Weigh bridge Configuration

Weigh bridge Configuration

Prerequisites:

1. Farvision API hosting server should have below configurations ready:

a. Dot Net framework v 4.6 (minimum)

b. IIS version 7.0

c. Windows OS 10

d. SQL server should be installed with a blank db

e. Table TFA_WEIGHBRIDGEDATA needs to be created & its structure mentioned below:

Table Name :-	TFA_WEIGHBRIDGEDATA
Column name	DataType	Length	Field Details
Id	INT		Identity Column
BUId	INT		Farvision Business Unit Internal ID
QTY	DECIMAL	21, 3
IMG_CAMERA1	VARBINARY	max
IMG_CAMERA2	VARBINARY	max
IMG_CAMERA3	VARBINARY	max
IMG_CAMERA4	VARBINARY	max
WeighbridgeId	INT
Weighbridgeno	Nvarchar	50

2. API hosting server should have active internet connection

3. API hosting will be done by Gamut Release Team

4. After hosting this API, url to be shared with Gamut

5. Farvision business unit name with id to be shared with Weigh bridge vendor

Steps:

1. TFA_WEIGHBRIDGEDATA table needs to be created in blank db by Gamut Team

2. Weigh bridge vendor will insert the data in TFA_WEIGHBRIDGEDATA table in following columns

BUID, QTY, IMG_CAMERA1, IMG_CAMERA2, IMG_CAMERA3, IMG_CAMERA4

3. Once the Farvision user will click on the Get Weight option in Farvision Vehicle in/out option, this will initiate the API calling & same will check the latest available data in TFA_WEIGHBRIDGEDATA table & reflect the Quantity data in Farvision.

Note: There will be a single row against any business unit in TFA_WEIGHBRIDGEDATA table, data will be inserted for new business unit & for next time onwards the same row will be updated with updated information against the same business unit.

Vehicle In/Out

4. Quantity & attachment will be fetched from weigh bridge software

Vehicle inward: Document print will have the same attachments print