P6-Loader

Highlights Overview Purchasing News Case Studies Videos Survey Results Blogs

Automate Primavera P6 data loading and updating. Load and extract data back and forth between Primavera P6 and Microsoft Excel with ease.

P6-Loader is cloud enabled and Oracle Cloud Marketplace approved
P6-Loader Blog - Tips, tricks and use cases on how we've automated P6 data entry
Easily update Primavera P6 with data that exists in other locations
Give contractors ready-to-load Excel templates to fill in
Load and extract global and project data with hierarchy and logic between Microsoft Excel and Primavera P6
Automate the backups out of P6, even from the Oracle P6 Cloud

Latest Version - Highlights

Simplify all Primavera P6 data loading and updating using the ease of Microsoft Excel.
Extract 99% of information in P6 on one or many projects.
Upload P6-Loader files singly or line them up to load while doing another task.
Remove POBS and RISK TYPES from an XER before you import it and convert XER or XML files to P6-Loader friendly files.
Give your team the ease of working with P6 data in a familiar tool, Microsoft Excel. This activity sheet includes all the data you need to create, edit and update activities.
P6-Loader has the ability to transfer global, project and user filters, layouts, global changes and reports from one database to another while maintaining the integrity.
Keep your databases tidy with usage sheets that identify what project is using what piece of global data. In this example, projects that are using each calendar are easily identified. A Usage Sheet can be run for UDFs, Activity Codes, Calendars, Resources and Roles.
Create backup files with daily and/or monthly frequency from P6-Loader. Projects can be selected based on their status.
Export files to the P6-Loader Excel format and P6 XML (or both) formats on a Daily, Weekly or Monthly basis and choose if/what baselines you want to include.
With automation turned on for a given database, a full export of the database's global data is performed every day and/or week. It includes EPS, OBS, resources, roles, users, dictionaries, UDFs, etc.
Export files to the P6 XML format.
Download the project and global files for a database at a given point in time. This makes recovering lost data and administering the database much easier.
Resource assignment duplicates using the internal ID of the resource assignment or pick one or more UDFs to help the P6-Loader match the right one.

Overview

Problem

Oracle Primavera P6® is a state of the art enterprise project portfolio management (EPPM) system designed to allow worldwide project teams to collaborate for the best project results. Giving your team access to load all of the necessary data into the system may not always be possible, and even when it is, the data entry process can be frustrating and time-consuming.

Solution

The Emerald P6-Loader is a flexible and secure solution that automates Primavera P6 data extraction, loading and updating. The P6-Loader gives project users and administrators the ability to import and export nearly every data element available in P6, allowing for the movement of data back and forth between Primavera P6 and Microsoft Excel in a controlled manner.

The P6-Loader can create and update data in the Primavera database and allow users to manipulate data at both the project level and global level. With the P6-Loader, you can literally create an entire database in minutes. As a result, the P6-Loader goes above and beyond Primavera P6’s built-in Excel import & export functionality. The functionality in P6 is limited to the manipulation of 5 data elements and restricted to project level data that can only be moved one project at a time. P6-Loader includes activities, resource assignments, the resource dictionary, calendars and more.

ROI

Emerald’s P6-Loader, developed by our team of Primavera specialists, can significantly accelerate Primavera P6 implementations, monthly statusing from multiple Primavera P6 systems, clean-up efforts and project updates. The user-friendly nature of the P6-Loader solution means that it can be used by any user without requiring database administrator knowledge or security privileges.

Purchasing

The P6-Loader Subscription Model Back to top

News

P6-Loader v14 - New Release

Better resource assignment and unique loading options, record action column, and backup of layouts

P6-Loader v13 - New Release

Easier Hierarchies and Fragnet Templating

P6-Loader v12 - New Release

Our latest version of the P6-Loader brings the ability to automate the backups out of P6 even from the Oracle P6 Cloud.

P6-Loader v11 - New Release

Our latest version of the P6-Loader brings a new user-interface with the ability to save extract definition and new version 20 support, as well as UDF merging.

P6-Loader v10 - New Release

Version 10 of the P6-Loader now uses the Cloud API, a programming platform developed by Emerald to allow our apps to work with either the P6 API or the P6 Web Services. It also streamlines restoring and reassigning baselines and initiated support for the new P6 v20 objects.

Case Studies

P6-Loader Used to Help Client Upgrade P6 and Clean Database

Emerald Helps Midstream O&G Client to Upgrade P6 and Clean Database with P6-Loader SaaS