Difference between revisions of "Exporting rules to Excel"
From Tech-Wiki
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
#In the Web GUI select Device > Setup > Operations and click on Export Named Configuration Snapshot | #In the Web GUI select Device > Setup > Operations and click on Export Named Configuration Snapshot | ||
| − | |||
#From the pop-up menu select running-config.xml, and click OK | #From the pop-up menu select running-config.xml, and click OK | ||
| − | |||
#Now edit the xml file and remove all tags '''until the first''' <security>, and also remove all tags '''after''' </security> | #Now edit the xml file and remove all tags '''until the first''' <security>, and also remove all tags '''after''' </security> | ||
| − | |||
#Add a header: <?xml version="1.0" encoding="UTF-8"?> | #Add a header: <?xml version="1.0" encoding="UTF-8"?> | ||
| − | + | #Now do remove the following tags doing search and replace for the keyword <member> and </member> with blank (nothing) | |
| − | #Now do | + | |
| − | + | ||
#Save as policy.xml | #Save as policy.xml | ||
| − | |||
#Open a new Excel Spreadsheet and click on MenuBar DATA > From Other Sources > From XML Data import | #Open a new Excel Spreadsheet and click on MenuBar DATA > From Other Sources > From XML Data import | ||
| − | |||
#To improve visualisation, replace “ “ (space) with blank (nothing) | #To improve visualisation, replace “ “ (space) with blank (nothing) | ||
| − | |||
#To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml. | #To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml. | ||
| − | |||
#Search for tag <address-group> and delete all the text '''before''' this tag and also delete all the text '''after''' the tag </address-group> | #Search for tag <address-group> and delete all the text '''before''' this tag and also delete all the text '''after''' the tag </address-group> | ||
Latest revision as of 19:31, 20 September 2016
- In the Web GUI select Device > Setup > Operations and click on Export Named Configuration Snapshot
- From the pop-up menu select running-config.xml, and click OK
- Now edit the xml file and remove all tags until the first <security>, and also remove all tags after </security>
- Add a header: <?xml version="1.0" encoding="UTF-8"?>
- Now do remove the following tags doing search and replace for the keyword <member> and </member> with blank (nothing)
- Save as policy.xml
- Open a new Excel Spreadsheet and click on MenuBar DATA > From Other Sources > From XML Data import
- To improve visualisation, replace “ “ (space) with blank (nothing)
- To export Address-Groups, generate a new copy of running-config.xml and save it as address-group.xml.
- Search for tag <address-group> and delete all the text before this tag and also delete all the text after the tag </address-group>