Import Excel to Database not working

Could you please check your table structure. I think ID is integer in your table and you are passing string for the insertion. You have to use toInteger("abc") function to insert the data successful id id is of integer type in DB Table

Hi deepak,

Thank you for replying, I am using postgreSQL DB I have tried your way also still the same error. Can yyou please tell me Is this smart service work with PostgreSQL?

If you look at the recent comments on the AppMarket, it seems like it doesn't support PostgreSQL

Hi Harshit,

Do you know any alternative way for postgreSQL?

or is there any function by which we can convert excel into CDT?

to convert excel to CDT, you have to use readExcelDocument function and then map the result into respected local variable and then use writetodatastore entity. Hope it will work.

Deepak gupta said:

to convert excel to CDT, you have to use readExcelDocument function and then map the result into respected local variable and then use writetodatastore entity. Hope it will work.

This is exactly what we do with fn!readExcelSheet() from the Excel Tools plugin.  I avoid those nodes that convert a file directly to the DB due to lack of debugging and reliability, and instead always read the file into a local variable with this function, then cast the result to CDT to be used in the Write to DS service.  Allows much more flexibility and is not DB-dependent. 

Deepak gupta said:

to convert excel to CDT, you have to use readExcelDocument function and then map the result into respected local variable and then use writetodatastore entity. Hope it will work.

This is exactly what we do with fn!readExcelSheet() from the Excel Tools plugin.  I avoid those nodes that convert a file directly to the DB due to lack of debugging and reliability, and instead always read the file into a local variable with this function, then cast the result to CDT to be used in the Write to DS service.  Allows much more flexibility and is not DB-dependent.