Monday, July 20, 2015

Blogiversary

Happy-Anniversary

 

Yesterday was our 3rd blogiversary and I am celebrating by taking a couple of weeks off.

 

Copyright © 2015 Michèle Simmons Lewis

Friday, July 17, 2015

For those that use BYU’s Relative Finder

RF

If you don’t know what BYU’s Relative Finder is click HERE. Before we go any further, please know that this website is mostly for fun.  If you find a connection to someone that doesn’t mean you are actually related to them. There are many connections errors on FamilySearch so you will need to prove every relationship up the line and then back down to the person you are connected to. 

BYU’s Relative Finder

I have set up a new Group just for the Ancestoring blog readers.  You can see if you are related to me or to any other blog reader that has signed up.

Before you can do this you must have a FamilySearch login.  You also have to have yourself connected in FamilySearch’s Family Tree.

On the top menu bar go to Groups then Join.  Typing in Ancestoring in the Search box. Click Add. Type in the Password which is blog.  Now the group is added to the list of groups you can search. 

Go back to the home page.  Click Relatives on the top menu bar.  You will now see Ancestoring as one of the groups you can select on the left.

If you are related to me, let me know how in the comments.

 

Copyright © 2015 Michèle Simmons Lewis

Wednesday, July 15, 2015

Yet another reason to join the NGS

member_pin

If you are a member of the National Genealogical Society (NGS) you can get a free year’s subscription to FindMyPast. How cool is that!  You do not have to enter your credit card number so that is even better. The signup page is HERE. For more reasons to join genealogical societies click HERE.

Copyright © 2015 Michèle Simmons Lewis

Monday, July 13, 2015

Thank you, ESM

IMG_20150714_095018902

The 3rd edition of Elizabeth Shown Mills’ Evidence Explained has joined my battered 1st edition in my bookcase. You can see that I also have Elizabeth’s first citation book, Evidence! Citation & Analysis for the Family Historian. I bought Evidence! in 1997 and it completely changed everything. By 1997 I had been researching my family for six years and I had been doing everything wrong. I read the first two chapters, “Fundamentals of Citation” and “Fundamentals of Analysis,” over and over again. I realized that I just didn’t know enough to do quality research. I immediately enrolled in Brigham Young University’s Independent Study Program and I took every genealogy course they had from 1997 through 2001. I quickly learned just how important continuing education is and to this day I take advantage of as many reference books, conferences, classes and webinars that I can.  That is why I couldn’t wait to get my hands on the 3rd Edition of EE. The first two chapters are “Fundamentals of Evidence Analysis” and Fundamentals of Citation.”  If new researchers would read these two chapters they too would have the eye opening experience that I did.

Thanks, Elizabeth, for everything.

 

Copyright © 2015 Michèle Simmons Lewis

 

Friday, July 10, 2015

Legacy: Even more searches

In the blog post Legacy: Searches and more searches I told you about the six different tabs on the main search page.   There are three other types of searches Legacy can do.

Search> Search/Replace
This one is used to fix errors in your file or to change the wording of something.  Because you will be making global changes it is very important that you back up your file before you get started just in case things don’t go the way you planned.

Let’s say I have been using the abbreviation Ev. for Evangelisch and I now want the word spelled out.

b1

 

And here is what it looks like once you click the Start button:

b2

The Replace All button is a great timesaver but don’t click it unless you are 100% sure something you don’t want changed won’t be.  You can use the Replace button which will let you approve each replacement one at a time.

 

Search > Search Internet
The other type of search in Legacy is an external one.  This is how you can search websites from within Legacy using the information you have already gathered.  Notice how the information defaults in.

b3

Also notice the dropdown arrow next to Ancestry.com.  There are 30 websites to choose from and you can add your own using the Customize Searches button.  Make sure you click on the Help button on this screen because you will need to learn how to create the search strings to make it work correctly.

There is one more search, Search > FamilySearch.  This will bring up the screen that directly interfaces with FamilySearch’s Family Tree.  Explaining how this works is more than a single blog post can handle so here is some additional information for you.

 

Copyright © 2015 Michèle Simmons Lewis

Wednesday, July 8, 2015

Legacy: Searches and more searches

