Family Historian User Group

Hello, i want to make a query for the data i'm missing. I will explain it with pictures Correct.png As you can see i have the witnesses, a description of the deed, the source and a picture of that deed. But i also have records where i miss a lot Missing data.png Is it possible to make a query where ...

Hello ,

Thanks Jane, Bill and Mike

This will help me a lot

Greetings

Koenraad

Hello tatawise This is a query i make. As you can see : the first 11 lines refers to a microfilm with number "M975-4PM," the next 6 lines to another microfilm "M975-4P3"............... I only want to change that number but keep the rest. so "M975-4PM" i want to change to "1254789" "M975-4P3" i want ...

Hello Mike, Thanks for your reply. No , i have about 14000 deeds, but i only must change about 3000 sources. (i use before a website where i copy the microfilm number from that website to the source of FH, but they stop the website, so i must change all those microfilms numbers in my deeds source fr...

Thanks Bill,

I wait for Make Tata. I know it is a difficult one.

Greetings

Koenraad

Hello Bill,

There are 14000 different sources, 1 for Birth, 1 for Death, 1 for baptisme...
Every source will specify the microfilm , where , the fact and the Deednumber.
But not all sources must be change !! and only a part (the microfolm number)

Greetings


Koenraad

Hello ,

There are about 14000 deeds , so if possible i want to do it with a query.

Greetings

Koenraad

Hello ,

here are the screens :

Greetings

Koenraad

Hello, Is this possible with a query ? I want to change only a part of my source title : Old : Neerpelt 1828-1864, Microfilm FamilySearch, nummer SPG7-929 - 1863 - Overlijdensakte 21 New: Neerpelt 1828-1864, Microfilm FamilySearch, nummer 1231495 - 1863 - Overlijdensakte 21 so only the number must c...

Thanks for the advice

Greetings

Koenraad

Hi ,

I want to make a query where I can see all the families who has a date, place or date and place of a marriage.
I try something but it did not work. Suggestions ?

Greetings

Koenraad

hello tatewise,

it's working.
Thank you very much.

Greetings

Koenraad

Hello tatewise,

I attach all the screens so that you can see what i mean.
Thanks for helping me.

Greetings

Koenraad
The other tabs (Notes and Media) are also blanc

Hello Tatawise, I only want to remove persons who has no witness or data. Only people where I only have a name and nothing else. This did occur before when I transfer my old database into FH. I notice it too late because I already work a few months with FH and did a lot of input. Greetings Koenraad

Hello tatawise,

Sorry for the late reply, I'm traveling for my work, I try to reach you but where I was there was only bad internet. Next week I'm back home, then I will look for it.

Sorry again and I will contact you again later.

Greetings and thanks for your reply.

Koenraad

Hi tatewise, Thanks for your reply. In my pool1 I also have records who are not related at all with other persons (no witness , no godparents.....). This I want to clean, the other records who has a relation (witness, godparents....) I want to keep. It is not a big problem , I can clean it manually ...

Hello tatewise, Thanks for the info. The first part (UDF) I already do, and with the plugin I have cleaned my database. About the second part (unrelated persons), the large numbers in pool 1 are more than 5000 persons, but I also see related persons. The related persons are Witness, Godparent, etc. ...

Hello, I want to delete 2 not used (_Uid and _Sex) field out of my database, I transfer all the info in other fields, because I could not deleted when I start with FH (about 2 months ago) I use already query's a lot because my database is old (28 years) and I want to make it updated. I know, if I ma...

Thanks Jane and Mike for the answer I use the root person for someone else who only need a part of my ancestery., but not the descendants For myself i need it later because i have about 14000 persons and about 14.000 deeds, and i want to split it later and use it again in FH. I also use "John Cardin...

Hello, I try the make a new ancestry in FH, with a new root person. The person I want is born in 1804. So I want all the persons before (uncle aunts...),but NOT the descendants. I already try in export gedcom, select the person and use query ->" Ancestors", but I only ged a part of the persons, when...