topic Re: Python import csv API in Network Platform API

Python import csv API

What In the — Tue, 02 Apr 2024 20:40:32 GMT

I am trying to import a csv of switch port configs.

I am able to print the csv from the below script

def read_csv_to_dict_list(filename):

data = []
with open(filename, 'r') as csvfile:
reader = csv.DictReader(csvfile)
for row in reader:
data.append(row)
return data


data = read_csv_to_dict_list("C:\\temp\\Sample Switch.csv")

# Access data
for row in data:
print(f"Port: {row['portId']}, Name: {row['name']}, Tags: {row['tags']}, Type: {row['type']}, Vlan: {row['vlan']}, VoiceVlan: {row['voiceVlan']}")"

how do I use this with "updateDeviceSwitchPort"

Re: Python import csv API

aleabrahao — Tue, 02 Apr 2024 20:47:06 GMT

Take a look on those links.

https://github.com/meraki/automation-scripts

https://github.com/meraki/automation-scripts/blob/master/update_ports.py

Re: Python import csv API

Rasmus Hoffmann Birkelund — Wed, 03 Apr 2024 05:50:44 GMT

You'll need to reference each field, individually.

Based on your print statement, something like

destSerial = 'Q2QN-9J8L-SLPD'

for row in data:
    response = dashboard.switch.updateDeviceSwitchPort(
        destSerial, row['portId'], 
        name=row['name'],
        tags=row['tags'],
        type=row['type'],
        vlan=row['vlan'], 
        voiceVlan=row['voiceVlan']
    )

Re: Python import csv API

What In the — Wed, 03 Apr 2024 14:37:38 GMT

Thank you.

I get an error

line 41, in <module>
serial, Port=row["portId"],
~~~^^^^^^^^^^
KeyError: 'portId'

** I changed the serial line. I have the SN as a variable already

Re: Python import csv API

aleabrahao — Wed, 03 Apr 2024 14:47:30 GMT

The error message KeyError: 'portId' indicates that the key 'portId' is not found in the dictionary row. The CSV file does not have a column named 'portId'. You need to check the CSV and ensure that the column names match the keys you are using in your code.

Re: Python import csv API

What In the — Wed, 03 Apr 2024 14:53:32 GMT

line 1 of the csv is Port,name,tags,type,vlan,voiceVlan

**Edit** I updated the csv. was getting confusing.

If I print the dictionary keys..

dict_keys(['Port_num', 'Port_name', 'Port_tag', 'Port_type', 'Port_vlan', 'Port_voiceVlan'])

Re: Python import csv API

What In the — Wed, 03 Apr 2024 15:37:34 GMT

I figured it out, kinda

I had the dict keys swapped with the update switch API requirements

response = dashboard.switch.updateDeviceSwitchPort(
Serial, portId=row['Port_num'],
name=row['Port_name'],
type=row['Port_type'],
vlan=row['Port_vlan'],
)

I removed tags as it wants an array, and voiceVlan as it must be an integer or null

Re: Python import csv API

What In the — Thu, 04 Apr 2024 18:28:18 GMT

!!UPDATE!!

I got it to work.

I added an if statement to replace empty cells with None

def read_csv_to_dict_list(filename):
data = []
with open(filename, 'r') as csvfile:
reader = csv.DictReader(csvfile)
for row in reader:
if row['Port_voiceVlan'] == '':
row['Port_voiceVlan'] = None
data.append(row)
return data