In addition, you’ll have to select the character encoding type: UTF-16 or UTF-8. The data source, which is the data you’d like to write to the data file, can be a field or a variable. Now that you know how to create and open a data file let’s explore writing to one. There’s a limit of 25 data files that can be opened at the same time, and if you attempt to open more than that, you’ll get an error code of 2: Memory error. If you try to open a file that’s already been opened, you’ll get an error code of 300: File is in use. You can also use a new function, Get(OpenDataFileInfo) to find the File IDs if you did not store them in a field or variable. You will need this value to use some of the other script steps, so don’t forget to set it to something you can reference later (field or variable). The target is where you would like to store the File ID of the data file. If you do not enter a path or you enter an invalid path, you will receive an error code of 100: file is missing. Files created Open Data Fileīefore you can start writing to a file you’ve created (or one that already exists), you must first open the file with the script step “Open Data File.” The file will be considered opened until you close it with the “Close Data File” script step (or quit FMP or close down your computer). I was pleasantly surprised to find that they all were created successfully.
What type of files can you create? The help doesn’t specify, so I tested the following: If the file already exists, FileMaker will overwrite the original. If you leave “create folders” to off while missing folders, you will receive an error code of 100: file is missing. If your file path is missing folders, and you set “create folders” to on, the script step will create the missing folders. There is another option of “create folders,” which defaults to off. If you leave the file path blank, it will return error code 100: file is missing.
When setting up options for this step, you must specify the file path with the specific file dialog.
This means that this script step works hand-in-hand with several other script steps that I’ll explore further along in this post. “Creates an empty, closed data file, to then open with the Open Data File script step and add data to using the Write to Data File script step.” Create Data FileįileMaker’s help documentation describes this script step as follows:
To test out each script step as you go through this blog post, please download our companion sample file. Let’s explore each one and see how to use them! One of Filemaker 18’s most exciting new features is the addition of new data file manipulation scripts steps.
0 kommentar(er)
