Import File Example

An import file can an activity file, resource file, or a combination of both.

This is an example of an activity import file.

1.1.1,1600,01,161,This is act 1,12/15/09,02/03/02

1.1.1,1600,02,162,This is act 2,02/09/02,03/30/0

This is an example of a resource file.

161,ENG1,156,12/15/09,12/31/09

161,ENG1,200,01/01/02,01/31/02

161,ENG1,10,02/01/02,02/03/02

161,ENG2,35,12/15/09,12/31/09

161,ENG2,40,01/01/02,01/15/02

162,TECH,206,02/01/02,02/28/02

162,TECH,290,03/01/02,03/30/02

162,MATL,10000,02/01/02,02/01/02

This is an example of a combined activity/resource import file.

1.1.1.1,1400,01,1.1.1.1.01,06/01/2007,07/12/2007,LABOR,100,10000

1.1.1.1,1400,02,1.1.1.1.02,06/01/2007,10/13/2007,MAT,0,100000

1.1.1.2,1420,01,1.1.1.2.01,09/01/2007,12/23/2007,LABOR,50,5000

If you are loading a forecast, you are loading forecast dates and forecasted resource requirements. Therefore, the resource requirements should not be before the status date. For example, if the project status date was 12/31/09, the following is an example of the resource import file:

161,ENG1,200,01/01/02,01/31/02

161,ENG1,10,02/01/02,02/03/02

161,ENG2,40,01/01/02,01/15/02

162,TECH,206,02/01/02,02/28/02

162,TECH,290,03/01/02,03/30/02

162,MATL,10000,02/01/02,02/01/02

Note: To easily create an import file for the ancillary data you want to import into Cobra, you can generate the corresponding export report to see a sample CSV file for import. If you save the data as a CSV file, you can select the File contains a header row check box on the Ancillary File Field Mapper page and just import the file.