As a forensic programmer, I go to many different companies - I am often sent multiple xer files to analyse. Is there any way of importing more than one xer file at a time? I understand that you can export multiple file as one xer, but often we don't have this advantage.
Importing Multple XER files
Forum Sponsor
Top Posters
Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
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
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.
I beilive that you can also import them therough a command prompt
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.
Hi David, did you get assistance regarding multiple XER importing? if you did do you mind sharing the solution please.
Contact me with your exact needs and I will include this capability in the next version of XER Manager software. Regards, [email protected]
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 [email protected]
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