P6-Loader

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

  • P6-Loader 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

Latest Version - Highlights

  • Simplify all Primavera P6 data loading and updating using the ease of Microsoft Excel.
  • See all P6-Loader submitted tasks in one window.
  • 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 UDF’s, Activity Codes, Calendars, Resources and Roles.

Overview

Problem

Oracle Primavera P6® is a state of the art Enterprise Project Portfolio Management 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.

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

Case Studies

Global Engineering Consultant Enhances P6 Usage

Global Engineering Consultant Enhances P6 Usage
Learn how Emerald's tools are enhancing this Engineering Consulting Company's use of P6

Learn more

Large Engineering Firm Moves to EAI Hosting

Large Engineering Firm Moves to EAI Hosting
Learn how a large engineering firm moved to the Emerald Cloud.

Learn more

Large US Oil Company Implements P6-Loader and TAPS

Large US Oil Company Implements P6-Loader and TAPS
One refinery using TAPS and P6-Loader saw great improvements in speed and accuracy when working with P6 data that the company rolled out the tools to all refineries.

Learn more

P6-Calculator and P6-Reporter Makes Power BI Reporting a Breeze

P6-Calculator and P6-Reporter Makes Power BI Reporting a Breeze
Major North Eastern utility company uses P6-Reporter and P6-Calculator to improve their reporting.

Learn more

CAPPS Makes Updating Hundreds of Projects Easy

CAPPS Makes Updating Hundreds of Projects Easy
Remote PMs get updates in on time with CAPPS

Learn more

Large US Refinery Implements Emerald Tools

Large US Refinery Implements Emerald Tools
Learn how this refinery used P6-Loader and TAPS to improve accuracy and speed when working with data in their P6 schedules and how they used EP-datawarehouse and custom dashboards to help with cost control and management visibility for their turnarounds.

Learn more

IT Portfolio Management in P6

IT Portfolio Management in P6
IT Portfolio Streamlined with PeopleSoft and P6

Learn more

Moving from SAP to P6

Moving from SAP to P6
Oil exploration company uses P6-Loader to migrate to Primavera P6 with speed and consistent data.

Learn more

Turnaround Planning with Outsourced Contractors

Turnaround Planning with Outsourced Contractors
Large oil and gas company uses P6-Loader to develop turnaround plans.

Learn more

Moving to the Primavera Cloud Made Easy

Moving to the Primavera Cloud Made Easy
Used the P6-Loader to move a client to the Primavera Cloud in two weeks.

Learn more

SAP Integrated to P6 with P6-Loader

SAP Integrated to P6 with P6-Loader
Large Australian rail company uses the P6-Loader to integrate SAP to Primavera P6.

Learn more

AVEVA->P6 Engineering Document Integration

AVEVA->P6 Engineering Document Integration
We integrated Aveva with P6 to drastically reduce the time our client spent updating their capital projects

Learn more

Large Energy Company Migrates to Clean P6 Environment

Large Energy Company Migrates to Clean P6 Environment
The daunting task of cleaning up 10 years of projects was made easy with P6-Loader so archiving, cleaning, fixing and upgrading could happen.

Learn more

Fabrication Program Management

Fabrication Program Management
Large Pre-Fab Manufacturer uses P6-Loader to get control over their planning, scheduling and cost controls.

Learn more

See Case Studies for all tools...

Videos


Blogs

P6-Loader, Excel, Primavera P6 Add-Ons by EAI