Update database by overriding with a new one

Ask the community
,
1

Hello,

I imported a database using a csv file.

Is it possible to work on the csv file (in excel for example) and then reimport it in Wix to update the same old database ?

The structure would stay the same. I would only add new lines and modify the content in certain columns.

I already tried to reimport the same updated database (in .csv) but Wix add the new lines on top instead of updating the corresponding lines ?

Thanks

2

I found a solution at my problem. You export the database in csv and you edit it. But before importing the edit to wix and trying to override (which doesn’t work), you have to delete all the rows of the table on wix but not delete the table itself ! After that, you reimport your updated lines (the csv you edited) in the empty online database.
Thanks to this workaround, all the links / dataset stay in place and the lines are “updated”.
I hope my solution is understandable :wink: