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

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Lance Lund
I have been trying to import a CVS file of credit card transactions and when I get to the step of picking the column headers the mouse will not activate the pull-down menus for the available headings.  Once this happens I can go no further.  Lance
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

David Carlson-4
On Fri, Feb 1, 2019 at 1:14 PM Lance Lund <[hidden email]> wrote:

> I have been trying to import a CVS file of credit card transactions and
> when I get to the step of picking the column headers the mouse will not
> activate the pull-down menus for the available headings.  Once this happens
> I can go no further.  Lance
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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.
>

Lance,
It is very common for some financial institutions to be very confused about
the format for CSV files, not realizing that the C stands for Comma.  Many
use TABs or other separators.  That is the reason for all the choices in
the CSV importer definition page.  Either check the file with a text editor
or, easier, play with the separator choice buttons until each field has
it's own title section.  Then you will be able to select each field
separately.

David Carlson
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

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

David Cousens
In reply to this post by Lance Lund
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
[hidden email]
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.
David Cousens
Reply | Threaded
Open this post in threaded view
|

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

Lance Lund
In reply to this post by Lance Lund
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
[image1.jpeg]

[image2.jpeg]
Sent from my iPhone

On Feb 1, 2019, at 6:35 PM, David Cousens <[hidden email]<mailto:[hidden email]>> 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
[hidden email]<mailto:[hidden email]>
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.

_______________________________________________
gnucash-user mailing list
[hidden email]
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.

image1.jpeg (7M) Download Attachment
image2.jpeg (4M) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [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 [hidden email] 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 <[hidden email]> 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
> > [hidden email]
> > 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.

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
David Cousens