P6-Loader

Automate Primavera P6 data loading and updating. Import and export 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
  • Import and export global and project data with hierarchy and logic between Microsoft Excel and Primavera P6

Latest Version - Highlights

  • Welcome to P6-Loader
  • P6-Loader Control Page
  • Extraction
  • P6-Loader Activity Sheet
  • Copy Layouts, Filters, Reports and Global Changes
  • Global Calendar Usage Sheet
  • Simplify all Primavera P6 data loading and updating using the ease of Microsoft Excel.
  • From the main screen, everything P6-Loader can do is at your fingertips, including the ability to remove POBS and RISK TYPES from an XER before you import it and convert an XER or XML to a P6-Loader friendly file.
  • Extract multiple pieces from as many or as few modules as you want. User, Global, Project and Activity data can be selected, as well as one or many Projects. Multiple utilities are provided to analyze where data is used, combine duplicate Activity Codes and demote Activity Codes and Calendars.
  • 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.
  • Copy layouts, filters, reports and global changes from one database to another without “breaking” them. Exporting and importing from one database to another tends to render the layout in the destination unusable. This is due to P6 using the unique table identifier in each database, rather than the actual data name.
  • 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.
  • Welcome to P6-Loader
  • P6-Loader Control Page
  • Extraction
  • P6-Loader Activity Sheet
  • Copy Layouts, Filters, Reports and Global Changes
  • Global Calendar Usage Sheet

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

Resources

Brochures

Videos

Recent Blogs

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