JDBC Call Logger

Connection properties for the JDBC Call Logger are taken from the "External Connections" configuration under the "System" menu of Noojee Administrator.

Sample config:

Field	Description	Default
Class name	Is the fully qualified class path of the JDBC Call Logger, this value should not be changed.	au.com.noojee.service.crm.calllogger.CrmCallLoggerJDBC
Did Numbers	Allows filtering with multiple instances of Call Loggers base on the DID number of the call.
Method	SQL that will be exeuted, note the use of ? for parameters, there must be exactly eight and their order is as per the example. You can invoke a procedure call if preferred.
Connection	A connection that is configured in Noojee Administrator in the "External Connections" page.
Extra Args	used by some special loggers - not this one.

SQL parameters

Parameter	Description
agent	Login of the agent involved in the call.
callerid	The caller Id of the other party.
disposition	The disposition in text format
dispositionid	Integer value of the disposition
duration	The duration of the call
uniqueCallId	The Unique id of the call
timeStamp	Unix timestamp of the start of the call
inbound	direction of the call 1 = inbound 0 = outbuond

Sample stored procedure for MSSQL

CREATE PROCEDURE [dbo].[someArbitraryName]
    @agent varchar(50), @callerid varchar(20), @disposition varchar(50), 
    @dispositionid int, @duration int, @uniqueCallId varchar(20), @timeStamp bigint,
    @inbound int
AS
BEGIN

	insert into someArbitraryTable ([agent], [callerid], [disposition], [dispositionid], [duration], [uniqueCallId], [timeStamp], [inbound]) 
			 values (@agent, @callerid, @disposition, @dispositionid, @duration, @uniqueCallId, @timeStamp, @inbound);

END

Method to call this stored procedure is

call someArbitraryName ?,?,?,?,?,?,?,?