• Testing with CSV and Excel to Notes.

    By Puhn Dunners 2 decades ago

    Hi,



    This is a fantastic tool. Really. Thanks for your great effort and especially for the demo files.



    I have tested several scenarios:



    CSV to Notes Test

    ===============

    189 lines for processing (Add new documents to Target DB, update existing documents).

    The key in CSV file is a number (from 19 to 1014)

    1) If the key in the Target DB is a text field - when DB empty - all documents created correctly, but when updating (even when simply re-running Upload), documents are updated correctly, but log throws an error:



    Errors: Operation failed

    Error in Row: 191

    Error no: 1024 in LotusScript line: 25

    Time to Run (sec): 10.469970703125

    <br/>

    Created: 0

    Updated: 0

    Deleted: 0

    <br/>

    Processed: 189

    Found by Key: 189

    NOT Found by Key 0



    2) If the key in the Target DB is a number field, when DB empty - all documents created correctly, however when updating, the key cannot be found and new documents are created again (probably this is a normal behaviour - i.e. key must be a text field).



    3) CSV file uses ";" as a separator (not comma - ","). Obviously this is fine for Excel and DMA, but if a column name contains comma in it, the column choices on the 'Data to Move' tab cannot be numbered correctly (there are lines without a number, column names are truncated etc.).



    Excel to Notes Test

    ===============

    1) If multiple worksheets in the XLS file - only the first worksheet can be uploaded. It would be nice (but not absolutely necessary) if the interface allows for selecting a worksheet to upload.



    2) If the value in a cell being imported is #NA, LN will crash.



    Documentation and versioning:

    ========================

    Dcumentation is great. but it also refers to functionality that is missing :

    1) Advanced/Validation;

    2) Notes Transform

    3) Copy Profile Document

    Probably these have been removed from 1.0? I have downloaded 1.1, but could not find the version in the About or Help document, so it could be that I am using v 1.0?



    All the above will not stop me from using DMA :)



    Cheers!



    Puhn

    • Excellent feedback

      By David Jeyachandran 2 decades ago

      Hi Puhn,



      I've said this before but thank you for your excellent feedback.



      CSV to Notes Test

      ===============

      1) You were correct about the DMA throwing an error even when it looks like to completed successfully. The new release will be less sensitive and less meaningless errors will be thrown. I've put more work into a more robust error handler.



      2) If the key in the Target DB is a number field, when DB empty - all documents created correctly, however when updating, the key cannot be found and new documents are created again. I am leaving this one for the moment. The key must be a text field.





      3) CSV file uses ";" as a separator (not comma - ","). A useful enhancement would be to make the separator configurable but I will leave this functionality as is for now.



      Excel to Notes Test

      ===============

      1) If multiple worksheets in the XLS file - only the first worksheet can be uploaded. It would be nice (but not absolutely necessary) if the interface allows for selecting a worksheet to upload. This is a great idea and I will get this implemented. The next release (1.2) is a turning out to be lots of work so I'll leave this for the one after.



      2) If the value in a cell being imported is #NA, LN will crash. I am very happy to say that this is fixed in the next release (1.2). The side effect is that it will not let you upload a cell that begins with a "#" but I think that would be extremely rare. Crashes should anyway be prevented at all cost.



      Documentation and versioning:

      ========================

      Dcumentation is great. but it also refers to functionality that is missing :

      1) Advanced/Validation;

      You are right - I had removed this. I will bring this back in a later release. I have removed this from the documentation.



      2) Notes Transform

      You will find this by going into one of the "Notes to Notes" view and clicking New - Notes Transform.



      3) Copy Profile Document

      You will find this by going into one of the "Notes to Notes" view and clicking New - Copy Profile.



      The new release is taking a little longer than expected but I'm glad the DMA is getting more robust and the logging is getting better.



      I've released a new version of another OpenNTF project called "Notes Reconn". It's still in beta but please check it out if you are interested in generating web/Notes client reports from any Notes Database.



      Thanks again.



      Kind Regards

      David