1

CSV to KML converter

Topic: CSV to KML converter

Hi guys,

we really need to find a converter, we have to upload 8k geofences to wialon hosting, geofences should be with this characteristic: radius 50m and marked as a source of address

we found this converter http://www.earthpoint.us/ExcelToKml.aspx but does not make radius or source address

anybody can help us ??

THANKS IN ADVANCE

2

CSV to KML converter

Re: CSV to KML converter

Guess it would go easier via WLP file type. http://docs.gurtam.com/en/hosting/cms/port/exp-wlp
Export few POIs with radius and check the file in notepad++ or similar text editor.
Than follow the syntax of it

Aliaksandr Kuŭshynaŭ, Gurtam
3

CSV to KML converter

Re: CSV to KML converter

cttmx wrote:

Hi guys,

we really need to find a converter, we have to upload 8k geofences to wialon hosting, geofences should be with this characteristic: radius 50m and marked as a source of address

we found this converter http://www.earthpoint.us/ExcelToKml.aspx but does not make radius or source address

anybody can help us ??

THANKS IN ADVANCE

The are special tags responsible for "address source" checkbox and radius.
1. Import geofences as they are. Than export them back. This step helps to optimize structure of kml file.
2. Open kml file in any text editor (NotePad++)
3. Use Find and Replace Tool:
   3.1. addr="0" to addr="1"  (the tag responsible for address source option)
   3.2. width="1000.0 to width="50.0

4, Import kml file to Wialon.

Maps Manager
Gurtam
4

CSV to KML converter

Re: CSV to KML converter

Thanks !!! work perfect

5

CSV to KML converter

Re: CSV to KML converter

by the way, we have sometimes also the demand of customers to convert their excel file with ADRESSES into geofences.
Problem here is the conversion of adresses into latitude/longitude.

Does anybody know a "lookup-tool" for this?

Thanks
Wolf.

Politeness dictates it to write his name on a post
6

CSV to KML converter

Re: CSV to KML converter

Hello, Wolf.

First variant coming to my mind is this API call - http://sdk.wialon.com/wiki/en/sidebar/r … tes_simple
With an example here - http://sdk.wialon.com/wiki/en/sidebar/r … ss_coords/

BR.

7

CSV to KML converter

Re: CSV to KML converter

Hi Serd,

cool!!! always cool to see how many functions api has.

Will ask Venellin to create a little SW to import xls file into Wialon....


Thanks
Wolf.

Politeness dictates it to write his name on a post