Curious. I do not run any of the over bloated "security" products as I find they often cause more problems than they solve. For Windows I find Microsoft Security Essentials plus common sense and the occasional scan with MalwareBytes is good enough and they are all free! I would be very surprised in these caused any problems with screen re-rendering and I have used them with Version 4 extensively over the last couple of years with no problem. If no one else has the problem it is more likely to be my graphics card - the laptop I have installed version 5 on was only purchased a month ago, I did not notice version 4 having the problemon it but I had only installed it and had a cursory look so I may have missed it. The laptop is a Samsung with an AMD RADEON HD 6970M graphics card. When I get time I will install version 5 on either my windows desktop or under parallels on the MAC and see if I get same behaviour there. On 3 April 2012 21:00, Lorna Craig <l.m.craig@ntlworld.com> wrote: > I have not been able to reproduce this problem with the opening of the > multimedia window. > I'm using Windows 7 Professional, 64 bit. > > Lorna > > If my memory serves me correctly (always a dodgy assumption) I had a similar problem a few weeks ago while still running V.4. Because of a problem with updating my Mail Client I booted McAfee Internet Security into touch and lo, no more problem. Coincidence? George On 02/04/2012 18:02, terryjacombs wrote: > > Not sure if anyone else has noticed these or if it is just a problem on > my > > machine. > > > > Some of the screen updating when opening, switching and resizing windows > is > > not working fully on all occasions. > > > > For example:- > > > > When opening the multimedia window from the toolbar button (selecting > view > > all media or for selected records) or by selecting multimedia window from > > the view menu, the multimedia window opens with a bit of the previous > > window still showing between the multimedia records list and the linked > > records list in the context pane. This can be made to vanish by selecting > > the grabber at the top of the linked records list and slightly moving it > or > > switching to another window and back to the multimedia window again. This > > happens when I have the family history window maximised on the desktop > from > > startup. > > > > If I do it from a smaller window (any size smaller window) it does not > > happen, but resizing small windows does not update the screen for the > open > > window correctly. Switching to another window corrects this. Switching > back > > to maximised also fails to update correctly on some occasions, but after > > switching back to maximised the multimedia windows then open correctly > > updated. > > > > I have generally done this with the family historian windows all > maximised > > in the main family historian window. I have not experimented with > > individual family historian windows floating in the main family historian > > window. A bit difficult to fully describe all the circumstances but I > hope > > this gives some indications. > > > > I have checked it out from the focus window, records list and diagram > > windows on two separate gedcoms and it can occur in all circumstances. > > > > Not causing any problems, just seems to be some errors in the screen > > redrawing routines. > > > > Window 7 Home premium 64 bit - fully up to date from windows update. > > > > ------------------------------- > 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 > -- Kind Regards Terry Jacombs

Fine, thanks, Mike. I might have a go myself when I have time. Martin -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Beryl & Mike Tate Sent: 03 April 2012 22:00 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Addresses and Places Martin, To be pedantic, it is the Google Maps Online Geocoder employed by the 'Map Life Facts' Plugin, that does not recognise the Chapman codes. Assuming the Chapman codes are always delimited by commas or end of field, the Plugin could be modified to recognise them. It would then substitute the full County name before submitting the Location details to Google Maps for Geocoding. I will add it to my Wish List of updates. 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: 03 April 2012 16:45 To: abruce@madasafish.com; family-historian-users@rootsweb.com Subject: Re: [FHU] Addresses and Places I've been following all this, but my problem is a bit different. The mapping plugin doesn't recognise all my county codes - I'm using standard Chapman codes. Is there a solution? Martin ------------------------------- 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 ------------------------------- 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

If my memory serves me correctly (always a dodgy assumption) I had a similar problem a few weeks ago while still running V.4. Because of a problem with updating my Mail Client I booted McAfee Internet Security into touch and lo, no more problem. Coincidence? George

