GEDCOM & DnD transfer losses #gedcom

Background

RM10 reportedly uses direct data transfer between databases for drag’n’drop, not GEDCOM, so it will have different issues, if any. 2024-06-20

RootsMagic Drag’n’Drop between the windows of two databases is a background GEDCOM export-import process. Both Drag’n’Drop and the explicit File>Export and Import process fail to fully transfer everything from one database to another. Drag’n’Drop and GEDCOM are governed by the settings for Export in Lists>Fact Type List so any fact type that is not enabled for “Exporting GEDCOM files” will be lost in transfer. A number of other less obvious losses have been identified

by various users over the years. A SQLite script from 2012 that is included in RMtrix, asterixed a number of items that would not transfer; see RMGC_Properties – Query

The following list is an attempt to consolidate all known GEDCOM|Drag’n’Drop transfer losses:

“Full” Transfer to an Empty Database

Having selected everyone in the database, the following are lost:

  1. Named Groups definitions. (added 2020-06-04)
  2. Fact types not enabled for “Exporting GEDCOM files” in Lists > Fact Type List. To check and fix this in RM and then revert is tedious. The scripts on Fact Inclusion Controls and in RMtrix can help.
  3. The DNA fact type
  4. Fact Description fields longer than 100 characters either truncated or transferred to the Note. Prior discussion here predated the changes in RM to address truncation by moving the data.
  5. Custom default sentence templates for built-in Fact Type roles, i.e., Principal, Witness, …
  6. Fact Notes for non-Principal participants of shared events that differ from the Note for the Principal.
  7. Trailing white space at the end of all Note type fields in facts, events, sources, citations, places… and from all text fields that can export giving rise to mismatches using File Compare between original and target database and, using TreeShare, between target database and original Ancestry Member Tree.
  8. Standardized Place Name and Abbreviated Place Name. Update 2024-05-09: RM4-7, RM8 unknown, RM9 preserved.
  9. Unused:
    1. Custom fact types
    2. Custom roles
    3. Sources
    4. Custom Source Templates
    5. Repositories
    6. Places
    7. Place Details
    8. Media
    9. General Research logs do not transfer. You can use Import lists to import them. (Research logs linked to a person are transferred.)
    10. General ToDo items do not transfer. Use Import lists to import general ToDo items. (ToDos linked to a Person are transferred.)
  10. The “Not a match” flags that preclude Duplicate Search Merge from offering a pair of people as a potential duplicate.
  11. The “Not a Problem List” from Tools > Problem List
  12. Non-default settings under Tools > File Options
  13. Last-used Report settings
  14. Custom report definitions
  15. Publisher Book definitions
  16. The Family Search ID is transferred. The FamilySearch password for FamilySearch Central and FamilySearch WebHints are imported. FamilySearch Central and FamilySearch Person Tools work as usual. You do need to check LDS Support at Tools, File options, General.
  17. TreeShare linkages for media and citations of Ancestry Sources are lost but the person-person TreeShare connection is maintained.
  18. #RM9 Associations 2023-02-28
  19. Living Flag settings 2023-07-09
  20. Set Relationships settings 2023-07-09
  21. Labels for Color Code Sets (RM9); retrievable from the source database file using File > Import Data > Import Lists. The color codes are transferred. 2023-09-25
  22. Custom sentences for any instance of citation Footnote, Short Footnote, Bibliography (new feature in RM8, RM9) 2024-05-08 per Jerry Bryan post in the RM Community
  23. Custom sentence for any instance of the Name fact, Alternate or Primary (RM4-9) 2024-05-08

Partial Transfer to an Empty Database

Having selected a subset of the people in a database, the following are lost, in addition to the above:

  1. “Family”-type fact types for couples broken by one not included in the selection, e.g., Marriage, Census (fam), Residence (fam), Separation, Divorce and anything that becomes “unused” as a result.

Transfer to a Non-Empty Database

Whether full or partial, the following are lost, in addition to the above:

  1. TreeShare connection

Multiple Transfers from One Database to Another

In addition to the losses attendant to transfers, multiple transfers from one database to an initially empty database have the following undesirable outcomes:

  1. Duplicates of people if already transferred; Drag’n’Drop can merge the focus person if dropped onto the duplicate.but not the others in the selection.
  2. Duplicates of Custom Source Templates used by Sources already transferred, leading to
  3. Duplicates of Sources using a duplicated Custom Source Template

Inter-version Losses

Additional losses may be incurred when transferring via GEDCOM between databases under different versions of RootsMagic. For example, no TreeShare data exported from RM7.5+ can be imported by earlier versions. No Tasks and Task Folders from a RM8 GEDCOM can be imported by earlier versions.

Alternative Transfer Methods

As an alternative to “Full” Transfer to an Empty Database, one might simply make a copy of the database, using RM’s File>Copy. That is simply copying the file by the operating system and does nothing to clean out detritus and perhaps repair certain problems that a GEDCOM|Drag’n’Drop transfer may do as is routinely advised by RootsMagic staff. Bad data is bad data and there can be corruption that can go undetected by the File >Database Tools set and only surfaces in a GEDCOM export with a crash. Then it’s too late for the transfer to fix anything. Better to add a regular “full” GEDCOM export to your routine to monitor for such corruption so that you can revert to a recent uncorrupted backup (you are doing them frequently?).

But what about the detritus from intensive database operations? We have SQLite solutions!

  1. Delete Phantoms – a more comprehensive process than RootsMagic’s Database Tool
  2. Groups – Extract most everything for one to a new database – a group of “Everyone in the database” loses only the stuff “unused” by any of the people.
  3. Direct Import of RM8 database into RM7 – Part 1 – a direct inter-version transfer, detritus and all, except for some things.

And the Group Extract is the less lossy method for Partial Transfer to an Empty Database and for duplication-free Multiple Transfers from One Database to Another.

That leaves Transfers to a Non-Empty Database without an alternative. That is a development in progress which may yet see the light of day, given enough time and skill…

9 Replies to “GEDCOM & DnD transfer losses #gedcom

  1. Additional losses may be incurred when transferring via GEDCOM between different generations of databases. For example, no TreeShare data exported from RM7.5+ can be imported into earlier versions. No Tasks and Task Folders can be imported from RM8 into earlier versions.

  2. I had seen mention of losses during gedcom transfers, but had no idea how many there were. I had a feeling my questions were going to have very complicated answers and I’m gonna have to really study what everyone is saying. I thank you all so much for your replies. I am not SQL-fluent, so may have more questions as I go along.

  3. I’m seeing loss of the Living flag and of the Set Relationship indicators. These are both easily resettable. They are maintained by RM9’s import from RM7 and by Tom’s script to revert from RM9 to RM7.

  4. Concerning point 8: Standardized Place Name and Abbreviated Place Name

    I found that “Abbrev” which is for Abbreviated Place Name is transferred during gedcom transfer for standard place types 0 and 1 but not for type 2 (detailed place types).
    I use this with sql database by filling the abbreviated place names with PlaceID. After gedcom transfer the Abbreviated Place Name are still in place, and so I can transfer latitude and longitude for places by the help of the Abbreviated Place Name.

Leave a Reply

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