Python Script for All Networks

[KRobert]

Does anyone know what they best way is to grab all of the networks in an organization and print or write them to an excel file all within a python script? 

I am trying to grab a list of Network Names and their Network IDs and write them to a excel file to represent a dictionary key:value pair. 

I can grab the Networks using the dashboard.organizations.getOrganizationNetworks(organization_id, total_pages='all') string, but I am having trouble sending this data to an excel file. 

Thank you,

[sungod]

I use openpyxl to create excel files, instructions and tutorial are here...

https://openpyxl.readthedocs.io/en/stable/

[AutomationDude · Accepted solution]

Hello good sir, I recorded a video that explains exactly how to do this for the API course I made. Here's the link:

https://www.youtube.com/watch?v=kfTtEUotXCI&t=125s&ab_channel=BoundlessDigital

[KRobert]

Hey @AutomationDude That was what I was looking for! Thank you. Now any idea on what script I can write to read the file? I am trying to create a program that allows you to input a Network Name and correlate the network name to it's Network ID in a dictionary Key:Value pair. Once the program has the Network ID, it can start making changes to the network. In the csv that was created, I need the program to understand that a user input (Key) should equal Column C (Name) and the program should print the Network ID as the value, Column A. 

[AutomationDude]

Hey @KRobert, you're welcome!

I've never written anything for exactly what you described but did have this video that creates new networks from a csv file:

https://www.youtube.com/watch?v=Jbb3sxcxQ0A&t=312s&ab_channel=BoundlessDigital

I'm guessing you were having some trouble working with variables that were read from the csv so this should hopefully give you some insights that move you in the right direction. Best of luck!

[KRobert]

@AutomationDude we are getting closer! With the following, I am able to print the "name" and "id" field of the network list csv. This narrows the data to just those two fields, which I need for the script. 

with open('networks.csv', 'w') as new_file:
    csv_writer = csv.DictWriter(new_file, Networks[0].keys())
    csv_writer.writeheader()
    csv_writer.writerows(Networks)


with open('networks.csv', 'r') as read_file:
    csv_reader = csv.DictReader(read_file)
    for line in csv_reader:
        print(line['name'],line['id'])

Now I need to find a way to correlate the data so that when a user input types 'name', it prints 'id'.

Any ideas on how to do that? 

[AutomationDude]

Hmm, not sure what you're missing here since you've got all the data. Could you try rephrasing the use case or the issue?

[KRobert]

A user is supposed to input data. When the user inputs a network name, let's just say "Test123" the program then takes the name "Test 123" and checks the list of network names in the csv. If it finds "Test123" in the csv, it prints the corresponding network id for Test123. My goal is to rather than print the network id, save it as a variable to use later in the script 

[KRobert]

@AutomationDude I published a clean version to my GitHub. It is a framework, but I am trying to replace the Dictionary Steps with the CSV setup you helped me with. 

https://github.com/routercuriosity/MerakiNetworkUpdater

[NesAlba]

@KRobert Try this script 

https://github.com/NesAlba21/Meraki_Tshoot

 I think this is what you are looking for