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.

data tranfer to/from P3 to MS Access

8 replies [Last post]
Fri, 2005-09-30 23:43
Gün Göksu
User offline. Last seen 1 year 43 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
Hello fellow planners,

Anyone can please send me some examples (macro?) to transfer data from P3 to MS Access and back?

I need to link some data in an Access Database to P3.

(by way of mirroring the P3 data tables in Access)


Thanks,

Gün Göksu :)
Top

Replies

Tue, 2005-10-04 15:58
#1
Cor de Bakker
User offline. Last seen 12 years 49 weeks ago. Offline
Joined: 10 Aug 2005
Posts: 5
Groups: Petro-Chem / Oil & Gas
If you want to link P3 data into MS Access you have to install an ODBC driver that works with 16 bit data.
Doing so, ou can use P3 data directly in MS Access.
But you have to know how some things work, Otherwise it will crash instantly.
Top
Tue, 2005-10-04 03:43
#2
Steven Oliver
User offline. Last seen 11 years 25 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Why not export to a dbf file, this can be read directly by MsAccess
Top
Mon, 2005-10-03 22:25
#3
Kevin Button
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 16 Jul 2003
Posts: 112
Groups: None
I don’t have a copy of P3 with me so I am guessing here. You need to go to Tools, Updata Data Dictionary and select Advanced. This will make your custom data fields available for RA to use.

Don’t know if this will solve your problem, but I think you would have to do this anyway.

Cheers
Top
Mon, 2005-10-03 12:35
#4
MK TSE
User offline. Last seen 3 years 49 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
The file is running on Access verion 97.
Top
Sat, 2005-10-01 21:47
#5
Gün Göksu
User offline. Last seen 1 year 43 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
Hello,

I’ve found the file from the cd.
\P3\Ra\samples\access\PRIMAVER.MDB

there is no documentation with it.
moreover, some stuff dont work in the file.
I did get the activity table. but not the CUSTOMCDI.
it gives an error: 3315 Field ’activityCDI.value’ cannot be zero-length string.

what could be wrong? any clues?

Gün.
Top
Sat, 2005-10-01 00:52
#6
MK TSE
User offline. Last seen 3 years 49 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
There ia a MsAccess file on the CD which can link to P3 by RA also.
It performs same as XLS.
Top
Fri, 2005-09-30 23:57
#7
Bill Guthrie
User offline. Last seen 8 years 3 days ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
forgot, also there is a file in many p3 disc for upload, called projects.xls

this will export all your schedule in one pass to a excel file.
cheers bill
Top
Fri, 2005-09-30 23:55
#8
Bill Guthrie
User offline. Last seen 8 years 3 days ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
use p3 utilities, export 2 files

1 with schedule data
2 with relationships

after you get export in database, merge the two excel files and you have a complete schedule in db and can play with it in access then back to p3

enjoy.
Top