The standard comma separated value import from a third-party package is made up of multiple record types within the file. There may be quotes around the alpha fields. The import program checks for quotes and, if found, removes them. Some fields may be cross-referenced to Viewpoint codes. All numeric fields should have no commas, and the decimal position is a floating decimal. The import will round the numeric to the precision defined in the data dictionary for each field. All fields will be formatted to the data dictionary specifications.

The record types will be as follows:

Each record type has a specific format for importing. To see a layout of each record type, click a link below.

• Record Type 1 – Item Record

• Record Type 2 – Phase Record

• Record Type 3 – Cost Type Record

• Record Type 4 – Subcontract Record

• Record Type 5 – Material Record

• Record Type 6 – Project Record

• Sample CSV Import