Glad I could help :) Unfortunately my problem is different , I am using ldap and HttpBasicAuth for CAS. With this setup it seems impossible to populate the customer table ! Chris ----- Original Message ----- From: Karnan Seevaratnam To: croffler@earthlink.net;Development community of OTRS.org Sent: 1/9/2007 11:57:35 PM Subject: RE: [dev] Customer Backend Hi Chris, Following is the table structure that I want to have it as a drop downlist on the PhoneTicket section. CREATE TABLE `customers` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `parent` int(11) NOT NULL default '0', `active` smallint(6) NOT NULL default '1', `expires` bigint(20) NOT NULL default '-1', `balance` int(11) NOT NULL default '0', `credit` int(11) NOT NULL default '0', `maxin` int(11) NOT NULL default '-1', `maxout` int(11) NOT NULL default '-1', `maxtotal` int(11) NOT NULL default '-1', `email` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name_2` (`name`), KEY `name` (`name`), KEY `parent` (`parent`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; I don�t want to authenticate or do any kind of validation, suppose if a customer calls and my support staff will be creating a new phone ticket and select one customer. And this will just add these customer information to the comment field. Thank you for your help. Karnan From: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] On Behalf Of Chris Roffler Sent: Tuesday, January 09, 2007 3:43 PM To: dev@otrs.org Subject: [dev] Customer Backend We have implemented OTRS with CAS using HTTPBasicAuth and the Customer back end is setup with ldap. We need to create location based reports for tickets. For example we want to create reports that show tickets that have been created in the state of NY in NY City by Queues. I have all the Customer / GIS information in ldap. I need to bring this GIS info for each user somehow into the OTRS customer table so I can create these reports. Since I am using HTTPBasicAuth the users are not imported into the OTRS DB. Is there a way to populate the customer table ? Thanks Chris