Re: Improper CSV export delimiter
Re: Improper CSV export delimiter
От:
Thom Brown <thom@linux.com>
Дата:
On 6 November 2010 21:08, Aren Cambre <aren@arencambre.com> wrote:
-- Bug report:When I use File > Export from a Query window, it's clearly trying to make a CSV. The suggested filename is suffixed with .csv.
Are you sure that isn't just there because that's the last filename you used? Mine doesn't default to anything. If I click on the ellipsis and type a filename without an extension into the file browser and click OK, it just comes up with the path and the filename I typed without an extension.
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Re: Improper CSV export delimiter
От:
Aren Cambre <aren@arencambre.com>
Дата:
Someone else could have used it.
Anyway, I can't reproduce this.
It's my personal laptop. Guaranteed no other users.
If you can't reproduce, I may be mistaken.
Aren
Re: Improper CSV export delimiter
От:
Aren Cambre <aren@arencambre.com>
Дата:
Moreover, the value you have as a column separator comes from your last
export. You probably set it to a semi-colon the last time you used the
Export functionality.
This was the first time I ever used the dialog.
Aren
Re: Improper CSV export delimiter
От:
Aren Cambre <aren@arencambre.com>
Дата:
Maybe. But if I click on the ellipsis, the Windows dialog has CSV preselected in Save as type, even if the prior extension isn't CSV.
But even more strongly, all the settings on the Export data to file dialog are CSV-compliant except that one. Shouldn't common standards be the default? What value is there in being "almost" CSV vs. being truly CSV?
The problem with this is when you save a CSV with semicolons instead of commas, other programs may not recognize the file. Already ran into a problem importing into Excel with semicolon separations. So if I forget change to comma, I may end up doing an export and may risk a complex CSV edit later. (It's simple if you're just replacing ";" with "," but can be complex in certain scenarios.)
Aren
On Sat, Nov 6, 2010 at 4:19 PM, Thom Brown <thom@linux.com> wrote:
--On 6 November 2010 21:08, Aren Cambre <aren@arencambre.com> wrote:Bug report:When I use File > Export from a Query window, it's clearly trying to make a CSV. The suggested filename is suffixed with .csv.Are you sure that isn't just there because that's the last filename you used? Mine doesn't default to anything. If I click on the ellipsis and type a filename without an extension into the file browser and click OK, it just comes up with the path and the filename I typed without an extension.
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
Improper CSV export delimiter
От:
Aren Cambre <aren@arencambre.com>
Дата:
Bug report:
When I use File > Export from a Query window, it's clearly trying to make a CSV. The suggested filename is suffixed with .csv.
The problem is the semicolon character is selected by default. That is not CSV. Please change this so the comma is the default delimiter.
Now, I understand semicolon is the standard in certain regions (e.g., France?), but the vast majority of cases, comma is the norm. If semicolon is selected by default, it should only be because regional OS settings are detected that recommend this.
Aren
