Wireless Access

Reply
Occasional Contributor II
Posts: 89
Registered: ‎12-27-2012

importing CSV file to internal DB

Hi All

We are using controller 3600 with version 6.1.3.5
I have created CSV file with user accounts in order to import it to the controller

I was able to import the CSV file to the controller successfully by going to Authentication - > server - > internal db -> import.

After importing I could not see any user entries in the internal db.

1. Am I doing something wrong in creating CSV file?
2.do you have any procedure how to create CSV file and also how to enter the user entries into the CSV file in order to import successful?

Thanks in advance
Guru Elite
Posts: 21,543
Registered: ‎03-29-2007

Re: importing CSV file to internal DB

You should only be able to import something that you already exported from the controller.

 

For what you are trying to accomplsh, please see the Excel method here:  http://community.arubanetworks.com/t5/Mobility-Management-System-MMS/Enquiries-on-Aruba-s-internal-db/td-p/1299



Colin Joseph
Aruba Customer Engineering

Looking for an Answer? Search the Community Knowledge Base Here: Community Knowledge Base

Occasional Contributor II
Posts: 89
Registered: ‎12-27-2012

Re: importing CSV file to internal DB

Hi CJ

Thanks for your reply.

My question is I am trying to import the bulk guest user account to the internal db. How can I achieve that?
In the user guide it has mentioned that we have to create CSV file and then we need to import them.

thank you
Guru Elite
Posts: 21,543
Registered: ‎03-29-2007

Re: importing CSV file to internal DB

Okay.  A guest user list can ONLY be imported, if it was first exported from an Aruba Controller.  a CSV cannot be imported.

 

What you have to do is to use excel to put the usernames and passwords in two columns.  In excel, you should also put the commands to add each user in colums around the usernames and passwords.  Copy and paste the commands into the commandline on the controller.  For example, the format for adding a user (or guest) on the commandline is:

 

local-userdb add username <username> password <password> role <role>

 So what you have to do in excel is create a column that has "local-userdb <space>" in one column, your usernames in the second column, "password" in the third column, the password for that user in the fourth column.  Make a list like this :  http://community.arubanetworks.com/aruba/attachments/aruba/67/17/1/local-userdb.jpg

 

Select all the rows and columns and paste into the commandline in the controller.

 



Colin Joseph
Aruba Customer Engineering

Looking for an Answer? Search the Community Knowledge Base Here: Community Knowledge Base

Search Airheads
Showing results for 
Search instead for 
Did you mean: