Typos in MLS export file format in MLS 3.6
Posted: Thu Jul 11, 2013 12:58 pm
MLS 3.6 introduced a change, apparently typographical errors, in the file format of one of the standard MLS export files, Membership.csv.
The first line of that csv file contains the column names for the fields being exported. Several of those field names, excerpted here for brevity, traditionally have been named as follows:
But in MLS 3.6, the corresponding column titles are:
In each case, the character following the "2" at the beginning of each column title traditionally has been an ordinary ASCII hyphen character (hex 2D). But in MLS 3.6, each of those characters has been retyped as an em-dash (hex 97).
This change, presumably an error, might break any programs, spreadsheets, scripts, etc. designed to read the export files. It certainly broke mine. I can work around it, but it is maddening to find such inconsistency.
The first line of that csv file contains the column names for the fields being exported. Several of those field names, excerpted here for brevity, traditionally have been named as follows:
Code: Select all
"2-Street 1","2-Street 2","2-D/P","2-City","2-Zip","2-State/Prov","2-Country"
Code: Select all
"2—Street 1","2—Street 2","2—D/P","2—City","2—Zip","2—State/Prov","2—Country"
This change, presumably an error, might break any programs, spreadsheets, scripts, etc. designed to read the export files. It certainly broke mine. I can work around it, but it is maddening to find such inconsistency.