maybe you should never add anything to defaults.pm better use the appropriate config files for actions like this..... just 2ct, Li otrs-bounces@otrs.org schrieb am 09.03.2006 18:51:47:
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf
Of
Zaeem Arshad Sent: quinta-feira, 9 de Março de 2006 15:06 To: User questions and discussions about OTRS.org Subject: RE: [otrs] Adding new fields in ticket
hi,
On Thu, 2006-03-09 at 14:44 +0000, Duarte Cordeiro wrote:
You have 2 different options:
1) Use freekey[1..8]/freetext[1..8]
There are only 4 freekeys shown in a default install of OTRS 2.0 and they can only be added after a ticket is created. My requirement is to populate fields upon creation of the phone ticket.
Just edit the corresponding template page. For example, on 2.0.1, one of them is: kernel/ouotput/html/standard/AgentTicketPhone.dtl and uncomment the 5 to 8 pairs :)
2) Add this info to the customer table
I suggest the 2nd, but it always depends on the setup.
Exactly. This is what I want. Any pointers on how to do that? I need
to
make sure that the added fields are consistent with the whole OTRS design as well.
Someone may kick me, but I just edited Kernel/Config/Defaults.pm and...
$Self->{CustomerUser} = { Name => 'Database Backend', Module => 'Kernel::System::CustomerUser::DB', Params => { Table => 'customer_user', }, # customer uniq id CustomerKey => 'login', # customer # CustomerID => 'customer_id', CustomerValid => 'valid_id', CustomerUserListFields => ['first_name', 'last_name', 'email'], # CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'], CustomerUserSearchFields => ['login', 'last_name', 'customer_id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['salutation', 'first_name', 'last_name'], CustomerUserEmailUniqCheck => 0, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [ 'UserSalutation', 'Saudacao ', 'salutation', 1, 0, 'var', '', 0 ], [ 'UserFirstname', 'Nome Proprio', 'first_name', 0, 1, 'var', '', 0 ], [ 'UserLastname', 'Apelido', 'last_name', 0, 1, 'var', '', 0 ], [ 'UserMiddlenames', 'Nome ', 'middle_names', 1, 1, 'var', '', 0], [ 'UserMobile', 'Telefone', 'mobile', 1, 0, 'var', '',0 ], ['UserPhone2', 'Outro Contacto', 'phone', 1,0, 'var', '',0], [ 'UserFullOrganica', 'Organica', 'organica_text', 1, 0, 'var','',1 ], [ 'UserLocal', 'Local', 'local', 0, 1, 'int','',0 ], [ 'UserFullLocal', 'Local', 'local_text', 1, 0, 'var','',1 ], ['UserLocal2', 'Local 2', 'local2',1,0,'var','',0],
[ 'UserCargo', 'Cargo', 'cargo', 1, 0, 'var', '', 0], [ 'UserOrganica', 'Organica', 'organica', 0, 1, 'int','',0 ], [ 'UserEmail', 'Email', 'email', 1, 1, 'var', '$Env{"CGIHandle"}? Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"} &ArticleID=$Data{"ArticleID"}', 0 ], [ 'UserLogin', 'Login', 'login', 1, 1, 'var', 'http://helpdesk.cm-lisboa.net/otrs/index.pl? Action=AdminCustomerUser&Subaction=Change&ID=', 0 ], [ 'UserAD', 'LoginAD', 'login_ad', 1, 0, 'var','',0 ], [ 'NrMecanografico', 'Nr Mecanografico', 'mecanografico', 1, 0, 'var','',0 ],
[ 'UserPassword', 'Password', 'pw', 0, 1, 'var', '', 0 ], [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ], [ 'UserSapLogin', 'Saplogin', 'sap_login', 1, 0, 'var' ,'',0], [ 'UserComputerName', 'Computername', 'computer_name', 1, 0, 'var','',0 ], [ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ], # [ 'UserOrganicaOld', 'Organica', 'organica_old', 0, 0, 'var','',1 ], [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ], ], # default selections Selections => { UserSalutation => { ' ' => ' ', 'Sr.' => 'Sr.', 'Sra.' => 'Sra.', 'Dr.' => 'Dr.', 'Dra.' => 'Dra.', 'Eng.' => 'Eng.', 'Arq.' => 'Arq.', }, }, };
Then, just fire up mysql... mysql> desc customer_user; +---------------+--------------+------+-----+--------------------- +----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+--------------------- +----------------+ | id | int(11) | | PRI | NULL | auto_increment | | login | varchar(100) | | UNI | | | | email | varchar(150) | | | | | | customer_id | varchar(200) | | | | | | pw | varchar(50) | | | | | | salutation | varchar(50) | YES | | NULL | | | first_name | varchar(100) | | | | | | last_name | varchar(100) | | | | | | valid_id | smallint(6) | | | 0 | | | comments | varchar(250) | | | | | | create_time | datetime | | | 0000-00-00 00:00:00 | | | create_by | int(11) | | | 0 | | | change_time | datetime | | | 0000-00-00 00:00:00 | | | change_by | int(11) | | | 0 | | | middle_names | varchar(250) | YES | | NULL | | | phone | varchar(50) | YES | | NULL | | | mobile | varchar(50) | YES | | NULL | | | sap_login | varchar(50) | YES | | NULL | | | computer_name | varchar(150) | YES | | NULL | | | cargo | varchar(150) | YES | | NULL | | | organica_old | varchar(100) | YES | | NULL | | | local | int(11) | YES | | NULL | | | login_ad | varchar(100) | YES | | NULL | | | organica | int(11) | YES | | NULL | | | local_text | varchar(150) | YES | | NULL | | | organica_text | varchar(150) | YES | | NULL | | | local2 | varchar(100) | YES | | NULL | | | mecanografico | varchar(30) | YES | | NULL | | +---------------+--------------+------+-----+--------------------- +----------------+ 28 rows in set (0.00 sec)
Meaning... Add a new line to Defaults.pm, and a new table column to customer_user :)
Hope it Helps
Regards
-- ZA
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On
Behalf
Of
Zaeem Arshad Sent: quinta-feira, 9 de Março de 2006 13:45 To: otrs@otrs.org Subject: [otrs] Adding new fields in ticket
Hi,
Any pointers on how to add multiple fields in a new phone ticket like phone number, house address etc etc.
regards
-- ZA
_______________________________________________ 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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.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 Support oder Consulting fr Ihr OTRS System? => http://www.otrs.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 Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/