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.

Material Resource Assignment export incorrect

1 reply [Last post]
Tony Scott
User offline. Last seen 13 years 42 weeks ago. Offline
Joined: 29 May 2007
Posts: 19
For you information, this is a problem that I have discovered. Not sure of it is mine alone, or a global issue. This could be a huge issue in some cases.

I recently exported material resource assignments from Primavera to Excel. In the resulting output, all of the material values were off by a factor of 10 (i.e. what was entered into Primavera as 1,000, was exported as 10,000). Upon further investigation, we realized that every one of the exported values ended with a "3".

The material resource was assigned a unit of measure (UoM) of m3. It appears that the numeric value from the UoM was exported with the actual quantity, in the quantity field, as if it were part of the value itself. An export of the UoM field indicated m3 as one would expect. With testing, it was confirmed that this did not happen if the UoM chosen was alphabetic only, and not alphanumeric (i.e. CuM wasn’t a problem while m3 was).

Our platform is Primavera 5.0, SP1, running on a SQL Server 2000 backend (soon to be upgraded when IT has the infrastructure fully in place). I am unsure if this problem exists with other versions.

I was unable to find this issue referenced directly on the Primavera knowledgebase, but I have submitted a support request in order to get it logged.

Tony

Replies

Arnold Puy
User offline. Last seen 9 years 28 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Tony,

Yes, you are correct. It happens also in P6. However to avoid this, prior to export to excel go to Edit --> user preferences --> Time Units Tabs, untick "Show Unit label" then you can proceed to export to excel spreadsheet. There you can find that your Budgeted Quantity will be okey.

Just like when you are going to "Assignments" icons, selecting all activities & press Ctrl+C and paste it in excel spreadsheet, you can see that m3, m2 & etc (UoM) will also be copied.

HTH.

Regards,

Arnold