topic Problems to import CSV endpoints to ISE in Network Access Control

Problems to import CSV endpoints to ISE

jimontoro — Fri, 21 Feb 2020 18:59:34 GMT

Hello, everyone

we can´t import csv file to ISE. We use the template with the form:

IM Renderer Page

MACAddress,EndPointPolicy,IdentityGroup,PortalUser.GuestType,Description,PortalUser.Location,PortalUser.GuestStatus,StaticAssignment,User-Name,DeviceRegistrationStatus,PortalUser.CreationType,AUPAccepted,PortalUser.EmailAddress,PortalUser.PhoneNumber,FirstName,ip,Device Type,host-name,StaticGroupAssignment,MDMEnrolled,MDMOSVersion,PortalUser.LastName,PortalUser.GuestSponsor,EmailAddress,PortalUser,PortalUser.FirstName,BYODRegistration,MDMServerName,LastName,MDMServerID,Location
50:12:33:44:55:66,,vlan501,,,,,,,,,,,,,,,,,,,,,,,,,,,,

is this form right?

ISE is not able to import the endpoints (attach error)

Please, Could anyone help us?

Thanks!

Re: Problems to import CSV endpoints to ISE

balaji.bandi — Thu, 28 Jun 2018 07:16:33 GMT

Make sure you have CSV valid format to import.

Re: Problems to import CSV endpoints to ISE

jimontoro — Thu, 28 Jun 2018 08:56:44 GMT

the file has the ise template´s format:

we use three columns, and the other in blank.

Re: Problems to import CSV endpoints to ISE

Rob Ingram — Thu, 28 Jun 2018 09:34:10 GMT

Which 3 columns are you using? The error messages indicates "IdentityGroup" is invalid....so I'd suggest ensuring that the endpoints you are importing have been defined with a valid group.

Re: Problems to import CSV endpoints to ISE

jimontoro — Thu, 28 Jun 2018 10:01:38 GMT

Sorry, we are using 2: MACAddress,,IdentityGroup

Re: Problems to import CSV endpoints to ISE

Rob Ingram — Thu, 28 Jun 2018 10:10:23 GMT

Ok, can you provide an example of what you are attempting to import?

Re: Problems to import CSV endpoints to ISE

jimontoro — Thu, 28 Jun 2018 10:17:23 GMT

I attach an example.

Re: Problems to import CSV endpoints to ISE

Rob Ingram — Thu, 28 Jun 2018 10:24:48 GMT

So if I import your CSV as you have it, I get the exact same error - which I'd expect as I dont have your Identity Group "huva-vlan501".

If I modify the group to a default ISE Identity Group e.g. Workstation, it imports fine.

What is "huva-vlan501"? and where have you defined it? It should be an Endpoint Identity Group.

Re: Problems to import CSV endpoints to ISE

jimontoro — Thu, 28 Jun 2018 10:47:40 GMT

huva-vlan501 is a endpoint identity group. I don´t what you mean when you say default ISE Group.

Re: Problems to import CSV endpoints to ISE

Rob Ingram — Thu, 28 Jun 2018 11:05:22 GMT

I was referring to the default Endpoint Identity Group (appears under Profiled).

I created "huva-vlan501" and successfully imported from your csv.

Try another Endpoint ID Group such as "Workstation" and see if that works

What version of ISE and patch are you running?

Re: Problems to import CSV endpoints to ISE

jimontoro — Thu, 28 Jun 2018 12:36:38 GMT

2.3.0.29 Patch 4.

Re: Problems to import CSV endpoints to ISE

Rob Ingram — Thu, 28 Jun 2018 13:14:54 GMT

Try another Endpoint ID Group such as "Workstation" and see if that works

Re: Problems to import CSV endpoints to ISE

Rnardi — Fri, 23 Nov 2018 13:45:41 GMT

HI Jimontoro,

Could you import the list?

Or were you able to change the status of profiled?

Thanks,

Ricardo.