libofx: Error importing Ofx file: incorrect dates

[Tiberio Melo]

When I import an ofx file the transaction dates in all of them are 1969-12-31.
View an excerpt from the ofx file with a transaction:
...
  <STMTTRN>
    <TRNTYPE>DEBIT
    <DTPOSTED>20200406000000[-03:EST]
    <TRNAMT>-31.16
    <FITID>N102C0:06/04/20:-914.16:0002579: Visa Electron: Supermercado
    <CHECKNUM>0002579
    <MEMO>Visa Electron Supermercado
  </STMTTRN>
...
I'm using:
----
OS Type : Gnu/Linux, distribution Ubuntu 20.04
HomeBank version: 5.4.2
GTK version : 3.24.18
Libofx : libofx7:amd64, :0.9.15-3build1
----

[Maxime DOYEN (mdoyen)]

please try ofxdump <yourfile>
if you have the same result, then it is a libofx problem

[Tiberio Melo (tiberio-melo)]

Folling ofxdump file. Error persist after install ofx package ('sudo apt-get install ofx').

[Maxime DOYEN (mdoyen)]

ok, then you can open a bug @libofx project.
there is nothing I can do to fix this.

[Tiberio Melo (tiberio-melo)]

Thanks for the guidance. I will open the bug on @libofx project. Do I have to do anything with this bug? Close it?

[Maxime DOYEN (mdoyen)]

yes

[cascagrossa (cascagrossa-cascao)]

Maxime, that is happening only for dates after 2020.09, before that date all went ok.
I am sure this bug will affect all homebank users, so I think you should fire a bug on @libfox project too, or assign yourself as affected.

[Maxime DOYEN (mdoyen)]

filled an ofxbug:

https://github.com/libofx/libofx/issues/39

[Tiberio Melo (tiberio-melo)]

 Thanks to copy me.
     Em sábado, 6 de fevereiro de 2021 07:55:44 GMT-3, Maxime DOYEN <email address hidden> escreveu:

 filled an ofxbug:

https://github.com/libofx/libofx/issues/39

** Bug watch added: github.com/libofx/libofx/issues #39
  https://github.com/libofx/libofx/issues/39

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1886034

Title:
  libofx: Error importing Ofx file: incorrect dates

Status in HomeBank:
  Triaged

Bug description:

  When I import an ofx file the transaction dates in all of them are 1969-12-31.
  View an excerpt from the ofx file with a transaction:
  ...
    <STMTTRN>
      <TRNTYPE>DEBIT
      <DTPOSTED>20200406000000[-03:EST]
      <TRNAMT>-31.16
      <FITID>N102C0:06/04/20:-914.16:0002579: Visa Electron: Supermercado
      <CHECKNUM>0002579
      <MEMO>Visa Electron Supermercado
    </STMTTRN>
  ...
  I'm using:
  ----
  OS Type        : Gnu/Linux, distribution Ubuntu 20.04
  HomeBank version: 5.4.2
  GTK version    : 3.24.18
  Libofx          : libofx7:amd64, :0.9.15-3build1
  ----

To manage notifications about this bug go to:
https://bugs.launchpad.net/homebank/+bug/1886034/+subscriptions

[Maxime DOYEN (mdoyen)]

@Tiberio Melo (tiberio-melo) can you:

1) give it a try with a libofx >= 0.10.1 if possible for you

2) provide a file for the libofx team to try reproduce and hopefully fix any problem ?

you can post directly to https://github.com/libofx/libofx/issues/39
or here

[Maxime DOYEN (mdoyen)]

I do not reproduce with that file and with libofx 0.9.15
I also tested with libofx 0.10.1 and no problem either

can someone else try ?

[Maxime DOYEN (mdoyen)]

and if not Tiberio Melo
=> please provide a file that reproduc the problem (or your libofx version if it has changed)

[cascagrossa (cascagrossa-cascao)]

Maxime.

As you can't reproduce the error using the file attached by Tiberio, I begin to suspect that the root of the problem is in the system locale configuration.

From the file attached by Him I realized that it seems to be, like mine, a system configured as Brazilian Portuguese.

ivan@cerebro:~$ locale
LANG=pt_BR.UTF-8
LANGUAGE=pt_BR:pt:en
LC_CTYPE="pt_BR.UTF-8"
LC_NUMERIC="pt_BR.UTF-8"
LC_TIME="pt_BR.UTF-8"
LC_COLLATE="pt_BR.UTF-8"
LC_MONETARY="pt_BR.UTF-8"
LC_MESSAGES="pt_BR.UTF-8"
LC_PAPER="pt_BR.UTF-8"
LC_NAME="pt_BR.UTF-8"
LC_ADDRESS="pt_BR.UTF-8"
LC_TELEPHONE="pt_BR.UTF-8"
LC_MEASUREMENT="pt_BR.UTF-8"
LC_IDENTIFICATION="pt_BR.UTF-8"
LC_ALL=

[Maxime DOYEN (mdoyen)]

this is a plus to know.
but still, a test file is required for OFX maintainer to fix
no file, no fix

please port directly to the OFX bug and mention the pt_BR locale ;)

[cascagrossa (cascagrossa-cascao)]

Maxime, sorry, but the files that I could upload have bank information that I don't intend to share, so I prefer to avoid uploading them.
By the way, my problem is solved, I created a script that can translate "xls" files obtained from my bank into "csv" files that can be imported by HomeBank.
Thanks for your help, anyway.

[Tiberio Melo (tiberio-melo)]

cascagrossa-cascao, can you share the script to convert "xls" files on "csv" files that can be imported by HomeBank?

[cascagrossa (cascagrossa-cascao)]

Tiberio, envie um e-mail pessoal para <email address hidden>.

Em 17/05/2021 09:23, Tiberio Melo escreveu:
> cascagrossa-cascao, can you share the script to convert "xls" files on
> "csv" files that can be imported by HomeBank?
>

[Maxime DOYEN (mdoyen)]

@cascagrossa
the idea was more to take the file and open it with a text editor to obfuscate personal data.
just keep a few txn with the problem to create a sample file for OFX team to debug.
it will not take long to do that for sure.

your problem is not solved, you have just make a workaround to it, great for you in waiting an OFX fix, but this fix is still required.

[cascagrossa (cascagrossa-cascao)]

Maxime,

You are right, the problem has not been solved, however in fact I have no problem anymore because I no longer use OFX.
Anyway, the attached file causes the error. Attached here because I don't have a github.com account.

[Maxime DOYEN (mdoyen)]

thanks,
no problem, I have added the file to the ofx githup bug.
( https://github.com/libofx/libofx/issues/39 )

[Maxime DOYEN (mdoyen)]

could you go to https://github.com/libofx/libofx/issues/39
there have been some update on that problem

[Maxime DOYEN (mdoyen)]

ok I tested as well with pt_BR locale and I get the correct date:
Date posted: Thu May 13 04:00:00 2021 CEST

so I close this bug