PlanAcademy - Learn Oracle Primavera

Plan Academy

Join The Team
  • About Plan Academy
  • Courses
  • Training for Teams
  • Blog
  • Video Channel
  • Contact
  • Login
PlanAcademy - Learn Oracle Primavera

Project Controls Training & Courses

Join The Team
  • About
    • Who We Are
    • Testimonials
    • Join The Team
    • Contact Us
  • Courses
    • All Courses
    • Course Bundles
    • Primavera P6 Professional
    • Construction Planning & Scheduling
    • Advanced P6 Schedule Building
    • Advanced P6 Progressing
    • Forensic Schedule Delay Analysis
    • Analyze P6 Schedules with ScheduleReader
  • Solutions For
    • Companies
    • Individuals
  • Case Studies
  • Resources
    • Blog
    • Video Channel
    • Webinars
    • Guides & Templates
    • Knowledgebase
  • Partnerships
    • Deltek Acumen
  • Login
Blog > Import / Export

Importing and Exporting Data - Primavera P6

Browse our helpful tutorials on importing and exporting data from Oracle Primavera P6.

One Trick to Export P6 Resource Assignment Data to Excel

62 Comments
One Trick to Export P6 Resource Assignment Data to Excel

As you know Primavera P6 has a lack of graphical features so often we schedulers need to export everything to other software packages (mostly Excel) to produce an understandable schedule and graphs. I always had a problem when I export P6 resource assignment data to Excel with the standard exporting feature on P6 until I found a way to leverage the Reports feature. Here you can use the current

Read more

How to clean a Primavera P6 XER file using the XER File Parser

11 Comments
How to clean a Primavera P6 XER file using the XER File Parser

In the third part of our Primavera P6 databases and data cleansing series, we will show how to use the parser to clean an xer file In the third part of our Primavera P6 databases and data cleansing series, we will show how to use the parser to clean an xer file.  But if you haven't read them go back and read: XER File Parser Excel utility Part 1: 6 Ways to Clean Up Your Primavera Database

Read more

Understanding Primavera XER Files

47 Comments
Understanding Primavera XER Files

In this second part of Primavera P6 databases and data cleansing series, we will discuss the data structure of an XER file, and how the XER File Parser & Builder works. As the XER File Parser is a manual process (it does not honour P6 business rules), it is handy for the user to have a working knowledge of the P6 database. That’s why in this P6 tutorial we will show a general overview of P6's

Read more

How To Import P6 Assignment Codes from Excel

3 Comments
How To Import P6 Assignment Codes from Excel

Perhaps you’ve noticed that as of December 2020, there are some new features in Primavera P6 EPPM (Enterprise Project Portfolio Management), which we are going to take a look at today. Specifically, we’ll talk about Assignment Codes, one of the new Primavera P6 features here to make our jobs easier. But only, of course, if you know how to use everything right. Note: If you didn’t read my last

Read more

Quickly Export From Primavera P6 To Excel

10 Comments
Quickly Export From Primavera P6 To Excel

Faster is better.  That should be Oracle Primavera's mantra.  Well, in this case it is! Exporting Primavera P6 data to Excel could not be faster & easier with this quick tip. Getting Primavera P6 Activity data into Excel is essential. Excel's data crunching, grouping, pivoting and filtering is just so much easier to use than Primavera P6's. Even generating S-curves and graphs is better in

Read more

How To Import & Export Activity Layouts in Primavera P6

17 Comments
How To Import & Export Activity Layouts in Primavera P6

Primavera P6's Activity Layouts can be a super-feature for helping you to plan, analyze, and progress a schedule. But what about exporting Activity Layouts to other copies of Primavera P6? In this post I'll show you how to import and export those precious Primavera P6 Activity Layouts. The Activity screen is where we spend 95% of our time as Primavera P6 users. Having a facility to configure

Read more

Open Zipped XER files in Primavera P6 v18 – New Feature

4 Comments
Open Zipped XER files in Primavera P6 v18 – New Feature

As of Primavera P6 version 18, you can now import zipped XER files directly into Primavera P6. There's no need to uncompress them first. Primavera P6 will read the zip archive directly. Check out our zipped xer files video tutorial to see firsthand how it all works....and also what doesn't

Read more

Translate A Primavera P6 Project To A Different Language

