Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(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.

Import Project codes?

13 replies [Last post]
Mon, 2005-01-31 11:50
Alexandre Faulx-B...
User offline. Last seen 2 years 22 weeks ago. Offline
Joined: 20 Jan 2003
Posts: 1355
Groups: Petro-Chem / Oil & Gas, TILOS
Hello,
my customer would like to enter all the project specs in MS-Excel, as he feels more confortable than in the relevant P3 forms.
Is it by any means possible to export/import project codes and obtain the same result as for the activity data custom items?
Thanks,
Alexandre
Top

Replies

Mon, 2005-02-07 15:24
#1
Forum Guest
User offline. Last seen 10 weeks 18 hours ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
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.
Top
Mon, 2005-02-07 07:08
#2
Andrew Podolny
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
This forum doesn’t support slash symbol.
Top
Mon, 2005-02-07 07:05
#3
Andrew Podolny
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
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
Top
Mon, 2005-02-07 05:27
#4
Rajeev Kumar
User offline. Last seen 9 years 32 weeks ago. Offline
Joined: 27 Apr 2003
Posts: 43
Groups: None
Thanks. But I get an error 501111, file not found. Any ideas?

Thanks once again.
Top
Mon, 2005-02-07 03:18
#5
Andrew Podolny
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Hi, there
Make sure P3 is already running on your computer (even with no project opened). That may help.
Top
Mon, 2005-02-07 01:10
#6
Rajeev Kumar
User offline. Last seen 9 years 32 weeks ago. Offline
Joined: 27 Apr 2003
Posts: 43
Groups: None
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
Top
Tue, 2005-02-01 04:08
#7
Andrew Podolny
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Hi, there.
All a.m. utilities you can download from here:
http://rapidshare.de/files-en/489358/P3_excel.zip.html
Best regards,
Andrew
Top
Mon, 2005-01-31 12:59
#8
Jaco Stadler
User offline. Last seen 17 years 50 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
D:SUPPORT/UTILS/EXCEL/activity
Will give you the ability to import Codes & Descriptions from xls
Top
Mon, 2005-01-31 12:37
#9
Jaco Stadler
User offline. Last seen 17 years 50 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
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
Top
Mon, 2005-01-31 12:30
#10
Steven Oliver
User offline. Last seen 11 years 45 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
I dont recall the name of the file, but they are *.xls, with macros written to import/export activity codes, resources and WBS.

Top
Mon, 2005-01-31 12:21
#11
Steven Oliver
User offline. Last seen 11 years 45 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
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.


Top