Skip to main content
mohammedmujaheedp0001
mohammedmujaheedp0001
November 6, 2023
Question

Import Data from excel to database

  • November 6, 2023
  • 4 replies
  • 0 views

Hi All,

I have a scenario where i am facing some issue:

I have a process model to create a data into db by using import excel to database, when i add the data in excel and upload its working as usual, but when i miss some rows in excel while adding data and uploading.

process model is not writing that data in Database, its simply completing the flow but not writing the data.

    4 replies

    sriramk5349
    sriramk5349
    November 6, 2023

    Hi [mention:66d56c5c48e14e2794083f5e086d5dbd:e9ed411860ed4f2ba0265705b8793d05],

    If appian detects one empty row, then the node stops there from writing into db. So please dont leave empty rows in the middle

      mohammedmujaheedp0001
      mohammedmujaheedp0001Author
      November 6, 2023

      Hi @sriramkaja thanks for you response, Is there any validation we can add so that it throw some error or cancel the floe please?

      sriramk5349
      sriramk5349
      November 7, 2023

      Hi Mohammed, you can read the file using readexcelsheet or readexcelsheetpaging but those functions also stop reading once they detect empty row. So, better check the file before uploading

      D
      dhivyam231668
      November 9, 2023

      Hi [mention:66d56c5c48e14e2794083f5e086d5dbd:e9ed411860ed4f2ba0265705b8793d05] 

      We have done a workaround to handle this case. If anyone has a better solution please share it. 

      1. Read the data from Excel ( readexcelsheet() ).

      2. Check that the expected column has been returned, before pushing it to the table. 

      3. If it is empty, return the flow back to the screen, and will show a validation message manually. 

      Hope it will work for you. 

      Terms & ConditionsAccessibility statement