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?


*Answers and views expressed by me on this forum are my own and not necessarily the position of Aruba Networks or Hewlett Packard Enterprise.*
ArubaOS 8.3 User Guide
InstantOS 8.3 User Guide
Airheads Knowledgebase
Airheads Learning Videos
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


*Answers and views expressed by me on this forum are my own and not necessarily the position of Aruba Networks or Hewlett Packard Enterprise.*
ArubaOS 8.3 User Guide
InstantOS 8.3 User Guide
Airheads Knowledgebase
Airheads Learning Videos
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.


*Answers and views expressed by me on this forum are my own and not necessarily the position of Aruba Networks or Hewlett Packard Enterprise.*
ArubaOS 8.3 User Guide
InstantOS 8.3 User Guide
Airheads Knowledgebase
Airheads Learning Videos
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: