Bulk New Project creation tool? or SQL function?

Submitted by rodneyoz on
Oracle Primavera - PM6

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Wed, 2021-08-11 15:38
Permalink

guess they need a 64 bit version

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Wed, 2021-08-11 02:34
Permalink

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

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Sun, 2021-08-01 02:18
Permalink

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

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Tue, 2021-07-20 16:17
Permalink

sent file to Rodney

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Mon, 2021-07-19 07:47
Permalink

Hi Zoltan,

 

Would you please email those parser instructions? I can't get it to run, just errors of not finding file.

 

Rod

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Sun, 2021-07-18 12:17
Permalink

Hi Rod,

What is the error? Is it opening the xer or loading the excel parser?

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Sun, 2021-07-18 06:54
Permalink

Hi Rodel,

 

The parser fails, the error is

and then,

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Sun, 2021-07-18 02:16
Permalink

Thanks Rodel, I'll give it a try today.

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Sun, 2021-07-18 02:13
Permalink

Hi Zoltan,

 

Than picture hasn't come through properly so please email me. 

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Fri, 2021-07-16 15:48
Permalink

here are the instructions

not sure why so smal but if u give me your email address I can send the word file

[[wysiwyg_imageupload:7833:]]

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Fri, 2021-07-16 09:36
Permalink

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.

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Fri, 2021-07-16 02:57
Permalink

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.

 

 

