Once again, Mike, many thanks for your much appreciated help. I've tried your suggestion of running a fact query and see what you mean. I'm quite attracted to your idea of searching for paragraph headings beginning with specific words or phrase, as opposed to running a query based simply on the note containing the word or phrase. However, try as I might I can't get it to work! Here are the various settings I've used: I've got 5 individuals each with a dummy To Do attribute. (I've configured the To Do tab to show the date, which was your idea, and one large note box, which was Jane's. Thus I'll be entering multiple To Do tasks in the one box, rather than having a new To Do attribute for each task.) Some of the tasks begin with 'GRO:' (followed by a desription of the task itself) and others have random sentences containing one or more words with 'gro' in them - 'growth', etc - but which don't have a paragraph beginning with 'GRO'. I've kept these entries for all the following queries: 1. Individual Query Column: %INDI% Filter: Exclude unless %INDI._ATTR-TO_DO[1].NOTE2[1]% contains [parameter] Parameter: gro Result: produced all individuals with 'GRO' at the start of the paragraph and words containing 'gro' in the text (5 individuals). 2. Individual Query Column: %INDI% Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: exactly the same as query 1. 3. Fact Query Column: =GetRecord(%FACT%) Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: no records produced. 4. Fact Query Column: =GetRecord(%FACT%) Filter: Exclude unless =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: 6119 families and individuals As mentioned above, I like the idea of the query producing results that are based on the first word of a paragraph. It's just that I can't get it to work. At the end of the day, I'm happy to have the query produce results for To Do tasks that contain, say, GRO and words with 'gro' in them. But now you've brought to my attention the possibility of using a paragraph heading search, it would be nice if I could incorporate that into my query. Thanks again and sorry if I'm becoming a bit of a nuisance!. Regards Ed An afterthought: It might sound like an odd question but does the way the GetLabelledText function work depend on how the paragraph is created? I've entered a note in the To Do attribute that begins "GRO: locate entry for birth.", pressed the enter key twice (thereby leaving a blank line between the two paragraphs) and entered the next 'to do' ("Census: locate in 1871. Possibly living in Basingstoke."). I've also made the same entries but with no blank line between the two tasks (ie, pressed the enter key once). Unsurprisingly, neither way appears to make any difference to the query results. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ What would George Smiley do...? -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Beryl & Mike Tate Sent: 14 October 2011 21:00 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Property Box Custom Tab In your particular case it makes little difference whether you use an Individual Query or a Fact Query, and I don't think you are going against any conventions. I should point out that the =GetRecord(%FACT%) Column gives exactly the same Record as your %INDI% Column i.e. it lists the Record that contains the Fact. Try it and you will see what I mean. I also think that your 2nd & 3rd hidden Columns, and the 1st Exclude if Rows filter, can all be omitted, and still produce the same Result Set. The reason that the two approaches are equivalent is because you only have at most one To Do attribute per Individual and are not listing the To Do Note text itself. The Fact Query comes into its own when you want to list multiple Facts per Individual (such as Census), and also be able to list Facts per Family record. I would advise the use of Row Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null because it only checks the beginning of each Note paragraph. Whereas, Row Filter: Exclude unless %INDI._ATTR-TO_DO.NOTE2% contains ["String"] will search the entire Note and may include Records you don't want. For example if "String" is "GRO" then it will match a Note containing "GRO" or "gro" anywhere. Whereas if "Heading" is "GRO" it will only match if a Note paragraph starts with "GRO" or "gro". However, the risk of such mismatches can be minimised by ticking the 'Match case' option, but then you have to enter the Parameter in the appropriate case to match your heading. Regards, Mike Tate

