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