Page 1 of 1

Can't import QIF from Money

Posted: Tue Dec 06, 2016 2:40 pm
by JillB
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

Posted: Sat Dec 10, 2016 1:38 pm
by Nikolay
Could you post a small peace of QIF file here to develops can to eproduce this problem?

Re: Can't import QIF from Money

Posted: Sat Dec 10, 2016 2:06 pm
by JillB
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

Posted: Mon Dec 12, 2016 2:45 pm
by JillB
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

Posted: Wed Dec 28, 2016 10:42 am
by Nikolay
Please check if the QIF file in UTF8 encoding.

Re: Can't import QIF from Money

Posted: Wed Dec 28, 2016 11:50 am
by JillB
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

Posted: Sat Dec 31, 2016 3:16 pm
by Fabien69
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

Posted: Sun Jan 01, 2017 5:26 pm
by Nikolay
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

Posted: Sun Jan 01, 2017 8:08 pm
by JillB
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.