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

Metabolic: Map file names out of ca_objects.preferred_labels

Description

For all object records in the system, including those that are part of albums, do the following IF there is only one media item per record (the vast majority):

  • IF ^ca_objects.preferred_labels ends in a file extension, THEN move it to ca_object_representations.preferred_labels.name

  • AND delete any value in ca_objects.nonpreferred_labels that ends in a file extension

  • ELSE IF any value in ca_objects.nonpreferred_labels ends in a file extension, THEN move the value to ca_object_representations.preferred_labels.name

  • ELSE set ^ca_object_representations.preferred_labels.name to ca_object_representations.original_filename if one exists

Environment

None

Assignee

Seth

Reporter

Eve Perry

Labels

Priority

Major
Configure