SOLVED ! CSV export, some datas in fields are wrong

Hi,
In my form, users have to edit ages of children they have in school or day care centre

if user edit : 6-10 (to say age between 6 and 10)
csv export gives : 6/10/12 or sometimes 01/06/10

if user edit : 3-17
csv export gives : 01/03/17

When user add "years old" (in french "ans") : no problem.
or "03 to 12" (french "3 à 12"): no problem

I think csv export translates the field as if it was a date field when you have only numbers and dash in it.

Any fix for that ?
thanks

Hi Repitol,

I don't think that CSV Export will change anything like this, it doesn't look at the type of data at all.

What do you see when you open the .csv file in a text editor?

It's much more likely that this is happening when you open the file in Excel. (Or just possibly you are saving the data in columns of type DATE in the database).

Bob

Damn ! You're right again !! 😀
when I open csv in Excel or OpenOffice, these programs first ask for the column separation (coma, space, etc.)
Then, csv is opened and datas are modified automatically as described in my post.

Hi Repitol,

I think that if you mark those columns as 'text' in the import process then they will keep the original formatting.

Bob