Drop the Elgin Roadworks table
Dropping the table makes sure that you get rid of any existing information before trying to upload the new data. To do this you will need to add another Task entry. In the tree, right click on the Elgin Roadworks Job you have just created and select New Task.
Select the Stored Procedure type and click OK.
Task Details
Enter the following:
Name
Enter a name for the task. We have chosen Elgin – Drop roadworks.
Connection Details
Select your Data Share database from the list. Then select the Workflow radio button as this will limit the list of available stored procedures and then select the at_wkf_executecmd entry from the list.
Parameters
Click on Parameter 1. cmdtexecute and enter the following.
DROP TABLE IF EXISTS "Elgin Roadworks";
As this table name is not all lower case you will need to add " quotes to the table name as shown above.
Click Save to update the Studio with the changes.
Download the Elgin data
We need to create a task to download the Elgin data to an XML file on the iShare server. To do this you will need to add another Task entry. In the tree, right click on the Elgin Roadworks Job you have just created and select New Task.
Select the Program type and click OK.
Task Details
Enter the following:
Name
Enter a Name for the task. We have chosen Elgin – Download data to file.
Program
Browse to the python executable e.g. c:\python25\python.exe
Additional Parameters
Here you need to enter the link to the python script to download the Elgin data e.g.
F:\Astun\iShare\Studio\config\feedxml-elgin-download.py
Click Save to update the Studio with the changes.
Now you need to Run this Task to actually download the data. Either click on the Run button or right click on the Task in the Explorer and select Run Task Elgin – Download data to file