we are changing from Microsoft ISA to MWG. On ISA there are many lists with IP-adresses an with a comment why the IP is excluded from something.
This list can be exported in this way
When importing such a list into MWG only the IP-adresses can be imported, NOT the comment. In my case we want to import several lists with more than thousand entries.
Has anyone an idea how an IP list can be imported including comments?
We had the same problem. We tried to reimport our lists defined in our BlueCoat environement. We had also serveral comment to import
We used the following way. We wrote 2 lines in the list manually, exported it. You will get an XML File.
You can use this format as template to generate a file filled with your values. I used a litte AWK Script to convert a ;-separated file into the
Now you can add this file using append from file. Not really self-explaining, but it worked for us.
Nachricht geändert durch feickholt on 18.04.13 06:47:54 CDT
thanks for the information. This was also one possible way i thought about. :-)
Hmmm, do you have a tool or a script to for generating the XML File?
This is the awk script we used
print "<libraryContent> <libraryObject> <name>LISTNAME</name> <version>126.96.36.199.0-13935</version> <description>Created on Fri Nov 16 12:32:13 CET
2012</description> </libraryObject><lists><entry><string>com.scur.type.string.17105</string> \n<list version=\"188.8.131.52\" mwg-version=\"184.108.40.206
.0-13935\" name=\"GLB_EJournal\" id=\"com.scur.type.string.17105\" typeId=\"com.scur.type.string\" classifier=\"URLs\" systemList=\"false\" stru
print "<listEntry>\n <entry>"$1"</entry>\n <description>"$2"</description>\n</listEntry>";
Replace the print part wihtin the BEGIN section with your actual XML definitions.
cat yourdata.csv | awk -f list2xml.awk > list2import.xml
Thanks a lot!