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

JSMWhitaker
New MMEX 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 MMEX 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
MMEX 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 MMEX 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 MMEX 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
MMEX 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 MMEX 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 MMEX 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
MMEX 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 MMEX 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?
Post Reply