FTM - complex query

Moderator: MOD_nyhetsgrupper

Svar
Jim

FTM - complex query

Legg inn av Jim » 4. januar 2007 kl. 21.04

Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.
Jim

Charlie Hoffpauir

Re: FTM - complex query

Legg inn av Charlie Hoffpauir » 4. januar 2007 kl. 22.04

On 4 Jan 2007 12:04:38 -0800, "Jim" <wolfej50@msn.com> wrote:

Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.
Jim

Jim,

Since you include "secondary products", I'd suggest importing your FTM
dataset into RootsMagic (which will read your native file directly)
and making your complex queries from within RM. And if you get really
complex (too complex for RM to handle) since the RM data sets are not
"proprietary" as FTM is, you can always open the data in a database
program and create custom queries via programming.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

Kerry Raymond

Re: FTM - complex query

Legg inn av Kerry Raymond » 4. januar 2007 kl. 23.14

"Jim" <wolfej50@msn.com> wrote in message
news:1167941078.356110.225690@v33g2000cwv.googlegroups.com...
Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.

No. And it's one of the biggest drawbacks to FTM in my opinion.

You can select people based on individual characteristics (born in England,
died before 1900, etc --- albeit with some limitations), but you can't
select based on relationships (mother called Mary, is a twin). Nor can you
produce reports easily using relationships (other than some built-in
reports). Using Custom Report with careful selection of individuals to be
included and information to be displayed, you can sometimes produce reports
that are a sort of poor man's query output, but if you have any experience
in relationship/object/XML database query, you will be very disappointed!

Certainly you can't say something like ...

WHERE P.parent.parent.child.givenName = "Robert"

Kerry

Hugh Watkins

Re: FTM - complex query

Legg inn av Hugh Watkins » 4. januar 2007 kl. 23.33

Kerry Raymond wrote:

"Jim" <wolfej50@msn.com> wrote in message
news:1167941078.356110.225690@v33g2000cwv.googlegroups.com...

Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.


No. And it's one of the biggest drawbacks to FTM in my opinion.

You can select people based on individual characteristics (born in England,
died before 1900, etc --- albeit with some limitations), but you can't
select based on relationships (mother called Mary, is a twin). Nor can you
produce reports easily using relationships (other than some built-in
reports). Using Custom Report with careful selection of individuals to be
included and information to be displayed, you can sometimes produce reports
that are a sort of poor man's query output, but if you have any experience
in relationship/object/XML database query, you will be very disappointed!

Certainly you can't say something like ...

WHERE P.parent.parent.child.givenName = "Robert"

but upload a gedcom to World Connect and get another view point
or via PAF make your own html site and use google

Or import a ged into Gustodian 3


Hugh W

--

a wonderful artist in Denmark
http://www.ingerlisekristoffersen.dk/

Beta blogger
http://snaps4.blogspot.com/ photographs and walks

old blogger GENEALOGE
http://hughw36.blogspot.com/ MAIN BLOG

Stan Barras

Re: FTM - complex query

Legg inn av Stan Barras » 5. januar 2007 kl. 21.21

You can do it with The Master Genealogist. It will take your data directly
from FTM.
Stan.

"Jim" <wolfej50@msn.com> wrote in message
news:1167941078.356110.225690@v33g2000cwv.googlegroups.com...
Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.
Jim

Paul Blair

Re: FTM - complex query

Legg inn av Paul Blair » 5. januar 2007 kl. 22.53

Stan Barras wrote:
You can do it with The Master Genealogist. It will take your data
directly from FTM.
Stan.

"Jim" <wolfej50@msn.com> wrote in message
news:1167941078.356110.225690@v33g2000cwv.googlegroups.com...
Is there a capability within FTM or some secondary product that would
perform complex queries within the FTM dataset? For example, I would
like to search for married names, or sets of specific siblings, or
individuals who were born at a specific location and had an uncle named
'Robert'.
Jim



TMG has some query strength, to be sure. But, to get the full SQL life,
export FTM as a GEDCOM, import it into Legacy, and you have the full
power (!) of MS Access at your fingertips. You can knit a query to do
just about everything your data will allow then...

Paul

Svar

Gå tilbake til «soc.genealogy.computing»