Aphex Help
Go to Aphex
  • Welcome
  • Getting Started
    • Joining your Team
      • Getting Around
      • Adding Tasks
      • Linking Tasks
      • Resources
      • Map & Location
      • Readying & Publishing Plans
    • Project Set Up
      • Importing
      • Folders & Structure
      • Users
      • Views
      • Resources & Assets
      • Map
      • Publishing & Routine
  • Guides
    • Imports
      • Importing your Master Schedule (XML/XER/MPP)
      • Migrate existing plans to Aphex (CSV)
      • Importing Folders (CSV)
    • Feature Walkthroughs
      • Creating & Sharing Published Versions
      • Understanding Resources in the Plan
      • Group Dates & Durations
      • Exporting Data to a CSV
      • Copying tasks between Projects
      • Blockers
    • Integrations
      • ArcGIS Set Up Guide
      • Getting Started with Power BI Reporting
    • Reporting
      • Power BI Templates
  • Reference Docs
    • Fundamentals
      • Organisations
      • Projects
      • Tasks
      • Task Panel
      • User Preferences and Notifications
    • Scheduling
      • Views
      • Gantt
      • Board
      • List
      • Map and Clashes
      • Status and Progress Updates
    • Project Assets
      • Project Users and Teams
      • Resources and Assets
      • Structure
    • Publish, Print & Share
      • Printing
      • Published Versions and Shared Plans
      • Readying and Reviewing Plans
    • Data
      • Imports and Exports
      • Transferring
  • Frequently Asked
    • FAQs
      • How do I Add & Remove Filters?
      • How do I create & track Milestones?
      • How do I Move Folders?
      • How to login with SSO
      • Where have my Tasks gone?
      • How do I print my Plan?
      • Can I change the sort order of Tasks and Packages?
      • How is PPC calculated in the Power BI dashboard?
      • Why can't I delete a Task?
      • Why are the successors not scheduling?
      • How do I promise Tasks?
      • How do I delete multiple Tasks?
      • Why were some Tasks skipped from updating?
      • Why can't I upload an image for my Location?
      • How do I change the non-working days of a Task?
      • How do I make changes in bulk?
      • How do I transfer my work to another User?
      • How do I add new Users to the Project?
      • What can Lite users do?
      • How do I set a Reviewer?
      • How do I reset my Password?
      • How do I set up MFA?
      • Setting up SAML SSO
      • How can I use Aphex to update P6?
    • Troubleshooting
      • Troubleshooting Aphex
      • Troubleshooting your ArcGIS integrations
    • Coming Soon
      • 2025 Pricing Update
      • Changes to View Controls & Filters
      • Changes to the WBS
      • Changes with Status
  • Policies
    • Terms & Policies
      • Compliance and Certification
      • Terms & Agreements
        • Terms of Service Overview
        • Terms of Service
        • Subprocessors List
        • Service Level Agreement
      • Policies
        • Acceptable Use Policy
        • Privacy Policy
        • Cookie Policy
        • Fair Billing Policy
        • Support Policy
  • DEVELOPER
    • API & Integration
      • Plan APIs
        • Authentication
        • Project Assets
        • Tasks
      • Published Plans (Power BI) API
      • Work Area API
Powered by GitBook
On this page
  • Supported Migration Sources
  • Migrating Tasks while Creating a New Project
  • Migrating Tasks into an Existing Project

Was this helpful?

  1. Guides
  2. Imports

Migrate existing plans to Aphex (CSV)

For users wanting to move their planning to Aphex, we provide an easy way to migrate data from spreadsheets or other tools (like excel) into their project.

This guide will cover formatting your spreadsheet, the task properties you can import, and how to run the migration.

The migration tool allows you to import tasks with some basic properties through either a CSV upload or a direct copy-paste action.

Supported Migration Sources

In order to enable anyone to move tasks to Aphex, regardless of where they currently plan, the migration tool is built to support CSV formatted data.

If your plans are in any system with rows and columns, you can most likely either export the data directly to CSV or copy the data from the interface and paste it into a CSV or other spreadsheet.

Task Properties

The migration tool supports the optional mapping of six properties (Aphex columns) on imported tasks, with at least one mapping required for a valid import.

Column
Format
Auto-assigned value

Column

Format

Auto-assigned value

Task Name

Any string

"New Task"

Start

'dd/MM/yyyy',

'dd/MM/yy',

'yyyy/MM/dd',

'dd-MM-yyyy',

'dd-MM-yy',

'yyyy-MM-dd',

'ddMMyy',

'yyyyMMdd',

Prefix of the day are also supported i.e. "Tue ddMMyyyy"

Today

End

Same as Start

Same as Start

Shift

'Day',

'Afternoon',

'Night',

'All',

Day

Package

Any string

N/A

Subcontractor

Any string

N/A

Imported tasks will be assigned to the project's default calendar and the owner undertaking the migration. Assigned Project Assets, such as Packages or Subcontractors will be created automatically if required.

Formatting your Data

The migration tool will typically support any CSV export from other planning tools. If your existing plans are in a spreadsheet, the data can be copied directly. Additional heading rows can be excluded during the import.

Should your existing data be inconsistently structured due to headings or another formatting technique, you can download an example CSV template below and paste your relevant data before importing.

Migrating Tasks while Creating a New Project

You can migrate your plans to Aphex whilst creating a new project:

  • From your Org's homepage, click Create New Project

  • Enter your Project's name, then hit Continue

  • See the next steps using the interactive walkthrough below:

Migrating Tasks into an Existing Project

You can import your tasks into an existing project:

  • Open your Project

  • See the next steps using the interactive walkthrough below:

Only Admins will be able to create new Subcontractors during the migration process.

All Packages named in the migrated data will be created as new Public Packages, owned by the User running the migration

Last updated 11 months ago

Was this helpful?

Sample CSV Import File