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

[Roy Kaldung]

On Wed, 8 Feb 2012 15:46:03 +0100, 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?

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: r...@kaldung.com
-
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

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

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

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

[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