The simplest way is to export from FH and then run Res Privata over the file http://www.fhug.org.uk/wiki/doku.php?id=fhugdownloads:contents:res_privata_-_gedcom_privatisation On 24 August 2011 11:35, <info@genealogyprinters.com> wrote: > To export a privatised gedcom from FH > > I want to export the gedcom with everybody born within the last 100 years > privatised, for example I don't want them ommited from the file, I still > want them to be in the exported file but I do not want any of their data, > just their names exported. > -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

To export a privatised gedcom from FH I want to export the gedcom with everybody born within the last 100 years privatised, for example I don't want them ommited from the file, I still want them to be in the exported file but I do not want any of their data, just their names exported. Best Wishes. Ron

Thank you so much will now go ahead. I would be nice if someone or company could publish a book on how to use the queries. I have looked at the help but it does not address many issues. Thanks again John In a message dated 24/08/2011 15:54:51 GMT Daylight Time, janetaubman@gmail.com writes: Sorry should be =Bool(Exists(%INDI.BIRT.DATE%) or Exists(%INDI.FAMS[1]>MARR[1].DATE%) or Exists(%INDI.BIRT.DATE%)) On 24 August 2011 15:35, <APhill1274@aol.com> wrote: > you mention 2 > INDI.BIRT and one INDI.DEAT but no INDI. marriage ?? -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk ------------------------------- To unsubscribe from the list, please send an email to FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

thank you very much Jane I will try this I have some persons with no birth or death date but do have a marriage date/ This you have made no comment in your suggestion , you mention 2 INDI.BIRT and one INDI.DEAT but no INDI. marriage ?? Was this an oversight or deliberate Thanks John In a message dated 24/08/2011 15:12:10 GMT Daylight Time, janetaubman@gmail.com writes: On 24 August 2011 13:19, <APhill1274@aol.com> wrote: > If date of birth is blank (null?) and date of marriage is blank and date of > death is blank then the query result will not print their names. Something like a Row condition of Add If =bool(Exists(%INDI.BIRT.DATE%) or Exists(%INDI.DEAT.DATE%) or Exists(%INDI.BIRT.DATE%)) is true, should work for you. -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk ------------------------------- To unsubscribe from the list, please send an email to FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Dear Janet I have taken the 1911 Query census from the custom query list but want to alter it so that if the following condition are met then the persons would NOT be printed on the results list. If date of birth is blank (null?) and date of marriage is blank and date of death is blank then the query result will not print their names. At the moment is shows as N/a Thanks John

> You should be able to use the standard "Contains Text" Query, on it's > own or use the results from it to populate the Report Record > selection. > > So select Individual Summary, then on the Record selection use Add > using Query and run the Contains Text query and enter the result you > want. > > If you want to select additionally by letter of the Alphabet just copy > the Contains text query to a new one and add a Exclude unless Surname > starts with, set as a parameter and select the letter as you go. Thanks Jane - Perfect! Graham No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3848 - Release Date: 08/22/11 07:35:00

You should be able to use the standard "Contains Text" Query, on it's own or use the results from it to populate the Report Record selection. So select Individual Summary, then on the Record selection use Add using Query and run the Contains Text query and enter the result you want. If you want to select additionally by letter of the Alphabet just copy the Contains text query to a new one and add a Exclude unless Surname starts with, set as a parameter and select the letter as you go. On 22 August 2011 18:39, Graham Anstey <ganstey@lodgegate-wood.org.uk> wrote: > What I'd really like to be able to do is to run an individual summary report > (or similar) for each person who has a particular word in any of their > records. I can't see how to do this using a query as it seems like I have to > add a condition for every record type. -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

One of the mailing lists I subscribe to is running a 'roll call' where people post details of people on their trees that relate to that list, one letter of the alphabet per week. I've been using the standard search feature to look for people that match, but it's very clumsy as I have to start from the first match and manually step through. I then have to extract relevant details from the search results002E What I'd really like to be able to do is to run an individual summary report (or similar) for each person who has a particular word in any of their records. I can't see how to do this using a query as it seems like I have to add a condition for every record type. I'm still using V3.1.2 Cheers Graham No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3848 - Release Date: 08/21/11 19:33:00

I would always recommend if you are working on long lines to use something like PsPad to enter them in. PSPad has a couple of advantages over both the input line on FH and notepad. http://www.fhug.org.uk/wiki/doku.php?id=fhugdownloads:contents:pspad_editor 1. When your cursor is on a bracket it shows you where the closing one is. 2. If you spend the time to download and install the Syntax and prompting extension I did you can prompt the functions. http://www.fhug.org.uk/wiki/doku.php?id=fhugdownloads:contents:pspad_fh_functions Thank you Jane – I will have to digest this slowly! Joan Thank you Jane – I will have to digest this slowly! Joan

Thank you very much to Bran and Jane who together have enabled me to do just what I want. I think this wil help me next time I try a query, too. --- On Thu, 18/8/11, Brian Horridge <brian.horridge@btinternet.com> wrote: From: Brian Horridge <brian.horridge@btinternet.com> Subject: Re: [FHU] Printing list of sources To: family-historian-users@rootsweb.com Date: Thursday, 18 August, 2011, 19:54 Pauline There is a standard query titled "Source Record - All" which gives the Source title and other information. If you want to show the Source number, you'll need to save it as a custom query and then add another column with the value "=RecordId()" and you could remove the ones you don't want before you save the results set. Brian ----- Original Message ----- From: "Pauline Lowe" <pauline247@yahoo.com> To: <FAMILY-HISTORIAN-USERS@rootsweb.com> Sent: Thursday, August 18, 2011 7:39 PM Subject: [FHU] Printing list of sources ....I just want to print a list of sources by title as they appear on the Record page under Source tab. I don't want details as appear when I run a report of sources, only the title. I want to do this so that I can use the same name for sources I created in another project without closing the project I'm working on and opening the other project in order to check.

