I couldn’t find the scripts that you wrote. Could you provide a link? Thanks.
Go to SQLite Tools for RootsMagic and then to Forum.
Sorry for the thread necromancy, but I’ve discovered I’ve run into what appears to be the same issue. This is what I see on my “Citation Used” screen for a particular citation:
Can you think of any reason why your SQL delete script above would not also work on an RM10 database?
More info is required:
- Post a shot of the Edit Citation screen
- Post a shot of the Edit Person screen for Darnell-929 focussed on the Death event
- Check that these are really “phantom” links as @thejerrybryan 's script is addressing:
- Export this person to GEDCOM and import to another database. Does the multiplicity of links for the given citation reduce? That also would confirm there are phantoms of the sort discussed in this topic.
The RM9 script should work on RM10. Nothing has changed in the CitationLinkTable between RM9 and RM10.
Remember that the script only works for citations for people, families, facts, and names. It doesn’t work for citations for tasks or associations because I don’t use those RM features. If RM adds support to the Remove Phantom Records tool to remove phantom citations, the tool should delete all phantom citations. And I don’t use the new DNA tools in RM. Do the DNA tools support citations?
The reason I had to have separate scripts for RM7 and RM8/9/10 is that RM7 did not have a CitationLinkTable. Rather, the citation links were directly in the CitationTable. RM8 introduced reusable citations which introduced the CitationLinkTable. The CitationLinkTable is identical for RM8, RM9, and RM10 so the same script works in all three.
I don’t have a sample file with phantom citation links. If this is an example of it please send in support ticket Attn: Renee
https://support.rootsmagic.com/hc/en-us/requests/new
1 Like
I ran your deletion script on a copy of my database. Examining the “Edit Citation”:“Citation Used” screen after doing that, I no longer see multiple copies of the same event.
I also ran the following on the original and the post-deletion copy:
SELECT COUNT(*) FROM CitationLinkTable
… and got the following counts:
Original: 10710
Post-deletion: 8871
[Edit:] I believe I started using RootsMagic with version 8. But I started using Familiy Tree Maker around 1994 (2.0 I think) through 11; switched to The Master Genealogist around its v.5 (~2003 maybe) through its discontinuance after v.9 (~2014); finally started using RM8+ in early 2022. So I supposed whatever caused those citation errors could’ve crept in as a result of how the data was stored/migrated during any of those transitions…
Renee — I have sent a copy of my database as you requested via your support link.
FWIW, Jerry’s script did appear to resolve the issue for me…
Glad to hear you’ve resolved the problem but I wonder if we understand it correctly.
- How did you make the copy of your database on which you ran Jerry’s script successfully?
- Does Jerry’s script not succeed on the original database?
- Your image of the Edit Citation screen in response to my #1 confirms that it is a unique citation name not subject to a Merge All Duplicate Citations miscue.
- Your image of the Edit Person windows in response to my #2 is a surprise with the overlay of a second window for a Nameless person. That’s a different kind of phantom and I do not know if it would cause the multiplicity of the Citation Links you reported. What I wanted to see for Darnell-929 is hidden by the overlay - the number of Death facts and the number of citations for the Death fact.
- In response to my #4, I wanted the Citation Used image as you initially presented. If you simply reported the total uses, that would have changed if you GEDCOMed just the one person, not the whole database, because the citation is used for other people. So it tells us nothing definite about the effect on uses by Darnell-929.
Sorry, I think I was not as clear as I should have been.
#1. Literally a file-copy from outside of RootsMagic (i.e., at the Windows folder level).
#2. Once I confirmed it worked on my copy, I backed up my original (via RM backup), then ran the script on the original.
Re: #4 and #5, yes, I misunderstood. Hopefully the following is more what you were looking for?
#4. Ronald W DARNELL-929’s “Edit Person” screen — 1 Death fact, 1 Source for the fact, and 1 Citation of that source (I don’t know any way to show the Source AND Citation at the same time though):
#5. This is from the RM file imported from a GEDCOM of the entire database. The Citation Used totaled 61 times for that particular citation, but only the 3 highlighted here for Ronald:
Okay, I still need to be clearer but I’ll drop my line of inquiry because I mistakenly inferred from your first post that you had already run Jerry’s script and it had left the plethora of citation links untouched:
I’m still puzzled about that empty Edit (nameless) Person window, though!
That’s what I was getting when I clicked on the Edit Person “pencil” with a phantom citation highlighted