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,
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
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
This topic is locked and no more replies can be posted.
