{"id":211,"date":"2008-10-22T16:46:50","date_gmt":"2008-10-22T16:46:50","guid":{"rendered":"https:\/\/www.wapshere.com\/missmiis\/?page_id=211"},"modified":"2008-10-22T16:46:50","modified_gmt":"2008-10-22T16:46:50","slug":"add_contactsps1","status":"publish","type":"page","link":"https:\/\/www.wapshere.com\/missmiis\/add_contactsps1","title":{"rendered":"add_contacts.ps1"},"content":{"rendered":"<pre>#\r\n# add_contacts.ps1\r\n# \r\n# Written by Carol Wapshere, October 2008\r\n#\r\n# Use to create one or more contacts.\r\n# If the contact exists already the create command will throw an error, but the attributes will still be updated.\r\n#\r\n# Instructions:\r\n#\r\n#\u00c2\u00a0\u00c2\u00a0 1. Modify the add_contacts.csv file to include information about the contacts to add.\r\n#\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 The file must have a header row and must include the following fields:\r\n#\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 displayName,sn,givenName,name,mail,telephoneNumber,facsimileTelephoneNumber,mobile,homePhone,streetAddress,company\r\n#\r\n#\u00c2\u00a0\u00c2\u00a0 2. Open the Exchange Management Shell\r\n#\r\n#\u00c2\u00a0\u00c2\u00a0 3. CD to C:\\scripts and run add_contacts.ps1.<\/pre>\n<pre>\r\ncat add_contacts.csv &gt; unicode.csv # make utf8<\/pre>\n<pre>import-csv unicode.csv | foreach {<\/pre>\n<pre>write-host\r\nwrite-host\r\nwrite-host \"Creating contact for \" $_.displayName<\/pre>\n<pre>New-MailContact -ExternalEmailAddress $_.mail -DisplayName $_.displayName -Name $_.name -OrganizationalUnit 'bbhfgg.local\/BBH\/Contacts' -FirstName $_.givenName -LastName $_.sn<\/pre>\n<pre>$ldapstring = \"LDAP:\/\/CN=\" + $_.name + \",OU=Contacts,OU=BBH,dc=bbhfgg,dc=local\"\r\nwrite-host $ldapstring\r\n$contact = [ADSI]$ldapstring<\/pre>\n<pre>write-host\r\nwrite-host \"Setting AD attributes...\"<\/pre>\n<pre>if ($_.displayName -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 displayName: \" $_.displayName\r\n\u00c2\u00a0 $contact.Put(\"displayName\", $_.displayName)\r\n}<\/pre>\n<pre>if ($_.sn -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 sn: \" $_.sn\r\n\u00c2\u00a0 $contact.Put(\"sn\", $_.sn)\r\n}<\/pre>\n<pre>if ($_.givenName -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 givenName: \" $_.givenName\r\n\u00c2\u00a0 $contact.Put(\"givenName\", $_.givenName)\r\n}<\/pre>\n<pre>if ($_.company -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 company: \" $_.company\r\n\u00c2\u00a0 $contact.Put(\"company\", $_.company)\r\n}<\/pre>\n<pre>if ($_.telephoneNumber -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 telephoneNumber: \" $_.telephoneNumber\r\n\u00c2\u00a0 $contact.Put(\"telephoneNumber\", $_.telephoneNumber)\r\n}<\/pre>\n<pre>if ($_.facsimileTelephoneNumber -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 facsimileTelephoneNumber: \" $_.facsimileTelephoneNumber\r\n\u00c2\u00a0 $contact.Put(\"facsimileTelephoneNumber\", $_.facsimileTelephoneNumber)\r\n}<\/pre>\n<pre>if ($_.mobile -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 mobile: \" $_.mobile\r\n\u00c2\u00a0 $contact.Put(\"mobile\", $_.mobile)\r\n}<\/pre>\n<pre>if ($_.homePhone -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 homePhone: \" $_.homePhone\r\n\u00c2\u00a0 $contact.Put(\"homePhone\", $_.homePhone)\r\n}<\/pre>\n<pre>if ($_.streetAddress -ne \"\")\r\n{\r\n\u00c2\u00a0 write-host \"\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 streetAddress: \" $_.streetAddress\r\n\u00c2\u00a0 $contact.Put(\"streetAddress\", $_.streetAddress)\r\n}<\/pre>\n<pre>$contact.SetInfo()<\/pre>\n<pre>\r\n} | out-file -filepath \"c:\\scripts\\add_contacts.log\" -encoding \"UNICODE\"<\/pre>\n","protected":false},"excerpt":{"rendered":"<p># # add_contacts.ps1 # # Written by Carol Wapshere, October 2008 # # Use to create one or more contacts. # If the contact exists already the create command will throw an error, but the attributes will still be updated. # # Instructions: # #\u00c2\u00a0\u00c2\u00a0 1. Modify the add_contacts.csv file to include information about the&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-211","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/Pkp1o-3p","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/211","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":1,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/211\/revisions"}],"predecessor-version":[{"id":212,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/pages\/211\/revisions\/212"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}