Microsoft Money Import using QIF file fails
Moderator: Renato
-
- 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
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
Jim Whitaker
-
- 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
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?
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?
-
- 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
There is no limitation.
Possibly there is not enough PC's memory for this operation.
Possibly there is not enough PC's memory for this operation.
-
- 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
OK, I shall monitor that and see. 8Gb is usually not stressed by this sort of thing.
-
- 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
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.
-
- 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
Could you reproduce the issue with mmex 1.3.5-rc.2 ?
-
- 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
I'll try that.
-
- 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
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".
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".
-
- 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
Could you provide QIF file sample?
-
- 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
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?
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?
-
- 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
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?
Seems time to register the bug
https://github.com/moneymanagerex/moneymanagerex/issues
and generate QIF file with random data.
May be ubing Python script?
-
- 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
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
-
- 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
Could you try to change QIF file encoding to UTF8?
Related bug:
https://github.com/moneymanagerex/money ... ssues/2751
Related bug:
https://github.com/moneymanagerex/money ... ssues/2751
-
- New User
- Posts: 3
- Joined: Sat Sep 05, 2020 1:56 pm
- Are you a spam bot?: No
-
- MVP User
- Posts: 681
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich