The way I have entered by source data in my database results in the following rules. 1) for every fact there should be one or more sources. 2) for every Fact-Source combination there should be a citation. 3) for every Fact-Source-Citation combination there should be a media item attached. The missing sources from rule 1 are easily identified by "Facts without Sources" list. Does anyone have any ideas of how i could identify the missing data from rules 2 and 3? I know I could write a program to analyze the gedcom output from the database and identify the missing data, but I am hopeful of an easier solution. Red Fenton
1) and 2) are the same. Attaching a source to a fact creates a citation-footnote-endnote so "Facts without Sources" is actually "Facts without Citations". 3) is a bit ambiguous because media can be tagged to the Fact and/or a Master Source and/or to a Citation. Whatever, I agree that there is no report or tool in RM to readily provide "Facts without Media", "Sources without Media" and "Citations without Media", let alone "Facts having Citations without having any media tagged to any of the Fact, its Citations or the latter's Master Sources". I would use SQLite queries to answer these questions. Tom -----Original Message----- From: Red Fenton Sent: Sunday, October 14, 2012 2:01 PM To: rootsmagic-users@rootsweb.com Subject: [RMagic] Identifing missing source support data in the database The way I have entered by source data in my database results in the following rules. 1) for every fact there should be one or more sources. 2) for every Fact-Source combination there should be a citation. 3) for every Fact-Source-Citation combination there should be a media item attached. The missing sources from rule 1 are easily identified by "Facts without Sources" list. Does anyone have any ideas of how i could identify the missing data from rules 2 and 3? I know I could write a program to analyze the gedcom output from the database and identify the missing data, but I am hopeful of an easier solution. Red Fenton =================================== RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ ------------------------------- To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message