[GNC] Struggling with Export/Import of Accounts

[Adrien Monteleone]

I’ve had no issue exporting and importing an account tree myself.

I see you’re using a comma as part of an account name. While changing the separator and using quotes should work, I try to avoid commas in CSV data as a rule.

Try using something else like `-` (hyphen), `–` (en dash), `—` (em dash), `~` (tilde), or `_` (underscore) and see if that works without quotes and with the standard comma separator or CamelCase the names if that isn’t an eye sore for you.

Note, I’d suspect a bug, but maybe there is a good reason why it failed. Hopefully someone more familiar with the importer’s quirks will chime in.

Regards,
Adrien

> On Aug 4, 2019, at 5:03 AM, Michael Hendry <hendry.michael at gmail.com> wrote:
> 
> 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