iotcreators.com web
    • Login
    • Search
    • forum.iotcreators.com
    • docs.iotcreators.com
    • Tags
    • Popular
    • Recent
    • Register

    Batch import Excel/csv

    iotcreators.com portal & API
    import batch csv excel batch import automate automated
    4
    12
    269
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L
      Lauwie007 last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • Uta
        Uta iotcreators.com team last edited by

        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

        1 Reply Last reply Reply Quote 0
        • L
          Lauwie007 last edited by

          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 1 Reply Last reply Reply Quote 0
          • Uta
            Uta iotcreators.com team @Lauwie007 last edited by

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

            L 1 Reply Last reply Reply Quote 0
            • L
              Lauwie007 @Uta last edited by

              @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 1 Reply Last reply Reply Quote 0
              • Uta
                Uta iotcreators.com team @Lauwie007 last edited by

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

                S 1 Reply Last reply Reply Quote 0
                • S
                  Stefan de Lange @Uta last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • Uta
                    Uta iotcreators.com team last edited by

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

                    L 1 Reply Last reply Reply Quote 1
                    • L
                      Lauwie007 last edited by

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

                      1 Reply Last reply Reply Quote 0
                      • L
                        Lauwie007 @Uta last edited by

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

                        1. Only the first 9 devices from csv are registered.
                        2. 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 1 Reply Last reply Reply Quote 0
                        • Uta
                          Uta iotcreators.com team @Lauwie007 last edited by

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

                          1 Reply Last reply Reply Quote 0
                          • Roland Baldin
                            Roland Baldin iotcreators.com team last edited by

                            @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

                            1 Reply Last reply Reply Quote 1
                            • 1 / 1
                            • First post
                              Last post