The data from the Modern.gov RSS feed needs to be reformatted before it can be used by iShare. This is done via a Stored Procedure Task. In the tree, right click on the Update Modern.gov Data Job you have just created and select New Task.
...
Task Details
Enter the following:
Task Name
Enter a Name for the task e.g. Format Modern.gov Councillors
Connection
Select the Data Share database from the list.
Stored Procedure
First 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 listlist (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).
Parameters
Click on Parameter 1. cmdtoexecute and enter the following:
...
| Info |
|---|
This example provides county councillor information using OS BoundaryLine's County Electoral Division data. Adjust the tablename in the snippet above if the table has a different schema and name in your database. To run the same process for borough, district or unitary councillors use the 'boundaryline.district_borough_unitary_ward' dataset and change references from 'ED' to 'Ward'. |
...