Page Comparison

Table of Contents
outline true style none

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.

...

To create a new Import, see the Importing Data into the system wiki page.

Notes

• 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 = " > ".

...

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:

...

1. If the Save to the database failed for an unexpected reason, the errors do not generate. The Import knows about that until it actually tries to do the Save can’t detect these errors until the save is attempted, which does not happen in Test mode.
2. User Defined Field (UDF) Import Save logic is done after the Save and is only done for non-test Imports. For this reason, UDF fields do not UPDATE or INSERT in test mode.

Here are few of the general errors that display if the Import process is stopped, causing a data rollback.

...

Errors that cause the import to Abort

If one of these errors occur, a Rollback will happen, which will undo any progress that was made before the problem.

• Value not present in lists table
• Error reading column using format mask
• Column defined as a number contains non-numeric data
• Column position not present in line
• Column index not present in line
• Database error
• SQL error
• Uploaded file is Empty

Related Pages

...

h6

Child pages (Children Display)
style
sort title