Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

SQL Processing Details (SQL)

Use the information in this section to know more about the processing details that Import Items use for SQL databases.

Files Necessary to Run the Import Items Preprocessor

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

File Description
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
Note: 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.

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.