Recovering Deleted Primavera P6 Data - A Client Crisis
A client of ours had just this sort of scenario.
The user reached out to us in a panic. This user had just been given increased access in P6 and had renamed an existing UDF. He realized it was renamed improperly and instead of changing the name of the UDF, he deleted it. The project level User Defined Field (UDF) had data assigned to many of their projects. They needed to recover it and ensure the values were reinstated on their projects. We were able to recover the data in less than and hour and a half.
We needed to identify and restore values that were assigned to over 400 projects. If we restored from a weekly or monthly full database backup, we could lose recent changes to all 2,750 projects that had been done since the the backup was taken. That was clearly not ideal! However, we had been creating backup XML files with our P6-Loader’s backup functionality on a nightly basis, so we could get the values from those XMLs.
Our programmers wrote a query to create a CSV file with the Project ID and UDF values from those backup XML files. They then queried the projects with data in that UDF and provided them to our functional team. The functional team then used that data to populate a P6-Loader file in Excel that would repopulate the UDF values. We then uploaded the files with P6-Loader and voila! Data restored.
Our P6-Auditor and P6-Loader tools were invaluable in restoring our client’s data so quickly. If you would like more information on these tools or any of our other offerings, visit our website at https://www.emerald-associates.com/
About the Author
At Emerald Associates, Sue is an Implementation Specialist and has been successful at drawing on her accounting and project management background to consult with our diverse client base. With her friendly demeanor and strong communication skills, she has become a talented Primavera trainer and works very hard to effectively implement Oracle Primavera solutions that cater to each client’s unique organizational needs.