Hi All,
I am trying to import excel to database, but getting this error. I am using PostgreSQL database, is this smart service work with PostgreSQL?
Thanks,
Kiran
Discussion posts and replies are publicly visible
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.