Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - webmayo

Pages: [1]
1
Family History Programs, Tree Organisation, Presentation / Re: GEDCOM to XLS conversion
« on: Wednesday 16 April 14 14:18 BST (UK)  »
Did this project go through to completion?
I would be interested to know what the results were of testing the gedcoms supplied by members.

I am the author of GenScriber. I have recently included a gedcom import/export. Like Mark, I am in a position of not having gedcom files from various applications to test. It would be good to know which tags are most used.

I ended up just adding the tags I had in my own gedcoms.

L

2
Technical Help / Re: Excel help needed
« on: Tuesday 11 March 14 08:52 GMT (UK)  »
Quote from: Cancan on Tuesday 24 December 13 22:39 GMT (UK)
Hi,

Great News!!!

It has worked!!!  Have lost a few hundred names but at least that is a small amount to what I could have lost!! 

Lesson learned to double check that ALL columns are highlighted!!!

Learned something new, as did not know I could 'restore'

Thank You! Thank You! Thank You!!

Cancan  :D ;D :D ;D :D ;D
Can I just say something about the 'restore'. It's not actually a restore. It is a drop back.

When you run 'restore' you actually lose everything you did after the time you go back to.
That includes any emails, images, docs, applications etc. Anything you created after the 'restore' date.

It may have helped you recover most of your spreadsheet, but you may have lost more without knowing it.
Immediately after the restore, back up your spreadsheet and move forward again.


3
Technical Help / Re: Excel help needed
« on: Friday 07 March 14 19:11 GMT (UK)  »
The problem you had with the sort is just one of many ways a spreadsheet can destroy your data.
There is a free application called GenScriber that is made specifically for transcribing genealogy records.
It is designed to not do the bad things that spreadsheets do. Give it a try.
http://genscriber.com

Now that I have used genscriber, I would never use a spreadsheet for genealogy data.

4
Family History Programs, Tree Organisation, Presentation / Re: Spreadsheets help track Surnames
« on: Thursday 05 September 13 10:39 BST (UK)  »
Quote from: downside on Monday 19 May 08 23:48 BST (UK)
Organising your data by having separate workbooks for births, marriages and deaths is also fraught with difficulty.

What are these difficulties? I can't think of any. Could you please amplify.
I have multiple files (hundreds) and see no problems.

5
Family History Programs, Tree Organisation, Presentation / Re: Spreadsheets help track Surnames
« on: Thursday 05 September 13 09:49 BST (UK)  »
I agree that a database is the way to go for large amounts of data, but for most average users it is too complicated.
I am a retired software developer. Over the years I found that my clients preferred simple applications. The only way a database was acceptable was if I created a bespoke application that required nothing more than entering data into a form. For most people, using 'Access' is over complicated and overkill.

Even though I have developed many different database applications in the past, I don't bother to use one for storing this kind of data. I store everything in csv files. I can easily import that into a database if I every need to.

All my data is entered through 'GenScriber' (I fell out with spreadsheets a long time ago).
The csv files that GenScriber creates are organised in folders. Each file is of a reasonable size. They is no need to try and cram everything into a single file.

To retrieve records I use a simple application called 'CsvFileSearch'. It searches through multiple csv files and retrieves individual records.

L

Pages: [1]