Why is the importer turning 25.00000 into 2,500,000?

[jerrac]

My bank exports the csv amount column in number like:

-450.00000
25.00000
0.02000

The import job is turning those numbers into:

-$45,000,000.00
$2,500,000.00
$2,000.00

I initially thought it might be something to do with how some countries use a comma like "1,000" for one thousand, while some use a period like "1.000" for one thousand. (At least I think that's a thing.) But I couldn't find any setting related to that, and I'm not sure how 0.02000 would get parsed into 2,000.00 even if that was the cause...

I couldn't find anyone else having this issue, or I just didn't have the correct search terms.

Any tips on what I might have missed?

Thanks!

Edit:

I dug into my logs and found this:

[2024-01-30 14:36:43] production.DEBUG: Created converter class Amount  
[2024-01-30 14:36:43] production.DEBUG: Start with amount "25.00000"  
[2024-01-30 14:36:43] production.DEBUG: Stripped "25.00000" to "25.00000"  
[2024-01-30 14:36:43] production.DEBUG: Disabled "findFromLeft" because it happens more often that "1.000" is thousand than "1.000" is 1 with three zeroes.  
[2024-01-30 14:36:43] production.DEBUG: No decimal character found. Converted amount from "25.00000" to "2500000".  
[2024-01-30 14:36:43] production.DEBUG: Final NUMERIC value is: "2500000"  
[2024-01-30 14:36:43] production.DEBUG: Stored column #4 with value "2500000" and role "amount" in field "amount"  

So, it's working as designed? Is there a way around that?

FYI, I'm running the fireflyiii/data-importer:version-1.4.2 Docker image.

[JC5]

This is working as designed, but I'll see if I can catch this.

[jerrac]

The Docker image from 2024-01-31 06:20:05 should have the change in it, right? I just tried again on that image and the issue is still there.

[2024-01-31 07:24:10] production.DEBUG: getParsedValue will run "Amount"  
[2024-01-31 07:24:10] production.DEBUG: Created converter class Amount  
[2024-01-31 07:24:10] production.DEBUG: Start with amount "25.00000"  
[2024-01-31 07:24:10] production.DEBUG: Stripped "25.00000" to "25.00000"  
[2024-01-31 07:24:10] production.DEBUG: Disabled "findFromLeft" because it happens more often that "1.000" is thousand than "1.000" is 1 with three zeroes.  
[2024-01-31 07:24:10] production.DEBUG: No decimal character found. Converted amount from "25.00000" to "2500000".  
[2024-01-31 07:24:10] production.DEBUG: Final NUMERIC value is: "2500000"  

[JC5]

No, thats not the latest one. Just pull develop again.

[jerrac]

Er, docker hub has it as the latest with the develop tag. https://hub.docker.com/layers/fireflyiii/data-importer/develop/images/sha256-40e2662279337c0cbd49bf0ee591c0a0f970349a0c53890215a8cc0aa7144c89?context=explore

Would there be a delay between when you push an image, and when it's available so that they can scan for issues?

Anyway, I'll try again in a few hours. Off to work soon.

[JC5]

Not sure. I just ran the latest build again, here. It should report as build nr 521.

https://dev.azure.com/Firefly-III/ImportToolImage/_build/results?buildId=2249&view=results

I was able to pull it myself, but it could be a cache thing.

[jerrac]

Well, I don't have a clue what is going on. I tried logging into docker hub to make sure there wasn't some odd limit thing going on, and I'm still only getting the build I linked above. I even deleted the image entirely and repulled.

On dockerhub, this is what I see: