Re: [otrs] Export name and email adresses to a CSV file

2012-02-09 Thread Roy Kaldung
On Wed, 8 Feb 2012 15:46:03 +0100, Andy Wodfer wod...@gmail.com wrote: Hi, We're running OTRS 2.4.7 currently. I need to export all names and email adresses from tickets (from senders) in 2 different OTRS folders/mailboxes. The csv file needs to be in the following format: name, email

Re: [otrs] Export name and email adresses to a CSV file

2012-02-08 Thread Leonardo Certuche
Hello, You could get that info using an SQL query: the ticket table has a field called customer_user_id which has the login of the customer (or his email in case he is not a registered customer) and you can join it with the customer_user table where the first_name and last_name of all your