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