I still couldn't find much information on this feature 1.5 years later. I also had issues with uploading the CSV containing the Association data. When I created the CSV file myself, WCS kept reporting that the "File seems to be empty or not well formated. There should be a new line character at the end of each line." When I generated the CSV file in Excel 2003, I received the error "CSV Import: 'import.csv' has an unsupported Mime Type\b\bCSV Import: Supported file format mime types are\b\b[application/vnd.ms-excel, text/csv, text/plain]\n\nNote:\n' application/vnd.ms-excel' should be of CSV format and not a spreadsheet".
The issue with the manually created CSV was that I didn't have colons between every 2 characters of the MAC address. I wasn't able to determine the issue with the CSV created in Excel 2003, the output of "cat -A filename.csv" appeared to be the same for the excel generated CSV and the manually created one.
These are my tips if you're having problems:
- You must be logged into WCS as root to see the Planned AP Association link in Planning Mode.
- Create the CSV manually (or figure out the problem wtih using Excel and post/link a solution here)
- Use the following headers in your CSV: Campus,Building,Floor,APName,MacAddress
- Make sure you are using the correct names for Campus, Building, Floor, AP name and that your MAC address is formatted with colons separating every 2 characters
From what I observed, you should be able to upload 1 CSV file that contains all the AP associations to the APs on all your planning maps.
I also noticed that there is a 15 character limit in the AP Name field of the Planning Mode feature (WCS 7.0.172). This was unfortunate because I would like to have been able to name the APs with our preferred (and probably too long) naming standard before they physically registered with the WLC or WCS.
