convertcsvgoogle earth
Does anyone know a workable and stable program which converts csv extension files to kml?
There are many tools available online but none of them worked for me.
I tried many including
I will be grateful if someone can direct me to something working.
In order to upload csv to FusionTables, you'll need to make sure you authenticate first. I see you've included the dependencies for OAuth, but if you're just trying to have a script do a simple upload, it'd be easiest to use ClientLogin (and you don't need the dependencies). A skeleton of the code should look something like this (adapted from the sample code in the python library you referenced):
from authorization.clientlogin import ClientLogin
from sql.sqlbuilder import SQL
import ftclient
from fileimport.fileimporter import CSVImporter
token = ClientLogin().authorize(username, password) #Replace with your username and password (or prompt for them would be more secure)
ft_client = ftclient.ClientLoginFTClient(token) #ft_client needs to be used from here on out to make any calls to the FusionTables SQL API
#If you want to CREATE a table from the csv...
tableid = int(CSVImporter(ft_client).importFile("data.csv")) #Replace with your csv data source (or prompt for the location would be less hard-coded)
print tableid #This will print out the ID of your new table, but the table should also show up in Google Docs for the username you used to authenticate.
If you want to add rows to an existing FusionTable, that'll be trickier. It would probably take parsing out the CSV with csv.DictReader or something and then iterating over that and uploading those rows using something like...
#update row using dictionary of values
print ft_client.query(SQL().update(tableid, cols={'strings': 'mystring3'}, row_id=rowid))
print ft_client.query(SQL().select(tableid))
...for each row.
In the save as dialog you will see a drop down labelled geometry which let's you choose x, y instead of wkt.
Best Answer
There are 2 immediate options that would best get you where you are trying to go.
Your first, and probably easiest option, would be to download Quantum GIS, using the OSGeo4W Installer.
Once you have installed that program, follow this tutorial, which covers Importing a .csv file to QGIS.
Once you have imported the file, simply right click on the layer in the table of contents, choose Save As, and save as ".kml".
Here is a link to the QGIS User Documentation, to help you get started.
Try the OGR Simple Features Library, specifically the ogr2ogr utility. This program lets you specify your input file, input file format, output file, and output file format, as well as projections and geometry columns, if necessary.
Here is the section of documentation about reading CSV files, and creating spatially enabled layers from them: Comma Separated Value