When the an an activity references an administrative level for location rather than a point location type like "Village", the importer fails to correctly match upper levels of geography.
To reproduce, create an activity in a database with country "Madagascar".
Try to import the following spreadsheet:
After matching the columns to each of the four administrative levels, proceed to matching.
All four administrative levels should be matched with 100% accuracy.
Only the lowest level (Fokontany) matches and the remaining administrative levels do not match at all.