Hello, im currently trying to export / import information from one ca instance to another. For security and discretion concerns we are not allowed to have our database exposed to the internet so we set up a online subset of the records and the data schema, so the configuration of both systems differ a little.
I thought i could achieve this by exporting the ca_objects and then doing their corresponding splitters and refineries but things get complicated when there are multiple relationships and relationship's types tied to a single record.
Now, im thinking i could export every other related table first and then use the matchOn feature. So far so good, but when i reached places, i just dont know what to do, the places importer can only match a single type at a time. So i started exporting the first hierarchical level, lets say "countries", it went smooth. Then i went one level down, i tried to tie ca_places.parent_idno to their corresponding parent idno to see if it built the hierarchy, wont budge. Then maybe the placeHierarchyBuilder, but i dont know even where to place it. I read the docs, and i searched in the forum, so this is my last chance. I thank you all for being so good of a community.
CA version 1.7.16