Querying a SQL database from within OTRS
Hello, I work for a customer support organization that is looking at otrs for a trouble ticketing system. I currently have a SQL database containing all of the customers information and would like to have the agent be able to make queries back to the database from the open ticket screen. For example I would like them to be able to select a customer name from a dropdown list and have all the customer information populated or enter a serial number and have it query the database for customer information. If anyone has experience doing this any assistance would be appreciated. Thanks Chris
On Wed, 13 Oct 2004 16:13:51 -0400, Chris Sanford
Hello, I work for a customer support organization that is looking at otrs for a trouble ticketing system. I currently have a SQL database containing all of the customers information and would like to have the agent be able to make queries back to the database from the open ticket screen. For example I would like them to be able to select a customer name from a dropdown list and have all the customer information populated or enter a serial number and have it query the database for customer information. If anyone has experience doing this any assistance would be appreciated.
You probably should check the customer backend modules, and modify/write them suiting your needs... -- Now using M2, Opera's e-mail client: http://www.opera.com/m2/
participants (2)
-
Chris Sanford -
Peter Gervai