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