Wireless Access

Reply

Mass folder creation

Hello,

 

Anyway to create a mass amount of folders by importing using CSV?

 

I know we can import devices via CSV but not create folders.

 

I have 28 controllers which I want in their own AMP Group.

I also have roughly ~2100 APs that I need to monitor via Airwave but I want them in their own folder for per folder reporting possibilities.

 

Any way to do this??

Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
Moderator

Re: Mass folder creation

Yes, there's a create folders from csv script

 

# cd /root/svn/mercury/scripts

# ./create_folders_from_csv.pl

 

./create_folders_from_csv.pl <csv_data_file>

Create a folder structure from a csv file. This script will not allow duplicate folder names even though AMP will.
You must create the high level folders before you create the sub folders. From the example below, you cannot create
sub_sub_folder_1 before you create sub_folder_1.

 

CSV FORMAT:

Top_folder,new_folder

 

example:
Top_folder,new_folder
Top,sub_folder_1
Top,sub_folder_2
sub_folder_1,sub_sub_folder_1

 

--> first row entry of CSV must be Top_folder,new_folder

 

Here's an example run through:

[root@amp tmp]# cat csv
Top_folder,new_folder
Top,alpha
Top,beta
alpha,gamma

[root@amp tmp]# cd /root/svn/mercury/scripts

[root@amp scripts]# ./create_folders_from_csv.pl csv
creating new folder alpha under Top
creating new folder beta under Top
creating new folder gamma under alpha

 

And then verify that your UI reflects the desired folder structure.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company

Re: Mass folder creation

Beautiful. Thanks a lot, I didn't know this existed.

 

Are these scripts usually reserved for TAC? or is there a document that explains how to use these scripts for end-users?

 

EDIT: It worked, thankl you

Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
Moderator

Re: Mass folder creation

There's a few KBs that recommend using the scripts.  Other than that, they are left for TAC to recommend as needed.  There's no single document since these are all custom scripts that were created as needed.

 

You can get lucky and try ? or no flags to see if there are usage notes.

# ./create_folders_from_csv.pl ?

./create_folders_from_csv.pl

-in this case, the latter produces the usage note output I previously provided.

 

Be aware that some of these scripts will run if there's no flag.  So you may want to try them on a lab setup before trying them in production.  If you do not have a lab setup, it'd be best if you interacted with TAC instead of guessing which script to try, as some of these scripts can cause lost of CLI access or database data.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company

Re: Mass folder creation

Thank you very much for your time. This helps greatly

Pasquale Monardo | Senior Network Solutions Consultant
ACDX #420 | ACMP
[If you found my post helpful, please give kudos!]
Occasional Contributor I

Re: Mass folder creation

This information is help to cteate mass folder.

But if i need more sub_folder, how to do it

 

example:

HS   --->High School

HS,RHHS

HS,AAAA

JS  ---->Junior High School

JS

JS,BBBB

 

 

like that. Can it do it by "mass folder create way" ?

 

Kirby 

 

 

 

Re: Mass folder creation

Awesome.  This saved me a good couple of hours.

 

:-)


If my post is helpful please give kudos, or mark as solved if it answers your post.

ACCP, ACMP, ACMX #294
mclarke@arubanetworks.com
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: