PROCESSING DETAILS (SQL)

Files Necessary to Run the Import Items Preprocessor

The following custom files must be installed and accessible to run the Import Items Preprocessor:

CSTPOINT.EXE	Costpoint executable
CPPMGRSV.EXE	Costpoint Process Server executable
AOPITEM.EXE	Application executable
AOPITEM.MSS	You must apply SQL Server stored procedures before you can execute the Import Items preprocessor.
AOPITEM.QRP	Report Template

If your Costpoint system is configured on a Microsoft SQL Server database platform, the Import Items preprocessor supports only the (PT2) Part file layout.

Item Preprocessor tables

The following Costpoint tables are maintained by this preprocessor:

Table	Table Name	Definition
ITEM	Item	Stores parts, services, and goods.
PART	Part	Used to create parts and assign various characteristics that are individual to each part. Many of these characteristics act as defaults in other modules as this part is used. The Comments tab and the Units of Measure and U/M Conversions subtasks are available on the Manage Parts screen, and can be assigned to this part.
ITEM_UM	Item Unit of Measure	A cross-reference between parts, unit of measure, and system unit of measure type that indicates the applicable units of measure for a given part and their use. Three of these cross-references exist for each part (one each for Inventory, Ordering, and Selling.)

Input File Details

The Part (PT2) input file layout is documented in a table (click the link below) to illustrate the data field structure and column updates that occur after this preprocessor is successfully executed. You can process only one input file (with multiple lines) at a time. In the Part (PT2) input file layout, each column lists:

Input File Field — This column displays the name of the Costpoint field for which data is processed.
Costpoint Column — This column displays the functional field name within Costpoint for which data is processed.
Column Type and Max Length — This column displays the allowable data type and maximum character length for the Input File Field.
Starting Position — This field displays the input file field's starting position number for the first character in a string of data in a fixed-length input file.
Ending Position — This field displays the input file field's ending position number for the last character in a string of data in a fixed-length input file. The Ending Position number is the Starting Position number plus the maximum length for a given input file field. This is the last character of data that can exist before the next input file field (that is, the next starting position number) is populated.
Required — This field indicates whether or not the input file field must be populated on the input file.
Values, Defaults, and Notes — This field indicates any miscellaneous processing data for the input file field.

Input file fields that are defined as decimals in Costpoint must include the decimal point in the data being processed. Otherwise, integer (whole) numbers are assumed.

Input file fields that are defined as dates in Costpoint must be 10 characters and must be in YYYY-MM-DD format (a four-character year (including century), month (01-12) and day (01-31)). You must separate the year, month, and day by hyphens (-).

Timestamp fields in Costpoint must be 19 characters and in YYYY-MM-DD-hh.mm.ss format (a four-character year (including century), month (01-12), day (01-31), hour (00-24), minute (00-59) and second (00-59)). You must separate the year, month and day by hyphens (-), there must be another hyphen following day and hour, and minutes and seconds must be separated by periods (.). Time can be omitted.

PART (PT2)