Format File for Import – CivilPro

In CivilPro Cloud, there is an option to import data in Excel files (from Clipboard or as CSV files). However, only specific data can be imported. CivilPro Cloud can only identify and capture data in your file that aligns with the importable values in its system.

Related Link:

How to create a CSV file

The following table outlines what can be imported:

Table A

Available For:	Importable Values	Number of Values
Work Types	Work Type (Codes) Description	2
Area Codes	Area Codes Description	2
Control Lines	Control Lines (Codes) Description	2
Inspection Test Plan (ITP)	Description Clause Responsibility Records Inspection Method	5
Schedule Items	Schedule Number Description Quantity Scheduled Unit DJC Rate Sell Rate	6

Hence, it is important that you format your files before importing to align your data correctly in CivilPro Cloud. Use the following points as your guide when formatting:

Include only the data that can be imported (hierarchical data cannot be imported)
No merged or split cells
No empty cells between rows or columns
Headings can be included but these can be added later in CivilPro if not imported
Align the Headings/Columns in your file with the importable values shown in Table A
Most columns have character limits, for example, "Units" columns typically have a 10-character limit (including space). "Description" columns tend to have more character allowance but you should always include the most relevant information only. If your values are too long, you'll get an error message when importing your file.

Below are a few examples of how the data in your Excel files should look and their corresponding values as they appeared in CivilPro Cloud:

Example 1 : Area Code

Excel