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

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