Thanks, Gerald. Appreciate the help! -- Jill Goldstein Customer Support Phone: 303-731-5634 http://spfsolutions.biz
From: Gerald Young <[email protected]<mailto:[email protected]>> Reply-To: "User questions and discussions about OTRS." <[email protected]<mailto:[email protected]>> Date: Thursday, December 19, 2013 at 1:36 PM To: "User questions and discussions about OTRS." <[email protected]<mailto:[email protected]>> Subject: Re: [otrs] Adding Fields You may: extend/alter the customer_user table and reference the new fields in CustomerUser Map (copy all of CustomerUser from Defaults.pm to Config.pm and modify). (this will be reasonably safe) something like: ALTER TABLE customer_user ADD my_lat VARCHAR(100) NULL; ALTER TABLE customer_user ADD my_lon VARCHAR(100) NULL; or likewise grab all fields from a third party customer backend. (the prefix my_ will help prevent otrs clobbering on updates and help you remember if this was a custom column or a stock otrs column). This code isn't tested, but if you don't like it, use phpmyadmin or a gui for your database to alter the table. Adding columns is *generally* non destructive, but of course, it will be a good idea to make backups of your database before making changes. On Thu, Dec 19, 2013 at 3:17 PM, Jill Goldstein <[email protected]<mailto:[email protected]>> wrote: Is it possible to add fields in the Customer Record? For example, in our line of work it's the latitude and Longitude of a location is important. Am I able to add a field that says "Lat/Lon?" As a work around, I can use the comment field to mark the Lat/Lon. Jill Goldstein Customer Support http://spfsolutions.biz<http://spfsolutions.biz/> Phone:303-731-5634<tel:303-731-5634> --------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
