XLSX

M
meobeo u 👤 Member for 7 years 4 months

Hello there!

I am having issues while importing units and durations on P6, using XLSX files. 

When I import floating point values, it ignores the decimal point and import as an integer. For example, importing 12.05 and it writes 1,205 in the database. 

Does anybody have any idea on why does it happen and how to fix it?

I tried the oracle support here in Brazil but the company analysts only search the knowledge base and send default answers and workarounds that generally don't work. 

I am using P6 PRofessional R16.2 Release 16.2.7 (Build #: 23684).

Thank you!!!

Lee!

Z
Zoltan Palffy 👤 Member for 16 years 10 months

what is your units per day set on your resource ?

a quick fix would be to run a global change 

where budgeted cost is not equal to 0

then budgeted cost  = budgeted cost / 100

or 

where budgeted units is not equal to 0

then budgeted units  = budgeted units / 100

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts