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
QIF import : date format or date mask is incorrect
Moderator: Renato
-
- New User
- Posts: 6
- Joined: Tue Dec 06, 2022 8:48 pm
- Are you a spam bot?: No
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: QIF import : date format or date mask is incorrect
Would it be possible to post the first 20 lines of the input file.
Renato Forum Administrator
-
- New User
- Posts: 6
- Joined: Tue Dec 06, 2022 8:48 pm
- Are you a spam bot?: No
Re: QIF import : date format or date mask is incorrect
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
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
-
- New User
- Posts: 6
- Joined: Tue Dec 06, 2022 8:48 pm
- Are you a spam bot?: No
Re: QIF import : date format or date mask is incorrect
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
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
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: QIF import : date format or date mask is incorrect
probably the opening date of the accounts is / are greater than the date in the transactions.
Renato Forum Administrator
-
- New User
- Posts: 6
- Joined: Tue Dec 06, 2022 8:48 pm
- Are you a spam bot?: No
Re: QIF import : date format or date mask is incorrect
Unfortunately not.
Even if I set the account opening date prior to the first transaction, it only imports a few transactions.
Regards,
Patrick
Even if I set the account opening date prior to the first transaction, it only imports a few transactions.
Regards,
Patrick
-
- New User
- Posts: 6
- Joined: Tue Dec 06, 2022 8:48 pm
- Are you a spam bot?: No
Re: QIF import : date format or date mask is incorrect
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
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
-
- MVP User
- Posts: 674
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: QIF import : date format or date mask is incorrect
thanks for the feedback, have fun with MMEX
Renato Forum Administrator
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
-
- New User
- Posts: 6
- Joined: Tue Dec 06, 2022 8:48 pm
- Are you a spam bot?: No
Re: QIF import : date format or date mask is incorrect
Hi Nikolay,
Thanks ! Happy to see that this issue will be soon resolved.
Best regards,
Patrick
Thanks ! Happy to see that this issue will be soon resolved.
Best regards,
Patrick