FLMNH-MGCL/spesql

Update via CSV/XLSX

Closed this issue · 1 comments

aaronleopold commented

Is this a NEW feature request or an UPDATE feature request?
NEW

Is your feature request related to a problem? Please describe.
#76 - tangentially related
It would be beneficial to be able to download troublesome tuples (i.e. ones containing invalid characters that was not removed pre-upload: �) and manually replace these characters with their correct versions. Since all the characters are not necessarily the same, we cannot just batch update and replace it.

Describe the solution you'd like

  1. Query for troublesome entries
  2. download them as csv
  3. fix the issues
  4. upload the csv to spesql, which will generate a large update query
aaronleopold commented

d7f5dfa - work done, requires testing and some optimization