Importing and Exporting Enterprise Data

You can import enterprise data to create and update your enterprise data dictionaries more efficiently.

Note

Oracle recommends always working from a recently exported copy of your enterprise data.

When you export your existing enterprise data, the resulting XLSX file includes a separate tab for each page of enterprise data page. You can modify or create new data in the spradsheet by modifying or adding to rows three and later. Be careful to follow the existing format of data in the spreadsheet.

To import enterprise data:

Click Administration.
On the Administration navigation bar, click Enterprise Data.
Click Import/Export Enterprise Data.
On the Export tab:
1. Select the types of enterprise data to export.
2. Click Export.
Your browser might require you to approve the download of the file.
Open the exported file and enter or update the data on rows three and later.
Note

Do not change or delete any of the data in rows one and two of each tab in the XLSX file.
Click Import/Export Enterprise Data.
On the Import tab:
1. In the File field, click Browse.
2. Select the types of enterprise data to import.
3. Click Import.

Tip

You can't delete enterprise data by importing an XLSX file.

The ability to import and export Enterprise data as described here, replaces previous import and export processes that relied on the P6 Professional SDK using a macro-enabled Excel file. Primavera SDK was a 32-bit technology and has not been supported since release 18.8. Many platforms (including Microsoft Excel) restrict macro use by default, to help protect your data against unintended macro activity. Therefore importing and exporting enterprise data using the method described here offers improved security over the use of the P6 Professional SDK tool.

Related Topics