Did you know that there are SIX different search tabs?  Legacy has several built-in searches to make your life easier.

Tab 1 – Query by example
This is a simple fill-in-the blank search form.

I am looking for all male Glaentzers whose first name starts with B, who were born before 1880 in Köln (I don’t have type the rest of the location)

blog 1

 

Tab 2 – Detailed Search
This is the search tab that most people go to when searching.  One thing that a lot of people don’t realize is that you can have as many search criteria you want, not just the three that are on the screen.  The trick is to do your first search using the three search criteria and then Create List.  Then change the search criteria to your next three but this time select ONLY SEARCH THE SEARCH LIST.  You can do this as many times as you need to.  This multi-tiered search is very powerful.  I am looking for every Glaentzer that was was born in Germany and is also on Tag 9.

blog 2

 

Tab 3 – Miscellaneous
This is a fun one.  There are all kinds of great searches here.  Here I am doing a simple search for everyone in my file that has an unknown spouse.

blog 3

 

Tab 4 – Missing Sources
This is a scary tab.  Everyone know how important it is to have a source for every fact in your file.  This tab will help you do that.  I am searching for anyone that does not have a source for the relationship to father and/or the relationship to mother (these are two very overlooked source fields).  Notice the two options at the top, Everything and Anything, as well as the two at the bottom ALL or ONE.

blog 4

 

Tab 5 – Missing Information
This tab isn’t as scary as tab 4.   Here I am searching for missing birth, marriage and death dates.  Why?  So I can go back and estimate these dates based on the information I do have.  It is always good to estimate the dates so that you can do better searches on repository websites.  It also helps you rulle people in and out when you are trying to figure out who could be the parents of whom and whether you are dealing with one person or two people with the same name (it is all about timelines). Again, notice the two options at the bottom ALL or ONE.

Blog 5

 

Tab 6 – Census List
This is a great way to systematically go through your file and fill in census information.  The state of Mississippi conducted a statewide census in 1866.  I am looking for everyone in my file that was alive in 1866 and should have been living in the state of Mississippi so that I can check to see if they appear in this census.  I also want to exclude anyone that I have already recorded a 1866 census for (Legacy looks at events and sources to figure this out).  There are checkboxes to narrow the search further but I am going to leave it like this.

Blog 6

 

Notice that ALL of the tabs allow you to append your search list and all but the Misc. Search will also allow you to search just the current search list which means you can switch back and forth between the tabs and mix and match your searches.

 

Copyright © 2015 Michèle Simmons Lewis

Monday, July 6, 2015

Legacy: What do all of those numbers mean?

I posted this on the Legacy User Group Facebook page and I didn’t want a good graphic to go to waste so I am posting it here as well.  Do you know what all of the numbers mean in the extreme bottom right corner of the Family view?

Tips

Copyright © 2015 Michèle Simmons Lewis

Friday, June 26, 2015

I’m not here

alligator-1395206976QHHPhotograph courtesy of Public Domain Pictures

 

I’m in Florida so no blog post.

 

Copyright © 2015 Michèle Simmons Lewis

 

Wednesday, June 24, 2015

Recording internet database searches

I hope by now everyone knows the importance of keeping research logs.  However, many of the researchers that do use research logs don’t bother to record internet database searches.  I agree that recording every single search you do slows you down but I still think it is necessary. 

We will use Find A Grave as an example since it is constantly being updated.  I make an entry showing not only the date that I searched but also the parameters I used.  This is definitely a database I want to check periodically.  I do this for every single search that I do on every single person.  I record these as To-Do tasks in Legacy because they are very easy to enter and you can tell Legacy to remind you when you need to do a new search, say, every three months.  I don’t have to reenter it.  The reminder will show up on the Legacy Home tab.  On the Legacy Home tab if you go to OPTIONS > OPTIONS > REMINDER OPTIONS you can change the number of days notice you get for reminders. The default is 14 days.

ss1

Chocolate is a rare enough surname that I can just run a search using the surname and then go through the entries one by one.  I might even pick up a related Chocolate.  I also limited the search to the state of Mississippi since Ghirardelli was born there, married there and lived her entire life there so she is, most likely, buried there.  (You guys do know that Ghirardelli Chocolate is a fake person, right?)

