Import Project codes?

Primavera Project Planner - P3
F
Forum Guest 👤 Member for 17 years 4 months
· Permalink

Hi there Andrew,



We have tweaked the code so that it will (hopefully) show the slash, i.e. the \\\\\\\\\ character.



Thanks for the observation.



PP Admin.

A
Andrew Podolny 👤 Member for 21 years 6 months
· Permalink

Go to debug mode and check the vba code. I’m pretty sure that something wrong with project path or project name.

Be aware - you have to put short path in any Macro.

For instance:

c:progra~1 instead of c:Program files

Don’t hesitate to contact me personally.

Best regards

Andrew

R
Rajeev Kumar 👤 Member for 23 years 1 month
· Permalink

Thanks. But I get an error 501111, file not found. Any ideas?



Thanks once again.

A
Andrew Podolny 👤 Member for 21 years 6 months
· Permalink

Hi, there

Make sure P3 is already running on your computer (even with no project opened). That may help.

R
Rajeev Kumar 👤 Member for 23 years 1 month
· Permalink

I checked the spreadsheets. For the spreadsheet to work is it necessary that p3win directory exists in the C directory or will it work even if the p3win directory exists in any other subfolder in the c: directory. It just displays exiting RA as soon as I run any macro.



Can anyone help?



Thanks

J
Jaco Stadler 👤 Member for 21 years 9 months
· Permalink

D:SUPPORT/UTILS/EXCEL/activity

Will give you the ability to import Codes & Descriptions from xls

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months
· Permalink

Guys,

I am looking for a way to import PROJECT CODES from some Excel or Lotus 123 file to P3.

It looks like it’s only possible to export / import activity / resources custom data items.

Any idea?

J
Jaco Stadler 👤 Member for 21 years 9 months
· Permalink

D:SUPPORTUTILSEXCEL



ACTIVITY





This will allow you to export/import the Code & Description. If you jou want to assign act codes to an activities you can just export a norml wk1 file and ensure that you have ask for activity id & activity codes



Cheers

S
Steven Oliver 👤 Member for 23 years 7 months
· Permalink

I dont recall the name of the file, but they are *.xls, with macros written to import/export activity codes, resources and WBS.


S
Steven Oliver 👤 Member for 23 years 7 months
· Permalink

Supplied with P3 are some utilities to do exactly this. If you dont have the original CD, PM me and I’ll forward a copy.




Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts