Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
620 Views 4 Replies Latest reply: Apr 19, 2013 6:36 AM by Troja RSS
Troja Champion 256 posts since
Aug 26, 2010
Currently Being Moderated

Apr 18, 2013 6:04 AM

IP-list import in MWG with comments not posssible?

Hi all,

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

 

IP;Comment

 

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?

 

Cheers,

Thorsten

Attachments:
  • feickholt Apprentice 51 posts since
    Nov 16, 2012
    Currently Being Moderated
    1. Apr 18, 2013 6:47 AM (in response to Troja)
    Re: IP-list import in MWG with comments not posssible?

    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

    xml format.

    Now you can add this file using append from file. Not really self-explaining, but it worked for us.

     

    Frank

     

    Nachricht geändert durch feickholt on 18.04.13 06:47:54 CDT
  • feickholt Apprentice 51 posts since
    Nov 16, 2012
    Currently Being Moderated
    3. Apr 19, 2013 2:08 AM (in response to Troja)
    Re: IP-list import in MWG with comments not posssible?

    This is the awk script we used

    list2xml.awk

     

    BEGIN {

    FS=";";

    print "<libraryContent> <libraryObject> <name>LISTNAME</name> <version>7.2.0.3.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=\"1.0.3.42\" mwg-version=\"7.2.0.3

    .0-13935\" name=\"GLB_EJournal\" id=\"com.scur.type.string.17105\" typeId=\"com.scur.type.string\" classifier=\"URLs\" systemList=\"false\" stru

    cturalList=\"false\" defaultRights=\"2\">\n<description></description>\n<content>"

    }

    {

    print "<listEntry>\n  <entry>"$1"</entry>\n  <description>"$2"</description>\n</listEntry>";

    }

     

    END {

    print "</content>";

    print "</list></entry></lists>";

    print "</libraryContent>";

    }

     

    Replace the print part wihtin the BEGIN section with your actual XML definitions.

     

     

    than

     

    cat yourdata.csv | awk -f list2xml.awk > list2import.xml

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 5 points
  • Helpful Answers - 3 points