Versions Compared

Key

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

Table of Contents

...

  • In the tree, right click on the Build Councillors (CMIS) Job you have just created and select New Task.
  • Select the Program type and click OK.


Task Details

...


Name

Enter a Name for the task e.g. Fetch CMIS Councillors.

Program

Browse to the python executable e.g. c:\python27\python.exe

Additional Parameters

Here you need to enter the link to the python script to download the CMIS data e.g.

...

  • Right click on the Build Councillors (CMIS) Job you have just created and select New Task.
  • Select the Spatial Data Transformation type and click OK.

Task Details

Enter the following:

Name

Enter a Name for the task e.g. CMIS Import councillors.csv

Source Data

Select Comma-Delimited Text File

Filename

Enter the path to the generated councillors.csv  file e.g. D:\Astun\iShareGIS\5.4\Studio\config\councillors.csv

Output

Select your Data Share database from the list e.g. iShareData

Table

Enter the name of the table that you wish to be created in the Data Share database e.g. councillors

Force Geometry

Tick the Force Geometry box and select NONE from the list.

Show expert mode

Tick the Show expert mode and then enter the following in the Additional Parameters.

...

  • Right click on the Build Councillors (CMIS) Job you have just created and select New Task.
  • Select the Stored Procedure type and click OK.

...

Enter the following:

Name

Enter a Name for the task e.g. CMIS - Create councillor_html

Connection details

Select the Data Share database from the list.

Function

Select at_sys_create_table entry from the list.

Parameters

The at_sys_create_table function requires two parameters. First select the parameter from the list and then you will be able to enter the value in the Edit parameter area.

...

  • Right click on the Build Councillors (CMIS) 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 e.g. CMIS - Create councillor_ward

Connection details

Select the Data Share database from the list.

Function

Select at_sys_create_table entry from the list.

Parameters

The at_sys_create_table function requires two parameters. First select the parameter from the list and then you will be able to enter the value in the Edit parameter area.

...