We're updating the issue view to help you get more done. 

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

Description

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

Environment

None

Activity

Show:
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.

Seth
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, 10:09 PM

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

Seth
October 7, 2020, 4:15 AM

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

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.

Assignee

Seth

Reporter

Eve Perry

Labels

Components

Fix versions

Affects versions

Priority

Major
Configure