How can I specify the data types for the columns in a CSV I upload?
Accepted Solutions
I just did a simple test to load the csv from my computer and when I do so, it allows me to change the data format that it will apply to the fields. See the interface below (sorry for the Spanish text). As you can see the field campaign_id is detected as integer field:
When I click on the field type, I can set it to Text:
The resulting service seems to be correct if I validate the field type at the REST endpoint:
So, I tried a few different configurations for the campaign_id and run_id .
<<Note: I'll leave what I started writing below, but I don't think this is an option, since it is no better than the results you were getting above, that is, not wanting to put in a fake value....although you would probably only have to do it for the first line. This may give you or others a better idea.>>
Although this may not be an option, it did stick as a string if I put a ' (single quote) in front, and left off the double quotes completely. A single quote in Excel is seen as a align-left (if I remember correctly) and therefore is invalid for a numeric field. I'm assuming it is now a sctring since if I go into the configure pop-up and then the configure attributes, it shows it as a "single line"
I used my own coordinates so I could show it on my base map, but this is the input of my .csv file. I found that if I opened it in Excel to make it easier to change, then it didn't work, so I was editing in Notepad++
operator_id,line_id,campaign_id,run_id,CreationDate,Creator,EditDate,Editor,Longitude,Latitude
operatorName,lineName,'1,'2,2/16/2018 21:44,userName,2/16/2018 9:44,UserName,-154.244467,64
operatorNam2,lineNam2,'1,'2,2/16/2018 21:44,userName,2/16/2018 9:44,UserName,-154.244467,64NOTE: the pop-up doesn't show the single quote, but it does seem to show when viewing the attribute tables...so this may not help any.
There is likely a better way to do this, but if in a hurry, that might be a quick fix.
Hi, the single quote does not work, I tried it too. ArcGIS throw an exception and I suppose that is because '1 is not a valid value for the domain of the field, that is "1", "2", for example. I neither can use a first row as dummy to specify the data types because the uploading fails due to the domain of the select_one field.
I probe with a single quote in another string field that is text and the value stored is textually '1, and it is an invalid value for the select_one field.
So, I thing that I'll have to change the values for the domain to alpha-numeric string but it mean that I'll have to update the other apps that uses the feature service too.
Other problem that I've had is that the coordinates doesn't are recognized, the system change the values to a non valid latitude and longitude, I don't know which is the correct format for the coordinates.
I don't know if because the feature layer was created from a survey of Survey123, It works different and has these troubles that if the feature was created with another method.
Best Regards.
I just did a simple test to load the csv from my computer and when I do so, it allows me to change the data format that it will apply to the fields. See the interface below (sorry for the Spanish text). As you can see the field campaign_id is detected as integer field:
When I click on the field type, I can set it to Text:
The resulting service seems to be correct if I validate the field type at the REST endpoint:
I never thought about using the "Add Item" from computer. I was draggin and dropping or just adding in the map itself. I think you have the answer xander_bakker . That worked for me too (in English even. 
)
