In this article, we will review how to export/import Projects, Programs, Portfolios, and Resources to/from the CSV file.
We will review the import option on the example of Projects, but the process is the same for Programs/Portfolios/Resources.
The Projects will be exported to the CSV file format and then this file can be edited and used to import the information from the CSV file to the Projects page.
This functionality is available from the table and timeline view of the Projects page.
To export the Projects from the Projects page perform the following:
1. Open the Projects page in the timeline or table view.
2. Select the Projects that you need to export to the CSV file.
3. Select the Export to CSV option from the actions bar.
If you need to include more fields in the CSV file, it is required to add these fields to the Projects page view first.
4. Open the CSV file and check or edit the information there as required.
If editing the values in the CSV file, it is required to preserve the format used in the columns, as a different format is not supported. For example, if the value is provided as 'At Risk' and will be changed to 'AT RISK' or 'at risk', the changes will not be applied. If the auto-calculation of Statuses is enabled for your PPM Express tenant, the statuses cannot be edited from the CSV file.
When importing dates from the CSV file, the format can be according to the region selected on the Tenant Settings page or an international format (YYYY-MM-DD).
The Projects are found by UIDs and updated accordingly. If the UID is deleted from the CSV file or updated there, new Projects will be created in PPM Express when importing data from this CSV file. If new Projects are created in the CSV file, the UID field should be left empty, it will be added automatically on importing new Projects to PPM Express.
Some fields are read-only and cannot be edited via the CSV file.
If any invalid data is provided in the CSV file, it will be ignored when importing to PPM Express.
5. Open the Projects page to import these Projects. Click Actions => Import from CSV.
6. Select the required file from your PC and click Open.
7. The Projects will be imported to the Projects page at once and the information will be updated accordingly.