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