Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Import NEW Activities from Excel to P6 Error: control_updates_flag is null for TASK ActivityID:

1 reply [Last post]
sam dsoza
User offline. Last seen 5 years 22 weeks ago. Offline
Joined: 20 Jun 2006
Posts: 55
Groups: None

Hello All,

I am getting above mentioned error while importing new activities in to P6 - 

I could not find a accurate answer, while going through the forum -  Please asssist if there is a workaround.

TIA

Replies

Zoltan Palffy
User offline. Last seen 3 days 21 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

try this 

  1. Create new activities in the project that you want to import the new activities to (in Primavera). The number of activities should match the number of new activities that  you want to add.
  2. Export the  Primavera file to Excel. Ensure you have the correct columns, including:
    • Activity ID
    • Activity Name
  3. In the Excel file replace the ‘Activity Name’ and other fields as needed with new activities. Ensure you don’t change the ‘Activity ID’ field.
  4. Import the Excel to Primavera.

this procedure will update the existing "placeholder activities" with correct activities from the Excel.