DreamCom

Z Wiki UnArt Slavičín
Skočit na navigaciSkočit na vyhledávání

Import telefonních čísel z Freenetisu:

SQL dotaz pro výpis dat z Freenetisu ve formátu, který chce DreamCom:

SET NAMES "CP1250";
SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení",
"" as "Přezdívka", concat(name, " ", surname) as "Jméno", phone as "Tel. číslo",
"" as "Seznam čísel", email as "Email", "" as "Seznam emailů", "" as "Sms-email",
"" as "Typ zprávy", "" as "Skript",
"True" as "Potvrzení", "True" as "Identifikace", "False" as "Flash",
"" as "Oslovení", "" as "Podpis", "" as "Svátek", "" as "Narozeniny",
"" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`;


Pozn.: nastavení CP1250 je nutné, díky za tip článku o češtině a MySQL