Veda2.0 Released!


Write to Excel/CSV file
#6
Dear Amit,

thank you for providing this version of VEDA-BE with CSV export option.

However, this version seems to be buggy, as one cannot work in the Veda Tables window, since everything is blocked by a giant font-size (probably the data fields), please see screenshot attached.

Despite the bug, I (blindly) clicked the export button and noticed a two problems in the generated CSV file:
  • The decimal operator is a comma (,) instead of a dot (.) which will cause import problems since the comma is already used as a separator
    As standard setting I'd suggest to use the dot, since VEDA-FE requires this as well.
    A user choice in the VEDA-BE settings for separator, decimal value and (maybe) thousand separator, would maybe useful for some users.


  • All values are enclosed by double-quotes (") whereas RFC 4180 section 5 does not enforce this.
    Since these double-quotes blow up the file-size enormously in bigger datasets (more than 25% in my test case), I would suggest to only enclose into double-quotes if absolutely needed (which should never be the case in VEDA since no double-quotes or CRLFs do appear in the data fields, see RFC 4180 sections 6 and 7).


Caveats: I know that there is no binding standard for CSV-files, but for ease of use, I would suggest to stick to the non-binding suggestions.

Thanks again and regards!
Fabian


Attached Files Thumbnail(s)
   
Reply


Messages In This Thread
Write to Excel/CSV file - by fg - 17-03-2017, 04:11 AM
RE: Write to Excel/CSV file - by Vikrant - 17-03-2017, 11:53 AM
RE: Write to Excel/CSV file - by fg - 19-03-2017, 06:58 PM
RE: Write to Excel/CSV file - by fg - 01-06-2017, 03:14 PM
RE: Write to Excel/CSV file - by AKanudia - 14-06-2017, 05:39 PM
RE: Write to Excel/CSV file - by Antti-L - 20-06-2017, 02:12 PM
RE: Write to Excel/CSV file - by fg - 19-06-2017, 02:45 PM
RE: Write to Excel/CSV file - by Vikrant - 19-06-2017, 08:47 PM
RE: Write to Excel/CSV file - by AKanudia - 20-06-2017, 03:03 PM
RE: Write to Excel/CSV file - by fg - 20-06-2017, 03:28 PM
RE: Write to Excel/CSV file - by Antti-L - 20-06-2017, 06:01 PM
RE: Write to Excel/CSV file - by AKanudia - 20-06-2017, 06:02 PM
RE: Write to Excel/CSV file - by fg - 21-06-2017, 02:45 PM
RE: Write to Excel/CSV file - by fg - 14-08-2017, 02:09 PM
RE: Write to Excel/CSV file - by Antti-L - 14-08-2017, 03:08 PM
RE: Write to Excel/CSV file - by fg - 17-08-2017, 06:55 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)