On 2022-12-30 14:10, Odhiambo Washington wrote:
On Fri, Dec 30, 2022 at 1:57 PM Jan Eden via Mailman-users < mailman-users@mailman3.org> wrote:
Hi,
I would like to export users of my mailing lists including their full name (if present). The export button in Postorius creates a CSV with addresses only, and the tool bin/list_members mentioned in the [Mailman 2 FAQ] does not seem to be available in Mailman 3.
I have full access to the server/database, so scraping the web interface with [Mark's script] seems unneccessary. Is there an SQL statement (or an equivalent of bin/list_members) to extract the data?
Thanks, Jan
For MM3:
(venv) [mailman@gw ~/mm]$ mailman members listname@domain --output some_file.txt
Thank you! This should have been obvious to me, but I never actually used the mailman command so far. On minor issue: All user names with non-ASCII characters appear with quoted-printable encoding (e.g. =?utf-8?q?J=C3=BCrgen?=). Is there a way to output UTF-8 instead of QP?
- Jan