{"id":1909,"date":"2012-08-27T15:27:43","date_gmt":"2012-08-27T13:27:43","guid":{"rendered":"http:\/\/www.ewig-drohendes-versagen.de\/?p=1909"},"modified":"2012-08-27T15:35:59","modified_gmt":"2012-08-27T13:35:59","slug":"powershell-active-directory-csv-user-importad-csv-benutzer-import","status":"publish","type":"post","link":"https:\/\/www.ewig-drohendes-versagen.de\/?p=1909","title":{"rendered":"Powershell Active Directory csv User Import<br>AD CSV Benutzer Import"},"content":{"rendered":"\n<!-- google_ad_section_start -->\n<p>Da ich grad ein wenig die Migration unserer 8 Dom\u00e4nen vorbereite &#8211; hier mal ein Powershell Script und Benutzer aus einer csv (mit Komma getrennt) ins AD zu importieren.<\/p>\n<p>Download: <a href=\"http:\/\/www.ewig-drohendes-versagen.de\/wp-content\/geheim_uploads\/2012\/08\/ad_user_import_from_csv.ps1_.txt\">ad_user_import_from_csv.ps1.txt<\/a><\/p>\n<p>Die Datei in .ps1 umbenennen.<\/p>\n<p>Damit das Script l\u00e4uft muss noch die Execution Policy so ge\u00e4ndert werden das auch &#8222;remotesigned&#8220; Scripte ausgef\u00fchrt werden d\u00fcrfen.<\/p>\n<p><code>set-executionpolicy remotesigned<\/code><\/p>\n<p>Bei <a title=\"howtogeek.com\" href=\"http:\/\/www.howtogeek.com\/50187\/how-to-create-multiple-users-in-server-2008-with-powershell\/\" target=\"_blank\">howtogeek.com<\/a> gibs den original Artikel nach dem ich das Script umgebaut habe.<\/p>\n<p>Zum editieren hab ich <a href=\"http:\/\/notepad-plus-plus.org\/\" target=\"_blank\">Notepad++<\/a> benutzt und den Quelltext mal eben von 20 auf 120 Zeilen ausgedehnt \ud83d\ude42<\/p>\n<p>An dieser Stelle &#8211; Danke an das <a href=\"http:\/\/www.ewig-drohendes-versagen.de\/?p=1853\" target=\"_blank\">OOP Modul<\/a> im Studium &#8211; das hat an dieser Stelle wirklich was gebracht &#8230;<\/p>\n<p>Das csv sollte so aussehen:<\/p>\n<pre><code>GivenName,sn,OU,Title,Description,Department,telephoneNumber\r\nAnna,Bolika,KZH,Innere Medizin,OP Leiter,Magdeburg,0815\/4711<\/code><\/pre>\n<p>Ich hab mich bem\u00fcht alles zu kommentieren \ud83d\ude42<\/p>\n<p>An dieser Stell m\u00f6chte ich nochmal darauf hinweisen:<\/p>\n<h3>ICH BIN KEIN PROGRAMMIERER!!!!<\/h3>\n<p><!--more--><br \/>\nWer Verbesserungsvorschl\u00e4ge hat -> bitte die Kommentarfunktion verwenden.<\/p>\n<p>Weiterer Lesestoff zu dem Thema:<\/p>\n<p>Technet &#8211; <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ff406264.aspx\" target=\"_blank\">Display Output in Color Using Windows PowerShell<\/a><br \/>\nTechnet &#8211; <a href=\"http:\/\/technet.microsoft.com\/de-de\/library\/dd315350.aspx\" target=\"_blank\">about_Try_Catch_Finally<\/a><br \/>\nTechnet &#8211; <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ee692804.aspx\" target=\"_blank\">The String\u2019s the Thing<\/a><br \/>\nTechnet &#8211; <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ee692797.aspx\" target=\"_blank\">Even More Things You Can Do With Arrays<\/a><br \/>\nTechnet &#8211; <a href=\"http:\/\/gallery.technet.microsoft.com\/scriptcenter\/PowerShell-Create-Active-7e6a3978\">Create Active Directory Users Based On Excel Input<\/a><\/p>\n<p>colorconsole.de &#8211; <a href=\"http:\/\/www.colorconsole.de\/PS_Windows\/de\/about_Special_Characters.htm\" target=\"_blank\">PowerShell Special Characters <\/a><br \/>\npowershellpro.com &#8211; <a href=\"http:\/\/www.powershellpro.com\/powershell-tutorial-introduction\/variables-arrays-hashes\/\" target=\"_blank\">Power Shell Variables and Arrays<\/a><br \/>\nvexasoft.com &#8211; <a href=\"http:\/\/vexasoft.com\/cmdletlibrary\/blog\/2011\/powershell-tutorial-%E2%80%93-try-catch-finally-and-error-handling-in-powershell\/\" target=\"_blank\">Powershell error handling<\/a><\/p>\n\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<p>Da ich grad ein wenig die Migration unserer 8 Dom\u00e4nen vorbereite &#8211; hier mal ein Powershell Script und Benutzer aus einer csv (mit Komma getrennt) ins AD zu importieren. Download: ad_user_import_from_csv.ps1.txt Die Datei in .ps1 umbenennen. Damit das Script l\u00e4uft muss noch die Execution Policy so ge\u00e4ndert werden das auch &#8222;remotesigned&#8220; Scripte ausgef\u00fchrt werden d\u00fcrfen. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[1,16],"tags":[40,60,19,26,71],"class_list":["post-1909","post","type-post","status-publish","format-standard","hentry","category-allgemein","category-edv-probleme","tag-active-directory","tag-powershell","tag-server-2008","tag-windows","tag-work"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/peux2-uN","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts\/1909","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1909"}],"version-history":[{"count":0,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=\/wp\/v2\/posts\/1909\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ewig-drohendes-versagen.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}