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.

Export data into Excel !

4 replies [Last post]
Wed, 2006-09-20 21:14
Deepak Jain
User offline. Last seen 11 years 15 weeks ago. Offline
Joined: 14 Jan 2006
Posts: 31
Groups: Petro-Chem / Oil & Gas
Hi all,

While exporting data to excel, P3 usually generates some un-necessary columns containing some random characters. Any ideas to get rid of this ? n any method to have custom defined column titles..

Thanks
Deepak
Top

Replies

Sun, 2006-09-24 00:49
#1
Gün Göksu
User offline. Last seen 2 years 49 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 123
Groups: GPC Qatar, Petro-Chem / Oil & Gas, TILOS
Deepak,

Please copy paste the first 3 of 4 lines of the export you get and say you have the random characters. If you havent solved the problem yet.

I have never seen P3 output random characters; there must be a reason.

also as previously said: looking at the export "Contents of list" just before an export will and must give you an idea.

otherwise please send/post here an example of the export file. especially the first 3 lines.

Gün.
Top
Thu, 2006-09-21 06:44
#2
Hashim Muhammud
User offline. Last seen 13 years 10 hours ago. Offline
Joined: 7 Mar 2004
Posts: 38
Groups: None
if you can let us know some of those unneccessary characters then may be we could help you.

And regarding giving custom names for columns, as far as i know its not possible.

bye
Top
Thu, 2006-09-21 04:12
#3
Christian Adrian ...
User offline. Last seen 5 years 47 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
You can try checking the data field under the Export>Contents of List... there could be some data fields which are unneccesary for exporting...

HTH...
Top
Thu, 2006-09-21 03:22
#4
Jose Frade
User offline. Last seen 4 years 15 weeks ago. Offline
Joined: 7 Jun 2005
Posts: 144
Groups: None
It never happened to me.

Try using RA to get data out of the database - and even changing the samples you can extract exactly what U are looking for.

May be not a big help

BR
JMFrade
Top