[Qgis-user] Import kml with all the fields

[C Hamilton]

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/c4fc9e3a/attachment.html>