City Works Sync.

POSM 10 can now sync inspections into a CityWorks SQL Database with the built in CityWorks Sync tool. To ensure sessions sync it is very important that the AssetID for the inspection matches the Pipe_IDs in cityworks. Using POSM Map Reader with POSM Server GIS Tools is the best way to ensure these IDs will always match. The WorkOrder special field may also be used to pre-load the Work Order number into the session and therefore to link back to CityWorks. If the work order number does not exist in the session, one should be created in CityWorks and then entered into the Sync tool before adding the inspections to the Work Order.

To use this tool the SQL connection data for the CityWorks database will need to be entered into the CityWorks fields. To test that the connection is working, press the Open Connection button. If the connection is good an OK box will return and the CW Table and CW Obs Table drop downs will be populated.

A mapping template will need to be created for each type of inspection, PACP, LACP and MACP in this example. Selecting the Nassco PACP template, the search button may be pressed to find all inspections that have not been Exported to Cityworks by searching for field Exported To GIS = False. Ensure that the CW Table is selected for the correct CityWorks TV Inspection table. Ensure that the CW Obs Table is selected for the correct CityWorks TV Observation table if it is desired to have Observation data imported into Cityworks. For each TV Inspection field to be imported from POSM to Cityworks, a Match must be created. Using the CW Field match the field to the POSM Field dropdown and then press Add Match. If an improper match is made it may be deleted by pressing Delete Match. Once all the matches have been made inspections may now be added to CityWorks. Select the sessions to sync with Cityworks. Enter in the Work Order number to assign to these inspections. If a work order number is in the inspection already it will use the inspection number in the POSM database. If there is not a work order number it will use the number supplied in the Work Order Sync tool. Press the “Add to Inspections” button. The software will display the number of sessions added and an OK box when complete. POSM will mark the added inspections as Exported so they do not show up in the search again.

Querying the Cityworks database now shows the newly added inspections.

Querying the [STVOBSERVATION] table for the TV inspection added will show the newly added observations to the Cityworks TV Inspection.