Outputs, such as reports, will still show duplicate footnotes for the fact. However, as of RM8 Preview 7.9.310, “Merge All Duplicate Citations” can result in duplicate ‘uses’ of the merged or master citation where there were previously duplicate but independent citations linked to the same fact. This is an example of improved database normalisation.Ĭoncomitant with this change is an added feature “Merge All Duplicate Citations” whose effect is to replace all records in the CitationTable having the same Master Source and matching text fields (Citation Details) with one record linked via the CitationLinkTable to all the facts that its duplicates were previously attached.
The one set of citation data then becomes a ‘master’ citation whose edits then carry through to all ‘uses’ of it, just as revisions to a Master Source affect all citations of it in all versions of RM.
RM8 adds the CitationLinkTable which allows one set of citation data to be linked to or ‘used’ by multiple facts. To use the same citation data for more than one fact meant that it had to be replicated in another record, making revisions to the data repetitious and onerous. RootsMagic 8 introduced indirection between citation data (text fields) and the fact to which a citation is attached, In RM7, the citation data and linkage was combined in the CitationTable. or this could be TemplateID = a specific template number, to just change one template WHERE (SourceTable.SourceID = CitationTable.SourceID) WHERE SourceTable.SourceID = CitationTable.SourceID ) SET (Fields) = (SELECT cast(Replace(cast(CitationTable.Fields as Text),'','CitItemD' || SourceTable.Name || '') as blob) add extra field for name - at the start so it is used for citation name when converting to v8 or this could be TemplateID = a specific template number to just change one template SET (FieldDefs) = cast(Replace(cast(FieldDefs as Text),'','CitItemDItem NameTextItem NameTo distinguish citationsTrue') as blob) This will only work for user templates, not for supplied ones (SourceTable.TemplateID > 10000)Īdd in new field - CitItemD for citation name and put in source name - creates good citation name in RM8 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.
So I run this script on my RM version 7 database so that it is ready for importing into RM version 8. Census information available online, international records, public access catalogs, and more Genealogy Online For Dummies, 7th Edition helps you follow the clues to uncover your family?s legacy ? the fun and easy way.
NEW TREE SHARE ROOTSMAGIC 7 HOW TO
Shows you how to conduct research into family history using the latest online tools, mobile apps, and other resources Explains how to use online and offline research techniques and tools for genealogical research, find and share information with other genealogists, and create your own site to showcase your family tree, digital images, and compiled genealogies Includes access to free versions of RootsMagic Essentials and Legacy Family Tree Standard Edition as well as information on free websites for storing your genealogical information Covers DNA research and testing, new geocoding applications, U.S. You?ll discover how to start your investigation, develop a research plan of action, identify sites and resources that will be of the most use to you, get information from government records, preserve electronic materials, and share your findings with the rest of the family. Updated to cover the latest online tools, this new edition shows you how to leverage social networks and the rapidly increasing number of mobile apps to locate family members and trace their histories. Research your family history using the latest online tools and apps Genealogy Online For Dummies, 7th Edition is the perfect book to help you conduct genealogical research.
0 kommentar(er)
