TCDC Maintaining Interface Data - Pathway
The interface between biscoPro and Pathway uses a custom built Web Service to move data between the two systems developed by Ben Sole (TCDC) and Stuart Cross (bisco). There are various SQL statements and stored procedures used to do this.
In Pathway each inspection has a unique Inspection Type code and the description describes includes the inspection form and building category. biscoPro needs to know this information and the Pathway descriptions are a text field and not structured consisently enough to try and automatically determine this. Therefore we use a cross reference from the Pathway Inspection Type ID to provide the correct Inspection Code and Building Category to biscoPro.
This cross reference file needs to be updated whenever a new inspection type is added into Pathway.
File Location
The csv file is called InspectionProperties.csv and is located on the biscoPro server in C:\bisco\biscoLive for production or C:\bisco\biscoTest for the test system.
Inspection Cross Reference File
biscoPro needs to know different information about the inspections that is not supported well in Pathway provided by a mapping file that the web service uses.
The structure of the file is as follows:
|
InspectionType |
Inspection |
InspectionCode |
InspectionCategory |
|
295 |
Food sample inspection |
Office |
200 |
|
296 |
Low Risk Inspection |
Office |
200 |
|
297 |
Pre Inspection |
Office |
200 |
|
298 |
Followup Inspection |
Office |
200 |
|
299 |
Repeat food sample |
Office |
200 |
|
301 |
Pool Inspection |
Office |
200 |
|
302 |
Water Sample |
Office |
200 |
|
303 |
Land Classification |
403 |
200 |
|
304 |
Foundation Inspection |
403 |
203 |
|
305 |
2nd foundation Inspection |
403 |
203 |
|
306 |
Floor slab inspection |
406 |
203 |
|
307 |
2nd floor slab Inspection |
406 |
203 |
Field Definitions
The fields relate to:
InspectionType - the Pathway Inspection Type code
InspectionDescription - the description of the inspection (only used to make this file easier to use)
InspectionCode - the cost for the biscoPro element that represents the inspection. This mapps the inspection to the correct element within the biscoPro BIM model structure.
InspectionCategory - the unique ID for the inspection category sourced from the table GLOB_LICENSE.REC_ID.
The current Category values are:
GLOB_LICENSE
|
REC_ID |
NAME |
|
200 |
Building Category 1.1 |
|
201 |
Building Category 1.2 |
|
202 |
Building Category 2.1 |
|
203 |
Building Category 2.2 |
|
204 |
Building Category 2.3 |
|
205 |
Building Category 3.1 |
|
206 |
Building Category 3.2 |
|
207 |
Building Category 3.3 |
|
208 |
Building Category 3.4 |
If more categories are created they must first be created in the License Category Look Up table in Maintenance in biscoPro then updated into the cross reference file.
For more information about biscoPro Maintenance click <<here>>.
|
