Commerzbank

[Edward Doolittle]

The error message about not enough columns set most likely means that you
haven't taken all the necessary steps before moving forward with the CSV
import. Unfortunately, the CVS importer can't automatically tell which
column in the CSV file should be mapped to which "column" in GnuCash. It
can make a guess in many cases, but you probably need to tweak it manually.
If you're lucky, that's all you'll have to do.

I tested out the importer on a CSV file downloaded from one of my financial
services sites and even tweaking was not enough. I had to edit the CSV file
to combine two columns If something similar happens to you, you'll have to
find or write a converter. A CSV to QIF converter might work better than
CSV to CSV.

On 7 February 2015 at 16:47, Horea Christian <horea_christian at yahoo.de>
wrote:

> Hi guys, in addition to and completely independently of my present query
> regarding currency quotes, I would like to somehow integrate gnucash and
> my Commerzbank (Heidelberg, vormals Dresdner Bank; for all gnucash
> purposes probably irrelevant) account more automatically.
>
> Currently I am trying to import my transaction list (csv file offered by
> the Commerzbank) into gnucash. The first issue with this is that the
> import wizard does not support dates separated by anything else than
> dashes (seriously?!?), while the Commerzbank formats dates with periods.
> I am able to work around this by editing my files (though I would very
> much welcome a more elegant solution). However, after I do that, the
> gnucash import wizard still fails after I set the separator etc. with a
> fairly nondescript error message stating "The date format could be
> wrong, or there are not enough columns set..." How do I debug this?
>
> My second question would be if hbci would allow me to circumvent this
> manual import (or is that just for issuing transactions?)?
>
> Best,
> Christian
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>



-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI