Welcome to Data Upload with FME Server. In this series, we are going to explore data
upload options from the FME Server web interface. We will need to do some preparation before
we can perform data upload through the FME server web interface. This is to prepare and
publish a workspace to FME server. If you're doing this with me, download and unzip the
template attached to this tutorial. Open the workspace called 1_CheckFieldStatus in
the workspaces folder. This workspace takes a CSV file containing information about the
availability of playing fields and combines it with the MapInfo tab file showing park
locations in the city of Vancouver. We also do a bit of KML styling and attribute cleanup
before writing out the data to KML. Now the field availability can change from week to
week so we want to create a workspace that can read the most up-to-date version of the
CSV file and regenerate the KML with the new information without having to modify the workspace
every time. We achieve this with user parameters. Let's set up our source CSV reader parameter
with a user parameter. Expand the CSV reader. In the navigator pane right-click on the CSV
File parameter and choose Create User Parameter. In the dialogue dropdown select the Type field
and change this to File Name Existing because the user will provide an existing file. Change
the Prompt to Field Status CSV file. This is what the user is asked to provide when
the workspace runs. Click OK. Notice back in her Navigator window that our new user
parameter appears under Published Parameters in the User Parameter section. Let's run the
workspace locally using the Prompt and Run workspace tool. Notice our new user parameters.
Let's pick the weekendplayfieldstatus.CSV file and click OK to run the workspace. Let's
take a quick look at the results in Google Earth. Right-click on the destination feature
type and select Open Containing Folder. Double-click on the KML file that was just created. This
opens the file in Google Earth. Remember we'd used the KML Styler to color parks red that
had a weekend status of Closed. Let's click on a red park and notice we have fields like
closure notice and weekend status, and indeed the weekend status is closed. Now let's publish
the workspace to FME server. Click on the Publish to FME server tool. Enter the credentials
for your FME server, then click Next. Let's publish this workspace into a new repository.
Click on New next to Repository Name and enter Data Upload for the repository name. Let's
also enter a description like 'workspace repository for data upload tutorial'. Click OK. Notice
that by default that Upload Data Files is checked. Let's take a look at which files
are being uploaded. Click on Select Files. The Parks files are all from our MapInfo dataset.
Leave those alone. Uncheck the CSV file at the bottom, because remember, we want the
user to provide the CSV file for this workspace. Click ok until youre back to the Publish Workspace
dialog. Then click Next. Make sure your workspace is registered with both the Data Download
and the Job Submitter services. Click Publish to publish the workspace to FME server.