Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2011-09

CSV export (was: MS-Access ...)

2 messages · 2 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Graeme Geldenhuys
Reinier Olislagers wrote
I'm going to crawl back into my hole now and dream of proper CSV export in FPC, something a certain database product has been able to do well for quite some time ;)

I guess I missed some prior discussion about this. What exactly are you looking for? If you haven't yet, maybe take a look at tiOPF v2 [http://tiopf.sourceforge.net]. It has persistence layers for CSV, TAB etc file storage, including TDataset support. So it's quite easy to load something into a TDataset, then store it as a CSV or TAB delimited text file. Maybe that code could be of use to you.

With my sympathy to your former helldesk people,

:-)

Regards, - Graeme - _______________________________________________ fpGUI - a cross-platform Free Pascal GUI toolkit http://fpgui.sourceforge.net

Reply by email

Reinier Olislagers
to Graeme Geldenhuys
Graeme Geldenhuys wrote 7 lines
On 07/09/2011, Reinier Olislagers wrote: > > I'm going to crawl back into my hole now and dream of proper CSV export > in FPC, something a certain database product has been able to do well > for quite some time ;) I guess I missed some prior discussion about this.

Just trying to draw out Michael Van Canneyt after that helpdesk remark ;) He'd earlier said he'd have a look at bugs
19759 [Patch] CSV export doesn't quote memo fields 19937 TSQLExporter does not quote memo fields (or blobs) http:/msg25283.html

I happen to have some memo fields (that contain spaces) in my application, and exporting them to CSV leads to unquoted fields and a borked CSV file.

Tried to talk him into using SDFDataset functionality for the DB CSV export instead of the current coding, as well...

BTW, I'll probably be away for a day or ten, so expect a bit less mailing list/bugtracker/wiki activity regarding dbs/exports ;)

Show quoted text 6 lines
What exactly are you looking for? If you haven't yet, maybe take a look at tiOPF v2 [http://tiopf.sourceforge.net]. It has persistence layers for CSV, TAB etc file storage, including TDataset support. So it's quite easy to load something into a TDataset, then store it as a CSV or TAB delimited text file. Maybe that code could be of use to you.

Mmmm yes, tiOPF is on my todo list (still).

Thanks.

Reply by email