Problem importing object-place relationships

nuzzart

I am having a problem importing a place relationship for an object. Initially I created the test place hierarchy by importing it from a spreadsheet. Then since I had a working object-storagelocation mapping I started with that and modified it for places. Column 19 is the location field.

Mapping 19 ca_places placeSplitter { "placeType":"location", "hierarchicalDelimiter": ",", "hierarchicalPlacesTypes": [ “state”, "city", "location" ], "relationshipType": “located" }

This gave me an error:

ERROR --> [100001] Could not insert place xxx: placeprefix must be set to p; was x; 'xx' is not valid for ; only numbers are allowed

and no place relationships are created for the object. It looks like it is trying to create the xxx location using x and xx as the identifier but xxx(p00003) location already exists. The place identifiers are configured to create an identifier pxxxxx where xxxx is a serial number.

Also I don't think that hierarchicalPlacesTypes is a valid place parameter. I don't find it in the documentation. There is a placeHierachy parameter but it says that it wants a single identifier where you want it mapped, not a place type list.

Clearly I am not understanding something here. I expected it to be similar to the storageLocation mapping but I guess it's not.

Any assistance is appreciated. I am running CA-1.8 on Ubuntu 20.04.

nuzzart

I figured out how to do this. In case anyone is interested, here is what worked for me:

Mapping 19 ca_places placeSplitter { "placeType":"location", “parents”: [ {“idno” :”^17”,"name”: “^17”, “type”: “city”}, {“idno” :”^18”,"name”: “^18”, “type”: “state”} ] , "relationshipType": “located" }