Getting Legacy master file into a spreadsheet - how?
Tessa, wonderful webinar on Wednesday. I do have a question on "How Did You Do That?" How did you get your Legacy Master file into a spreadsheet? I have been searching Legacy help file...NO help unless I am not searching the correct key terms. A nudge in the correct direction would be extremely appreciated.
Thanks Susan Penn Groover What I did was put my Name Index into a spreadsheet (because I want a record of all my individuals, spouses, RINs and MRINs since I file by name and RIN). When you go through your Name List you can print a report - with options and lines (I think 3) and add whatever information your want. Then you print the report to a csv format. I usually clean it up a bit, but that is the bones of what I do.
ReplyDeleteAnd I find the Help Index a bit daunting as well - they never use the first or second term I think of for searches.
What are you thinking of putting in your spreadsheet - that might be a good discussion for use in the June Webinar! In the meantime, perhaps a short Tuesday's Tip tutorial (I'll add it to the list).
Thanks for asking the question Susan Penn Groover, I was trying to find out how to do that exact same thing and thought I might need to watch the video again in case I missed that bit.
ReplyDeleteThanks for on the spot response, Tessa!
ReplyDeleteLike you I was wanting a "spreadsheet" backup. I was attempting this with Event descriptions before moving to Name List. Anyway...my downfall was inabliity to find "csv" choice and now that I found this option and feel like big dummy; I am off to CVS for headache remedy to my csv dilemma.
I work with spreadsheet "worksheets" before entry into Master database and was wanting to create some "cheat" sheets for Event definitions and Locations plus the Name List using spreadsheets. Thank you so much for the nudge!
Growing up, my parents always told us " no such thing as a dumb question" - and here we are about learning NOT beating ourselves up. I'm glad you found it (I didn't know what a csv format was until I started doing my one-name study). Would love to hear how you put together your spreadsheets - what types of things do you include? I have to admit when I get to several rows, sometimes it is too much information.
ReplyDeleteWhat a wonderful idea for a webinar, "How to print the name list or index to a csv file and what you can include". It would be exciting to learn other's tricks and tips on this subject.
ReplyDeleteTessa, my quote was from college prof. "The only dumb question was the one unasked." Was not beating self up...well maybe a little for the time wasted for looking for something I knew had to be in front of me. Back to spreadsheets...I have a "forms notebook" of templates I have made using spreadsheet. I have a research file on my hard drive. I pull the "template" into my work area when researching. This way I can print it or fill it in. Would be happy to share, I just do not know how or where to upload. And since I am know as "frugal.family.historian" these spreadsheets are made with OpenOffice and am told can be opened by the major ie: Excel, QuattroPro, etc. My interest is family history. My files have been let's just say "scewed" so I am starting a new with self. I have back ups, but my reader is kaput What I trying to convey here, is when I research I have a specific person in mind in a specific location. So on my hard drive in a research file I have a directory of location largest to smallest jurisdiction. I copy the form from my above mentioned notebook and start filling in the blanks for that location. Happy to share with instruction on how to upload..
ReplyDeleteokay - I like your college prof (I had lots who were happy for us to keep our heads down and mouths shut). I would love to see your process in action and think the notebook/template process sounds great.
ReplyDeleteIn order to share in one of our posts (or any other Google+ post), you will need to start a new post. You write your text and You should see several choices - photos, link, video. When you click on one of these choices, Google will ask where you want to take your "thing" from that you plan to share. I usually put a copy of what I want to share on my desktop (so it is easily found).
So if you have some examples of your process or your Legacy program that you want to have a snippet of, take a screenshot (I use Window Snipping Tool - it is an accessory with Windows - also pinned to my task bar) and snip and save to your desktop (to use for posting). Hope that is clear.
Sounds like a good idea to show everyone in LVUG in a Tuesday's Tip - perhaps tomorrow!
Susan, it's also easy to use Google drive to share spreadsheets. You can also convert your sheet to a google sheet and then anyone can use it, even those without excel or OpenOffice. Just store it on drive and share the link with the community.
ReplyDeleteFirst attempt unsuccessful...
ReplyDeleteHardy, sounds simple...but I do not have time for the learning curve today. Sounds like the simpler thing for me is send to my file storage and let who wants it contact me...One more attempt to upload and I will need to get on with my day.
ReplyDeleteSusan, try this out. I wrote it last year and google is notorious for changing things but maybe it'll help. I'm having brunch at my local eatery so that's the best I can do for now. https://docs.google.com/presentation/d/1ltA8pZoksUyMt_EgBQCWEOG75rbJfYQyrOFQf3zcxoU/edit?usp=docslist_api
ReplyDelete