Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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
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
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
Did you try by making SubjectId as a varchar type?
Load excel file to DB Done. Thank You
Could you please verify the answer.
Sure