Cisco ISE, to add start and end date into csv file of sponser portal

[kaushalparab]

Hi,

On cisco ISE sponser portal , while uploading a csv file for bulk users, can add a field start and end date inside csv file ? i know it can be done on manually but i want inside csv file can we mentioned start and end date to reflect in database once we upload the csv file? currently template of csv file only below field , can we add 2 more fields like start and end date inside csv file only ?  

Note: i tried adding start and end date inside csv file but it does not work, i mean file does not upload into sponser portal. 

Currently showing fields in csv format template. 

First name:

Last name:

Email address:

Phone number:

Company:

[Francesco Molino · Accepted solution]

Hi

When importing users, on the right you can select the user validity using number of days or date start and stop.

Ps: excuse me i took the screenshot from my phone that's why there's a volume indication on top of the picture.

You can't add these infos on the template itself.

Also, you can use api if you to setup different dates for each users when importing then automatically.

[kaushalparab]

Thanks for info. Yes you are right.  inside CSV file you cant mentioned start and end date. only if using API is posible. but Cisco should consider to implement to add start and end date inside csv file itself coz we planning to automation where csv file will be auto upload into ISE so in that case if these 2 field not inside need to manually put start and end date which will be show stopper for automation of uploading file. 

[Jason Kunst]

---

@kaushalparab wrote:

Thanks for info. Yes you are right.  inside CSV file you cant mentioned start and end date. only if using API is posible. but Cisco should consider to implement to add start and end date inside csv file itself coz we planning to automation where csv file will be auto upload into ISE so in that case if these 2 field not inside need to manually put start and end date which will be show stopper for automation of uploading file. 

---

i'd recommend using the API instead of automating CSV upload, this seems rather crude. 

To contact our product team for future enhancement requests, externally for cisco customers/partners at http://cs.co/ise-feedback for cisco employees internally at http://cs.co/ise-pm