Difference between revisions of "Autoloader File Preparation"

From SmartWiki
Jump to: navigation, search
(Constant)
Line 16: Line 16:
  
  
When a ''Merge Control'' or ''Constant'' is defined,  
+
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_".
  
 
[[Image:AutoloaderModifiedUploadFile.png|link=|350px]]
 
[[Image:AutoloaderModifiedUploadFile.png|link=|350px]]
 +
 +
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==
 
==See Also==

Revision as of 09:45, 26 February 2014

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 merged into one SmartSimple field.
  • Using Constant,
AutoFilePreparation.png

Merge Control

Syntax

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_".

AutoloaderModifiedUploadFile.png

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