Exporting Problem from Primavera to Excel

Submitted by Kien Dinh on
Oracle Primavera - PM6

Member for

6 years 3 months
Member for 6 years 3 months
Submitted by Kien Dinh on Tue, 2019-07-23 08:35
Permalink

Dear sỉ,

Trying this way has solved the issues. 

 DQK

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Mon, 2019-07-22 13:59
Permalink

go to edit users prefernces

then on tthe time units tab under Units format uncheck Sub-unit

and also under Durations format uncheck sub-units

Member for

6 years 3 months
Member for 6 years 3 months
Submitted by Kien Dinh on Sat, 2019-07-20 05:39
Permalink

Dear Zoltan,

Thank for the reply. I have verified both the Window and P6 for decimal and digit. After that, I tried to export P6 again but it still didn't work. Perhap the decimal and digit was not the cause for the exporting problem.

[[wysiwyg_imageupload:6885:]]

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Fri, 2019-07-19 14:47
Permalink

Issue is caused by the Windows Regional Settings having an inconsistent Decimal symbol and Digit grouping symbol then the Decimal Symbol and Digit grouping symbol in P6 Professional.

To ensure that Decimal symbol and Digit grouping symbol for both P6 Professional and the Windows Region and Language settings, under Customize Format, match and are consistent with the desired currency please do the following:

Make sure that these match 

For the Windows OS Region and Language settings:

  1. Launch the Windows OS Control Panel
  2. Select 'Region'
  3. Select 'Additional Settings'
  4. Select the 'Currency' tab
  5. Review the 'Decimal symbol' and 'Digit grouping symbol'

For P6 Professional

 

  1. Access P6 Professional
  2. Select 'Currencies' under the 'Admin' menu item
  3. Review the 'Decimal symbol' and 'Digit grouping symbol'make sure that