* Individuals without any Sources

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
User avatar
Gary Carson
Famous
Posts: 162
Joined: 02 Mar 2016 17:46
Family Historian: V7
Location: Grand Island, Nebraska, USA

Individuals without any Sources

Post by Gary Carson »

I am looking for the correct expression for a query to find individuals without any sources to any fact.
Gary
Win 10, FH 7.0.15
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

It is crucial to get the specification of the criteria perfectly correct.

If I understand correctly, you want to find any Individual record that has no Source Citations anywhere at all.
i.e.
No <whole record> Citations.
No Name field Citations.
No Note field Citations.
No Individual Fact Citations such as Birth, Death, Census, Occupation that may have multiple instances.
No Family Fact Citations such as Marriage where there may be more than one Family partnership.

That is almost certainly impossible with a single Query and needs a Plugin or a collection of Queries with manual cross-checks.

If you are only looking for any single Facts that don't have a Source Citation then see the KB Unsourced Facts Query.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
Gary Carson
Famous
Posts: 162
Joined: 02 Mar 2016 17:46
Family Historian: V7
Location: Grand Island, Nebraska, USA

Re: Individuals without any Sources

Post by Gary Carson »

I already have queries for singular tasks. Was looking for the "magic expression". Will continue to use single Query.

Thanks for input.
Gary
Win 10, FH 7.0.15
User avatar
LornaCraig
Megastar
Posts: 3229
Joined: 11 Jan 2005 17:36
Family Historian: V7
Location: Oxfordshire, UK

Re: Individuals without any Sources

Post by LornaCraig »

This probably won't help, but there is a standard query called 'Sources for Given Record'. It lists all Sources for a record so you can see if there are none at all. But you can only check one record at a a time!
Lorna
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

So if an Individual record is chosen and the Result Set is empty, then it has no Source Citations at all.

That is pretty useful, and includes any Family facts such as Marriage with Source Citations.

However, that =LinksFrom(...) function that the Query uses would make a Plugin really simple to construct by looping all Individual records past all Source records.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

Try the attached Unsourced Individuals plugin Version 0.1 Date 31 Dec 2020
[ EDIT Attachment deleted as superseded later. ]
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

Did you ever try this Unsourced Individuals plugin, Gary?
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

Mike,

I just tried this plugin and it seems to work just fine. I was actually needing something like this myself. One question... would it be possible to add a surname column so one could sort by surname?

Thanks,
Bill
Bill Henshaw
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

Try the attached Unsourced Individuals plugin Version 0.2 Date 02 Jan 2021 :D
Last edited by tatewise on 01 Feb 2024 16:00, edited 1 time in total.
Reason: Attachment deleted - contact Mike Tate if needed
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

Mike,

Works great. Just what I needed.

Thanks!
Bill
Bill Henshaw
User avatar
Roberto
Gold
Posts: 24
Joined: 30 Sep 2021 06:50
Family Historian: V7
Location: Adelaide, South Australia

Re: Individuals without any Sources

Post by Roberto »

I went looking for the Unsourced Individuals plugin in the store but couldn't find it. V0.2 with a Surname column looks like what I amlooking for.

Has it changed its name?

Cheers,
Robert
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

I don't believe it is in the store. Until Mike (the author) posts a link to it, here is a link that I just created to the plugin.

https://www.mediafire.com/file/8fj4hxgh ... h_lua/file

Bill
Bill Henshaw
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

Roberto, we are no longer allowed to attach plugins to posts for security reasons and must use file share links.
The plugin was never popular enough to warrant publishing in the Plugin Store.
Use the Unsourced Individuals link to download the plugin V0.2.

