Cybersecurity
DevOps Cloud
IT Operations Cloud
By Bryan Keadle
I found it necessary to clean up my GroupWise Address books. I had several different books going, some with duplicates, and now that I'm syncing to my phone, I really needed to consolidate them into one book.
Trying to merge several entries from several books into one, and then clean them up is quite an undertaking, especially if you attempt to do so using the GroupWise Address Book interface. I really could make better work of it by exporting the books from GroupWise, then importing them into a spreadsheet (Excel). Now by using the spreadsheet functions to sort various ways, I can more easily find duplicates, merge records, and edit fields. The trick now is to be able to save out the spreadsheet, and import it back into the GroupWise Address Book.
However, Microsoft Excel's .CSV format is incompatible with the GroupWise .NAB format for importing the address book back in. So, to work around this issue, I created this utility, Tab2NAB.exe, which will convert a TAB-delimited GroupWise address book "spreadsheet" into a compatible GroupWise .NAB-formatted file.
So, here are the steps for using Excel to clean up your GroupWise address book:
:::TAGMAP:::0FFE0003:***,3001001E:Name,3A08001E:Office
Voila! A nice, clean address book!