Spouseless Marriages

craigmollekin · Post by **craigmollekin** » 02 Mar 2013 19:35

Hi,

I have noticed, in a couple of queries that I have generated, that I have two marriages in an imported Gedcom that appears to have no data attached...no people, date or location etc; just a marriages stuck in limbo.

I have attached a screen capture. Has anybody got an idea as to how I can go about finding who it belongs to?

Kind Regards,

Craig Mollekin

ID:6803

BillH · Post by **BillH** » 02 Mar 2013 20:38

Craig,

If you right click on the date is there an option to locate in property box?

Bill

craigmollekin · Post by **craigmollekin** » 02 Mar 2013 20:43

Hi Bill,

No, there is no date to click on. In fact there, is nothing to click on at all.

Craig

BillH · Post by **BillH** » 02 Mar 2013 20:48

Craig,

In your example, I mean the date in the first column.

Does it work there?

Bill

craigmollekin · Post by **craigmollekin** » 02 Mar 2013 21:19

Hi Bill,

I am referring to the middle entry where all you can see is 'marriage'.

Craig[grin]

YouTube · Post by **Jane** » 02 Mar 2013 21:32

If you add a column with just %FACT% does that show anything.

If not just build a Family Query and select the Marriage fact and then you will see the Family or just go to the Family tab on the records window and look for the record with not spouses attached.

Post by **tatewise** » 02 Mar 2013 21:44

Try running the Show Project Statistics Plugin.
It reports unusual Family Records with no Parents linked, etc, and provides a Result Set that links to them.

BillH · Post by **BillH** » 02 Mar 2013 21:48

Hi Craig,

I know, but if I run a fact query which shows marriages, and then click on the date field, and then click on 'Locate in Property Box', it takes me to the property box and positions me on the marriage fact.

The line in the query looks like this::

The marriage fact then looks like this:

Maybe that doesn't work for you since you don't have any people associated with the marriage.

Bill

craigmollekin · Post by **craigmollekin** » 02 Mar 2013 22:31

Many thanks for all the replies.

I attempted to use the Project plug in. It reported the stats but I couldn't seem to find who the stats referred to (only numbers with nothing to click on and no links). Perhaps because I'm not actually doing a project?

I built a family marriage query as suggested and that found the rogue entry.

Many thanks,

Craig

BillH · Post by **BillH** » 02 Mar 2013 22:52

Craig,

First of all, I'm glad you got it figured out.

Secondarily, now I understand the problem. There is no date to click on in the middle entry. I didn't notice that, even after you pointed it out. Don't I feel silly. [oops]

Bill

craigmollekin · Post by **craigmollekin** » 02 Mar 2013 22:56

Hehee, it is quite an odd problem though, Bill [grin]

Post by **tatewise** » 02 Mar 2013 23:24

When you Close the Show Project Statistics Plugin there is a Result Set with clickable links for all the unusual statistics (marked in red).

It would be handy to know if this also finds the problem entry.

craigmollekin · Post by **craigmollekin** » 03 Mar 2013 00:05

Thanks, Mike, I understand how it works now; very clever.

I've just checked on an earlier Gedcom. It found a lot of stuff out, but it didn't seem to pick up on the marriage problem. It would be handy actually if it picked up on relationships where no spouse is entered.....for example where the Tree Splitter knocks out the spouse and leaves the data 'married '

Post by **tatewise** » 03 Mar 2013 00:34

My understanding is that those 'married ' entries should appear under the One Parent Family categories.

You also didn't really explain what the original Marriage problem was exactly.

craigmollekin · Post by **craigmollekin** » 03 Mar 2013 00:38

I did spot the one parent families. But what if there are no children, i.e., just one person without children but with un-named spouse (thus not a parent)?

craigmollekin · Post by **craigmollekin** » 03 Mar 2013 00:41

Unfortunately, I don't know what the problem was, Mike. I just know that there was a marriage entry in a couple of the standard queries that had no data attached to them. What caused this to happen is sadly beyond my understanding of how Gedcoms/Family Historian works.

Post by **tatewise** » 03 Mar 2013 00:42

Yes, it reports both types of One Parent families.

It also reports No Parent families with & without Children.

See the Help & Advice on the Result Set for a full list of Exception Reports.

What did you have to do to fix the problem?

craigmollekin · Post by **craigmollekin** » 03 Mar 2013 00:43

Will do, Mike.

I only needed to find the rogue marriage data so I haven't really spent enough time understanding how the plugin works.

craigmollekin · Post by **craigmollekin** » 03 Mar 2013 00:45

I simply created the query that Jane suggested, Mike and that identified who the marriage entry pertained to. I'd previously tried to use the 'events', 'facts' and a modified 'all individuals' query which only returned blank fields.

Post by **tatewise** » 03 Mar 2013 00:54

To help you understand how families are formed in a GEDCOM, think of a Family Record as a coupling between family members.
Any Family Record can link to none, one, or two parents/spouses (husband & wife, or same sex couple).
It can also link to any number of Children, including none.
The record holds Family Facts such as Marriage and Divorce.

So it is possible to have an empty Family Record with no links to anyone and no Facts.

Or a Family Record can link to just one parent/spouse which gives the message.

craigmollekin · Post by **craigmollekin** » 03 Mar 2013 00:58

Thanks, Mike.

I tend to like to eliminate the records as they appear in some website generation software that I use. It creates an 'unknown person' entry on the website. In PHP scripts that I use, I get no such error.

PeterR · Post by **PeterR** » 03 Mar 2013 11:47

Craig Mollekin said:
I'd previously tried to use the 'events', 'facts' and a modified 'all individuals' query which only returned blank fields.

I often define a column in a Fact query with the following expression:

Code: Select all

=GetRecord()

instead of two columns with the expressions:

Code: Select all

=FactOwner(%FACT%,1,MALES_FIRST)
=FactOwner(%FACT%,2,MALES_FIRST)

I believe that if you had used =GetRecord() the result set would have included a Family record.

You could double-click this ...of (parents not known) to go to the relevant Property Box and use the All tab to see everything linked to the record, which could have included a child record.

craigmollekin · Post by **craigmollekin** » 05 Mar 2013 14:33

I just gave that a try, Peter. It does work great, thanks.

Family Historian User Group