Batch import Excel/csv
I want to import a batch of ±100 devices in IoT creators.
I want to import using a csv or Excel file, but can’t find any examples.
Is there a example for batch import that I can copy?
Hi @Lauwie007 unfortunately we’ve got a bug in the file upload and the bugfix is already on it’s way (see bug ticket IC-5133 - whatch this page to see when it is released). Maybe that’s why you got an error message.
Normally you create a csv file like this:
IMEI,PROTOCOL 44211***067,UDP 53910***691,UDP
The first line - header - is optional. Separator is comma.
Please make sure that protocol is identical for all IMEI.
UDP = UDP protocol
COAP = Neul Messaging protocol
Sorry for the inconvenience.
Thanks for the response Uta,
I tried the example you send, but I still get the error “Something went wrong while registering your devices. Please try it again.” Also when not using the header. So I’ll wait with the CSV file untill the bugfix is live.
The complete csv file I used:
IMEI,PROTOCOL 86151********51,UDP 86151********97,UDP
Also tried a excel file, but that also didn’t work.
Importing using a Excel file is also workable.
Do you have an example of a excelfile?
What rows/columns should I use?
@Lauwie007 our portal can only process plain text files with comma separated values. We can’t process Excel format unfortunately. I hope the fix will be deployed beginning of next week.
@Uta the portal states ‘Import CSV/Excel file’ so I assumpted Excel was supported.
Okay, good to know. Then I can continue with the project. Thanks for the help.
@Lauwie007 “Excel” means you need to choose “Save-as” in MS Excel and then choose the file format “CSV UTF-8 (comma seperated values)” as output format which then generates the plain text file “*.csv” from the selected spreadsheet in MS Excel.
@Uta I agree with Lauwie007. It’s a little misleading, since ‘Excel file’ (.xlsx) and csv are both file formats…
The bugfix will be deployed Wed 7.7.21. Sorry for the delay
Thats no problem, thanks for the update.
I have copy+pasted every device manually.
Wasn’t that much work for 100 devices.