> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/
