[Human task] Clean the data that's been migrated to acronym buster

[nanometrenat]

Re the excellent new https://rcrcsims.org/acronyms

Context

Data was directly migrated from MTAG, and was crowdsourced, so there are some items that need to be removed/edited.

We also want to add categorisation as per https://sims-ifrc.slack.com/archives/CEFDXURA9/p1708611515646549?thread_ts=1706801333.684669&cid=CEFDXURA9

Action

@nanometrenat and @ioalexei to review and update the export, for re-importing

Subsequently an additional category/scope filter will need to be added on the UI - once categorisation is done.

[JonathanGarro]

@nanometrenat @ioalexei ive finished adding features as part of #107 and #108 - i assume you'd rather manage this update process on the data directly in a csv, but if the changes you want to make are relatively minor, just wanted to flag that you can now make edits to the records in the front end if you were the original author or are an admin. if you'd like to have that ability to edit the records that were part of the original import (which were all just bulk-assigned to me) i can either:

• make you admins in the portal temporarily
• run an update on the db to make the author id of each imported record one of you so you can edit

otherwise, happy to handle the re-upload via csv. if you do go that route, just be sure to download the csv from the site so you're working with the proper index

[nanometrenat]

Thanks @JonathanGarro I will be working on this some more on the plane this evening (seeing as I can do it offline). Would love to go the csv re-upload route please, for this bulk lot. I've made a start on the list you previously downloaded into Slack - is that still the go or have the indices changed? (know there was one new record added since then, but that was mine ;)
THANKS

[JonathanGarro]

acronym_export_2024-05-09.csv

@nanometrenat - some things that henk has raised in other tickets may have tweaked the data structure here. see this CSV for the latest file