You can send data in the following file formats using Primavera Gateway:
- CSV
- Excel (XSL or XSLX)
- XML
The file content is processed in Gateway using parsers and generators during a synchronization.
Rules for Creating CSV and Excel Files
CSV and Excel files that are to be consumed by Primavera Gateway must be specially formatted to contain specific indicators. Indicators are containers of the data represented in the CSV or Excel file. Parsers and generators in Gateway use these indicators as markers to read and write the data contained in the file.
Use the following indicators in a CSV and Excel (XSL or XSLX) files for Gateway:
Row Indicator | Indicator Name | Description | Required? |
|---|---|---|---|
ON | Object | Use the ON indicator to indicate the name of the provider object in the CSV or Excel file. For example, Project, Role, or Resource. The first column of the spreadsheet must always contain the indicators. An ON row is succeeded by a FH row in a CSV or Excel file. A parser or generator will search for a row labeled 'ON' to begin reading or generating a file. Note: A CSV or Excel file must contain at least one object row (ON). | Yes if you use the Default Parser or Default Generator in the synchronization. No if you use any other parser or generator in the synchronization. |
FH | Field Header | Use the FH Indicator to specify the fields contained in a provider object. Only one FH row can be included for each provider object. A FH row is preceded by an ON row, and succeeded by a DR in a CSV or Excel file. For example, a Role object containing two fields, ID and Name. | Yes |
DR | Data Row | Use the DR indicator to specify a data row for the fields of a provider object. You can include more than one data row for a provider object to specify multiple values for each field. | Yes |
Use the following indicator to include file attachments to a provider object. | |||
AR | Attachment Row | Use the AR indicator to include a file attachment with a provider object. Each row supports an attachment. Multiple attachments can be included with a provider object.
| No |
For more details, see the following sections to create data files that can be consumed by Gateway.