Import

You can import your programme if your Tasks already exist outside of Aphex.

There are two supported file types:

.xml

.csv (or copy + paste)

When it can be imported

Any time

During Project setup only

Task Name

✔️

✔️

Start / End Dates

✔️

✔️

Packages

-

✔️

WBS Codes

✔️

-

Subcontractor

✔️

✔️

Calendars

✔️

-

Shift

Assigned based on the activity's start / end time in P6

✔️

Relationship Links

✔️

-

Owner

✔️

-

Location

✔️

-

Activity ID

✔️

-

.xml

Your import file must be exported from Primavera P6, Microsoft Project or Asta PowerProject in order to be in the correct format for import.

Existing Tasks

Once a Task has been imported, it's treated as the most up-to-date version, meaning that if it is imported again, the Task won't be overwritten.

Only new Tasks are included in imports - imported Tasks that match an external ID that already exists within the plan are ignored.

Importing Tasks from Microsoft Project follows a similar logic, however the external ID is generated differently as Microsoft Project files tend to follow the same ID structure:

external id = <projectname>_ID

This allows multiple different Microsoft Project files to be imported as each should have a different set of IDs.

When new Tasks are imported, the system will check against existing tasks to find any predecessors.

Project Assets

You can include Location, Owner and Subcontractor in your .xml import.

If the imported Project Asset already exists within the Project, imported Tasks will be assigned to the existing asset.

If the imported Project Asset doesn’t exist in the Project, it will be created and assigned to the relevant Tasks.

You can import Owners of Tasks so that imported tasks are preassigned to an Owner.

If the email address that owns an imported Task is not a User on the Project, the User will be added to the Project as a user and will receive an email informing them of this.

Shift

Tasks imported from P6 will be assigned the shift Day, Night, or All based on the start and finish time of the Task.

Shift

Task planned to start and finish between

Day

06:00:00 - 17:59:00

Night

18:00:00 - 05:59:00

All

06:00:00 - 17:59:00
AND

18:00:00 - 05:59:00

.csv

Your import file can be exported from spreadsheet programmes that support .csv exports, including Microsoft Excel and Google Sheets.

Tasks imported from a CSV file will be automatically assigned to the Project default calendar.

Data from spreadsheets can also be copy and pasted into the

Export

You can export data from a Published Version to input the data into a Project management/analysis tool.

Download Data will download a compressed file containing two CSV files, one contains your Project’s tasks, the other contains delay data.

Did this answer your question?