cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Welcome to Cisco Firewalls Community


137
Views
0
Helpful
2
Replies
Highlighted
Cisco Employee

import of objects that creates an object-group,

I have a customer that has a question… Is there any way to do an import of objects that creates an object-group, via an excel sheet?

 

I have not found any documentation that would suggest or not a way,  I wanted to check with an expert resource to see..

 

My customer has about 250 URL’s that would need to added to a policy object group for example “OneDrive rule” or other cloud app and they are trying to find a way to do it without having to do it by each individual URL.

2 REPLIES 2
VIP Advisor

Re: import of objects that creates an object-group,

Hi there,

Save the Excel spreadsheet as a CSV and parse it in Python, run each line through a Jinja template representing an ACE and output the result to a text file to be pasted into the CLI. Or combine with the netmiko library and configure the device as part of the script.

 

About 30 lines of code. (use of Jinja may be a bit overkill, string.format() would be suitable)

 

Can you share part of the spreadsheet, or at least the format? I could write the script tonight.

 

cheers,

Seb.

Cisco Employee

Re: import of objects that creates an object-group,

Thanks very much... I am working to get this from the customer...