I am trying to import a QIF file (with 2490 lines) into a new database in MMEX 1.9.0 on Mac. Most of the transactions are imported but about 20 of them get the following error: CHECKINGACCOUNT_V1: Exception constraint failed[1555]: UNIQUE constraint failed: CHECKINGACCOUNT_V1.TRANSID.
The strange thing is that I tried the import 3 times and, each time, the transactions which give the error are different and their number is also different (21, 22, 18).
Anybody has an idea of what the problem is?
Thanks
Errors while importing QIF file into MMEX 1.9.0 on Mac
Moderator: Renato
-
jhotterb
- New User
- Posts: 2
- Joined: Fri Mar 14, 2025 3:03 pm
- Are you a spam bot?: No
-
Renato
- MVP User
- Posts: 866
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Errors while importing QIF file into MMEX 1.9.0 on Mac
Renato Forum Administrator (I'm not a developer)
-
jhotterb
- New User
- Posts: 2
- Joined: Fri Mar 14, 2025 3:03 pm
- Are you a spam bot?: No
Re: Errors while importing QIF file into MMEX 1.9.0 on Mac
Indeed. It seems to be fixed but I'm not too sure how to get the fix (no pun intended). On the milestone part of issue 7194, it says v1.9.1 due by May 29, 2026.
-
guangong
- Developer
- Posts: 654
- Joined: Wed Dec 21, 2011 5:58 am
- Are you a spam bot?: No
Re: Errors while importing QIF file into MMEX 1.9.0 on Mac
You can try the fixed app (v1.9.1.beta) via development build through it’s not stable.
Splitting the file might help on importing.
this is due to ID generation conflicts in batch mode.
Splitting the file might help on importing.
this is due to ID generation conflicts in batch mode.