(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.
Hello All,
I have recieved an excel spreadsheet that contains about 500 rows and 8 columns.
The columns are:
Project Id
Project Name
and 6 other columns that match our Project Code directory.
My question is, do you know of a way that this spreadsheet can be used to create new projects in bulk?
Regards,
Rod
Printer-friendly version
Send to friend
guess they need a 64 bit version
Rodel, Zoltan,
Thank you both for the assistance. I had to install Office 365 32 bit version to get the Parser file running. All working as described now.
Much Appreciated.
Rod
Hi Zoltan,
Tyhanks for the file but I can't get it to run either, I am using Office 365, do I need an earlier version of Excel to have this working without errors?
Rod
sent file to Rodney
Hi Zoltan,
Would you please email those parser instructions? I can't get it to run, just errors of not finding file.
Rod
Hi Rod,
What is the error? Is it opening the xer or loading the excel parser?
Hi Rodel,
The parser fails, the error is
and then,
Thanks Rodel, I'll give it a try today.
Hi Zoltan,
Than picture hasn't come through properly so please email me.
rodney.jones@y7mail.com
rodney.jones@y7mail.com
here are the instructions
not sure why so smal but if u give me your email address I can send the word file
Hi Rod,
The purpose of creating 2 or 3 Project in P6 is to have sample data to see or review so you can familiarize on the data that will be exported to xer and excel by xerFileParser. Once you get the idea, you can just copy and paste the project id and project description on the correct field and populate the other fields. Let me know if there is any issues.
Hi Rodel,
Great, I will download it from that link.
Just to clarify, I want to auto-create projects without having to first create them in P6. I will be bringing approx 1,000 projects in. Here is a screen snip and attached is a sample spreadsheet with only 200 rows, but you get the idea.
(Hmmm, I can't insert the spreadsheet)
Zoltan, I have not included the other 6 columns as I am not concerned about them at the moment but they are columns that are mapped to some specific Project Codes that we have created.
| Project | Project Name |
| P.0005151 | HW7 East Sprayed Sealing |
| P.0005293 | Behavioural Speed |
| P.0005328 | Facilities around schools - Reactive |
| P.0005352 | HW7 West Sprayed Sealing |
| P.0005353 | HW6 Sprayed Sealing |
| P.0005354 | HW8 Sprayed Sealing |
| P.0005355 | HW11 Sprayed Sealing |
| P.0005356 | HW12 Sprayed Sealing |
| P.0005357 | HW18 Sprayed Sealing |
| P.0005358 | HW21 Sprayed Sealing |
| P.0005359 | HW22 Sprayed Sealing |
| P.0005360 | HW27 Sprayed Sealing |
| P.0005382 | HW29 Sprayed Sealing |
| P.0005383 | MR54 Sprayed Sealing |
| P.0005384 | MR56 Sprayed Sealing |
| P.0005385 | MR61 Sprayed Sealing |
| P.0005386 | MR70 Sprayed Sealing |
| P.0005387 | MR78 Sprayed Sealing |
| P.0005388 | MR245 Sprayed Sealing |
| P.0005389 | MR253 Sprayed Sealing |
| P.0005390 | MR310 Sprayed Sealing |
| P.0005391 | MR334 Sprayed Sealing |
| P.0005392 | MR359 Sprayed Sealing |
| P.0005393 | MR377 Sprayed Sealing |
| P.0005394 | MR410 Sprayed Sealing |
| P.0005395 | MR421 Sprayed Sealing |
| P.0005396 | MR516 Sprayed Sealing |
| P.0005397 | MR558 Sprayed Sealing |
| P.0005398 | MR559 Sprayed Sealing |
| P.0005399 | Reg Roads Broken Hill WC Sprayed Sealing |
| P.0005401 | HW17 MB3 Asphalt Resheeting |
| P.0005412 | HW5 Asphalt Resheeting |
| P.0005413 | HW7 East Asphalt Resheeting |
| P.0005547 | Reg Rds Block Grant Mid Western Regional |
| P.0005548 | Reg Rds Block Grant Bathurst Regional |
| P.0005558 | BalItem 21110 Passing Lanes OW |
| P.0005661 | HW17 Mogriguy Rehab |
| P.0005682 | HW5 Kirconnel Reconstruction |
| P.0005800 | Reg Rds Block Grant Warrumbungle Ccl |
| P.0005856 | BalItem 222021 Bridge Rebuilding OW |
| P.0005987 | BalItem 22114 Concrete Pavemt Rehab OW |
| P.0006018 | BalItem 21301 Flood Mitigation OW |
| P.0006044 | HW7 B4148 LH Ford Bdge Midspan |
| P.0006059 | BalItem 21106 Sealed Road Extension OW |
| P.0006118 | HW7 East Heavy Patching Auslink |
| P.0006120 | HW7 West Heavy Patch State |
| P.0006210 | HW18 Back Creek Road Widening |
| P.0006276 | HW18 Blackmans Flat Widen & Reshape |
| P.0006281 | HW17 Marsden Rehab |
| P.0006406 | HW5 Orange Road Services Culvert Repairs |
| P.0006586 | HW17 MB2 Heavy Patch Auslink |
| P.0006588 | HW17 MB3 Heavy Patch Auslink |
| P.0006590 | HW17 North Marsden Causeways |
| P.0006627 | HW8 B9239 Unnamed Creek |
| P.0006677 | HW8 Musheroo Widening |
| P.0006694 | LGRSO MOREE Projects |
| P.0006695 | LGRSO ORANGE Projects |
| P.0006696 | LGRSO DUBBO REGIONAL Projects |
| P.0006698 | LGRSO BATHURST Projects |
| P.0006699 | LGRSO MOREE Salary |
| P.0006700 | LGRSO ORANGE Salary |
| P.0006701 | LGRSO DUBBO REGIONAL Salary |
| P.0006826 | MR633 Sprayed Sealing |
| P.0006827 | MR633 Pavement Heavy Patch State |
| P.0006903 | LGRSO BATHURST Salary |
| P.0006904 | LGRSO PARKES Projects |
| P.0006905 | LGRSO PARKES Salary |
| P.0006906 | OCCUPANT RESTRAINT |
| P.0006907 | Reactive Speed Zone Reviews |
| P.0006967 | BalItem 22201 Bridge Routine & Minor OW |
| P.0007113 | HW27 B4409 Plain Creek 22.12km NE Dubbo |
| P.0007161 | HW27 B4405 Ballimore Ck 33.84km NE Dubbo |
| P.0007182 | HW27 B4402 Spicers Ck 41.03km NE Dubbo |
| P.0007222 | B4B LR2580005 B1302 McKanes Bridge CoxsR |
| P.0007335 | HW5 B1036 Marrangaroo |
| P.0007421 | Reg Rds Block Grant Forbes Ccl |
| P.0007436 | Reg Rds Block Grant Gilgandra Ccl |
| P.0007463 | Reg Rds Block Grant Lachlan Ccl |
| P.0007468 | Reg Rds Block Grant Narromine Ccl |
| P.0007483 | Reg Rds Block Grant Parkes Ccl |
| P.0007488 | Reg Rds Block Grant Walgett Ccl |
| P.0007505 | Reg Rds Block Grant Warren Ccl |
| P.0007508 | Reg Rds Block Grant Weddin Ccl |
| P.0007584 | Reg Rds Block Grant Lithgow Ccl |
| P.0007591 | Reg Rds Block Grant Oberon Ccl |
| P.0007709 | Reg Rds Block Grant Broken Hill Ccl |
| P.0007734 | Reg Rds Block Grant Central Darling Ccl |
| P.0007766 | Reg Rds Block Grant Blayney Ccl |
| P.0007773 | Reg Rds Block Grant Bogan Ccl |
| P.0007776 | Reg Rds Block Grant Bourke Ccl |
| P.0007780 | Reg Rds Block Grant Brewarrina Ccl |
| P.0007803 | Reg Rds Block Grant Cabonne Ccl |
| P.0007810 | Reg Rds Block Grant Cobar Ccl |
| P.0007826 | Reg Rds Block Grant Coonamble Ccl |
| P.0007830 | Reg Rds Block Grant Cowra Ccl |
| P.0007924 | HW5 Meadow Flat Stabilise Orange RS |
| P.0008201 | HW12 Browns Creek Widening |
| P.0008245 | MOTORCYCLE SAFETY EDUCATION - WESTERN |
| P.0008300 | HW17 North Croppa Creek Rehab |
| P.0008315 | BalItem 22104 Flexible Pavement Patch OW |
| P.0008335 | HW17 North Gurley Foam Stabilisation |
| P.0008395 | Reg Rds Block Grant Narrabri Ccl |
| P.0008411 | Reg Rds Block Grant Moree Plains Ccl |
| P.0008724 | BalItem 22303 Slope & Retaining Wall OW |
| P.0008725 | HW28 Carnarvon Highway Rehabilitation Ca |
| P.0009004 | HW18 North Coonamble Rehab |
| P.0009035 | MR54 Perthville Rehab Bathurst Ccl |
| P.0009052 | MR253 O'Connell Rehab |
| P.0009122 | B4B LR157002 B4658 Warroo Bridge Replace |
| P.0009272 | HW17 MB2 Sprayed Sealing |
| P.0009274 | HW17 MB3 Sprayed Sealing |
| P.0009275 | HW5 Sprayed Sealing |
| P.0009332 | HW17 Mardell Cracked Reshape |
| P.0009444 | BalItem 22304 Drainage Rehabilitation OW |
| P.0009511 | HW7 B4123 Bridge Molong Ck Larriss Lea |
| P.0009540 | Reg Rds Block Grant Orange Ccl |
| P.0009634 | BalItem 22323 Slope Retain Wall Cap OW |
| P.0009636 | BalItem 22001 Routine Maintenance OW |
| P.0009709 | OLD-HW22 Waratta Ck Int Seal DONT USE! |
| P.0009712 | HW22 EightMile Ck Intl Seal Far West RMD |
Hi Rod,
You can download it from the internet. There also some tutorial on how to use it. See below link.
https://cdn.planacademy.com/wp-content/uploads/2012/01/xerFileParserBuilder_2007.xlsm
The best way of doing it is by creating 2 to 3 Projects in P6 including the Project Code so you will be familiar with the data. Open all the 3 projects created (Just place holder and NO WBS , NO Activities) and export it to XER. Open the xer with the XERFileParserBuilder and fill the the project data and project code. I assumed you are familiar with P6 database field to understand the heading of the XER table. Should you have any issue, let me know. If you can share the spreadsheet, I can build the xer for you.
can you share the spreadsheet or a pic of it. Some fields are importable into primavera and some are not.
Hi Rodel,
Yes, I just want the placeholder/shell created because then I will copy my template wbs into them. What is this tool you speak of?
Thanks,
Rod
Hi Rodney,
Do you mean adding those project into P6 Database without WBS and Activities?
If you are familiar with xerFileParserBuilder you can build XER with all the project in one XER and import to P6.
Email: PPadmin@planningplanet.com
Replies