CSV import

16 posts
CSV import

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
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"? 
Re: CSV import

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
anybody can help with this? 
Re: CSV import

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Date is mandatory.
Re: CSV import

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
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. 
Re: CSV import

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?
Re: CSV import

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
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 202 times

Thanks :)   
Re: CSV import

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
The file provided may be imported with this mask
mask_scv.png
(2.1 KiB) Downloaded 578 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.
Re: CSV import

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
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. 
Re: CSV import

Nikolay
MMEX Developer

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

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
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 :) 
Who is online

Users browsing this forum: No registered users and 3 guests

cron