Import CSV negative withdrawals come in as zero

General discussion on all other topics under the sun.

Moderator: Renato

jimmerydad
New User
Posts: 3
Joined: Thu Apr 22, 2021 1:22 am
Are you a spam bot?: No

Import CSV negative withdrawals come in as zero

Post by jimmerydad »

Hello,
I just upgraded from 1.3.6 to 1.5.0 on Ubuntu 20.10. I noticed a problem that did not occur in previous version.
My csv file contains 2 columns: one for withdrawals and one for deposits. When importing I have my setup (as I did in previous version as shown below)

Import Screen:
ExportWindowWithNegativeWithdrawal.png

After the import completes all the withdrawals are zero. (The deposits are positive and appear)

Withdrawals Zero:
negativewithdrawalsimportaszero-1.png
Here is a sample csv file.
ExampleNegativeExport2.csv
I have a workaround to find and replace all minus signs, but would like to submit this for investigation.

Thank you.
You do not have the required permissions to view the files attached to this post.
MartinArmstrong
MVP User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Import CSV negative withdrawals come in as zero

Post by MartinArmstrong »

Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Import CSV negative withdrawals come in as zero

Post by Nikolay »

jimmerydad
New User
Posts: 3
Joined: Thu Apr 22, 2021 1:22 am
Are you a spam bot?: No

Re: Import CSV negative withdrawals come in as zero

Post by jimmerydad »

Sorry for the late reply, the update in 1.5.1 worked.
Thank you

(Ran into issue with 1.5.2 , but see that 1.5.3 is out, haven't installed that yet)