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.
@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.
Is this a issue on my side, or are you experiencing the same?
Or was I not patient enough?
@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.
@Lauwie007 Can you please send your IMEIs to firstname.lastname@example.org? I like to analyse the problem in more depth and fix it.
Many many thanks for your support!