The PreProcessing Tab provides a way to setup processes that should happen before the import process begins. These processes can take the form of a file download, or running a script. This allows you to download files to import and then move them to a new location before importing.
When a file is downloaded it is automatically renamed to match the name of the file specified on the Data Source tab. Therefore the file download will typically be used with the Text or XML data source type
File Download |
|
This section allows you to make a call to an external file storage location and download a file |
|
Download Source |
The file storage service that contains the file. Supports Amazon S3 and FTP. |
Delete Source File after Download |
Instructs the source location to delete the file after the download is complete. |
Property Name |
Displays a list of properties that need to be filled out to connect to the Download Source. The list displayed is specific to the selected Download Source. |
External Process(es) |
|
This section indicates any executables or batch files to be run. |
|
Name |
Enter a name to identify the process. |
Order |
If there is more than one process enter a number for the order that each process should occur in. |
Program * |
Enter the path to the .exe or .bat file that you will run. Note: The path should not include " ". |
Arguments * |
Enter any parameters that will be passed to the program. |
Note: File Downloads occur before External Processes.
Note: Failed pre-processes will cause the import to fail.
* Supports using formulas. Must be enclosed in [[ ]]. Example: [[+GETDATE()]]