Imports

General discussion on all other topics under the sun.
Post Reply
Den
New MMEX User
Posts: 4
Joined: Sat Mar 04, 2017 4:20 pm
Are you a spam bot?: No

Imports

Post by Den »

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

Nikolay
MMEX Developer
Posts: 1346
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Imports

Post by Nikolay »

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.

Den
New MMEX User
Posts: 4
Joined: Sat Mar 04, 2017 4:20 pm
Are you a spam bot?: No

Re: Imports

Post by Den »

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

Nikolay
MMEX Developer
Posts: 1346
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Imports

Post by Nikolay »

What is the dates values in the QIF file?
'Date mask has several values' is nor an error but warning.

Den
New MMEX User
Posts: 4
Joined: Sat Mar 04, 2017 4:20 pm
Are you a spam bot?: No

Re: Imports

Post by Den »

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

Nikolay
MMEX Developer
Posts: 1346
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Imports

Post by Nikolay »

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.

Den
New MMEX User
Posts: 4
Joined: Sat Mar 04, 2017 4:20 pm
Are you a spam bot?: No

Re: Imports

Post by Den »

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.

latedev
Super MMEX User
Posts: 21
Joined: Mon Mar 06, 2017 12:53 am
Are you a spam bot?: No

Re: Imports

Post by latedev »

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.

Post Reply