QIF Import Error in Financisto

[Evgeny]

As I see, the feature requested in "​#701822 Feature request: Import qif files to new accounts" is already implemented.
So, I tried to import data from HomeBank to Financisto. Exported it in QIF, then started importing QIF in Financisto. But at the end, unfortunately, got "QIF Import Error" message without any explanations. Tried with different files (small and big) - the same story.
Are QIF formats different in this 2 programs?
Is this a known bug, that's gonna be fixed?
Thanks.

[Maxime DOYEN (mdoyen)]

Hi Evgeny,

QIF should ensure that HomeBank and Financisto or any other finance softawre that support QIF may exchange datas.
The QIF specification should be the same.

If I understand you right, you exported QIF file from HomeBank and cannot import into Financisto, right ?
So 2 options here, my qif export is wrong, or Financisto import is.
maybe it is related to #902926, but I was not able to fail a QIF file exported from HomeBank.

Can someone please test with the HomeBank exampe file ?
Also if someone is skilled enough, maybe test in a kind of debug mode into Financisto ?

And post the result here, many thanks.

[Evgeny (evgpiun)]

Hello, Maxime.

I checked the QIF feature with the sample file (http://homebank.free.fr/public/example_file.tar.gz) - it was successfully imported in Financisto after exporting from HomeBank.
But on my files it fails in both ways which are proposed for the file pick up: "Normal Android Way" and "File Way".
Any help will be very appreciated.

[Ivan Strokanev (bahbka)]

Workaround:
After changing account record in QIF, exported by homebank:
!Type:Bank
!Account
NZupapupabank
^

to:

!Account
NZupapupabank
!Type:Bank
^

resolve problem, financisto successfuly imports my qif.

[Ivan Strokanev (bahbka)]

Also, in "Cash" accounts absent !Type:Cash line, and financisto assumes that this is "Bank" account.

[Evgeny (evgpiun)]

Ivan, thank you for the info very much!
I was also able to import a QIF file exported from Homebank to Financisto, although I needed to perform a bit different rearrangement:
!Account
NZupapupabank
^
!Type:Bank

It is the right QIF structure according to http://en.wikipedia.org/wiki/Quicken_Interchange_Format.

And for me in "Cash" accounts the "!Type:Cash" was not missing but was replaced by "!Type:Bank" line. Changing it to the right line also fixed the problem.

I found a couple of other small problems, too:
 - there's an import error, if there's an account without transactions in Homebank;
 - the account's initial sum is not exported (imported) (may be it's just not supported by QIF).

Waiting for the Homebank 4.5!

[Maxime DOYEN (mdoyen)]

Hi,

HomeBank qif format is correct:
http://svn.gnucash.org/trac/browser/gnucash/trunk/src/import-export/qif-import/file-format.txt

!Account
NCompte de dépot
TBank
^
!Type:Bank
D11/03/1993
T76.22
CR
P
MOuverture compte
LVirement
^

I have just fixed the issue with account type (was always Bank)
Also added T<acc type> in !Account section as well.