Versions Compared

Old Version 3

changes.mady.by.user Robert Sutton (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Robert Sutton (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


The generic database plugin allows Noojee Answer to use an external database to map caller details into a url or fragment of javascript, paste data, caller name and display text.

JDBC

The generic database plugin uses JDBC (java's equivalent of ODBC) to access virtually any database.

The plugin needs the following configuration information:

...

Code Block
linenumberstrue
<crm-plugin>
    <class>au.com.noojee.answerbar.server.plugin.JdbcPlugin</class>
        <params>
	    <jdbcUrl>jdbc:mysql://127.0.0.1/asterisk?user=asterisk&password=fred
	    </jdbcUrl>
	    <driverClass>com.mysql.jdbc.Driver</driverClass>
	    <query>call getData("plugins": {
     "JdbcPlugin": {
    "params.jdbcUrl": "jdbc:sqlserver://host;DatabaseName=xxxxxxx;user=xxxxxxxx;password=xxxxxxxxx",
    "params.driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
    "params.query": "exec getJAVA ?,?,?,?,?,?,?,?)</query>
	    <channelVariable>account</channelVariable>
	    <channelVariable>country</channelVariable>
	</params>
	<filter>
	    <didPattern>410</didPattern>
	    <queue>test</queue>
	</filter>
</crm-plugin>",
    "channelVariables": ["UNIQUEID","UNIQUEID","UNIQUEID","UNIQUEID","UNIQUEID","UNIQUEID"],
	"filter":{
	    "didPattern":"410",
	    "queue":"test"
	}
}