Forum Discussion

Steve's avatar
Steve
Level 1.6: Donut
11 days ago
Solved

Unable to upload bulk CSV file to ZeroTouch

Hi Team,   Is there currently an issue uploading a bulk .csv file to ZeroTouch? It's giving me an error. See below.     Steps below: I downloaded the sample .csv file then updated it w...
Devices
EMM
Enrolment
Management
microsoft intune
Zero-touch
  • Steve's avatar
    Steve
    5 days ago

    Thanks Emilie_B​ Moombas​ Michel​ 
    I have figured out what the issue was, I wanted to do bulk deregister devices and I had the last field title in the csv file set to "userid" rather than "owner".
    Funny it was throwing an error saying Wrong file type.

Steve's avatar
Steve
Level 1.6: Donut
10 days ago

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.

 

 

Moombas's avatar
Moombas
Level 4.4: KitKat
10 days ago

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).