FTM - complex query

[Jim]

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]

On 4 Jan 2007 12:04:38 -0800, "Jim" <[email protected]> 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]

"Jim" <[email protected]> wrote in message
news:[email protected]...

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]

Kerry Raymond wrote:

"Jim" <[email protected]> wrote in message
news:[email protected]...

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]

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

"Jim" <[email protected]> wrote in message
news:[email protected]...

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]

Stan Barras wrote:

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

"Jim" <[email protected]> wrote in message
news:[email protected]...
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