The OPC-Integrator can extract information from, and load information to, multiple files within Oracle Primavera Cloud (OPC) in the same load. This means that there’s no need to run separate extracts from each file when you need the same (or similar) data pulled from each file. With the OPC-Integrator, you can just select the definition or select the modules you need, configure them, and then select all the files you want to download the module information from. Then, simply click the download button!
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
Recently, when working with a client who was combining several Primavera P6 databases into one, we discovered some interesting things with respect to layouts and filters.
In the latest version of Primavera P6 v24, there have been major changes to updating baselines, including a visual overhaul and some new functionality. However, some of our clients have recently noticed that their baselines weren’t updating correctly. While the Job Services logs showed that everything was updating properly, in reality users weren’t seeing any changes when they actually went into their projects to check if their baseline changes were reflected.
In this release of P6-Loader v15, Emerald has added additional UDF merging options for better control. Layouts and filter controls have been greatly expanded, with a layout usage sheet and loader sheet to deal with user layouts. Resources can now be remapped when copying layouts.
March 26, 2025
Written by Ravi Wallau
In this release of P6-Loader v15, Emerald has added additional UDF merging options for better control. Layouts and filter controls have been greatly expanded, with a layout usage sheet and loader sheet to deal with user layouts. Resources can now be remapped when copying layouts.
New Features
SQLite - Reading SQLite files and converting them into Excel files with global and project data.
Process One Row at a Time - Disable batching completely when dealing with large changes, such as deleting code types, UDF types, and projects. This can also be useful when loading data, if P6 is unable to save certain updates.
Layout Usage Sheet - Know which layouts and filters are in the database, and which filters exist and/or are active inside each layout, as well as which of these filters are user, layout, or global filters. The sheet also lists the Gantt bars in the layout, if they are visible or not, and which filter they reference.
Layout Usage Sheet Loader - Allows the team to clean up user filters from layouts, including global layouts. Replace a layout/user filter reference with a global filter, change the filter reference, and save the filter blob in the proper area in the layout, so that Gantt bar filters can be edited by users other than the original creators of the filter. This is a key tool for keeping your layouts usable over time.
Task Dissolving - The P6-Loader can now dissolve tasks, keeping relationships working correctly in the project.
Enhancements
Improvements in the UDF Merge Sheet - More merge options and more control regarding which values to keep/remove in the sheet.
Resource Remapping - When copying layouts, in addition to remapping code types, code values, users, and UDF types, the P6-Loader can now remap resources as well.
When creating a schedule in Oracle Primavera Cloud (OPC), you should consider using the Scope App in conjunction with the Schedule App. With the Scope app, you can create scope items and choose whether to connect them to activities in the schedule, depending on your project requirements. Scope items are the materials or products needed to complete a project.
At Emerald Associates, we’ve worked with many clients who’ve 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, especially when their databases are in a SQLite format.
It might not seem like a big deal to give meaningful or unique names to your filters and layouts in Primavera P6, especially when they are your own user filters and layouts. After all, you made the filter and likely know what it’s for. However, having an abundance of unnamed filters can quickly become an issue.
EPS level activity codes can be created in Primavera P6 to be available to projects under a designated EPS. While this can help with the amount of activity codes at the Global level, you may want to carefully consider whether you want to add activity codes at the EPS level, as they can pose problems for you down the line.
The OPC-Integrator is a new tool developed by Emerald’s team of Primavera specialists. A secure solution, the OPC-Integrator provides data extraction, loading, updating, and integrating in a quick and easy to use tool - one that both project users and administrators will find efficient and easy.