Write to Excel/CSV file

[Vikrant]

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

Hi Fabian,

Decimal separator is not decided by the VEDA, It is fetched from system settings. but yes we can provide an option to disable double quotes in csv file.

Is scenario import working fine in new updated VEDA-BE?
And we never seen this type of giant font size issue in VEDA-BE browser. Is other VEDA-BE windows showing text properly?