I am working on a test system trying to understand how to import data. I have been able to import data like idno, title, description, notes, dates,etc. but I am have a problem importing anything that is part of a hierarchy. Right now I am trying to import the storage location hierarchy.
Suppose I have a spreadsheet like this:
Cabinet Drawer Folder
Cabinet1 Drawer1 Folder1
Cabinet1 Drawer2 Folder2
Cabinet1 Drawer3 Folder3
Cabinet1 Drawer4 Folder4
Cabinet1 Drawer5 Folder5
Cabinet1 Drawer6 Folder6
Cabinet1 Drawer7 Folder7
Cabinet1 Drawer8 Folder8
and I want to import it to build the storage hierarchy. Cabinets are type cabinet, drawers are type drawers and folders are type folder. I have the storage configured to automatically generate a serial idno. Cabinet1 is already created in the storage hierarchy. This is just a simplified example for testing.
Starting with an example from the manual I have the refinery as storageLocationSplitter for both column 2 and 3. The refinery parameters for column 2 is:
{ "storageLocationType": "cabinet",
"hierarchicalStorageLocationTypes": [ "drawer" ],
"relationshipType": "related" }
and for column 3:
{ "storageLocationType": "cabinet",
"hierarchicalDelimiter": ",",
"hierarchicalStorageLocationTypes": [ "drawer","folder" ],
"relationshipType": "related" }
I have tried several variations on this but the drawer data and the folder data always end up at the same level as cabinet, not under cabinet. For this to work correctly I realize I need to reference column 2 so that the folders fall under the correct drawer but I didn't know how to do that.
Clearly I am not understanding something.
Eventually I'd like to also build the place hierarchy and the object hierarchy by
importing a spreadsheet..
I am running Providence 1.8 on Ubuntu 20.04
Any assistance is appreciated.