Exporting data from a query to CSV file

tLeodiensian · Post by **tLeodiensian** » 24 Jan 2013 21:10

I'm trying to put source data from my FH gedcom file into a csv format file for import into GenQuiry. The query Result Set truncates the Actual Text to around 154 characters. Is this a deliberate limit, a result of the GEDCOM spec or a bug ?

ID:6720

Post by **tatewise** » 24 Jan 2013 21:40

The Result Set truncation is a deliberate limit.

The only workaround I can think of is to write a Plugin to export the required data in CSV file format.

[EDIT in 2016:
A workaround is given in how_to:display_long_text_like_notes|> Display long text such as Notes that also works for Text From Source (TEXT), etc.]

Post by **hsw** » 25 Jan 2013 19:55

Useful to know. It will be a while before I can even think about writing a plugin to generate the required data I'm afraid, but I'll put it on the GenQuiry bug list.

YouTube · Post by **Jane** » 26 Jan 2013 10:30

I don't mind writing it, it's pretty simple, but how does MS Access want newlines, tabs commas quotation marks escaped in a CSV file. Alternately does it have an XML or similar import option.

Do you also want it to export Places etc?

Post by **hsw** » 26 Jan 2013 11:32

Jane, thanks for offering. Access has an XML option which would be the best way to go from a plugin, I think, but I'll need to put a little thought into it. At the moment I use four queries to generate csv files for import, one each for People, Places, Sources and Repositories (and the Places one is pretty ropey as doesn't eliminate duplicates).

YouTube · Post by **Jane** » 28 Jan 2013 12:19

When you know what format you need give me a shout.

If you send me a template file for each record type, I should be able to easily populate it from FH.

Family Historian User Group