DreamCom - Historie editací

Dulik v 15. 9. 2008, 00:17

2008-09-15T00:17:26Z

← Starší verze		Verze z 15. 9. 2008, 00:17
Řádek 4:		Řádek 4:

	SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení",		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 "Přezdívka", concat(name, " ", surname) as "Jméno",
			concat("+420", phone) as "Tel. číslo",
	"" as "Seznam čísel", email as "Email", "" as "Seznam emailů", "" as "Sms-email",		"" as "Seznam čísel", email as "Email", "" as "Seznam emailů", "" as "Sms-email",
	"" as "Typ zprávy", "" as "Skript",		"" as "Typ zprávy", "" as "Skript",

Dulik v 14. 9. 2008, 23:37

2008-09-14T23:37:15Z

← Starší verze		Verze z 14. 9. 2008, 23:37
Řádek 1:		Řádek 1:
	Import telefonních čísel z Freenetisu:		Import telefonních čísel z Freenetisu:

	SQL dotaz pro výpis dat z Freenetisu ve formátu, který chce DreamCom:		SQL dotaz pro výpis dat z Freenetisu ve formátu, který chce DreamCom, zadáme v phpmyadmin-u nebo MySQL Administrátoru:

	~~SET NAMES "CP1250";~~
	SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení",		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 "Přezdívka", concat(name, " ", surname) as "Jméno", phone as "Tel. číslo",
Řádek 12:		Řádek 11:
	"" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`;		"" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`;

			Jak phpMyAdmin, tak MySQL Administrátor, umí vypsaná data exportovat do formátu CSV, takže si je vyexportujeme.

	~~Pozn~~.~~: nastavení~~ CP1250 ~~je nutné, díky za tip~~ [http://molhanec.net/mysql_cestina_minifaq.html#korekce článku o češtině a MySQL]		Bohužel, toto CSV bude v kódování UTF-8. Nastavení na CP1250 pomocí SET NAMES jako v [http://molhanec.net/mysql_cestina_minifaq.html#korekce článku o češtině a MySQL] tyto SW ignorují.

			Takže CSV soubor otevřeme v OpenOffice (při importu je nutné zvolit UTF-8 a nastavit oddělovač na středník) a v OpenOffice dáme "Uložit jako" a zaškrtneme "Upravit nastavení filtru", což nám umožní uložit CSV v UTF-8 jako CSV ve Windows 1250.

Dulik v 14. 9. 2008, 22:44

2008-09-14T22:44:55Z

← Starší verze		Verze z 14. 9. 2008, 22:44
Řádek 1:		Řádek 1:
	Import telefonních čísel z Freenetisu:		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í",		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 "Přezdívka", concat(name, " ", surname) as "Jméno", phone as "Tel. číslo",
Řádek 9:		Řádek 10:
	"True" as "Potvrzení", "True" as "Identifikace", "False" as "Flash",		"True" as "Potvrzení", "True" as "Identifikace", "False" as "Flash",
	"" as "Oslovení", "" as "Podpis", "" as "Svátek", "" as "Narozeniny",		"" as "Oslovení", "" as "Podpis", "" as "Svátek", "" as "Narozeniny",
	"" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`		"" as "Operator", "" as "OperatorCalc", "" as "Note" FROM `freenetis`.`users`;


			Pozn.: nastavení CP1250 je nutné, díky za tip [http://molhanec.net/mysql_cestina_minifaq.html#korekce článku o češtině a MySQL]

Dulik v 14. 9. 2008, 22:28

2008-09-14T22:28:47Z

← Starší verze		Verze z 14. 9. 2008, 22:28
Řádek 4:		Řádek 4:

	SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení",		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 "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 "Seznam čísel", email as "Email", "" as "Seznam emailů", "" as "Sms-email",
	"" as "Typ zprávy", "" as "Skript",		"" as "Typ zprávy", "" as "Skript",

Dulik: Nová stránka: Import telefonních čísel z Freenetisu: SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení", "" as "Přezdívka", concat(name, surname) ...

2008-09-14T22:27:38Z

Nová stránka: Import telefonních čísel z Freenetisu: SELECT "" as "ID", "" as "ID skupin", name as "Křestní jméno", surname as "Příjmení", "" as "Přezdívka", concat(name, surname) ...

Nová stránka

Import telefonních čísel z Freenetisu:

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`