| Table of Contents |
|---|
...
The script must be modified to specify the URL for the CMIS SOAP web service and details of any Proxy.
| Note |
|---|
The IP address of the server which is running the download script will normally need to be whitelisted by CMIS in order for the URL to be accessible. |
- Open the GetCMISPeople.py, which you will find in the ...Studio\config folder for your iShare installation, in a Text Editor such as Notepad++.
...
- 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.
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.
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.
Name
Enter a Name for the task e.g. CMIS - Create councillor_html
Connection details
Select the Data Share database from the list.
Function
Click on the Astun radio button and select at_sys_create_table entry from the list (from v6.0.0 this is called wkf_create_table under the -Workflow- Function filter).
Parameters
The at_sys_create_table function requires two parameters (the wkf_create_table function in v6.0.0 has one extra parameter being the schemaname in which you wish to create your table).
...
- Right click on the Build Councillors (CMIS) Job you have just created and select New Task.
- Select the Stored Procedure type and click OK.
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 Click on the Astun radio button and select at_sys_create_table entry from the list (from v6.0.0 this is called wkf_create_table under the -Workflow- Function filter).
Parameters
The at_sys_create_table function requires two parameters (the wkf_create_table function in v6.0.0 has one extra parameter being the schemaname in which you wish to create your table).
First select the parameter from the list and then you will be able to enter the value in the Edit parameter area.
...