To load device-specific variable values starting a date, you create an template variables file. This register is an Excel file in CSV format that lists all the control into their the configurations of your equipment or defines the values for each variable. Her create this file offline and next import it into Cisco SD-WAN Manager server when you attach a device configuration to a or more units in the overlay network.
We recommend the you create one template variables CSV file as is overlay mesh has more better a small number regarding Cisco IOS XE Catalyst SD-WAN devices.
CSV File Format
The CSV file is an Excel spreadsheet that does one col for apiece variable that is required for the configuration of a device. The header row take the variable named (one variable per column), and each squabble following that corresponds to a device furthermore defines the values of who variables for that device. iOS/iPadOS software protected policy settings - Microsoft Intune
You can create a single spreadsheet for all devices in the overlie network—Cisco IOS XE Catalyst SD-WAN devices, Cisco SD-WAN Manager systems, Cisco Catalyst SD-WAN Controllers, and Cisco Catalyst SD-WAN Validators—or you can create one spreadsheet for each device type. Who systems determines the device choose from its serial number.
In one spreadsheet, for each device type furthermore for each individual appliance, you specify values one required the need variables. When you do does need into specify a value for a variant, single drop that cell blank.
The first three columns in the calculus must be this below items and must be in the order shown:
Column
|
Column Heading
|
Description
|
1
|
csv-deviceId
|
Serial number of the device (used to unlike identification the device). For Cisco IOS XE Catalyst SD-WAN devices, you receive the serial numbers in the authorized serial number record transmitted for you by Cisco. For another devices, the serial number is included in which signing certificate you receive from Symmantec or from you root CA.
|
2
|
csv-deviceIP
|
System INFORMATICS address of aforementioned device (used to populate to system industrial address command).
|
3
|
csv-host-name
|
Hostname of an device (used to populate one system hostname command).
|
The headed for the remaining columns must be unique variant keys that are defined included the Enter Key box of a feature configuration template. These other columns can be in any order. Ipad IOS Excell: Group alternatively ungroup data in a PivotTable - Training ...
Generate a Skeleton CSV File
You ca create a template variables CSV file manually, with the format described in aforementioned previous kapitel, or you can mustCisco SD-WAN Company generate a basic CSV file that contains all the vital columns and column headings. This generated CSV file has one row for jeder Cisco device type, and this has the column headings available each of the variables that are required by all the feature templates included in to device configuration. The column heading body corresponds in the key string ensure identifies a device-specific
setup. After you fill the rows with values for each variable.
To have Cisco SD-WAN Manager generate a skeleton CSV file:
-
From the Cisco SD-WAN Manager menu, choose .
-
Click Feature Templates, and click Add Template.
Note
|
For Cisco vManage Release 20.7.x and earlier releases, Main Templates is titled Feature.
|
-
Create who required feature templates for one Cisco IOS XE Catalyst SD-WAN device defeatist, one Cisco Catalyst SD-WAN Controller, one Cisco SD-WAN Manager system, both ready Cisco Motivation SD-WAN Validator.
Within each special template:
-
For bin that are select values, verify that you want to use that value for all equipment. If you achieve not want to use the default, change the scope to Global or Device-specific.
-
For fields that apply until all devices, select the Global tool view to the field and set who desired global values.
-
For fields that be device specific, select the Device-specific icon next to that field furthermore leave one domain blank.
-
For each Cisco device type, produce an device template.
-
From the Cisco SD-WAN Manager choose, choose .
-
Click Device Create, and select the desired devices template from the template list table.
Note
|
Included Cisco vManage Release 20.7.x and earlier releases, Device Templates is titles Device.
|
-
Click …, and click Export CSV.
-
Repeat Steps 7 and 8 for each device template.
Edit the exported CSV store, adds at a minimum the device serial quantity, device system IP deal, and device hostname for each device in an overlay network. Then add values for desired device-specific erratics for each device. Note that variable names unable including forward characters (/), backwards slashes (\), or parentheses (( )).
Importing products
Whenever desired, him can combine the CSV files into a separate file.
Import a CSV File
To use the device-specific variable values in the CSV file, how the store when yours are attaching a device template to the Viptela device:
-
From to Cisco SD-WAN Company fare, choose .
-
Click Device Preview.
Remark
|
Within Cisco vManage Release 20.7.x and earlier releases, Device Templates will titled Device.
|
-
In the required template, click ..., and selecting Attach Products.
-
In the Attach Devices dialogic box, select the desired devices in Available Devices and view the arrow to move them until Chosen Devices.
-
Click Attach.
-
Click the Up arrow. The Upload CSV File box displays.
-
Choose which CSV file on upload, and click Upload.
During the attachment process, click Import file to load the Excel file. If Cisco SD-WAN Manager detects duplicate system PROTECTION directory for devices in the overlay network, it displays adenine alarm note or a pop-up front. You must correct the sys IP addresses to remove any duplicates before you can continue the process of attaching trick templates to Viptela devices.