Re: [dev] Entry point @ Utilities page
Hi Alex,
What exactely do you want to do ?
I did add some phone number and billing system information on our OTRS
customer_user.
I changed the customer_user table added some columns.
Then you need to change the Config.pm.
Then I realized that the phone view customer lookup slowed down (I have
some 800.000 customers)so we added some indexes on the same table and
changed DB.pm files and Config.pm.
Speed is fine now; really faaaaast.
Plus developped a little perl script to updat the data fom our billing
system during the night.
I posted a low level howto on otrs earlier this year.
If this what you are looking for, try the archive. If you do not find it
there I can resubmit.
hth
Paul
"Alex Mihicinac"
Heya Paul,
What exactely do you want to do ? I did add some phone number and billing system information on our OTRS customer_user. I changed the customer_user table added some columns. Then you need to change the Config.pm. Then I realized that the phone view customer lookup slowed down (I have some 800.000 customers)so we added some indexes on the same table and changed DB.pm files and Config.pm. Speed is fine now; really faaaaast.
I need much simpler thing - I'd like to have links (URLs), which would take me to the OTRS search page and show all tickets related to one specific customerID (that ID would be passed to search engine via URL variable probably?). For example: when i click specific url (somewhere on the web, not in otrs) OTRS would open a search page and display all tickets related to searched customerID. Is that possible? Best regards, Alex
On Mon, Nov 24, 2003 at 04:48:35PM +0100, Alex Mihicinac wrote:
What exactely do you want to do ? I did add some phone number and billing system information on our OTRS customer_user. I changed the customer_user table added some columns. Then you need to change the Config.pm. Then I realized that the phone view customer lookup slowed down (I have some 800.000 customers)so we added some indexes on the same table and changed DB.pm files and Config.pm. Speed is fine now; really faaaaast.
I need much simpler thing - I'd like to have links (URLs), which would take me to the OTRS search page and show all tickets related to one specific customerID (that ID would be passed to search engine via URL variable probably?). For example: when i click specific url (somewhere on the web, not in otrs) OTRS would open a search page and display all tickets related to searched customerID. Is that possible?
http://host/otrs/index.pl?Action=AgentCustomer&Subaction=CustomerID&Customer... The same as AgentInterface -> Utilities -> Customer History. .-)
Alex
Martin -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
http://host/otrs/index.pl?Action=AgentCustomer&Subaction=CustomerID&Cust omerID=XYZ
The same as AgentInterface -> Utilities -> Customer History. .-)
Great! That's what I was looking for! :) Thanks Martin & Paul! Best Regards, Alex
participants (3)
-
Alex Mihicinac -
Martin Edenhofer -
Paul Rhein