I would always recommend if you are working on long lines to use something like PsPad to enter them in. PSPad has a couple of advantages over both the input line on FH and notepad. http://www.fhug.org.uk/wiki/doku.php?id=fhugdownloads:contents:pspad_editor 1. When your cursor is on a bracket it shows you where the closing one is. 2. If you spend the time to download and install the Syntax and prompting extension I did you can prompt the functions. http://www.fhug.org.uk/wiki/doku.php?id=fhugdownloads:contents:pspad_fh_functions On 18 August 2011 18:08, <stevens@nwthree.demon.co.uk> wrote: > it has now finally worked. Obviously cutting and pasting meant that some hidden line break instructions were present – I thought that by doing this I was less likely to make a mistake! -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

With any Query to sort them just click on the column heading for the column you want them sorted by, before you print. The same as you do on the Records Window. On 18 August 2011 19:39, Pauline Lowe <pauline247@yahoo.com> wrote: > I managed to get just the name of the source and the number of times I'd cited it but when I printed the page they were not in ABC order. -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

Jane Thank you for pointing me in that direction. Malcolm Kersey ----- Original Message ----- From: "Jane Taubman" <janetaubman@gmail.com> To: <family-historian-users@rootsweb.com> Sent: Wednesday, August 17, 2011 7:43 AM Subject: Re: [FHU] Retrieving Custom Queries following reinstallation > On 16 August 2011 22:59, Malcolm Kersey <mjkersey@tiscali.co.uk> wrote: > >> I have retained all the old files, so the Project data is intact, but my >> Custom queries are "missing". > > > Please see: > http://www.fhug.org.uk/wiki/doku.php?id=how_to:move_settings > > -- > Jane. > > Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk > > ------------------------------- > To unsubscribe from the list, please send an email to > FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' > without the quotes in the subject and the body of the message >

Pauline There is a standard query titled "Source Record - All" which gives the Source title and other information. If you want to show the Source number, you'll need to save it as a custom query and then add another column with the value "=RecordId()" and you could remove the ones you don't want before you save the results set. Brian ----- Original Message ----- From: "Pauline Lowe" <pauline247@yahoo.com> To: <FAMILY-HISTORIAN-USERS@rootsweb.com> Sent: Thursday, August 18, 2011 7:39 PM Subject: [FHU] Printing list of sources I have spent ages tryng to do a very simple task without success so now I need your help! I just want to print a list of sources by title as they appear on the Record page under Source tab. I don't want details as appear when I run a report of sources, only the title. I want to do this so that I can use the same name for sources I created in another project without closing the project I'm working on and opening the other project in order to check. I tried creating a named list but I cannot find a way of adding all the sources in ABC order except by adding each one separately. I cannot seem to highlight them all together. I am not practised at running queries but there was a standard one for sources. I managed to get just the name of the source and the number of times I'd cited it but when I printed the page they were not in ABC order. I know I must be missing something very obvious and I shall be grateful for advice. Pauline ------------------------------- To unsubscribe from the list, please send an email to FAMILY-HISTORIAN-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

Jane Thank you – it has now finally worked. Obviously cutting and pasting meant that some hidden line break instructions were present – I thought that by doing this I was less likely to make a mistake! Joan

I just cut and pasted the line, via PSPad to get it all on one line and pasted it into FH and it worked fine. On 18 August 2011 15:11, <stevens@nwthree.demon.co.uk> wrote: > But when I use ‘Test’ it tells me I have an error. -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

Not currently, but if you reduce the minimum box width (dimensions tab on diagram options) for the diagram you can drastically reduce the amount of space the spouse box takes. On 18 August 2011 14:47, Nev.Ramsden <nevramsden@ukfsn.org> wrote: > If a woman has an illegitimate child before she has two subsequent marriages, then is it possible to attach this child directly to the mothers box in a diagram, rather that have the complexity of a third, but empty, spouse box ? -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

Jane and Mike Thank you for your suggestions. Mike – I am very grateful for your amendment. I have put it in as %INDI.BIRT.DATE:YEAR%=TextIf(%INDI.BIRT.DATE:XDATETYPE% = "calculated","(est)","")=TextIf(Exists(%INDI.BIRT.DATE%) or Exists(%INDI.DEAT.DATE%) ,"-","")%INDI.DEAT.DATE:YEAR% But when I use ‘Test’ it tells me I have an error. This error is normally at the start of the second =TextIf but occasionally it finds fault elsewhere as I have tried playing around with spaces. I seem to have the right number of brackets so my error must be more fundamental – I have looked at the references you gave but I still do not know where my error is. Joan

Hi, Can someone point me to the answer to the following problem. If a woman has an illegitimate child before she has two subsequent marriages, then is it possible to attach this child directly to the mothers box in a diagram, rather that have the complexity of a third, but empty, spouse box ? Nev.

I have spent ages tryng to do a very simple task without success so now I need your help!   I just want to print a list of sources by title as they appear on the Record page under Source tab.  I don't want details as appear when I run a report of sources, only the title. I want to do this so that I can use the same name for sources I created in another project without closing the project I'm working on and opening the other project in order to check.   I tried creating a named list but I cannot find a way of adding all the sources in ABC order except by adding each one separately. I cannot seem to highlight them all together. I am not practised at running queries but there was a standard one for sources.  I managed to get just the name of the source and the number of times I'd cited it but when I printed the page they were not in ABC order.   I know I must be missing something very obvious and I shall be grateful for advice.   Pauline