Data Cleaning

Hi,

I'm wondering if others have found a good way to import clean logistical data back into Altru. For example, I am looking to batch clean duplicate location names with slight variations (from too many cooks in the kitchen) that are linked to events, etc. I can do this in Python but there doesn't seem to be a very easy way to import the data back into Altru. I know there are limited batch import options but those are mainly for constituent information updates and not necessarily operational cleaning. I know there are also some limited API endpoints I can use but I am unfamiliar with this process. If anyone has good resources for this please let me know!

There are so many great queries that can pull .csv files of the uncleaned data that I can run through cleaning programs but no easy way to port that info back in! I would hate to have to manually go through and clean system options and every linked event, etc. across the entire database.

Thank you in advance!!

Katie