CSV import
Moderator: Renato
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
CSV import
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"?
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"?
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
anybody can help with this?
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: CSV import
Date is mandatory.
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
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 wrote:Date is mandatory.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: CSV import
Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?
Could you please upload csv sample file?
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
sure! here it is ThanksNikolay wrote:Sorry for misundestanding. I'll check, it seems like a bug.
Could you please upload csv sample file?
You do not have the required permissions to view the files attached to this post.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: CSV import
The file provided may be imported with this mask
If dates will be "02/01/2015" it will be imported.
Will see how to import this dates.
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.
You do not have the required permissions to view the files attached to this post.
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
Nikolay:The file provided may be imported with this mask
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.
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.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: CSV import
I've fixed the bug with date parsing.
https://github.com/moneymanagerex/money ... 70f2259de3
I've tested the code with this csv file:
All records have been successfully imported.
The changes will be available in the next release (next weekend).
Thank you for your cooperation.
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","",""
The changes will be available in the next release (next weekend).
Thank you for your cooperation.
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
Way cool!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:
All records have been successfully imported.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","",""
The changes will be available in the next release (next weekend).
Thank you for your cooperation.
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
-
- Super User
- Posts: 72
- Joined: Thu Dec 11, 2014 8:40 am
- Are you a spam bot?: No
Re: CSV import
I found the amounts can't have symbols in the column either.
£123 will fail as well.
£123 will fail as well.
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
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 weekendsterling wrote:I found the amounts can't have symbols in the column either.
£123 will fail as well.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: CSV import
I think it may be fixed using regex.sterling wrote:I found the amounts can't have symbols in the column either.
£123 will fail as well.
I've registered a feature request.
https://github.com/moneymanagerex/money ... issues/659
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
Where do I find the next release?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:
All records have been successfully imported.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","",""
The changes will be available in the next release (next weekend).
Thank you for your cooperation.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
-
- New User
- Posts: 9
- Joined: Tue Jan 12, 2016 10:34 pm
- Are you a spam bot?: No
Re: CSV import
hey thanks :)I tried to find it on my own, thank you again