Database Operational Interfaces - Description

DESCRIPTION

RaPTr Server will communicate with a MySQL, Microsoft SQL Server, or Oracle database via a stored procedure. RaPTr Server will call the stored procedure and provide the barcode that was scanned, and the LocationID of the scanner. From there, custom business logic can be performed, and a response generated. The response will be sent back to the scanner and displayed for the operator. The response contains a message (Response), a background color (ResponseColor), and a Pallet Status. The Pallet Status is used to log events where the barcode scanned did not belong at that location.

Optionally, an order number can be returned. The order number will be logged by the server and can be used to search for pallets in the RaPTr Web Reporting Server. Furthermore, the stored procedure can update the meta data section of the RaPTr Scanner that triggered the event by providing HTML in the MetaDataDisplay parameter. To play audible feedback on RaPTr Scanner, provide an Audible Key. This corresponds to the Sound ID parameter on the RaPTr Scanner audible configuration. Finally, a Dwell Time (milliseconds) can be specified to control how long the response message will remain on the screen for the operator. Specifying a value of 0 will result in the default response dwell time being used.

In most cases, the Supervisor puts the necessary pallet information into a database table once an order is made and the stored procedure verifies pallet scans to those tables.

PARAMETERS

Parameter	Definition
Database Connection String	Connection string to the database of choice. Typically includes security credentials
Stored Procedure Name	Name of the stored procedure to be called by RaPTr Server