You can set the import order and use the Specify import order option, or perform this script step with the dialog box so the user can set new criteria, such as importing data as a new table. If the certificate cannot be verified and the Set Error Capture script step is set to On, this script step behaves as if the server were unavailable. If the certificate cannot be verified, users can choose to connect anyway or cancel to skip this script step. Verify SSL Certificates verifies the SSL certificate of the server specified in an HTTP request for XML data.Note When import source fields and target fields are mapped using matching names, field name matching is performed dynamically each time the script step is performed. See Setting the import action and mapping fields during import. Specify import order defines whether to add, update, or replace records in the current found set, and how source fields are mapped to target fields when this script step runs.Otherwise, the results may be inconsistent.
Note If you use the Import Records script step to import ODBC data that contains Unicode strings, your ODBC driver must support Unicode. SQL statements are limited to a maximum length of 256 K characters (512 KB). See Automating ODBC import using the Import Records script step.
Specify the data source name and location, the user ID and password (if any), and the SQL query to be executed. The XML and XSLT source may be a file, the result of an HTTP request, or a calculation that generates a file path or an HTTP request. In the Specify XML and XSL Options dialog box, choose the source of the XML data that you want to import, and choose an XSLT style sheet if you want to apply one prior to import. This option is not supported in FileMaker WebDirect and server-side scripts. See Importing a folder of files all at once and Creating file paths. FileMaker Pro Advanced will use the first path it locates as the folder to import. In the Folder of Files Import Options dialog box, choose the folder of image or text files that you want to import, or type the folder paths directly into the list. If you specify a file with a custom field delimiter in the Specify File dialog box, for File Type, choose Custom-Separated Values, and specify the field delimiter. However, if you use the the Specify import order option, you can choose any record to use as field names when importing from certain file formats indicated in Supported import/export file formats. If the First Row Option dialog box appears after you specify a data source, you can specify whether to use the first row as field names. FileMaker Pro Advanced will use the first path it locates as the file to import. In the Specify File dialog box, choose the file you want to import, or type file paths directly into the list.