{"id":930,"date":"2012-10-26T14:59:33","date_gmt":"2012-10-26T14:59:33","guid":{"rendered":"http:\/\/www.c3000.net\/?p=930"},"modified":"2012-10-29T12:04:19","modified_gmt":"2012-10-29T12:04:19","slug":"export-der-c3000-benutzer-aus-der-sql-datenbank","status":"publish","type":"post","link":"https:\/\/c3000.net\/?p=930","title":{"rendered":"Export der C3000 Benutzer aus der SQL Datenbank"},"content":{"rendered":"<p>Bei lokaler Benutzerverwaltung in der Sybase SQL Datenbank kann sich die Aufgabe stellen, die Benutzer zu exportieren. Das l\u00e4sst sich recht bequem mit der Sybase Central erledigen:<\/p>\n<p>1. Sybase Central starten:<\/p>\n<p><a rel=\"attachment wp-att-931\" href=\"https:\/\/c3000.net\/?attachment_id=931\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-931\" title=\"Sybase Central starten\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Sybase-Central-starten.png\" alt=\"Sybase Central starten\" width=\"427\" height=\"372\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>2. Sybase DB Server verbinden<\/p>\n<p><a rel=\"attachment wp-att-932\" href=\"https:\/\/c3000.net\/?attachment_id=932\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-932\" title=\"Sybase Server verbinden\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Sybase-Server-verbinden.png\" alt=\"Sybase Server verbinden\" width=\"551\" height=\"235\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>3. User &#8222;sa&#8220; und dazugeh\u00f6riges Kennwort einf\u00fcgen<\/p>\n<p><a rel=\"attachment wp-att-933\" href=\"https:\/\/c3000.net\/?attachment_id=933\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-933\" title=\"Sybase sa Password\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Sybase-sa-Password.png\" alt=\"Sybase sa Password\" width=\"564\" height=\"407\" \/><\/a><\/p>\n<p>4. Datenbank &#8222;c3k&#8220; ausw\u00e4hlen und dort die Tabelle C3K_USER markieren. Im rechten Fensterbereich auf &#8222;Data&#8220; wechseln.<\/p>\n<p><a rel=\"attachment wp-att-954\" href=\"https:\/\/c3000.net\/?attachment_id=954\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-954\" title=\"User_Data\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/User_Data-580x409.png\" alt=\"User_Data\" width=\"580\" height=\"409\" srcset=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/User_Data-580x409.png 580w, https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/User_Data.png 894w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>5. Unter &#8222;Options&#8220; im rechten Bereich kann die maximal angezeigte Anzahl an Datens\u00e4tzen bestimmt werden &#8211; diese sollte mit der Anzahl der eingetragenen Benutzer harmonieren. Wenn alle Datens\u00e4tze angezeigt werden, mit &#8222;Select all&#8220; und &#8222;Copy&#8220; alle Datens\u00e4tze in die Zwischenablage kopieren und danach in ein neues Textdokument einf\u00fcgen.<\/p>\n<p><a rel=\"attachment wp-att-955\" href=\"https:\/\/c3000.net\/?attachment_id=955\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-955\" title=\"select_all_copy\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/select_all_copy-580x413.png\" alt=\"select_all_copy\" width=\"580\" height=\"413\" srcset=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/select_all_copy-580x413.png 580w, https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/select_all_copy.png 891w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>Damit haben wir eine Exportdatei, die in der ersten Zeile die entsprechenden Spaltennamen und die wichtigsten Userdaten enth\u00e4lt.<\/p>\n<p>Diese wiederum kann man z.B. in Excel importieren, um die Daten weiterzubearbeiten. Die Felder sind in der Regel durch ein Komma getrennt.<\/p>\n<p><a rel=\"attachment wp-att-942\" href=\"https:\/\/c3000.net\/?attachment_id=942\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-942\" title=\"Excel Import Schritt 1\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-1-580x386.png\" alt=\"Excel Import Schritt 1\" width=\"580\" height=\"386\" srcset=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-1-580x386.png 580w, https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-1.png 604w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p><a rel=\"attachment wp-att-943\" href=\"https:\/\/c3000.net\/?attachment_id=943\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-943\" title=\"Excel Import Schritt 2\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-2-580x388.png\" alt=\"Excel Import Schritt 2\" width=\"580\" height=\"388\" srcset=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-2-580x388.png 580w, https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-2.png 605w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>und dann am besten alle Felder als Textfelder definieren.<\/p>\n<p><a rel=\"attachment wp-att-944\" href=\"https:\/\/c3000.net\/?attachment_id=944\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-944\" title=\"Excel Import Schritt 3\" src=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-3-580x384.png\" alt=\"Excel Import Schritt 3\" width=\"580\" height=\"384\" srcset=\"https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-3-580x384.png 580w, https:\/\/c3000.net\/wp-content\/uploads\/2012\/10\/Excel-3.png 606w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bei lokaler Benutzerverwaltung in der Sybase SQL Datenbank kann sich die Aufgabe stellen, die Benutzer zu exportieren. Das l\u00e4sst sich recht bequem mit der Sybase Central erledigen: 1. Sybase Central starten: &nbsp; 2. Sybase DB Server verbinden &nbsp; 3. User &#8222;sa&#8220; und dazugeh\u00f6riges Kennwort einf\u00fcgen 4. Datenbank &#8222;c3k&#8220; ausw\u00e4hlen und dort die Tabelle C3K_USER markieren. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,57],"tags":[86,119,121],"class_list":["post-930","post","type-post","status-publish","format-standard","hentry","category-faq-tipps-tricks","category-sybasedatenbank","tag-benutzerverwaltung","tag-export","tag-user"],"_links":{"self":[{"href":"https:\/\/c3000.net\/index.php?rest_route=\/wp\/v2\/posts\/930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/c3000.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c3000.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c3000.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/c3000.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=930"}],"version-history":[{"count":15,"href":"https:\/\/c3000.net\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions"}],"predecessor-version":[{"id":953,"href":"https:\/\/c3000.net\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions\/953"}],"wp:attachment":[{"href":"https:\/\/c3000.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c3000.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c3000.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}