Wednesday 18 May 2022

Export Oracle Primavera P6 EPPM Project Data to P6 XML using Excel

If you have an option of exporting project out of Oracle P6 EPPM application using excel, will you use it?

Introducing new excel utility that will let you do just that. It will let you select one or multiple projects and export it to the directory of your choice on your desktop. You can optionally export baselines along with the project. There is no restriction on number of projects that you select to export. You can export all projects in your Oracle Primavera P6 EPPM application using this excel utility.


The excel utility uses P6 web services to export projects. As a result, exporting the project using this excel utility will not impact the performance of P6 EPPM application or P6 Professional.

Projects are downloaded in XML format. Each project is downloaded to the export folder specified. This will avoid navigation in the P6 EPPM application to multiple screen to select the project and then download project file.

To use the excel utility 

  • Enter P6 application login credential. You are required to have access to P6 web services. 
  • Select the folder where P6 Project XML files will be saved. 
  • Click Read Project button to fetch P6 projects based on user access to the Project worksheet
  • Mark the projects in the column Export Project as "Y" that you want to export.
  • Click on Export Projects to export selected projects.
  • Verify the P6 Project XML file in the Export Folder.


Download the file from here. Drop me a message, if you are unable to download evaluation copy.


No comments:

Post a Comment

About Me

My photo
Over 20 years of experience in providing integration software solutions to various industries.Handled numerous projects implementing Primavera P6 EPPM, P6 Analytics, P6 BI Publisher Reports, Oracle BPM, SOA Suite, Primavera Gateway, Oracle Unifier, Instantis EnterpriseTrack, Oracle E-Business Suite.

Developed integration solution around these products and with ERP and legacy systems.

Designed excel utilities to quickly load and maintain data in excel for these products.

Connect with me on LinkedIn

Popular Posts

Contact Form

Name

Email *

Message *