Jump to content
John Kouraklis

CDATA CSV Component

Recommended Posts

Hi all,

 

I need to add CSV import functionality in an app and before I write it myself I thought to have a look at CDATA's CSV component. 

 

One thing I am not clear after checking their website; is it a FMX or VCL component? Anyone has used it?

 

Thanks

Share this post


Link to post

Hello,

 

You did not clarify if you need FMX or VCL or both in your question.

 

I am using SMImport, SMExport suite from http://www.scalabium.com for years. Never had the need to look for another solution. They are VCL only.

 

 

  • Like 1

Share this post


Link to post

https://www.cdata.com/drivers/csv/firedac/

Good questions, these are basically FireDac componenets, so they should be cross-platform.
Not checked if they have any visual components too, but I don't think so.

If the Enterprise connectors wouldn't be only available bundled as 80+, 160+ components, but available single or more granular,  I would have tested them already.

Edited by Rollo62

Share this post


Link to post

But I do hope it's either free, or very inexpensive. Importing CSV is far from being magic. It's more like splitting a String into a TStringlist and trying some StrToInt or StrToFloat...

Otherwise, try looking into these threads from the mother ship

https://www.delphipraxis.net/51457-csv-editor.html   

https://www.delphipraxis.net/158355-csvviewer-zum-betrachten-von-csv-dateien.html

  • Like 1
  • Thanks 1

Share this post


Link to post

TStringlist has DelimitedText and CommaText properties that works for many CSV files, free and one line of code.  However it treats spaces as a delimiter, so I use a minor variant that also always writes delimiters.

 

Angus

Share this post


Link to post
2 hours ago, Angus Robertson said:

TStringlist has DelimitedText and CommaText properties that works for many CSV files, free and one line of code.  However it treats spaces as a delimiter, so I use a minor variant that also always writes delimiters.

 

Angus

You need to set StrictDelimiter:=true to force TStringList to use only the DelimiterChar and not the spaces

Share this post


Link to post

For anyone who is interested, I contacted CData and they told me their FireDac components do not support FMX at all. Disappointing...

  • Sad 1

Share this post


Link to post
4 hours ago, John Kouraklis said:

FlexCel reads/writes only XLS files, doesn't it?

 

I will have another look again. Thx

FlexCel also read / writes CSV files

  • Like 1

Share this post


Link to post

kbmMemTable has a good CSV import unit for importing into their memory table.  I use this and then process the data from there.  It isn't an import component as such but part of the table.  It can be used in both VCL and FMX.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×