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