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 customers is. Since probably you have several tickets from the same customer, you'd want to use a select distinct  statement to extract your data. Web clients like phpmyadmin will let you run the query and export its output to csv.

Regards,

Leonardo Certuche
www.itconsultores.com.co
Medellín, Colombia


On 8 February 2012 09:46, Andy Wodfer <wodfer@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

Are there any plugins for OTRS that can do this or can someone give me some input on how to do this the best way?

Thanks!
Andy



---------------------------------------------------------------------
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