Importing data

Top  Previous  Next

In addition to data transfers completed through the data transfer wizard or when a project is created, you can import specific data from csv and civil pro specific cpx files. This section explains the different formats.

 

Data imported into civil pro can be of three types.

1.Flat table like data from any program such as a csv or tabular data from the clipboard
2.Hierarchical data previously exported from civil pro
3.An entire project - either another CP8 project, or from a CP7 project

 

CSV (comma separated values)

Flat table like data (csv) can be imported using the Import Wizard and can be from any program such as excel or Expert Estimate that create this type of data. You can also copy data onto the clipboard (ctrl+c) from a program like excel.

 

Hierarchical data

Hierarchical data is produced from civil pro for copying between projects and is used when data contains multiple levels - for example an ITP which has to record a list of ITPs, the line items for each ITP and then the testing for each line item. Imports of this nature do not occur very often and are described in the registers in which they are found i.e. ITP register, Test Method register.

 

Importing from other databases

Importing between projects is relatively simple but there are a couple of tricks. Please refer to the sections on Backup and Restore and Transferring project data in the System Administration topic.