I can also update my search criteria.  Let’s say I find out that Ghirardelli visited her sister Melted Chocolate over in Louisiana on a regular basis and that Melted was her only living relative.  I could make a note that I expanded my search to include Louisiana.  Maybe I find out that Ghirardelli married late in life and her new surname was Pistachio.  I would need to update my search criteria.  I take the time to record all of this information.

Notice that the first time I did this search was 15 Nov 2014.  The next scheduled search is on 15 Aug 2015.  Here is a shot of the Results tab:

ss2

Here you can see the negative searches I have already done. If on August 15th I search Find A Grave and I find Ghirardelli then I can close this task out.  I will put what I found on the results tab.  I can put a link the memorial and/or the information on the memorial. 

I can then add a new To-Do task if I need to request a photograph be taken (if there isn’t one). I will get reminders just to let me know the photo hasn’t been taken yet.  On those To-Do’s I also record whether or not I have permission to use the photo once the photo has been taken.  I don’t close the photo task out until I know one way or the other whether I have that permission.

I do this for every database I search.  For example, I don’t make a To-Do for Ancestry.com but rather I do one for each specific database I accessed on Ancestry.com.  I know it sounds time consuming but once you get into a routine it is no big deal. 

You can also do this with broader searches not tied to a specific person.  This is great for One-Name Studies (ONS).  I am going to show you a real one from my ONS file. Internet databases are especially important to ONS and you have got to have a way to keep track of what you have done and when.  I make a General To-Do for each database that I search.  Here is one for Germany Births and Baptisms, 1558-1898 on FamilySearch:

ss3

I have the category as Online Databases so that I can sort them together when I use the filter. I have a couple of other General To-Do categories.  These are different than the categories I use for Individual To-Dos.

Here is the Results tab:

ss4

You can see how many name variations I searched and now many hits I got on each name.  An X means I have entered those hits into my database.  This database is a little different in that it is a stagnant one.  It probably won’t be updated though I will still check periodically just in case.

 

Copyright © 2015 Michèle Simmons Lewis

Monday, June 22, 2015

Jazzing up Legacy reports

Someone on the Legacy Virtual Users' Group Community on Google+ said that they were trying to learn more about Legacy reports and how to make them more attractive and interesting to family and friends.  Many Legacy users miss a very powerful tool called “Edit Event Definitions.”

In a nutshell, Legacy uses simple codes to trigger how sentences read out in reports.  You can manipulate these codes to alter how the sentences will read.  You can get VERY creative with this to include conditional sentences (if… then…). 

In the Help File, type in the word "Sentence" (no quotes) and then click the word "Event" that appears underneath that entry.  This explains how to customize your sentences and it will list all of the codes and what they do. 

To get to the screen where you can do this, go to VIEW >  MASTER LISTS > EVENT DEFINITION.   When I am working with Events I like to purge my unused ones so that I can see what I really have.  OPTIONS > PURGE UNUSED.  Uncheck the box that will put the defaults back in.  You can put these back in later if you want to by doing the same thing only this time check marking the box.

Highlight the first event you want to work with and then click EDIT over on the right.  The first screenshot shows the screen where you can change the way the sentences will be worded.  This is actually a lot of fun.  This is the generic Residence event.  You can change the codes or you can change the text between the codes.  Here are two simple examples. In the first field I could change the sentence to:

[FirstName] lived [inPlace] at [Desc] [onDate].  You have A LOT of codes you can choose from and the possibilities are endless.

You can do something more complicated like:

[HeShe] <::lives::lived> at [Desc] [inPlace] [onDate].  Now the verb tense will change depending on whether or not the person is living or deceased.

SS1

 

You can also do this with shared event roles.  Here is the generic Occupant role.

SS2

 

After you take the time to customize these events you definitely want to tag them so know what you have already done.

ss3

 

On the first screenshot you will notice that there is a RESET button in the bottom right corner.  If you click this you have two options:

ss2

If you choose to Load default sentences, it will reset to the Legacy generic sentences.  This is useful if you aren’t happy with what you have done and you want to start over.  If you have crafted some really good sentences for another event that you think could give you a head start on a new event you are working on you can choose to Load sentences from another event.

