• Excel to Notes

    By Gaurang S Sampat 1 decade ago

    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.

    • Embarassing bug - Yes you are right!

      By David Jeyachandran 1 decade ago

      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