Upload should provide same update functionality as import from shared database

[wvengen]

If upload is used to add articles to a supplier, it may very well be that at some point later in time the same list needs to be updated from a similar file. Imports from the shared database do some checking to see if existing articles can be updated. It would be very nice if this functionality was present in upload too. They're basically the same thing anyway, in my view, with a different source (externally maintained database versus locally maintained list of articles in a spreadsheet which may come from the supplier directly too - after some column shuffling).

• Fix title of import and sync article overview screen
• Update upload screen text
• Check if we need to be able to specify parameters for upload or not --> nope
• Tests for upload: adding, updating and deleting articles.
• Tests to check different file formats when uploading
• Handle errors when form is incomplete (e.g. category empty)
• Choose whether to take units from foodcoop or upload/shared_supplier
• Add ability to delete/make unavailable products not in spreadsheet

[bennibu]

yeah, nice idea. This shouldn't be so difficult.

[wvengen]

Good news, thanks.

[wvengen]

Anyone interested in implementing this in the next week or so? If not, I'll remove it from the 4.1 milestone.

[wvengen]

I've finally started to work on this. A prototype is ready in branch feature/spreadsheets (which also enables importing Excel and OpenOffice files directly).

[wvengen]

Regarding upload options as csv column separator and encoding: this is not something that's possible right now. Besides, most people having a hard time specifying a csv column separator are probably better off using xls/xlsx/ods.

[wvengen]

For an impression:

The next form is the same as sync (except the title)

[wvengen]

That should be everything. There are two new checkboxes for controlling how the upload works. By default the settings were the same as before (no unit conversion, retain articles not in upload).

Suggestions for the user-interface and texts welcome, I think they can be better. Please test!