Ed, Remember it is a Fact Query so the Row Filters must refer to %FACT% not %INDI% data items. Use Rows Filters such as: Add if =FactName(%FACT%) matches 'To Do' Exclude if =GetLabelledText(%FACT.NOTE2%,["Label"]) is null Regarding your afterthought, no it does not matter how the paragraph is created. However, on re-reading the Function description I realise that I have mislead you. The "Label" does NOT have to start at the beginning of a paragraph, it can appear anywhere, so it does have to be unique. Therefore, ensure each "Label" ends with a colon (:) as you have done, and include the colon (:) in the "Label" parameter, e.g. GRO: Since you are simply looking for a quick way of identifying Individuals with particular 'To Do' entries then you could use the 'Individual Record Window Columns'. To illustrate what I mean, open the Individual 'Records Window' and use 'Lists > Configure Record Window Columns'. Scroll to the bottom of the 'Item' list on the left and select <Other...> then click '>' and enter a 'Heading' such as 'To Do'. Enter an 'Expression' of 'TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"GRO:")="","","GRO: ")' and select 'Default Sort Direction' as 'Descending' and click 'OK' twice. Now all 'Individuals' with a To Do 'GRO:' entry are at the top of the Record Window. To extend this idea for all To Do 'Labels' you could add a separate Column for each 'Label'. However, the following 'Expression' combines them all into one Column. =Text( TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"GRO:")="","","GRO: ") . TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"Census:")="","","Census: ") . TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"TNA:")="","","TNA: ") ) Just keep adding similar . TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"Label:")="","","Label: ") functions for each To Do 'Label'. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Ed Thomas Sent: 15 October 2011 14:11 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Property Box Custom Tab Once again, Mike, many thanks for your much appreciated help. I've tried your suggestion of running a fact query and see what you mean. I'm quite attracted to your idea of searching for paragraph headings beginning with specific words or phrase, as opposed to running a query based simply on the note containing the word or phrase. However, try as I might I can't get it to work! Here are the various settings I've used: I've got 5 individuals each with a dummy To Do attribute. (I've configured the To Do tab to show the date, which was your idea, and one large note box, which was Jane's. Thus I'll be entering multiple To Do tasks in the one box, rather than having a new To Do attribute for each task.) Some of the tasks begin with 'GRO:' (followed by a desription of the task itself) and others have random sentences containing one or more words with 'gro' in them - 'growth', etc - but which don't have a paragraph beginning with 'GRO'. I've kept these entries for all the following queries: 1. Individual Query Column: %INDI% Filter: Exclude unless %INDI._ATTR-TO_DO[1].NOTE2[1]% contains [parameter] Parameter: gro Result: produced all individuals with 'GRO' at the start of the paragraph and words containing 'gro' in the text (5 individuals). 2. Individual Query Column: %INDI% Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: exactly the same as query 1. 3. Fact Query Column: =GetRecord(%FACT%) Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: no records produced. 4. Fact Query Column: =GetRecord(%FACT%) Filter: Exclude unless =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: 6119 families and individuals As mentioned above, I like the idea of the query producing results that are based on the first word of a paragraph. It's just that I can't get it to work. At the end of the day, I'm happy to have the query produce results for To Do tasks that contain, say, GRO and words with 'gro' in them. But now you've brought to my attention the possibility of using a paragraph heading search, it would be nice if I could incorporate that into my query. Thanks again and sorry if I'm becoming a bit of a nuisance!. Regards Ed An afterthought: It might sound like an odd question but does the way the GetLabelledText function work depend on how the paragraph is created? I've entered a note in the To Do attribute that begins "GRO: locate entry for birth.", pressed the enter key twice (thereby leaving a blank line between the two paragraphs) and entered the next 'to do' ("Census: locate in 1871. Possibly living in Basingstoke."). I've also made the same entries but with no blank line between the two tasks (ie, pressed the enter key once). Unsurprisingly, neither way appears to make any difference to the query results. -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Beryl & Mike Tate Sent: 14 October 2011 21:00 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Property Box Custom Tab In your particular case it makes little difference whether you use an Individual Query or a Fact Query, and I don't think you are going against any conventions. I should point out that the =GetRecord(%FACT%) Column gives exactly the same Record as your %INDI% Column i.e. it lists the Record that contains the Fact. Try it and you will see what I mean. I also think that your 2nd & 3rd hidden Columns, and the 1st Exclude if Rows filter, can all be omitted, and still produce the same Result Set. The reason that the two approaches are equivalent is because you only have at most one To Do attribute per Individual and are not listing the To Do Note text itself. The Fact Query comes into its own when you want to list multiple Facts per Individual (such as Census), and also be able to list Facts per Family record. I would advise the use of Row Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null because it only checks the beginning of each Note paragraph. Whereas, Row Filter: Exclude unless %INDI._ATTR-TO_DO.NOTE2% contains ["String"] will search the entire Note and may include Records you don't want. For example if "String" is "GRO" then it will match a Note containing "GRO" or "gro" anywhere. Whereas if "Heading" is "GRO" it will only match if a Note paragraph starts with "GRO" or "gro". However, the risk of such mismatches can be minimised by ticking the 'Match case' option, but then you have to enter the Parameter in the appropriate case to match your heading. Regards, Mike Tate

