Hello All
Just using Money manager Ex for the first time in order to replace MS Money. But having great difficulty importing files. I have tried .QIF and CSV files. I keep getting 'Date mask has several values' error. i have tried different ones but no joy. My date format should be DD/MM/YYYY. It continues importing but at the end shows '0' imported.
I have exported from MS Money (only QIF vailable) and directly from bank statement in CSV format.
I should add this is on windows 10 with the latest MM_Ex (32 bit).
Any help greatly appreciated.
Thank you
Imports
Moderator: Renato
-
- MMEX Developer
- Posts: 1432
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Imports
Could you upgrade to v 1.3.3?
https://sourceforge.net/projects/moneym ... es/v1.3.3/
Several QIF transactions as sample will be helpful for tests.
https://sourceforge.net/projects/moneym ... es/v1.3.3/
Several QIF transactions as sample will be helpful for tests.
Re: Imports
Hi NikoayNikolay wrote:Could you upgrade to v 1.3.3?
https://sourceforge.net/projects/moneym ... es/v1.3.3/
Several QIF transactions as sample will be helpful for tests.
Thanks for replying. I use the portable version 1.3.3.
I exported from MS Money in QIF format (both loose QIF and strict QIF, whatever that may mean!) But when importing I get the "Data mask has several values" error. I have tried importing with each of the values but get same error. It does import the file but the dates are totally wrong, ranging from 1999 to 2021.
The exported file is only from 2016 to 2017, so not sure why it changes the dates.
Thanks for any help.
Den
-
- MMEX Developer
- Posts: 1432
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Imports
What is the dates values in the QIF file?
'Date mask has several values' is nor an error but warning.
'Date mask has several values' is nor an error but warning.
Re: Imports
Hi, Thanks again.Nikolay wrote:What is the dates values in the QIF file?
'Date mask has several values' is nor an error but warning.
Not sure what you mean by date values? But below is a copy of first 4 lines of QIF file:
!Type:BankD06/04/1997T0.00
CX
Does this help?
Regards
-
- MMEX Developer
- Posts: 1432
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Imports
Date mask should be 'dd/mm/yyyy'
Or 'mm/dd/yyyy'
But may be date is too old and a parser can't accept it.
Or 'mm/dd/yyyy'
But may be date is too old and a parser can't accept it.
Re: Imports
Thanks NikolayNikolay wrote:Date mask should be 'dd/mm/yyyy'
Or 'mm/dd/yyyy'
But may be date is too old and a parser can't accept it.
I had already tried 'dd/mm/yyyy' without success. But as you say probably some dates go too far back. I shall try with only the current year's date and keep you posted.
Thanks again.
Re: Imports
I have noticed the same thing happening,however it is the file shown which looks odd.
Example here are the first 4 lines of the transaction shown in the import dialog window
!Type:CCard
Line 2 D15/10/2019
Line 3 T-
Line 4 O-OPERATIVE FOOD
Here are the same 4 lines in the actual qif file
!Type:CCard
D15/10/2019
T-£3.10
PCO-OPERATIVE FOOD
I you notice there is nothing wrong with the date, but that is all that is shown when the file is imported. It is just a misleading pointer to the wrong type of problem. In other words because someone sees the warning about the date types, they automatically assume it is the date in error, whereas there is something else going amiss.
Because of this, no data is written in.
Solution was found to be the currency symbol that has been written into the qif. Using textpad I just did a replace £ with null and everything was imported.
Example here are the first 4 lines of the transaction shown in the import dialog window
!Type:CCard
Line 2 D15/10/2019
Line 3 T-
Line 4 O-OPERATIVE FOOD
Here are the same 4 lines in the actual qif file
!Type:CCard
D15/10/2019
T-£3.10
PCO-OPERATIVE FOOD
I you notice there is nothing wrong with the date, but that is all that is shown when the file is imported. It is just a misleading pointer to the wrong type of problem. In other words because someone sees the warning about the date types, they automatically assume it is the date in error, whereas there is something else going amiss.
Because of this, no data is written in.
Solution was found to be the currency symbol that has been written into the qif. Using textpad I just did a replace £ with null and everything was imported.