[Eclipsesql-bugs] [ eclipsesql-Bugs-1620376 ] Export to CSV is not working correctly

[SourceForge.net <no...@so...>]

Bugs item #1620376, was opened at 2006-12-21 19:12
Message generated for change (Settings changed) made by spackers
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1620376&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Interface (example)
Group: v1.0 (example)
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Bill_Robinette (bill_robinette)
Assigned to: Nobody/Anonymous (nobody)
Summary: Export to CSV is not working correctly

Initial Comment:
When exporting to CSV we only have the choice to use ; | or tab. Where is the comma? The is no option to surround text in "". This is need to import numbers that are in char fields.



----------------------------------------------------------------------

Comment By: Rocco Rutte (pdmef)
Date: 2007-06-18 16:39

Message:
Logged In: YES 
user_id=1794719
Originator: NO

In CVS there's some changes. You can now specify any delimiter for CSV
export and tags and ampersands are properly escaped, fixes to conform at
least a little to HTML standards were added.

Here, XML tags are properly exported to CSV files. Also, NULL values
should be exported as '<null>' just fine. It'll need some more tweaks to be
abled to specify a custom string for NULL values, though.

----------------------------------------------------------------------

Comment By: Holger Schimanski (hschimanski)
Date: 2007-02-12 09:52

Message:
Logged In: YES 
user_id=367964
Originator: NO

Export of <null> values does not work, too, when choosing HTML or cvs. 

Same problem, when you have XML in your varchar field. The XML tags are
not exported to cvs. They are simply ignored. In HTML export they are
present, but not encoded, so interpreted as HTML tags by the Web browser.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=1620376&group_id=132863