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 (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).

Parameters

Click on Parameter 1. cmdtoexecute and enter the following.

DROP TABLE IF EXISTS roadworks;

If your table name is not all lower case you will need to add " quotes to the table name e.g. "Elgin Roadworks".

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

Browser not supported