
Hi, We're in the pre-roll out customization phase and I'm interested in any comments as to what we've done. We wanted to add a company field (and later may add more) to the customer log in create new account. We are also going to add a telephone field. Here's what we did: To add a "company" field to customer_user and capture to DB on new account: 1) Add field to otrs mysql table (ALTER TABLE statement, nulls allowed as data already in table) - also changed the corresponding XML file. 2) add form input create account for CustomerLogin.dtl 3) moved $Self->{CustomerUser}{...} block from defaults.pm to config.pm to customize. 4) in $Self->{CustomerUser}{...} block in config.pm added to map array the company field array (copied and adapted Email item), NOTE: to make this work, we needed to have the "required" element set as "0" not "1" (Item 5 in array). Possibly this is because there was pre-existing data or that the db column allows NULLS. Testing showed that the data entered the DB if 0 but not when 1. So we are capturing it. Here's where we want to go: Have the Company data show up in the right sidebar information in the Agents ticket view - we found the output file AgentTicketQueueTicketView.dtl, but are having some trouble finding where the data set used here populates. We went into the Ticket.pm file and found the SQL statement in the TicketGet, and added and tested a new item "CustomerCompany"that is returned in the dataset as $Row[40]. But this doesn't seem to be what populates the dataset used in the dtl file. We're total PERL tyro's, or at least I am (but have some experience with other languages), so any help here will be greatly appreciated, and allow us to understand how to make further customizations. Future customizations include adding to preferences the ability for a customer to edit email address, company and phone number (but not customer ID), and to display Telephone and Company on all agent's ticket view pages. Appreciatively, Keith