

If you want to run tasks periodically you should take a look at FME Server… I was not able to find out to start a follow-up process if the “storing process” was successful or not.

Furthermore I needed to start this last process with a so-called creator.
#Fme etl Pc
I ended up with calling WinSCP on my Windows PC with some custom commands. The normal FTPCaller was not working with our sftp digital-geography server (…). Therefore I needed to use the System Caller Transformer. The hard one was to get it on the server so a potential webmap application could work with the data. I loaded it back again from this file and saved it again as geoJSON. To work on with it I needed to store it on my hdd. After choosing the Google Sheet reader I needed to replace some strings and format my lat/lon columns and defined the lat/lon columns for the Geometry. There all the fancy processes and tasks are stored like string manipulation, spatial queries and even an IP geocoder or the What3WordsEncoder.
#Fme etl software
The help section of this software is really great and you will find plenty of video tutorials for this baby made by FME.įor the second task I needed some more magic from the so-called Transformer Gallery. Take care of string formatting a bit and decide which columns you really need and off you go.

The first task was done quite easy as you simply load the excel with a file reader process and attach three different file writers to it.Įxample view of a a process after run of FMEĪs you simply need to define the lat/lon columns everything else is done by the program. You’ll get support for over 350 file formats. The software itself can be used in three-way: Desktop version, Server version or Cloud version. For short-term tests they offer a 30 day trial. Despite this price: If you need software like FME for your studies, just drop them a line as they have an academic grant program. An indicator for the price is set at the cloud provider. The installation is a no-brainer but this does definitely not come for free.
