File Format for Importing Apportionment Mapping
The CSV file must contain comma separate columns and optionally can have quotes around string values.
The first row can be a column header, which is optional. If you do use one, it needs to follow the order in the following table:
Column | Column Name |
---|---|
1 | Target Project |
2 | Resource |
3 | Target CA1 |
4 | Target CA2 |
5 | Target CA3 |
6 | Target WP |
7 | Rate Set |
8 | Source Project |
9 | Source CA1 |
10 | Source CA2 |
11 | Source CA3 |
Different columns must be filled in depending on what you are importing. The following validations take place:
- If the specified project is a master project, the projects named in Column 1 (Target Project) and Column 8 (Source Project) must both exist as a subprojects of the specified master project.
- If the specified project is not a master project, the projects named in Column 1 (Target Project) and Column 8 (Source Project) must be the same as the name of the specified project.
- The resource in Column 2 must be a valid resource with apportionment defined in the resource file of the specified project.
- The data in Columns 3 - 6 (Target CA/WP) must exist in the target project if Column 3 is not
<Same As Source>. If Column 3 is
<Same As Source>, any data in Columns 4 - 6 is ignored.
Note: <Same As Source> is case sensitive.
- The data in Columns 9 - 11 (Source CA) must exist in the source project if Column 9 is not
<All>. If Column 9 is
<All>, any data in Columns 10 - 11 is ignored.
Note: <All> is case sensitive.
- The rate set in Column 7 is checked to see if it exists in the rate file for the specified project, but the data is imported anyway if not found.
Parent Topic: Data Import — Apportionment Mapping