Have fun!

 

Copyright © 2015 Michèle Simmons Lewis

Friday, June 19, 2015

I was wrong (it happens)

Several people sent me a message telling me that Find A Grave wants you to put full names on the entries even if the information isn’t on the marker. I don’t agree with Find A Grave’s policy but my readers are correct. Here is what the Find A Grave FAQ says:

First Name
First name of the deceased. Put the entire first name (if known), even if the grave marker is only an initial. Do not include titles or other prefixes in the First Name field.

Middle Name
Middle name of deceased. Put the entire middle name (if known), even if the grave marker is only an initial.

Nickname
A familiar name of the deceased, if known; the nickname is automatically placed in quotes. A nickname is different from the real name (first or middle).

Maiden Name
Maiden name of a married individual, if known (otherwise leave blank); the maiden name is automatically italicized and is only used if the individual was married and took the spouse's last name as their new last name. If the deceased was never married, then the last name is placed in the "Last Name" field, NOT in the "Maiden Name" field.

Last Name
Last Name as you would find it on the tombstone, if the interred had more than one marriage or other possible spellings please place this information in the bio and use the family links. Do not include honorary or other suffixes in the Last Name field.

I disagree with how Find A Grave handles this.  They want you to add information to the first, middle, nickname and maiden name but for the last name they want you to put what is on the marker and then any additional information in the bio.  That’s a bit inconsistent.

If they want you to add information that isn’t on the marker then they need a box you can check that states the information is NOT on the marker.  AGAIN, this is a moot point if there is a clear photo.  If there is a photograph everyone can see what is on the marker themselves so it doesn’t matter that you have added information.  I am talking about memorials that don’t have photographs. 

I think that people are confused about what the SOURCE of the information is.  If I go to a cemetery in person the source of my evidence is the GRAVE MARKER.  It is no different with Find A Grave.  The source of the information is the GRAVE MARKER.  If there is no grave marker photo then the evidence presented on the Find A Grave memorial is nothing more than an index/database which is a dubious source at best.

Indexes are FINDING AIDS.  They assist you in locating records.  For example, the information on a Find a Grave memorial that does not have a marker photograph can lead you to things like a actual photo of the marker (you put in a request for it), a death certificate (you order it based on the information on FAG) or an obituary (you search newspapers using the information provided).  Those things become your source. 

I will give you an example.  This isn’t a name example, it is more a date and additional information example:

John Lewis FAG Memorial

I have done A LOT of research on John Lewis and I can tell you that he isn’t buried at Grove First Baptist Church.  He doesn’t have marker at Grove Baptist and they have no record of his burial but that is not the only reason I believe that he is not there. He was a member of Lewis Memorial United Methodist Church (named after his son) which is several miles away. At the time it was Sardis Methodist Church.  His homeplace was near this church. Hard to believe that John would have not only been buried at a church he didn’t belong to but at a church of a different denomination not to mention this church was not near where he lived.

Where did the exact birth and death dates come from?  I have his exact birth and death dates and I have a source for them but there is no mention on this memorial where the dates (or the birth and death locations came from).

Husband of Mary C. Sims.  John had four known marriages which I have fully documented that span his life from age 22 until his death at age 79 none of them being Mary C. Sims.  I am not sure when he could have squeezed another marriage in but if he did I would like to see a source for this.

So, someone comes along and sees all this great information and they add it to their file.  They dutifully add Find A Grave as the source.  Can you see the problem with this?  People look at this memorial and assume that the information was taken from a marker or maybe from Sexton records. 

There needs to be a way to show that this information was not from a marker like a checkbox or something.  The way I handle it is that I use the bio section to write up any explanations that I need but not everyone does this.  Here is an example of one without a marker photograph.  This was from a cemetery survey I did in 2003 before I started taking photos of markers. I DID update the full name on this one and I will continue to do so now that I see that this is what Find A Grave wants but I will also continue to put an explanation in the bio section.

Mrs. Elizabeth McGlamery Montgomery Memorial

 

Copyright © 2015 Michèle Simmons Lewis

Thursday, June 18, 2015

Legacy Family Tree Announcement

newversion8

Due to popular demand the official Legacy User Group Facebook Group has been formed. This group is set up just like our Legacy User Group Mailing List.  This is a place where users can share ideas and help each other.  Technical support will be monitoring the group BUT this isn't the place to get technical support help.  If you are having a technical problem with the program please send an email to Legacy Technical Support so that we can get your issue logged into our tracking system.   We would love for you to post about your favorite features, tips, tricks and shortcuts you have discovered.  You can post questions about how to do certain tasks in Legacy.   The Legacy staff will also be posting hints and videos for you.

 

Copyright © 2015 Michèle Simmons Lewis

Wednesday, June 17, 2015

I had to decline a Find A Grave edit today

Simmons, William 1978 and Docia Perry 1987
Copyright © 1994 Michele Simmons Lewis*

 For those of you that are familiar with the Edit tab on Find A Grave’s Contributor Tools page, I had to decline two edits today. This is the first time I have had to do this. The two markers in question were from a cemetery survey I did many years ago. At that time I wasn’t photographing markers, just surveying them. The person wanted me to add information to the person’s name and dates that isn’t on the marker. If there is a photograph I will update the information and then put a blurb that “FAG volunteer #999999 states that John Q. Doe’s full name is John Quincy Doe and his full date of birth is 15 June 1858. Please contact #999999 for more information and their sources.”  Since you can see what is actually written on the marker you can take any additional information with a grain of salt. I don’t mind adding it along with a disclaimer. However, if there is no photograph I don’t want to add any additional information that isn’t on the marker because then it is not clear what is on the marker and what isn’t.  I could add a transcription of the marker (there is a place to do that) but it is easily overlooked, especially by beginners who will just see all of that great complete information and they will snag it as is.  I did go in and update the bio section with the information the person gave along with his information but I did not change the name and date that was associated with the person.

A side note, when you use Find A Grave as a source it is the marker photo you are creating a citation for.  If there is no photograph, I don’t use Find A Grave as a source.  You can use the information the person typed into the Bio section as a clue but the evidence is on the marker.


*This is a photo I took of my grandparents’ grave. This isn’t the grave that is in question in the blog post.  I just wanted to jazz up the blog with a photo.

 

Copyright © 2015 Michèle Simmons Lewis

Monday, June 15, 2015

Should I change my name?

One of the Legacy French translators always writes my name as Michèle with an accent mark because that is how it is written in French. I kind of like it. My dad always told me that he spelled my name with one L because that was the French way. Too bad he forgot to include the accent mark. Whenever I email this French translator (and now all of our French translators) I use this spelling.

So what are the implications? I wonder if a hundred years from now a genealogist will be entering this as an AKA for me.

 

Copyright © 2015 Michèle Simmons Lewis

Friday, June 12, 2015

Follow-up to Something so simple

Two people contacted me with some thoughts about my Something so simple post that I wanted to address.

From Kathy,

