[Qgis-user] Import kml with all the fields

[krishna Ayyala]

Calvin,
That worked for me. Thanks a lot for your help. I am very happy with this
solution.

Regards.

On Fri, Jan 21, 2022 at 10:26 AM C Hamilton <adenaculture at gmail.com> wrote:

> KMLs can be difficult to work with. In your case the Fields are actually
> an HTML block of text that is contained in the description field of the
> KML. KML Tools will work with this, but there are two steps that you need
> to take. The first is to import the KML file into QGIS. Install the KML
> Tools plugin and run "Vector->KML Tools->Import KML/KMZ" from the QGIS
> menu. All of your tables are in the description attribute field. The next
> step is to select this imported layer and run "Vector->KML Tools->Expand
> HTML Description Field". For "Input layer" select your imported KMZ data.
> Description field will automatically be set to description. "How to expand
> the description field" should be set to "Expand from a 2 column HTML
> Table". Click on OK. It will ask you what fields from the table you want
> expanded. Select what you want and then click on OK.
>
> This works for the KMZ file you sent.
>
> Best wishes,
>
> Calvin
>
> On Fri, Jan 21, 2022 at 5:04 PM krishna Ayyala <ayyalakrishna at gmail.com>
> wrote:
>
>> Hello,
>> I am herewith attaching the kmz. When I open this in google earth, I can
>> see all the four fields;Field1,Field2,Field3 and Field4. But, when I add
>> this kmz to QGIS and open the attribute table, I cannot see any of these
>> fields. This is just a sample data. I have about 50 to 60 such kmzs. Can
>> you please suggest as permanent solution so that I can fix it myself and
>> see all the four fields?
>>
>> Regards.
>>
>> On Thu, Jan 20, 2022 at 10:40 PM Phil Wyatt <phil at wyatt-family.com>
>> wrote:
>>
>>> Is it KML (single file) or KMZ which may contain multiple files? Unzip
>>> the KMZ and have a look at the files – maybe there is some way to
>>> connect/join the different files via a common field
>>>
>>>
>>>
>>>
>>> https://gis.stackexchange.com/questions/365579/showing-images-linked-with-corresponding-kmz-in-qgis
>>>
>>>
>>>
>>> *From:* krishna Ayyala <ayyalakrishna at gmail.com>
>>> *Sent:* Friday, 21 January 2022 4:08 PM
>>> *To:* Phil Wyatt <phil at wyatt-family.com>
>>> *Cc:* Camilo Aristizabal <aristizabalcamilo at ymail.com>; qgis-user <
>>> qgis-user at lists.osgeo.org>
>>> *Subject:* Re: [Qgis-user] Import kml with all the fields
>>>
>>>
>>>
>>> Phil,
>>>
>>> Thanks for the reply. I did drag and drop. But still only "Field1" shows
>>> up in the attribute table. There are other fields such as "description",
>>> "timestamp", "begin", "end" which show in the attribute table. These other
>>> fields are automatically generated when I add kml to the map. But all I am
>>> interested to see are Field1,Field2,Field3 and Field4.. The only useful
>>> filed I see is  Field1. When I open this kmz in google earth and click on
>>> any point, I see all the four fields. Is there a way to see all these four
>>> fields in QGIS?
>>>
>>>
>>>
>>> Regards
>>>
>>>
>>>
>>> On Thu, Jan 20, 2022 at 9:23 PM Phil Wyatt <phil at wyatt-family.com>
>>> wrote:
>>>
>>> Hi Kryshna
>>>
>>>
>>>
>>> Its also possible to ‘drag and drop’ the kml from the file manager to
>>> the map window. You might also let us know where the kml was created as the
>>> error may be from the original source rather than a QGIS issue. Do the
>>> other fields show up if opened in Google Earth?
>>>
>>>
>>>
>>> Cheers - Phil
>>>
>>>
>>>
>>>
>>> Em quinta-feira, 20 de janeiro de 2022 22:19:46 BRT, krishna Ayyala <
>>> ayyalakrishna at gmail.com> escreveu:
>>>
>>>
>>>
>>>
>>>
>>> Hello,
>>>
>>> I have a kml that has a point layer with about 50 Points. Each point has
>>> four fields. Field1,Field2,Field3 and Field4. I have imported this kml into
>>> qgis. When I open the attribute table, I see only Field1. Is there a way to
>>> import the kml so that I can see all the 4 fields in the attribute table?
>>>
>>>
>>>
>>> Regards.
>>>
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220121/7b90095b/attachment.html>