I need to go from EXCEL in address form TO KML

Hi,

 

 

A basic way is: 1) Start the FME Workbench with a blank workspace. 2) Add an Excel reader to read the Excel spread sheet.  3) Add a KML writer to write a kml file, and define user attributes named "St Num" and "Street Name" in the writer feature type. 4) Connect the reader to the writer, then run the workspace. If attribute names provided by the Excel reader are not preferable, rename them with the AttributeRenamer after reading features.   By the way, I think a kml file is usually used to save spatial data, i.e. geometries and corresponding attributes. Do those attributes have to be written together with geometries (maybe line shapes)? If so, you probably should consider how to merge geometry (where come from?) and attributes (from Excel file) before writing. e.g. using the FeatureMerger. If you have any question about this, please let us know your actual conditions.

 

 

Takashi

Hi,

 

 

You can try the GoogleGeocoder from the FME store, but you need more than just st num and strret name for that (or for any other type of geocoding for that matter)

 

 

Itay

download the transformer and see for yourself....type google on the fme cnavas the store transformer should appear.

Good example of why the documentation should be searched first ....