CSV import

[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]

anybody can help with this? 

[Nikolay]

Date is mandatory.

[mynetdude]

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]

Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?

[mynetdude]

Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?

sure!  here it is

export (1).csv

(1.39 KiB) Downloaded 482 times

Thanks   

[Nikolay]

The file provided may be imported with this mask

mask_scv.png (2.1 KiB) Viewed 5029 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]

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]

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]

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  

[sterling]

I found the amounts can't have symbols in the column either.
£123 will fail as well.

[mynetdude]

I found the amounts can't have symbols in the column either.
£123 will fail as well.

That has nothing to do with this; the CSV import failed because the date format did not match anything the software was already capable of doing, we should be seeing a desktop update here shortly this weekend  

[Nikolay]

I found the amounts can't have symbols in the column either.
£123 will fail as well.

I think it may be fixed using regex.

I've registered a feature request.

https://github.com/moneymanagerex/money ... issues/659

[mynetdude]

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.

Where do I find the next release? 

[Nikolay]

Right here https://sourceforge.net/projects/moneym ... sion_1.2.5

[link]

[mynetdude]

Right here https://sourceforge.net/projects/moneym ... sion_1.2.5

[link]

hey thanks :)I tried to find it on my own, thank you again