Update table via CSV deletes data if CSV contains a subset of updated columns (+ other issues)

Feedback
1

Hi,
Baserow 1.33.4.

I tried to use the update feature via CSV file import and found a few unexpected results:

If the imported table does not include all the columns in the target table in baserow the values missing from the imported CSV are just deleted in the baserow table.

this seems a bit related to:

This does show up in the import preview - but is barely visible for larger tables, so will often lead to data loss in practice.

A similar data loss happens for values in single and multi select columns, which are not present in the baserow table. In other words - new select options are not added on import/upsert and there is no information presented to the user that the values were not imported. Even worse - legitimate values for those items are deleted from baserow if there are any for the affected rows/columns.

Additionally:
A few members of my team reported that they encountered a case where the updated rows were just deleted from the baserow table entirely. I have not been able to reproduce this with a sample table I can share, though.

2

crucially - the AI filed is also affected by this - as the field gets deleted every (skip is forced un update) which renders the update feature completely useless for any table with AI field present.

3

This is indeed covered by this issue and is prioritised so it will definitely be fixed in the next release (or perhaps before that in a patch in our saas)

1 Like