RE: [dev] Entry point @ Utilities page
Hi Alex,
Sounds pretty straight forward. Those are options in ../Kernel/Config.pm. Check out the ../Config/Defaults file.
Here is mine, ignore the parameterEPTCustomerUserSearch => 1.
We do have a jsp running on the billing system that answeres our requests. Have a look at the line starting with [ 'UserCustomerID'.
hth
-p.
$Self->{CustomerUser} = { Module => 'Kernel::System::CustomerUser::DB',
Params => {
Table => 'customer_user',
EPTCustomerUserSearch => 1,
},
CustomerKey => 'login',
CustomerID => 'customer_id',
CustomerValid => 'valid_id',
CustomerUserListFields => ['first_name','last_name','phone','email'],
CustomerUserSearchFields => ['last_name','email','phone'],
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['first_name','last_name'],
# Login Email and Customer_id are needed !!!
# var, frontend, storage, shown, required, storage-type, link
Map => [
[ 'UserSalutation','Salutation','salutation',0,0,'var'],
[ 'UserFirstname','Firstname','first_name',1,0,'var'],
[ 'UserLastname','Lastname','last_name',1,1,'var'],
[ 'UserPhone','Phone','phone',1,0,'var'],
[ 'UserEmail','Email','email',1,0,'var','$Env{"CGIHandle"}?Action=AgentCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}'],
[ 'UserCustomerID','ICMS
ID','icms_id',1,1,'var','http://10.10.0.5/RensClient/DetailClientNew.jsp?CustomerID=$Data{"CustomerID"}&Multiplicator=1'],
[ 'UserComment','Comment','comment',0,0,'var'],
[ 'ValidID','Valid','valid_id',0,0,'int'],
[ 'UserAddress','Address','address',1,0,'var'],
[ 'UserPassword','Password','pw',0,1,'var'],
[ 'UserLogin','Login','login',0,1,'var'],
[ 'info_source','Info','info_source',0,0,'var'],
],
};
"Alex Mihicinac"
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 _______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
participants (1)
-
Paul Rhein