Not able to import related object lots, storage locations, or collections

lou-h

Hello,

Running 1.7.13

Would someone be able to look at my import mapping and data to see if there's any obvious issues? I can generate the objects just fine, but not the rest of the data.

Long story short, we're doing a roundabout finding aid, since most of what we have is described on the lot level without storage locations or subject terms included (I'm using "Collections" as a subjects stand-in) and so we need to go back and associate physical objects with their lots, locations, and subjects by manually entering them in a spreadsheet. Luckily, we at least wrote the lot numbers on the objects!

finding-aid.xlsx

finding-aid-mapping-2.xlsx

monica

For mapping objects to their lot, use lot_id as the table.element, rather than ca_object_lots.
for the collections and storage_locations, you will need the relevant spitters eg collectionSpiltter, storageLocationSplitter not relationshipSplitter.

In your refinery parameters, you need to include the types, eg. collectionType, objectLotType.
You will also need to include relationshipType in the refinery parameters

see documentation: https://manual.collectiveaccess.org/providence/user/import/mappings/refineries.html#collectionsplitter

lou-h

Thank you so much! I'll give it a go.

lou-h

This basically worked, though I had to use the ignore parent parameter. However, this causes a problem elsewhere, so I need to be able to import the entire hierarchy in a relatively straightforwardmanner. We have a bunch of legacy stuff that we don't really need but I don't want to recreate all the storage locations, as the last two items in the hierarchy are especially relevant. Is there a relatively easy way to map the entire hierarchy in a spreadsheet? I had been hoping to rely on just the location_id but that's not going to cut it, apparently. I'm trying to set things up so a fellow volunteer or intern can do a very simplified data entry. Any help is greatly appreciated!

finding-aid-mapping.xlsx

finding-aid.xlsx

monica

lou-h I assumed that you already had your locations imported into the system since you were matching them on location_id, which is the internal system ID. Do you want to create the storage location records with the object mapping?

lou-h

Hi Monica,

All storage locations are created - I just want to be able to link them to the object within an object lot and collection, and be able to display like so:

https://catalog.interferencearchive.org/index.php/Detail/object_lots/2024.003

This will later be used to populate a list of object lots and their associated locations under a collection, like so (this is a rough draft, as these are not associated with objects yet):

https://catalog.interferencearchive.org/index.php/Detail/collections/001_test

Now, the only way I could get my import mapping to work was by ignoring parents, but this meant when I went to display the associated storage locations as in the first link, nothing would populate, though the rest of the information (object ID, related collection) would. When I manually changed the storage location using the full hierarchy, it worked. I can only assume because I was mapping just a part of the hierarchy that it was causing the location not to be found? Even though the data seemed to be ok in the database, though maybe I misread something.

I appreciate your help and patience, as I'm just learning as I go.