Add merge_on_id mode to data importer (merge on internal CA record id value)


Add new existing record policy to data importer allowing merge on internal CollectiveAccess record id (Eg. object_id for objects, entity_id for entities).




Eve Perry
October 7, 2020, 7:16 PM

Ok, I tested the mapping and it works. Thanks!

If you could pull the change to the comedias sueltas live system that would be great. I think they will need some time to cleanup in their spreadsheet, but they will want to import right away when they’re finished.

One thing I noticed with “merge_on_id_with_replace” is the ca_objects.nonpreferred _labels field does not have values removed when replacement the value is null. I get the import error “Could not add non-preferred label to ca_objects: Name must be at least 1 characters” even though the system is not configured to require nonpreferred_labels. If this is intentional behavior, I will just need to let the client know about it so he can clear these values before the import.

October 7, 2020, 4:15 AM

The database needs to be updated by clicking the link. I’ve done it.

Eve Perry
October 6, 2020, 10:09 PM

I went to try it again and now I get this error:

October 6, 2020, 6:38 PM

Let’s try and use the mapping. I just updated the vendor libraries on the test system. I think that might have been the problem. Please try it again when you can?

Eve Perry
October 6, 2020, 4:42 PM

I get this error when I go to import>media in the test system. Is it easier to pull the change to the comedias live system or to write a script to import data? I am attaching the mapping so you can see what needs to be done, although they keep adding fields they want to import.

Your pinned fields
Click on the next to a field label to start pinning.




Eve Perry