Log in to ask questions, share your expertise, or stay connected to content you value. Don’t have a login? Learn how to become a member.
I have searched online on how to import Mist APs via a CSV file but found nothing, could someone provide a link to documentation on how this can be achieved?
There is no option for claiming AP's using a CSV file. Unless you have a file with a list of claim codes, then just cut copy and paste the codes…
AP's can be claimed in bulk using an activation code from your sales order, one code will claim all devices (AP's, switch's, Edges, WAN edges) and activate your paid subscriptions with just one entry. Useful for anywhere from one to thousands of devices.
Claim codes can be used to claim a device individually, multiple claim codes can be used at the same time to claim multiple devices. Useful for anywhere from one to dozens of devices.
The QR code on an AP can be scanned and will claim the AP using the App. Useful for one at a time, especially during installation and mounting, take pictures, set height and orientation, name the AP and place it on the map. App instructions Mist AI Mobile App - Mist
Everything can always be done via API calls.
After the fact, all devices claimed can be exported to a CSV file by going to Organization -> Inventory and clicking on the download button in the upper right-hand corner.
You probably read the doc, but for reference Claiming APs - MistHope this helps
Hi Fred, thank you for your reply. For a while there I thought I was being so clever using a bar code reader on the boxes of Mist APs to create a spread sheet with the same details as the export csv file. (Status,Name,MAC Address,Model,Site,Serial Number,SKU,Type) Now I find that this is a waste of time and even if I added the activation code into the spreadsheet somewhere, there is still no means to import these APs into the Mist website. Surely I am not the first person wanting to do a large import of APs into Mist in this way. As well I not sure what the advantage of claiming a 1000 APs is when I still have to go through and touch each and every one them, coping and pasting their names from a my spreadsheet on to the website. ( I did see how to use the subnet to assign APs to a site). Nonetheless, this doesn't sound like an efficient way to do a bulk in load of large number of APs, it sounds like the existing methodology is design for small business or for home use and not for bigger deployments. So until the option of claiming APs, using a CSV file, is created and it needs to be created, I will remain unimpressed with Mist Cloud website. In regards to API calls that can do everything, where do I find them, again am I the first person wanting to do a single touch bulk import of APs?
Chris,There is an Activation Code that gets created and sent to partners and customers when APs are purchased. All APs on the P.O are tied to that Activation Code. The Activation code can be entered in the Mist Interface and will onboard all APs are part of that P.O. This works for 1 to XXXX number of APs. No need to create a CSV file to do this. We have multiple ways to onboard APs because partners and customers have multiple use cases/processes for doing so. Even if you use the Activation Code to onboard the APs you can still use the Mist AI app to deploy them by scanning the QR code. Hope this helps with your use case.See this link for more detail: Claiming APs - Mist
Hi Mike, no it does not help with my case. My point is that even though there are multiple ways to onboard APs to suit the multiple use cases/processes customers have, there isn't a single touch method where the customer can upload a csv file with the Activation code, Name, MAC Address, Model, Site, Serial Number, SKU and Type. Where a customer can upload XXXX number of APs that have all the necessary information about them, so that when an AP connects, it knows what site it is in, what name it has and can acquires any other information it needs to start operating and without any further input. It just seems overly complicated going through the process of claiming, activating, working out AP naming formulas, matching those formulas with MAC addresses, and setting a site subnet association, when a csv file with all that information could be imported. Again, I am not the first one to have thought of this and probably not the only one wishing it existed when, for the first time, on boarding APs in Mist.
Thank you for your response, you have answered my question.
When you acquire the APs from Juniper, you get a list about the claim codes associated to serial numbers. You can make CSV file from the list easily.Other method is to hire a staging company that collect all the information for you.
To follow up, I thought your original challenge was just claiming the AP's, as mentioned there are a number of easy ways to do this at scale, adding the activation code or claim codes gets the AP's imported to the Mist website.
Reading between the lines it sounds like you are wanting to automate the naming of the AP's? Often people will simply use the App to name and assign the AP to each site when its being mounted to the ceiling. This has the benefit that the installer can grab any AP set it and name it accordingly without worrying about which MAC gets which name.
There are a number of ways you can bulk rename the AP's AP Naming - Mist or you can go to the AP itself as you have mentioned and name them one by one.
You can also name the AP based on the LLDP configuration of the switch port Auto-Provisioning - Mist in my opinion, I would spend more time configuring the switch instead of just renaming the AP.
The API is as powerful as you can make it, using Python scripts and programing logic you can create a unique and custom name for everything. The API docs can be found by going to the upper right hand corner and clicking the question mark and then selecting the API Docs. Home | API | Mist direct link, but requires you to be logged in.
There are some advanced examples at Mist Systems's Public Workspace | Postman API Network these are Runner Collections in postman, one that you might be interested in is update device(group) -> Device Naming where you can reference a csv file formatted as: device_name,mac_address perhaps something like this would allow you to use your spreadsheet with MAC/name combos if you decide to go that route. I am bit out of my depth to help much further here though.
Hope that clarifies a few things.
Guys, I am not trying to be argumentative, but you are missing my point. What I am trying to get across is that it is relatively easy for a less experience person to create a CSV file of XXXX amount of Mist APs. Then within that same spreadsheet to give each of those APs a site and a name. What is not simple, or simply does not exist, on the Mist website, is the ability to upload or import such a CSV file. Yes, I agree and recognise that the Mist website has many tools that can do many things, such as AP naming, Auto-Provisioning and API. Nonetheless, what the Mist website cannot do is import a CSV file with the Activation code, Name, MAC Address, Model, Site, Serial Number, SKU and Type for XXXX amount of APs. I believe creating such a CSV file is far easier than learning how to use APIs (Mist account required) or rapping one's head around the methodology for AP naming or Auto-Provisioning. The process I am advocating, is that a person receives XXXX amount of APs, creates a CSV file, adds the Activation codes, logs on to the Mist Website, imports the CSV file, labels and deploys the XXXX amount of APs, logs back into Mist site and confirms that all the APs are connected. With this process there is no need to become an expert in API and Postman, or understand how to create AP names using LLDP configuration of a switch-port, or investing time and effort working out how to use Mist's AP naming or Auto-Provisioning. My point is the process provided by the Mist website is inefficient, time consuming and unnecessarily complicated, when it is compared to being able to import a CSV file. Once again, I cannot believe that I am the first person to point this out or requested this feature from Mist. Thank you all for your responses.
------------------------------Fred GlauserOriginal Message:Sent: 05-28-2023 18:55From: CHRIS DOOLANSubject: Importing Mist APs