# Master Schedule Import

{% hint style="info" %}
Project Admins or Members with Additional Permissions can run Master Schedule Imports.
{% endhint %}

Bring selected parts of your Master Schedule into Aphex using XER, XML, or MPP files from P6, Asta, or MS Project. Import only the activities your team needs - this helps seed the lookahead plan with the right level of detail or key Milestones - just enough for the team to breakdown, adjust and build from.&#x20;

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FWHGjuanVlmOHA4cZ8aYQ%2F1%20Grey.svg?alt=media&#x26;token=56471c5f-ac0f-4afb-9149-453a36097a85" alt="" data-size="line"> Upload your File

***

The first step is to upload your file.&#x20;

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2Fkn4nxdWFiIunW3oqUBYT%2FMS%20Import%20Upload%20File.svg?alt=media&#x26;token=1bb25333-91f7-42b9-8a2b-005484c5d08d" alt=""><figcaption></figcaption></figure>

#### To upload your XER, XML or MPP file:

* Click your Project Title in the top left&#x20;
* Select `Master Schedule Import` from the dropdown menu
* Click <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FLpgpV4iN2kYuHKZSisMX%2FImport%20Button.svg?alt=media&#x26;token=8153e0a0-a04a-43a9-b266-8d00061f234e" alt="" data-size="line">
* Upload your File&#x20;

<details>

<summary>Prepare your file before exporting</summary>

### Filter (Optional) <a href="#h_b013291c68" id="h_b013291c68"></a>

UDFs allow you to filter to the specific data you want to import into Aphex:

* In your master schedule, create a User Defined Field (you might want to name this something straightforward: Aphex Filter)
* In this UDF assign a consistent value against the activities you would like to import and ones you would not (this could simply be "Yes" and "No")

### Project Assets (Optional) <a href="#h_e1474d1c06" id="h_e1474d1c06"></a>

Save time during your import by including Owners and Project Assets in your import file.

You can add the email address of the user’s you’d like to assign imported work to automatically, and the subcontractor and location of each task.

* Create a UDF for each attribute (i.e. Subcontractor, Location and Owner) you wish to pre-populate.
* Name each UDF something memorable, like “Aphex Subcontractor”.
* In each UDF (eg. Subcontractor or Location), insert the field (Subcontractor, location etc.) for each activity. This should be consistent with the name in your Aphex project (if not, Aphex will create a new one)
* In the Owner UDF, insert the email address of the activity’s owner. Check that this matches the email address the team member uses for Aphex.\
  If not, the address entered will receive an invite to join the project.

</details>

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2Fx4scw3mIcnyLsn8g8MmY%2F2%20Grey.svg?alt=media&#x26;token=f6db6b12-c9fd-4d08-bae0-e141912069da" alt="" data-size="line"> Filter your Import Scope

***

Choose exactly which Tasks to bring into Aphex. Use a custom field (like a UDF in P6) to flag only the relevant Tasks you want to import; for example, bringing in Construction activities while skipping Design or Procurement.

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FT7ngqwQvmJOhiUnsDHoG%2FMS%20Import%20Filter.svg?alt=media&#x26;token=c2593595-02ba-48e7-8e3d-0af5018e7243" alt=""><figcaption></figcaption></figure>

#### To filter what Tasks are imported into Aphex:

* Click the `Column` dropdown and select the UDF column you want to filter by
* Click the `Value` dropdown and choose the value you want to import
* Click <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line">
* You can also skip this step by leaving both dropdowns blank and clicking <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line">

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2Fz0xFokg3mMNUa5YFeFPq%2F3%20Grey.svg?alt=media&#x26;token=8c7ad95f-9887-4530-8006-d8b807c108da" alt="" data-size="line"> Select your Date Range

***

