Page 1 of 1

Exporting to .cvs

Posted: 2007-12-14 04:56:25
by -=[WeBsEcReTa]=-
How do I get a piece of data in a cell? As to the earlier version



Image


Thanks

PD: Sorry, I do not speak English, this is a translation of google.

Posted: 2007-12-14 16:27:03
by antp
Old versions were using ";" if I remember well.
Now you can chose the character to use.
In the export window, try by using a "," or a ";" : one of these two must work.
You can also use the <tab> as delimiter, and then save the file to .txt instead of .csv

Posted: 2007-12-14 16:33:17
by -=[WeBsEcReTa]=-
antp wrote:Old versions were using ";" if I remember well.
Now you can chose the character to use.
In the export window, try by using a "," or a ";" : one of these two must work.
You can also use the <tab> as delimiter, and then save the file to .txt instead of .csv

I worked, thank you, you are cool! :P

"You can also use the <tab> as delimiter, and then save the file to .txt instead of .csv" :grinking:

Posted: 2008-02-09 20:06:15
by crazyiven
I updated to 3.5.1.0 and have a Problem.

In the old version I had the Option to replace the delimiter in the data so prevent wrong delimiter ... but with the new version dont have this function. I think this function is VERY useful and it would be nice if you can readd it to the newest Version?

Exported my Data today, parsed it for my Wordpress Blog (wrote a Plugin) and it fu**ed my DB ;)

Posted: 2008-02-09 20:18:15
by antp
Normally this is not useful, as in CSV you can have text block delimiters (typically quotes "...").
That's why I removed that option, as the new system was working fine with the few programs that I know for importing CSV.
Isn't possible to import CSV with quote-protected blocs in that blog? Or does it depend on your plugin? (in first case I could re-add the option... in second case you just have to improve your plugin to support true CSV :hihi: )

Posted: 2008-02-09 20:23:22
by crazyiven
antp wrote:Normally this is not useful, as in CSV you can have text block delimiters (typically quotes "...").
That's why I removed that option, as the new system was working fine with the few programs that I know for importing CSV.
Isn't possible to import CSV with quote-protected blocs in that blog? Or does it depend on your plugin? (in first case I could re-add the option... in second case you just have to improve your plugin to support true CSV :hihi: )
Its my own Plugin and i just exploded the CSV File with delimiter ; ... quick & dirty PHP code *g*

So I have to find a way for "true CSV Import" ... i hate you ... more work ;)

Thx for Information :)

Posted: 2008-02-09 23:57:08
by antp
:lol: well it is indeed less easy, but not a so big work, I guess that some ready-to-use functions, classes or libraries must have been done in PHP if you do not wish to do it yourself ;)