Skip to main content

Posts

Showing posts from July, 2018

If you use Multi-Factor Authentication, you need another Module to connect PowerShell

Last week, following best practice guidelines, we switched to Multi-Factor Authentication. While it was a little painful at first, it's working well now for our admin team. I'm not sure if or when we'll push this out to our users. It might be too difficult for them. (in fact, personally, I think that Google's token system might be far easier) In any case, as it turns out, we can't login to PowerShell now that MFA is running. A little searching provided the answer. We had to install an extension for PowerShell.  The process is already very well documented , so I won't go over here except to add one observation; You must install it via Edge (or possibly IE) -- it won't install via Chrome. 

Updating Contact Information in Office 365 from CSV via PowerShell

Some time ago, we did an export of our Domino contacts into the Office 365 address book. It was mostly successful and we got the users and their email addresses but missed a lot of detail on the phone numbers, company names and fax numbers.  At the time it didn't matter but recently we reached a point where we needed this information to be present.  The process was much fiddlier than it should have been, so here's how we did it. Exporting out of Domino This was easy, literally a five minute job for about 5000+ contacts. Domino has menu options to export as CSV, so I won't go into detail here. The end result is that you should have a CSV file that looks something like this; ExternalEmailAddress,FirstName,LastName,Name,Title,Company,Phone,MobilePhone,Fax,StreetAddress,City,StateorProvince,PostalCode,CountryOrRegion atano@clonewars.com,Ashoka,Tano,Ashoka Tano,,Cartoon Network,08 8988 9889,,,,,,, ynotfar@dagpbah.com,Yoda,Not Far,Yoda Not Far,Jedi Master,Food of th...