After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 795666 - Backslash "\" in Description field spoils CSV Import without helpful error message
Backslash "\" in Description field spoils CSV Import without helpful error me...
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Import - CSV
3.0
Other Linux
: Normal normal
: future
Assigned To: gnucash-import-maint
gnucash-import-maint
: 796453 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2018-04-29 15:36 UTC by Michael Wenyon
Modified: 2018-06-30 00:09 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Michael Wenyon 2018-04-29 15:36:01 UTC 
CVS importer on v3.0.1 in Debian Buster failed to import an (AMEX) CVS with a sinlgle '\' (backslash) character in it. Import was OK when character deleted. 

\ was in the Description column

The entire description field as I found it in the CSV was (in my single quotations): 'WINNERS GARAGE WINNERS GARAGE\ - WOODSIDE  NY'
It was the only backslash in three years of Amex CSVs. I don't recall ever having my cursor in that field, so I believe it unlikely I accidentally typed it myself.

LibreOffice Calc (on Linux) and Excel (Mac) opened it without a problem.

The error message appeared as soon as I chose the file in the CSV Importer panel. A pop up window said it could not parse the file.

I believe this should be repeatable by another user.
Comment 1 Geert Janssens 2018-05-05 11:44:43 UTC 
Thanks for your report. This will be fixed for gnucash 3.2

Meanwhile you can work around it by changing the backslash in your csv file
with a double backslash
\ -> \\
Comment 2 Geert Janssens 2018-05-30 10:26:34 UTC 
*** Bug 796453 has been marked as a duplicate of this bug. ***
Comment 3 John Ralls 2018-06-30 00:09:13 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=795666. Please update any external references or bookmarks.