Export produces CSV files in unfriendly format

evoluteur / evolutility-server-node

Model-driven REST APIs for CRUD and more, written in Javascript, using Node.js, Express, and PostgreSQL.

GNU Affero General Public License v3.0

112 stars 33 forks source link

Export produces CSV files in unfriendly format #9

Closed david-pfx closed 5 years ago

david-pfx commented 6 years ago

The export feature produces UTF-8 files with long verbose dates. They do not import at all easily into common tools such as Excel. For easy import into Excel (and other tools) the ideal would be tab delimited, either ANSI or UTF-8 with BOM mark, and with a short culture-neutral date/time format.

david-pfx commented 5 years ago

Suggest switching from express-csv (which is no longer being supported or updated) to csv-express (a fork resolving some outstanding issues). It behaves better with Excel, and provides options for encodings and different delimiters.

evoluteur commented 5 years ago

OK, I just made the switch to csv-express.