Ways of importing numerous XER files

Member for

11 years 3 months

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_exp…) 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 

Member for

18 years 11 months

Bookmarking Zoltan's procedure.

Member for

16 years 3 months

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

Member for

7 years 10 months

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.

Member for

16 years 3 months

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