Network Management

Reply
DSP
Contributor II

AirWave 8.2.0.3 DB update via import csv

Hi, 

 

I have a spreadsheet in .csv with locations for APs that are managed by AMP but have no location information available. 

 

Is there a way to load/import this into AMP to update this field for almost every AP ?

 

Not sure if this is possible or there is another way we could possibly try XML, CLI , SQL ... ?

 

Thanks, 

 

DSP

Guru Elite

Re: AirWave 8.2.0.3 DB update via import csv

Screenshot of the field you are talking about, please?



Colin Joseph
Aruba Customer Engineering

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

DSP
Contributor II

Re: AirWave 8.2.0.3 DB update via import csv

Field Highlighted in yellow, Location.

Guru Elite

Re: AirWave 8.2.0.3 DB update via import csv

I am not aware of how to do that via CSV update, but if you provision an Aruba AP using the controller, the "SNMP System Location" attribute on the controller is imported by Airwave:

Screenshot 2016-11-11 at 04.44.50.png



Colin Joseph
Aruba Customer Engineering

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

DSP
Contributor II

Re: AirWave 8.2.0.3 DB update via import csv

 

Thanks for your reply C Joseph, 

 

Reprovisioning the AP would be an option.

 

What I was hoping is to see if theres a way, via XML, SQL, or uploading .CSV to automatize this process as much as possible and if someone has tried it before ...

 

Regards, 

 

DSP

 

Guru Elite

Re: AirWave 8.2.0.3 DB update via import csv

I would challenge you even further:

 

Come up with an AP naming scheme that lets everyone know exactly where an AP is so that they don't have to consult an additional field.



Colin Joseph
Aruba Customer Engineering

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

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