Paddy, Are you using the FH Qualifiers to extract :YEAR, :MONTH_NUMBER, and :DAY from dates in Result Sets? This is certainly a partial workaround, but does not work for all data formats (I think Quarter Dates and Date Ranges are poor). There were also several inaccuracies in other date Qualifiers and Functions that are now fixed in FH V5. In particular the =DayNumber() and =Timespan() functions will now yield a spreadsheet integer that sorts in date order. These work well for virtually any A.D. FH Date except Date Phrases. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Paddy Buckley Sent: 03 April 2012 17:07 To: Andrea Kent; family-historian-users@rootsweb.com Subject: Re: [FHU] Find Same Death Date I also spotted Mike's bold assertion about not being able to sort into date order in Excel, but was reluctant to comment as he has helped me so many times in FH. My main one-name database is an Excel spreadsheet with over 7300 records. I use 3 columns to sort on date; year, month & day. It will certainly find twins with different forenames. Paddy ----- Original Message ----- From: "Andrea Kent" <andrea.kent@btopenworld.com> To: <family-historian-users@rootsweb.com> Sent: Tuesday, April 03, 2012 8:05 AM Subject: Re: [FHU] Find Same Death Date I use Excel a lot in my research, both for recording data and for to do lists at archives, etc. If I want to sort into date order, I just create an additional column Sort Date, and enter it in the format YYYYMMDD, e.g. 19000201, 18000101, 15000607. That way it will always give me the correct date sequence - a lot to do in a large spreadsheet, I agree, but sometimes worth it to achieve the end! Regards, Andrea ________________________________ From: Beryl & Mike Tate <post@tatewise.co.uk> To: family-historian-users@rootsweb.com Sent: Tuesday, 3 April 2012, 0:10 Subject: Re: [FHU] Find Same Death Date OK George, you knew to format the dates as text, but they don't sort into date order. i.e. "1 Feb 1900" and "1 Jan 1800" and "1 Mar 1700" all come together followed by say "2 Apr 1600" and "20 Dec 1500". Because you are searching for two rows with the same date, they will come together OK. I just did not want anyone to get the impression that the dates will sort into date order. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of George Bush Sent: 02 April 2012 22:46 To: FHUG Subject: Re: [FHU] Find Same Death Date I have tried this already and it did work if I formatted the whole column as text. However, it did miss the ones I was looking for but that was because the 2 siblings did not appear next to each other in the surname list. Good learning experience, though. George -------Original Message------- From: Beryl & Mike Tate Date: 02/04/2012 22:24:53 To: abruce@madasafish.com; family-historian-users@rootsweb.com Subject: Re: [FHU] Find Same Death Date Unfortunately, that probably won't work because Excel and other Spreadsheets do not recognise dates before 1 Jan 1900 and treat them as text!!! See FHUG Forum thread for details http://www.fhug.org.uk/cgi-bin/index cgi?action=forum&board=v4use&op=display&num=4785 Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Adrian Bruce Sent: 02 April 2012 19:56 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Find Same Death Date <<snipped>> Somewhere in my, or my wife's, tree are 2 brothers (not twins) who died either on the same day or within 24 hours of each other. I cannot for the life of me recall who they were so I wonder if it would be possible to construct a query to find them for me? <<snipped>> Not sure what you're like with spreadsheets, but I'd create a query to extract all males with a non-blank death date (or is it non-null???), sorted by surname then death date; export that to a spreadsheet; and create a new column whose value was "FOUNDIT" if the death date on this row matched the death date on the previous row. Then just do a search for "FOUNDIT". Yes, there are flaws - the 2 with the same name might not be brothers but it would find all such people so you can do a visual check on the tiny population found. Adrian B ------------------------------- 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 ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2114/4910 - Release Date: 04/02/12 ------------------------------- 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 ------------------------------- 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 ------------------------------- 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 ------------------------------- 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

