SQL Files List

Tip: use browser’s search on page (Ctrl+F) to help find scripts of interest. The string “RM8” is typically added to the names of those written for scripts revised for or written for RootsMagic 8. The search term “rm8.sql” (sans quotes) will highlight them fast.

SQL files and where they are referenced

SQL FileUsed inDescription
Add-name-field-to-citations-RM7.sqlNaming Citations in Preparation for RM8 #RM7 #Citations
Addresses-HowUsed.sqlAddresses - How Used #RM7caption
Addresses-with-No-Name-1.sql
Addresses-with-No-Name.sql
AddressHowUsed-RM7.sqlAddresses - How Used #RM7
Ahnentafel-64_tidy.sqlAhnentafel 64 generations #ahnentafel #ancestors #reports
Ahnentafel-64.sqlAhnentafel 64 generations #ahnentafel #ancestors #reports
Ahnentafel-64.sqlList of Pages imported from Wikispaces Site
Ahnentafel-64.sqlQuery Menu
Ahnentafel-64.sqlSQLite Queries #sqlitemanagers #sql
AllCitations-RM7.sqlAll Citations - Query #citationsCitation list (for RM7 database format)
AllCitations-RM8.sqlAll Citations - Query #citationsCitation list (for RM8 database format)
AllCitations-RM8.sqlAll Citations - Query #citationsCTE version by Pat Jones, rev. 2022-04-27 by Tom Holden to include duplicate uses.
AllCitations.sqlAll Citations & Dupes Count - Query #citations #duplicates
AllCitations.sqlAll Citations - Query #citations
AllCitations.sqlAllCitations.sql Error
AllCitations.sqlBundled Utilities - Groupings #application
AllCitations.sqlList of Pages imported from Wikispaces Site
AllCitations.sqlEarlier Queries by Date
AllCitations.sqlQuery Menu
AllCitations.sqlSQLite Queries #sqlitemanagers #sql
AllCitations.sqlhome - as exported
AllCitations.sqlAll Citations - Query #citationsQuery to list all citations for RM4-7, rev 2022-04-26
AllCitationsDupes-1.sql
AllCitationsDupes.sqlAll Citations & Dupes Count - Query #citations #duplicates
AllFacts4Person10-OO.sql
AllFacts4Person11-OO.sqlPulling Together All the Events for An Individual #person #events #lifelineA TimeLine list of events. RM8 compatible.
AllFacts4Person4.sqlPulling Together All the Events for An Individual #person #events #lifeline
AllFacts4Person5.sqlBirths of children as facts #birth #child #events
AllFacts4Person5.sql
AllFacts4Person8.sqlPulling Together All the Events for An Individual #person #events #lifeline
AllFacts4Person9.sql
AllFactsWidthTestGenerate.sqlGEDCOM & DnD Event Description Length Anomalies & Bugs #gedcom #events
AllFactsWidthTestParameters.sqlGEDCOM & DnD Event Description Length Anomalies & Bugs #gedcom #events
Ancestors.sqlAhnentafel 64 generations #ahnentafel #ancestors #reports
Ancestors.sqlAncestors Named Group #namedgroup #pedigree
Ancestors.sqlAncestors Query - Recursive #recursive
Ancestors.sqlAncestors Query #pedigree
Ancestors.sqlAnother version of a Set Living query #living
Ancestors.sqlBundled Utilities - Groupings #application
Ancestors.sqlChildren - Set Lineage to Birth #birth #ancestors #lineage
Ancestors.sqlList of Pages imported from Wikispaces Site
Ancestors.sqlEarlier Queries by Date
Ancestors.sqlGroup - Ancestors #ancestors #namedgroup #recursive
Ancestors.sqlGroup - Descendants #descendants #namedgroup #recursive
Ancestors.sqlLiving Flag - Set Globally #living #update #recursive
Ancestors.sqlMaps - Geo-Pedigree, plotting your ancestors' birth places #googlemaps #geocoding
Ancestors.sqlNamed Group Refresh #namedgroup
Ancestors.sqlNames - Delete Duplicate Alternate Names of Type 'Married' #alternatenames #names #duplicates
Ancestors.sqlQuery - All Names in Tree
Ancestors.sqlQuery Menu
Ancestors.sqlRecursive Queries - Ancestors and Descendants #recursive #ancestors #descendants
Ancestors.sqlSQLite Queries #sqlitemanagers #sql
Ancestors.sqlSet Living Flag #update #living
Ancestors.sqlSplitTree #splittreeancestorsleaves #application #visualc
Ancestors.sqlSubmit Your Problem #requestforhelp
Ancestors.sqlWish List
Ancestors.sqlhome - as exported
AncestorsGroup.sqlAncestors Named Group #namedgroup #pedigree
AncestorsGroup.sqlBundled Utilities - Groupings #application
AncestorsGroup.sqlQuery Menu
AncestorsGroup.sqlSQLite Queries #sqlitemanagers #sql
AncestorsRecursive.sqlRecursive Queries - Ancestors and Descendants #recursive #ancestors #descendants
Birth-AddFromChristenBaptism.sqlBirths - Add from Christening or Baptism #birth #events
BirthYearMisMatch.sqlBirth Year Mis-Match #date #birth
BirthYearMisMatch.sqlBundled Utilities - Groupings #application
BirthYearMisMatch.sqlDeath Year Mismatch #date #death
BirthYearMisMatch.sqlQuery Menu
BirthYearMisMatch.sqlSQLite Queries #sqlitemanagers #sql
BMD_private_multiples.sqlPrivatise Extra BMD Events #events #reports #privateScript for privatising plural BMD events.
BMD_private_multiples2.sqlPrivatise Extra BMD Events #events #reports #privateEnhanced to privatise all non-Primary BMD mults
Census-needed-1871-Canada-group-Unmark-list-1.sql
Census-needed-1871-Canada-group-Unmark-list.sqlNamed Group - Mark or Unmark List refresh #namedgroup
CensusNeededGroup.sqlA Proposal for a Named Group and Color Manager
CensusNeededGroup.sqlBundled Utilities - Groupings #application
CensusNeededGroup.sqlCensus Needed - Named Group #namedgroup #census
CensusNeededGroup.sqlQuery Menu
CensusNeededGroup.sqlSQLite Queries #sqlitemanagers #sql
CensusNeededGroup.sqlAargh! Systemic Error re: GroupID
CensusNeededGroup2-RM8.sqlCensus Needed - Named Group #namedgroup #census
CensusNeededGroup2.sqlBundled Utilities - Groupings #application
CensusNeededGroup2.sqlCensus Needed - Named Group #namedgroup #census
CensusNeededGroup2.sqlQuery Menu
CensusNeededGroup2.sqlSQLite Queries #sqlitemanagers #sql
CensusNeededGroup2.sqlAargh! Systemic Error re: GroupID
CensusNeededGroup2.sqlCensus Needed - Named Group #namedgroup #census
CheckTMGimportforCodes.sqlTMG-RootsMagic Sentence Variables & Format Codes #tmg
Children-NeedingManualArranging-2.sqlChildren - Needing Manual Arranging #child #family #sortdate
Children-NeedingManualArranging.sqlChildren - Needing Manual Arranging #child #family #sortdate
Children-NeedingManualArranging.sql
Children-SetLineage2Birth.sqlChildren - Set Lineage to Birth #birth #ancestors #lineage
Children-SetOrderByBirthSortDate.sqlChildren - Needing Manual Arranging #child #family #sortdate
Children-SetOrderByBirthSortDate.sqlChildren - Set Order by Birth SortDate #child #family #sortdate #update
Citations_TMGimport_splitCDtoCD1-2.sql
Citations_TMGimport_splitCDtoCD1-9.sqlTMG-RootsMagic Split Citation Details #tmg #citations #sourcetemplates
Citations-Dupes-Delete.sqlCitations - Delete Duplicates #citations #sources #duplicates
Citations-Invisible-Convert-to-Personals-1.sql
Citations-Invisible-Convert-to-Personals-Flagged-1.sql
Citations-Invisible-Convert-to-Personals-Flagged.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
Citations-Invisible-Convert-to-Personals.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
Citations-Invisible-Convert-to-Personals.sqlCitations Invisible Revealed #citations #ancestrycom
Citations-Invisible-List-1.sql
Citations-Invisible-List.sqlCitations Invisible Revealed #citations #ancestrycom
Citations-Invisible-Revealed-Revert-1.sql
Citations-Invisible-Revealed-Revert-Bitwise-1.sql
Citations-Invisible-Revealed-Revert-Bitwise.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
Citations-Invisible-Revealed-Revert.sqlCitations Invisible - Reveal and Revert #citations #sources #ftm2014 #ftm2012 #ancestrycom #gedcom
CitationSort-RM8.sqlSource Citation Sort RM8 #sources #citations
CitationSort.sqlSource Citation Sort #sources #citations
ColorCode-byConsanguinity1.sqlColor Code by Consanguinity Degree #colorcoding #relationships
ColorCode-byConsanguinity2.sqlColor Code by Consanguinity Degree #colorcoding #relationships
ColorCode-byConsanguinity3.sqlColor Code by Consanguinity Degree #colorcoding #relationships
ColorCode-byLivingFlag.sqlLiving Flag - Set Globally #living #update #recursive
CopyFact2Group.sqlBundled Utilities - Groupings #application
CopyFact2Group.sqlCopy Fact to Group #update #namedgroup #events
CopyFact2Group.sqlQuery Menu
CopyFact2Group.sqlSQLite Queries #sqlitemanagers #sql
CopyFact2Group.sqlAargh! Systemic Error re: GroupID
CopyFact2Group.sqlCopy Fact to Group #update #namedgroup #eventsrev, 2020-05-16
cte-facts-citations-RM7.sqlCommon Table Expressions – The Building Blocks of SQLEvents and Citations list demonstrating use of Common Table Expressions (for RM7 database format)
cte-facts-citations-RM8.sqlCommon Table Expressions – The Building Blocks of SQLEvents and Citations list demonstrating use of Common Table Expressions (for RM8 database format)
CustomDatabaseShell.sqlBundled Utilities - Groupings #application
CustomDatabaseShell.sqlDepopulate but keep Customs, Places, Sources #database #places #placedetails #sourcetemplates #sources #facttypes #custom #media #roles
CustomDatabaseShell.sqlQuery Menu
CustomDatabaseShell.sqlSQLite Queries #sqlitemanagers #sql
Database-CopyMasterListsToShell.sqlDatabase - Copy Master Lists to Shell
DateDecoder.sqlBundled Utilities - Groupings #application
DateDecoder.sqlDate Decoder #date
DateDecoder.sqlDates - SortDate Algorithm #date #sortdate
DateDecoder.sqlQuery Menu
DateDecoder.sqlSQLite Queries #sqlitemanagers #sql
DateFormat.sqlDate Decoder #date
DateFormat.sql
DeathYearMisMatch.sqlBundled Utilities - Groupings #application
DeathYearMisMatch.sqlDeath Year Mismatch #date #death
DeathYearMisMatch.sqlQuery Menu
DeathYearMisMatch.sqlSQLite Queries #sqlitemanagers #sql
DeleteByColorCode.sqlDelete Many #delete
DeleteByColorCode.sqlDelete Phantoms #database #delete #phantom
DeleteByColorCode.sqlQuery Menu
DeleteByColorCode.sqlSQLite Queries #sqlitemanagers #sql
DeleteByNamedGroup.sqlDelete Many #delete
DeleteByNamedGroup.sqlQuery Menu
DeleteByNamedGroup.sqlSQLite Queries #sqlitemanagers #sql
DeleteByNamedGroup.sql
DeleteByNamedGroup2.sqlDelete Many #delete
DeleteDuplicateCitationLinks-RM8.sqlCitation 'Uses' and Duplicates #rm8 #citations #duplicatesSQL script for deleting duplicate uses of a citation
DeletePhantoms.sqlDelete Many #delete
DeletePhantoms.sqlDelete Phantoms #database #delete #phantom
DeletePhantoms.sqlMedia - Delete Unused #media #delete
DeletePhantoms.sqlPlaces - Delete Unused #places #placedetails #delete #phantom
DeletePhantoms.sqlQuery Menu
DeletePhantoms.sqlSQLite Queries #sqlitemanagers #sql
DeletePhantoms.sqlUpdates responding to TreeShare
DeletePhantoms2.sqlDelete Phantoms #database #delete #phantom
DeletePhantoms3.sqlDelete Phantoms #database #delete #phantom
DeletePhantoms3.sqlUpdates responding to TreeShare
DeletePhantoms3.sqlDelete Phantoms #database #delete #phantom
Depopulate-RM7_5.sqlReturning to RM7.5 custom reports, groups and Publisher from RM8 via GEDCOM
DescendantsRecursive.sqlRecursive Queries - Ancestors and Descendants #recursive #ancestors #descendants
DNA_mtDNA_locationslist.sqlBundled Utilities - Groupings #application
DNA_mtDNA_locationslist.sqlDNA Test results list #dna #xml #replace
DNA_mtDNA_locationslist.sqlQuery Menu
DNA_mtDNA_locationslist.sqlSQLite Queries #sqlitemanagers #sql
DNA_Y-STR_markerslist.sqlBundled Utilities - Groupings #application
DNA_Y-STR_markerslist.sqlDNA Test results list #dna #xml #replace
DNA_Y-STR_markerslist.sqlQuery Menu
DNA_Y-STR_markerslist.sqlSQLite Queries #sqlitemanagers #sql
DummyFamily-Add.sqlQuery Menu
DummyFamily-Add.sqlReports, Narrative, Jerry Bryan Trick #reports
DummyFamily-Add.sqlSQLite Queries #sqlitemanagers #sql
DummyFamily-Add2.sqlReports, Narrative, Jerry Bryan Trick #reports
DummyFamily-Delete.sqlQuery Menu
DummyFamily-Delete.sqlReports, Narrative, Jerry Bryan Trick #reports
DummyFamily-Delete.sqlSQLite Queries #sqlitemanagers #sql
DummyFamily-Delete.sql
DuplicateNameSearch.sqlBundled Utilities - Groupings #application
DuplicateNameSearch.sqlDuplicate Name Search - query #duplicates #names
DuplicateNameSearch.sqlQuery Menu
DuplicateNameSearch.sqlSQLite Queries #sqlitemanagers #sql
Empty4084Schema.sqlVersion Monitoring #database #databaseproperties #datadefinitions
Empty4097Schema.sql
Empty4098Schema.sql
Empty4114Schema.sql
Empty4121Schema.sqlVersion Monitoring #database #databaseproperties #datadefinitions
Event-Add_Marriage.sqlList of Pages imported from Wikispaces Site
Event-Add_Marriage.sqlEvent - Add Marriage to Couples Without #events
Event-Add_Marriage.sqlQuery Menu
EventDescriptionToNote-Move.sqlEvents - Move Description to Note #events #notes
EventNoteToDescription-Move.sqlEvents - Move Short Note to Description #events #tmg #notes
Events-AddSharedParent-RM7.sqlEvents - Add to all Children a Parent event shared with parents #facttypes #sharedevent #relationships #rm8Adds a Parent event to each child shared with Parents
Events-CitationsMissing-UsingViews.sqlA Sample Query Created with Views #events #colorcoding #sql #views #citations #sources
Events-CitationsMissing-UsingViews.sqlEarlier Queries by Date
Events-CitationsMissing-UsingViews.sqlhome - as exported
Events-FMNO.sqlFacts - Add custom MRIN event to each family #facttypes #events #mrin
Events-MismatchedFMNO.sqlFacts - Add custom MRIN event to each family #facttypes #events #mrin
Events-sans_media_rescensus-1.sql
Events-sans_media_rescensus.sqlEvents with no Media attached #events #media
FactOrderTable.sqlFacts - Sort Order Problems #events #date #sortdate
FactOrderTable.sqlQuery Menu
Facts_shared-ChangeType-RM8.sqlFacts - Change Fact Type #facttypes #events #rm8
Facts_shared-ChangeType.sqlFacts - Change Fact Type #facttypes #events #rm8
Facts-ChangeType.sqlFacts - Change Fact Type #facttypes #events #rm8Globally change events of one Fact Type to another.
Facts-ChangeType.sqlFacts - Change Fact Type #facttypes #events #rm8
Facts-RefNos_person_spouse_parents.sqlFacts - Reference Numbers for person, spouse and parents. #facttypes #events #refno
Facts-Split-HideTracks.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-Split-HideTracks.sqlQuery Menu
Facts-Split-Undo-RM9.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-Split-Undo.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-Split-Undo.sqlQuery Menu
Facts-SplitSharedToIndiv-NoRIN.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-SplitSharedToIndiv-RM9.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-SplitSharedToIndiv.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-SplitSharedToIndiv.sqlQuery Menu
Facts-TranslateNames.sqlLanguage other than English #languages #reports #french
Facts-Unshare.sqlFacts - Split Shared to Individual #facttypes #events #sharedevent #RM9
Facts-Unshare.sqlQuery Menu
FactsHavingPlaceDetails.sqlBundled Utilities - Groupings #application
FactsHavingPlaceDetails.sqlFacts Having Place Details - Query #placedetails #events
FactsHavingPlaceDetails.sqlQuery Menu
FactsHavingPlaceDetails.sqlSQLite Queries #sqlitemanagers #sql
FactsHavingPlaceDetails2.sqlFacts Having Place Details - Query #placedetails #events
FactsHavingPlaceDetails3.sqlBundled Utilities - Groupings #application
FactsHavingPlaceDetails3.sqlFacts Having Place Details - Query #placedetails #events
FactsHavingPlaceDetails3.sqlQuery Menu
FactsHavingPlaceDetails3.sqlSQLite Queries #sqlitemanagers #sql
FactsSharedWithTreelessPersons-OO.sqlPeople Who Share A Fact with a Principal, But Who Are Not in a Tree in The File List - Query #sharedevent #person
FactType-Convert-Census_shared-to-Year_Census-1.sql
FactType-Convert-Census_shared-to-Year_Census.sqlFact Type - Convert Census to yyyy Census and back #facttypes #census
FactType-Convert-Census_unshared-to-Year_Census-1.sql
FactType-Convert-Census_unshared-to-Year_Census.sqlFact Type - Convert Census to yyyy Census and back #facttypes #census
FactType-Convert-Census-to-Year_Census.sql
FindAlmostEverywhere-Build_FTS_table.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search #rm8
FindAlmostEverywhere-Build_FTS_table.sqlSearch - Find Almost Everywhere #search #fts
FindAlmostEverywhere-Search_LocateQuery.sqlSearch - Find Almost Everywhere #search #fts
FindAlmostEverywhere-Search_Simple.sqlSearch - Find Almost Everywhere #search #fts
FindAlmostEverywhere-Snippet_Waymarks_LocateQuery.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search #rm8
FindAlmostEverywhere.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search #rm8
FindAlmostEverywhere.sqlSearch - Find Almost Everywhere #search #fts
FindEverywhere.sql
FTMimport-MoveEventPlaceDetail2Description.sqlFTM import - restore Event description from Place Details #ftm2014 #ftm2012 #placedetails #events
Geo-Lifelines.sqlGeo-Lifelines Query #places #placedetails #geocoding #events
Group-Ancestors.sqlGroup - Ancestors #ancestors #namedgroup #recursive
Group-Descendants.sqlGroup - Descendants #descendants #namedgroup #recursive
Group-Extract.sqlGroups - Extract most everything for one to a new database #namedgroup #TreeShare
Group-PersonsWithDuplicateEvents-RM8.sqlGroup - Persons with Duplicate Events #namedgroup #events #date #duplicates
Group-PersonsWithDuplicateEvents.sqlGroup - Persons with Duplicate Events #namedgroup #events #date #duplicates
Group-PersonsWithTextDates-RM10.sqlGroup - Persons with Text Dates #date #namedgroupGroup: Persons with a Text Date, for RM10
Group-PersonsWithTextDates.sqlGroup - Persons with Text Dates #date #namedgroup
Group-UnconnectedPersons.sqlGroup - Unconnected Persons #namedgroup
GroupsPopulation-RM8.sqlGroup - Population statistic #namedgroup
GroupsPopulation.sqlGroup - Population statistic #namedgroup
GroupTableWrite.sqlNamed Group Refresh #namedgroup
Import_RM8_to_RM7-Part2.sqlDirect Import of RM8 database into RM7 – Part 2SQLite script that directly imports a RM8 database into RM7
Import_RM8_to_RM7-Part2A.sqlDirect Import of RM8 database into RM7 – Part 2
Import_RM8_to_RM7-V3.sqlConvert RM8 Database to RM7 #rm8 #rm7
Import_RM8_to_RM7.sqlDirect Import of RM8 database into RM7 - Part 1SQLite script for direct import of RM8 data into a RM7 database
Import_RM8_to_RM7.sqlDirect Import of RM8 database into RM7 – Part 2SQLite script for direct import of RM8 data into a RM7 database
Import_RM8_to_RM7.sqlConvert RM8 Database to RM7 #rm8 #rm7SQLite script for direct import of RM8 data into a RM7 database
ImportPicasaDescriptions.sqlMedia Metadata, Read, Write, Compare with Picasa #media #metadata #picasa
ImportPicasaDescriptions.sqlQuery Menu
ImportPicasaDescriptions.sqlSQLite Queries #sqlitemanagers #sql
KinshipList.sqlRelationships #relationships
LifeLines-OO.sqlLifeLines #places #placedetails #events #lifelines
LifeLines-OO.sqlSQLiteManagers #sqlitemanagers
LifeLines-RINparm.sqlLifeLines #places #placedetails #events #lifelines
LivingFlag-GlobalSet.sqlLiving Flag - Set Globally #living #update #recursive
Make-Pop-TmpCitation.sql
MapEvents-KML.sqlBundled Utilities - Groupings #application
MapEvents-KML.sqlList of Pages imported from Wikispaces Site
MapEvents-KML.sqlEarlier Queries by Date
MapEvents-KML.sqlMapEvents-KML query #googlemaps #places #placedetails #geocoding #events
MapEvents-KML.sqlQuery Menu
MapEvents-KML.sqlSQLite Queries #sqlitemanagers #sql
MarkNotProblem.sqlBundled Utilities - Groupings #application
MarkNotProblem.sqlDuplicate Search Merge Database #datadefinitions #duplicates
MarkNotProblem.sqlQuery Menu
MarkNotProblem.sqlSQLite Queries #sqlitemanagers #sql
MarriageLength.sqlMarriages, Length of #marriage
MasterSources-RM8.sqlSource List Query #sources #sourcetemplates #citations #xml #dateMaster Source List query compatible with both RM8 and prior versions to RM4. Pat Jones.
MasterSources.sqlEarlier Queries by Date
MasterSources.sqlSource List Query #sources #sourcetemplates #citations #xml #date
MasterSources.sqlhome - as exported
MasterSources.sqlSource List Query #sources #sourcetemplates #citations #xml #date
Media-DupFilesList.sqlMedia Duplicates - Reports and Remedies
Media-DupThumbnailsList.sqlMedia Duplicates - Reports and Remedies
Media-MergeDuplicates.sqlMedia Duplicates - Reports and Remedies
Media-UsersList.sqlMedia Users List Query #media #rm8Traces where media files are used better than RM4
Media-UsersList3.sqlMedia Users List Query #media #rm8Traces where media files are used better than RM4. (In RMtrix app)
Media-UsersList4-RM7.sqlMedia Users List Query #media #rm8Traces where media files are used better than RM5-7
Media-UsersList4-RM8.sqlMedia Users List Query #media #rm8Traces where media files are used better than RM8 7.9.180
Media-UsersList4.sqlMedia Users List Query #media #rm8Traces where media files are used better than RM5-RM7
MediaDeleteUnused.sqlMedia - Delete Unused #media #delete
MediaDeleteUnused.sqlQuery Menu
MediaList-RM5.sqlMedia List Query #media #filenames #msexcel #date #person #family #events #sources #citations #places #placedetails
MediaList.sqlMedia List Query #media #filenames #msexcel #date #person #family #events #sources #citations #places #placedetails
MediaRepair.sqlBundled Utilities - Groupings #application
MediaRepair.sqlMedia Repair Queries #filenames #duplicates #media #links #rmnocase #delete #update
MediaRepair.sqlQuery Menu
MediaRepair.sqlSQLite Queries #sqlitemanagers #sql
MediaShuffle.sqlMedia - Bulk Rename and Relink #media #multimediatable #batch
MediaTags-CopySharedFactsMediaToShareePersonal.sqlMediaTags - Copy Shared Facts Media To Sharee Personal #media #sharedevent
MediaTags-CopySharedFactsMediaToShareePersonal.sqlQuery Menu
MediaTags-DeletePersonalHavingFactDupes.sqlMediaTags - Copy Shared Facts Media To Sharee Personal #media #sharedevent
MediaTags-DeletePersonalHavingFactDupes.sqlMediaTags - Delete Personal Having Fact Duplicates #media
MediaTags-DeletePersonalHavingFactDupes.sqlQuery Menu
MediaTags-SetPrimaryForPersons.sqlMedia - Set Primary Photo for Persons #media #update
MediaTypeReset.sqlMedia Type Reset #media #update
MediaTypeReset.sqlQuery Menu
MediaTypeReset.sqlSQLite Queries #sqlitemanagers #sql
MediaTypeReset.sqlMedia Type Reset #media #update
MergeAncestryURLsToFTM.sqlAncestry.com and RootsMagic 5 #ancestrycom #sources #update #gedcom
MergeAncestryURLsToFTM.sqlQuery Menu
MergeAncestryURLsToFTM.sqlSQLite Queries #sqlitemanagers #sql
MergeDupeNotes-CTE-1.sqlRemove Duplicate Merged Notes
MergeDupeNotes-CTE-2.sqlRemove Duplicate Merged Notes
MergeDupeNotes-CTE.sqlRemove Duplicate Merged Notes
missing_stuff.sqlEvents with no Media attached #events #media
Multi-spouses.sqlMultiple Spouses query #spouse #multiplesLists people with count of multiple spouses. RM4 to RM8 compatible.
Name-Add_Married-RM7.sqlNames - Add Married #names #alternatenames #marriage #spouseAdds Married Name to female spouses. RM5 to RM7 compatible.
Name-Add_Married-RM8.sqlNames - Add Married #names #alternatenames #marriage #spouseAdds Married Name to female spouses. RM8 compatible.
Name-Add_Married.sqlNames - Add Married #names #alternatenames #marriage #spouse
Name-Add_Married.sqlQuery Menu
Name-Add_Married.sqlSQLite Queries #sqlitemanagers #sql
Name-Married_in_DeathSentence.sqlNames - married name in death sentences #names #alternatenames #death
NameFind.sqlBundled Utilities - Groupings #application
NameFind.sqlName Find query #search
NameFind.sqlQuery Menu
NameFind.sqlSQLite Queries #sqlitemanagers #sql
Names-AltMarriedDupeDelete.sqlNames - Delete Duplicate Alternate Names of Type 'Married' #alternatenames #names #duplicates
Names-ConcordanceCaps.sqlReports - Concordances for Indexes #names #alternatenames #places #reports #msword #index
Names-ConcordanceCapsFirstYrsMids.sqlReports - Concordances for Indexes #names #alternatenames #places #reports #msword #index
Names-Edit_NameTable.sqlList of Pages imported from Wikispaces Site
Names-Edit_NameTable.sqlEarlier Queries by Date
Names-Edit_NameTable.sqlNames - Edit NameTable with SQLite Expert #names #alternatenames #editable #sqliteexpert
Names-Swap_AltBirth_to_Primary.sqlNames - Set Alternate of type Birth to Primary #names #alternatenames #birth
NickAltNameConflict.sqlNickname Manipulations #nicknames
NickGivenCombine.sqlNickname Manipulations #nicknames
NickGivenSplit.sqlNickname Manipulations #nicknames
NicknameAmbivalent.sqlNickname Manipulations #nicknames
Notes-Invisible-Convert-to-General-1.sql
Notes-Invisible-Convert-to-General.sqlNotes Invisible Revealed #notes #tmg #gedcom
Notes-Invisible-List-1.sql
Notes-Invisible-List.sqlNotes Invisible Revealed #notes #tmg #gedcom
Notes-RemoveDupMerged-CTE.sqlRemove Duplicate Merged Notes
OrphanedPlaceDetails_DeleteUnused.sqlPlace Details without a Place #placedetails #phantom
OrphanedPlaceDetails_DeleteUnused.sqlPlace Errors #placedetails #places
OrphanedPlaceDetails.sqlPlace Details without a Place #placedetails #phantom
OrphanedPlaceDetails.sqlPlace Errors #placedetails #places
Paragraph-add.sqlBundled Utilities - Groupings #application
Paragraph-add.sqlParagraphing #update #paragraphing #reports
Paragraph-add.sqlQuery Menu
Paragraph-add.sqlSQLite Queries #sqlitemanagers #sql
Paragraph-strip.sqlBundled Utilities - Groupings #application
Paragraph-strip.sqlParagraphing #update #paragraphing #reports
Paragraph-strip.sqlQuery Menu
Paragraph-strip.sqlSQLite Queries #sqlitemanagers #sql
Parents-Three_Childrens_Names.sqlQuery to Search Parents by Children's Given Names #search #familyLists parents given a name for each of three children in a database.
ParentSingleMerge.sqlMerge Duplicate Single Parent Couples #merge #spouse #child #phantom
PersonsBegatChildren.sqlBirths of children as facts #birth #child #eventsA list of "Begat" events for the births of children in the lives of the parents. RM4 - RM8 (caption)
PersonsWithTextDates.sqlGroup - Persons with Text Dates #date #namedgroup
PersonsWithTextDates.sql
Place_Details-Convert_to_Place.sqlPlaces to Place Details Conversion #places #placedetails #update
Place_Frequency_GPSVisualizer.sqlMaps - markers proportional to number of events #googlemaps #geocoding
Place_Frequency.sqlMaps - markers proportional to number of events #googlemaps #geocoding
Place_Frequency.sqlPlaces - Frequency of Use #places #geocoding
Place_Frequency.sqlQuery Menu
PlaceAbbrevUpdate.sqlPlace Names - parse and recombine #places #instr
PlaceAbbrevUpdate.sqlQuery Menu
PlaceCommaParse.sqlPlace Names - parse and recombine #places #instr
PlaceCommaParse.sqlQuery Menu
PlaceErrors3.sqlPlace Errors #placedetails #places
PlaceNameUpdate.sqlPlace Names - parse and recombine #places #instr
PlaceNameUpdate.sqlQuery Menu
PlaceParse.sqlPlace Names - parse and recombine #places #instr
PlaceReverse.sqlPlaces - Count People and Events for a Group #places #statistics #events #namedgroup
Places-ConvertPlaceDetailsToPlaces.sqlPlaces - Conversion of Place Details to Places #places #placedetails #update
Places-EventCount.sqlPlaces - Count People and Events for a Group #places #statistics #events #namedgroup
Places-FirstNameExploit.sqlPlaces - first name exploit for improved narratives #places #reports
Places-PeopleCount.sqlPlaces - Count People and Events for a Group #places #statistics #events #namedgroup
Places-RecombineFTMfractures.sqlPlaces - Recombine Fractures from FTM 2012 #ancestrycom #ftm2012 #places
Places-RecombineFTMfractures.sqlQuery Menu
Places-UnConvertPlaceDetailsConvertedToPlaces.sqlPlaces - Conversion of Place Details to Places #places #placedetails #update
PlacesDeleteUnused.sqlPlaces - Delete Unused #places #placedetails #delete #phantom
PlacesWithoutGeocodesForGroup.sqlPlaces without Geo-codes for Named Groups #places #placedetails #geocoding #namedgroup
PrivatizeLiving.sqlPrivatize Living #private #reports #gedcom
Proven.sqlBackup Media with Database - RAR #batch #backup #media #rar
Proven.sqlChildren - Set Lineage to Birth #birth #ancestors #lineage
Proven.sqlList of Pages imported from Wikispaces Site
Proven.sqlEarlier Queries by Date
Proven.sqlQuery Menu
Proven.sqlReportNon_proven #events
Proven.sqlSource Templates by Origin #sourcetemplates
Proven.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Proven.sqlTools - Problem Search - Spouse Order Questioned #tools #spouse
Proven.sqlCommon Table Expressions – The Building Blocks of SQL
RecursiveAncestors.sqlAncestors Query - Recursive #recursive
REFN_CopyFSID-RM9.sqlCOPY FamilySearchID to REFN fact #refno #FamilySearchCopies FSID to REFN type event set as Primary and shuffles all other REFN event records to follow. For RM9.
REFN_CopyFSID.sqlCOPY FamilySearchID to REFN fact #refno #FamilySearch
REFN-MRIN-RM10.sqlRIN MRIN - add Reference Number fact to all persons #mrin #refno #rinScript adds Ref# fact to each person containing RIN and MRIN
REFN-MRIN.sqlRIN MRIN - add Reference Number fact to all persons #mrin #refno #rin
REFN-RematchFSID.sqlREMATCH to FamilySearch ID in REFN fact #FamilySearch #refno
Reports-NewParagraphGeneralNote.sqlReports - New Paragraph for General Note #paragraphing #reports
Reports-PointFormNarrativeSetup.sqlReports - Point Form Narratives Setup #reports
Reports-PointFormNarrativeSetup2.sqlReports - Point Form Narratives Setup #reports
Reports-RestoreAfterPointForm.sqlReports - Point Form Narratives Setup #reports
Reports-RestoreAfterPointForm2.sqlReports - Point Form Narratives Setup #reports
RM4_Copy_data_to_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM4_CREATE_as_DB3_NOCASE.sqlComparing Two RM Databases #compare #database #rmnocase
RM4_CREATE_as_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM4_Queries.sqlFour Little Queries #names #blanks #placedetails
RM4_Queries.sqlSubmit Your Problem #requestforhelp
RM4_Queries.sqlhome - as exported
RM4-MultiLinkedMediaDuplicationPreRM5.sqlMedia - Preserve Captions et al from RM4 to RM5 #media #metadata #batch
RM4-MultiLinkedMediaDuplicationPreRM5.sqlQuery Menu
RM4-MultiLinkedMediaDuplicationPreRM5.sqlSQLite Queries #sqlitemanagers #sql
RM5_Copy_data_to_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM5_CREATE_as_DB3_NOCASE.sqlConvert Database to NOCASE #rmnocase
RM5copyMetadataToImageFileExifToolArgList.sqlMedia Metadata, Read, Write, Compare with Picasa #media #metadata #picasa
RM5copyMetadataToImageFileExifToolArgList.sqlQuery Menu
RM5copyMetadataToImageFileExifToolArgList.sqlSQLite Queries #sqlitemanagers #sql
RM5copyMetadataToRM.sqlMedia Metadata, Read, Write, Compare with Picasa #media #metadata #picasa
RM5copyMetadataToRM.sqlQuery Menu
RM5copyMetadataToRM.sqlSQLite Queries #sqlitemanagers #sql
RM6_WaymarksViews.sql
RM7_5_WaymarksViews-1.sql
RM7_5_WaymarksViews.sqlAncestry TreeShare - Impact #ancestrycom #TreeShare
RM7_5_WaymarksViews.sqlEvents with no Media attached #events #media
RM7_5_WaymarksViews.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search #rm8
RM7_5_WaymarksViews.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
RM7_5_WaymarksViews.sqlUpdates responding to TreeShare
RM7_5_WaymarksViews.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search #rm8Provides navigation waymarks from any record in most RM database tables to a User Interface in the RM7.5 application.
RM8_WaymarksViews.sqlSearch - wayfinding from data tables to RootsMagic screens #database #fts #search #rm8Provides navigation waymarks from any record in most RM database tables to a User Interface in the RM8 application.
RMGC_Properties.sqlBundled Utilities - Groupings #application
RMGC_Properties.sqlCitations - Delete Duplicates #citations #sources #duplicates
RMGC_Properties.sqlList of Pages imported from Wikispaces Site
RMGC_Properties.sqlGEDCOM & DnD transfer losses #gedcom
RMGC_Properties.sqlMedia Repair Queries #filenames #duplicates #media #links #rmnocase #delete #update
RMGC_Properties.sqlPlace Details without a Place #placedetails #phantom
RMGC_Properties.sqlQuery Menu
RMGC_Properties.sqlRMGC_Properties - Query #database
RMGC_Properties.sqlSQLite Queries #sqlitemanagers #sql
RMGC_Properties.sqlShared Events With Missing Witnesses #sharedevent
RMGC_Properties.sqlRMTREE Properties Query for RM8
RMGC_TablesRowCount.sqlRMGC Tables Row Count #databaseproperties #integrity
RMTREE_Properties.sqlRMTREE Properties Query for RM8
RoleSort.sqlRoles-Sort Alphabetically #roles #facttypes
SharableEvents-Convert.sqlBundled Utilities - Groupings #application
SharableEvents-Convert.sqlQuery Menu
SharableEvents-Convert.sqlSQLite Queries #sqlitemanagers #sql
SharableEvents-Convert.sqlSharable Events - Find and Convert to Shared #sharedevent
SharableFacts2-RM8.sqlSharable Events - Find and Convert to Shared #sharedeventSQLite script that lists events in a RootsMagic 8 database that have so much in common that they may be consolidated under a shared event.
SharableFacts2.sqlBundled Utilities - Groupings #application
SharableFacts2.sqlQuery Menu
SharableFacts2.sqlSQLite Queries #sqlitemanagers #sql
SharableFacts2.sqlSharable Events - Find and Convert to Shared #sharedevent
SortDateDecodeDev.sqlDates - SortDate Algorithm #date #sortdate
SortDateDecodeDev.sqlQuery Menu
SortDateDecodeDev.sqlSQLite Queries #sqlitemanagers #sql
SortDateEncodeDecode.sqlBundled Utilities - Groupings #application
SortDateEncodeDecode.sqlDates - SortDate Algorithm #date #sortdate
SortDateEncoderDev.sqlDates - SortDate Algorithm #date #sortdate
SortDateEncoderDev.sqlEarlier Queries by Date
SortDateEncoderDev2.sqlDates - SortDate Algorithm #date #sortdate
SortDateSameDayOrder.sqlBundled Utilities - Groupings #application
SortDateSameDayOrder.sqlDates - Same Day Sort Order #date #sortdate #update
SortDateSameDayOrder.sqlEvents - Add to all Children a Parent event shared with parents #facttypes #sharedevent #relationships #rm8
SortDateSameDayOrder.sqlQuery Menu
SortDateSameDayOrder.sqlQuery to Add Parents Events to RM Database #facttypes #events #sharedevent
SortDateSameDayOrder.sqlSQLite Queries #sqlitemanagers #sql
SortDateSameDayOrderCustom.sqlBundled Utilities - Groupings #application
SortDateSameDayOrderCustom.sqlDates - Same Day Sort Order #date #sortdate #update
SortDateSameDayOrderCustom.sqlEvents - Add to all Children a Parent event shared with parents #facttypes #sharedevent #relationships #rm8
SortDateSameDayOrderCustom.sqlQuery Menu
SortDateSameDayOrderCustom.sqlQuery to Add Parents Events to RM Database #facttypes #events #sharedevent
SortDateSameDayOrderCustom.sqlSQLite Queries #sqlitemanagers #sql
SortOrderProblems.sqlFacts - Sort Order Problems #events #date #sortdate
SortOrderProblems.sqlQuery Menu
SourceList-RM8.sqlSource List Query #sources #sourcetemplates #citations #xml #dateSQLite script to report every citation and its uses in RootsMagic 8.
SourceList.sqlSharable Events - Find and Convert to Shared #sharedevent
SourceList.sqlSource List Query #sources #sourcetemplates #citations #xml #date
SourceNames-AppendSurnames-RM9.sqlSource Names - Append Surnames
sources_without_media.sqlList of Pages imported from Wikispaces Site
sources_without_media.sqlEarlier Queries by Date
sources_without_media.sqlQuery for Sources Without Media #sources #media
sources_without_media.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Sources-AuthorUnreverse.sqlSources - Unreverse Author Names #sources #tmg
Sources-CopyRepositoryInfoTo.sqlSources - Copy Repository Name, Address from Repository List #sources #sourcetemplates #repositories
Sources-CreateExtremelySplitFromCitations.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Sources-DeleteAfterSplit.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
Sources-HybridFF-SetFF-Export.sqlSource Templates - Versatile Free Form Hybrids #sourcetemplates #sources
Sources-HybridFF-SetFF-Export.sql
Sources-HybridFF-UnSetFF.sqlSource Templates - Versatile Free Form Hybrids #sourcetemplates #sources
Sources-MergeDuplicates.sqlSources - Merge Duplicate Masters #merge #sources
Sources-NewspapersCom-LumpClean.sqlSources - Newspapers.com - Cleaner Footnotes and Simpler Bibliography
Sources-UnifyAliases_RepositoryLoc.sqlSources - Copy Repository Name, Address from Repository List #sources #sourcetemplates #repositories
Sources-UnifyAliases_RepositoryLoc.sql
SourcesByDetailLength.sqlSource Template, A Better Free Form #sourcetemplates #sources #search #replace
SourcesSort.sqlSource Citation Sort #sources #citations
SourceTemplate-AncestryRecord-cleaned.sqlSources - Newspapers.com - Cleaner Footnotes and Simpler Bibliography
SourceTemplate-AncestryRecord-Reset.sqlSources - Newspapers.com - Cleaner Footnotes and Simpler Bibliography
SourceTemplateExtremeSplitConvert.sqlSource Templates - Convert Builtins to Editable, Split, Import #sourcetemplates
SourceTemplateExtremeSplitConvert.sqlSources - Adventures in Extreme Splitting #sources #sourcetemplates #replace
SourceTemplateListWithCitationDetails.sqlBundled Utilities - Groupings #application
SourceTemplateListWithCitationDetails.sqlQuery Menu
SourceTemplateListWithCitationDetails.sqlSQLite Queries #sqlitemanagers #sql
SourceTemplateListWithCitationDetails.sqlSource Template List - Query #sources #sourcetemplates
SourceTemplateListWithCitationDetails2.sqlBundled Utilities - Groupings #application
SourceTemplateListWithCitationDetails2.sqlQuery Menu
SourceTemplateListWithCitationDetails2.sqlSQLite Queries #sqlitemanagers #sql
SourceTemplateListWithCitationDetails2.sqlSource Template List - Query #sources #sourcetemplates
SourceTemplateRevisionUtilities.sqlSource Templates - Revision Utilities #sourcetemplates
SourceTemplates_CopyBuiltin2Editable.sqlSource Templates - Convert Builtins to Editable, Split, Import #sourcetemplates
SourceTemplates_CopyBuiltin2Editable.sql
SourceTemplates-FieldCount.sqlSource Templates - Field Count #sourcetemplatesCounts fields in Source Templates. RM4-RM8 compatible.
SourceTemplates-MergeDuplicates.sqlSource Templates - Merge Duplicates #sourcetemplates #sources #merge
SourceTemplates-MergeDuplicates.sql
SourceTemplates-SetUKquotePunctuation.sqlSource Templates - Set Quotation Punctuation to 'UK' or 'Logical' Placement #sourcetemplates #update
SourceTemplatesHybridFreeFormConvert.sqlSource Templates - Versatile Free Form Hybrids #sourcetemplates #sources
SpouseID_Invalid-Check.sqlSpouseID Invalid #spouse #error #familyChecks for invalid values of SpouseID in FamilyTable that result in weird RM behaviour. RM8 compatible.
SpouseID_Invalid-Reset.sqlSpouseID Invalid #spouse #error #familyResets to 0 invalid SpouseID values found by SpouseID_Invalid-Check.sql. RM8 compatible.
SpouseOrderQuestioned.sqlTools - Problem Search - Spouse Order Questioned #tools #spouse
SpouseSort.sqlSpouse Order - Global Sort by Marriage or First-Birth SortDate #spouse
SpouseSort.sql
SpouseSort2.sqlSpouse Order - Global Sort by Marriage or First-Birth SortDate #spouse
SrcTmpltsConvert.sqlBundled Utilities - Groupings #application
SrcTmpltsConvert.sqlQuery Menu
SrcTmpltsConvert.sqlSQLite Queries #sqlitemanagers #sql
SrcTmpltsConvert.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
SrcTmpltsConvert.sqlhome - as exported
SrcTmpltsConvert.sql
SrcTmpltsConvert2.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
SrcTmpltsConvert2.sqlhome - as exported
SrcTmpltsConvert2.sql
SrcTmpltsRevert.sqlBundled Utilities - Groupings #application
SrcTmpltsRevert.sqlQuery Menu
SrcTmpltsRevert.sqlSQLite Queries #sqlitemanagers #sql
SrcTmpltsRevert.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
SrcTmpltsRevert2.sqlSource Templates #sources #sourcetemplates #rmnocase #conversion #editable
Stats-MaxChildren.sqlStatistics #child
SURNAME-Titlecase-1.sqlSurname ALL-CAPS to Propercase #names
SURNAME-Titlecase.sqlSurname ALL-CAPS to Propercase #names
TMG-RM_convertTMG_IDtoREF.sqlTMG-RM Convert TMG_ID to Reference Number #tmg #refno
TMG-RM_convertTMG_IDtoRIN.sqlTMG-RM Convert TMG_ID to Record Number #tmg #rin
TMG-RM_FalseSpousalEventSentences.sqlTMG-RM Check for False Spousal Event Sentences #tmg
TMG-RM_Sentence_Tweaks.sqlTMG-RM Fact Sentence Tweaks #tmg #facttypes #roles #events #sharedevent
To-Do.sqlBundled Utilities - Groupings #application
To-Do.sqlBundled Utilities - RMtrix #application #visualc
To-Do.sqlList of Pages imported from Wikispaces Site
To-Do.sqlDatabase Properties List - Query #databaseproperties
To-Do.sqlDelete Many #delete
To-Do.sqlMS Access Engine - EXCEL Pivot Tables #msaccess #msexcel #pivottable #events
To-Do.sqlMS Access Engine - Event Query #msaccess #marriage #sharedevent
To-Do.sqlMS Access Engine - The BLOB Fields #msaccess #blobfields #conversion
To-Do.sqlMS Access Engine - Using EXCEL #msaccess #msexcel #charts #filters
To-Do.sqlMS Access Engine #msaccess #msexcel #crystalreports #odbc
To-Do.sqlQuery Menu
To-Do.sqlRM4 To Do List #todolist #tasks #date
To-Do.sqlRM5 Table Summaries #datadefinitions
To-Do.sqlSQLite Queries #sqlitemanagers #sql
To-Do.sqlTo-Do List - filter by locale
To-Do.sqlhome - as exported
To-Do.sqlDirect Import of RM8 database into RM7 – Part 2
To-Do4Persons.sqlBundled Utilities - Groupings #application
To-Do4Persons.sqlQuery Menu
To-Do4Persons.sqlSQLite Queries #sqlitemanagers #sql
To-Do4Persons.sql
TraceHeadlessWitnesses.sqlBundled Utilities - Groupings #application
TraceHeadlessWitnesses.sqlQuery Menu
TraceHeadlessWitnesses.sqlSQLite Queries #sqlitemanagers #sql
TraceHeadlessWitnesses.sqlShared Events With Missing Witnesses #sharedevent
Tree-HourglassMembers.sqlQuery - All Names in Tree
TreeShare-DisconnectButNotCitations-1.sql
TreeShare-DisconnectButNotCitations.sqlAncestry TreeShare - Impact #ancestrycom #TreeShare
TreeShare-LinkPastedAncestrySources.sqlTreeShare - Link Pasted Ancestry Sources #ancestrycom #TreeShare #citations #sources
TreeShare-MediaRenameStep1.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
TreeShare-MediaRenameStep2.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
TreeShare-MediaRenameUNDO.sqlTreeShare - Rename Cryptic Filenames for Citation Media #TreeShare #media #citations #batch
UpdateBirthDeathYears.sqlQuery Menu
UpdateBirthDeathYears.sqlRebuild Indexes and Update Birth and Death Years #update #date #birth #death #index #speed #rmnocase
UpdateBirthDeathYears.sqlSQLite Queries #sqlitemanagers #sql
WebTags_to_Notes.sqlQuery Menu
WebTags_to_Notes.sqlWebTags - convert to Notes et al #webtags #gedcom
WebTags-Consolidate-RM8.sqlWebTags - Consolidate #webtags #delete #citations
WebTags-Consolidate.sql
WebTags-DeleteDuplicates-RM8.sqlWebTags - Consolidate #webtags #delete #citations
WebTags-DeleteDuplicates.sqlEarlier Queries by Date
WebTags-DeleteDuplicates.sqlQuery Menu
WebTags-DeleteDuplicates.sqlSQLite Queries #sqlitemanagers #sql
WebTags-DeleteDuplicates.sqlWebTags - Consolidate #webtags #delete #citations
WebTags-MakeFromAncestryComments.sqlQuery Menu
WebTags-MakeFromAncestryComments.sqlSQLite Queries #sqlitemanagers #sql
WebTags-MakeFromAncestryComments.sqlWebTags - from Ancestry.com and FTM #ancestrycom #webtags
WitnessOrderByRelationshipName.sqlShared Events - Sort Witnesses by Consanguinity plus Name #sharedevent