Novell Cool Solutions

Tab2NAB



By:

September 27, 2005 5:11 pm

Reads:6,728

Comments:3

Score:Unrated

Print/PDF

License:
Free

Download tab2nab

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:

  1. From your GroupWise address book, select your address book(s) you want to edit/consolidate, go to File/Export
  2. Import the *.NAB file(s) into Excel
  3. 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:

    :::TAGMAP:::0FFE0003:***,3001001E:Name,3A08001E:Office

  4. 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)
  5. Run Tab2NAB.exe utility, and select your saved tab-delimited file (MyAddresses.txt). This will produce a new, correctly formmatted .NAB file ( MyAddresses.nab)
  6. From your GroupWise address book, either create a new book, or select all the entries in your target address book and delete them.
  7. Go to File/Import, and select your .NAB file for import (MyAddress.nab)

Voila! A nice, clean address book!

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.
Loading...Loading...


Categories: Uncategorized

Disclaimer: This content is not supported by Novell. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.

3 Comments

  1. By:vanslyck

    This is for those who’ve had difficulty using this tool. Before step 2, you may find it helpful to rename the exported *.NAB file(s) to *.CSV. Just change the filename extension. After that, import the exported file(s) into Excel. You may have to try doing this a couple of different ways, to get Excel to bring up the import dialog.

    Read step 4 carefully. When you’re done in Excel, you must save the file as a tab delimited *.TXT file. Not a *.CSV file.

    When all is said and done, you’ll have dealt with up to five different files, in this order:

    1. MyAddresses_exported.NAB
    2. MyAddresses_exported.CSV
    3. MyAddresses_working_and_cleanup.XLS
    4. MyAddresses_to_be_imported.TXT
    5. MyAddresses_to_be_imported.NAB

    TAB2NAB is run after making the *.TXT file and it will generate the *.NAB file.

    • By:Anonymous

      I am finding that running tab2nab creates a .csv file, not a .nab file. I’ve spent about an hour and gone through the developer’s and vanslyck’s steps several times with a fine-tooth comb, but can’t get a .nab file, only a .csv. Anyone?

  2. By:anonymous

    TAB2BAB doesn’t create the NAB file at step 1. At step 1, the NAB is the file exported by GroupWise. You then rename that NAB file to a CSV file, and it is the CSV that is imported into Excel. Then you clean up the data, save the Excel file as a tab delimited *.TXT file, and _then_ you run TAB2NAB on that TXT file to create a new NAB file which you can re-import back into GroupWise.

Comment

RSS