I have imported a csv file but for some reason in some values the data after . is missing
If my value in csv is 0.5 it displays 0. and 5 went missing
but in my csv file i have value as 0.5
I don't what step i am missing on import.
I tried running csv import again but didn't helped.
I was saving my .ods file to .csv and don't know what was wrong with it but it always show me an error
Invalid column count in CSV input on line 1 Error.
I checked my column count and it was correct.
Then i tried Google spreadsheet and saved it as .csv and there it gets imported properly into database.
Solved but wasn't able to figure out the problem.