P.S. Correction: The initial Record Window Column 'Expression' needs a leading '=' symbol. i.e. '=TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"GRO:")="","","GRO: ")' -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Beryl & Mike Tate Sent: 15 October 2011 17:15 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Property Box Custom Tab Ed, Remember it is a Fact Query so the Row Filters must refer to %FACT% not %INDI% data items. Use Rows Filters such as: Add if =FactName(%FACT%) matches 'To Do' Exclude if =GetLabelledText(%FACT.NOTE2%,["Label"]) is null Regarding your afterthought, no it does not matter how the paragraph is created. However, on re-reading the Function description I realise that I have mislead you. The "Label" does NOT have to start at the beginning of a paragraph, it can appear anywhere, so it does have to be unique. Therefore, ensure each "Label" ends with a colon (:) as you have done, and include the colon (:) in the "Label" parameter, e.g. GRO: Since you are simply looking for a quick way of identifying Individuals with particular 'To Do' entries then you could use the 'Individual Record Window Columns'. To illustrate what I mean, open the Individual 'Records Window' and use 'Lists > Configure Record Window Columns'. Scroll to the bottom of the 'Item' list on the left and select <Other...> then click '>' and enter a 'Heading' such as 'To Do'. Enter an 'Expression' of 'TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"GRO:")="","","GRO: ")' and select 'Default Sort Direction' as 'Descending' and click 'OK' twice. Now all 'Individuals' with a To Do 'GRO:' entry are at the top of the Record Window. To extend this idea for all To Do 'Labels' you could add a separate Column for each 'Label'. However, the following 'Expression' combines them all into one Column. =Text( TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"GRO:")="","","GRO: ") . TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"Census:")="","","Census: ") . TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"TNA:")="","","TNA: ") ) Just keep adding similar . TextIf(GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,"Label:")="","","Label: ") functions for each To Do 'Label'. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Ed Thomas Sent: 15 October 2011 14:11 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Property Box Custom Tab Once again, Mike, many thanks for your much appreciated help. I've tried your suggestion of running a fact query and see what you mean. I'm quite attracted to your idea of searching for paragraph headings beginning with specific words or phrase, as opposed to running a query based simply on the note containing the word or phrase. However, try as I might I can't get it to work! Here are the various settings I've used: I've got 5 individuals each with a dummy To Do attribute. (I've configured the To Do tab to show the date, which was your idea, and one large note box, which was Jane's. Thus I'll be entering multiple To Do tasks in the one box, rather than having a new To Do attribute for each task.) Some of the tasks begin with 'GRO:' (followed by a desription of the task itself) and others have random sentences containing one or more words with 'gro' in them - 'growth', etc - but which don't have a paragraph beginning with 'GRO'. I've kept these entries for all the following queries: 1. Individual Query Column: %INDI% Filter: Exclude unless %INDI._ATTR-TO_DO[1].NOTE2[1]% contains [parameter] Parameter: gro Result: produced all individuals with 'GRO' at the start of the paragraph and words containing 'gro' in the text (5 individuals). 2. Individual Query Column: %INDI% Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: exactly the same as query 1. 3. Fact Query Column: =GetRecord(%FACT%) Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: no records produced. 4. Fact Query Column: =GetRecord(%FACT%) Filter: Exclude unless =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null Parameter/heading: gro Result: 6119 families and individuals As mentioned above, I like the idea of the query producing results that are based on the first word of a paragraph. It's just that I can't get it to work. At the end of the day, I'm happy to have the query produce results for To Do tasks that contain, say, GRO and words with 'gro' in them. But now you've brought to my attention the possibility of using a paragraph heading search, it would be nice if I could incorporate that into my query. Thanks again and sorry if I'm becoming a bit of a nuisance!. Regards Ed An afterthought: It might sound like an odd question but does the way the GetLabelledText function work depend on how the paragraph is created? I've entered a note in the To Do attribute that begins "GRO: locate entry for birth.", pressed the enter key twice (thereby leaving a blank line between the two paragraphs) and entered the next 'to do' ("Census: locate in 1871. Possibly living in Basingstoke."). I've also made the same entries but with no blank line between the two tasks (ie, pressed the enter key once). Unsurprisingly, neither way appears to make any difference to the query results. -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Beryl & Mike Tate Sent: 14 October 2011 21:00 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Property Box Custom Tab In your particular case it makes little difference whether you use an Individual Query or a Fact Query, and I don't think you are going against any conventions. I should point out that the =GetRecord(%FACT%) Column gives exactly the same Record as your %INDI% Column i.e. it lists the Record that contains the Fact. Try it and you will see what I mean. I also think that your 2nd & 3rd hidden Columns, and the 1st Exclude if Rows filter, can all be omitted, and still produce the same Result Set. The reason that the two approaches are equivalent is because you only have at most one To Do attribute per Individual and are not listing the To Do Note text itself. The Fact Query comes into its own when you want to list multiple Facts per Individual (such as Census), and also be able to list Facts per Family record. I would advise the use of Row Filter: Exclude if =GetLabelledText(%INDI._ATTR-TO_DO.NOTE2%,["Heading"]) is null because it only checks the beginning of each Note paragraph. Whereas, Row Filter: Exclude unless %INDI._ATTR-TO_DO.NOTE2% contains ["String"] will search the entire Note and may include Records you don't want. For example if "String" is "GRO" then it will match a Note containing "GRO" or "gro" anywhere. Whereas if "Heading" is "GRO" it will only match if a Note paragraph starts with "GRO" or "gro". However, the risk of such mismatches can be minimised by ticking the 'Match case' option, but then you have to enter the Parameter in the appropriate case to match your heading. Regards, Mike Tate ------------------------------- 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

