Schedule an Import or Export
- Last updated
- Save as PDF
You must have administrator rights to access this feature.
These instructions are for customers with on-premise deployments only. Hosted customers have to contact Tech Support for help with this feature. Please have the format file path and data file path created before contacting Tech Support.
Automation Manager can be used to schedule an import or export to run at a specific interval via the Schedule an Import/Export automation template. Subscribe to the Integration Results notification through Notification Manager to receive error logs from your scheduled import.
View the job log on the Jobs tab in the Import/Export feature. Automated jobs can be found by selecting the Automated Job user from the User field.
Input Parameters
|
Property |
Description |
Example |
|---|---|---|
|
Job type |
The job type to be performed. Valid job types include:
|
FileImport |
|
Format file path |
The full path to the format file (imx). The file needs to be accessible to the application server |
C:\DataXChanger Specs\Water Backflows.imx |
|
Data file path |
The full path to the data file. This argument is only required when the job type is FileImport or FileExport. The file needs to be accessible to the Application server. |
c:\ DataXChanger Specs\ Water Backflows.csv |
|
Data file archive path |
The full path to a directory the data file is copied to on the Application server. This is an optional argument, so if it is not supplied, the service does not archive the data file. |
C:\DataXChangerArchive |
|
Notification frequency |
Defines when a notification should be sent. If an argument is not supplied, frequency defaults to FailureOnly. Valid frequencies are:
|
Always |
|
Delete data file |
This optional argument determines if the data file will be deleted after the command completes. |
true |
CSV files generated by an export that will be used for importing must use ANSI encoding.