Yes, Excel will sort dates entered in Date Format, but Date Format only supports dates from 1 Jan 1900 onwards. Dates prior to that are treated as text strings and do NOT sort into date order but into string order. Just do a Google search for 'Excel date before 1900' and you will see what I mean. Even Microsoft admit it is a limitation. OpenOffice Calc spreadsheet is better, because its Date Format goes back to 1582. Yes, there are manual workarounds, and macros, etc, but FH exported dates prior to 1900 do NOT sort. If don't believe me just try it. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Graham@number57.org Sent: 03 April 2012 17:46 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Find Same Death Date Providing the cell is in Date Format and the full year has been entered (e.g. 03/04/2012 or 10/2/1989) - even if you can only see the last two year digits (e.g. 12 for 2012), just using the Sort function in Excel will sort the data in any order you like. The way this works depends on which version of Excel you are using. It's powerful enough to recognise the "/" as a divider. It would be completely thrown if some dates were in UK style and others in US, though! It's pretty much identical in OpenOffice and LibreOffice (free downloadable alternatives to Microsoft Excel but just as powerful), although the way you do it is slightly different. Graham On 03/04/2012 17:06, Paddy Buckley wrote: > I also spotted Mike's bold assertion about not being able to sort into date > order in Excel, but was reluctant to comment as he has helped me so many > times in FH. My main one-name database is an Excel spreadsheet with over > 7300 records. I use 3 columns to sort on date; year, month& day. It will > certainly find twins with different forenames. > Paddy > > ----- Original Message ----- > From: "Andrea Kent"<andrea.kent@btopenworld.com> > To:<family-historian-users@rootsweb.com> > Sent: Tuesday, April 03, 2012 8:05 AM > Subject: Re: [FHU] Find Same Death Date > > > I use Excel a lot in my research, both for recording data and for to do > lists at archives, etc. If I want to sort into date order, I just create an > additional column Sort Date, and enter it in the format YYYYMMDD, e.g. > 19000201, 18000101, 15000607. That way it will always give me the correct > date sequence - a lot to do in a large spreadsheet, I agree, but sometimes > worth it to achieve the end! > > Regards, > Andrea > > > ________________________________ > From: Beryl& Mike Tate<post@tatewise.co.uk> > To: family-historian-users@rootsweb.com > Sent: Tuesday, 3 April 2012, 0:10 > Subject: Re: [FHU] Find Same Death Date > > OK George, you knew to format the dates as text, but they don't sort into > date order. > i.e. "1 Feb 1900" and "1 Jan 1800" and "1 Mar 1700" all come together > followed by say "2 Apr 1600" and "20 Dec 1500". > > Because you are searching for two rows with the same date, they will come > together OK. > > I just did not want anyone to get the impression that the dates will sort > into date order. > > Regards, Mike Tate > > -----Original Message----- > From: family-historian-users-bounces@rootsweb.com > [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of George > Bush > Sent: 02 April 2012 22:46 > To: FHUG > Subject: Re: [FHU] Find Same Death Date > > I have tried this already and it did work if I formatted the whole column as > text. However, it did miss the ones I was looking for > but that was because the 2 siblings did not appear next to each other in the > surname list. Good learning experience, though. > > George > > > -------Original Message------- > > From: Beryl& Mike Tate > Date: 02/04/2012 22:24:53 > To: abruce@madasafish.com; family-historian-users@rootsweb.com > Subject: Re: [FHU] Find Same Death Date > > Unfortunately, that probably won't work because Excel and other Spreadsheets > do not recognise dates before 1 Jan 1900 and treat them > as text!!! > > See FHUG Forum thread for details http://www.fhug.org.uk/cgi-bin/index > cgi?action=forum&board=v4use&op=display&num=4785 > > Regards, Mike Tate > > -----Original Message----- > From: family-historian-users-bounces@rootsweb.com > [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Adrian > Bruce > Sent: 02 April 2012 19:56 > To: family-historian-users@rootsweb.com > Subject: Re: [FHU] Find Same Death Date > > <<snipped>> > Somewhere in my, or my wife's, tree are 2 brothers (not twins) who died > either on the same day or within 24 hours of each other. > I cannot for the life of me recall who they were so I wonder if it would be > possible to construct a query to find them for me? > <<snipped>> > > Not sure what you're like with spreadsheets, but I'd create a query to > extract all males with a non-blank death date (or is it > non-null???), sorted by surname then death date; export that to a > spreadsheet; and create a new column whose value was "FOUNDIT" if > the death date on this row matched the death date on the previous row. > > Then just do a search for "FOUNDIT". > > Yes, there are flaws - the 2 with the same name might not be brothers but it > would find all such people so you can do a visual check > on the tiny population found. > > Adrian B > > > > ------------------------------- > 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 > > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2012.0.1913 / Virus Database: 2114/4910 - Release Date: 04/02/12 > > > ------------------------------- > 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 > > > ------------------------------- > 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 > > ------------------------------- > 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 > > > ------------------------------- > 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 > > ------------------------------- 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

Alternatively, there is a 'Change Any Fact Tag' Plugin that can selectively change each of the UDF HIST or HEAL tags into say a Physical Description Attribute, or any other appropriate Event or Attribute, or it can selectively delete the UDF you do not want. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Andrew Jolly Sent: 03 April 2012 17:40 To: family-historian-users@rootsweb.com Subject: Re: [FHU] HIST message when upgrading Done that, and will do, thanks Jane. Andrew On 3 Apr 2012, at 17:19, Jane Taubman wrote: > I would guess they have come from an different program on loading V5 they > are reported again, they would have been in the file on V4 as well, you > might have gained them if you merged a file from another program at some > point. > > In the plugin store you will find a UDF list plugin if you download and run > it, it will list all the problem fields on a query window and you can > select all the cells and press the delete button to get rid of them, > > > > > On 3 April 2012 16:58, Andrew Jolly <asjolly@btinternet.com> wrote: > >> I have just upgraded from v4 to v5 and have a report of a number of things >> 'INFO ONLY' such as : >> >> l.10639 - INFO ONLY: Loaded uncategorised data (non-GEDCOM): "1 HIST >> @@N334@@" >> >> or HEAL etc >> >> which now rest as an item in the relevant persons properties on the >> expanded records view. >> >> What am I supposed to do with them please? >> >> > -- > 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 ------------------------------- 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

Martin, To be pedantic, it is the Google Maps Online Geocoder employed by the 'Map Life Facts' Plugin, that does not recognise the Chapman codes. Assuming the Chapman codes are always delimited by commas or end of field, the Plugin could be modified to recognise them. It would then substitute the full County name before submitting the Location details to Google Maps for Geocoding. I will add it to my Wish List of updates. 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: 03 April 2012 16:45 To: abruce@madasafish.com; family-historian-users@rootsweb.com Subject: Re: [FHU] Addresses and Places I've been following all this, but my problem is a bit different. The mapping plugin doesn't recognise all my county codes - I'm using standard Chapman codes. Is there a solution? Martin ------------------------------- 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

One thing worth considering is that if you separate the place name from the address and, as Jane suggested, use tools, work with data- place names you will be able to find how many names you have put in with people living in that place. Prompting the figure will list those people. You wont get this if you combine address and place name in one line. Don't forget to include the county name too. Victor

I have not been able to reproduce this problem with the opening of the multimedia window. I'm using Windows 7 Professional, 64 bit. Lorna On 02/04/2012 18:02, terryjacombs wrote: > Not sure if anyone else has noticed these or if it is just a problem on my > machine. > > Some of the screen updating when opening, switching and resizing windows is > not working fully on all occasions. > > For example:- > > When opening the multimedia window from the toolbar button (selecting view > all media or for selected records) or by selecting multimedia window from > the view menu, the multimedia window opens with a bit of the previous > window still showing between the multimedia records list and the linked > records list in the context pane. This can be made to vanish by selecting > the grabber at the top of the linked records list and slightly moving it or > switching to another window and back to the multimedia window again. This > happens when I have the family history window maximised on the desktop from > startup. > > If I do it from a smaller window (any size smaller window) it does not > happen, but resizing small windows does not update the screen for the open > window correctly. Switching to another window corrects this. Switching back > to maximised also fails to update correctly on some occasions, but after > switching back to maximised the multimedia windows then open correctly > updated. > > I have generally done this with the family historian windows all maximised > in the main family historian window. I have not experimented with > individual family historian windows floating in the main family historian > window. A bit difficult to fully describe all the circumstances but I hope > this gives some indications. > > I have checked it out from the focus window, records list and diagram > windows on two separate gedcoms and it can occur in all circumstances. > > Not causing any problems, just seems to be some errors in the screen > redrawing routines. > > Window 7 Home premium 64 bit - fully up to date from windows update. >

Hi Walter Thanks for the tip, I have just booked my £19 room Irene On 3 Apr 2012, at 17:54, Walter Burton <walter.burton@gmail.com> wrote: > On 3 April 2012 17:06, (Irene Blackburn, Vol 7, 136 - 1) wrote: > >> >> <There is a course in Mexborough, South Yorkshire, details on FHUG >> website. I am travelling there from Northumberland.> >> >> Course - May 12. > I'm coming down from Oban, even further, but Mexborough's where the course > is. > <advert> If you book early, Travelodge at Doncaster Lakeside have vacancies > at £19 on Fri May 11th. If you're driving, you could be back to Motherwell > Saturday evening about 9pm. > > OK the course is far away, but I'll get lots of payback, gloating over how > quick and easy (and very cheap) it is to get Scottish BMD from Register > house in Edinburgh, and I'll learn how I should have been using FH ! > > See you in May > Walter > > ------------------------------- > 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

Well you can always pay a small fee for more Dropbox storage. Having your Project folder "where Dropbox thinks it ought to be" is actually close to the truth! Put the FH Project folder wherever you like and give Dropbox an alias. I can't comment on Windows Live Mesh - I gave up on Windows long ago - except for FH using a virtual Windows machine! Barry On 3 Apr 2012, at 15:32, family-historian-users-request@rootsweb.com wrote: > I'm on 3.6 GB for 2,800 individuals - but I'm keeping all my censuses, PR > images, downloaded directories etc. > > Sizewise, Dropbox is therefore out for me but I can sync my FH Project up > into Windows Live Mesh and it'll sync from where my FH folder is, not from > where Dropbox thinks I ought to put it. Though having said that, Live Mesh > syncs it back on other machines into C:\Users\user-name. AND (I'm still on > v4) Live Mesh and FH don't agree with one another when FH is writing back to > disk and renaming stuff that Live Mesh is copying. > > I guess you pays your money for these services and takes your choice. Money? > Oh, hang on... > > Adrian B

On 3 April 2012 17:06, (Irene Blackburn, Vol 7, 136 - 1) wrote: > > <There is a course in Mexborough, South Yorkshire, details on FHUG > website. I am travelling there from Northumberland.> > > Course - May 12. I'm coming down from Oban, even further, but Mexborough's where the course is. <advert> If you book early, Travelodge at Doncaster Lakeside have vacancies at £19 on Fri May 11th. If you're driving, you could be back to Motherwell Saturday evening about 9pm. OK the course is far away, but I'll get lots of payback, gloating over how quick and easy (and very cheap) it is to get Scottish BMD from Register house in Edinburgh, and I'll learn how I should have been using FH ! See you in May Walter

Sorry - I forgot to mention that there is also a Filter tool in Excel, which would allow you to select a particular date or range of dates, a particular Surname or Forename, or any other field you would like to use to filter out only that data you want to look at. Graham On 03/04/2012 17:46, Graham@number57.org wrote: > Providing the cell is in Date Format and the full year has been > entered (e.g. 03/04/2012 or 10/2/1989) - even if you can only see the > last two year digits (e.g. 12 for 2012), just using the Sort function > in Excel will sort the data in any order you like. The way this works > depends on which version of Excel you are using. It's powerful enough > to recognise the "/" as a divider. It would be completely thrown if > some dates were in UK style and others in US, though! > > It's pretty much identical in OpenOffice and LibreOffice (free > downloadable alternatives to Microsoft Excel but just as powerful), > although the way you do it is slightly different. > > > Graham > > On 03/04/2012 17:06, Paddy Buckley wrote: >> I also spotted Mike's bold assertion about not being able to sort >> into date >> order in Excel, but was reluctant to comment as he has helped me so many >> times in FH. My main one-name database is an Excel spreadsheet with >> over >> 7300 records. I use 3 columns to sort on date; year, month& day. >> It will >> certainly find twins with different forenames. >> Paddy >> >> ----- Original Message ----- >> From: "Andrea Kent"<andrea.kent@btopenworld.com> >> To:<family-historian-users@rootsweb.com> >> Sent: Tuesday, April 03, 2012 8:05 AM >> Subject: Re: [FHU] Find Same Death Date >> >> >> I use Excel a lot in my research, both for recording data and for to do >> lists at archives, etc. If I want to sort into date order, I just >> create an >> additional column Sort Date, and enter it in the format YYYYMMDD, e.g. >> 19000201, 18000101, 15000607. That way it will always give me the >> correct >> date sequence - a lot to do in a large spreadsheet, I agree, but >> sometimes >> worth it to achieve the end! >> >> Regards, >> Andrea >> >> >> ________________________________ >> From: Beryl& Mike Tate<post@tatewise.co.uk> >> To: family-historian-users@rootsweb.com >> Sent: Tuesday, 3 April 2012, 0:10 >> Subject: Re: [FHU] Find Same Death Date >> >> OK George, you knew to format the dates as text, but they don't sort >> into >> date order. >> i.e. "1 Feb 1900" and "1 Jan 1800" and "1 Mar 1700" all come together >> followed by say "2 Apr 1600" and "20 Dec 1500". >> >> Because you are searching for two rows with the same date, they will >> come >> together OK. >> >> I just did not want anyone to get the impression that the dates will >> sort >> into date order. >> >> Regards, Mike Tate >> >> -----Original Message----- >> From: family-historian-users-bounces@rootsweb.com >> [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of George >> Bush >> Sent: 02 April 2012 22:46 >> To: FHUG >> Subject: Re: [FHU] Find Same Death Date >> >> I have tried this already and it did work if I formatted the whole >> column as >> text. However, it did miss the ones I was looking for >> but that was because the 2 siblings did not appear next to each other >> in the >> surname list. Good learning experience, though. >> >> George >> >> >> -------Original Message------- >> >> From: Beryl& Mike Tate >> Date: 02/04/2012 22:24:53 >> To: abruce@madasafish.com; family-historian-users@rootsweb.com >> Subject: Re: [FHU] Find Same Death Date >> >> Unfortunately, that probably won't work because Excel and other >> Spreadsheets >> do not recognise dates before 1 Jan 1900 and treat them >> as text!!! >> >> See FHUG Forum thread for details http://www.fhug.org.uk/cgi-bin/index >> cgi?action=forum&board=v4use&op=display&num=4785 >> >> Regards, Mike Tate >> >> -----Original Message----- >> From: family-historian-users-bounces@rootsweb.com >> [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Adrian >> Bruce >> Sent: 02 April 2012 19:56 >> To: family-historian-users@rootsweb.com >> Subject: Re: [FHU] Find Same Death Date >> >> <<snipped>> >> Somewhere in my, or my wife's, tree are 2 brothers (not twins) who died >> either on the same day or within 24 hours of each other. >> I cannot for the life of me recall who they were so I wonder if it >> would be >> possible to construct a query to find them for me? >> <<snipped>> >> >> Not sure what you're like with spreadsheets, but I'd create a query to >> extract all males with a non-blank death date (or is it >> non-null???), sorted by surname then death date; export that to a >> spreadsheet; and create a new column whose value was "FOUNDIT" if >> the death date on this row matched the death date on the previous row. >> >> Then just do a search for "FOUNDIT". >> >> Yes, there are flaws - the 2 with the same name might not be brothers >> but it >> would find all such people so you can do a visual check >> on the tiny population found. >> >> Adrian B >> >> >> >> ------------------------------- >> 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 >> >> >> ----- >> No virus found in this message. >> Checked by AVG - www.avg.com >> Version: 2012.0.1913 / Virus Database: 2114/4910 - Release Date: >> 04/02/12 >> >> >> ------------------------------- >> 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 >> >> >> ------------------------------- >> 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 >> >> ------------------------------- >> 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 >> >> >> ------------------------------- >> 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 >> >>

Providing the cell is in Date Format and the full year has been entered (e.g. 03/04/2012 or 10/2/1989) - even if you can only see the last two year digits (e.g. 12 for 2012), just using the Sort function in Excel will sort the data in any order you like. The way this works depends on which version of Excel you are using. It's powerful enough to recognise the "/" as a divider. It would be completely thrown if some dates were in UK style and others in US, though! It's pretty much identical in OpenOffice and LibreOffice (free downloadable alternatives to Microsoft Excel but just as powerful), although the way you do it is slightly different. Graham On 03/04/2012 17:06, Paddy Buckley wrote: > I also spotted Mike's bold assertion about not being able to sort into date > order in Excel, but was reluctant to comment as he has helped me so many > times in FH. My main one-name database is an Excel spreadsheet with over > 7300 records. I use 3 columns to sort on date; year, month& day. It will > certainly find twins with different forenames. > Paddy > > ----- Original Message ----- > From: "Andrea Kent"<andrea.kent@btopenworld.com> > To:<family-historian-users@rootsweb.com> > Sent: Tuesday, April 03, 2012 8:05 AM > Subject: Re: [FHU] Find Same Death Date > > > I use Excel a lot in my research, both for recording data and for to do > lists at archives, etc. If I want to sort into date order, I just create an > additional column Sort Date, and enter it in the format YYYYMMDD, e.g. > 19000201, 18000101, 15000607. That way it will always give me the correct > date sequence - a lot to do in a large spreadsheet, I agree, but sometimes > worth it to achieve the end! > > Regards, > Andrea > > > ________________________________ > From: Beryl& Mike Tate<post@tatewise.co.uk> > To: family-historian-users@rootsweb.com > Sent: Tuesday, 3 April 2012, 0:10 > Subject: Re: [FHU] Find Same Death Date > > OK George, you knew to format the dates as text, but they don't sort into > date order. > i.e. "1 Feb 1900" and "1 Jan 1800" and "1 Mar 1700" all come together > followed by say "2 Apr 1600" and "20 Dec 1500". > > Because you are searching for two rows with the same date, they will come > together OK. > > I just did not want anyone to get the impression that the dates will sort > into date order. > > Regards, Mike Tate > > -----Original Message----- > From: family-historian-users-bounces@rootsweb.com > [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of George > Bush > Sent: 02 April 2012 22:46 > To: FHUG > Subject: Re: [FHU] Find Same Death Date > > I have tried this already and it did work if I formatted the whole column as > text. However, it did miss the ones I was looking for > but that was because the 2 siblings did not appear next to each other in the > surname list. Good learning experience, though. > > George > > > -------Original Message------- > > From: Beryl& Mike Tate > Date: 02/04/2012 22:24:53 > To: abruce@madasafish.com; family-historian-users@rootsweb.com > Subject: Re: [FHU] Find Same Death Date > > Unfortunately, that probably won't work because Excel and other Spreadsheets > do not recognise dates before 1 Jan 1900 and treat them > as text!!! > > See FHUG Forum thread for details http://www.fhug.org.uk/cgi-bin/index > cgi?action=forum&board=v4use&op=display&num=4785 > > Regards, Mike Tate > > -----Original Message----- > From: family-historian-users-bounces@rootsweb.com > [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Adrian > Bruce > Sent: 02 April 2012 19:56 > To: family-historian-users@rootsweb.com > Subject: Re: [FHU] Find Same Death Date > > <<snipped>> > Somewhere in my, or my wife's, tree are 2 brothers (not twins) who died > either on the same day or within 24 hours of each other. > I cannot for the life of me recall who they were so I wonder if it would be > possible to construct a query to find them for me? > <<snipped>> > > Not sure what you're like with spreadsheets, but I'd create a query to > extract all males with a non-blank death date (or is it > non-null???), sorted by surname then death date; export that to a > spreadsheet; and create a new column whose value was "FOUNDIT" if > the death date on this row matched the death date on the previous row. > > Then just do a search for "FOUNDIT". > > Yes, there are flaws - the 2 with the same name might not be brothers but it > would find all such people so you can do a visual check > on the tiny population found. > > Adrian B > > > > ------------------------------- > 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 > > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2012.0.1913 / Virus Database: 2114/4910 - Release Date: 04/02/12 > > > ------------------------------- > 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 > > > ------------------------------- > 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 > > ------------------------------- > 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 > > > ------------------------------- > 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 > >

Done that, and will do, thanks Jane. Andrew On 3 Apr 2012, at 17:19, Jane Taubman wrote: > I would guess they have come from an different program on loading V5 they > are reported again, they would have been in the file on V4 as well, you > might have gained them if you merged a file from another program at some > point. > > In the plugin store you will find a UDF list plugin if you download and run > it, it will list all the problem fields on a query window and you can > select all the cells and press the delete button to get rid of them, > > > > > On 3 April 2012 16:58, Andrew Jolly <asjolly@btinternet.com> wrote: > >> I have just upgraded from v4 to v5 and have a report of a number of things >> 'INFO ONLY' such as : >> >> l.10639 - INFO ONLY: Loaded uncategorised data (non-GEDCOM): "1 HIST >> @@N334@@" >> >> or HEAL etc >> >> which now rest as an item in the relevant persons properties on the >> expanded records view. >> >> What am I supposed to do with them please? >> >> > -- > 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

Nancy, I haven't used FTM so can't give any advice about how best to transfer your media from FTM to FH, but I did notice one thing in your first message which might be significant. You said: "FTM gave me the option of including media in the gedcom file it was creating" I wonder if this means the media was actually embedded in the Gedcom? There are two methods of 'connecting' media to your records: one is to embed them in the Gedcom and the other is to link them to the Gedcom. The first method is not generally recommended as it makes the Gedcom file VERY large, but it is a valid technique. The second, recommended, method is to link your media to the gedcom, preferably first having stored them all in a designated folder, or a media folder with sub-folders for different categories, e.g. photos, census images, images of birth certificates, death certificates, etc. It is possible to 'expel' embedded media objects and convert them to linked ones. However without knowing exactly what the FTM export did with the media I can't help much further. If it did embed tham, it sounds as if FH still is not finding them. Perhaps someone with more knowledge of FTM can come to your aid. Lorna On 03/04/2012 13:03, Nancy Marty wrote: > Thanks for responding, Jane. > > In the Focus Window, I see a box representing each photo, for example, that > I had for that particular person. Then there is a large X from corner to > corner. It shows no Title and in the left column (sorry, I don't know the > names for things yet), when I select the all tab, it just shows something > like a directory for each entry, with the words "no title". When I click on > each of them, I eventually see the name of the person the photo was tied to. > > But I'd like to change my question, I think. I guess a better question would > be, for those of you who converted from other software applications and > didn't start from scratch, how did you add all of your media? The data > itself converts just fabulously. Did you have to manually add your photos, > one at a time, to each person? I have a very small tree, but even the > thought of trying to find where the photos are now stored (some are on my > hard drive, some were merged directly from ancestry.com with their merge > feature) and manually adding say 500 media records drives me to trying to > see what others have done. The bulk of my photos were scanned by a company > and the file names they gave them are just a bunch of letters and numbers. > So I'd have to pull up a photo, see what it's a picture of then find the > person in FH and add it to them. If manually is the only way to do it, I may > still do it while my tree is fairly small. But I don't want to do that > without trying to see what others have done. >

<<snipped>> This seems strange as it is a Mormon program and so is Gedcom. <<snipped>> Err - yes. (I might also ask how it is that GEDCOM doesn't seem to cope with polygamy but maybe that's not the done thing to ask the LDS!) <<snipped>> This means that all my names are full ones with both "address" and "place" combined. Having read all the postings regarding this I am questioning the need to change all my entries to show address and place separately. If I don't I do have some (much) duplication in reports.. <<snipped>> I wouldn't have thought you would get duplication??? While a report may show slots for "address" and "place", as far as FH is concerned, surely you have used only "place" and the "address" boxes are all empty. You and I know your "place" names contain an, ahem, "address" but FH doesn't know - it just thinks you've got placenames. (And empty addresses). Unless you start hitting problems, I'd leave well alone. The only issue I can think of within FH would be that if you put the placename onto diagrams and try to shorten it, you might end up with placenames like "42 High St". Equally, if you started to generate HTML pages that (say) had an index of placenames, your list would be large and odd because it would actually be addresses not places. But you might get used to that. Adrian B

To edit places or addresses use Tools>Work With Data If you want to change them at some point it's a pretty easy plugin to write to say remove the Place string from the Address field if you wanted to. On 3 April 2012 16:55, Robert Warnock <robert.warnock@virgin.net> wrote: > But if I do it looks as if I would > have to go through my database for every individual and do the changes > manually. I can get lists of places in reports but cannot find any list > which is editable. > -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

I would guess they have come from an different program on loading V5 they are reported again, they would have been in the file on V4 as well, you might have gained them if you merged a file from another program at some point. In the plugin store you will find a UDF list plugin if you download and run it, it will list all the problem fields on a query window and you can select all the cells and press the delete button to get rid of them, On 3 April 2012 16:58, Andrew Jolly <asjolly@btinternet.com> wrote: > I have just upgraded from v4 to v5 and have a report of a number of things > 'INFO ONLY' such as : > > l.10639 - INFO ONLY: Loaded uncategorised data (non-GEDCOM): "1 HIST > @@N334@@" > > or HEAL etc > > which now rest as an item in the relevant persons properties on the > expanded records view. > > What am I supposed to do with them please? > > -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

I also spotted Mike's bold assertion about not being able to sort into date order in Excel, but was reluctant to comment as he has helped me so many times in FH. My main one-name database is an Excel spreadsheet with over 7300 records. I use 3 columns to sort on date; year, month & day. It will certainly find twins with different forenames. Paddy ----- Original Message ----- From: "Andrea Kent" <andrea.kent@btopenworld.com> To: <family-historian-users@rootsweb.com> Sent: Tuesday, April 03, 2012 8:05 AM Subject: Re: [FHU] Find Same Death Date I use Excel a lot in my research, both for recording data and for to do lists at archives, etc. If I want to sort into date order, I just create an additional column Sort Date, and enter it in the format YYYYMMDD, e.g. 19000201, 18000101, 15000607. That way it will always give me the correct date sequence - a lot to do in a large spreadsheet, I agree, but sometimes worth it to achieve the end! Regards, Andrea ________________________________ From: Beryl & Mike Tate <post@tatewise.co.uk> To: family-historian-users@rootsweb.com Sent: Tuesday, 3 April 2012, 0:10 Subject: Re: [FHU] Find Same Death Date OK George, you knew to format the dates as text, but they don't sort into date order. i.e. "1 Feb 1900" and "1 Jan 1800" and "1 Mar 1700" all come together followed by say "2 Apr 1600" and "20 Dec 1500". Because you are searching for two rows with the same date, they will come together OK. I just did not want anyone to get the impression that the dates will sort into date order. Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of George Bush Sent: 02 April 2012 22:46 To: FHUG Subject: Re: [FHU] Find Same Death Date I have tried this already and it did work if I formatted the whole column as text. However, it did miss the ones I was looking for but that was because the 2 siblings did not appear next to each other in the surname list. Good learning experience, though. George -------Original Message------- From: Beryl & Mike Tate Date: 02/04/2012 22:24:53 To: abruce@madasafish.com; family-historian-users@rootsweb.com Subject: Re: [FHU] Find Same Death Date Unfortunately, that probably won't work because Excel and other Spreadsheets do not recognise dates before 1 Jan 1900 and treat them as text!!! See FHUG Forum thread for details http://www.fhug.org.uk/cgi-bin/index cgi?action=forum&board=v4use&op=display&num=4785 Regards, Mike Tate -----Original Message----- From: family-historian-users-bounces@rootsweb.com [mailto:family-historian-users-bounces@rootsweb.com] On Behalf Of Adrian Bruce Sent: 02 April 2012 19:56 To: family-historian-users@rootsweb.com Subject: Re: [FHU] Find Same Death Date <<snipped>> Somewhere in my, or my wife's, tree are 2 brothers (not twins) who died either on the same day or within 24 hours of each other. I cannot for the life of me recall who they were so I wonder if it would be possible to construct a query to find them for me? <<snipped>> Not sure what you're like with spreadsheets, but I'd create a query to extract all males with a non-blank death date (or is it non-null???), sorted by surname then death date; export that to a spreadsheet; and create a new column whose value was "FOUNDIT" if the death date on this row matched the death date on the previous row. Then just do a search for "FOUNDIT". Yes, there are flaws - the 2 with the same name might not be brothers but it would find all such people so you can do a visual check on the tiny population found. Adrian B ------------------------------- 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 ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.1913 / Virus Database: 2114/4910 - Release Date: 04/02/12 ------------------------------- 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 ------------------------------- 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 ------------------------------- 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