Our customers absolutely love (the idea of) the new table upload/download functionality in the webUI.
However we're scared to turn it on, because the upload functionality is quite risky as it's easy to lose quite a bit of data quickly.
For instance, when a table is filtered and exported (and changed a bit in Excel) and then uploaded again, all values that were filtered before are cleared, because they are not present in the Excel.
A proposal to address this from both angles:
- Make the filtered export explicit and optional: add additional dialogue to give end-user choice to download all data, or just the filtered data (only when filtering is active)
- Provide an option to make the import more forgiving: create two separate upload actions: in replace mode (clears all values not present in the Excel) and in merge mode (doesn’t change values not present in the Excel). In addition, make it up to the app-developer to provide zero, one or two of these actions per table to the end-user.