Hello, someone knows how I can generate a link from a kml file of mymaps, to place in the url of kml in a column type coordinates and that you can see every change made in the map of mymaps automatically in appsheet
Please see my post:
[Host KML files on Google Drive](https://community.appsheet.com/t/host-kml-files-on-google-drive/10941) Tips & Tricks ?
If you want to use a KML map layer as described here you can host the kml file on Google Drive. Just right-click on it and choose SHARE. Then click on ADVANCED and copy the link. Paste this link here to get the Export Link: http://kolorobot.github.io/permalink/ Copy this Export Link and paste it in your column definition under “Optional Url for KML File”. The kml file does not to be public. It can be private. One thing I noticed: It will not work with https:// but only with http://
Hi Fabian, I tried what you said above and my kml works well, but it does not show the lines and other features that my map has in my maps. It only shows the map without anything.
As you can see I can not find the ADVANCED option when I enter to share the file, however take the link that appears above and convert it with the link you sent.
Please try this: Right click on the kml and choose “Get shareable link”
In the URL just change the word “open” to “uc” and try using http:// instead of https://
1 Like
This isn’t working for me either.
Try and save the klm file to Google Firestore cloud storage which gives the public url to the file and use that URL. Firestore is basically free storage services.
Ok. I’m setting it up. Do you know what type of dataflow template I would use?
What do you mean?
You generate KML file on Google My Map. Then download that file to local.
Then save the same file to Google Firestore and get the link (URL)
Paste the URL to Appsheet. Thats all the step required.
1 Like
tsuji_koichi:
Then save the same file to Google Firestore and get the link (URL)
thanks
After numerous trial and errors, I finally got this approach to work when I would export my Entire Google Map, selecting only “Export as KML…” ! image|458x202
1 Like
Hi @Benjamin_Parmenter In fact you can also use KMZ files in AppSheet. For some cases it’s even better, because KML would loose some informations.
[I've added a URL to a hosted KML file (< 5MB)...](https://community.appsheet.com/t/ive-added-a-url-to-a-hosted-kml-file-5mb/699/13) Questions
Yes that’s very important! And you should use a KMZ file, not a KML. Complex things get lost in KML. I had good luck with this format: https://docs.google.com/uc?id=YOUR_FILE_ID&export=kml If you change something in the KML or KMZ file, you should change also the “Optional Url for KML File” in your App. Because it seems that AppSheet caches the KML / KMZ file. You can simply put a number behind your URL like: https://docs.google.com/uc?id=YOUR_FILE_ID&export=kml1 to get the lates…
You can use also the Network Link. With this you don’t have to upload your KML file to Google Drive.
[KML for Map or XY using Network Link](https://community.appsheet.com/t/kml-for-map-or-xy-using-network-link/31450) Tips & Tricks ?
In column types like Address, LatLong, XY we can add an Optional Url for KML File. It was disused many times, how we can host the KML file. Now I found a method how you can use your Google My Maps File directly without the need to export it and to host the exported KML file. The URL should look like this: https://www.google.com/maps/d/kml?mid=YOUR_MY_MAPS_ID Don’t forget to set your Google My Maps File to “Anyone on the internet with this link can view”. If you like to show only one layer …
I posted some Tips & Tricks about KML. You can find them here:
https://community.appsheet.com/search?q=kml%20@Fabian
1 Like