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 795155 - CSV import does not distinguish between deposit and withdrawal
CSV import does not distinguish between deposit and withdrawal
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Import - CSV
3.0
Other Mac OS
: Normal major
: future
Assigned To: gnucash-import-maint
gnucash-import-maint
Depends on:
Blocks:
 
 
Reported: 2018-04-11 12:34 UTC by Christoph Rohland
Modified: 2018-06-30 00:08 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
test csv file (56 bytes, text/csv)
2018-04-11 12:34 UTC, Christoph Rohland 		Details

Description Christoph Rohland 2018-04-11 12:34:44 UTC 
Created attachment 370788 [details]
test csv file

The new csv transaction importer treats withdrawal and deposit columns the same.

When importing the attached file it will use it as deposits in a bank account independent if I tag the third column deposit or withdrawal. Negative numbers will be withdrawals though.
Comment 1 Geert Janssens 2018-04-11 17:40:02 UTC 
Are you sure? If you tag the third column it should revert the meaning of the numbers.

If the column is tagged "Deposit", positive numbers will be true deposits, negative numbers will be true withdrawals.

If the column is tagged "Withdrawal", positive numbers will be true withdrawals, negative numbers will be true deposits.

Is this not happening for you ?
Comment 2 Christoph Rohland 2018-04-11 19:42:20 UTC 
Yes, I am sure. Stumbled over this in my real file with a credit card account and had the same in my test file in a bank account. Tried multiple times. All the same...
Comment 3 Tae Won Ha 2018-04-14 09:46:38 UTC 
This also happens to me:

macOS 10.13.4
Gnucash 3.0

If I import the following line

2018-01-01; some description; 10; 20

with the column setting "Date; Description; Deposit; Withdrawl", Gnucash treats both Deposit and Withdrawl columns as Deposit.
Comment 4 Geert Janssens 2018-04-14 10:44:35 UTC 
I can confirm now that I actually have time to run gnucash myself.

The fix was trivial and will appear in gnucash 3.1 (still to be released).

Thanks for your report!
Comment 5 Tae Won Ha 2018-04-14 18:02:13 UTC 
I don't know how many people use the CSV import feature, but would it be possible to release a bugfix version earlier than 2018-05-13 for 3.1?
Comment 6 John Ralls 2018-04-14 21:07:58 UTC 
Depends on how much progress we make on the other bugs.
Comment 7 John Ralls 2018-06-30 00:08:02 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=795155. Please update any external references or bookmarks.