P6 can import Excel files in either .xls or .xlsx format. The import file must be in the correct format to be imported successfully. The following must be true for the file to be imported:
- Each data type must be contained in a separate worksheet in the file.
- The worksheets must contain the names of the data types exactly as they appear in the tabs on the Enterprise Data page. Worksheets which do not match the names of data types in the Enterprise Data page will not be imported.
- The first two rows of each worksheet in the file must contain the database column name and human readable column name of each of the data attributes to be imported.
- Duplicate rows will overwrite earlier rows when you import the file. Rows are identified by the primary keys for the data type. If two rows have the same data in the primary key fields they are duplicate rows.
- It is possible for a row to have multiple data errors, however import of a row will fail at the first data error encountered on a row. The results column explains the cause of the import failure so that you can correct the data and import the file again. It might be necessary to import a file several times before a row with multiple data errors can be added or updated.
Note: Oracle recommends that you create an import file by exporting the relevant data types first. If you intend to import data frequently, it is good practice to create an export file containing all data data types and protect the first two rows on each sheet and the worksheet names before populating the file with the data to be imported.