Bulk import PPSK groups and users failing

  • 1
  • Question
  • Updated 3 years ago
I need to create a few Local User Groups and Local Users for several PPSK groups. I'd like to import both, but get "CSV File format is invalid" with no explanation on what failed.

First, the user. I have an existing group called "Cortez PPSK." I tried to import a new user with:
//User Name,User Type,User Group,Password,Email Address or Description,Description
CortezPassword,3,Cortez PPSK,The_Example_PW,,

This just fails with the invalid format error.

I also tried to add a group with:
//User Group Name,User Type,User Attribute,VLAN ID,Reauth Time,Credential Persistency,Description
Alcott PPSK,3,,,1800,1,

The documentation isn't very good since it shows three different header names and formats, so I'm not sure where the problem lies. How do I import these groups and users?

Thanks,
-Dan
Photo of Dan Mellem

Dan Mellem

  • 52 Posts
  • 1 Reply Like

Posted 3 years ago

  • 1
Photo of Joe Fraher

Joe Fraher, Official Rep

  • 30 Posts
  • 7 Reply Likes
Hi, Dan. Is the file extension .csv? I typically test these out with a text editor and at first I got an invalid format error because I forgot to change it from .txt to .csv.

I created a user group on my VHM named "Cortez PPSK", made sure my file had .csv as its extension, and was able to import this user to that group:

//User Name,User Type,User Group,Password,Email Address or Description,Description
CortezPassword,3,Cortez PPSK,The_Example_PW1,,

The only change I made to what you provided above was to add "1" to the password because one of the password requirements for the user group was that the password must include at least one digit. (You can easily change that in the user group settings.) I think the problem you saw might have been with the extension of the file you're trying to import. - Joe 
Photo of Dan Mellem

Dan Mellem

  • 52 Posts
  • 1 Reply Like
Yup, that is the problem - it calls for "CSV File" and it has a ".CSV" extension, but it doesn't recognize it unless it's lowercase ".csv." A bit of a bug. Thanks for your help.
Photo of Joe Fraher

Joe Fraher, Official Rep

  • 30 Posts
  • 7 Reply Likes
I agree. I confirmed that an uppercase file extension doesn't work but a lowercase extension will and reported it to the engineering team. It's now being tracked as a bug. Thank you for pointing it out. - Joe 
Photo of Dan Mellem

Dan Mellem

  • 52 Posts
  • 1 Reply Like
Great. Thanks.