Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

P3 to Project through Excel

6 replies [Last post]
Wed, 2004-01-14 08:45
Luca Basile
User offline. Last seen 10 years 3 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
I have to link P3 to Ms Project.
But as P3 will be used at more high management level, and Project by the section engineer to product a detail level construction programme, I have to go through excel.
We use P3 for network, so it look like the Pervasive software for P3 is not working.
But after I have the file in excel I can import in P3.
So I would like to have a dynamic link between Project and excel, that will assure that the excel file will be update every time the project programme will be.

Can anyone help me to set up this dynamic link?

Thanks


PS. We have this situation, because fo we do not have licence of P3 also for the section engineer.

Top

Replies

Wed, 2005-08-31 18:34
#1
Gün Göksu
User offline. Last seen 2 years 33 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
Thank you very much Hannes de Bruyne.

I am checking that post now.
Top
Wed, 2005-08-31 06:14
#2
Hannes de Bruyne
User offline. Last seen 2 years 24 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
Hello Gün

in the thread "from P3 to MSP" I explained something about makros - the "engine" behind the file "activity.xls".

Hannes de Bruyne
Top
Tue, 2005-08-30 18:38
#3
Gün Göksu
User offline. Last seen 2 years 33 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
oh!

I’ll be very gratefull if anyone could send me some documents regarding the inerworkings of the activity.xls file.

I am trying to understand to way it really works.

any modified examples will be very much appreciated too.

Thanks.
Gün. :)
Top
Tue, 2005-08-30 18:34
#4
Gün Göksu
User offline. Last seen 2 years 33 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
Beware though,

WK1 files have a maximum line capacity of somewhere around 2200. if you have more data (read more lines) you will loose them.

DBF files need to have the boundaries defined. otherwise they dont have any limits (that I know of) concerning the number of lines in the file. But its a pain to arrange & check the boundaries everytime you add some lines to it as excel does not reset to the correct values when it saves. so you may have some lost data there too if you are not carefull.

My experience is dbf is better if you have big files. wk1 is better as you dont need to check the boundaries of the file.

if you want to automate the process somewhat I suggest you use the activity.xls and brother files you can find in the cd. play with it (thats what I am doing at the moment) and after a while you will get a feeling for the macro codes in it. thus in the very long therm may be able to code all of the exchange.

hope this helps.
Gün. :)
Top
Fri, 2005-08-26 06:09
#5
Lex de Jong
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 14 Jun 2004
Posts: 6
Groups: None
Hi,

The good old Lotus (WK*) export is also good.

You can open the Lotus spreadsheet directly in Excel.


If you want a report in excel, you can export to CSV-file. Than import a CSV as a text file.


Regards,

Lex
Top
Thu, 2005-08-18 12:52
#6
Peter Bailey
User offline. Last seen 19 years 7 weeks ago. Offline
Joined: 18 Aug 2005
Posts: 10
Groups: Petro-Chem / Oil & Gas
Hi,

P3 can not see Excel file extensions (.xls). You have to save the Excel file into a .dbf (database file) in order that P3 can see it.

Use a P3 export file as a template for your excel file and when it is populated using the P3 headings you may inport it as a .dbf file
Top