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.

Currency format

5 replies [Last post]
Alexandre Faulx-B...
User offline. Last seen 4 days 46 min ago. Offline
Joined: 20 Jan 2003
Posts: 1344

Hi Pplanners and PP users,

When I export a PP project as an XER file, the Currency thousand separator field remains empty; as a result, P6 does not want to import the project; I have to open the XER file in MS Excel, fill in the field and so on.

I have not found yet where to set up the thousand separator in Powerproject, it would help a lot.

By the way, many thanks to Malcolm Emmerson for his webinar earlier this week, very good!

Alexandre

Replies

Ben Taunt
User offline. Last seen 1 week 4 days ago. Offline
Joined: 16 Jan 2012
Posts: 109
Groups: None

Hi Alexandre,

 

As per my last, please make sure the Windows Regional Settings match the format that you need for importing to P6.  Sounds like you have a space in the settings, which is why the data is coming out without a different seperator.

It's probably best to contact either us or APP direct with questions like this, as we can then put all the correct resources behind answering your questions in a timely manner.

Thanks,

Ben

Alexandre Faulx-B...
User offline. Last seen 4 days 46 min ago. Offline
Joined: 20 Jan 2003
Posts: 1344

Ben,

I am working with Powerproject 15, translated in French by the spanish reseller and myself

The currency settings int he Export dialog only allows to select on currency in the list; I see nowhere how to set-up the separators.

In the Options dialogs, I have seen that the thousan separator for cost/revenues is a space, and the decimal a dot; in the Windows Regional settings for France, they are respectively a space and a comma.

Thank you for your help

Alexandre

Alexandre Faulx-B...
User offline. Last seen 4 days 46 min ago. Offline
Joined: 20 Jan 2003
Posts: 1344

Ben,

I am working with Powerproject 15, translated in French by the spanish reseller and myself

The currency settings int he Export dialog only allows to select on currency in the list; I see nowhere how to set-up the separators.

In the Options dialogs, I have seen that the thousan separator for cost/revenues is a space, and the decimal a dot; in the Windows Regional settings for France, they are respectively a space and a comma.

Thank you for your help

Alexandre

Alexandre Faulx-B...
User offline. Last seen 4 days 46 min ago. Offline
Joined: 20 Jan 2003
Posts: 1344

Thank you Ben,

an easy way to avoid this issue is to export as an XML file

Alexandre

Ben Taunt
User offline. Last seen 1 week 4 days ago. Offline
Joined: 16 Jan 2012
Posts: 109
Groups: None

Hi Alexandre,

I passed on your thanks to Malcolm and asked him to look into this one for us!  He thinks it is a Windows setting and a P6 setting.  Powerproject adheres to Windows currency separators and there is also a currency setting in the XER export wizard in Powerproject that should match the equivilant P6 setting.

Please do email Malcolm for more details.

Best wishes,

Ben @ Powerproject