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 ?
Discussion posts and replies are publicly visible
is your CDT field names similar to the table column name?
Yes
Hi Souvik,
yes, sometimes it is not working properly. you have to use a!readexcel funtion for reading excel data.
it will help you .
Regards,
Bhanu.
not found a!readexcel function
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.
Are the inputs right in the screenshot?
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.
Now table name is correct, but
This is my excel sheet
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?
subjectId is not a primary key. Please show me any example with this readexcelimportfile function. I'm not used before