Can't import QIF from Money

Page 1 of 1
9 posts
Can't import QIF from Money

JillB
New MMEX User

Posts: 5
Joined: Tue Dec 06, 2016 8:23 am
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
Re: Can't import QIF from Money

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Could you post a small peace of QIF file here to develops can to eproduce this problem?
Re: Can't import QIF from Money

JillB
New MMEX User

Posts: 5
Joined: Tue Dec 06, 2016 8:23 am
I'm out of town right now, but will post when I return home on Monday. Thanks for getting back to me. 
Re: Can't import QIF from Money

JillB
New MMEX User

Posts: 5
Joined: Tue Dec 06, 2016 8:23 am
Nikolay wrote:Could you post a small peace of QIF file here to develops can to eproduce this problem?
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. :)

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
Re: Can't import QIF from Money

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Please check if the QIF file in UTF8 encoding.
Re: Can't import QIF from Money

JillB
New MMEX User

Posts: 5
Joined: Tue Dec 06, 2016 8:23 am
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
Re: Can't import QIF from Money

Fabien69
New MMEX User

Posts: 5
Joined: Sat Dec 31, 2016 9:08 am
JillB 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

Hello
I have exactly the same problem
Re: Can't import QIF from Money

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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 ','.
Re: Can't import QIF from Money

JillB
New MMEX User

Posts: 5
Joined: Tue Dec 06, 2016 8:23 am
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 ','.
Thank you! It's working now.
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests