I’ve just added a new feature to Tabulate, that allows for the exporting (to CSV) of the set of filter values (for multi-valued filters) that are not found in the data. It also now tells you, next to each multi-valued filter, how many values you’ve got in the search field.
Just a note for my future reference: importing an Excel CSV into MySQL. The WKT column has been constructed by hand to be
POINT(lng lat) and the CSV contains headers.
LOAD DATA INFILE '/full_path/to/file-on-server.csv' REPLACE INTO TABLE the_table COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' IGNORE 1 ROWS (name,description,@geographic_location) SET geographic_location = GeomFromText(@geographic_location) ;