18 Comments
Translate A Primavera P6 Project To A Different Language

It's surprising to me how many people across so many countries have been helped by Plan Academy's Primavera P6 tutorials & training. I mean I know I'm tooting my own horn here, but it's not to be an egotist. When I first started blogging about Primavera P6 in 2011, and I would gaze daily at my little Google Analytics screen that would inform of what sort of visitors were visiting our site. I

Read more

How to Clean Your P6 POBS Table On MSSQL & Oracle DB

19 Comments
How to Clean Your P6 POBS Table On MSSQL & Oracle DB

In my last post I went deep on how to quickly clean POBS data from a Primavera P6 XER file using a simple text editor. And we discovered that removing POBS data from an XER file greatly improved the import time for large XER files. A big thanks to readers who left comments on that post letting me and you know that there are some 3rd party tools (free and paid) that handle this in a more automated

Read more

XER File Slow To Import to P6? Try Cleaning POBS Data

48 Comments
XER File Slow To Import to P6? Try Cleaning POBS Data

The other day one of our Plan Academy members called our support line with an unusual P6 problem. I'm always happy to help out our members solve P6 problems, even when it's 4:30pm on the Friday afternoon before I'm off on a full week of vacation.... OK. Full disclosure here. I had already powered down my laptop for the weekend and was just about to grab something ice-cold and carbonated when the

Read more

What is a .PLF File And How Do I Open It in Primavera P6?

17 Comments
What is a .PLF File And How Do I Open It in Primavera P6?

A .plf file is a Primavera Layout File that stores information about screen layouts. If you're having trouble opening a .plf file, let me show you how it's done using Primavera P6. Opening A PLF File In Primavera P6 A .plf file can't be double-clicked in your file browser in order to open it in P6. Double-clicking it doesn't work, and typically Windows will try to open it in some unrelated

Read more

Compare XER Files With Change Inspector

19 Comments
Compare XER Files With Change Inspector

What's the easy way to compare XER files? Are you an owner or client who uses Primavera P6 but has to review a schedule that is constantly being updated from a 3rd party? When receiving an updated schedule, a few common questions might include: What actuals data was changed since the last update? Were any activities added or deleted and how do I find them? Were there any other

Read more

The One Indicator That Can Foil Your Excel Import into Primavera P6

16 Comments
The One Indicator That Can Foil Your Excel Import into Primavera P6

There is the temptation to think that because you can export a data field from Primavera P6 to Excel that you can import the same data field back to Primavera P6 after manipulating the field’s data in Excel. If you have ever imported data into Primavera P6 using Excel, you would have experienced instances where despite getting the familiar message of a successful import, some of the changes you

Read more

What is XML [in under 100 words]

6 Comments
What is XML [in under 100 words]

XML is a computer language originally developed for the web to be a companion to HTML. Because XML is so versatile, you'll find it in lots of software packages, including Primavera. XML is perfect for storing and exchanging database data between incompatible systems but has other uses too. XML stands for Extensible Markup Language - I know.....<snore>. What IS interesting is that anyone can

Read more

Import an XER File From a Newer Version of Primavera P6

25 Comments
Import an XER File From a Newer Version of Primavera P6

To import a newer version XER file to an older version of Oracle Primavera P6 installed on your computer, follow this quick fix. 1) Open the XER file in any text editor like Windows Notepad.  2) On the very first line, you should see the version of Oracle Primavera P6 that this XER file was saved in. Edit the version in the file to match the version installed on your machine. You can check

Read more

How To Link A P6 Schedule To The BOQ With Different Levels Of Detail

11 Comments
How To Link A P6 Schedule To The BOQ With Different Levels Of Detail

Tutorial Files Excel Spreadsheet (Excel 2007+): PlannerTuts_BOQ_Pay_Item.xlsx P6 Schedule and BOQ challenges A contract's Bill of Quantities is always meant to be more details than the schedule, at least in theory. In many cases,  the planner and the estimator are not working in perfect coordination and you may end with two different level of details for the same project. In case you need

Read more

[Ask Plan Academy] How To Remove Resources From A Primavera P6 Schedule For My Client?

8 Comments
[Ask Plan Academy] How To Remove Resources From A Primavera P6 Schedule For My Client?

