This is the new Smart Service in Process modeler "Import Excel to Database", and there is no Documentation available regarding this.
Can anyone help me out that how to use it.
Discussion posts and replies are publicly visible
Hi .. assuming this is functionality offered up by the Excel Tools Plug In, then there maybe documentation on the Plug In page community.appian.com/.../excel-tools
You may need to download the JAR file to access the PDF document contained inside the JAR.
yes,its just a test table and very simple structure:
I have put up a quick explanation not so nice though, please refer it for configuring the Smart service fields .
What I would suggest is that,
1. Don't keep your Primary key in the file, use a separate ID column in the table make it auto increment. This smart service just does insert and not update is my understanding so if you repeat with same user id you may not find the data gets updated in the DB table.
2. Define exact no of columns you want to read from the file
3. Use the same column name in both excel and DB
© 2021 Appian. All rights reserved.