Drop the Elgin Roadworks table
...
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.
| Code Block |
|---|
DROP TABLE IF EXISTS "Elgin Roadworks"roadworks; |
| Note |
|---|
As this If your table name is not all lower case you will need to add " quotes to the table name as shown above. |
...
e.g. "Elgin Roadworks". |
Click Save to update the Studio with the changes.
...
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.
...