Export Global IP Pools from Cisco DNA-C and then Import to Smartsheet
Because many people still likes XLS files with their IP Pools :) Smartsheet offers history change.
- Export Cisco DNA-C to CSV File
- Export Smartsheet to CSV File
- Import to Smartsheet from CSV File
- Search for Smartsheet (ID)
This is Cisco Sample Code!
Cisco Products & Services:
- Cisco DNA Center
- https://sandboxdnac.cisco.com (or use your own)
Third-Party Products & Services:
- Smartsheet
Tools & Frameworks:
- Python3
- Smartsheet Python SDK
- Docker (optional)
python run.py -h
usage: run.py [-h] [--export-from-dnac EXPORT_FROM_DNAC]
[--import-to-smartsheet IMPORT_TO_SMARTSHEET IMPORT_TO_SMARTSHEET]
[--export-from-smartsheet EXPORT_FROM_SMARTSHEET]
[--search-smartsheets SEARCH_SMARTSHEETS]
cisco-dnac-ipam-smartsheet version 0.1
optional arguments:
-h, --help show this help message and exit
--export-from-dnac EXPORT_FROM_DNAC
CSV export from Cisco DNA-C
--import-to-smartsheet IMPORT_TO_SMARTSHEET IMPORT_TO_SMARTSHEET
Import CSV file to Smartsheet
--export-from-smartsheet EXPORT_FROM_SMARTSHEET
CSV export from Smartsheet
--search-smartsheets SEARCH_SMARTSHEETS
Search sheets based on value
Sample file is ipam.csv
"Name","IP Subnet Mask","Gateways","DHCP Server","DNS Server","Overlapping"
"Global_Pool","192.168.0.0/16","['192.168.1.1']","[]","[]","False"
"Overlay","172.17.0.0/24","['172.17.0.254']","['10.10.0.1', '10.10.0.2']","['10.1.1.1', '10.2.1.1']","False"
"Overlay-Second","172.17.1.0/24","['172.17.1.254']","['10.10.0.1']","['10.1.1.1']","False"
"test01","10.0.0.0/16","['10.0.0.1']","[]","[]","True"
"test02","172.16.0.0/24","['172.16.0.1']","[]","[]","False"
"Underlay","10.10.0.0/16","['10.10.0.1']","['10.10.0.1']","['10.10.0.2']","True"
git clone https://github.com/robertcsapo/cisco-dnac-ipam-smartsheet
pip install -r requirements.txt
Edit settings for Smartsheet / Cisco DNA-C
vim run.py
run.py
''' Smartsheet API Token '''
access_token = "Changeme"
''' Cisco DNA-C Login '''
dnacHost = "sandboxdnac.cisco.com"
dnacUser = "devnetuser"
dnacPass = "Cisco123!"
Start
docker run -it robertcsapo/cisco-dnac-ipam-smartsheet /bin/bash
Edit settings for Smartsheet / Cisco DNA-C
vim run.py
Run code
python run.py
- Robert Csapo [email protected]
Inspiration from https://github.com/tdorssers/dnac
This project is licensed to you under the terms of the Cisco Sample Code License.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent