Bulk PPSK users import in NG

  • 4
  • Question
  • Updated 1 year ago
Is there a way to bulk import users into NG via a CSV or something? I can't seem to find any docs on it. 

Thanks,
Photo of Rob Burgoyne

Rob Burgoyne

  • 19 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 4
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Still isn't there. I think everyone is waiting for it. I know there is a french guy that created a bulk import with the api's. I'm not at my pc but i will send you the link later
Photo of BJ

BJ, Champ

  • 374 Posts
  • 45 Reply Likes
I would also be very interested in this.
Photo of Rob Burgoyne

Rob Burgoyne

  • 19 Posts
  • 0 Reply Likes
Thanks, I appreciate it! Seems kind of silly that it hasn't been added yet. 
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Here you have the link: https://identity.ah-lab.fr/

I haven't test it so I hope it will do the trick.

It's indeed very silly that it isn't implemented yet. First it was Q2 2016, now normally Q3 2016 but ...
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Was the link helpful?
Photo of Daniel Montes

Daniel Montes

  • 2 Posts
  • 0 Reply Likes
How long does the import process? I'm testing to import a file of 20 lines, but after 30 minutes the number of created accounts is zero ...

The tool has not shown me any errors, but the same thing happens when I try to create users through the "Bulk" tab in the section "Create"

Did you have a similar problem with this tool? Can you give me some advice?

Regards

Daniel
Photo of Lars Fredrik Bach

Lars Fredrik Bach

  • 7 Posts
  • 0 Reply Likes
I have not got the tool to work.. We'll probably just have to wait for the HiveManager NG upgrade this weekend, and hopefully AH have upgraded it so it will bulk-import.
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Bulk import will not be added in this release but in the release in november they told me.

I have added two records and this was created immediately.

I get the fields when I select a user group and select a CSV file.
(Edited)
Photo of Lars Fredrik Bach

Lars Fredrik Bach

  • 7 Posts
  • 0 Reply Likes
I have also got the same options. But it will not import the users, with no errors.
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
What internet browser are you using? I used Mozilla Firefox. Some html 5 programs are not optimized for all browsers.

Photo of Rob Burgoyne

Rob Burgoyne

  • 19 Posts
  • 0 Reply Likes
This took care of a lot of my needs, however I also need to bulk import users that I choose the username and password. This tool only lets you generate new users that NG creates a random password. Anyone have any ideas? Would be much appreciated. 
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
I also used the api's to create users. But there is no password field you can use. So at the moment this isn't possible I think. Hopefully the password field is added to the bulk import feature in Hivemanager NG.

With the api's you can create something where the firstname is used as username. But then you need to let the emailadress + phone number empty and set delivery to NO_DELIVERY. But these options are not added to this program.

If you really need it my company can write it for you. You can contact us at info@complit.be
Photo of Lars Fredrik Bach

Lars Fredrik Bach

  • 7 Posts
  • 0 Reply Likes
Hello!
I am a need of creating users in HiveManager NG.
I have tried talking to the API, but I don't get it to work properly.

Currently I have tried using curl in a terminal.

curl -X GET -H "X-AH-API-CLIENT-SECRET: YOUR-CLIENT SECRET" \-H "X-AH-API-CLIENT-ID: YOUR-CLIENT-ID" \
-H "X-AH-API-CLIENT-REDIRECT-URI: YOUR-REDIRECT-URL" \
-H "Authorization: Bearer YOUR-ACCESS-TOKEN" \
"http://cloud-ie.aerohive.com/xapi/v1/identity/credentials?ownerId=YOUR-OWNER-ID";

But the only thing I get in return is that credentials are not correct.
I have signed up in developer.aerohive.com, created an app and got client-id together with client secret.
Still I don't get it to work.
Any got ideas what I am doing wrong? 
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Did you try with Postman (plugin of Google Chrome)? I have made all my api with this tool. If it work you can export it in the program language you want
Photo of Lars Fredrik Bach

Lars Fredrik Bach

  • 7 Posts
  • 0 Reply Likes
Thank you for the tip!
I could try using this plugin.
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
It's finally added. You can find in under Configure --> Users --> You can choose for bulk import with a prefix or to use a csv file
Photo of Luke Harris

