...
To create a new Import, see the Importing Data into the system wiki page.
Notes
- The Import process CANNOT DELETE records.
- In a Delimited file, the import treats the number of columns as one MORE than the number of commas separating values.
- For example, if there is a CSV line with three commas, there will be 4 values. The numbering of the fields is Zero-Based, so the indexes will be: 0,1,2,3 in the field mapping or Conditional Logic.
- In a Fixed Width file, you will define the fields by Position and Length. The field positions are Zero-Based. So in a file where a field starts on the 1st character of a line, the Position is entered as 0. If the field starts on the 10th character, the Position is 9.
- To create a GLA Path, the value stored in the configuration option GLA_CONCATENATOR should be used as a concatenator.
- The Default Value = " > ".
- To create any Hierarchy Path, the value stored in the configuration option HIERARCHYPATH_CONCATENATOR should be used as a concatenator.
- The Default Value = " > ".
...
To assign a UDF value, you must know the Identifier name for the UDF. This is the value in the first column of the User Defined Fields grid.
For example, to assign the Rollover GLA Date from input field 4 in the GLA import, the assignment would look like this:
...