topic Re: Bulk AP Naming from CSV or other source in Cloud Networking Platform

Bulk AP Naming from CSV or other source

roo54 — Fri, 26 Apr 2024 12:50:03 GMT

I have a bunch of sites that I have configured manually, which is OK up to about 100 APs then the time and effort to configure each AP gets a bit excessive. I now have to build a site with 350 APs and I don't want to use my time doing that many APs manually.

Is there a way to use a CSV file or similar,to input things like AP name, address, tags, etc, etc.

Thanks

Roo

Re: Bulk AP Naming from CSV or other source

Ryan_Miles — Fri, 26 Apr 2024 14:27:05 GMT

Perhaps give this option a look https://netprepare.com/blog/automate-meraki-device-renaming/

Re: Bulk AP Naming from CSV or other source

Rasmus Hoffmann Birkelund — Fri, 26 Apr 2024 18:48:56 GMT

With a file named "name.csv", that contains the following,

name,serial
ap1,xxx
ap2,yyy
ap3,zzz

You can use the following

#! /usr/bin/env python3

import meraki
import csv

def main():
    dashboard = meraki.DashboardAPI(suppress_logging=True)

    with open("name.csv") as csvfile:
        ap = csv.DictReader(csvfile, delimiter=',')
        for row in ap:
            # print(row['name'],row['serial'])
            print("Updating:",row['serial'])
            response = dashboard.devices.updateDevice(
                row['serial'], 
                name=row['name'], 
            )
            if response['name'] is row['name']:
                print("Success!")

if __name__ == "__main__":
    main()