Forum Discussion
Unable to upload bulk CSV file to ZeroTouch
You need to ensure the field names (headline) are correct and you set all the , in the correct way and amount. Have had same issue some weeks ago because of that.
Example which works fine:
"modemtype","modemid","serialnumber","manufacturer","model","profiletype","profileid"
"IMEI","1234567890123456","","LENOVO","","ZERO_TOUCH","012345678"Don't care about the empty columns as i generate this by a script and there i can have devices with SNR and without IMEI which require different columns which can be left empty if not needed.
And i also think i remember that the file must be named with .csv at the end, not .txt or so, even if the format inside of it is correct.
And just for verification, it works still fine on my side:
Thanks Moombas, the issue is with the file extension not being accepted even though it is a .csv file. The file content is fine, see below an e.g of my file content.
I have used the same field before with no issues.Strongly Recommendation: Don't use Excel for csv files except you take care of every field seriously and very carefully!
Especially the thing you see in column 2 can cause issues, depending on the Excel version, it cuts the last number of the IMEI and replaces it with a 0 (1234567890123456 -> 1234567890123450) causing all IMEIs being wrong (this field and the modemid2 should be defined as a text field).
Also ensure it's in the correct format as shown above in my post or documentation and correct encoding (I guess UTF-8) and the correct delimiters (,) need to be used and so on.
I recommend the use of Notepad++ (or similar alternatives) for viewing and fast edit and an external small program to generate such a file based on a "data" file (like a delivery note).
