P6 Professional - SQLite Database XER - Export/Scrub/Import Utility Mini Webinar

At Emerald Associates, we’ve worked with many clients who have had to migrate standalone databases over to a shared environment in Primavera P6. One of the struggles they often face is getting their EPS structures and global data out of their standalones and into their new Cloud environments when their databases are in a SQLite format.

The P6 Import/Export Utility lets you export files from a P6 SQLite database, as well as import files into a P6 online database or P6 local database, using the P6 client itself. Only XER files can be exported/imported, and it currently only lists projects from a SQLite database when exporting projects.

This tool can be used to export all projects from a P6 SQLite database. It lists the projects from the SQLite database, allowing you pick and choose which projects you want to export, and then invokes P6 on each project to have the XER generated. Also, in conjunction with Emerald’s P6-Scrubber tool, the utility also lets you clean, roll down, and/or remap unwanted data on all XER files in a given folder. As the files are processed, they are moved into a success/failure folder and the P6-Scrubber generated files are placed into an output folder. When this is complete, the tool can be used to import projects from a given folder into a P6 database. This database can be any type that is supported by the P6 client - so, in essence, any type supported by Primavera P6.

Curious to see how it works? Join our free mini webinar to see a live demonstration of this exciting software!