Hi, we have the following requirements: upload a great excel file, more than 4 mb, read the content of this file, map the content into a CDT and store it on the DB so to retrive it later.
Usually i would have done this creating a form that allow user to upload the file, stored this file on a pv, used the readexcelspreedsheet() function for read and mapping the information on a CDT and store these informations on the DB
But now, from my understanding if we save just for 1 second on a pv these informations these will be stored on the in memory db and and also if the process is then archived the memory allocation will be left only when we will reboot Appian, so it is deprecated.
How can we reach the same result in the right way? readexcelspreedsheet doesn't work if the input document is the same uploaded in the form
Discussion posts and replies are publicly visible