QIF import : date format or date mask is incorrect

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
Patslayer
New MMEX User
Posts: 6
Joined: Tue Dec 06, 2022 8:48 pm
Are you a spam bot?: No

QIF import : date format or date mask is incorrect

Post by Patslayer »

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
User avatar
Renato
MVP MMEX User
Posts: 655
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

Post by Renato »

Would it be possible to post the first 20 lines of the input file.
Renato Forum Administrator
Patslayer
New MMEX 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

Post by Patslayer »

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
Patslayer
New MMEX 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

Post by Patslayer »

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
User avatar
Renato
MVP MMEX User
Posts: 655
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

Post by Renato »

probably the opening date of the accounts is / are greater than the date in the transactions.
Renato Forum Administrator
Patslayer
New MMEX 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

Post by Patslayer »

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

Regards,
Patrick
Patslayer
New MMEX 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

Post by Patslayer »

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
User avatar
Renato
MVP MMEX User
Posts: 655
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

Post by Renato »

thanks for the feedback, have fun with MMEX
Renato Forum Administrator
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: QIF import : date format or date mask is incorrect

Post by Nikolay »

Patslayer
New MMEX 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

Post by Patslayer »

Hi Nikolay,

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

Best regards,
Patrick
Post Reply