“And an even more accurate way of recording it would be to record it as Between June 1801 and May 1802 (change month as appropriate depending on which census it is (UK ones happened in different months in different years)”

The reason I didn't suggest this is then you get into the whole debate between looking at the official census date and the date the numerator put at the top of the page. These two dates are rarely the same.  However, whether the census official census date was 01 June vs. the actual enumeration date of 15 September, my method still works.

 

From Bob,

“This assumes the person's age was recorded accurately. You are right if the age is right, but I think that "about" is better on the basis that the age is not necessarily (and most probably not) accurate.”

Sometimes you have to make some base assumptions and then adjust as you get more information in. For example, I assume that children are born within the confines of their parents' marriage. I assume that the parents actually are the parents. I assume that the information on a census record is correct until I have conflicting evidence at which time I will reconcile the conflicting evidence.

With census records specifically I can adjust the date range to incorporate all of the census records I have. You do this all the time when you are working with the 1800-1840 census. (1790 doesn't give a tight date range so it isn't as helpful). When you correlate the date ranges you come up with across several census records you can narrow the date of birth quite a bit, again, you assume that the information is correct until other evidence comes in that conflicts and then you have to address it.

There are many variables to consider and you always have to keep these scenarios in the back of your mind but you have to start somewhere.

 

Copyright © 2015 Michele Simmons Lewis

 

Wednesday, June 10, 2015

Something so simple

Let’s say you are looking at a census record, an obituary, or anything that might record someone’s age as opposed to their date of birth.  For example,

1850 US Federal Census, Columbia County, Georgia
Mortimer Snerd, male, age 48, farmer, born in Georgia

How would you record Mortimer’s date of birth?  Most people would simply put “About 1802” but is that the most accurate way to record it?

If Mortimer was born before the census date then he was born in 1802.  If he was born after the census date then he was born in 1801.  A more accurate way of recording his date of birth is 1801-1802. 

This is one of those OCD things.

 

Copyright © 2015 Michele Simmons Lewis

Monday, June 8, 2015

When an interview is your best evidence

In this case it isn’t an interview I conducted but rather one that was conducted in 1802. I am documenting the lives of three men, Rev. Daniel Marshall, his son Rev. Abraham Marshall, and Abraham’s son Rev. Jabez Marshall, three generations of Baptist preachers. The patriarch, Rev. Daniel Marshall, founded Kiokee Baptist Church in Columbia County, Georgia which is the oldest Baptist church in the state.  It happens to be four miles from my house.  I am not related to this family.  The reason I am interested, aside from the historic significance of this story, is that there is a lot of information out there about the Marshalls on the internet, in books, in magazines, and in church periodicals. The problem is that none of the published information (at least none that I could find) was sourced properly. I want to go back and reconstruct the family the right way.

The family starts in Connecticut.  I have all of the births and marriages I need from the wonderful town records they kept up there.  Once the family gets to Georgia I am good to go because the Richmond and Columbia County records are almost 100% intact (Columbia was formed from Richmond in 1790).  My problem is the time between when they left Connecticut and arrived in Georgia. 

The Marshalls were missionaries.  The preached to the Indians in remote locations.  No records were generated in these areas.  Some of Abrahams younger children were born on the trip down to the south.  Trying to piece together this time period, about 1744 to about 1770, is difficult. The family did make a stop in a populated area of Virginia and in South Carolina on the way down which does give me two more records reference points but I am still missing a lot of time and details.

The answer I needed was printed in the Georgia Analytical Register (a Baptist publication) in 1802.1 Rev. Abraham Marshall dictated a biographical sketch of his father Daniel to the editor of the GAR.  It is written in the first person.  Though it starts with Daniel’s birth in Connecticut much of the story is primary evidence as Abraham was an active participant.  I still consider his testimony of the events prior to him being old enough to have first hand knowledge as fairly accurate because he never left his father’s side until his father’s death.  This information is secondary but he would have heard the accounts over and over and over again from his father. The stories could certainly have been embellished a bit but the timeline is what I was more concerned with.


1 Henry Holcomb, editor, "Biography of the late Rev. Daniel Marshall, communicated to the editor by the Rev. Abraham Marshall," The Georgia Analytical Repository 1 (May-June 1802): 23-30; Georgia Regents University Library, microfilm 3578.

 

Copyright © 2015 Michele Simmons Lewis

Friday, June 5, 2015

My new digs

My daughter Kelly got married in May and moved out. I immediately took possession of her vacated room to turn it into my new office. I have never had a real office. I have always either been in a corner of my bedroom or in the family room. That’s what happens when you have a houseful of kids. 

You can see my old office space HERE. This was actually two spaces ago. This is when I was in the bedroom but I moved to the family room sometime after that. If you are on Facebook, you can see my space in the family room HERE. Even if you don’t have Facebook you can try the link. Who knows, you still might be able to see it.  

My new office has a fresh coat of paint, crown molding installed and a new ceiling fan. I moved my two big bookcases in and I bought a new, larger desk. I also brought in a little antique table I found at an estate sale about a year ago to hold my printer. The shredder sits underneath. I have a TV in here which is nice. I moved in three plants (love living in a jungle). The best part of moving is it forced me to go through everything I have and I got rid of a lot of junk. The not so best part is when I went through everything I ended up making a lengthy to-do list of things I need to tackle. 

I started working in here on Monday. I have a door that I can close which means I can use Dragon Naturally Speaking without my kids laughing hysterically. I can have the news on the TV going in the background too (I am a news junkie). 

So why no pictures of my new digs? The one thing I want to do before I let you see it is get some stuff on the walls. I can’t stand having bare walls. I also need to sew some curtains but I might let you see it before then. I am just having a hard time figuring out what I want to put on the walls and where. I have a large map of Germany, a couple of old pictures, and some of my daughter’s oil paintings that will make the cut. I want to get a wall clock.  Even though I have the time on my wristwatch, my telephone and my computer I still prefer just glancing up at the wall. I am also considering a bulletin board and maybe a white board. In the above two photos you can see that I was using the blinds as a bulletin board.  My desk isn’t under a window now so that is why I am thinking about a bulletin board in front of my desk.

I will be doing a lot of work in here this weekend.  I might try to get you a picture sometime next week.

 

Copyright © 2015 Michele Simmons Lewis

Wednesday, June 3, 2015

Another cool Excel trick, well two

I stumbled on this one quite by accident.  I like to have my dates completely written out like this:  14 February 1862.  Excel does not allow you to format dates this way, well, it won’t let you if you happen to be in the United States. If you change your location to English (United Kingdom) you can format your dates this way.

DATE 1

 

Another thing I stumbled on.  If you have been using Excel for any length of time you will know that it doesn’t like pre 1901 dates.  You have to format the cells containing dates as Text instead of dates.  I noticed that when I imported a CSV file that I created in Legacy that my pre 1901 dates were intact, they were being treated like text because Excel didn’t recognize them as dates.  A further clue that Excel didn’t recognize them as dates is that they were justified left.  So far so good.  However, the post 1900 dates were imported with two digit years (because of the US setting) and they were justified right (made them easy to spot).  I was able to fix all the dates so that they were uniform and correct.  I want to thank my coworker Sherry from Legacy Family Tree for helping me test this and figure out the solution. 

1) Import the data (CSV file)
2) Change to the English (United Kingdom) date formats and choose DDMMYYYY format*
3) Justify the column to the left (or right) to line all the dates up

