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.

P6 Not Exporting Full Cost Account ID

7 replies [Last post]
Coy Laughlin
User offline. Last seen 4 years 21 weeks ago. Offline
Joined: 13 Nov 2019
Posts: 4
Groups: None

I am trying to export the entire cost account ID into excel. It appears as if primavera only takes the end value of the ID. So if I have a cost acount ID 00A.01 it will only export 01. Is there any way around this? 

Replies

Zhang Haixiang
User offline. Last seen 3 years 27 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None

 

you can try report. 

* create a "activity resource and role assignments" report to include the cost account column

* run the report and save to an ASCII Text File

* import the file into Excel

Coy Laughlin
User offline. Last seen 4 years 21 weeks ago. Offline
Joined: 13 Nov 2019
Posts: 4
Groups: None
Yes. The cost account ID only exports the end value so 316.0.10.4 will only export .4 I dont know how to format the cost account ID to get a successful re-import. I am exporting to excel.
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

so you are exporting Resources and Resource assignments ?

then you are exporting resource id and and cost account id ?

and resource type ?

David Kelly
User offline. Last seen 1 year 37 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

I have a few versions of P6 on different machines, but none as old as 7.0

I would advise downloading an evaluation of version 18 PPM, and checking it with an import of your project.

Coy Laughlin
User offline. Last seen 4 years 21 weeks ago. Offline
Joined: 13 Nov 2019
Posts: 4
Groups: None
I checked the admin preferences and both items you specified were set to the maximum. Also, I am using version 7.0.
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

do you have the rights to do this ?

what version of p6 are you using ? 

in the data limits what are your cost account tree maximim level set to  ?

in your ID Lenghts what are your cout account ID maximim characters set to  ? The maximum is 20 make sure that is set to that

 

David Kelly
User offline. Last seen 1 year 37 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630

works for me...