Address book import

Hi

I know I’m probably going to regret even posting this but I’ll give it a try.

I have a new staff person who wants to import 2000 outlook contacts.

I have gotten them to export as a CSV file.

I have reworked and cleaned up the CSV file.

I have massaged via Excel and saved as WK4 workbook as per

https://www-304.ibm.com/support/docview.wss?uid=swg21098837

I have updated the column headings.

I have successfully imported the WK4 into a new personal address book, or contacts, nsf file (lotus seems to like have two names for just about everything in 8.0.2).

In the notes client I have added the address book into the File>Preferences>User Preferences>Local Address book list.

When I create a new email I can click on new message and then on “To” and select a person/email address from the new address book

But…

the auto name lookup does not work.

For example I have an entry for a person called Guy Ritchie. When I type “Guy” into the “To” field all I get is a message down the bottom status line saying "Could not find ‘Guy’ "

In my location document I have Recipient Name lookup set to exhaustively check all address books - and I know that has it’s own issues but it mostly works ok

Here’s the real problem - if I go into the new address book, and edit the entry for Guy Ritchie. I just click on Edit then click Save and Close - without actually making any changes - the name lookup starts to work.

When I type in ‘Guy’ lo and behold it now finds Guy Ritchie

So, can anyone tell me, how I can make it work without having to manually and go Edit, Save and Close on the remaining 1999 entries?

PS it’s only taken about 6 hours for me to get this far so I’m really loving how easy this is

PPS I’ve had a look in the 802 personal address book design - and by gee it’s ugly in there, did it get cleaned up in 8.5?

Subject: Try opening the addressbook after the import

and pressing Ctrl-Shift-F9 to rebuild all the view indexes, that might do it.

Otherwise you’ll need to create a quick agent that does a @Command( [ToolsRefreshSelectedDocs] ) Which when you run that agent from the view, is the equivalent to editing each document and hitting save, and then closing it.

Subject: Fixed - many thanks Carl

you are a legend

ctrl-Shift-F9 solved it