Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Team,
I am using the smart service - Import Excel to Database - in one of my development projects to read an excel files and write the values as-is to the database tables. The excel file is huge and is having 2 sheets that contains data to be written to 2 different table. As per the implementation, I have created 2 different tables for storing this information and the excel column names and table column names were specifically mentioned along with the mandatory information required for the smart service to work.
Data is getting written into the database table, but not fully. The first sheet has 83621 rows (out of 83625), and the second sheet has 137738 rows (out of 137742) of data that needs to be written to the database table. The batch size of the smart service is configured as 1000. After successful execution of the process model, I could see that the 82994 rows were written from the first sheet and 136994 rows were written from the second sheet of the excel file.
I believe it is something related to the batch size, as I modified the batch size from 1000 to 500 and the number of rows processes got changed to 83494 and 137494 respectively, which is 500 rows more than what was the previous outcome. Further, I reduced the batch size to 100 and the number of rows processes got changed to 83594 and 137694 respectively, which is again 100 more than was the previous outcome.
Because of this issue, we are not able to extract the data completely from the excel files. Kindly help me in resolving this issue.