
person source citation missing after gedcom import
#1
Posted 12 November 2012 - 12:24 AM
Except from an example of a single individual file:
1 DATE 11 NOV 2012
1 CHAR ANSI
1 FILE C:\Users\Tim\My Genealogy\lyons_mary_ellen_2012-11-11.ged
1 SUBM @SUBM@
1 GEDC
2 VERS 5.5
2 FORM LINEAGE-LINKED
0 @SUBM@ SUBM
0 @I849@ INDI
1 NAME Mary Ellen /Lyons/
2 SOUR @S727@ <------ this is the source for the "primary" name that is lost upon import
...
1 NAME Mary E. /Lyons/
2 SOUR @S944@ <----- these sources for the alternate name were not lost
2 SOUR @S732@
2 SOUR @S731@
2 SOUR @S750@
2 SOUR @S738@
2 SOUR @S656@
2 SOUR @S7@
3 DATA
4 TEXT born July 1897 in Illinois. age 3 in 1900.
...
0 @S727@ SOUR
1 AUTH City of Chicago
1 TITL LyonsMaryEllen1912DeathCertificate
1 PUBL Name: dec 12, 1912;
1 REPO @R66@
1 NOTE
2 CONC Source Medium: Internet
2 CONT
Regardless of the cause, I have thousands of lost sources, so this is a showstopper for using RM at all. I had converted from FTM recently. Hopefully, there is a fix or workaround or I am missing something.
Tim in Chicago
#2
Posted 12 November 2012 - 08:36 AM
I am not where I can reference my materials at this time, but this sounds like a similar problem that I had that was resolved with an SQL update query from TomH on this forum. Perhaps he will chime in here with some ideas. As I recall, the citations may actually be in your database, but they are 'linked' to a Name record that does not exist in RM. They may be able to be re-linked to the appropriate Person record. Don't give up, just yet.
Paul
#3
Posted 12 November 2012 - 01:29 PM
Thanks. A workaround would be encouraging.
However, I wonder if the root cause may be the lack of a NAME fact. I would prefer to see RM treat a NAME just like any other fact, and not a special case of PERSON or a special case of ALT NAME. RM handles alternative facts using the same label just fine. PERSON should be just a record in a database used to tie facts about a person together. If RM needs something to label a person with, it should borrow the value from the first or primary NAME fact. If there are multiple names for a person, I prefer to see multiple NAME facts, not a PERSON fact that cannot have multiple entries and a set of ALT NAME facts. RM does not treat any other facts this way. There is no ALT BIRTH, ALT DEATH, ALT MARRIAGE, for example so why is it necessary for names?
Tim
#4
Posted 12 November 2012 - 01:59 PM
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
#5
Posted 12 November 2012 - 11:21 PM
Thanks for digging that up before I could get to it, and again, thank you for your assistance with that.
I do have one question, though. For the last year I have been watching many items get entered INTO the "Tracking System." Does anyone know the last time an item came OUT of the "Tracking System?"

Paul
#6
Posted 12 November 2012 - 11:49 PM
I was able to restore 3801 missing citations by running your queries. Excellent. It saved me from giving up on RM. Your SQLite Tools WIKI for Roots Magic is an excellent resource. Thanks for the help and for sharing your tools.
Tim
#7
Posted 13 November 2012 - 09:06 AM
Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com wiki, exploiting the database in special ways >>>
app, a bundle of RootsMagic utilities.
Also tagged with one or more of these keywords: person, name, source
General →
RootsMagic Wish List →
Better handling of URLs in SourcesStarted by GlenB, 08 Dec 2020 ![]() |
|
![]() |
||
Product Support - Current Versions →
RootsMagic 7 →
Discussion →
Notation in name suffix boxStarted by herbreed, 30 Jul 2020 ![]() |
|
![]() |
||
Product Support - Current Versions →
RootsMagic 7 →
Discussion →
Alternate name type: FOR SORTING PURPOSE ONLYStarted by SomebodySmart, 27 May 2020 ![]() |
|
![]() |
||
Product Support - Current Versions →
RootsMagic 7 →
Discussion →
Using the same source for multiple facts for the same personStarted by Beth Savage, 30 Dec 2019 ![]() |
|
![]() |
||
Product Support - Current Versions →
RootsMagic 7 →
Discussion →
prioritize sourcesStarted by SomebodySmart, 29 Dec 2019 ![]() |
|
![]() |