Emerald Associates

Suite 140, bldg B8, 2526 Battleford Ave SW
Calgary, AB   T3E 7J4 Canada

Solution Name


Solution Summary

The Emerald P6-Loader is a flexible and secure solution to automate data entry processes and load project data and dictionaries from Excel into Primavera P6. This solution can create and update data in the Primavera database, going above and beyond Primavera P6’s built-in import functionality.

Solution Profile

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.

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 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.

The modules included in the P6-Loader 4.0 are:



  • EPS
  • EPS Spending Plan
  • Project Code Type
  • Project Code Values
  • Activity Code Type
  • Activity Code Values
  • User Defined Fields
  • Users
  • User Security Profiles
  • Cost Account
  • Calendar
  • OBS
  • User OBS Mapping


  • Projects
  • Project Details
  • Project Benefit Plans
  • Project Spending Plans
  • Baseline Project
  • WBS
  • WBS Categories
  • WBS UDF Assignments


  • Activity Details
  • Relationships
  • Resource Assignment
  • Activity Expenses
  • Activity Steps
  • Activity Code Assignments
  • Activity UDF Assignments


  • Roles
  • Role Limits
  • Role Rates
  • Role Teams
  • Resources
  • Resource Rates
  • Resource Code Types
  • Resource Codes
  • Resource Code Assignments
  • Resource Teams
  • Bucket Planning

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.

Distinguishing Features

User friendly

  • Web or client based
  • Update baselines without restoring those baselines into projects

Saves Time

  • Load into all of the data dictionaries within P6 (EPS, OBS, Resources, Roles, Activity Codes, Project Codes, Resource Codes, Cost Accounts, etc) and create User Defined Fields and missing code/dictionary values


  • Streamline project updates from contractors without giving access to P6 using a more robust approval process than Reflection allows

Saves Money

  • Load information into P6 from another system without building a dedicated integration program (expenses, timesheet hours, etc.)
  • Allows third-party users to import data from Excel without making them Project Superusers in P6
  • Works through P6 API so P6 security is respected and data is always supported by Oracle

Solution Name


Solution Availability



  • Aerospace and Defense, Automotive, Chemicals, Communications, Consumer Goods, Education and Research, Engineering and Construction, Financial Services, Healthcare, High Technology, Industrial Manufacturing, Insurance, Life Sciences, Media and Entertainment, Natural Resources, Oil and Gas, Professional Services, Retail, Public Sector, Travel and Transportation, Utilities, Wholesale Distribution

Oracle Products

  • Applications
  • Oracle Project Portfolio Management

Company Size Solution is Targeting

No data available.

Open Source Solutions


About Emerald Associates

Company Description

Since 1995 Emerald's dedicated team of project managers, engineers and programmers have been implementing, customizing, integrating and training on the complete Oracle Primavera product line. We pride ourselves on delivering best-of-breed project management solutions to a perse client base. We also strive to go above and beyond the basic delivery of Oracle Primavera software through the development of integrations, conversions, automations, unique Primavera enhancement tools, engineered systems and cloud solutions that help our clients get the most out of their Oracle Primavera investment.



  • Needs Assessment
  • Implementation Services (On-Premise & Cloud Solutions)
  • Software Integration and related services
  • Migration Services
  • Business Process Development
  • Turnaround/Shutdown/Outage Planning
  • Scheduling Assistance
  • Risk Analysis
  • Staff Augmentation
  • Oracle Primavera Training
  • Engineered Systems
  • Primavera-In-A-Box
  • Hosting
  • Primavera Managed Services
  • Cloud Managed Services
  • Oracle Management Cloud
  • Primavera SaaS Cloud
  • Hybrid Primavera Cloud
  • Oracle IaaS for Primavera Cloud
  • Maxavera Support Services


In addition to specializing in the Oracle Primavera product line, Emerald is also a world class software development house. Our toolkit contains data loading, auditing, archiving and migration tools for Primavera P6, PCM and Unifier that reduce data entry, streamline reporting and fast-track updating for Turnaround, Capital and IT projects. Our unique Primavera enhancements tools include:


P6 Add-Ons

PCM Add-Ons


Integrations with Oracle Primavera Products

  • SAP®
  • Oracle EBusiness Suite®
  • JD Edwards®
  • Microsoft Dynamics®
  • Microsoft SharePoint®
  • Sage Timberline Accounting
  • Lawson Accounting®
  • Intuit QuickBooks®
  • AssetWorks FleetFocus M5®
  • B2W®
  • Indus PassPort®
  • IBM Maximo® and QByte®
  • FileNet®
  • Peloton SiteView®
  • Peloton WellView®
  • Energy Navigator AFENavigator®
  • CGI PVR®
  • Intentia Movex®
  • OpenText LiveLink®


1000+ Historical Projects Migrated From Other Systems

  • Revere IMMPOWER® EAM
  • Jacobs Engineering former scheduling system CASP®
  • Artemis®


Enterprise Reporting Engines Used

  • Oracle Business Intelligence
  • Oracle Primavera Analytics with OBIEE
  • Oracle's Hyperion BRIO®
  • Microsoft's Reporting Services®
  • SAP Business Intelligence


Development Technologies Used for Oracle Primavera Products

  • Flex®
  • WebServices®
  • JAVA
  • VBA
  • .Net

Past Primavera Certifications

  • Primavera Authorized Partner
  • Primavera Authorized Representative
  • Exclusive Canadian Primavera Premiere Solutions Provider


View Partner Profile

Integrated Cloud Applications & Platform Services