Page 1 of 1

Microsoft Money Import using QIF file fails

Posted: Wed Jun 03, 2020 3:02 pm
by JSMWhitaker
I'm try to import data from MS Money by creating a QIF file and then importing from that. Every time I try, MMEX shuts down. Reopening shows no rows imported.

Jim Whitaker

Re: Microsoft Money Import using QIF file fails

Posted: Thu Jun 04, 2020 10:08 am
by JSMWhitaker
UPDATE
I wonder if it is a problem with the size of the file; it has some 47k rows. I have created another file with only 160 rows and that has loaded OK. Is there a known size limitation?

Re: Microsoft Money Import using QIF file fails

Posted: Fri Jun 05, 2020 11:00 am
by Nikolay
There is no limitation.
Possibly there is not enough PC's memory for this operation.

Re: Microsoft Money Import using QIF file fails

Posted: Fri Jun 05, 2020 11:19 am
by JSMWhitaker
OK, I shall monitor that and see. 8Gb is usually not stressed by this sort of thing.

Re: Microsoft Money Import using QIF file fails

Posted: Fri Jun 05, 2020 11:40 am
by JSMWhitaker
I've tried again and there is no indication of significant memory use at all. Plenty of headroom in any case - 4.3 Gb available.

Re: Microsoft Money Import using QIF file fails

Posted: Sat Jun 06, 2020 9:45 am
by Nikolay
Could you reproduce the issue with mmex 1.3.5-rc.2 ?

Re: Microsoft Money Import using QIF file fails

Posted: Sun Jun 07, 2020 10:06 am
by JSMWhitaker
I'll try that.

Re: Microsoft Money Import using QIF file fails

Posted: Sun Jun 07, 2020 10:51 am
by JSMWhitaker
I discovered that I was using 1.3.5-rc.2 !
Changed to 1.3.4 - same behaviour, a large file crashes the application. Using a smaller file the import process runs but every record has an error and no records are loaded. The reported error is: "Error: Transaction Account is incorrect".

Re: Microsoft Money Import using QIF file fails

Posted: Tue Jun 09, 2020 7:08 am
by Nikolay
Could you provide QIF file sample?

Re: Microsoft Money Import using QIF file fails

Posted: Mon Jul 13, 2020 4:28 pm
by gooman
Same problem here, importing large QIF file from Anmoney.

Crashes with no messages after 18200 lines.

I'm afraid I can't provide a sample - it's all highly sensitive info. Any way of getting any logging?

Re: Microsoft Money Import using QIF file fails

Posted: Wed Jul 15, 2020 2:22 pm
by Nikolay
OK

Seems time to register the bug
https://github.com/moneymanagerex/moneymanagerex/issues
and generate QIF file with random data.
May be ubing Python script?

Re: Microsoft Money Import using QIF file fails

Posted: Sat Sep 05, 2020 2:01 pm
by njwmmex
I had a similar problem - large QIF file exported from Quicken, crash on import into MMEx. Found the issue - not the size, but one record had a pound sign £ in the memo field. When I removed that the import was fine

Re: Microsoft Money Import using QIF file fails

Posted: Tue Dec 22, 2020 8:29 am
by Nikolay
Could you try to change QIF file encoding to UTF8?
Related bug:
https://github.com/moneymanagerex/money ... ssues/2751

Re: Microsoft Money Import using QIF file fails

Posted: Wed Jul 07, 2021 8:48 am
by njwmmex
Nikolay wrote: Tue Dec 22, 2020 8:29 am Could you try to change QIF file encoding to UTF8?
The import with the £ sign in it now imports correctly in version 1.5.3 64-bit with the default encoding

Re: Microsoft Money Import using QIF file fails

Posted: Wed Jul 07, 2021 9:12 am
by Renato
Thanks for the feedback