Importing your schedule in smaller timeframes helps keep things tidy. Most projects avoid bringing in the entire long-range plan at once. By importing just what's needed for the next stage, then running regular imports (e.g. monthly) to add the next few weeks as the project moves forward, you give the team relevant, up to date data they can build from.

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FwI06hV54QTEc58oSarlJ%2FMS%20Date%20Range.svg?alt=media&#x26;token=b77a1e34-ef29-4c8f-bca5-1298bcce9452" alt=""><figcaption></figcaption></figure>

#### To select a Date Range

* Select from `Next 4 Weeks`, `Next 12 Weeks`, `All Future`, `All Past and Future`
* Click <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line">

<details>

<summary>Rules for New vs Existing Tasks</summary>

* Only Tasks that match your chosen filter and fall within the selected date range will be considered for import.
* You’ll see a count of how many new Tasks will be imported, based on your selection.
* Aphex will only import Tasks that don’t already exist in the project - we identify matches by Activity ID (mapped to Aphex External ID)
*
* If a Task has already been imported before (based on its Activity ID), it will be skipped - even if it’s since been updated in the source tool.
* Imported Tasks are treated as the source of truth from the time they’re brought into Aphex - they won’t be overridden or replaced by future imports.

</details>

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F8spmtZY3piARidsDCwrR%2F4%20Grey.svg?alt=media&#x26;token=355fe092-0b22-4c78-aa59-ebf7e6706f03" alt="" data-size="line"> Smart Checks for Unsupported Data & Variance Detection

***

To keep Aphex simple & intuitive, some Master Schedule features aren’t supported. During import, you’ll be prompted to make smart decisions about how to handle things like actual dates, or LoE / WBS Summary Bars that don’t translate 1:1. This helps ensure Tasks still land on the dates they’re supposed to.

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FKC0Vw3IJo7oMW0vQ1peH%2FMS%20Smart%20Check.svg?alt=media&#x26;token=21bf4890-6e40-41eb-8ce2-cb9ef2d25bb5" alt=""><figcaption></figcaption></figure>

{% tabs %}
{% tab title="1" %}

### Check Unsupported Task Types <a href="#check-unsupported-task-types" id="check-unsupported-task-types"></a>

If your Import file contains **WBS Summaries** or **Level of Effort (LoE) Tasks**, you can choose how to handle these tasks.

For **WBS Summaries**, you can choose to:

* Ignore them from the import so they will be excluded.
* Import as Tasks. If imported, WBS summaries will convert to Task Dependant types.

For **Level of Effort (LoE) Tasks** you can select from:

* Ignore all LoE tasks and these will not be imported (this is the recommended option)
* Import LoE tasks as task dependant types without links
* Import LoE tasks as task dependant types with links - Selecting this option may cause variance in your import

Once you've made your selection, select <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line"> to move to the next step
{% endtab %}

{% tab title="2" %}

### Check Driving Predecessors

There may be some Tasks that are being driven by Tasks outside of your import dates. This can sometimes result in variance. The decisions for this step include:

For **Driving Predecessor Tasks**, you can choose to:

* Add missing Tasks to the import scope (this is the recommended option)
* Remove non-driving Links between selected Tasks.
* Do nothing

For **Driving Predecessors Level of Effort Tasks** you can select from:

* Remove non-driving Links between selected Tasks (this is the recommended option)
* Add missing Tasks to the import scope
* Do nothing

Once you've made your selection, select <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line"> to move to the next step
{% endtab %}

{% tab title="3" %}

### Handle Actual Dates

Aphex uses Task Status to define a Task state & scheduling behaviour. Decide how you would like to handle tasks with Actual Dates.

For **Actual Starts**, you can choose to:

* Import without Predecessor Links (this is the recommended option)
* Import with Predecessor Links

For **Actual Finishes** you can select from:

* Set Task Status to Done (this is the recommended option)
* Do nothing

Once you've made your selection, select <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line"> to move to the next step
{% endtab %}
{% endtabs %}

