Forum | Appery.io

Hi,

I have been trying to import a collection from csv file.

All the number type fields in csv is getting imported as string in the collections.

Is there a workaround for this?

Is there a way to change the datatype of the column in a collection after importing data ?

I cant use json format.
reason - I cant risk my data on online csv to json file conversion sites.

thanks

Ram

Modelexam - are you sure they're set up in the collection as numbers and not strings? Also, any possibility that values are enclosed in e.g. quotes in the csv file?

Hi -

Please make sure that your .csv file contains such structure:
pre
"_id:string","acl:object","field:number"
"55a15b9ce4b0a016a272d1ac","","1.0"
"55a15b9de4b0a016a272d1ad","","2.0"
"55a15b9ee4b0a016a272d1ae","","3.0"
/pre

Thanks a lot...field:number --- this works now!!