XER-Splitter
XER-Splitter copied to clipboard
A tool to handle the parsing of Oracles Primavera P6 XER output files
XER-Splitter
A tool to handle the parsing of Oracles Primavera P6 .XER output files. Convert your .XER files into seperate CSVs for parsing and transforming in other tools (eg. PowerBI for reporting)
Features include
- CSV or XLSX output of .XER files
- GUI and CLI available
- Optionally ignore problematic RISKTYPE & POBS tables
- Basic metrics (Total tables & rows)
- Sample XERs here
Installation
Command line
Use pip to install XER-Splitter:
pip install xersplitter
This puts xersplitter on the PATH, allowing you to invoke the gui or use the command line arguments.
GUI
Alternatively if you just want the gui, the latest build (windows .exe) can be found here or you can build the file yourself using pyinstaller from the root folder
pyinstaller xersplitter/Splitter.py --onefile
Usage
usage: xersplitter [-h] [-csv | -xlsx] [-i] [-o] [-cli] [-a]
A script to parse those pesky .xer files from Primavera P6
optional arguments:
-h, --help show this help message and exit
-csv Comma seperated output
-xlsx Excel file output
-i , --inputFile The path to the input .xer file
-o , --outputDir The directory where the output files will be placed
-cli, --suppressGui Hide the GUI - opens by default
-a, --allTables Parse all tables - Skips possibly problematic RISKTYPE & POBS tables by default