Skip to main content

Export to XML (PMXML)

Applies to: Pro · Enterprise Last updated: 27-Feb-2026

Overview

Export your schedule as an Oracle PMXML v22 file — the native XML format used by Oracle Primavera P6 for structured data interchange. This format preserves the project hierarchy, activities, relationships, and calendars in a well-formed XML document.

Prerequisites

  • Active Pro or Enterprise subscription
  • At least one schedule loaded
  • Export → Primavera XML (.xml) from the Export menu

PMXML Format

The PMXML schema follows this structure:

<APIBusinessObjects>
<Project>
<Activity>...</Activity>
<Relationship>...</Relationship>
<WBS>...</WBS>
<ProjectCalendar>...</ProjectCalendar>
</Project>
</APIBusinessObjects>

Exported Elements

Project

ElementDescription
ProjectIdProject short name
NameProject full name
PlannedStartDatePlanned start
MustFinishByDatePlanned finish
DataDateLast schedule calculation date
ScheduledFinishDateCalculated project finish
StatusPlanning, Active, or Complete

WBS

ElementDescription
WBSObjectIdUnique WBS node ID
CodeWBS code
NameWBS node name
ParentObjectIdParent WBS node ID
SequenceNumberSort order

Activity

Each activity maps to an Activity element:

ElementMappingFormat
ActivityObjectIdtask_idInteger
ActivityIdtask_codeString
ActivityNametask_nameString
ActivityTypeSee type mappingString
StatusSee status mappingString
PlannedStartDateearly_start_dateISO 8601
PlannedFinishDateearly_end_dateISO 8601
ActualStartDateact_start_dateISO 8601
ActualFinishDateact_end_dateISO 8601
RemainingDurationremain_drtn_hr_cntPT_n_H format
PlannedDurationtarget_drtn_hr_cntPT_n_H format
AtCompletionDurationcalculatedPT_n_H format
TotalFloattotal_float_hr_cntPT_n_H format
FreeFloatfree_float_hr_cntPT_n_H format
EarlyStartDateearly_start_dateISO 8601
EarlyFinishDateearly_end_dateISO 8601
LateStartDatelate_start_dateISO 8601
LateFinishDatelate_end_dateISO 8601
PhysicalPercentCompletephys_complete_pctDecimal
PrimaryConstraintTypecstr_typeString
PrimaryConstraintDatecstr_dateISO 8601
CalendarObjectIdclndr_idInteger
WBSObjectIdwbs_idInteger

Activity Type Mapping

Internal TypePMXML ActivityType
TT_TaskTask Dependent
TT_MileStart Milestone or Finish Milestone
TT_LOELevel of Effort
TT_WBSWBS Summary

Activity Status Mapping

Internal StatusPMXML Status
TK_NotStartNot Started
TK_ActiveIn Progress
TK_CompleteCompleted

Relationship

ElementDescription
PredecessorActivityObjectIdPredecessor activity ID
SuccessorActivityObjectIdSuccessor activity ID
TypeSee relationship type mapping
LagDuration in PT_n_H format

Relationship Type Mapping

Internal TypePMXML Type
PR_FSFinish to Start
PR_SSStart to Start
PR_FFFinish to Finish
PR_SFStart to Finish

Calendar

ElementDescription
CalendarObjectIdUnique calendar ID
CalendarNameCalendar display name
CalendarTypeGlobal, Project, or Resource

Duration Format

All durations in PMXML use the ISO 8601 duration format:

HoursPMXML Format
8PT8H
40PT40H
80PT80H
0PT0H

Export Process

  1. Select Export → Primavera XML (.xml) from the Export menu
  2. The export generates immediately
  3. The browser downloads the .xml file

File Naming

{project_name}_{YYYY-MM-DD}_pmxml.xml

The _pmxml suffix distinguishes this from the MSPDI XML export.


Limitations

LimitationDetail
No resourcesResource definitions and assignments are not exported
No UDFsUser Defined Fields are not included
No activity codesActivity code definitions and assignments are not exported
No calendar work-day dataCalendar elements include metadata but not detailed work-week patterns or exceptions
Single projectOnly one project per file

PMXML vs XER Comparison

FeatureXERPMXML
FormatTab-delimited textXML
Tables17 full P6 tables5 element types
ResourcesYes (31 fields per resource)No
AssignmentsYes (47 fields)No
UDFsYesNo
Activity CodesVia UDF tableNo
Calendar detailWork patterns + exceptionsMetadata only
File sizeSmallerLarger
ReadabilityLow (tab-delimited)High (structured XML)
P6 CompatibilityFull importFull import

Recommendation: Use XER for full-fidelity P6 data exchange. Use PMXML when XML format is required by your workflow or integration tooling.


Tips & Best Practices

  • Use PMXML export when your recipient requires Oracle P6 XML format specifically
  • For the most complete data export, prefer the XER format which includes resources, assignments, and UDFs
  • PMXML files are human-readable — useful for debugging or data inspection
  • Some third-party scheduling tools accept PMXML as an import format