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

2012-02-09 Thread 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 ther

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

2012-02-08 Thread 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 custome

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

2012-02-08 Thread 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