Dynamic Routes Example configuration - Revision history

John at 06:42, 16 June 2016

2016-06-16T06:42:38Z

← Older revision		Revision as of 08:42, 16 June 2016
Line 27:		Line 27:


	The ~~dynamic routing~~ module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow [[Creating_a_MySQL_table_for_use_with_Dynamic_Routes\|this example]].		The Dynamic Routes module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow [[Creating_a_MySQL_table_for_use_with_Dynamic_Routes\|this example]].

	Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be		Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be

John: John moved page Example configuration to Dynamic Routes Example configuration without leaving a redirect

2016-06-13T13:20:16Z

John moved page Example configuration to Dynamic Routes Example configuration without leaving a redirect

← Older revision		Revision as of 15:20, 13 June 2016
(No difference)

John at 09:33, 13 June 2016

2016-06-13T09:33:49Z

← Older revision		Revision as of 11:33, 13 June 2016
Line 31:		Line 31:
	Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be		Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be

	SELECT priority FROM customer_priority WHERE callerid like '%[NUMBER]'		<pre>SELECT priority FROM customer_priority WHERE callerid like '%[NUMBER]'</pre>

	Dynamic Routes will substitute the [NUMBER] symbol for the incoming callerid if one is present.		Dynamic Routes will substitute the [NUMBER] symbol for the incoming callerid if one is present.

John at 09:32, 13 June 2016

2016-06-13T09:32:29Z

← Older revision		Revision as of 11:32, 13 June 2016
Line 123:		Line 123:
	[[File:Dr_page1.png]]		[[File:Dr_page1.png]]

	[[File:~~Dr_page2~~.png]]		[[File:Dr_page2c.png]]

John at 09:30, 13 June 2016

2016-06-13T09:30:51Z

← Older revision		Revision as of 11:30, 13 June 2016
Line 123:		Line 123:
	[[File:Dr_page1.png]]		[[File:Dr_page1.png]]

	[[File:~~Dr_page2a~~.png]]		[[File:Dr_page2.png]]

John: /* Set the queue priority of callers, allowing "top" customers to receive a faster answer */

2016-06-13T09:25:13Z

Set the queue priority of callers, allowing "top" customers to receive a faster answer

← Older revision		Revision as of 11:25, 13 June 2016
Line 27:		Line 27:


	The dynamic routing module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow [[Creating_a_MySQL_table_for_use_with_Dynamic_Routes this example]].		The dynamic routing module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow [[Creating_a_MySQL_table_for_use_with_Dynamic_Routes\|this example]].

	Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be		Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be

John: /* Set the queue priority of callers, allowing "top" customers to receive a faster answer */

2016-06-13T09:24:48Z

Set the queue priority of callers, allowing "top" customers to receive a faster answer

← Older revision		Revision as of 11:24, 13 June 2016
Line 27:		Line 27:


	The dynamic routing module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow ~~this example.~~		The dynamic routing module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow [[Creating_a_MySQL_table_for_use_with_Dynamic_Routes this example]].
	[[Creating_a_MySQL_table_for_use_with_Dynamic_Routes]]

	Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be		Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be

John at 09:24, 13 June 2016

2016-06-13T09:24:03Z

← Older revision		Revision as of 11:24, 13 June 2016
Line 28:		Line 28:

	The dynamic routing module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow this example.		The dynamic routing module does not actually create the database, table, user to access the database or grant permissions. These are assumed to existing already. If you need help setting up please follow this example.
	[[~~xxxx~~]]		[[Creating_a_MySQL_table_for_use_with_Dynamic_Routes]]

	Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be		Let's assume that you have created a table caller "customer_priority" in database "customer" and it has the columns "callerid" and "priority" as in the above table. Your sql lookup would be
Line 38:		Line 38:
	We will also assume that the database is located on the localhost and that there is a user of "dr_user" and password "xxxxxxxx". If possible you should verify that you can connect to the database and execute a select query on the table, for example:		We will also assume that the database is located on the localhost and that there is a user of "dr_user" and password "xxxxxxxx". If possible you should verify that you can connect to the database and execute a select query on the table, for example:

	<pre>mysql -u dr_user -p ~~xxxxxxxx~~		<pre>mysql -u dr_user -p
			use customer
	SELECT * FROM customer_priority;</pre>		SELECT * FROM customer_priority;</pre>

John at 09:17, 13 June 2016

2016-06-13T09:17:36Z

← Older revision		Revision as of 11:17, 13 June 2016
Line 97:		Line 97:
	\|-		\|-
	\| MySQL database		\| MySQL database
	\| ~~customer_priority~~		\| customer
	\|-		\|-
	\| MySQL username		\| MySQL username

John at 09:00, 13 June 2016

2016-06-13T09:00:15Z

← Older revision		Revision as of 11:00, 13 June 2016
Line 123:		Line 123:
	[[File:Dr_page1.png]]		[[File:Dr_page1.png]]

	[[File:~~Dr_page2~~.png]]		[[File:Dr_page2a.png]]