WebTags – convert to Notes et al #webtags #gedcom

Intro

WebTags, introduced in RootsMagic 6, are not successfully exported to 3rd party software. One wish is for an export option that would append WebTags to the Note or Comment for the related entity which are supported by GEDCOM 5.5. Until that happens, this special SQLite3 query offers a potential workaround and a possible model for a future RM feature.

Conditions

RM6/7 offer the WebTag feature for Persons, Sources, Citations, Places and Research Log items. The first three entities are supported in standard GEDCOM; the last two require custom GEDCOM which is largely incompatible with other software so there is no point in attempting to convert their WebTags. Person Notes, Source Comments and Citation Comments are GEDCOM compatible so that is where we will append the WebTags.

Because there can be multiple WebTags for a given entity, I could not come up with a procedure that appended all its WebTags with a single command. Instead, this script is to be executed repeatedly until the temporary tables it creates are all empty.

Screenshots

WebTagsWindow.PNG
List of WebTags for Hiram Decker-321
WebTagsToNotesWithoutPrivateParts.PNG
Individual Report showing the content from WebTags appended to the Personal Note. Private notes excluded.
WebTagsToNotesWithPrivateParts.PNG
Extract from Individual Report with Private Notes included, thus showing the {RMwebtag}{/RMwebtag} pair demarking each WebTag.

Download

WebTags_to_Notes.sql Rev 2016-11-20

Leave a Reply

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