ProjectProject NameP.0005151HW7 East Sprayed SealingP.0005293Behavioural SpeedP.0005328Facilities around schools - ReactiveP.0005352HW7 West Sprayed SealingP.0005353HW6 Sprayed SealingP.0005354HW8 Sprayed SealingP.0005355HW11 Sprayed SealingP.0005356HW12 Sprayed SealingP.0005357HW18 Sprayed SealingP.0005358HW21 Sprayed SealingP.0005359HW22 Sprayed SealingP.0005360HW27 Sprayed SealingP.0005382HW29 Sprayed SealingP.0005383MR54 Sprayed SealingP.0005384MR56 Sprayed SealingP.0005385MR61 Sprayed SealingP.0005386MR70 Sprayed SealingP.0005387MR78 Sprayed SealingP.0005388MR245 Sprayed SealingP.0005389MR253 Sprayed SealingP.0005390MR310 Sprayed SealingP.0005391MR334 Sprayed SealingP.0005392MR359 Sprayed SealingP.0005393MR377 Sprayed SealingP.0005394MR410 Sprayed SealingP.0005395MR421 Sprayed SealingP.0005396MR516 Sprayed SealingP.0005397MR558 Sprayed SealingP.0005398MR559 Sprayed SealingP.0005399Reg Roads Broken Hill WC Sprayed SealingP.0005401HW17 MB3 Asphalt ResheetingP.0005412HW5 Asphalt ResheetingP.0005413HW7 East Asphalt ResheetingP.0005547Reg Rds Block Grant Mid Western RegionalP.0005548Reg Rds Block Grant Bathurst RegionalP.0005558BalItem 21110 Passing Lanes OWP.0005661HW17 Mogriguy RehabP.0005682HW5 Kirconnel ReconstructionP.0005800Reg Rds Block Grant Warrumbungle CclP.0005856BalItem 222021 Bridge Rebuilding OWP.0005987BalItem 22114 Concrete Pavemt Rehab OWP.0006018BalItem 21301 Flood Mitigation OWP.0006044HW7 B4148 LH Ford Bdge MidspanP.0006059BalItem 21106 Sealed Road Extension OWP.0006118HW7 East Heavy Patching AuslinkP.0006120HW7 West Heavy Patch StateP.0006210HW18 Back Creek Road WideningP.0006276HW18 Blackmans Flat Widen & ReshapeP.0006281HW17 Marsden RehabP.0006406HW5 Orange Road Services Culvert RepairsP.0006586HW17 MB2 Heavy Patch AuslinkP.0006588HW17 MB3 Heavy Patch AuslinkP.0006590HW17 North Marsden CausewaysP.0006627HW8 B9239 Unnamed CreekP.0006677HW8 Musheroo WideningP.0006694LGRSO MOREE ProjectsP.0006695LGRSO ORANGE ProjectsP.0006696LGRSO DUBBO REGIONAL ProjectsP.0006698LGRSO BATHURST ProjectsP.0006699LGRSO MOREE SalaryP.0006700LGRSO ORANGE SalaryP.0006701LGRSO DUBBO REGIONAL SalaryP.0006826MR633 Sprayed SealingP.0006827MR633 Pavement Heavy Patch StateP.0006903LGRSO BATHURST SalaryP.0006904LGRSO PARKES ProjectsP.0006905LGRSO PARKES SalaryP.0006906OCCUPANT RESTRAINTP.0006907Reactive Speed Zone ReviewsP.0006967BalItem 22201 Bridge Routine & Minor OWP.0007113HW27 B4409 Plain Creek 22.12km NE DubboP.0007161HW27 B4405 Ballimore Ck 33.84km NE DubboP.0007182HW27 B4402 Spicers Ck 41.03km NE DubboP.0007222B4B LR2580005 B1302 McKanes Bridge CoxsRP.0007335HW5 B1036 MarrangarooP.0007421Reg Rds Block Grant Forbes CclP.0007436Reg Rds Block Grant Gilgandra CclP.0007463Reg Rds Block Grant Lachlan CclP.0007468Reg Rds Block Grant Narromine CclP.0007483Reg Rds Block Grant Parkes CclP.0007488Reg Rds Block Grant Walgett CclP.0007505Reg Rds Block Grant Warren CclP.0007508Reg Rds Block Grant Weddin CclP.0007584Reg Rds Block Grant Lithgow CclP.0007591Reg Rds Block Grant Oberon CclP.0007709Reg Rds Block Grant Broken Hill CclP.0007734Reg Rds Block Grant Central Darling CclP.0007766Reg Rds Block Grant Blayney CclP.0007773Reg Rds Block Grant Bogan CclP.0007776Reg Rds Block Grant Bourke CclP.0007780Reg Rds Block Grant Brewarrina CclP.0007803Reg Rds Block Grant Cabonne CclP.0007810Reg Rds Block Grant Cobar CclP.0007826Reg Rds Block Grant Coonamble CclP.0007830Reg Rds Block Grant Cowra CclP.0007924HW5 Meadow Flat Stabilise Orange RSP.0008201HW12 Browns Creek WideningP.0008245MOTORCYCLE SAFETY EDUCATION - WESTERNP.0008300HW17 North Croppa Creek RehabP.0008315BalItem 22104 Flexible Pavement Patch OWP.0008335HW17 North Gurley Foam StabilisationP.0008395Reg Rds Block Grant Narrabri CclP.0008411Reg Rds Block Grant Moree Plains CclP.0008724BalItem 22303 Slope & Retaining Wall OWP.0008725HW28 Carnarvon Highway Rehabilitation CaP.0009004HW18 North Coonamble RehabP.0009035MR54 Perthville Rehab Bathurst CclP.0009052MR253 O'Connell RehabP.0009122B4B LR157002 B4658 Warroo Bridge ReplaceP.0009272HW17 MB2 Sprayed SealingP.0009274HW17 MB3 Sprayed SealingP.0009275HW5 Sprayed SealingP.0009332HW17 Mardell Cracked ReshapeP.0009444BalItem 22304 Drainage Rehabilitation OWP.0009511HW7 B4123 Bridge Molong Ck Larriss LeaP.0009540Reg Rds Block Grant Orange CclP.0009634BalItem 22323 Slope Retain Wall Cap OWP.0009636BalItem 22001 Routine Maintenance OWP.0009709OLD-HW22 Waratta Ck Int Seal DONT USE!P.0009712HW22 EightMile Ck Intl Seal Far West RMD

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Thu, 2021-07-15 14:55
Permalink

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.

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Thu, 2021-07-15 13:39
Permalink

can you share the spreadsheet or a pic of it. Some fields are importable into primavera and some are not. 

Member for

13 years 4 months
Member for 13 years 4 months
Submitted by rodneyoz on Thu, 2021-07-15 13:16
Permalink

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

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Thu, 2021-07-15 09:04
Permalink

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.