Update Locations for ACMA

[crugas]

ACMA needs to add several spreadsheets worth of new Locations. To use the Locations CSV, the CAAS team will need to update newly added locations to associate them with ACMA. Mark created a script previously, found here, to quickly update added Locations provided a CSV is used containing the URIs of the newly added Locations.

Mark advised that we have ACMA add the new locations to ASpace, then generate a CSV of the newly added Locations from the ASpace SUI sorting by date added - greater than that day's date - containing the URIs of all the Locations added. Then we can run the above script or a modified version of it to associate it with ACMA repository.

TODO: Once this is completed, make sure to resolve SCTASK0189884 in ServiceNow.

[fordmadox]

In addition to the CSV download from the staff interface, here's the hacky SQL that I found that I used previously to get a list of locations that might need to be updated (but the Udvar-Hazy examples where AAA materials are stored is a good reason, I think, not to assign the repository data point):

SELECT CONCAT('/locations/', location.id) AS url, location.title
from location
LEFT JOIN owner_repo_rlshp orr ON location.id = orr.location_id
WHERE orr.repository_id IS NULL;