Tutorials

Eine immer größer werdende Tutorialdatenbank.

PHP-Fusion Core

Aktuelle PHP-Fusion Vollversionen und Updates

Addon Downloads

Alle Downloads garantiert Kostenlos

Support 24/7

24 Stunden, 7 Tage die Woche, das ganze Jahr.

Thema ansehen
Export Email List Thema drucken
Benutzeravatar

Neuling


afoster Geschrieben am 20.06.2018 um 05:51
 #1 Beitrag drucken Top
Is it possible to export the member's emails in a text list and if so, how is it done? thanks.
Beiträge:
Benutzeravatar

Seiten Administrator


Layzee Geschrieben am 20.06.2018 um 09:11
 #2 Beitrag drucken Top
Sure, it's possible by csv-export for example.

I have attached a file which needs to be changed for your usage.
This file was written to export all needed userdatas as CSV.

Enter YOUR DB-Datas:
Download Code  Code
define("select_table", "fusionj7i6e_users"); // Enter YOUR prefix and needed DB-table
define("csv_delimeter", ";");
define("db_user", "db_username"); // Enter YOUR DB Username
define("db_password", "db_password"); // Enter YOUR DB Password
define("db_server", "localhost");
define("db_db_name", "db_name"); // Enter the name of YOUR database


Change this line to your needs:
Download Code  Code
$sql = "SELECT user_fax, user_identnr, user_firma, user_vorname, user_nachname, user_strasse, user_plz, user_location "
        ."FROM " . select_table . " ORDER by user_fax ASC "
        ."LIMIT 65534 ";


That's all.
As a result you schould get a CSV-file which can be opened with MS Excel or OpenOffice Calc.
Layzee hat folgende Datei angehängt:  csv_export.zip [968Bytes / 43 mal Heruntergeladen]
Beiträge: 282 
http://der-nachtfalke.net 
Benutzeravatar

Neuling


afoster Geschrieben am 20.06.2018 um 16:15
 #3 Beitrag drucken Top
Thank you very much, I appreciate your help.
Beiträge:
Springe ins Forum:
Anzeige


© 2016 Real Space. All rights reserved | Design by W3layouts
Powered by PHP-Fusion copyright © 2002 - 2018 by Nick Jones. Released as free software without warranties under GNU Affero GPL v3.