Forums

Hi there,

I'm having trouble when exporting to CSV. I have stored ID numbers in the database (13 digits) which are stored correctly by choronoforms. When i use the export CSV option and open the CSV it shows "3.52E+12" instead of the 13 digit value. The same happens with some telephone number fields. I have tried changing the field type to text, char, varchar, int, bigint but still does not work.

I cannot seem to find a solution online therefore wondering if you could guide me.

thanks,

Hi 1rfan,

What are you opening the CSV in? I suspect that it is Excel which is auto-formatting the column. Please check the exported file in a plain text editor - hopefully you will see the full string there. If that is so then you need to set the column type in Excel to text - or something similar.

Bob