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/