CSV import

General discussion on all other topics under the sun.

Moderator: Renato

sterling
Super MMEX User
Posts: 72
Joined: Thu Dec 11, 2014 8:40 am
Are you a spam bot?: No

Re: CSV import

Post by sterling »

I found the amounts can't have symbols in the column either.
£123 will fail as well.
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 »

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 
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 »

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
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.
Where do I find the next release? 
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 »

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 »

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