[GNC] Unable to pick date/description/credit or debit column headers

[David Cousens]

Lance,

Reply, Reply to List or Reply to All will likely be buttons or menu items in your email client. 

Your mail is going to the list. You will see gnucash-user at gnucash.org either in the To or CC or BCC fields for the
message when you send it which indicates a reply to the list.

The CSV import for V3.3 works OK on Linux so it may be a MacOS specific problem. The following threads have some
discussion of v3.3 problems on the MacOS which might give you some clues:
http://gnucash.1415818.n4.nabble.com/GNC-GNC-3-3-CSV-Importer-Freezing-on-MacOS-td4704858.html

particularly the info about date formats and conversion of the CSV to a QIF format file. (see 
https://download.cnet.com/CSV2QIF-Convert/3000-2066_4-75788670.html for a converter, unfortunately not free although you
can try it for free but not save the file).

There is little documentation for the CSV importer at the moment. I import single line data under Linux (without a
transfer account specified for the second split) without any problem once I get the right association of columns. IOf
you can get Date Description and Deposit columns assigned it can usually work with that. 

I started to write a section for the Tutorial and Concepts Guide some time ago but it needs a lot more work and
exploration of various options. This is underway but probably won't be in the docs until a later version. The importer
does seem to have some problems with importing multi-split transactions.  I have to get back to testing this out
systematically so the developers can identify/fix specific problems. 

I would also try the various separator options in the CSV importer first. One of the other users who operates on a Mac
using Mojave might be persuaded to try a CSV import to see if it is a general problem. Your image of the window only
showed a part of it and it was unclear whether the importer was detecting multiple columns.

David Cousens


On Sun, 2019-02-03 at 17:03 +0000, Lance Lund wrote:
> I’m using Gnucash v 3.3 build 3.3+(2018-09-29) on an iMac with v 10.14.2 Mojave. 
> I’m trying to import transactions from a credit card account using a csv file from the credit card account. I’ve
> checked the file with a text editor and it is truly a csv file. When I get to the step where I need to select a column
> and define the heading the mouse picks a row not a column. See attached photos. 
> I’ve tried typing “reply-all” in the cc and the mail bombs. I’m not sure how to do this properly. 
> Lance
> 
> 
> 
> Sent from my iPhone
> 
> On Feb 1, 2019, at 6:35 PM, David Cousens <davidcousens at bigpond.com> wrote:
> 
> > Lance
> > 
> > What version of GnuCash on what OS?  The selection of column headers works
> > fine in V3.4 on Linux MInt/Ubuntu 18.04 and I have used it in V3.1-3.3 as
> > well.
> > 
> > Are you seeing multiple columns in the Import preview window or only one? If
> > it is only one try setting some of the other separators (space tab etc) to
> > see what effect that has. Make sure multisplit (multiple lines per
> > transaction ) or fixed width are not selected unless you are really sure you
> > should be using them.  Also don't use the GnuCash Export Format Settings
> > unless the data has been exported previously from GnuCash using that format.
> > Even in these cases I can still select the headers though)
> > 
> > The only way I can disrupt it is to disable the separator used in the file,
> > but even then the header for the single input column can be selected.
> > 
> > Have you tried opening the CSV file in Excel or LibreOffice Calc? This may
> > help diagnose problems.
> > 
> > David Cousens
> > 
> > 
> > 
> > -----
> > David Cousens
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.