[GNC] When importing an account tree from a csv file, account type information disappears
hakon at finne.net
hakon at finne.net
Fri Jan 10 10:16:13 EST 2025
Thanks, Brad, for the Wiki pointer. No, I had not read it. However,
while it says something about importing data from specific banking
formats, the treatment of csv file import seems to be concerned with
transactions only and not account structures. As for my account Type
problem, I think I have solved it and I have circulated the solution on
the list (I did not discover your post until just now). As for importing
transactions, I have discovered that if the csv file is generated by
Excel, it turns out that Excel may add three bytes at the start of the
file. These bytes make up a byte order mark (BOM). This mark is
interpreted by Excel (and other programs) and not visible. When GnuCash
imports a transaction csv file with a BOM, however, this mark is simply
displayed as three characters like any other characters. This blocks the
import of transactions from the file. I solved this by removing the BOM
using a hex editor. This does no seem to happen, however, when GnuCash
imports an account hierarchy written to csv from Excel.
I am running GnuCash 5.10 (Norwegian download) on Windows 11 Enterprise
(British English with localization Norway and bm). Because of the
localization, I use semicolon for list element separator and comma as
the decimal. Obviously these data may be important for diagnosis.
-- HÃ¥kon
Message: 4
Date: Thu, 09 Jan 2025 01:07:10 -0800
From: Brad Morrison <bradmorrison at sonic.net>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] When importing an account tree from a csv file,
account type information disappears
Message-ID: <bc9536cfc004aa74f101dbfced87f903 at sonic.net>
Content-Type: text/plain; charset=UTF-8
Hi Hakon/GnuCash users,
https://wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data - have you
read this section of the GnuCash Wiki on importing and exporting data?
What version of GnuCash are you using? The current version is 5.10 -
https://www.gnucash.org/download.phtml
What operating system are you using?
---
Thanks,
Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison
More information about the gnucash-user
mailing list