Changing multiple rates in P6

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

T
Thomas Nicholson 👤 Member for 19 years 8 months

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, 

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

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