Changes

Jump to: navigation, search

Auto Loader

1,003 bytes added, 13:33, 20 June 2013
no edit summary
If the selected Record type is a [[UTA]] then the user is required to populate an additional Level field. The possible options here can include Level 1, Level 2, Level 3 and Transctions.
 
:[[Image:Auto5.png]]
If the selected Record type is a [[UTA]] and the selected Level is Transaction then the user is required to populate an additional drop-down field reflecting all the levels that the transactions are enabled against.
:[[Image:Auto5Auto5b.png]]
==Additional Settings==
===File Layout - Defining the number of columns===
The File Layout section is used to determine the number of columns in the file, the delimiter between the columns and the use of a '''HTML table''' to display the data.
:[[Image:Auto8.png]]
* Number of Column - The number of columns you select is used to define the number of columns in the upload file, and the number of fields that can be updated in the database.:* The maximum number of fields that can be updated is 50 100 fields in a single file.:* If more than 50 100 fields are required, then you will need to create two upload files.* Ignore Lines - You can specify the number of rows to ignore from the beginning of the file. This can be used to ignore column headers, if they exist as the first row in any file.* Field Delimiter - drop-down list showing the delimiter options used to separate different values in the file into different columns. * Use HTML Table - An HTML table is very useful where imported data contains multiple records and a single record set of fields exists within SmartSimple. For example, if you wished to import multiple lines of sales information into a single text box field you would enable the HTML table feature and then map all the fields into a single field indicating the column and row delimiters.* Column Delimiter - free text field to allow entry of any delimiters required to separate different values in the file into different columns. * Row Delimiter - free text field to allow entry of any delimiters required to separate different values in the file into different rows.   
===Defining the Column Mapping===
Smartstaff, administrator
4,478
edits

Navigation menu