Created attachment 372545 [details] View of the CSV importer Probably a really dumb question, but I've been struggling with it for about 30 minutes. It's stupid. The interface for importing a CSV file says I need to select a column for date, description, and deposit/withdrawal (circled red in attachment). However, I can't for the life of me figure out how on earth I'm supposed to select the column. I can't move on to any other steps either (Next button is greyed out, circled blue). Even better, there's no documentation on it. Like I said, this is stupid. Fix it.
It looks to me from the image that there might be two things... 1, the list has been scrolled down and so the column headers are missing at the top indicated by the dotted line. 2, You will need to skip the first line as it looks like the csv file has a header in it.
To state it explicitly: you select columns by clicking on the column headers (currently not visible in your screenshot). That will open a dropdown list in which you can select the column type. There is a known issue that the column headers are sometimes not click-able until at least one of the other options is changed. So change for example the date format to d-m-y and then back to m-d-y and try to set columns again.
Thanks for the pointers. I can now choose the column headers. Now I can see how I ran into the issue. The area where you click to select the headers A) Is the same color as the main window text and B) Doesn't have the column lines extending up to it. If either were in place (option B being the most preferable), I probably wouldn't have had an issue. I've attached a new image below. Thanks for your help! Let me know if there's anything else I can do! https://imgur.com/PCwgdsV
Created attachment 372562 [details] Illustration of misleading column headers in csv import
Note I have added the image you posted on imgur directly to this bug. I don't think images stay long on imgur. As for the content of this image: it looks like this is a theme issue on your PC. On my system the column headers are white with text and column separators in grey. That is on Fedora 27 with default gtk theme. I currently don't have access to a Windows system so I can't check how it looks there. Did you install a custom theme for gnucash ?
Sorry for the long wait. Been on vacation trying to plow through emails right now. Thanks for adding the screen shot to the issue. I wasn't quite sure how to do that (I think. It's been awhile and I haven't used bugzilla before). I haven't installed a custom theme for GNUCash. I'm also running the default theme for Windows as well. Let me know if there's anything else I can do.
Which is pretty odd. Unfortunately I don't have a Windows test system available for some time so I'm not in a position to debug this further. I'm glad you have a workaround for now. Just to complete the information: what version of Windows are you running ?
I'm running Windows 10 right now. Specifically: Version 1709 (OS Build 16299.492)
On Mac OS 10:13:5 I am unable to add 1 leading lines to skip. It goes from 0 to 2. I am unable to assign other column headings apart from Date. This is on GnuCash build Build ID: 3.2+ (2018-06-24)
(In reply to markgtrosenthal from comment #9) > On Mac OS 10:13:5 I am unable to add 1 leading lines to skip. It goes from 0 > to 2. I am unable to assign other column headings apart from Date. > > This is on GnuCash build Build ID: 3.2+ (2018-06-24) The only thing that's common between your problem and this bug is that they're both about the csv importer. Please open a new bug.
Changing summary to be more descriptive.
There are 3 changes I see now in Windows 10 GnuCash 3.10 (with no theme) that make it more obvious where the column headers are: 1) A down arrow to the right of the column header text for each column 2) The column header text is also lighter than the data text 3) Instead of being blank, the initial value of each header text is 'None'. The column separator lines do extend into the header but they are difficult to see. I'll have a look at the code to see if there are some css id's that can be used to make the header more obvious.
From the GTK Inspector, it seems it is not possible to use CSS to further differentiate the column headings without modifying the program to add unique css styles (if that is the right word) to the treeview header. I'll close this now. Please test in the latest stable version 3.10. If you still think the header is not easily distinguishable, please raise a new bug (type Enhancement) requesting unique css styles be added to the Header and Data cells.
Unfortunately I don't use Windows anymore, so I'm unable to test 3.10 to see if the issues fixed.
