CSV import

General discussion on all other topics under the sun.

Moderator: Renato

mynetdude
New MMEX User
Posts: 9
Joined: Tue Jan 12, 2016 10:34 pm
Are you a spam bot?: No

CSV import

Post by mynetdude »

having trouble importing the CSV and so this is what it looks like at my bank 

Date Reference Type Description Debit Credit CheckNumber

So in Money Ex I have done this: 

Date Don't Care Don't Care Payee Withdrawl Deposit Number 

^^ however Money Ex won't accept that keeps telling me the following  in the logs: 

One of the following fields: Date, Amount, Type is missing, 

I have verified that the date format matches the Money Ex date format 

According to the help file it says NOT to use Amount (-/+) when using withdrawl/deposit and even if I could use it; I can't use it twice and I am not sure what to put for "type"? 
mynetdude
New MMEX User
Posts: 9
Joined: Tue Jan 12, 2016 10:34 pm
Are you a spam bot?: No

Re: CSV import

Post by mynetdude »

anybody can help with this? 
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: CSV import

Post by Nikolay »

Date is mandatory.
mynetdude
New MMEX User
Posts: 9
Joined: Tue Jan 12, 2016 10:34 pm
Are you a spam bot?: No

Re: CSV import

Post by mynetdude »

Nikolay wrote:Date is mandatory.
That's a no brainer; and the date must match the format... I did that and it still won't import did you even read what I said? the headers for my bank is different than what Money Ex does... and instead of having one column for amount -/+ I have two and you can't use that header twice so I have deposits and withdrawls but that doesn't seem to work either. 
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: CSV import

Post by Nikolay »

Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?
mynetdude
New MMEX User
Posts: 9
Joined: Tue Jan 12, 2016 10:34 pm
Are you a spam bot?: No

Re: CSV import

Post by mynetdude »

Nikolay wrote:Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?
sure! :) here it is :D
export (1).csv
(1.39 KiB) Downloaded 476 times
Thanks :)   
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: CSV import

Post by Nikolay »

The file provided may be imported with this mask
mask_scv.png
mask_scv.png (2.1 KiB) Viewed 4996 times
 But mmex can't parce this date "2/1/2015"
If dates will be "02/01/2015" it will be imported.

Will see how to import this dates.
mynetdude
New MMEX User
Posts: 9
Joined: Tue Jan 12, 2016 10:34 pm
Are you a spam bot?: No

Re: CSV import

Post by mynetdude »

Nikolay:The file provided may be imported with this mask
1277: mask_scv.png
 But mmex can't parce this date "2/1/2015"
If dates will be "02/01/2015" it will be imported.

Will see how to import this dates.

ahh ok I matched the correct MM/DD/YYYY but I didn't notice that the bank only does M/DD/YYY


so a quick question about the headings... 

if you go back to my original post the bank has the following headings in their CSV: Date Reference Type Description Debit Credit CheckNumber  and the way you're saying to import it would have incorrect data here's why: 

Date is OK

Payee would be incorrect because according to the bank that's "reference" that has nothing to do with payees 

Again Amount +/- refers to money being taken or put in but you put it where TYPE is... TYPE only tells us what type of transaction it was: either ACH, DEBIT, ATM, etc how is Amount +/- going to work with that? 

you have Category in Description (that's usually the Payee)... so you see where I'm going with this? Its all in the CSV file I sent you. 

Debit and Credit are the actual dollar amounts; remember that we cannot use Amount +/- twice so using Category and subcategory on these is not correct either as this actually tells us how much was transacted. 
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: CSV import

Post by Nikolay »

I've fixed the bug with date parsing.

https://github.com/moneymanagerex/money ... 70f2259de3

I've tested the code with this csv file:

Code: Select all

"02/01/2015","","DEBIT","HLU*Hulu 25683027-U HULU.COM/BILL CAUS","-7.99","",""
"02/02/2015 00:00:00","","DEBIT","SOUTHGATE CINEMA GRANTS PASS ORUS","-8.5","",""
"2/3/2015","","DEBIT","ANC*Ancestry.com 800-2623787 UTUS","-19.99","",""
All records have been successfully imported.
The changes will be available in the next release (next weekend).

Thank you for your cooperation.
mynetdude
New MMEX User
Posts: 9
Joined: Tue Jan 12, 2016 10:34 pm
Are you a spam bot?: No

Re: CSV import

Post by mynetdude »

Nikolay wrote:I've fixed the bug with date parsing.

https://github.com/moneymanagerex/money ... 70f2259de3

I've tested the code with this csv file:

Code: Select all

"02/01/2015","","DEBIT","HLU*Hulu 25683027-U HULU.COM/BILL CAUS","-7.99","",""
"02/02/2015 00:00:00","","DEBIT","SOUTHGATE CINEMA GRANTS PASS ORUS","-8.5","",""
"2/3/2015","","DEBIT","ANC*Ancestry.com 800-2623787 UTUS","-19.99","",""
All records have been successfully imported.
The changes will be available in the next release (next weekend).

Thank you for your cooperation.
Way cool! 

I'm looking forward to getting this going soon, as soon as I can do all that I can donate! I hope to see attachments become available for the android version someday too :) 
Post Reply