Fusion table KML import

Question

I used to have no problem importing kmls to fusion tables and making lots of great maps but now it only brings in three columns - name, description and geography. The remaining attributes show up when a feature is clicked on but you can't make any map setting/theme changes based on any of them and they don't show up in table view. Table view appears to be restricted to name, description and geography. I've tried with multiple datasets.

Is anyone else having this issue.

Answer 1

If you use <Schema> and <SchemaData> elements in your KML then Google Fusion tables will import those as columns.

<ExtendedData>                   
  <SchemaData schemaUrl="anyURI">
    <SimpleData name=""> ... </SimpleData>
  </SchemaData>
</ExtendedData>

Likewise, if you use <Data> in ExtendedData for your metadata then that also is imported as columns in the import.

<ExtendedData>                       
  <Data name="string">
    <value>...</value>
  </Data>
</ExtendedData>                       

See related tutorial with examples:
https://developers.google.com/kml/documentation/extendeddata