cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Announcements
Choose one of the topics below to view our ISE Resources to help you on your journey with ISE

This community is for technical, feature, configuration and deployment questions.
For production deployment issues, please contact the TAC! We will not comment or assist with your TAC case in these forums.
Please see How to Ask the Community for Help for other best practices.

1248
Views
0
Helpful
12
Replies
Highlighted
Beginner

Problems to import CSV endpoints to ISE

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!
12 REPLIES 12
Highlighted
VIP Mentor

Make sure you have CSV valid format to import.

 

BB

BB
*** Rate All Helpful Responses ***
Highlighted

the file has the ise template´s format:

 

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,,huva-vlan501,,,,,,,,,,,,,,,,,,,,,,,,,,,,
 
we use three columns, and the other in blank.
Highlighted

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.
Highlighted

Sorry, we are using 2: MACAddress,,IdentityGroup

Highlighted

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

Highlighted

I attach an example.

Highlighted

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.
Highlighted

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

Highlighted

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?
Highlighted

2.3.0.29 Patch 4.

Highlighted

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

HI Jimontoro,

Could you import the list?

Or were you able to change the status of profiled?

Thanks,

 

Ricardo.

 

Content for Community-Ad