MMEX Discussion Forum

Hi All,

I know this topic has been raised a million times, but I haven't found a valid solution yet...

I'm trying to import a Microsoft Money QIF file but every line makes an error. For example :
Error:
( 02.12'2022|Withdrawal|-114.50|Alimentation:Commissions|Commissions| )
Date format or date mask is incorrect

I tried to change the date format to DD.MM'YYYY but no luck.

I'm using Win11 Pro in French.

Thanks and best regards,
Patrick

Would it be possible to post the first 20 lines of the input file.

Hello,

Sure, here they are:

!Type:Bank
D28.02'2009
T2.29
CX
PSolde initial
L[Compte courant]
^
D28.02'2009
T-1.00
PVirement mensuel
L[Compte Patrick]
^
D01.01'2018
T-9.00
PRS Equipement
LLoisirs:Sport
^
D01.01'2018
T-7.00
PRestaurant
LAlimentation:Restaurant
^
D01.01'2018
T-1.00
PSki
LLoisirs:Sport
^
D02.01'2018
T-1.00
PRestaurant
LAlimentation:Restaurant
^
D02.01'2018
T-5.00
PRestaurant
LAlimentation:Restaurant
^
D02.01'2018
T-1.00
PSki
LLoisirs:Sport
^
D03.01'2018
T-5.00
PRestaurant
LAlimentation:Restaurant
^
D03.01'2018
T-2.00
PThermes Parc
LLoisirs
^
D03.01'2018
T-2.00
PRestaurant
LAlimentation:Restaurant
^
D04.01'2018
T-1.00
PRestaurant
LAlimentation:Restaurant
^
D05.01'2018
T-7.00
PThermes Parc
LLoisirs
^
D06.01'2018
T-9.55
PCommissions
LAlimentation:Commissions
^
D06.01'2018
T-4.00
PRestaurant
LAlimentation:Restaurant
^
D06.01'2018
T-5.70
PCommissions
LAlimentation:Commissions
^
D06.01'2018
T-1.10
PEssence
LAutomobile:Essence
^
D09.01'2018
T-2.00
PFemme de ménage
LLogement
^
D09.01'2018
T-8.00
PPains Christine
LAlimentation:Commissions
^
D09.01'2018
T-2.80
PClaire's
LEnfants:Habillement
^

Regards,
Patrick

Hi All,

I've modified the date format to D28.02.2009 for example, and now there's no more the date format error message!

My QIF file contains 5690 lines but when I import it only creates 78 lines.

I've not set a filtering date.

Any idea why?

Thanks and regards,
Patrick

probably the opening date of the accounts is / are greater than the date in the transactions.

Unfortunately not.
Even if I set the account opening date prior to the first transaction, it only imports a few transactions.

Regards,
Patrick

Good news, I've been able to import everything!

Here's what I did :

- create all the accounts manually with the same name as in MS Money
- change all the creation date to a date prior to the first transaction date of all accounts
- change the date format in the qif files to DD.MM.YYYY

Regards,
Patrick

thanks for the feedback, have fun with MMEX

FYI

https://github.com/moneymanagerex/money ... ssues/5602

Hi Nikolay,

Thanks ! Happy to see that this issue will be soon resolved.

Best regards,
Patrick