{% hint style="info" %}
Please note that you will only see the steps that apply to your Import. If your Import doesn't contain Unsupported Task Types, Driving Predecessors, Actual Dates or Milestones, it will skip these steps.
{% endhint %}

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F9OJodh5gXwsZtz47NemJ%2F5%20Grey.svg?alt=media&#x26;token=ef387f89-206c-4bb3-8e65-95f2165dd70b" alt="" data-size="line"> Automatically set Milestone Target Dates

***

Milestones in your file will always be imported as Milestones in Aphex. You can also choose to set the imported Milestone date as a Target Date - this gives you a stable benchmark to compare against, so you can easily see how the Milestones in the short-term plan are tracking against your baseline or contract dates.

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FmGRv5zxzFcqF8SImUsZ1%2FMS%20Milestones.svg?alt=media&#x26;token=4f7dbf66-cdb3-4c38-b6f8-27b672a1613c" alt=""><figcaption></figcaption></figure>

#### Make a selection from:

* Set Milestone Target Date from the imported Dates
* Do nothing
* Click <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2F3x2epq8PMWfTNDMxuBN0%2FContinue%20Button.svg?alt=media&#x26;token=04aae1a2-2d05-479b-9aa4-6382534b741e" alt="" data-size="line">

<details>

<summary>Target Date Creation</summary>

* All Milestones in your file will be created as Milestones in Aphex.
* Target Dates are automatically set to the Milestone’s end date on import. You can update these later if needed.
* Aphex doesn’t support zero-duration tasks; so Milestones are converted to one-day activities.
* If a one-day duration is applied, Aphex will automatically add a -1 day lag to any successor links to prevent introducing variance.

</details>

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FDD13NaFDhZVJGI9HW3BH%2F6%20Grey.svg?alt=media&#x26;token=0d72ae8c-adfc-4148-a943-29d4d789c07d" alt="" data-size="line"> Bring in your WBS & Other Properties

***

Map the right data across. Task names, logic, and calendars come through automatically, but you can also import WBS structure, assign Owners, Notes, Locations, or Subcontractors based on your UDFs, and bring over key metadata that helps delivery teams plan faster.

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2Fj1lnPuTCe4RPsUGHd3f8%2FMS%20Mapping%20Fields.svg?alt=media&#x26;token=331c5393-bb76-4e7d-8075-e8bd113c5a36" alt=""><figcaption></figcaption></figure>

#### Map Folders

* To import your current WBS into your Project's Folder tree, select the `WBS` option from the `Folder Code` drop-down list.

#### Map Other Aphex Properties

* Additionally, you can also import `Subcontractor`, `Location`, `Owner` and `Notes`, if you've predefined these in your source tool before exporting.

<details>

<summary>Asset Creation &#x26; Mapping Rules</summary>

* Only data associated with activities you are importing will be included. i.e Folder codes unrelated to any imported activities will not be brought into Aphex.
* If a Folder code already exists in the project, imported activities with that code will be grouped into the existing Folder, even if the Folder names don’t match.
* If an Asset (like a Subcontractor or Owner) already exists with an exact name match, the imported tasks will be assigned to it. Otherwise, a new Asset will be created.
* The Owner field must contain email addresses. If the email matches an existing user in the project, the task will be assigned to them. If not, they’ll be invited as a new user.

</details>

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FaY9e19mbVITjdOtZPHYw%2F7%20Grey.svg?alt=media&#x26;token=77d2a27f-599c-4fd6-a287-e074c5a9b475" alt="" data-size="line"> Complete & Review your Import

***

This is your final review before Tasks are imported into the Project. You'll see a summary of what's about to be created, including Task counts & any new assets. If any changes were made during the process, you can download a CSV to review the modifications. Nothing has been created yet - confirm when you're ready.

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2Fk1LgGhJf8t9oyKIcFOTc%2FMS%20Review.svg?alt=media&#x26;token=546e126b-6aba-478b-9033-57e565b814ae" alt=""><figcaption></figcaption></figure>

#### To complete the import

* Review the data you're importing
* Download the skipped tasks, folders or modifications CSV
* Select <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FByGZBVazWPey73xbAQTy%2FFinish%20Import.svg?alt=media&#x26;token=c62ba17d-1398-4a40-b556-856ba07d883e" alt="" data-size="line">

<details>

<summary>What Aphex Creates Automatically</summary>

* **Calendars** are created if a Task uses a calendar that doesn’t already exist in the project.
  * This includes all custom working calendars, with their non-working days, RDOs, and exception rules (e.g. site shutdowns, public holidays).
  * If a calendar with the same name already exists in the Aphex project, imported Tasks will be assigned to the existing calendar instead.
* **Relationship links** between Tasks in your import scope are created automatically.
  * If both linked Tasks are imported at the same time, the relationship is created during import.
  * If the successor is imported later, Aphex will automatically stitch the existing predecessor and the newly imported successor back together once both Tasks exist.
* **Shifts** are assigned to every Tasks.
  * `Day Shift` is assigned by default.
  * Depending on task timing, Aphex may assign `All Shift` or `Night Shift` automatically.
* **External IDs** are generated automatically:
  * If **Primavera P6** is the source, the Activity ID becomes the `External ID`.
  * If **Microsoft Project** is the source, the `External ID` is built from the *Project Name + ID*.

</details>

<details>

<summary>Skipped &#x26; Modified CSV Format</summary>

**Key columns in both files typically include**:

* `ID`
* `Name`
* `Task Type`
*
* `Modification Reason` (for Modified):&#x20;
  * Why the task was changed (e.g., "Task type changed", "Links removed", "Status changed to Done", "Target Date set")
* Skipped Reason (for Skipped):&#x20;
  * Why the task was skipped (e.g., "LoE Tasks Skipped", "WBS Summary Skipped")

Folders Skipped CSV:&#x20;

* There is also a report for skipped folders, with folder-level details, e.g., folder code, name, and reason for skipping⁠

</details>

## <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FVWtN8XrhLrWNiwd7MHas%2F8%20Grey.svg?alt=media&#x26;token=9d8bb709-fa72-4661-848c-3cbcecead2c8" alt="" data-size="line"> Add Imported Tasks to the Plan

***

Before your newly imported work appears on the Gantt, your next step is to distribute tasks to the team. Then, once tasks have been assigned to an owner, the user will be notified that they have newly imported work waiting for them to add to the plan.

{% stepper %}
{% step %}

### Assign Ownership

<figure><img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2Fc14rBXC2A7cNzg4tigRH%2FMS%20Import%20Backlog%20Unassigned.svg?alt=media&#x26;token=b5f617e0-e0fc-4711-a23e-add9f4dd9f4f" alt=""><figcaption></figcaption></figure>

#### Here's how to allocate activities to the users responsible:

* Click your Project Title
* Click `Master Schedule Imports`, then navigate to the `Project Data` page using the side-menu
* Open the `Unassigned` tab
* Select an owner for each task with the drop-down menu
* Click <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FacYlxAtN11YYLyOnjDit%2FMove%20to%20Backlog%20Button.svg?alt=media&#x26;token=8d2d9489-f0e9-4842-ab13-fd201f87da0b" alt="" data-size="line">
  {% endstep %}

{% step %}

### Add Tasks to the Plan

If you're a user who has been assigned new tasks from an import, they'll appear in your Backlog. All you need to do is pull them onto the Gantt.

#### To add your Tasks to the Plan:

* Click your Project Title
* Click `Master Schedule Imports`, then navigate to the `Project Data` page using the side-menu
* Click <img src="https://2273109354-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLu0mYklsCTm7XQm3ZGqv%2Fuploads%2FPqHBYvbwIpS9naB5laWW%2FMove%20to%20Gantt%20Button.svg?alt=media&#x26;token=52e030e2-4a99-41ef-ba50-a23efde14155" alt="" data-size="line">
  {% endstep %}
  {% endstepper %}
