Changes

Jump to: navigation, search

Auto Loader

334 bytes removed, 4 September
no edit summary
* If the file has special characters, convert encoding to UTF-8.
* If columns has a number sign after the comma, always add double quotes to avoid data problem when processing the file.<br /><br />'''NOTE:'''* The number of rows in the selected file cannot exceed 100,000 * The number of columns in the selected file cannot exceed 100 * File should not contain a cell that exceeds the character limit of 32,000 
==Configuration - Essentials==
1. Essential settings in the '''General Tab'''
  ** Set the '''Loader Name'''   
* Select the '''Folder Type''': [[SmartFolders Overview|SmartFolder]] or [[SmartFolders_Overview#Configuration_Folders|Configuration Folder]]
* Click the Folder Lookup button and select the folder assigned to this autoloader
*
* Select the '''File Type'''
*
* Select the '''File Encoding'''
*
* Define the '''Record Type''' for this autoloader
*
* Select '''Item''' of the '''Record Type'''
*
* Activate the autoloader
*
 
 
2. Essential settings in the '''File Layout Tab'''
** Select the '''Number of Columns''' - based on the file sample to be uploaded into this autoloader    ** '''Ignore Lines''' should be 1, if the file has header in row 1    ** Select '''Field Delimiter''' from the dropdown list    ** Define the column mapping based on the field columns of the file to the '''Record Type''' fields from the dropdown      .<div style='margin-left: 50px;'br />Note that you can toggle the identifier if the file has a unique identifier.This will ensure integrity of the data being added/updated.</div>
3. Essential settings in the '''Process Tab'''
** Go to the '''Create / Update Options''' section and select '''Create / Update Behaviour''' for the autoloader.      <div style='margin-left: 50px;'br />Once all three tabs have been configured, click on '''SAVE''' button.The autoloader is now ready to process the file that will be fed to the [[SmartFolders Overview|SmartFolder]] or [[SmartFolders_Overview#Configuration_Folders|Configuration Folder]] selected for this autoloader.</div>
==Configuration - Advanced==
Smartstaff
6
edits

Navigation menu