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]> 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 > > 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 >
--------------------------------------------------------------------- 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
