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
Trick is the to remove the last column in your excel file and use it under "New Columns" with it's value under "New Column Values".
For example, in my CDT, the last column is always "isActive". Now when I would want to import Excel to database, I will not include "isActive" column on excel file, rather, I will input "IsActive" as Value under 'New Columns' and "1" as value under 'New Column Values'.
Following the pointers/field guide that mohamedt808 provided earlier, as inputs for 'New Column' and 'New Column Values', you should be able to import data.
As sandeepr373 mentioned, these were supposed to be optional fields, however, the node fails if they aren't populated, for some reason.
Keeping rest of the parameters as desired, the node should pass. It worked for me considering below:
© 2020 Appian. All rights reserved.