Copy/paste to/from google sheets

[danyx23]

Naive copy/paste has a couple of dangers - the most prominent one is that when you copy data out of the bulk fastt editor into a google sheet or excel and then keep it there for weeks and make changes and then want to apply it back there is no tracking whatsoever of what has changed in the mean time in the db itself (i.e. in the bulk fastt grid editor view if you like).

To solve this issue and allow reasonably long lifetimes outside of the system I decided instead to do a csv import/export that always gives and requests 2 csv files. "Original" which should not be changed, and "Edited" which should be. The idea is to make your edites in the edited csv in a tool of your choice. When you are done (maybe weeks later), you go back to the bulk fastt and upload both of these csv files - the original and the edited one. The bulk fastt admin then checks which cells have changed and tries to apply those changes using the normal bulk fastt api, always providing the original value from the original csv. This way, if a value has changed in the mean time, the change for that row would be rejected.