RE: [LegacyUG] How to merge a basic source into ESM template source using Access
Richard, I had a look at this to see if it would work in OpenOffice. In principle it should, although the syntax of the query is quite different - anyone who uses OOo should be able to convert it without difficulty. Unfortunately I was unable to verify whether the procedure works in OOo. This is because I'm an unreconstructed lumper and Source Writer has forced me to be somewhat less unreconstruced, hence my old and new files are not sufficiently compatible to test. Ron Ferguson _ *New Tutorial* Create Standards Compliant CSS Pedigree web pages http://www.fergys.co.uk/ View the Grimshaw Family Tree at: http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England See: http://myweb.tiscali.co.uk/fergys/ _ Date: Tue, 9 Jun 2009 19:29:26 -0700 Subject: [LegacyUG] How to merge a basic source into ESM template source using Access From: rfvanwasshn...@gmail.com To: LegacyUserGroup@legacyfamilytree.com In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. In Legacy: Tag the 2 sources you want to be merged (1 ESM 1 basic). From the source list check show only tagged sources to verify you have only 1 basic 1 ESM. Also: For the basic source: Show List Clear all tag1 Tag everyone in List.This will help to fill in the citation template later. From File Save Family File as: BasicSource Close Legacy. Open Access with your main file.fdb. Add the following select query to view tagged sources: SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, tblSR.TemplateID, tblSR.SrcTag FROM tblSR WHERE (((tblSR.SrcTag)=1)); Manually make following changes on the select query: Change “TemplateID” of the basic from 0 to equal the positive ID of the ESM. Change “UseStandard” on the basic from 1 to 0. Notice “Contents” of ESM record contains a template but the basic remains blank. Close Access. Open Legacy. Your 2 tagged sources now have the same templateID so they can now be merged or you can wait till you've filled in the source Detail templates. Go through your tagged individuals to fill in citation detail templates, untag Individuals as templates are filled in until all are untagged. Your multimedia will be there, Text/Comments will be there and Recorded date also. If you can't fill in the citation detail template from viewing multimedia or Text/Comments go back to your old BasicSource file. -- Richard Van Wasshnova http://www.gencircles.com/users/vanwasshnova http://gw.geneanet.org/vanwasshnova _ Get the best of MSN on your mobile http://clk.atdmt.com/UKM/go/147991039/direct/01/ Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] How to merge a basic source into ESM template source using Access
Richard Van Wasshnova wrote Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. Richard, thank you *so much* for these instructions. I think they may save me a *great deal* of time. But how frustrating that they arrive on the day I am going away for a couple of weeks and will be using a computer which doesn't have Access:-( I shall be itching to come home! -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] How to merge a basic source into ESM template source using Access
Thank you very much Richard. Appreciate it. Jeff - Original Message - From: Richard Van Wasshnova rfvanwasshn...@gmail.com To: LegacyUserGroup@legacyfamilytree.com Sent: Tuesday, June 09, 2009 10:29 PM Subject: [LegacyUG] How to merge a basic source into ESM template source using Access In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. In Legacy: Tag the 2 sources you want to be merged (1 ESM 1 basic). From the source list check show only tagged sources to verify you have only 1 basic 1 ESM. Also: For the basic source: Show List Clear all tag1 Tag everyone in List.This will help to fill in the citation template later. From File Save Family File as: BasicSource Close Legacy. Open Access with your main file.fdb. Add the following select query to view tagged sources: SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, tblSR.TemplateID, tblSR.SrcTag FROM tblSR WHERE (((tblSR.SrcTag)=1)); Manually make following changes on the select query: Change “TemplateID” of the basic from 0 to equal the positive ID of the ESM. Change “UseStandard” on the basic from 1 to 0. Notice “Contents” of ESM record contains a template but the basic remains blank. Close Access. Open Legacy. Your 2 tagged sources now have the same templateID so they can now be merged or you can wait till you've filled in the source Detail templates. Go through your tagged individuals to fill in citation detail templates, untag Individuals as templates are filled in until all are untagged. Your multimedia will be there, Text/Comments will be there and Recorded date also. If you can't fill in the citation detail template from viewing multimedia or Text/Comments go back to your old BasicSource file. -- Richard Van Wasshnova http://www.gencircles.com/users/vanwasshnova http://gw.geneanet.org/vanwasshnova Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] How to merge a basic source into ESM template source using Access
Do not attempt to edit your Family File in Access without first doing a backup of the Family File! Thanks for using Legacy. Sherry Customer Support Millennia Corporation supp...@legacyfamilytree.com http://www.LegacyFamilyTree.com We are changing the world of genealogy! When replying to this message, please include all previous correspondence. Thanks. -Original Message- From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of Richard Van Wasshnova Sent: Tuesday, June 09, 2009 7:29 PM To: LegacyUserGroup@legacyfamilytree.com Subject: [LegacyUG] How to merge a basic source into ESM template source using Access In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to.snip Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] How to merge a basic source into ESM template source using Access
Be sure to back up the Family File before making any changes to it in Access or OO. Thanks for using Legacy. Sherry Customer Support Millennia Corporation supp...@legacyfamilytree.com http://www.LegacyFamilyTree.com We are changing the world of genealogy! When replying to this message, please include all previous correspondence. Thanks. -Original Message- From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of Jenny M Benson Sent: Wednesday, June 10, 2009 4:01 AM To: LegacyUserGroup@LegacyFamilyTree.com Subject: Re: [LegacyUG] How to merge a basic source into ESM template source using Access Richard Van Wasshnova wrote Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. Richard, thank you *so much* for these instructions. I think they may save me a *great deal* of time. But how frustrating that they arrive on the day I am going away for a couple of weeks and will be using a computer which doesn't have Access:-( I shall be itching to come home! -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] How to merge a basic source into ESM template source using Access
Richard, This is a jewel. I tried it out and it works great! Thank you for choosing Legacy, Jim Terry Technical Support Legacy Family Tree Legacy Charting http://LegacyFamilyTree.com Phone: 425 788-0932 We are changing the world of genealogy! -Original Message- From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of Richard Van Wasshnova Sent: Tuesday, June 09, 2009 7:29 PM To: LegacyUserGroup@legacyfamilytree.com Subject: [LegacyUG] How to merge a basic source into ESM template source using Access In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. In Legacy: Tag the 2 sources you want to be merged (1 ESM 1 basic). From the source list check show only tagged sources to verify you have only 1 basic 1 ESM. Also: For the basic source: Show List Clear all tag1 Tag everyone in List.This will help to fill in the citation template later. From File Save Family File as: BasicSource Close Legacy. Open Access with your main file.fdb. Add the following select query to view tagged sources: SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, tblSR.TemplateID, tblSR.SrcTag FROM tblSR WHERE (((tblSR.SrcTag)=1)); Manually make following changes on the select query: Change TemplateID of the basic from 0 to equal the positive ID of the ESM. Change UseStandard on the basic from 1 to 0. Notice Contents of ESM record contains a template but the basic remains blank. Close Access. Open Legacy. Your 2 tagged sources now have the same templateID so they can now be merged or you can wait till you've filled in the source Detail templates. Go through your tagged individuals to fill in citation detail templates, untag Individuals as templates are filled in until all are untagged. Your multimedia will be there, Text/Comments will be there and Recorded date also. If you can't fill in the citation detail template from viewing multimedia or Text/Comments go back to your old BasicSource file. -- Richard Van Wasshnova http://www.gencircles.com/users/vanwasshnova http://gw.geneanet.org/vanwasshnova Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp _ I am using the Free version of SPAMfighter http://www.spamfighter.com/len . We are a community of 6 million users fighting spam. SPAMfighter has removed 47230 of my spam emails to date. The Professional version does not have this message. Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] How to merge a basic source into ESM template source using Access
Although I have both Access and OO database, I have no experience of using either programme - it simply hasn't proved relevant to my computer needs. Is it possible that this method of combining sources will be available in Legacy at any time? -- - - - - - - - Elizabeth researching ALLAMBRIDGE (Dorset, Somerset and anywhere else they might turn up) 2009/6/10 Jim Terry/Support jimte...@legacyfamilytree.com: Richard, This is a jewel. I tried it out and it works great! Thank you for choosing Legacy, Jim Terry Technical Support Legacy Family Tree -Original Message- From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of Richard Van Wasshnova Sent: Tuesday, June 09, 2009 7:29 PM To: LegacyUserGroup@legacyfamilytree.com Subject: [LegacyUG] How to merge a basic source into ESM template source using Access In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. In Legacy: Tag the 2 sources you want to be merged (1 ESM 1 basic). From the source list check show only tagged sources to verify you have only 1 basic 1 ESM. Also: For the basic source: Show List Clear all tag1 Tag everyone in List.This will help to fill in the citation template later. From File Save Family File as: BasicSource Close Legacy. Open Access with your main file.fdb. Add the following select query to view tagged sources: SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, tblSR.TemplateID, tblSR.SrcTag FROM tblSR WHERE (((tblSR.SrcTag)=1)); Manually make following changes on the select query: Change “TemplateID” of the basic from 0 to equal the positive ID of the ESM. Change “UseStandard” on the basic from 1 to 0. Notice “Contents” of ESM record contains a template but the basic remains blank. Close Access. Open Legacy. Your 2 tagged sources now have the same templateID so they can now be merged or you can wait till you've filled in the source Detail templates. Go through your tagged individuals to fill in citation detail templates, untag Individuals as templates are filled in until all are untagged. Your multimedia will be there, Text/Comments will be there and Recorded date also. If you can't fill in the citation detail template from viewing multimedia or Text/Comments go back to your old BasicSource file. -- Richard Van Wasshnova Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] How to merge a basic source into ESM template source using Access
Richard, Thank you for the detailed instructions. At this late hour, they seem a bit daunting, but I will definitely hang onto them. --Paula in Texas --- On Tue, 6/9/09, Richard Van Wasshnova rfvanwasshn...@gmail.com wrote: From: Richard Van Wasshnova rfvanwasshn...@gmail.com Subject: [LegacyUG] How to merge a basic source into ESM template source using Access To: LegacyUserGroup@legacyfamilytree.com Date: Tuesday, June 9, 2009, 9:29 PM In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. In Legacy: Tag the 2 sources you want to be merged (1 ESM 1 basic). From the source list check show only tagged sources to verify you have only 1 basic 1 ESM. Also: For the basic source: Show List Clear all tag1 Tag everyone in List.This will help to fill in the citation template later. From File Save Family File as: BasicSource Close Legacy. Open Access with your main file.fdb. Add the following select query to view tagged sources: SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, tblSR.TemplateID, tblSR.SrcTag FROM tblSR WHERE (((tblSR.SrcTag)=1)); Manually make following changes on the select query: Change “TemplateID” of the basic from 0 to equal the positive ID of the ESM. Change “UseStandard” on the basic from 1 to 0. Notice “Contents” of ESM record contains a template but the basic remains blank. Close Access. Open Legacy. Your 2 tagged sources now have the same templateID so they can now be merged or you can wait till you've filled in the source Detail templates. Go through your tagged individuals to fill in citation detail templates, untag Individuals as templates are filled in until all are untagged. Your multimedia will be there, Text/Comments will be there and Recorded date also. If you can't fill in the citation detail template from viewing multimedia or Text/Comments go back to your old BasicSource file. -- Richard Van Wasshnova http://www.gencircles.com/users/vanwasshnova http://gw.geneanet.org/vanwasshnova Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp