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 Resources in P6 by importing Excel spreadsheet

10 replies [Last post]
Wed, 2010-02-24 05:41
Kinnar Patel
User offline. Last seen 6 years 7 weeks ago. Offline
Joined: 7 Jun 2006
Posts: 24
Groups: None
Hi Everyone,
Does anyone know that how to assign resources to P6 programme by an excel spreadsheet and importing it in P6.
Is there any add-on available for P6 to do this.
I will appreciate your help.
Thanks in advance.
Kinnar
Top

Replies

Sun, 2011-02-06 23:39
#1
Johnny Xu
User offline. Last seen 13 years 10 weeks ago. Offline
Joined: 2 Feb 2011
Posts: 3
Groups: None
WONDERFUL Post.thanks for share..extra wait .. … Play blackjack infestation Mobile Porn pollutant Mobile Porn roadbed Free Mobile Porn neurosensory government grants dividendi win palace Catchall
Top
Thu, 2010-02-25 08:26
#2
muhammad anwar
User offline. Last seen 3 years 40 weeks ago. Offline
Joined: 5 Feb 2007
Posts: 46
Groups: TILOS
Kinnar

You need to install SDK from primavera disk.
Put the disk 1 in and run the exe file. Then choose to modify and hit next. You will have the option to install sdk there.
Once you installed SDK with pubuser name and password and it has been configured.
Then run the activity6 file if are on p6 and enable the macro in the spreadsheet.
Put in admin as username and password if your username and password are default for P6
Then hit the update project button. It will connect to PMDSDK and update the list.
The select the appropriate project and hit the Get... button
and update informaton in editable field without touching read only fields. Then hit the Set... buttons to update.

Hope this will help.

regards
Top
Wed, 2010-02-24 08:34
#3
Ferdinand U.
User offline. Last seen 6 years 33 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
you need SDK installed

then just experiment with the excel file
Top
Wed, 2010-02-24 08:14
#4
Kinnar Patel
User offline. Last seen 6 years 7 weeks ago. Offline
Joined: 7 Jun 2006
Posts: 24
Groups: None
Hi,
How to use activity6x.xls?
Please let me know.
Top
Wed, 2010-02-24 08:09
#5
Ferdinand U.
User offline. Last seen 6 years 33 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
hi kinnar

you can try using export import to spreadsheet facility of p6 from file menu

or you can try activity6x.xls
Top
Wed, 2010-02-24 08:06
#6
Rafael Davila
User offline. Last seen 20 hours 24 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Mike,

Some values are related to other values; if you only copy a portion you might damage the database or make it invalid. A resource definition is tied to calendars. What if the calendar does not exists? What if calendar definitions are different but equal names?

If you change resources using existing resources there would be no issue but I believe here the intention is to bring resources from another job.

It is not as simple as copy and paste. I would not rely on software that allows you to do that. Remember by merely missing a line in the sequence you would induce great error. In order to do it appropriately a key field must be used.

Recommend you cross with magic marker this option in your screen.

You can write my name on an exel spreadsheet paste it and then tell me about my birthday, this day must be defined as a personal holiday. Well Poweproject is a cristal ball.

Best regards,
Rafael
Top
Wed, 2010-02-24 07:45
#7
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Kinnar

If you have any data in an excell column and the numbers line up with the activities on the chart you should be able to copy the excell data and paste it into the corresponding column in P6.

I do this all the time with PowerProject.

Best regards

Mike Testro.
Top
Wed, 2010-02-24 05:46
#8
Kinnar Patel
User offline. Last seen 6 years 7 weeks ago. Offline
Joined: 7 Jun 2006
Posts: 24
Groups: None
How?
Top
Wed, 2010-02-24 05:45
#9
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Kinnar

Why not just copy / paste from excell to P6?

Best regards

Mike Testro
Top
Wed, 2010-02-24 10:10
#10
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
Hi Rafael

I use copy paste all the time between the Powerproject spreadsheet columns and Lotus 123 columns.

I have to ensure that the the two sets of coulmns line up precisely but after that it is routine.

If I change a set of data - such as resource hours totals - the underlying calendars allocated to the task remain unchanged.

Since most of my delay analysis work is done on lotus 123 (80%) then this facility is very useful.

Best regards

Mike Testro
Top