• What About Blank Rows

    By Bob Brodsky 2 decades ago

    David,



    I have been testing using a copy of my production environment and have questions (what else):



    1-Is there a way that when I select a Form name I could select the alias or could you use the alias if present



    2-The spreadsheet that I am testing has blank rows (all cells empty) in with the data and DMA is creating almost blank documents. It seems that you are processing the number of rows that the spreadsheet thinks it has rather than really testing cell contents. I like the current behavior except that I don't want the empty documents created.



    3-Every time I run an upload (not an analysis run) it always ends up with a dialog box that says that the server is not responding even though all rows were processed and all documents created



    Still trying,

    Bob

    • alias and blank rows

      By David Jeyachandran 2 decades ago

      Hi Bob,



      Thank you again for your testing and feedback. In response to your questions…

      1-Is there a way that when I select a Form name I could select the alias or could you use the alias if present

      Good point. At the moment there is no way to select the alias. I can see that this is important when creating documents using "Excel to Notes". A work around for the moment would be to add a formula for the Form that does Form:="ALIAS" when a document is created. This can be done on the "Fields to Modify - Target Db" tab & then "Fields to modify on CREATE" tab. In the Fields column type Form and in the Formula column enter "ALIAS".



      I will do another release this week to include a function that automatically uses the alias (if present) when creating documents.





      2-The spreadsheet that I am testing has blank rows (all cells empty) in with the data and DMA is creating almost blank documents. It seems that you are processing the number of rows that the spreadsheet thinks it has rather than really testing cell contents. I like the current behavior except that I don't want the empty documents created.

      This is a bug! This bug was introduced in the last release when the I added a feature that showed a progress bar when uploading from Excel and made the code faster by relying on this Excel function (xlSheet.UsedRange.Rows.Count). This Excel function give the accurate row count most of the time but sometimes is wrong. You can simulate this function by opening the spreadsheet and using CTRL - End and Excel will automatically take you to what it thinks is the end. I will change from using this Excel function and revert to my previous code that checks each Excel row. I'll see if I can get this to you tomorrow Bob.



      3-Every time I run an upload (not an analysis run) it always ends up with a dialog box that says that the server is not responding even though all rows were processed and all documents created

      This is a strange one. The code has an "On Error" to ensure all that the scheduled configs run even if the first one has a problem. It reports the error in the summary log and in a popup in the very end. It is annoying when you have no idea when the error was generated. Can you check if you have logging enabled and the log file exists? In the next release I'll remove the On Error for the "Excel to Notes" so you can at least see where the error occurs. The only other scenario I can think of is where the server is timing out on a particular row but then continuing.



      Please keep your feedback coming in.



      Kind Regards

      David