Qlik Sense does not recognize extended data section of KML shape files

mikegrattan — Fri, 18 May 2018 14:43:39 GMT

Hello,

I'm trying to import GIS data from files that contain an ExtendedData section. The goal is to import not only the shapes for the coordinates, but also the names of the properties. In this case, we use Ranch, Lot, and Grower to assist in identifying the various properties in the map file. I've attached a zip file that should contain all relative data in order to do a conversion, but simply importing a KML (converted from the original SHP file) doesn't seem to pull in the data correctly. I've also tried using an online tool called My GeoData Converter, which supposedly can handle this conversion when you upload the entire set of files in a .zip file (or individually), and it does get the Extended Data, but drops the actual coordinates for some reason. Hoping someone can help here!

Note: I did find an older thread about the KML ExtendedData section but the resolution was a custom R script, which I attempted to modify for my file but could not get to work. That thread can be found at How to use a KML file's ExtendedData ?

I've attached a zip file containing the files I am trying to import into Qlik Sense. The .shp file was converted to .kml using Google Earth, which only allows selection of one data field as the "Name" field when creating a template for .kml conversion.

So, the goal is to either create a .kml file that includes the additional ExtendedData fields, or generate a lookup file that would include a key index for the Area and the related fields that go with that area.

Re: Qlik Sense does not recognize extended data section of KML shape files

abhalla2 — Wed, 30 Jan 2019 08:50:34 GMT

Try reading the data in .xml format, in data editor, should work.

Re: Qlik Sense does not recognize extended data section of KML shape files

jcf — Fri, 03 May 2019 15:12:54 GMT

Check out this link. i just posted a solution for just this thing.

KML extended data parsing

topic Qlik Sense does not recognize extended data section of KML shape files in Connectivity & Data Prep

Qlik Sense does not recognize extended data section of KML shape files

Re: Qlik Sense does not recognize extended data section of KML shape files

Re: Qlik Sense does not recognize extended data section of KML shape files