Luke Harris

  • 265 Posts
  • 18 Reply Likes
It does surprise me that features that were present in previous revisions of HiveManager (albeit 6.X) that weren't ported over to the NG platform at the time of release. 
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
NG is builded from scratch. So not every feature from 6 will be added to NG (and some features will be only for NG). But you are right that the bulk import must be in it from the beginning.
Photo of Luke Harris

Luke Harris

  • 265 Posts
  • 18 Reply Likes
Oh no I totally agree, the architecture on which NG sits is vastly different to the 6.X platform. I'm just disappointed that useful features like this and some of the more advanced/granular reporting functions have been omitted. 
Photo of Adam Norman

Adam Norman

  • 13 Posts
  • 0 Reply Likes
I love that the functionality is now here! However I have been testing and it doesn't work...
I import a small list of users, 30 or so, the import works. However they are unable to log on with the PPSK (PPSK Rejected by Guest Access) even though it is compliant with the groups complexity requirements....
Photo of Adam Norman

Adam Norman

  • 13 Posts
  • 0 Reply Likes
Even subsequently regenerating or manually specifying a PPSK results in the same "Incorrect pasword..." on device and "PPSK Rejected by Guest Access" on HMNG...
I can manually created a user on the same group, policy and attach to same AP and it joins without issue.
Support please advise? I just held off our deployment to wait for bulk import yet it still doesn't work.. 
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Can you check the following:
- if the ppsk are time based. Check the logs of the Aerohive ap's to see if the time settings are ok. Mostly this is a time/Date error
- did you use Service or device for the "Password db location" on the user group? If you choose for Device I think you need to do a configuration update to the access points.
Photo of Adam Norman

Adam Norman

  • 13 Posts
  • 0 Reply Likes
Hi Jonas
Thanks for your comment. The PPSK for this policy is not time based.
This is service based group/policy, so have not updated AP. 
I will try it though.
Cheers
Photo of Jonas Dekkers

Jonas Dekkers

  • 152 Posts
  • 29 Reply Likes
Do you see the users you imported and are they linked with the right user group? Are the passwords correct?
Photo of Adam Norman

Adam Norman

  • 13 Posts
  • 0 Reply Likes
AP update did not help...
Photo of Adam Norman

Adam Norman

  • 13 Posts
  • 0 Reply Likes
All users imported correctly. Cross checked the user properties to show group membership and the group properties to see the users in that group too.
The passwords are correct too, triple checked and manually set an "easy" password to try with that is still compliant with complexity requirements.
For clarity, manually adding a user to same group and using a generated or manual PPSK works without issue
Photo of Adam Norman

Adam Norman

  • 13 Posts
  • 0 Reply Likes
I've logged this to our partner/distributor support and will update here on their findings
Photo of Jim Oltman

Jim Oltman

  • 1 Post
  • 0 Reply Likes
Is there an EXPORT option for these PPSK users/passwords?
Photo of BJ

BJ, Champ

  • 374 Posts
  • 45 Reply Likes
From HM6, yes...
Photo of Jason Hills

Jason Hills

  • 78 Posts
  • 3 Reply Likes
Regarding importing a CSV of users.  It doesn't appear possible to include their existing PPSKs, so they can be migrated seamlessly from HM6 to NG?
I understand that PPSK is not a field, like it was in HM6?



is there a way PPSKs can be imported with their username.

thanks,
Jason
Photo of Olivier Bette

Olivier Bette

  • 5 Posts
  • 2 Reply Likes
Hello I have the exact same problem as Jason.
I noticed when you bulk create users in a DEVICE PPSK group with Fixed passwords, you receive a mail with a csv file with the following header:
SSID,ID,User Name,User Group,Access Key,Expiration

It would be nice to be able to re-import this csv because it's not even possible to use the bulk import for this type of user group... and I have hundreds of users to create...
Photo of Malcolm Snelgrove

Malcolm Snelgrove

  • 2 Posts
  • 0 Reply Likes
I am getting a failed import with "idm.import.csv.invalid.user.group.name". Of course I created all of the User Groups first, but it doesn't like them. Since we can't import passwords yet, I just I will have to create the users manually. ;-(