Search found 2145 matches
- 13 Feb 2018 22:18
- Forum: General Usage
- Topic: Regular Expressions and Lua Patterns
- Replies: 10
- Views: 7412
Re: Regular Expressions and Lua Patterns
Thanks Mike for the clear explanation. I'd been playing around with sets, but didn't get the syntax quite right! One criticism I would make of much of the patterns material I have read recently is that it gets too complicated too quickly. Lots of practice with simpler examples like this first! My fi...
- 13 Feb 2018 10:53
- Forum: General Usage
- Topic: Regular Expressions and Lua Patterns
- Replies: 10
- Views: 7412
Re: Regular Expressions and Lua Patterns
Thanks Mike, it was a few days before I was able to sit down and have a go at this, but it turned out to be quite a good first learning example! I've now got a simple script that updates most of my media records perfectly, but fails where the title is more complex. For a general media title, "Event ...
- 03 Feb 2018 18:22
- Forum: General Usage
- Topic: Regular Expressions and Lua Patterns
- Replies: 10
- Views: 7412
Re: Regular Expressions and Lua Patterns
This is timely, as I was looking at Lua for updating my media records. I have a large number of undated media records (images of source records) imported from FTM , and I want to add dates to aid reporting and sorting. My media titles are very structured, so I was thinking of two different scenarios...
- 15 Dec 2017 10:19
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
This is quite an old thread now that has probably run its course, but for completion I include below my final crib sheet for my FTM - FH migration. It is slightly high level rather than detailed "how to" instructions, and parts will be specific to my recording style and use of Excel as a GEDCOM proc...
- 20 Nov 2017 10:18
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
One final refinement - I have split out the source splitting and general format tidying into two separate workbooks, as they perform different functions and the latter is purely optional (a neat and tidy import to FH rather than hundreds of comments in the log files). The source splitting is now com...
- 16 Nov 2017 14:14
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Indeed - as somebody who's only a couple of pages ahead of you, my impression so far is that FH is strong on GEDCOM compliance, flexibility and transparency of its data structure, but that adherence to GEDCOM comes at a cost, as GEDCOM is not a proper database language so does not handle duplication...
- 16 Nov 2017 09:42
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Thanks Mike - I was aware of the All tab of course, as it is clear on screen and frequently referred to in the documentation, but I still don't like the fact that the summary shows one note without alerting the user to the extra detail available there, and doesn't refresh after editing. So it is not...
- 15 Nov 2017 23:29
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
PS - In principle, it should be possible to generalise the code, such that it reads the input GEDCOM file, presents the user with a list of all the lumped source titles (GRO Birth, Probate Calendar, etc), and asks which ones should be split. Food for thought later......
- 15 Nov 2017 23:13
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Hi David, Unfortunately, Excel macro code only works in "proper" versions of Excel, so not Open Office, not LibreOffice, and even not Excel for the iPad!! I've been away from this project for a few days as I've been busy with other things, but before I fully commit my data to FH and regard that as t...
- 05 Nov 2017 16:44
- Forum: Research
- Topic: Rethink of Sources and how to use them.
- Replies: 9
- Views: 7644
Re: Rethink of Sources and how to use them.
Indeed - in the absence of more precise data, my entered birth date is usually just a "best guess", and always qualified by "about". Death is generally the month of burial (unless very early in the month), and again always qualified with "about". I started out leaving both of these blank if I didn't...
- 04 Nov 2017 22:31
- Forum: Research
- Topic: Rethink of Sources and how to use them.
- Replies: 9
- Views: 7644
Re: Rethink of Sources and how to use them.
A related thought - for direct ancestors a certificate is essential, but for more distant relationships I do cite the index entry to support an Event, particularly if there are other corroborating data. My problem is how to record the Event date. For marriages, there is no issue as the event is reco...
- 04 Nov 2017 18:12
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Sorry, was being slightly lazy, as I was doing the Forum on the iPad and couldn't remember what the plug-in was called :) . I was thinking of List All Citations for a Source . If there were hundreds of entries to check, it might be useful to flag where Where Within Source is the same, but Text From ...
- 04 Nov 2017 14:45
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
I understand what is happening now. It's mentioned in the Knowledge Base, but worth highlighting as it is a fundamental difference compared with FTM that could trip up the unwary migrant (me, for instance :) ). When any citation from a lumped source is used in more than one "Fact", each citation is,...
- 04 Nov 2017 13:55
- Forum: General Usage
- Topic: FH 6.2.5 crashing problem
- Replies: 17
- Views: 12384
Re: FH 6.2.5 crashing problem
Worth commenting that I've been experiencing similar issues using Microsoft's OneDrive recently (albeit not in FH yet). There's probably a general "beware" message there regarding real-time synced backups that are dependent on an external network connection.
- 03 Nov 2017 11:12
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
It did raise a more fundamental question in my mind about how FH manages sources, but I'll do some experimenting over the weekend to explore. If necessary, I'll start a new thread in the general FH use bucket, as it is not specific to importing or macros...
- 03 Nov 2017 01:07
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Mike, Thanks for the detailed comments. It wasn't my intention to produce a universal script that would be useful across many different record keeping conventions, but really just to tidy up my own data prior to importing into FH . I suspect that for the experienced plug-in author, that would be the...
- 01 Nov 2017 09:36
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Helen, Yes, images came across fine. A typical entry is shown below: As exported from FTM as a lumped source: 1 CENS Retired Policeman, age 62 2 DATE 31 MAR 1901 2 PLAC Walpole St Peter, Norfolk, England 2 SOUR @S7@ 3 PAGE RG13/1557 folio 22 p1 (#1) 3 DATA 4 TEXT Appleton Croft, Walpole St Peter, NF...
- 31 Oct 2017 23:55
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Re: Using Excel VBA to convert from lumped to split sources
Thanks for the quick reply, Mike. Indeed, plug-ins and the transparency of the data storage in standard(ish) GEDCOM were two big pulls towards FH. I wanted to give FH as clean a dataset as possible in order to minimise dead time from reworking old data, and concentrate on playing with the fun new to...
- 31 Oct 2017 23:40
- Forum: General Usage
- Topic: Abbreviated place names
- Replies: 2
- Views: 3274
Abbreviated place names
Full place names (e.g. Wolverhampton, Staffordshire, England) are great for removing ambiguity in external connections such as Ancestry/FMP hints, but they get a bit tedious seeing them repeatedly in printed trees and reports (as well as taking up a lot of space!). Family Tree Maker had an option to...
- 31 Oct 2017 23:08
- Forum: Importing
- Topic: Using Excel VBA to convert from lumped to split sources
- Replies: 26
- Views: 15946
Using Excel VBA to convert from lumped to split sources
Having just migrated to FH from Family Tree Maker as a result of recent changes with the latter, I was faced with having to change around 700 or so detailed census records from the “source lumping” that is at the heart of the way FTM is structured (and generally does a pretty good job with) to “sour...