Hello,
I am new to Appian, have been working with it for a few months. Have done the developer training and studying for my CERT.
I have a request where they would like to put data in a Excel spreadsheet and then have a interface to click a import button and have the system import the Excel data into cloud databases. The would like to add data into Excel and then when done do the import.
Trying to wrap my hands around this and figure out if it can be done and confused when looking through the Documentation.
Can someone let me know if this can be done and point me to documentation that shows it and explains it.
Thank you
Discussion posts and replies are publicly visible
Hi,Yes sure you can do that. Add a file upload field in your interface where user will upload the excel file and then in your process model use "import excel to db" smart service node . This smart service will insert the data in your cloud database.
When I look at a process model, the only thing for import I see is Import CSV to Database I am not seeing a Import Excel data to DB?