( BTW: My Avast anti-virus reported that Bill's link was infected with URL:Scam! )
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

Mike,

I think that must be a false positive that should be reported to Avast. Neither Norton 360 nor Malwarebytes report it as having a problem. I use VirusTotal to check URLs and it shows no problems.

image.png
image.png (41.42 KiB) Viewed 689 times

I've been using MediaFire for years and have never had any problems with it.

Bill
Bill Henshaw
User avatar
ColeValleyGirl
Megastar
Posts: 5528
Joined: 28 Dec 2005 22:02
Family Historian: V7
Location: Cirencester, Gloucestershire
Contact:

Re: Individuals without any Sources

Post by ColeValleyGirl »

It passes Microsoft Defender and Malware Bytes...
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

I click on the large blue DOWNLOAD (1.63KB) button that says underneath:
'The download button will start your download and show a message from our advertisers in a new window.'
It seems that the advertisers new window is infected:

image.png
image.png (142.69 KiB) Viewed 670 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

Very strange. I don't get that any detection when I click on the download button. All works fine here with no detections.
Bill Henshaw
User avatar
ColeValleyGirl
Megastar
Posts: 5528
Joined: 28 Dec 2005 22:02
Family Historian: V7
Location: Cirencester, Gloucestershire
Contact:

Re: Individuals without any Sources

Post by ColeValleyGirl »

The download works fine for me; the adware never manifest itself -- presumably my ad blocker sees it off silently.
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

ColeValleyGirl wrote: 13 Apr 2024 17:22 The download works fine for me; the adware never manifest itself -- presumably my ad blocker sees it off silently.
In my case I was not using an adblocker and still didn't get any detections. I still think that maybe Avast is flagging things that are not really infected.

In any case I think MediaFire is safe and the plugin is safe so there shouldn't be any problems in downloading it. However, since Mike documented a link to it there is no need to use my link.
Bill Henshaw
User avatar
Roberto
Gold
Posts: 24
Joined: 30 Sep 2021 06:50
Family Historian: V7
Location: Adelaide, South Australia

Re: Individuals without any Sources

Post by Roberto »

Thanks Mike, it works a treat.

PS It downloaded and ran without a hitch. I am using Malwarebytes and Norton 360.

Cheers
Robert
avatar
NickiP
Famous
Posts: 195
Joined: 26 Feb 2013 12:36
Family Historian: V7
Location: UK

Re: Individuals without any Sources

Post by NickiP »

tatewise wrote: 13 Apr 2024 10:35 Roberto, we are no longer allowed to attach plugins to posts for security reasons and must use file share links.
The plugin was never popular enough to warrant publishing in the Plugin Store.
Use the Unsourced Individuals link to download the plugin V0.2.
Hmm does this plugin not like large files? I've just shy of 69k in the file and it basically just hangs with not responding ... or am I being impatient? ;)
User avatar
BillH
Megastar
Posts: 2262
Joined: 31 May 2010 03:40
Family Historian: V7
Location: Washington State, USA

Re: Individuals without any Sources

Post by BillH »

I have about 20,000 individuals in my tree and it takes about 15 or 20 seconds. It should create a new tab on the navigation bar on the far left with the results.

image.png
image.png (24.92 KiB) Viewed 610 times
Bill Henshaw
User avatar
tatewise
Megastar
Posts: 28519
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Individuals without any Sources

Post by tatewise »

NickiP wrote: 13 Apr 2024 23:20 Hmm does this plugin not like large files? I've just shy of 69k in the file and it basically just hangs with not responding ... or am I being impatient? ;)
It was written as a one-off temporary plugin for a couple of FHUG users, so it is very unsophisticated.
Thus it has no mechanism to keep Windows happy when it is running such a large loop without output.
That is why the message Not Responding is displayed.
If you wait long enough it may eventually complete, but if not it can be modified to cope with very large Projects.

That is an example of the extra coding plugin authors must incorporate before publishing in the Plugin Store where the plugin can be exposed to a wide range of scenarios. These quick-fix plugins often don't go that far.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
NickiP
Famous
Posts: 195
Joined: 26 Feb 2013 12:36
Family Historian: V7
Location: UK

Re: Individuals without any Sources

Post by NickiP »

I left it running for 50 minutes but still hadn't completed ... :(

If you ever have the time to modify it so it will complete on a large project, I'd be interested.

Thanks
avatar
jelv
Megastar
Posts: 655
Joined: 03 Feb 2020 22:57
Family Historian: V7
Location: Mere, Wiltshire

Re: Individuals without any Sources

Post by jelv »

I'm wondering if the environment it's being run in is making it slow. Is the project on a local or networked drive?

When you look in task manager can you see if CPU, disk or Ethernet are being maxed out?
John Elvin
Post Reply