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 742023 - cvs feature request: treat fields as zero when blank
cvs feature request: treat fields as zero when blank
Status: RESOLVED DUPLICATE of bug 721196
Product: GnuCash
Classification: Other
Component: Import - CSV
unspecified
Other Linux
: Normal enhancement
: ---
Assigned To: gnucash-import-maint
gnucash-import-maint
Depends on:
Blocks:
 
 
Reported: 2014-12-27 10:43 UTC by KTP
Modified: 2018-06-29 23:37 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description KTP 2014-12-27 10:43:45 UTC 
This is not a bug, but a "feature" request.  

When I export from my bank, it will not add "zero" to the balancing field, let me explain: 

example csv, 

Date;Description;in;out
2014-12-05;ATM withdrawal;500,00;;
2014-12-04;Expense;240;; <---no zero amount

In this case i have to edit the file and add 0,00, as the importer will fail as it "does not understand the column field "out" or "in", depending on which is blank.  

It would be nice here if the field set as a number field, would be treated as zero automatically if blank, and thus not throwing error on each column.

Thanks,
Comment 1 Bob 2014-12-31 12:04:11 UTC 
Which version of GnuCash are you using as I thought this was fixed.
What column headings are you selecting?
I have tried it on the developer version and it works but I needed to set the currency format.
Comment 2 KTP 2015-01-01 11:33:01 UTC 
Using 2.6.5 ( rev 23d0f79+ on 2014-12-23. ).

Locale is Norwegian (Norsk Bokmål), i select the xxx.xxx,xx format when importing.

The column headings are "Uttak" og "innskudd"  (withdrawal/deposit)
thx
thomas
Comment 3 Bob 2015-01-02 16:01:12 UTC 
I think this is the same as bug 721196 and I think this will be in the 2.6.5a release and later.
Comment 4 Mike Evans 2015-01-11 13:32:54 UTC 
Thanks for the bug report. This particular bug has already been reported into our bug tracking system.  I've re-opened the original bug that describes the same behaviour.  Please make further comments in that bug report.

*** This bug has been marked as a duplicate of bug 721196 ***
Comment 5 John Ralls 2018-06-29 23:37:05 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=742023. Please update any external references or bookmarks.