Microsoft Money Import using QIF file fails

MMEX4Desktop, incl. Windows, macOS (10.10 or newer), and Most Unix variants using the GTK+ toolkit

Moderator: Renato

Post Reply
JSMWhitaker
New User
Posts: 6
Joined: Wed Jun 03, 2020 2:52 pm
Are you a spam bot?: No

Microsoft Money Import using QIF file fails

Post 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
JSMWhitaker
New User
Posts: 6
Joined: Wed Jun 03, 2020 2:52 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post 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?
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Microsoft Money Import using QIF file fails

Post by Nikolay »

There is no limitation.
Possibly there is not enough PC's memory for this operation.
JSMWhitaker
New User
Posts: 6
Joined: Wed Jun 03, 2020 2:52 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post by JSMWhitaker »

OK, I shall monitor that and see. 8Gb is usually not stressed by this sort of thing.
JSMWhitaker
New User
Posts: 6
Joined: Wed Jun 03, 2020 2:52 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post 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.
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Microsoft Money Import using QIF file fails

Post by Nikolay »

Could you reproduce the issue with mmex 1.3.5-rc.2 ?
JSMWhitaker
New User
Posts: 6
Joined: Wed Jun 03, 2020 2:52 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post by JSMWhitaker »

I'll try that.
JSMWhitaker
New User
Posts: 6
Joined: Wed Jun 03, 2020 2:52 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post 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".
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Microsoft Money Import using QIF file fails

Post by Nikolay »

Could you provide QIF file sample?
gooman
New User
Posts: 1
Joined: Mon Jul 13, 2020 4:26 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post 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?
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Microsoft Money Import using QIF file fails

Post 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?
njwmmex
New User
Posts: 3
Joined: Sat Sep 05, 2020 1:56 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post 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
Nikolay
Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Microsoft Money Import using QIF file fails

Post by Nikolay »

Could you try to change QIF file encoding to UTF8?
Related bug:
https://github.com/moneymanagerex/money ... ssues/2751
njwmmex
New User
Posts: 3
Joined: Sat Sep 05, 2020 1:56 pm
Are you a spam bot?: No

Re: Microsoft Money Import using QIF file fails

Post 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
User avatar
Renato
MVP User
Posts: 669
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Microsoft Money Import using QIF file fails

Post by Renato »

Thanks for the feedback
Renato Forum Administrator
Post Reply