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.

Exporting/ importing OPP to Ms Access

6 replies [Last post]
James Anthony Wood
User offline. Last seen 1 year 10 weeks ago. Offline
Joined: 5 Feb 2004
Posts: 14
Groups: None
Greetings fellow Planners,

Question:- Is there an easy and simple way of exporting and importing data into and out of OPP from and to MS Access?

I want to keep it simple, so that I can show others how to do it without a long labourious process.

Cheers,

Jim Wood.

Replies

John Owen
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 27 May 2005
Posts: 10
Groups: None
Oops, I saw Project rather than Access...

OP 2.6 could save data directly into MS Access. You need an Access file populated with the relevant tables (from here: http://support.welcom.com/supportnet/tempdlfiles/OPP26_Access_2000.zip ) and an ODBC datasource pointing to the Access file. Once you have this use the ’File; Connect...’ option in OP 2.6 to connect to the database and restore your project (make sure you choose the ODBC data source in the file type when you restore each project file (Project, Calendar, Codes etc.). Be aware that the table structure is very different between OP 2.6 and 3.1 so don’t do any development if you plan on upgrading to 3.1 in the near future.
John Owen
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 27 May 2005
Posts: 10
Groups: None
OP 3.1b SP1 is available for download from SupportNet. This includes some updates to the standard OP 3.1 MS Project Import/Export feature (File; Import/Export; MS Project). This mechanism exports as much OP data as possible - which can sometimes confuse MS Project where feature support is different. If your need is to export OP projects to MS Project for reporting/contractual purposes then you could try the MSPRIF export (available by calling Welcom support) which modifies the exported data to coerce MS Project to display the exact same dates as Open Plan
Joanne Foster
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 17 Jan 2004
Posts: 50
Groups: None
oh...I didn’t realise that 2.6 was still out there - mind you I’m not sure if going to 3.1 is actually an upgrade or not!!!

Anyway, 2.6 still has the transfer.dat functionality - so you can try that.

Regards
J
James Anthony Wood
User offline. Last seen 1 year 10 weeks ago. Offline
Joined: 5 Feb 2004
Posts: 14
Groups: None
Hi All,

Thank you Joanne for your reply, we will be upgrading to 3.1 soon, so hopefully this will have easier functionality than 2.6.

Thanks again.

Jim Wood.
Joanne Foster
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 17 Jan 2004
Posts: 50
Groups: None
you can utilise either Cross Table Export, or write your own scripts in transfer.dat

Once it is set up correctly, your users will just need to run the export script.

Look at both the users guide and the developers guide for info on Exporting.

Regards
Joanne
Radek Slanina
User offline. Last seen 8 years 12 weeks ago. Offline
Joined: 29 Jun 2005
Posts: 6
Groups: None
OPP 3.1 stores data in MS ACCESS by default. The structure of data tables is described in developers guide. Maybe this can help...

Radek