Plan Academy, I have to send my client a copy of my schedule every month. But the client would like me to exclude any resourcing information in the copy that I send them. How can I easily remove resources in the copy of the project I send to my client?Signed, Geoff.  Geoff, it turns out that this is easily accomplished in Primavera P6 with the features included in the software's smart project

Read more

Solve Primavera P6 Import from Excel Problems with ASAP Utilities

46 Comments
Solve Primavera P6 Import from Excel Problems with ASAP Utilities

  Many P6 users have trouble importing data from Excel.  Many of the problems are focused on importing costs or other numeric data fields that have been manually typed into Excel. Why can't I import Primavera P6 cost data from Excel? Primavera P6 only imports data that is formatted as "Text" in Excel.  If you have manually typed in a value like "$32000" into an Excel cell, Excel will

Read more

Video: Import Primavera P6 Updates from Excel

53 Comments
Video: Import Primavera P6 Updates from Excel

Occasionally we revisit some of our reader's favourite posts from the annals of the Plan Academy tutorial library, and today we're revisiting a topic that is always hot - importing updates from excel. Let's take a look! Often large projects demand many sub-teams or subcontractors update a portion of the master project plan on an on-going basis. If your subcontractors are not up to speed on

Read more

Approve Updates from Subcontractors using Reflection Projects in Oracle Primavera [Video]

32 Comments
Approve Updates from Subcontractors using Reflection Projects in Oracle Primavera [Video]

Featured this week is a great way to use Primavera P6 Reflection projects.  If you've perused our other Primavera P6 tutorials, you may already know reflection projects are great for working with and managing scenarios.  But they can also provide a way to preview and selectively approve activity updates from sub-contractors or other groups. The key to getting project updates to merge back to a

Read more

Using Primavera’s .Xer File Parser – Import WBS From Excel Without The SDK

69 Comments
Using Primavera’s .Xer File Parser – Import WBS From Excel Without The SDK

In this tutorial we explain how to import a WBS dictionary in Primavera P6 without the SDK.   NOTE: The steps needed to transform a classical WBS presentation (which is WBS Path and Description) to a format understood by the database (which is parent / child) is covered in Steps 1 to 6 of this tutorial. To load the WBS data into Primavera P6, instead of using the SDK we will use the XER File

Read more

How To Import WBS From Excel To Primavera P6 Using The SDK

37 Comments
How To Import WBS From Excel To Primavera P6 Using The SDK

In this tutorial we explain how to use the Oracle Primavera P6 SDK to import a WBS from Excel to Primavera P6. We are using the WBS.xls P6 SDK spreadsheet made available by Oracle Support. The SDK is a very handy tool, but the data must exactly respect the required format, we used a sample WBSand a step-by-step guide to prepare the data to be imported. We assume you already have the Primavera SDK

Read more

Using Primavera P6 Filters On Export To Excel

19 Comments
Using Primavera P6 Filters On Export To Excel

Primavera's custom Activity filters are great for focusing in on a subcontractor's work list or even to hide Activities that are already completed.  But when it comes to filtering down a 5000 line project plan to Activities in a specific timeframe, P6's filters fall flat.  Here's the Gotcha: any filter that uses a rolling date or P6's built-in date variables will not work when exporting P6 data to

Read more

Browse Primavera P6 Topics

  • Activity Codes
  • Administration
  • Analysis
  • Ask Plan Academy
  • Construction
  • CPM Scheduling in Primavera P6
  • Critical Path
  • eBooks
  • Excel
  • General
  • Guides
  • IT
  • Learning
  • News
  • Oil & Gas
  • P6 EPPM
  • Planning
  • Primavera P6 Reporting
  • Primavera P6 Tutorials
  • Progressing
  • Project Controls Tips & Tutorials
  • Project Management
  • Resource Management
  • Software
  • Trends
  • Turnarounds
  • Videos

Company

  • About Plan Academy
  • Case Studies
  • Join The Team
see our reviews on g2crowd



We accept the following:

Training & Support

  • Courses
  • Training for Teams
  • Free Webinars
  • Free Resources
  • Blog
  • Help Center

Legal Stuff

  • Terms & Conditions
  • Privacy

Connect

Contact Us

Customer Support

Plan Academy Inc.
Hamilton, ON Canada.

1-877-626-2690

Follow Us:

Copyright © 2023 Plan Academy Inc. · All Rights Reserved ·