Executive Summary

This article delves into the comparative analysis of XER (Primavera Exchange Format) and XML (Extensible Markup Language) file formats, focusing on their use in Oracle’s Primavera P6 for project management. We examine the structural aspects, usage contexts, and the implications these formats have on data analysis and project management, with a special emphasis on the file size differences and the functionalities offered by ProjectControls.online in mitigating some of the inherent limitations of these formats.

Introduction

In project management environments using Oracle’s Primavera P6, choosing between XER and XML for data exchange is crucial for maintaining data integrity and facilitating effective analysis. Understanding their characteristics and limitations is essential for project managers and analysts.

XER: An Overview

• Definition: A proprietary file format for Primavera P6.
• Usage: Primarily for data exchange within Primavera software.

XML: An Overview

• Definition: A versatile, text-based format for broad data exchange applications.
• Usage: Widely used across various platforms for data interchange. While the language type is the same across platforms, the data structures are specific to the platform.

Comparative Analysis

Similarities

1. Text-Based Formats: Both are accessible in text format.
2. Structured Data Representation: Organize data systematically—XML with tags, XER in a tabular format.
3. Data Exchange Tools: Facilitate data interchange in their respective domains.

Differences

1. Flexibility: XML technically offers more flexibility because many platforms use XML. Though while XML is used by many platforms the data structure is proprietary and specific to P6 alone. XER, while exclusively proprietary, is somewhat easier for the average user to read.
2. Standardization: XML is globally standardized format (although customized to the specific data structure), whereas XER is specific to Primavera P6.
3. Data Sets: XML only provides the standard schedule data (dates/logic/calendars) expecting Primavera to re-perform the calculations upon import. XER, on the other hand, provides nearly all calculated fields as well as the standard schedule data. This is critical if the analysis is outside Primavera
4. File Size: Remarkably, XML files are about 100 times larger than their XER counterparts for the same project. This size difference is attributed to the verbosity inherent in the XML language. This also makes sharing XML files (especially via email) more difficult as many email services have file size limitations.

Primavera Import/Export Options

• XML Advantages: Primavera provides more extensive import/export options with XML.
• XER Advantages: Export multiple projects simultaneously with all of their data in about 1/100th the size of XML.

Overcoming XER Import/Export Limitations with PC.o

• Conversion and Customization: ProjectControls.online offers functionalities to convert or modify global information into project-specific data.
• Data Removal: Capabilities include stripping cost/resource information where necessary.
• Enhanced Flexibility: These features provide a workaround for some of XER’s restrictive aspects.

Data Completeness and Analysis Implications

XML’s Limitations in Project Management

• Absence of Calculated Fields: XML lacks all calculated fields necessary for analysis (i.e. Total Float).
• Imprecise Data Analysis: ProjectControls.online, and any other analysis software, need to recreate calculated fields which will not be as precise as from the source via XER.

XER’s Comprehensive Data

• Inherent Data Richness: XER files include more complete data, including calculated fields.
• Accurate Analysis: Leads to more reliable project analytics.

Conclusion

XER files, despite having fewer import/export options compared to XML, offer a richer data set for project analysis for Primavera P6. While XML is arguably a better portable file structure. The file size of XML is too robust, it’s likely that Primavera excluded calculated fields in XML exports in order to keep the file size “reasonable”. 

Since XML excludes calculated fields from the structure this leaves XER the clear winner in terms of available data for analytics, both for it’s more complete data, and the file size portability. ProjectControls.online can play a pivotal role in addressing some of these disparities in terms of data import options. It enhances the usability of XER through advanced features, compensating for its limitations and enabling more comprehensive project management and analysis.

---

Disclaimer: This post is based on current understanding and may not reflect the latest software updates or technological advancements.