Hi. I've just downloaded MMEX 1.2.7 and installed it on my Win10 (Home edition) as I was looking for an alternative to Money (2004). The installation went fine, and I have exported 2 QIF files from Money, one in each of the proposed formats. This is where the problems begin. Having created an account in MMEX, I try to import one of the QIF files, the importer goes through all of the 8502 items, but there is an error on each one and the result is an empty account in MMEX. I read through the manual and on each try I correct the date format to match that of Money, and I have tried to specify a date range but each try yields the same results. What am I doing wrong? Thank you in advance for any help you can give me.
JillB
Can't import QIF from Money
Moderator: Renato
-
- New User
- Posts: 5
- Joined: Tue Dec 06, 2016 2:23 pm
- Are you a spam bot?: No
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Can't import QIF from Money
Could you post a small peace of QIF file here to develops can to eproduce this problem?
-
- New User
- Posts: 5
- Joined: Tue Dec 06, 2016 2:23 pm
- Are you a spam bot?: No
Re: Can't import QIF from Money
I'm out of town right now, but will post when I return home on Monday. Thanks for getting back to me.
-
- New User
- Posts: 5
- Joined: Tue Dec 06, 2016 2:23 pm
- Are you a spam bot?: No
Re: Can't import QIF from Money
I've opened the QIF file with Notepad++ and copied a few lines, pasting them below. I hope this helps! And thank you for looking into this.Nikolay wrote:Could you post a small peace of QIF file here to develops can to eproduce this problem?
Regards,
Jill
!Type:Bank
D15/10'2013
T0.00
CX
PSolde initial
L[BNP Paribas]
^
D15/10'2013
CX
MOuverture de compte
T1,000.00
PHSBC
LAutres revenus
^
D23/10'2013
CX
T-42.40
PLeclerc
LAlimentation:Épicerie
^
D23/10'2013
CX
M26€ remboursé par Monique & Danièle
T-39.00
PMusée Jacquemart
LLoisirs-culture-sport:Musées-expositions
^
D23/10'2013
CX
T-23.00
N5267911
PDr. Ruby
LSanté:Médecin
^
D24/10'2013
CX
T-100.00
NRetrait d'es
PEspèces
LRetrait d'espèces
^
D25/10'2013
CX
Mgabarits cercles
T-32.53
PCotton & Color
LLoisirs-culture-sport:Quilt
^
D29/10'2013
CX
T-20.60
PMusée Jacquemart
LAlimentation:Restaurant
^
D29/10'2013
CX
T-9.10
PParking
LAuto-moto:Parking-péage
^
D30/10'2013
CX
T-98.56
PLeclerc
LAlimentation:Épicerie
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Can't import QIF from Money
Please check if the QIF file in UTF8 encoding.
-
- New User
- Posts: 5
- Joined: Tue Dec 06, 2016 2:23 pm
- Are you a spam bot?: No
Re: Can't import QIF from Money
The file I posted before was, I believe, in ANSI, so I've used Notepad++ again to convert it to ISO-8. The strange characters are (I think) due to the fact that the text is written in French. I hope I've done this right!
!Type:Bank
D15/10'2013
T0.00
CX
PSolde initial
L[BNP Paribas]
^
D15/10'2013
CX
MOuverture de compte
T1,000.00
PHSBC
LAutres revenus
^
D23/10'2013
CX
T-42.40
PLeclerc
LAlimentation:ʰicerie
^
D23/10'2013
CX
M26 rembours顰ar Monique & Dani魥
T-39.00
PMusꥠJacquemart
LLoisirs-culture-sport:Mus꦳-expositions
^
D23/10'2013
CX
T-23.00
N5267911
PDr. Ruby
LSant黍ꥥcin
^
D24/10'2013
CX
T-100.00
NRetrait d'es
PEsp餥s
LRetrait d'esp餥s
^
D25/10'2013
CX
Mgabarits cercles
T-32.53
PCotton & Color
LLoisirs-culture-sport:Quilt
^
D29/10'2013
CX
T-20.60
PMusꥠJacquemart
LAlimentation:Restaurant
^
D29/10'2013
CX
T-9.10
PParking
LAuto-moto:Parking-pꢧe
!Type:Bank
D15/10'2013
T0.00
CX
PSolde initial
L[BNP Paribas]
^
D15/10'2013
CX
MOuverture de compte
T1,000.00
PHSBC
LAutres revenus
^
D23/10'2013
CX
T-42.40
PLeclerc
LAlimentation:ʰicerie
^
D23/10'2013
CX
M26 rembours顰ar Monique & Dani魥
T-39.00
PMusꥠJacquemart
LLoisirs-culture-sport:Mus꦳-expositions
^
D23/10'2013
CX
T-23.00
N5267911
PDr. Ruby
LSant黍ꥥcin
^
D24/10'2013
CX
T-100.00
NRetrait d'es
PEsp餥s
LRetrait d'esp餥s
^
D25/10'2013
CX
Mgabarits cercles
T-32.53
PCotton & Color
LLoisirs-culture-sport:Quilt
^
D29/10'2013
CX
T-20.60
PMusꥠJacquemart
LAlimentation:Restaurant
^
D29/10'2013
CX
T-9.10
PParking
LAuto-moto:Parking-pꢧe
-
- New User
- Posts: 4
- Joined: Sat Dec 31, 2016 3:08 pm
- Are you a spam bot?: No
Re: Can't import QIF from Money
HelloJillB wrote:Hi. I've just downloaded MMEX 1.2.7 and installed it on my Win10 (Home edition) as I was looking for an alternative to Money (2004). The installation went fine, and I have exported 2 QIF files from Money, one in each of the proposed formats. This is where the problems begin. Having created an account in MMEX, I try to import one of the QIF files, the importer goes through all of the 8502 items, but there is an error on each one and the result is an empty account in MMEX. I read through the manual and on each try I correct the date format to match that of Money, and I have tried to specify a date range but each try yields the same results. What am I doing wrong? Thank you in advance for any help you can give me.
JillB
I have exactly the same problem
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Can't import QIF from Money
I've succesfully imported the file provided.
Before I've created a new account 'Test' to import the data into it.
Then I've changed 'Test' account currency settings. Decimal char should be '.' and Grouping char should be ','.
Before I've created a new account 'Test' to import the data into it.
Then I've changed 'Test' account currency settings. Decimal char should be '.' and Grouping char should be ','.
-
- New User
- Posts: 5
- Joined: Tue Dec 06, 2016 2:23 pm
- Are you a spam bot?: No
Re: Can't import QIF from Money
Thank you! It's working now.Nikolay wrote:I've succesfully imported the file provided.
Before I've created a new account 'Test' to import the data into it.
Then I've changed 'Test' account currency settings. Decimal char should be '.' and Grouping char should be ','.