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.

Changing multiple rates in P6

No replies
Thomas Nicholson
User offline. Last seen 2 weeks 15 hours ago. Offline
Joined: 4 Oct 2006
Posts: 88
Groups: None

Hey there, 

We've a staff rate change coming up and I wondered if there were an easy way to add a new rate to multiple resources at once rather than go through our staff list of near on 2,000 people individually and adding the new rates to each one. 

I've thought of global change but that doesn't seem to have such an option. 

I'm slightly concerned I'm going to spend the next few months going through them all changing them one by one. 

 

Thanks in advance, 

Thom

Rodel Marasigan
User offline. Last seen 20 weeks 1 day ago. Offline
Joined: 25 Oct 2006
Posts: 1699

Hi Thomas,

XER excel parser is an excel with visual basic program that extract XER data to excel spreadsheet so you can modify then build an xer. This is not SDK and you are importing XER not through 3rd party system therefore nothing to do with your IT unless you are not allowed to import xer to your P6 database.

Zoltan Palffy
User offline. Last seen 29 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

thats a good option to use the parser

Thomas Nicholson
User offline. Last seen 2 weeks 15 hours ago. Offline
Joined: 4 Oct 2006
Posts: 88
Groups: None

Rodel, 

Unfortunately our system won't let us use useful things like that, as such none of us have ever used them. 

May have to have a look and see if I can operate it, perhaps convince our IT dept to allow to use it. 

Thanks, 

Rodel Marasigan
User offline. Last seen 20 weeks 1 day ago. Offline
Joined: 25 Oct 2006
Posts: 1699

If you know how to use excel XER Purser Builder, you can easily populate the rate table (RSRCRATE) and build the xer so you can import the rate into P6 database.