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.

Export menu โ€” Excel, CSV, and project-file formats including PMXMLExport menu โ€” Excel, CSV, and project-file formats including PMXML

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