Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
outlinetrue
stylenone

Imports

PCR-360 allows Users to Import information into the application as needed. The bottom of this page has a list of all the Import types that can be used. Individual pages handle the specific logic of any given Import. This page goes over the more general information related to Imports.

...

  • 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_IMPORT_CONCATENATOR should be used as a concatenator.
    • The Default Value = " > ".
  • To create any other Hierarchy Path, the value stored in the configuration option HIERARCHYPATH_CONCATENATOR should be used as a concatenator.
    • The Default Value = " > ".
  • When running a Charge Import don't:
  • When running a Cabling Import don't:

...