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.

exporting to excel

5 replies [Last post]
Wed, 2005-12-07 08:37
sunil kumar
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 18 Oct 2005
Posts: 47
Groups: None
i am a beginner in p3 .. can anybody pls briefly explain how to export activity ids, activity desc,ES EF,OD RD to EXCEL....

thanx

sunil

Top

Replies

Tue, 2005-12-13 02:04
#1
Andrew Tan
User offline. Last seen 12 years 20 weeks ago. Offline
Joined: 9 Oct 2004
Posts: 40
Groups: Petro-Chem / Oil & Gas
Hi,
If you want to know what to export, use WK1 for export and edit accordingly. Try importing after that.
I will not recommend exporting and importing unless you have a lot of data to amend fast.
I have a excel utility that will extract data like export/import function.
Top
Fri, 2005-12-09 08:12
#2
Hannes de Bruyne
User offline. Last seen 2 years 41 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
Better use a wk1-File to export (can be extended for reimport)
Top
Thu, 2005-12-08 03:58
#3
Sen Moc
User offline. Last seen 19 years 24 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
In P3, select Tools/Project Utilities/Export. Then if you don’t want to use the existing export definition file, CLICK MODIFY.

In the Content Tab, select Export/Contents of List. Then choose the items you want to export such as, Act ID, Act Description, ES, EF, etc……..

In the Format Output Tab, Input filename and select file type. Note: the default file location is P3win/P3Out.

In the Selection Tab, provide selection criteria or leave it blank if you want to select all activities.

Finally, Click Run.

Then, in MS Excel open the exported file. Note: the default file location is P3win/P3Out.

Good luck and More Power!
Top
Wed, 2005-12-07 15:42
#4
David Andreotti
User offline. Last seen 9 years 16 weeks ago. Offline
Joined: 6 Jul 2005
Posts: 47
Groups: None
Sunil;

Run the export utility in P3. It will take you through the process.

Dave
Top
Wed, 2005-12-07 09:10
#5
Steven Oliver
User offline. Last seen 12 years 31 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Easiest way is to Cut & Paste
Top