CSV import

16 posts
Re: CSV import

sterling
Super MMEX User

Posts: 82
Joined: Thu Dec 11, 2014 2:40 am
I found the amounts can't have symbols in the column either.
£123 will fail as well.
Re: CSV import

mynetdude
New MMEX User

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

Nikolay
MMEX Developer

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

Where do I find the next release? 
Re: CSV import

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Right here https://sourceforge.net/projects/moneymanagerex/files/moneymanagerex/Version_1.2.5

[link]
Re: CSV import

mynetdude
New MMEX User

Posts: 9
Joined: Tue Jan 12, 2016 4:34 pm
Nikolay wrote:Right here https://sourceforge.net/projects/moneymanagerex/files/moneymanagerex/Version_1.2.5

[link]
hey thanks :)I tried to find it on my own, thank you again :)  
Who is online

Users browsing this forum: No registered users and 17 guests

cron