Skip to content

Problem importing activities from excel

Alexander MacintyreMember for 7 years 8 months
Created
3
3
0

Hello all,

Here is the issue im facing;

I made my activity list in excel with each WBS codes with the exact codes in Primavera. I then made one new activity in Primavera, exported the xls file, added the "Activity ID", "WBS code", "Activity name" and "Duration" of each actvity, and made sure the "Duration" was formatted to text, but when I import it I get an Error message saying';

Excel Import log started : 14-Feb-19
INFO: Importing Global Data...
INFO: Importing Project Data...
INFO: Importing:
WARNING: TASK: Failed to resolve foreign key for field WBS Code with value NEWPROJ-7.Cons.Allb.Resd.St-A.Z-01.A-A1.Sust.Cnwr. Field cleared.

It has this for what I belive to be every WBS

Then it says;

ERROR: target_start_date is null for TASK ActivityID: St-A-Z-01-A-A1-3-0, Project: NEWPROJ-7

For what I assume is every activity.

I hope you guys can help.

Thanks,

 

Alex

3 replies

Oldest first
  1. 0
    Alexander Macintyre ·

    I found the solution!If you

    I found the solution!

    If you schedule the project and give it a data date before importing, the activies will import sucessfully.

  2. 0
    Kirill PM ·

    it becomes easier with

    it becomes easier with additional tools:

    https://youtu.be/1e-AAxCMAis

  3. 0
    Zoltan Palffy ·

    double check the wbs code

    double check the wbs code 

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?