Read Excel data and update few fields from the EXCEL in the database.


Case: Read Excel data and update few fields from the EXCEL in the database.

Steps:

1. User exports the data (Including ID field) in an Excel from the Record type view(only download 20 attributes out of 50 in the data type field)
2. User updates few Fields in the excel then uploads through an action given on the record type view.
3. Action calls the process model which has an Interface for the user to upload the document (created a Process variable of Document type- BulkUpload).
4. In the process model I call an expression rule which passes the document (BulkUpload) as the parameter in the Script task output and retrives all the output in a particular format.

Issue: Script task output generates two null records and adds two null rows in the database. However, when I test the expression rule separately then the output is as expected and reading all the records accordingly.

  Discussion posts and replies are publicly visible