We recently had a need to update the address of over one thousand routers in InControl2.
The hope was to load the shipping address and let IC2 determine the latitude and longitude the way it does if you change the address on a single router, but using the csv upload instead.
What we found was that using the csv upload in InControl2 to modify the address would also require the latitude and longitude of the location. Without those values, IC2 would return an invalid format error.
Would it be possible to adjust the feature so that the user could load a csv of addresses and allow IC2 to negotiate the Lat/Long?
For anyone looking to do anything similar, Iād suggest the plugin for google sheets here
This will return the coordinates for addresses and then you can use that to create the csv file.