...
- The Import process CANNOT DELETE records.
- In a CSV Delimited file, the import always treats the number of possible columns as one one MORE than the number of commas separating values.
- For example, if there is a CSV line with three commas, possible values look like this: there will be 4 values. The numbering of the fields is Zero-Based, so the indexes will be: 0,1,2,3 ,4in 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 = " > ".
...