Articles in Category: P6-Scrubber
P6-Scrubber v7 - New Release
In version 7, we added support for scrubbing role codes, revamped the simple scrub dialog (and added new simple scrub areas), and added the ability to apply a dynamic prefix to both IDs and hierarchies in the simple scrub area.
April 30, 2025
Written by Ravi Wallau

In version 7, we added support for scrubbing role codes, revamped the simple scrub dialog (and added new simple scrub areas), and added the ability to apply a dynamic prefix to both IDs and hierarchies in the simple scrub area.
New Features
-
Support for scrubbing role codes
-
Simple Scrub now supports “dynamic” prefixes where a user can configure a UDF or project code whose value is then used for prefixing
-
Simple Scrub dialog cleanup and support for new options
-
Supports importing data from a SQLite file - scrubbing operations can be performed against XML and XER files (same as before)
Enhancements
-
Added API for remote call by other apps such as P6-Calculator and P6 XER Importer/Exporter
-
Better REST support for remote P6 API calls
Learn More
P6-Scrubber News Articles
P6-Scrubber Videos
on Wednesday, 30 April 2025. Posted in News, P6-Scrubber
P6-Scrubber v6 - New Release
In version 6, we added notebook type scrubbing and also made improvements to the P6-Scrubber user interface, reports and functionality in general.
February 27, 2023
Notebook type scrubbing, improved UI
Written by Ravi Wallau

In version 6, we added notebook type scrubbing and also made improvements to the P6-Scrubber user interface, reports and functionality in general.
New Features
-
Notebook scrubbing - remove unwanted notebook types and/or rename them
Enhancements
-
Option to hide users starting with "zz" from the user list, as well as users with no global access to P6
-
Additional safeguards around editing configuration profiles to prevent accidental overwrites
-
Scrub report improvements
-
Up to 10 times faster XER/XML import operations, and up to 5 times faster scrubbing operations
Learn More
P6-Scrubber News Articles
P6-Scrubber Videos
P6-Scrubber Case Studies
on Monday, 27 February 2023. Posted in News, P6-Scrubber
P6-Scrubber v5 - New Release
Work online or offline to define and scrub your XER files and now, in the new release, XML files. Version 5 makes scrubbing files even easier for schedulers.
December 5, 2022
Written by Ravi Wallau

