Versions Compared

Key

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

...

  • Right click on the Jobs entry you have just created to Refresh the EduBase Data in the tree and select New Task.
  • Select Spatial Data Transformation as the task type and click OK.

Image RemovedImage Added

Task Name

Enter a Name for the task. In the above example we have chosen Download EduBase Data Update EduBase

Source Data

Here you need to select the WFS Workflow Connection you have just created.

...

Here you need to select the correct table for the type of EduBase data that you wish to extract from EduBase. This is actually a layer name and the options are:

      • all (All Services)
Info

Note: If there is no drop down selection then it is possible that you are missing the errorconfig.xml file from your Studio\config folder.

...

Enter a name for the Table that you wish to create in the PostgreSQL database; we have chosen edubaseeducation.edubase as we want to create an education table in the education schema.

  • Click Save to update the Studio with your changes.

...

  • Right Click on the Task you have just created and select Run Task Download EduBase DataUpdate EduBase or whatever you have called it. This may take a little while but you should see a successful completion message when the download has finished. This will import the WFS feed into the specified table.

...

If you open pgAdmin and select the Datashare database you should see your new edubase table.  Have a look at the table structure to see which columns you might wish to use as part of your select statement when updating the .MAP file for EduBase. You may also wish to create separate Tasks to split the data into individual tables for each type of School e.g. Nursery, Primary, Secondary etc.

...