exporting or importing data.

Billread · Post by **Billread** » 07 Mar 2009 12:33

I think a useful item on the wish list would be the ability to either import from or export to other database. I use several types including excel and Custodian. So if one could select certain individuals from FH and then the Data fields you wish to output, ie Nmae, Date birth, etc and format,or order of data so goes to and from correct fields, then it would save a lot of time in repeat entering of data being used in different programs. Would others find this useful??

If this does exist already, then I have missed how to do it. Many Thanks

ID:3495

RalfofAmber · Post by **RalfofAmber** » 07 Mar 2009 12:50

Can't a query do this? Select the bits you want and save the results to a CSV file?

YouTube · Post by **Jane** » 07 Mar 2009 12:59

Yes you can do all this with queries.

Just set up the data you want and click on the Query options button to save as CSV.

tLeodiensian · Post by **tLeodiensian** » 16 Jan 2010 13:35

Tony and Jane have both answered one half of the question - export. There are also several programs that will convert GEDCOM files to any number of formats.

What about import ?

I'm now in the stage of Family History Research that requires family reconstitution, i.e. I have (probable) cousins, with the same forename, baptising children within a parish or group of parishes, sometimes (i.e. before 1837) with no mother's name to distinguish between families.

To try to solve this I have built a Lotus Approach database and loaded some of my BMD transcriptions from parish registers across four surname variants (about 650 at the moment). I can then sort by date and filter on other criteria to pick out possible families. I'm also thinking of adding Census events to this, but that is another story.

However, once I have a probable family group, I find I am again re-typing them into FH.
FH only seems to allow import of other GEDCOM or FH related files.

PeterR · Post by **PeterR** » 16 Jan 2010 15:06

Have you seen this wiki article: http://www.fhug.org.uk/wiki/doku.php?id ... re:acc2ged? I guess you can easily generate a suitable csv file from your Lotus Approach database. Unfortunately the link for downloading acc2ged.zip appears to be broken, but this one works OK: http://www.wintree.plus.com/acc2ged.zip. There are several other suggestions on this site: http://www.edintone.com/blog/

tLeodiensian · Post by **tLeodiensian** » 16 Jan 2010 21:44

I'd downloaded acc2ged a couple of years ago, when originally deciding to build the Lotus Approach database, but felt that a 10 year old DOS program was not something I wanted to spend time getting to know too closely.

I can cope well with DOS (was the System Administrator at work from 1989 to 1995 - had 'experience' of all MSDOS versions from 3.3 to 6.22), however I'm not a programmer.

I suppose I was hoping that Calico might take up the task, or that there was someone who had written a nice interface that takes all the brain work out of it.

I'm actually now looking a Custodian3, that has had a mention once or twice in these forums.
acc2ged looks to be capable of handling output from Custodian3, as it seems to have separate data output for the different BMD event types, but acc2ged doesn't handle Census entries.

BTW, if you google for 'csv to gedcom' only Oxy-gen (that does the reverse) comes above the FHUG forums - well done Jane.

Family Historian User Group