
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

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

On Wed, 8 Feb 2012 15:46:03 +0100, Andy Wodfer
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?
Hi, You have the possibility to gather this data by a SQL statement from the otrs database: SELECT DISTINCT(a_from) FROM article; hth, Roy -- Roy Kaldung e-mail: roy@kaldung.com
participants (3)
-
Andy Wodfer
-
Leonardo Certuche
-
Roy Kaldung