|Latest 7 Posts
| Thoughts on the Microsoft Surface Book 4|
Mon, Jun 19th 2017 76
| How to Split SharePoint Document Libraries to Simplify Synching|
Sun, Apr 30th 2017 13
| Using SharePoint with OneDrive as a File Server (for Ex-Domino Admins and Traditionalists)|
Mon, Apr 24th 2017 15
| Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 2|
Tue, Apr 4th 2017 14
| Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 1|
Fri, Mar 31st 2017 14
| How to Set up Rooms Properly in Office 365 - Part 2 (Extending Booking Time)|
Tue, Mar 21st 2017 7
| How to use PowerShell to Change the Email Address of Office 365 Groups|
Fri, Mar 10th 2017 8
| Thoughts on the Microsoft Surface Book 4|
Mon, Jun 19th 2017 76
| How to Use Microsoft Outlook with Your IBM Verse (in the cloud) Mail|
Sun, Oct 9th 2016 46
| How to Create an Auto-Response Mail Message in Lotus Notes 8.5.3+|
Wed, Feb 22nd 2012 37
| Fixing Word 2016 Crashes when Opening Older Documents with Macros on Windows 7|
Tue, Nov 15th 2016 23
| Restarting Agent Manager on Domino 9.0.1 may crash your server....|
Wed, Feb 18th 2015 22
| How to do Bullets and Numbering in IBM Notes|
Tue, Feb 4th 2014 20
| How to set IBM Verse as your Default Email Client|
Thu, Jun 9th 2016 20
| How to Create a Good Email Signature and Use it in IBM Verse|
Mon, Apr 18th 2016 19
| Getting your Head around the IBM Connections ID|
Tue, Feb 23rd 2016 17
| Chrome Remote Desktop - A Better VPN and RDP Solution|
Mon, Mar 21st 2016 17
||Getting Contacts (Not Users) out of Your Notes/Domino NAB and into Office 365 Contacts
Recently we've been undertaking a task to move from IBM Domino to Office 365 with particular emphasis on the mail system. One of the first big tasks is to move all of our corporate contacts from the Domino NAB over to the Contacts area of office 365.
Corporate ContactsCorporate contacts, in this sense are contacts which are shared by the entire organisation. I'm not talking about actual users who will have an Office 365 licence with your company or about personal contacts, who would normally reside in the personal address book.
In our case, we had about 6500 corporate contacts who needed to be migrated.
There's a contacts screen in Office 365 which is accessible from the Admin portal. It's under users, then contacts.
Exporting from DominoIn IBM Notes, open your company's address book and press Ctrl+A on people. If you have your staff and non-staff in the same address book, you'll probably want to sort by company and deselect all the staff.
Next, click File, Export Contacts. You'll want to choose either "All contacts in this view" or "only the contacts you selected" depending upon your circumstances.
I'd recommend exporting all fields. It's a little messier but it means that you get your contacts address information (if you have it in Domino already).
Choose a place to save the file and make sure that you've used CSV.
Excel Stuff in the MiddleOpen the file in EXCEL,
Create a new file in excel with these fields as specified in this document.
Search and Replace commas. Commas (and rabbit ears "" aka inverted commas) can really upset CSV imports. I just replaced all ours with nothing.
You may have to create the Name column out of formula ... ie: Assuming that first name is in cell C2 and last name is in cell D2, you'd use =CONCATENATE(C2, " ", D2). Then Autofill the column and then copy and paste it into another blank column (so you could paste (special) as values.
Importing to Office 365The import to Office 365 is an entirely command line driven via PowerShell and these instructions helped enormously. Make sure that you connect to your exchange online service first. There's a link in step 1 but in case you can't find it, it's here.
I wish I could say that I completely understood the process I ran but I didn't.
It worked though, so I'm happy about that.
Now I just have to figure out groups.
Jan 22, 2017
| Recent Blog Posts
Thoughts on the Microsoft Surface Book 4|
Mon, Jun 19th 2017 9:40p Gavin Bollard
I've spent the last couple of months on Microsoft's Surface Book 4 (i7) and I've had enough time to form an opinion. I generally hate laptops but I've found the Surface Book to be fast enough and easy enough to do the majority of my work on. The touchscreen is very responsive and I love being able to detach the tablet from the base - though admittedly, I rarely have a good business reason to do it. We ordered around 45 of the devices all at once. One was DOA and another had batteries in th
How to Split SharePoint Document Libraries to Simplify Synching|
Sun, Apr 30th 2017 10:54p Gavin Bollard
In my last post, I talked about how you need to split your SharePoint document libraries into smaller chunks in order to synch them. In this post, I'm going to assume that you made the same mistake that I made and put too many documents into the one document library. In my case, I have an IT Team SharePoint site which holds all of our IT documents. It makes sense to keep all our IT documents together. For the most part, the site doesn't need to be synched anywhere because it's mostly a stora
Using SharePoint with OneDrive as a File Server (for Ex-Domino Admins and Traditionalists)|
Mon, Apr 24th 2017 6:33a Gavin Bollard
Over the past few months, I've been looking at a whole range of options to do with file storage on the basis that Microsoft's OneDrive simply doesn't do what we need. The whole time of course, I've been unable to shake the feeling that Microsoft should be offering something that already covers this space. After all, file sharing is one of the major "tentpoles" in most Windows networks. As it turns out, SharePoint is the answer to this - and it works well if it's playing nicely with OneD
Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 2|
Tue, Apr 4th 2017 6:14a Gavin Bollard
Last time on Real World Computing, I talked about migrating mail from IBM Notes and Verse to Microsoft Office 365. Now it's time for Part 2. Mail RoutingWe did routing in two parts. Initially we had MX records for both IBM and Microsoft with Microsoft having the higher number (which means lower priority). After the cutover date we switched the priorities so that Microsoft Office 365 had the higher priority. One of the cool things about Microsoft’s setup is that they give you two domains, o
Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 1|
Fri, Mar 31st 2017 11:05p Gavin Bollard
It was always just a matter of time. Eventually we were going to have to make the jump from IBM to Microsoft. It's not that IBMs software isn't good. It's very good. It's simply that IBM is the Beta to Microsoft's VHS. Technically the IBM product line is far superior but on the surface, IBMs poor UI will never match the incredible pull of Microsoft's polished Office 365 offerings. We're just finishing a mail migration from IBM Notes/Verse to Microsoft Outlook, which we did entirely in-ho
How to Set up Rooms Properly in Office 365 - Part 2 (Extending Booking Time)|
Tue, Mar 21st 2017 4:01p Gavin Bollard
Following on from Part 1 where I talked about how to get rooms to show up in the room list, here's the next step where we extend the booking time from the default of 180 days. Why is there a limit?In most circumstances, a limit makes perfect sense. It stops employees from booking meeting rooms for years in advance and then leaving the company. In our case, it's actually fairly common to book the meeting schedule up to about 18 months into the future - so the 180 day (6 month) limit is quite r
How to use PowerShell to Change the Email Address of Office 365 Groups|
Fri, Mar 10th 2017 9:34p Gavin Bollard
One of the odd things about Office 365 is how much you have to resort to PowerShell to get things done. That's currently the case with the Office365 Groups, a recently introduced type of group that works particularly well across all of the Office365 applications. I've been setting a few things up with Office365 groups lately and I've had two instances where I needed to do some renames. Once was when the people who asked for the group changed their mind about the name and the other was when
How to Set up Rooms Properly in Office 365|
Tue, Feb 21st 2017 7:53a Gavin Bollard
You'd think that setting rooms up in Office 365 would be a simple matter of going to the Office 365 Admin console, expanding Resources, clicking on Rooms and Equipment and then using the Add Button This works but it doesn't do everything. If you want your rooms to appear in the Room List (and to show available times), you'll have to use PowerShell to put them there. Finding AnswersSo... I spent a while trying to find the answers without a whole lot of luck. I think that coming from the No
Solving Some Azure Active Directory User Synchronisation Issues on Office 365 |
Sat, Feb 18th 2017 10:46p Gavin Bollard
We started moving over to Office 365 quite a while before we decided to ditch Notes mail and move to Outlook. It was also my plan to get rid of our internal active directory server and rely solely on the cloud for authentication. As it turned out, management wanted to keep the AD server a little longer, so we've had to synchronise our onsite accounts with the Office 365 ones. The synchronisation processes immediately created duplicates (and sometimes triplicates) of users. The journey to re
OneDrive to Rule them all ... or perhaps not.|
Mon, Feb 6th 2017 12:02p Gavin Bollard
Microsoft OneDrive is great! It's easy to use too and has some really great integration into Office 2016 - which means that when you go to save or open files, instead of displaying a file dialog, it renders the folder names right into the panel. Sadly the sharepoint integration in Office 2016 is still dialog-based. On the surface, it looks like a great files storage solution but as it turns out, just like Tolkien's OneRing, beneath that shiny surface, OneDrive is mostly evil. At work, we'