Security

last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).

Bradford Networks to Clearpass Endpoint Conversion Script - CSV to XML

This thread has been viewed 3 times
  • 1.  Bradford Networks to Clearpass Endpoint Conversion Script - CSV to XML

    Posted Jul 29, 2015 01:17 PM
      |   view attached

     

    We needed to convert ~500 or so guest and conference device registrations from Bradford Networks to Clearpass so as not to require folks to have to re-register when we introduced Clearpass.  The attached script will accept a CSV input file (could be from Bradford Networks or somewhere else) and create an XML output file in the <Endpoint> XML tag format currently required by Clearpass.

     

    Note that in our case we had a series of conference ID's that indicated which conference the device was affiliated with.  If a device was not affiliated with any conference, we indicated this with a 'NOID' entry in that column, so if you do not have any conference IDs and just a list of clients, be sure to have 'NOID' in the User-Title field within the import CSV.

     

    Steps/instructions are included in the attached .pl script.

     

    Attachment(s)