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 < jill.goldstein@spfsolutions.biz> 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
Phone: 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