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.

Lauwie007

@uta Hey Uta, I’m reviving this old thread.
I tried registering devices with csv today, but I encountered 2 bugs

Only the first 9 devices from csv are registered.
The interface remains white (page not responding) after registering the devices
I refreshed the page, and the new devices do appear.

Example csv:
8615180405XXXXX,UDP
8615180405XXXXX,UDP
8615180405XXXXX,UDP
8615180405XXXXX,UDP
8615180405XXXXX,UDP
ETC

Is this a issue on my side, or are you experiencing the same?
Or was I not patient enough?

Uta

@lauwie007 sometimes the page needs a refresh after an device bulk registration of devices (csv batch import), I guess this can be caused by a slow internet connection.

I’m going to check tomorrow if I can reproduce this error and if there’s something wrong.

Roalnd Baldin

@Lauwie007 Can you please send your IMEIs to support@iotcreators.com? I like to analyse the problem in more depth and fix it.
Many many thanks for your support!
Regards, Roland