Naming Citations in Preparation for RM8 #RM7 #Citations

In RM8, citations are re-useable and have a name which is made by concatenating the contents of the citation fields.
So I run this script on my RM version 7 database so that it is ready for importing into RM version 8.

I have taken advantage of this concatenation to get meaningful names by inserting a new field in my own templates as the first one in a citation and then setting the value in the citations to the source name.

This will only work for user templates, not for supplied ones (SourceTable.TemplateID > 10000)

/* update citations for RM8
 add in new field - CitItemD for citation name and put in source name - creates good citation name in RM8
UPDATE SourceTemplateTable
SET (FieldDefs) = cast(Replace(cast(FieldDefs as Text),'<Root><Fields>','<Root><Fields><Field><FieldName>CitItemD</FieldName><DisplayName>Item Name</DisplayName><Type>Text</Type><Hint>Item Name</Hint><LongHint>To distinguish citations</LongHint><CitationField>True</CitationField></Field>') as blob)
TemplateID > 10000;

-- or this could be TemplateID = a specific template number to just change one template

-- add extra field for name - at the start so it is used for citation name when converting to v8
UPDATE CitationTable 
SET (Fields) = (SELECT cast(Replace(cast(CitationTable.Fields as Text),'<Root><Fields>','<Root><Fields><Field><Name>CitItemD</Name><Value>' || SourceTable.Name ||  '</Value></Field>') as blob) 
                                FROM  SourceTable 
                                WHERE SourceTable.SourceID = CitationTable.SourceID )
    EXISTS (
       SELECT *
       FROM SourceTable 
        WHERE (SourceTable.SourceID = CitationTable.SourceID) 
AND SourceTable.TemplateID > 10000
-- or this could be TemplateID = a specific template number, to just change one template

One Reply to “Naming Citations in Preparation for RM8 #RM7 #Citations

  1. There is or was a problem in RM7.9.320 that I have not checked for in 350 that created false merges from the new Merge Duplicate Citations function because it considered only the fields in the CitationTable, not links from potentially differing WebHints and Media. Many citations imported through TreeShare have all those fields empty and therefore equal despite having different media. Your script could preclude such false duplications because one of the fields tested by the Merge is the Citation Name. By putting the person name or other unique information into the Source name and with your script populating Citation Name with it, the merge would be precluded.

    However, I don’t think the Source Name from TreeShare is differentiated across many different citations so false merging could still be a problem. I posted this risk to feedback. The proper fix is for RM to test for differences in WebHints and Media along with the text fields of the Citation.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.