Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. 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 tried using import excel to database smart service to import the data from excel to database which is working as expected, but when i test some negative scenarios like in one of the fields i gave more than 255 chars and tried uploading. Its failing and i wanted to capture the error so in output section i have created the pv to store the same. But its not working. Can anyone tell me how to solve this issue pls... thanks
Discussion posts and replies are publicly visible
This plugin can be a little finicky at times. For this reason I always implement fn!readexcelsheetpaging() instead from the Excel Tools plugin, to read the Excel document in an expression rule, then you can cast it to your CDT while performing any transformations necessary. Once your CDT is populated, simply use the Write to Data Store Entity service. It is a few more steps, but much more flexible and supportable I find.
Thanks Chris, ill try to explore fn!readexcelsheetpaging() and get back to you in case of any issues...