Ancillary File Field Mapper Page of the Integration Wizard
Use this page to define the order of the fields in the selected ancillary file.
The file field mapper displays the first 10 rows of data from the file you selected.
Defining the Field Order
Define the data element in each column by selecting values from the drop-down list on the first row of each column. If you want the imported file to contain a header row, select the File contains a header row check box. If the header in the file matches the field in Cobra, the column maps automatically when you select this option.
Additional fields can be mapped using the drop-down list. Select one of the following options:
- <Ignore>
- Control account field 1 prompt
- Control account field 2 prompt — This option is included only if this field is used in the imported file.
- Control account field 3 prompt — This option is included only if this field is used in the imported file.
- Work Package prompt
You can select a work package code without control account work package keys.
- Resource prompt
- Class
- Result — This is the actual word Result.
When you select Result, you must also select Result value and vice versa.
- Result value
- <Individual Results> — This option separately lists each result defined for the selected project based on the resource file information.
You can select either Result or multiple <Individual Results>. You cannot select both Result and <Individual Results>.
- Cost_date
- Project — This option is included only if the selected project is a master project.
- Code<prompt> — This option lists code prompts on the control account or work package depending on the level of actual costs defined.
With the exception of <Ignore>, you can select an option only once. A selected option is no longer available in subsequent columns.