Imports

Page 1 of 1
7 posts
Imports

Den
New MMEX User

Posts: 4
Joined: Sat Mar 04, 2017 10:20 am
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
Re: Imports

Nikolay
MMEX Developer

Posts: 2279
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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.
Re: Imports

Den
New MMEX User

Posts: 4
Joined: Sat Mar 04, 2017 10:20 am
Nikolay 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.
Hi Nikoay

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
Re: Imports

Nikolay
MMEX Developer

Posts: 2279
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
What is the dates values in the QIF file?
'Date mask has several values' is nor an error but warning.
Re: Imports

Den
New MMEX User

Posts: 4
Joined: Sat Mar 04, 2017 10:20 am
Nikolay wrote:What is the dates values in the QIF file?
'Date mask has several values' is nor an error but warning.
Hi, Thanks again.

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
Re: Imports

Nikolay
MMEX Developer

Posts: 2279
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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.
Re: Imports

Den
New MMEX User

Posts: 4
Joined: Sat Mar 04, 2017 10:20 am
Nikolay 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.
Thanks Nikolay
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.
Page 1 of 1
Who is online

Users browsing this forum: Google [Bot] and 2 guests