Move or synch data between Notes databases or with Excel. Relationally combine data using a key.
Hi David, I downloaded v 2.0 and tried the Excel to Notes data update for the example that you gave. It does not seem to get any matching keys. Same thing happened with few other examples that I tried. This is what I modified to get it working: Script Libraries -> Common-FieldLevelLibrary -> Function getConfigInfo -> Line 118 REPLACE If Cstr(docConfig.KeyColumnNO(0)) <> "" Then moveConfig.isKeyAvailable= False Else moveConfig.isKeyAvailable = True WITH If Cstr(docConfig.KeyColumnNO(0)) = "" Then moveConfig.isKeyAvailable= False Else moveConfig.isKeyAvailable = True The problem is with the condition (<>). I hope that correct and does not upset any other functions.
Hi Gaurang, What an embarrasing bug! I think that this may have been a bug I introduced in version 2.0. It has now been fixed & I better release the new version (2.1) soon. Thank you for spotting this one and providing the solution. Kind Regards David