Import Data into an Existing View

HCL Domino Domino Forum
1

Lotus Notes V8.I have an existing view with columns called: Store No, Store Manager, Store Name, Address, etc. I’m trying to Import the Store Managers names (which are currently blank) into the existing view. I have created the import file with headings Store No & Store Manager. Is there a way of matching the existing Store No with the imports Store No and add the Store Managers Name from the Import. I can import the data but I’m getting separate line entries for the same Store No.Your help would be very much appreciated.

Marion

2

Subject: I think you need to use something else

I take it you have tried to use the File, Import command. I don’t think that is designed for what you want to do i.e. update existing records as opposed to create new records. You would need to either write a custom import routine in LotusScript, or look around for a third-party tool.

3

Subject: Can I use Lookup

Is it possible to use Lookups? The import populates the view called ‘LookupStoreManagerName’ with field names: SAPNoN, StoreManagerNameN.Trying to bring manager name into ‘TestManager’ view with field names SAPNo (which has existing data), StoreManagerNameN, StoreName etc. How do I write a formula for column to populate the Store Manager Name if ‘SAPNo’ has the same value as ‘SAPNoN’ then compute StoreManagerNameN column

4

Subject: Yes, you could do that…

If you use the import process to populate the LookupStoreManagerName view, you could then write a one-off formula agent to run against all documents in the TestManager view with something like this:

FIELD StoreManagerNameN := @DbLookup(“”; “”; “LookupStoreManagerName”; SAPNo; “StoreManagerNameN”; [FAILSILENT]);

5

Subject: Using agent & lookup worked.

Thanks Wayne, Using the agent and lookup together is working fine.

Thanks for all your help… Marion