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.

Importing External Link via Excel

1 reply [Last post]
Thu, 2010-03-04 13:04
Richard Daoud
User offline. Last seen 11 years 41 weeks ago. Offline
Joined: 21 Jan 2010
Posts: 8
Groups: None
Hi,
I have a P6 schedule (called Schedule A)that I need to link to another P6 schedule (called Schedule B). I also have these required external links defined in an Excel sheet.
I did the following:
1- I exported Schedule A "Activity Relationships" to Excel by going to: File -> Export -> Spreadsheet-(XLS) ->...
2- In the above exported Excel file of point 1, I added new lines for the new external links and specified in column "pred_proj_id" and "proj_id" the adequate information.
3- I imported back the Excel file of point 2 above into P6, Schedule A.

During importing I received an error message saying that it did not recognize the external activities, knwoing that I am opening schedule A and B at the same time.

Can anyone help me on how to import external link via Excel?

Thanks,
Richard
Top

Replies

Mon, 2010-03-15 10:05
#1
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Richard,

You cannot add or modify any P6 format in Excel because of its "USERDATA" SETTING.

Add the required column in P6 and export it to Excel and perform the changes in relationship.

Regards,

Arnold
Top