Import Excel to Database

Question

Hi All , 
 I am using import excel to Databse smart service , But I am getting error called " No valid entries or contents found, this is not a valid OOXML (Office Open XML) file" , I have given the same column names as in DB and data source is jdbc/Appian , my table name is different from my CDT name , can someone help me on this ?

Deepak gupta · Answer

Hey, There is a new smart service available called import excel to database. you can use that.

Enter datasource name for example jdbc/Appian, map your excel document and enter your tablename in the properties of the smart service.

Deepak gupta · Answer

table name is correct what you entered?. please copy the table name from the DB and use that name to insert the data to DB, Make sure the field names of the table will be same in the excel columns. 
 
 As an Example. your table is Test_details and field names are id, name, percentage so in smart service the table name will be Test_details and in excel column names will be id name and percentage.

Deepak gupta · Answer

Could you please make subject id as String in DB. Or otherwise, Read the excel by using readexcelimportfile function and cast the result into CDT of this table and use write to datastore Entity. In the excel,you are using subject id as 1 for every row. is subject id is not a primary key in your table?

Import Excel to Database

Top Replies