Oracle Primavera P6 is one of the best project management tools available on the market. Although it has advanced project planning and scheduling capabilities, project teams may find it difficult to use. In this short tutorial, we will discuss how to remove resource costs from the Oracle Primavera P6 XER file. If you’re a project planner or scheduler, you’ve probably been in a situation where you need to send a project file to other parties, but want to preserve specific information.
For example, you need to provide a subcontractor a copy of the schedule, but you don’t want or the subcontractor is not interested in knowing the project costs. This is a standard kind of situation.
In reality, removing certain information from Primavera P6 XER file is not an easy task.
You need a copy of the project in Primavera P6, then toggle off the Expenses option and Resource & role assignments option. Then you export the schedule to an XER file and send it to appropriate parties. Imagine you have tens of stakeholders and all need to get a personalized schedule.
But what if all this can be done with a single click of a button? What if the whole process could be simplified and even automated?
That’s possible. With the right tools.
One such is ScheduleCleaner, desktop software that clean/hide sensitive information from XER files.
The process of removing information is simple: you upload the XER file into ScheduleCleaner and set which project categories should be removed according to specific stakeholders’ needs.
The output file is a copy of the original project schedule, but without the category of data, you want to remove/hide.
What Can You Remove/Hide with ScheduleCleaner?
- Convert Global to project calendars
- Convert Global/EPS to Project Activity Codes
- Change output file version number
Who to remove Costs from Primavera xer file with ScheduleCleaner?
A pre-requirement is to have ScheduleCleaner installed on your computer. A free trial version is available for testing purposes. Before deleting costs, we’ll open the original XER schedule.
We actually want to remove/hide “Actual Labour Cost” before sending the file to a contractor.
The first step is to start the program and locate the XER files. You can setup an output folder for the “cleaned” schedule. Note that ScheduleCleaner does not change the original file, but creates a duplicate version at the desired location.
Then in the “Clean” tab, you check the category for deletion. In our case, that’s “Clear All Costs” checkbox. It will remove project funding, budget changes, spending and benefits plans, and project expenses and assignments costs from the project plan.
The last thing is to click on the green button next to “Ready to clean”
You will get a notification that cleaning is complete.
To check, we are opening the output file and see that the Actual Labour Cost are zeroes.
ScheduleCleaner not only removes/hides data but also can add Prefix/Suffix. Inserting prefix or suffix to different categories in the project plan can give additional information to the person who reads the information and acts according to them.
But the best feature it could offer is creating Templates. A template is a form in ScheduleCleaner™, where the user can specify which action or combination of actions will be performed, location of the newly created file will be saved, the suffix that will be added to the newly created file, etc.
Users can create a specific template for each stakeholder if needed, depending on the information we want to protect from the third-party.
I strongly recommend ScheduleCleaner software for any scheduler who is serious with time-saving, automation and keeping data integrity.
What’s your favorite way to protect sensitive information within XER files? I would like to hear from you.