It depends on what you are looking to do with the XER Files.
The Command line utility can only create new projects & cannot update existing projects - not sure if there is a speed advantage in using this option as the Primavera Desktop application is not open during this import process. This will require some understanding of creating batch files & modifying XML Files to enable this to work. I have only used this for file exports & not tried the import option.
I would personally not recommend going down the xerFileParserBuilder route to merge multiple xer files, unless you really know the structure of the XER files & that you confirm thtat there is no duplicate key values in all the XER files - potential to corrupt yor entire database this way. It is also likely to take you longer to do this than just importing the files normally!
Please note that while the xerFileParserBuilder can be utilised to modify xer files, it also has the potential to create errors in your database. Calendar Data can grow considerably depending on how many calendar exceptions there are in the source database - excel has a maximum size limit for the amount of data each cell can contain & there is a potential that this could be exceeded. Activity Notebooks is another area where this data cropping may occur. Not saying not to use it - just to use caution!
If you are looking to compare XER files that contain the same project to allow comparisons, then you will be best looking to import each one separately so that if required you can rename the projects on import (in my opinion anyway).
I would also suggest having different databases if possible for each client, as there is potential for global data to be changed between the different companies (easy to do if using an SQLite Database format).
Regards,
Steven
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Fri, 2021-09-24 02:19
Yes, you can use the window explorer to import multiple xer like a batch file import. If the XER default program is P6 Primavera, you can highlight all XER to be imported and right click. Select Open. (It is recommended the P6 is already open, so you don't need to login.) Depending on how many xer you are going to import, it may take a couple of seconds before the P6 window import will show and it will import the xer one by one like a batch import.
Member for
16 years 3 months
Member for16 years3 months
Submitted by Zoltan Palffy on Thu, 2021-09-23 15:45
If you are familiar with xerFileParserBuilder, you can combine all the xer into one xer and import it as one (assuming that the xer's are separate files). Otherwise, you can use a 3rd party software available in the market.
Contact me with your exact needs and I will include this capability in the next version of XER Manager software. Regards, greg.horsfall@fortiorglobal.com
Member for
20 years 11 months
Member for20 years11 months
Submitted by Greg Horsfall on Thu, 2011-12-22 21:43
I am willing to add functionality to the XER Manager product to facilitate a solution. If you could please send me your exexact requirement. Maybe a batch merge into one XER file is is an option also. I have some ideas on how to loop through a folder of files importing automatically but would appreciate your input. Regards Greg.Horsfall@fortiorglobal.com
Member for
22 years 9 months
Member for22 years9 months
Submitted by Alexandre Faul… on Wed, 2011-11-30 16:59
you cannot open several XER files together; when you export several projects together, you create only ONE XER file; when you import an XER file, you may select the projects you need to import into PM
Member for
8 years 1 monthDavid,It depends on what you
David,
It depends on what you are looking to do with the XER Files.
The Command line utility can only create new projects & cannot update existing projects - not sure if there is a speed advantage in using this option as the Primavera Desktop application is not open during this import process. This will require some understanding of creating batch files & modifying XML Files to enable this to work. I have only used this for file exports & not tried the import option.
I would personally not recommend going down the xerFileParserBuilder route to merge multiple xer files, unless you really know the structure of the XER files & that you confirm thtat there is no duplicate key values in all the XER files - potential to corrupt yor entire database this way. It is also likely to take you longer to do this than just importing the files normally!
Please note that while the xerFileParserBuilder can be utilised to modify xer files, it also has the potential to create errors in your database. Calendar Data can grow considerably depending on how many calendar exceptions there are in the source database - excel has a maximum size limit for the amount of data each cell can contain & there is a potential that this could be exceeded. Activity Notebooks is another area where this data cropping may occur. Not saying not to use it - just to use caution!
If you are looking to compare XER files that contain the same project to allow comparisons, then you will be best looking to import each one separately so that if required you can rename the projects on import (in my opinion anyway).
I would also suggest having different databases if possible for each client, as there is potential for global data to be changed between the different companies (easy to do if using an SQLite Database format).
Regards,
Steven
Member for
19 yearsYes, you can use the window
Yes, you can use the window explorer to import multiple xer like a batch file import. If the XER default program is P6 Primavera, you can highlight all XER to be imported and right click. Select Open. (It is recommended the P6 is already open, so you don't need to login.) Depending on how many xer you are going to import, it may take a couple of seconds before the P6 window import will show and it will import the xer one by one like a batch import.
Member for
16 years 3 monthsI beilive that you can also
I beilive that you can also import them therough a command prompt
Member for
19 yearsIf you are familiar with
If you are familiar with xerFileParserBuilder, you can combine all the xer into one xer and import it as one (assuming that the xer's are separate files). Otherwise, you can use a 3rd party software available in the market.
Member for
13 years 11 monthsHi David, did you get
Hi David, did you get assistance regarding multiple XER importing? if you did do you mind sharing the solution please.
Member for
20 years 11 monthsContact me with your exact
Contact me with your exact needs and I will include this capability in the next version of XER Manager software. Regards, greg.horsfall@fortiorglobal.com
Member for
20 years 11 monthsI am willing to add
I am willing to add functionality to the XER Manager product to facilitate a solution. If you could please send me your exexact requirement. Maybe a batch merge into one XER file is is an option also. I have some ideas on how to loop through a folder of files importing automatically but would appreciate your input. Regards Greg.Horsfall@fortiorglobal.com
Member for
22 years 9 monthsDavid,you cannot open several
David,
you cannot open several XER files together; when you export several projects together, you create only ONE XER file; when you import an XER file, you may select the projects you need to import into PM