Novell Cool Solutions: Cool Tool
Use Excel to manage GroupWise address books.
|Posted:||27 Sep 2005|
Please read the note from our friends in legal before using this file.
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:
- From your GroupWise address book, select your address book(s) you want to edit/consolidate, go to File/Export
- Import the *.NAB file(s) into Excel
- Edit the records as needed, but do not change to order of the columns. You may want to keep the header line, which looks like:
- When finished, save the file as a Text (Tab delimited) (*.txt) file (MyAddresses.txt). *CLOSE* the file in Excel (it cannot be in use during the next step)
- Run Tab2NAB.exe utility, and select your saved tab-delimited file (MyAddresses.txt). This will produce a new, correctly formmatted .NAB file ( MyAddresses.nab)
- From your GroupWise address book, either create a new book, or select all the entries in your target address book and delete them.
- Go to File/Import, and select your .NAB file for import (MyAddress.nab)
Voila! A nice, clean address book!