193 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 2
Tue, Apr 4th 2017 11
Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 1
Fri, Mar 31st 2017 12
How to Set up Rooms Properly in Office 365 - Part 2 (Extending Booking Time)
Tue, Mar 21st 2017 8
How to use PowerShell to Change the Email Address of Office 365 Groups
Fri, Mar 10th 2017 12
How to Set up Rooms Properly in Office 365
Tue, Feb 21st 2017 10
Solving Some Azure Active Directory User Synchronisation Issues on Office 365
Sat, Feb 18th 2017 9
OneDrive to Rule them all ... or perhaps not.
Mon, Feb 6th 2017 11
Top 10
How to Create an Auto-Response Mail Message in Lotus Notes 8.5.3+
Wed, Feb 22nd 2012 43
How to Use Microsoft Outlook with Your IBM Verse (in the cloud) Mail
Sun, Oct 9th 2016 23
Getting your Head around the IBM Connections ID
Tue, Feb 23rd 2016 19
Restarting Agent Manager on Domino 9.0.1 may crash your server....
Wed, Feb 18th 2015 16
How to do Bullets and Numbering in IBM Notes
Tue, Feb 4th 2014 13
How to Create a Good Email Signature and Use it in IBM Verse
Mon, Apr 18th 2016 12
How to Embed Video into your IBM Connections Wiki
Wed, May 11th 2016 12
Getting Contacts (Not Users) out of Your Notes/Domino NAB and into Office 365 Contacts
Sun, Jan 22nd 2017 12
How to use PowerShell to Change the Email Address of Office 365 Groups
Fri, Mar 10th 2017 12
Migrating Mail from IBM Notes and Verse to Microsoft Outlook on Office 365 - Part 1
Fri, Mar 31st 2017 12


Getting Contacts (Not Users) out of Your Notes/Domino NAB and into Office 365 Contacts
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

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 Contacts

Corporate 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 Domino

In 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 Middle

Open the file in EXCEL,
Create a new file in excel with these fields as specified in this document.

  • ExternalEmailAddress

  • Name

  • FirstName

  • LastName

  • StreetAddress

  • City

  • StateorProvince

  • PostalCode

  • Phone

  • MobilePhone

  • Pager

  • HomePhone

  • Company

  • Title

  • OtherTelephone

  • Department

  • CountryOrRegion

  • Fax

  • Initials

  • Notes

  • Office

  • Manager


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 365

The 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.

---------------------
http://dominogavin.blogspot.com/2017/01/getting-contacts-not-users-out-of-your.html
Jan 22, 2017
13 hits



Recent Blog Posts
11
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
12
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
8
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
12
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
10
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
9
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
11
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'
13
Getting Contacts (Not Users) out of Your Notes/Domino NAB and into Office 365 Contacts
Sun, Jan 22nd 2017 7:19a   Gavin Bollard
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
4
New Year, New Directions
Sun, Jan 8th 2017 10:11p   Gavin Bollard
2017 marks the beginning of a massive shift in technology at work. We’re re-branding, we’re moving office and we're changing our technology from IBM to Microsoft. It's going to be a wild ride and I hope that you’ll stay with the blog as I delve into the new world and try to figure out what works and what doesn't. I've been on Notes/Domino since version 3.0 and I haven't used outlook at all, apart from a week in 1995 when I decided that I hated it (plus of course, the regular int
3
Microsoft - Clear Leaders in the Race for Digital Identity
Thu, Nov 17th 2016 11:59p   Gavin Bollard
One of the less obvious trends of the last five years has been the race to own people's "digital identities". It started in earnest with Facebook and Gmail and it soon spread to Apple and LinkedIn. More recently, we've seen Microsoft and IBM jumping on the bandwagon and I think that's when I started to realise that there was much more to this than simply "targeted advertising". Quiet Beginnings At this point, I'm not sure that all of the founding companies in this revolution fully unde




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition