Hi
A simple question...
How to I export all my customers to excel? I just need the email.
Its not possible just to select all because only 283 customers is shown
Kind regards
Per
How to ecport "customer user" email
Moderator: crythias
-
- Znuny superhero
- Posts: 889
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: How to ecport "customer user" email
Hello,
open the SQL Box in the Admin frontend and enter
SELECT `email` FROM `customer_user`
Leave the limit box empty and select your wished format.
open the SQL Box in the Admin frontend and enter
SELECT `email` FROM `customer_user`
Leave the limit box empty and select your wished format.
Last edited by zzz on 14 Jun 2017, 15:06, edited 1 time in total.
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny newbie
- Posts: 24
- Joined: 04 Feb 2015, 14:46
- Znuny Version: 3.3.9
- Real Name: Per Olsen
- Company: Capana
Re: How to ecport "customer user" email
Super!
Is it also possible to get the CUSTOMERID in the list?
Kind regards
Per
Is it also possible to get the CUSTOMERID in the list?
Kind regards
Per
-
- Znuny superhero
- Posts: 889
- Joined: 15 Dec 2016, 15:13
- Znuny Version: All
- Real Name: Emin
- Company: Efflux GmbH
- Contact:
Re: How to ecport "customer user" email
Of course! It's simple SQL.
SELECT `customer_id`, `email` FROM `customer_user`
SELECT `customer_id`, `email` FROM `customer_user`
Professional OTRS, Znuny & OTOBO services: efflux.de | efflux.de/en/
Free and premium add-ons: German | English
Free and premium add-ons: German | English
-
- Znuny newbie
- Posts: 24
- Joined: 04 Feb 2015, 14:46
- Znuny Version: 3.3.9
- Real Name: Per Olsen
- Company: Capana
Re: How to ecport "customer user" email
NICE! Just what i needed
Thanks!
Thanks!