Posts

Showing posts from March, 2013

OTRS - Adding new columns to customer database

Finding proper documentation on OTRS has been difficult for me so far. Maybe the reason behind this is, OTRS supports tons of great features, and to document everything that can be done is difficult. Nonetheless, OTRS is a fantastic software.

Recently, our company needed to add some columns in the OTRS backend database. As I work in a company that deals with the Internet, we needed to integrate customer bandwidth and prefix information to OTRS database. After some stumbling and trial and error, here's what can be done -

Part 1: Creating the columns
mysql -p mysql> use otrs; mysql> ALTER TABLE customer_user ADD bandwidth VARCHAR (50); mysql> ALTER TABLE customer_user ADD prefix VARCHAR (250); mysql> quit;
Part 2: Tuning OTRSvim /opt/otrs/Kernel/Config/Defaults.pm ## And we add the following lines [ 'UserBandwidth', 'Bandwidth', 'bandwidth', 1, 0, 'var', '', 0 ], [ 'UserPrefix', 'Prefix', 'p…