Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Select the Stored Procedure type and click OK.

Task Details

Enter the following:

Task Name

Enter a Name for the task e.g. Format Modern.gov MPs

Connection

Select the Data Share database from the list.

Stored Procedure

First select the Astun radio button as this will limit the list of available stored procedures and then select the at_sys_create_table entry from the list.

Parameters

Click on Parameter 1. tablename and enter moderngov_mps_spatial in the Edit parameter 'tablename' box e.g.

...