Work online or offline to define and scrub your XER files and now, in the new release, XML files. Version 5 makes scrubbing files even easier for schedulers.
New Features
-
XML support! Now the P6-Scrubber can scrub XER or XML files.
-
Simple prefix - lets you add a prefix to global objects such as resources, code types, UDFs, calendars, etc. to identify where it came from.
-
XML sanitation - when scrubbing an XML file, its contents are saved accordingly to the XML schema file. If the file cannot be imported into P6 EPPM because of schema errors, processing the file with the P6-Scrubber may fix it.
-
Version control - setting the version you are uploading back into P6 is now in the GUI for easier control for both XER and XML importing.
-
Parent role & resource - to land all the resources and roles in the scrubber file under a specific role or resource in the P6 database.
-
OBS definition - it is possible to choose an OBS that will be associated to the project when it is imported when scrubbing XER files.
-
SSO/ SAML support - if you are using SSO/ SAML for your P6 Cloud environment, you can perform SSO/ SAML login with the P6-Scrubber.
Enhancements
-
UI improvements - the last imported project (or projects) is shown in the UI, and it is possible to access the scrubbed files directly from the main page of the application.
Learn More
P6-Scrubber News Articles
P6-Scrubber Videos
P6-Scrubber Case Studies
on Monday, 05 December 2022. Posted in News, P6-Scrubber
Handling Codes Prior to XER/XML Import with P6-Scrubber
Written by Sue Fermelia - Implementation Specialist on Friday, 30 September 2022. Posted in All Articles, P6-Scrubber
Cleaning a P6 XER/XML Quickly for Import with the Simple Scrub
We may receive a file with codes, UDFs, Resources, Resource shifts and curves that we either do not want to import at all, or, perhaps, we want to prefix them so we can identify where they came from after they are imported. Global calendars also pose a problem. When global calendars are imported with an XER or XML file, those calendars overwrite the definition of a calendar with the same name in your existing database, which could alter dates on your existing projects. When those projects are rescheduled, the new calendar definition is used to calculate the dates. We also may not want the new imported calendars polluting our group of organizational global calendars. Ideally, we want to keep the global calendar in the imported project and move it to a project calendar so the integrity of the project dates is not altered by removing the calendar.
P6-Scrubber gives us a quick and easy way to handle data that we merely want to remove, prefix or roll down called the Simple Scrub. Simple Scrub is a “one stop shop” for handling all these data items. It is contained all in one window, so you can quickly define what you want to do with each data element.
Written by Sue Fermelia - Implementation Specialist on Thursday, 25 August 2022. Posted in All Articles, P6-Scrubber
Cleaning Microsoft Project XMLs Quickly for Importing to P6 with P6-Scrubber
MSP data imported as an XML file contains the following that you may want to control:
- Activity Codes and Dictionary
- Activity User Defined Fields
- Resources
- Resource Codes and Dictionary
- Calendars
P6-Scrubber gives you a quick and easy way to handle this data. You can import the MSP XML into the tool to look at what the XML contains and create definitions to save and use over and over again. Let's look at each piece of data and see what can be done with MSP XML data prior to import.
Written by Sue Fermelia - Implementation Specialist on Friday, 19 August 2022. Posted in All Articles, P6-Scrubber
Simple Scrub with the P6-Scrubber
Deal with Data Items in XERs and XMLs Quickly Prior to Import
Are you looking for a quick and clean way to remove or prefix data, roll global calendars to the project level or assign the resources to import to an existing resource node in an XER/XML before importing it into your production database? By doing things like this, you can keep your organization’s codes, UDFs, calendars and resources tidy and easily identify what was imported.P6-Scrubber - Simple Scrub will allow you to do one or all of these things quickly and easily. Once a definition is set up, it can be saved to scrub other files with the same parameters, saving even more time.
Written by Sue Fermelia - Implementation Specialist on Friday, 08 July 2022. Posted in All Articles, P6-Scrubber
P6-Scrubber v04
P6-Scrubber is the answer to your data pollution woes. This tool designed by Emerald Associates will take care of clearing out that unwanted garbage prior to importing the XER/XML by allowing you to easily decide what is acceptable in the file. The P6-Scrubber Definition Configurator allows you to set up and save definitions for each client to be used over and over without rebuilding it each time. Definitions can also be edited, so if a new cleansing definition is needed, it can be added to the existing one.
P6-Scrubber can be deployed stand alone or it can be pointed at one or many database so data can be validated against what is already in the database.
Written by Sue Fermelia - Implementation Specialist on Thursday, 24 March 2022. Posted in P6-Scrubber
P6-Scrubber - Demoting Versions in XERs
Written by Sue Fermelia - Implementation Specialist on Tuesday, 15 March 2022. Posted in All Articles, P6-Scrubber
P6-Scrubber - Keep Your Primavera P6 Clean!
Introducing our Latest Primavera P6 Add-on
Are you importing schedules into scrubbing databases, taking out all the unwanted data you don't want to pollute your production database, re-exporting the schedule and then importing it into the database where it should have gone in the first place?
Do you have required specifications your contractors need to follow for their schedules, but have a hard time knowing whether those details are missing or incorrect until you've already imported them?
Do you want to ensure you are not importing POBS tables and corrupted RISKTYPE tables?
That's a lot of quality assurance to do! Maintaining your corporate data standards for dashboarding and reporting can be a full time job, especially when project teams have their own coding structures and requirements for their P6 Environment.
Don't worry; there's relief. Emerald has developed a new tool that will do all that work for you! We are now introducing P6-Scrubber.
Written by Sue Fermelia - Implementation Specialist on Wednesday, 19 June 2019. Posted in P6-Scrubber, Primavera P6