Uploading Names into a Names Field
Posted on 2007-07-30
Sorry to be revisiting this. I thought I had it working but I am once again having some issues.
I import a list of Funds and Fundmanagers from Excel into a Names field type using the following:
Dim DocRdr As NotesItem
doc.FundUsers = .Cells(row, FundMgr).Value
Set DocRdr =New NotesItem(doc, "FundUsers", Names)
DocRdr.IsNames = intNames
Unfortunately Notes doesn't seem to store the Names field type correctly when updated via Lotus Script. This causes problems later when I copy the user names into a Reader field because Notes does not recognize the users name in the Reader.
But if I update the imported records directly (by changing a different field), everything works just fine. When I do the update I can see Notes is changing the format on the name to a CN= format. So, the Notes engine is updating the field with the right format at that time. Is there some way to set this via the VB script?
The other piece of information is that updating the second field via an agent or action does not work. I have to update each record directly. So there is something in the UI that is getting invoked, that I'm not triggering when deal from the backend.