Ubuntu
kmymoney2 package

Can't import a qif file

Asked by kris969

After having used M$ Money by the past then Grisbi for a while.
For many reasons, I want to change my account software, here I am with KMM.

Using Grisbi I first export my personal data to a qif file. Then I import these data to KMM. It works fine except it's really not efficient to have to create all new categories, and it took me a while.

So I get now me financial data in KMM.

What I want to do now is to update it with new import coming from my bank. The only basic way I have is to download a qif file.
The problem I have is that KMM don't import anything, I have check and tune the date format but it still not working. Is it possible to have a log during the processing import because for the moment I don't understand what is wrong.
I compare the too qif files, the first block was different, I tried to patch it to have the same type of record at beginning, but it still not working anyway.

I need some ideas and help to continue.

Thanks for all

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu kmymoney2 Edit question
Assignee:
No assignee Edit question
Solved by:
Hei Ku
Solved:
Last query:
Last reply:
Revision history for this message
Hei Ku (asoliverez) said : 		#1

Have you checked the online manual about it?

http://kmymoney2.sourceforge.net/online-manual/details.impexp.qifimp.html

Revision history for this message
kris969 (cby469) said : 		#2

Yes,
Of course I always read documentation before using something and read again before asking question.

This text was very useful to import my historical data. I add to tune the date format in accordance to the date format in the qif file it was dd/mm/yyyy.
To import update qif file coming from my bank, I change it because the date format is dd/mm/yy.

I don't know if some keys are mandatories in the qif file. In the file to import the only key is "bank" then come the transactions.

When I try to import a file, I have no error message, nothing that could help me to find what's wrong. The only observable thing is that nothing is imported.

So the question is : what's the way now to get more result ?

Thanks

Revision history for this message
Hei Ku (asoliverez) said : 		#3

What version of KMyMoney are you using?
It is important because there have been several improvement in the last months to that part of the application.

Revision history for this message
kris969 (cby469) said : 		#4

I am using the last KMyMoney stable version : V0.8.8
On an Ubuntu 8.04 (hardy heron)

This version is the one available from proposed packets with synaptic.
As the KMM V0.9 is under development and I want to really use it, I stay on the V0.8.8

Revision history for this message
Hei Ku (asoliverez) said : 		#5

Actually is 0.8.8 is stable as in way old (almost a year now), but I know
that's what is available in Hardy. Intrepid ships with v0.9 already.

Could you send me the first 20-30 lines of the QIF file?
That will give us a clue on what might be going wrong.

On Thu, Sep 4, 2008 at 12:48 AM, kris969 <
<email address hidden>> wrote:

> Question #43970 on kmymoney2 in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/kmymoney2/+question/43970
>
> Status: Needs information => Open
>
> kris969 gave more information on the question:
> I am using the last KMyMoney stable version : V0.8.8
> On an Ubuntu 8.04 (hardy heron)
>
> This version is the one available from proposed packets with synaptic.
> As the KMM V0.9 is under development and I want to really use it, I stay on
> the V0.8.8
>
> --
> You received this question notification because you are an answer
> contact for kmymoney2 in ubuntu.
>

Revision history for this message
kris969 (cby469) said : 		#6

Ok for the Intrepid, I plan to switch to this new version in next October.
Anyway here is the requested information, I will appreciate to be able to use KMM as soon as possible.

Of course, in the following sample, I have replaced some values and texts, but kipping the exact number of chars and the global format.

====================
!type:Bank

D01/09/2008

T-90.00

NChèque

PCHEQUE 1920

MCHEQUE 1920

^

D01/09/2008

T-49.00

NChèque

PCHEQUE 1922

MCHEQUE 1922

^

D01/09/2008

T300.00

NVirement

PVIR RECU 1234567890123

MVIR RECU 1234567890123 DE: XXXXX

^

D01/09/2008

T-6.50

NCarte

PCARTE 1234567890123456

MCARTE 1234567890123456 30/08/08 LEROY MERLIN

^

D01/09/2008

T-9.94

NCarte

PCARTE 1234567890123456

MCARTE 1234567890123456 30/08/08 LEROY MERLIN

^

====================

Revision history for this message
Best Hei Ku (asoliverez) said : 		#7

 Replacing

  !type:Bank

with

  !Type:Bank

in the QIF file should do the trick.

On Thu, Sep 4, 2008 at 1:20 PM, kris969 <<email address hidden>
> wrote:

> Question #43970 on kmymoney2 in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/kmymoney2/+question/43970
>
> Status: Answered => Open
>
> kris969 is still having a problem:
> Ok for the Intrepid, I plan to switch to this new version in next October.
> Anyway here is the requested information, I will appreciate to be able to
> use KMM as soon as possible.
>
> Of course, in the following sample, I have replaced some values and
> texts, but kipping the exact number of chars and the global format.
>
> ====================
> !type:Bank
>
> D01/09/2008
>
> T-90.00
>
> NChèque
>
> PCHEQUE 1920
>
> MCHEQUE 1920
>
> ^
>
> D01/09/2008
>
> T-49.00
>
> NChèque
>
> PCHEQUE 1922
>
> MCHEQUE 1922
>
> ^
>
> D01/09/2008
>
> T300.00
>
> NVirement
>
> PVIR RECU 1234567890123
>
> MVIR RECU 1234567890123 DE: XXXXX
>
> ^
>
> D01/09/2008
>
> T-6.50
>
> NCarte
>
> PCARTE 1234567890123456
>
> MCARTE 1234567890123456 30/08/08 LEROY MERLIN
>
> ^
>
> D01/09/2008
>
> T-9.94
>
> NCarte
>
> PCARTE 1234567890123456
>
> MCARTE 1234567890123456 30/08/08 LEROY MERLIN
>
> ^
>
>
> ====================
>
> --
> You received this question notification because you are an answer
> contact for kmymoney2 in ubuntu.
>

Revision history for this message
kris969 (cby469) said : 		#8

You are right, it work's with this workaround !!!

So I am very happy to be now in situation to continue with KMM.

Although the correct code seems to be <<!Type>> in the qif definition, I think it's not really necessary to be case sensitive in this syntax analysis. The proof is that in some cases the qif file could be different than expected. Don't you think that it could be interesting to change a little bit KMM code to be less restrictive on this point ?

If I have understood, I must have the possibility to right a filter (with awk for exemple) to change !type to !Type at each import cycle. Do you agree with this idea.

Thanks for all

regards

Revision history for this message
kris969 (cby469) said : 		#9

Thanks Hei Ku, that solved my question.

Revision history for this message
Hei Ku (asoliverez) said : 		#10

Yes, I think using awk or sed should do the trick.
Also, this has been fixed in CVS, so that should be no problem in future versions.
Thanks for your patience. My access to launchpad has been fairly erratic, so it took me longer than usual to get the answers to you.

Revision history for this message
kris969 (cby469) said : 		#11

Thanks for all your support.

On my side, my filling is that your support was very reactive and efficient.

I start to test the Ubuntu 8.10 Alpha 5 as it became available until yesterday evening.
Of course I have installed KMM 0.9 to have a look on it. YEHHHHH, that's amazing, all the job made by the team across one year on this software !!!

I have one problem with KMM on intrepid, but I will follow on this on a new post.

I think I will switch in the next days on the cvs version, to be able to help you a little bit on testing and translating.

Bye