GNOME Bugzilla – Bug 611014
CSV import crashes
Last modified: 2018-06-29 22:35:31 UTC
Created attachment 154629 [details] CSV file CSV import always crashes. How to reproduce: - Create default set of empty accounts - Select File | Import | Import CSV/Fixed-Width - Select the attached file "siirto3.csv" - Check tab-separator and uncheck comma - Set the 1st field as description, 2nd as deposit, 3rd as withdrawal, 4th as date (see attachment "import_dialog.png") - Click OK - Select eg. Assets | Current assets | Savings account as the account At this point, depending on which field you clicked last, the field header MAY HAVE BEEN cleared (attachment "error1.png"). - To go around this error, set the fields as described above and after that, select eg. d-m-y date format and then again y-m-d. This is silly. - Click Ok. - BOOM! It also crashed once when I just tried to set the fields (the date field, to be precise). Note: To use the attached CSV file, you may need to set your default language to Finnish or some other (European) language in which comma is used as decimal separator - or just change the commas to periods in the file...
Created attachment 154630 [details] Error in csv import dialog
Created attachment 154631 [details] CSV import dialog
Even though I haven't tried this example myself, I have seen plenty of crashes in the CSV importer before. Unfortunately this feature is only half-finished and we probably have to disable it for the 2.4.0 stable release. Sorry for that.
I tried this on linux - changed ',' to '.' in the csv file, and was able to import with no problem. What platform are you running?
(In reply to comment #4) > I tried this on linux - changed ',' to '.' in the csv file, and was able to > import with no problem. What platform are you running? Windows Vista x86_64.
Regarding the issue that sometimes the last column type switches back to "None", there seems to be a difference between linux and windows in how combo boxes are handled. On linux, selecting an item from the dropdown is sufficient. On windows, you need to select an item from the dropdown and then select something else in order for the new type to really register.
r18911 addresses the problem where the "Date" column is lost.
I can import the attached file correctly (2.3.15 on Linux) and without any crash. This is in de_DE locale, i.e. with the comma as decimal separator. I followed the advice from above and no crash occurred, and also the date format didn't behave in any unexpected way. Still a problem with 2.3.15?
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for. Thanks!
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=611014. Please update any external references or bookmarks.