Cisco Prime Planned AP Association CSV Columns

I have recently deployed a large number of access points using Prime 1.3 to plan the AP placements. One issue I ran into was the AP association and importing a CSV file. I receive all kind of errors when importing such as

1. CSV Import has an unsported Mime Type
2. New line required a the end of each
3. The MAC Address to use is the Base Mac Address. This is different to the AP MAC address


To avoid the MIME issue I saved the file as .txt instead of .csv and the final .txt file formatting looks like this

Building,Campus,Floor,APName,MacAddress
"Building Name","Campus Name","Floor Name","AP__1","00:00:00:00:00:00"
"Building Name","Campus Name","Floor Name","AP__2","00:00:00:00:00:00"
"Building Name","Campus Name","Floor Name","AP__3","00:00:00:00:00:00"
"Building Name","Campus Name","Floor Name","AP__4","00:00:00:00:00:00"
"Building Name","Campus Name","Floor Name","AP__5","00:00:00:00:00:00"