RE: [otrs] Having customers update their phone information
My db experience is quite limited, so without assistance, I don't think I'd be able to do option A (create user_pref. phone table and create an update data link). If you guys would be willing to patch Kernel/System/CustomerUser/DB.pm, I think that this feature would be a great boon to the community at large. P.S. On an offhand topic, I don't see any links on how to donate to the OTRS development team on your website. Have you thought about setting up a paypal site and linking to it? -----Original Message----- From: Martin Edenhofer [mailto:martin@edenhofer.de] Sent: Wednesday, July 23, 2003 10:52 AM To: otrs@otrs.org Subject: Re: [otrs] Having customers update their phone information Hi Jake, On Wed, Jul 23, 2003 at 09:03:14AM -0400, Covert, Jake wrote:
As of 1.1.2, I added the phone information into our database and now require all new users to add that information.
But we have about 500 users who we would like to have update their phone number. Is there any way I can add that field to their preferences page and make it editable by them?
It would be possible to add a customer user preferences named phone and it would be possible to make it editable by them (just a config option). But customer user preferences will not be shown in the customer info table. Just info from the customer-table. Solutions: a) Create the customer user preferences - phone - and the phone number will be in the customer_perferences table. Add a trigger function to the database (if possible) which updates the customer-table. If you don't want to add a trigger function, you also could do this via a little script every night (via cron). b) Patch the Kernel/System/CustomerUser/DB.pm to read also the preferences stuff of one customer user. PS: If we can help...
********************************* Jake Covert Infrastructure Analyst Electronic Data Systems PSIC Support Group (586) 986-9698 Work (586) 518-3859 Pager http://www.eds.com *********************************
-Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
On Thu, Jul 24, Covert, Jake wrote:
P.S. On an offhand topic, I don't see any links on how to donate to the OTRS development team on your website. Have you thought about setting up a paypal site and linking to it?
We'll shortly start a business support. Buying that is quite a nice way to support the project and you get a benefit too. I will announce our support and consulting offer on the announce mailinglist very soon. So in case you are not subscribed yet, hurry up! ;-) take care Stefan -- Stefan Wintermeyer Oh, baby -- we got him now! There's no escape from the airport! (Homer) "The Simpsons"
Hi Jake, On Thu, Jul 24, 2003 at 09:24:32AM -0400, Covert, Jake wrote:
My db experience is quite limited, so without assistance, I don't think I'd be able to do option A (create user_pref. phone table and create an update data link).
If you guys would be willing to patch Kernel/System/CustomerUser/DB.pm, I think that this feature would be a great boon to the community at large.
Unfortunately this would be a hack (not a regular patch working for everyone). -=> The best solution would be a new OTRS module for the self administration of users (customer users). Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 8:49pm up 164 days, 6:16, 6 users, load average: 0.98, 0.41, 0.20
participants (3)
-
Covert, Jake -
Martin Edenhofer -
Stefan Wintermeyer