[GNC] Importing Data
Chris Miller
cjm at tryx.org
Sun Sep 22 09:49:22 EDT 2024
Hi David,
> The CSV importer can also work with tab separated data. There is a
> setup screen in which you can set the separator so there is no need to
> change it.
Yes. There was an option to change the separator, but "tab" was not one of the choices. See the dialog below.
> The confusion may be that there are two import processes The "File ==>
> Import ==> Accounts" process imports an account tree structure that has
> been exported from either GnuCash or another program or just built up
> in a spreadshett.
Yes. Exactly. Among the differences is the rigidity of column headers. They seem to be defined, meaning I'm going to have to hack my accounts.IIF, and now, apparently, not only to satisfy field separators.
Here is the "Account" process:
So, I need to find the docs to tell me what these fields mean, and I'm going to have to hack my IIF to correct the separator and order of fields, at a minimum. It would probably be easiest to do that with a spreadsheet, but I'm still going to need those field explanations ... Any thoughts?
> I am not familiar with the IIF format
I'm pretty sure it is simply a special case of the CSV, meaning a special set of columns.
Thanks for the help,
--
Chris.
More information about the gnucash-user
mailing list