Jump to content
TNG Community
RichardSwetenham

Finding all references to a source

Recommended Posts

RichardSwetenham

Can someone give me the SQL query to find all persons where there is a citation of a source named “Wikipedia” - sourceID S213 ? In an ideal world, identifying multiple citations for a person.

Share this post


Link to post
Share on other sites
manofmull

I'm sure someone will reply to your question, but why not add Wikipedia as a new Media Type (Collection) as I do?

wiki2.jpg

wiki.jpg

Share this post


Link to post
Share on other sites
RichardSwetenham

This is an interesting idea, but I am not sure how far I can implement it.

I keep my main tree on Ancestry, and in accordance with Darrin Lythgoe’s advice, sync with FTM and export the GEDCOM from there to get functioning links to the media which FTM extracts from Ancestry and puts on my hard drive. I apply the method recommended by Bob Cumberbatch of doing a backup, clearing all tables, restoring the Media table, importing the GEDCOM and uploading new media by FTP.

That gives me functioning links from persons to media, but by default it all seems to be called Histories, and I would need to reclassify it all by hand to exploit the Media Types properly.

Perhaps I have missed something, but for the time being that is still on my ToDo list.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×