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 Cost Account

6 replies [Last post]
Sinan Fahmi
User offline. Last seen 9 years 8 weeks ago. Offline
Joined: 17 Dec 2006
Posts: 68
Groups: None
Dear Planners,
is there any method to import cost account from excel to primavera p6, because my company has more than 2000 cost account and it will take a lot of time to type it one be one?

Regards,

Replies

Mohammed Ali
User offline. Last seen 2 years 10 weeks ago. Offline
Joined: 16 Mar 2018
Posts: 72
Groups: None
Zoltan Palffy
User offline. Last seen 20 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

you do nto need sdk all you need is the excel spreadsheet but p6 has to be on a 32 bit machine

John Reeves
User offline. Last seen 17 weeks 1 day ago. Offline
Joined: 10 May 2013
Posts: 343
Groups: None

Can this be done now with without an SDK.  It is crazy that you cannot import the cost accounts and costs.  I am simply importing the costs from an original file to a later file of the same name.  Costs import fine.  I will only import the cost accounts if you also import the WBS - and being that the WBS uses the project name, even though the same file that rev number is different and over-writes the WBS - how crazy is this.  Let me know if a way around this.  

Rodel Marasigan
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Sinan,

There is a PP member offering Steps using SDK. Try to give him your email address and he might help.(link below)
STEP-BY-STEP GUIDE USING SDK IN SCHEDULE PREPARATION
Sinan Fahmi
User offline. Last seen 9 years 8 weeks ago. Offline
Joined: 17 Dec 2006
Posts: 68
Groups: None
Thanks my Friend,
unfortunately I don’t know how to use Excel SDK, do you have any reference material that I can learn how to use this Kit.

Thanks again for your reply
Rodel Marasigan
User offline. Last seen 10 weeks 6 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Sinan,
Defining Account codes can be done by Excel SDK. If assigning account codes to activity you can use export/import excel spreadsheet functions in P6 using resource assignment.