Autoloader File Preparation

This section of the Autoloader settings page allows for manipulation of the data prior to the Autoloader actually loading the data onto the system.

Use Cases

• Using Merge Control, you can merge two or more columns in your csv upload file so that their data is loaded into one SmartSimple field.
• Using Constant, you can set a constant value to be uploaded to a specific field for all records. You can also use this feature with an autonumber field to add sequential autonumbers to added or updated records.

Constant

Syntax

When a Merge Control or Constant is defined, once the import file is uploaded to a SmartFolder, the file will be altered according to the rules established in the Merge Control or Constant settings and a new upload file will be created with the prefix "mod_".

Both the original upload file and the file modified by the Autoloader File Preparation processes will be available for review in the SmartFolder.

See Also

• Autoloader