Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Ways of importing numerous XER files

5 replies [Last post]
Konstantinos Papa...
User offline. Last seen 6 years 2 weeks ago. Offline
Joined: 5 Dec 2017
Posts: 2
Groups: None

Dear Professionals,

Is there a way of importing numerous XER files in P6 rather than importing one by one?

Replies

Mohammad Khan
User offline. Last seen 38 weeks 4 days ago. Offline
Joined: 7 Aug 2014
Posts: 7
Groups: None

Hi All

I am also trying to import multiple .xer files (49 nos) into P6 one shot and had tried the solution provided at the Oracle website (https://docs.oracle.com/cd/F25600_01/English/admin/p6_pro_importing_expo...) but unfortunately this command line script is not working

Tried multiple times but as it is written, P6 application start window appears

Trying this script on a local standalone database (SQLite)

Any advise 

Tom Boyle
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

Bookmarking Zoltan's procedure.

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

you can use the windows command line to import xer file this is hiow

To use the Windows command line interface to import an XER file  the following:

 

  • Make a copy or edit the actions.xml file to specify the EPS you want to import the project to, the layout you want to use, and the XER file you want to import from.

 

You can specify more than one import action in a single file, by including multiple <action> nodes.

The following is a sample actions.xml file that illustrates importing 2 XER files from the same script. All tags must appear in the file; however, you can leave some tags empty, as noted below. Values in bold are literal values you must enter as is. Values in italics are samples that will vary with your configuration.

<actions>

<action>

       <type>import</type>

<importFormat>XER</importFormat>

<importType>PROJECT</importType>

<importAction>CREATE</importAction>

<importTo>EPS1</importTo>

<importConfiguration>MyConfig1</importConfiguration>

<importFile>c:\somefile1.xer</importFile>

       </action>

<action>

       <type>import</type>

<importFormat>XER</importFormat>

<importType>PROJECT</importType>

<importAction>CREATE</importAction>

<importTo>EPS2</importTo>

<importConfiguration>MyConfig2</importConfiguration>

<importFile>c:\somefile2.xer</importFile>

       </action>

</actions>

  • Close the PM module if it is running.
  • From the Windows command line, or a batch file, or from code, you can issue a command in the following form from the folder where PM.EXE is located:

 

PM.EXE /username=<name> [/password=<name>] [/alias=<name>] /actionScript=<path> [/logfile=<path>]

 

for example it would look like this 

PM.EXE /username=admin /password=admin /alias=PMDB /actionScript=c:\somefolder\importprojects.xml /logfile:c:\somefolder\myLog.txt

If any values include spaces, enclose the value in double quotes (""). For example:

PM.EXE /username=admin /password=admin /alias=PMDB /actionScript="c:\some folder\importprojects.xml" /logfile="c:\some folder\myLog.txt"

Processing results are written to the log file, or you can echo them to the command line interface

Julian Nunez
User offline. Last seen 6 years 18 weeks ago. Offline
Joined: 12 Dec 2017
Posts: 2
Groups: None

The only way I think this is possible, is if the XER you are importing contains multiple projects.

i.e. if you open 12 projects at once in P6, it will let you export all of them in to a single XER.  Good luck.

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

what format are they to begin with  ? one large file or multiple individual files ?