I've just had a problem using Gedcom Census. I set it to save and it just sat there for hours. Finally I had to close down the computer. Now several families that were linked have lost their links and I have no sources. I could use a backup, but that would lose quite a lot of work. Is there any way I can recover at least the original sources? And, yes, I know I should backup more often, but more than once a week is rare.

First of all I suggest you make a backup of everything you need to preserve NOW. Then at least you can get back to NOW if any of the recovery attempts fail. What version of Windows are you running? What exactly do you mean by "lost their links" and "no sources"? Have you tried simply restoring the Backup you create every time you close FH? i.e. File > Backup/Restore > Restore and select a recent .zip file. On a different Note: 1) I suggest you update from Gedcom Census to its successor Ancestral Sources which has many enhancements. 2) There are automatic synch/backup tools such as Dropbox and Windows Live Synch that work instantly. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Martin Allen Sent: 02 November 2011 18:47 To: family-historian-users@rootsweb.com Subject: [FHU] Lost sources I've just had a problem using Gedcom Census. I set it to save and it just sat there for hours. Finally I had to close down the computer. Now several families that were linked have lost their links and I have no sources. I could use a backup, but that would lose quite a lot of work. Is there any way I can recover at least the original sources? And, yes, I know I should backup more often, but more than once a week is rare.

Dear Mike I see in answer to some one else's query you answered. ' Have you tried simply restoring the Backup you create every time you close FH? ' This is what always happened to me, I was asked if I wanted to create a backup, some how the last couple of times I closed FH it is not asking. It just closes. I have checked that the Gedcom file has been updated, but would be happier if I also had the zipfile backup. Have i inadvertently changed an option somewhere? Best wishes Sue Howard