* You will need to change to whatever format your imported dates are in.  You will not be able to globally change these to another format because all of the pre 1901 dates are not being seen as dates.  I chose the format that was imported from a Legacy CSV file which is full dates.  If I had my dates entered in Legacy as 15 Jan 1900 then I would have to use that format.

BEFORE

DATE 2

 

AFTER

DATE 3

 

NOTE: You will not be able to sort by the date column.  Excel will only see the post 1900 dates as dates so anything before 1901 will not sort.  If you need to sort by date you will have to split the year from the rest of the date and then sort by the year column, then by the rest of the date column.  These columns will be treated like simple numbers so they will sort properly.

 

Copyright © 2015 Michele Simmons Lewis

Monday, June 1, 2015

One big happy file

I could have titled this post, “To split or not to split, that is the question.”  A common question that comes in to Legacy is asking how to split a file.  Most people that want to split their file want to have their information in one file and their spouse’s family in another.

Why would you want to do that? It is much easier working with one file for three reasons.

  • You won’t have to switch back and forth between files when you are doing research.  This is especially inconvenient if you are looking at a records set that could contain both families.
  • You won’t have duplication between the files (your spouse and descendants).  If you update one file you will have to go in and update the other one.
  • If there is some sort of link between you and and your spouse sometime in the past it will be much easier for you to recognize that there is a link if everyone is in the same file.  If you find a connection it will take less than five seconds to actually create the link.  If you do find a link between the two families you will then have to put everyone in the same file anyway. Far fetched?  Not really.  There is a good chance that you will find a connection if you go far enough back.  If you look at your file in terms of your children your two families are already linked.

That doesn’t mean that I don’t have more than one file.  I have my main file that has my personal family research in it.  I also have a file for my One-Name Study.  Technically these people are attached to my family tree but it is just easier to deal with this group of people separately because I use different research tactics and I have to look at all of this data in a different way.  I rarely take on clients anymore but when I do their information goes in separate files.  I have several test files because of my work with Legacy but most people won’t have that.

Unless you have one of these special cases you are better off keeping everything in one file.

Copyright © 2015 Michele Simmons Lewis