[Archivesspace_Users_Group] merge value error

[Callahan, Maureen]

Hey Brian,

Oh, that makes sense. Could you help me think through what I need to do here? I basically want to start by getting a list of identifiers for enumeration values that I’m trying to merge into a given value — say, all of the values that should become “aat”. Then, I identify all records in the subjects table with non-legit source ids. Then, I do an update in the subjects table where I update the bad source ids (identified in the previous step) with the one that I want. Once that’s done, I should be able to merge the source values from the interface.

Is there an easier/safer way of doing this?

Thanks,
Maureen

> On Jun 5, 2015, at 9:35 AM, Brian Hoffman <brianjhoffman at gmail.com> wrote:
> 
> Hi Maureen,
> 
> It kind of looks to me like you might have the following situation:
> 
> Two subject records with identical terms but different “source” values. The controlled values you are trying to merge would result in those two subject records having identical “source” values, and as a result be identical, which violates a uniqueness constraint in the database. Does that seem possible? If so, could you find those subject records first and de-dupe them?
> 
> Brian
> 
> 
> 
> 
> On Jun 5, 2015, at 8:46 AM, Callahan, Maureen <maureen.callahan at yale.edu> wrote:
> 
>> <mergeenums.txt>
> 
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=AwIF-g&c=-dg2m7zWuuDZ0MUcV7Sdqw&r=JgH2YCQ8D3P9-Lm_x4bv3d2CZBYlbx6hxnLFHtfovi8&m=dV_f9dLVb2pHqBsLSvZeWxpMEI58bKX9XCUnViWF3fk&s=mh0bb7LGZEk0NfeTHYSLy6KGsnRi847Ov_p21GRSkxc&e=