FluentPro Help Center

What do you need help with?

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.


    Import external EPM data

    Import external EPM data is designed to help a user to import data exported from different EPM systems such as Clarity, Daptiv, etc.

    To start the wizard click File → Import → Import external EPM data

    Step 1 - Load external EPM data

    1. Select Excel file that contains exported data (file must be saved in *.xlsx format).
    2. Select mapping file (if you have it).
    3. Click Next.

    Please note: If you want to map external data to existed project fields on the target PWA you should import those fields into the current workspace before starting the wizard. Input file may contain the following sheets: Resources, Projects, Tasks, Assignments, Risks, Issues, Deliverables. In case the input file does not have some sheets then appropriate import step will be skipped (e.g. Resources sheet is absent in the file then Import Resources step will be skipped).

    Step 2 - Import Resources

    1. Map imported fields from combo boxes to native PWA fields (e.g. Full Name field map to the Resource Name native field).
    2. Map fields in the table (optional).
    3. Click Next.

    Please note: Target Field and Target Field Type fields are editable.

    Verify the result of mapping process and click Next.

    Step 3 - Import Projects

    1. Map imported fields from combo boxes to native PWA fields (e.g. Project Name field map to the Project Name native field).
    2. Map fields in the table (optional).
    3. Click Next.

    Verify the result of mapping process and click Next.

    Step 4 - Import Tasks

    1. Map imported fields from combo boxes to native PWA fields (e.g. Task Name field map to the Task Name native field).
    2. Map fields in the table (optional).
    3. Click Next.

    Verify the result of mapping process. You can select a project from the drop down list and all imported tasks that belong to the selected project will be shown in the table below. To go to the next step click Next.

    Step 5 - Import Assignments

    1. Map imported fields from combo boxes to native PWA fields (e.g. Task Name field map to the Task Name native field).
    2. Click Next.

    Verify the result of mapping process and click Next.

    Step 6 - Import Project Artifacts

    1. Map imported fields from combo boxes to native PWA fields (e.g. Project Name field map to the Project native field).
    2. Click Next.

    Verify the result of mapping process and click Next.

    Step 7 - Finish

    In the last screen of the wizard you can do following actions: 

    1. Make all tasks auto scheduled.
    2. Set task Start and Finish time.
    3. Save mapping to a file.

    Click Finish to start import. After importing is complete current workspace will be shown with the imported data.


    Was this article helpful?

    Table of contents

      Still can't find what you're looking for?

      Contact Support
      Back To Top