csv2kml: csv to kml converter
version 3.2 01/25/2007
by Pivari.com© 2006-2007 http://www.pivari.com/
|
csv2kml: csv to kml converterversion 3.2 01/25/2007by Pivari.com© 2006-2007 http://www.pivari.com/ |
|---|
csv2kml (csv to kml converter) is a versatile server tool to convert a csv file (Comma Separated Value) into a kml file (the format of Google Earth). You can see a kml file using Google Earth.
To make a csv file you can use Excel or every database.
If you're interested in a binary for another operating system, such as Mac OS X, FreeBSD, SCO Unix, Irix, Digital Unix (tru64), please let us know, and we'll send you one. With enough requests, we'll also add one here permanently.
Demo versions have the same features of registered versions + watermarks
csv2kml is shareware, the registration fee is only 20 euro for a personal license (only for personal use, no inside a company)
The registration fee is 140 euro for company license.
For both licenses you have not limitaton on the number of kml you can produce.
The only limitation is that you have to install your registered version only on the number of computers you have registered.
We have not protected the registered csv2kml version. You are not
allowed to distribute or resell the registered csv2kml version without Pivari.com's authorization.
Obviously we can't verify this, simply we trust you.
For the registration email us at
info@pivari.com an we will send you an invoice.
If you're a developer or a software house, and wish to use csv2kml
inside of your own applications, please email us directly at
info@pivari.com
Contact us directly! We're looking for resellers and partnerships.
We are the developers of this software. Contact us directly for modifications or customization.
Scriveteci per la fattura e le modalità di pagamento info@pivari.com
At the moment csv2kml is a command line converter and works in the same
way on every OS supported (Windows, using a dos windows, Linux, Solaris,
AIX, HP-UX, if you need also Mac OS X, Tru64, BSD, SCO, ...)
csv2kml [-options]
where options include:
-help to print the line help
-verbose to print verbose messages
-version to print version
-mailto "name@domain.com" to send the generated kml to the specify email addresses
-configure file to use a specific configuration file (the default is csv2kml.cfg in the same directory of the executable)
The csv variable allows you to set the input csv file. You can introduce also a relative or absolute path. The default is input.csv
By setting skipfirstline to 1 (default is 0) csv2kml will skip the first line of your csv file. Useful if the first line is a description line
The default delimiter in the csv file is ;. With delimiter variable you can set a different delimiter.
With the label variable you can set a column of your csv file. e.g. §1 to set the first column, §2 to set the second column, ...
csv2kml will create a placemarker for every different label.
With the longitude and latitude variable you can set two columns of your csv file that have the longitude and latitude values.
With address you don't have to know longitude and latitude and you can introduce the address in this way: street address, ZIP city, state. This feature cuerrently works for addresses in Europe, U.S., Canada, Australia and New Zeland. You can use more fields of the csv.
Pay Attention: you can use more columns of your csv but the set on the left has to be minor that the set on the right.
e.g. you can use
address : <a href="§1">§3</a><br>
you can't use
address : <a href="§5">§2</a><br>
because on the left there is §5 that is major than §2!
The html variable allows you to set the html code to put on the text you can see when you click on a placemarker.
Pay Attention: you can use more columns of your csv but the set on the left has to be minor that the set on the right.
e.g. you can use
html : <a href="§1">§3</a><br>
you can't use
html : <a href="§5">§2</a><br>
because on the left there is §5 that is major than §2!
With kmlfile you can change the name of the default kml created: index.kml
Pay attention: kml and kmz are 2 new file formats that
Google Earth can read.
If you want to put a kml or kmz on your web server you need to add this
information inside the web configuration file.
Another possible way is to make .htaccess (I'm sure it works with apache, I don't know with other web server) with inside these lines:
AddType application/vnd.google-earth.kml+xml kml
AddType application/vnd.google-earth.kmz kmz
abd put .htaccess filein your web home.
With documentname you can set the kml document name
Setting correctly ftphost, ftpuser, ftppassword, ftpdirectory the produced htmlfile, kmlfile and xmlfile will be copied in the correct ftpdirectory in your ftphost using ftpuser and ftppassord via ftp.
sendmail to set the local sendmail or similar command. The default is sendmail -t -oi -oem mailhost to set the local or remote smtp host (you can use also the ip address)
mailfrom please change this default nobody@nobody.com with your email
mailsubject the Subject of the email (Your report is the default)
mailbody the body of the email (In attach your report is the default). You can make a multiline body using \n like end of line.
In the directory example you can find the files of this example.
These are the first 3 lines of my csv
lat;long;logo;url;company;company description;address;ZIP;city;state;email;emaillabel;phone;fax;other;image
45.463;9.181;http://www.pivari.com/images/1x1.jpg;www.peregosolera.it;Perego & Solera Comunicazione Integrata; ;Via Sant'Orsola, 10;20123;Milano;MI;info@peregosolera.it;info@peregosolera.it;+39 02 72021363;+39 02 72021652;<br />Ufficio in Germania<br />Tel. +49 (0) 8709 915498<br />Fax +49 (0) 8709 915997;
45.453;9.168;http://www.btp.it/images/logo%20btp%202.jpg;www.btp.it;BTP&P; ;Via Tortona, 14;20144;Milano;MI;btp@btp.it;btp@btp.it;+39 02 58104110;+39 02 89404410;