[GNC] Struggling with Export/Import of Accounts

Michael Hendry hendry.michael at gmail.com
Sun Aug 4 06:03:59 EDT 2019


I’m using GC version 3.5 on iMac with OS X High Sierra, set up to use UTF-8 by default.

I’ve created a GC file with accounts for each member of my Rotary club in the form:

Assets:Current Assets:Member:Surname, Forename

and thought I should be able to copy these Accounts to another GC file using "Export Account Tree to CSV” and “Import Accounts from CSV” on the respective files.

After my initial experiments failed, I ran a Google search, and found advice from 2017 that it’s necessary to use a semicolon as a separator, and to use quotes on export.

These adjustments didn’t resolve the problem, which is that an attempt to import fails to get beyond the “Import Account Preview…” phase. The header labels appear in the window, but none of the other content of the file.

I had hoped that I could edit the CSV file to include only the member’s individual accounts, and in due course to create CSV transaction files to speed the chore of adding a set of identical transactions for each member.

Presumably someone out there is using CSV export/import successfully?

Regards,

Michael




More information about the gnucash-user mailing list