JetTrac DBScanner

Introduction

Runs on a periodic basis (e.g. every one minute) to scan a SQL table to determine if a dispatch is required

How to Run JetTrac DBScanner

To run JTDBScanner, you will need these files in the same folder:

  • JTDBScanner.exe
  • ExitHandler.dll

Executable files and dll files should not be edited for any reason.

Default Functionality

Seamless integration between customer Dispatch system and JetTrac Field Service to kick off jobs with no user interaction required. Unlike most of JetTrac modules this program is not called from a Job Step of a job in the JMD. It is set up as a Windows service and runs continually on the service scanning a database for transactions to process.

JetTrac DBScanner Command Line

C:\DBScanner.exe   C:\configuration.ini   XMLFilePrefix   C:\file.log

JetTrac DBScanner Configuration.ini

type is SQL or ACCESS

DbType=SQL

DbConnection=TestDbScanner@DGLENO\SQLEXPRESS

#DbType=ACCESS

#DbConnection=TestDbScanner.accdb

DbUsername=username

DbPassword=password

#SqlStatement=SELECT * FROM TestTable WHERE Processed=No;

SqlStatement=SELECT * FROM TestTable WHERE Processed=0;

RowTag=row

JobName=job

UpdateColumnName=WorkOrderNo

#UpdateTemplate=UPDATE TestTable SET Processed=Yes WHERE WorkOrderNo IN (#$$#);

UpdateTemplate=UPDATE TestTable SET Processed=1 WHERE WorkOrderNo IN (#$$#);

optional

#FieldMap=Id>xmlClientId|Name>xmlName