Bank statement import error

1

Hi

Can anyone help me to understand why I get this import error:

image
image783×922 118 KB

Program doesn’t give anymore information about error.
I’ve done this 100 times even with large files - had no problems, so I’m confused what could went wrong.
Settings format=import format.

Any ideas?

Thanks

2

What does your first screen shot show?

3

You’re not using US date format. Bank import only works with mm/dd/yyy.

4

What Manager version?
Date format appears to require manual input from Lubos so maybe a risk of regression bugs

Btw
Date format in all places must be consistent

  • Manager
  • import file
  • computer localisation settings
7

that’s not correct

8

excel file where i process data before import.
second - the same file in text editor

9

waht that means? I’ll not be able to import csv myself?

21.8.39

10

This must mean that you already tried setting your excel cell format to “mm/dd/yyy” and it still didn’t work out, right?

11

Manager’s date format dd/mm/yyyy
Excels’s date format dd/mm/yyyy
CSV file format dd/mm/yyyy

I’ve never used US date format and don’t think I have to. I’m in UK and UK format used to work perfectly fine just now something went wrong.
S

12

Don’t take this the wrong way but you’re being stubborn for no reason. :unamused:

I too don’t use the US date format but for bank imports I have too. This is something that’s been bugging a lot of users as well.

I am 99.9% certain that this is the cause of your problem. So please try it before going into futile arguments.

13

I don’t think so. I have been using dd.mm.yy (31.01.20) and it works fine.

14

@Solnce try using this format dd.mm.yy (31.01.20) instead of 31/01/2020 and let see.

15

You’re using an ancient version. (Sorry, I thought 31.01.20 was your version)

This bug have been introduced after that. The developer’s reasoning was that it has something to do with server time or something.

This is a well discussed issue. Please research the forum.

16

I’m on the cloud

17

image
image923×774 28.6 KB

18

Ok guys. My bad :sunglasses:

19

Come on, you are reaching out to help, nothing bad about that.
Maybe @Solnce’s problem is not a date format problem. We shall see.

20

OK, that took a while, but I’ve found it and it has nothing to do with Manager, although from program side error reporting could be verbose.

Initial bank statements were not CSV file, but scanned and OCR processed so in the mid of the file I got few places were
l instead of 1
O instead of 0
and that caused the program to reject entire import process.

Thanks everyone for help.

S

1 Like