search

foodcoops / foodsoft

Web-based software to manage a non-profit food coop (product catalog, ordering, accounting, job scheduling).
https://foodcoops.net/
Other
327 stars 147 forks source link

Article Export to CSV: first column (header) "status" missing #854

Open mjavurek opened 3 years ago

mjavurek commented 3 years ago

The first column in the exported articel CSV looks like: "";Order number;Name;Note;Manufacturer;Origin;Unit;Price (net);VAT;Deposit;Unit quantity;"";"";Category or in the German version "";Bestellnummer;Name;Notiz;Produzent;Herkunft;Einheit;Nettopreis;MwSt;Pfand;Gebindegröße;"";"";Kategorie The first column header is an empty string (""). If such a CSV is imported, everything works fine. If the CSV is opened in LibreOffice and then saved as ODS, an error occurs during the import: A problem has occured: undefined method 'strip' for 1:Integer If the word "status" is typed into cell A1 of the ODS, the import works fine. So I think the exported CSV should contain a header for column 1 for compatibility with other file formats.

mjavurek commented 3 years ago

Thanks for fixing it so fast. I then noticed that the status data itself is also not exported.

kidhab commented 2 years ago

I then noticed that the status data itself is also not exported.

I assume this is by design. From the article upload view:

The rows shown here are examples. When there is an "x" in the first column, the article is outlisted and will be removed. This allows you to edit the spreadsheet and quickly remove many articles at once, for example when articles become unavailable with the supplier.

If the first column will be included in the export the column will be filled with frue or false statements.