Batch import Excel/csv

Lauwie007

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?

Uta

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.
Regards, Uta

Lauwie007

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?

Uta

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

Lauwie007

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

Uta

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

Stefan de Lange

@Uta I agree with Lauwie007. It’s a little misleading, since ‘Excel file’ (.xlsx) and csv are both file formats…

Uta

The bugfix will be deployed Wed 7.7.21. Sorry for the delay

Lauwie007

Thats no problem, thanks for the update.
I have copy+pasted every device manually.
Wasn’t that much work for 100 devices.