Skip to main content
December 15, 2021
Question

About null arguments is invalid

  • December 15, 2021
  • 5 replies
  • 0 views

I upload a excel and saved into database, then report such error

    5 replies

    selvakumark
    Participating Frequently
    December 15, 2021

    Hi, have you checked whether the pv!loginData is null?

    December 15, 2021

    Seems the parameter value didn't transmit in successfully, why?

    I only have 3 processparameters: but it tells me i need to input 4 parameters, where did I miss?

    csteward
    December 15, 2021

    As these Import-Directly-To-DS nodes can be finicky at times, I always recommend utilizing fn!readexcelsheetpaging() from the Excel Tools plugin, create a CDT with the data and utilize the Write to Datastore Entity service to persist.  This allows extra points for debugging and data manipulation capabilities. 

    December 16, 2021

    any refer document of readexelsheetpaging, I don't know what fill inside either

    csteward
    December 16, 2021

    It should be the document, sheet #, and start row #.  Have you ran any tests?

    If you type the function in your /design expression editor it will show you the function definition, and other information is available from the App Market page for Excel Tools as well.