My Oracle Support Banner

Double-Quote Marks in Field Data Are Doubled When Exporting a Project to XER in P6 Professional (Doc ID 2968536.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 23.4 to 23.7 [Release 23.4 to 23.7]
Primavera P6 Professional Project Management - Version 22.12 to 22.12.7.0 [Release 22.12]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

When exporting a project to XER format in P6 Professional, any double-quote (") characters in Activity data are repeated - for example, in a field containing 1.5" the data is converted to 1.5"" in the XER file (and when importing the XER file, the doubled characters are imported to the P6 database).  This does not occur when exporting a project to XER via P6 Web.

EXPECTED BEHAVIOR

Double-quote characters should not be doubled in XER files.

 

The issue can be reproduced at will using the following steps.

  1. In P6 Professional, create a new project.
  2. Add an Activity, accept the default Activity ID, and enter an Activity Name such as 1" straw tube.
  3. Export the new project to to Primavera XER format.
  4. Open the .XER export file in in a text editor (ex. Notepad).
  5. Find the Activity Name in the TASK table and notice that the activity name is 1"" straw.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.