I *did* provide a "well-detailed example", as shown in my post copied
below (one line with header info, one line of data). But apparently no
one looked at it to the point of finding my somewhat obvious error (not
complaining, I realize this is a volunteer resource).
So, the other thing I did was put it aside for a few days and take
another look with fresh eyes. And the problem was simply that I omitted
the column for "Account Code", even though it was present in my first
successful import file. Not sure why I missed it in the second file,
perhaps because (so far) I'm not using account codes for bottom-level
accounts. In the process of massaging the QB export data for input, I
must have just accidentally deleted or over-wrote the Code column.
On 2023-01-19 22:42, David Carlson wrote:
Mark,
The Help manual chapter 6 gives a good starting point to configuring a
successful CSV transaction import. However, it does not describe
importing accounts.
GnuCash is supposed to be able to import anything that it can export,
so if you try to find an existing account tree example in a test file,
possibly created by the Gnucash account setup wizard, you can try
exporting it to see what might work in the import direction. If you
have tried that and it still fails, you should at least have a well
detailed example to use when you return to ask this group for
additional help.
Is there documentation somewhere as to allowed characters, field
lengths, etc for CSV import of accounts?
Here is an example of an import file that fails for me. The top
level
and sub-accounts exist. Why won't it import successfully?
Type,Full Account Name,Account Name,Description,Account
Color,Notes,Symbol,Namespace,Hidden,Tax Info,Placeholder
ASSET,Current Assets:Other Current Assets:Ibond,Ibond,Treasury
Direct,,,USD,CURRENCY,F,F,F
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
