Using Import to Update a Schedule Sheet
You can also use CSV, XML, and MPP files to update an existing sheet. Before you begin:
- You must have permission to import files. See Schedule Sheet permissions.
- For CSV or XML files, your administrator must first define the data mapping.
- To use the Activity Calendar from Microsoft Project, first create a calendar in Unifier with the same name as the external calendar.
- To import Resource Assignments from Microsoft Project, first add the same MPP resource types to the SYS Resource Type data set in Unifier. Oracle recommends using MPP standard resource types: Work, Material, and Cost.
To import CSV files:
- Open the schedule sheet.
- From the File menu, select Import, and then select From CSV. If a default mapping is not selected, the Select Data Mapping window opens.
- Select the data mapping you want to use for this import, and select OK.
- In the File Upload window, browse to select the file to upload.
- Select OK.
To import XML and MPP files:
- Open the schedule sheet.
- From the File menu, select Import, and then select From External Source. If a default mapping is not selected, the Select Data Mapping window opens.
- Use the table below to complete the fields in this window.
- Select OK.
- In the File Upload window, browse to select the file to upload.
- Select OK.
In this field: | Do this: |
---|---|
MPP | Data mapping is not required. Leave the Data Mapping field empty. |
MPP XML | Data mapping is required. Select the mapping you want to use. |
MPP activity calendar | Select Consider Activity Calendar. This requires an existing calendar with the same name. If an activity calendar is not imported and considered, the activity will use the existing calendar defined in the schedule sheet properties. |
MPP Resource assignments | Data mapping is not required. Leave the Data Mapping field empty. This requires a data set for the SYS Resource Type data element. Use MPP standard resource types: Work, Material, and Cost. Upon import, the system will soft-book these resource types. |
Last Published Thursday, October 9, 2025