Question

Forms and Files uploaded - when and how they can be removed ?

Forms

Updated May 21, 2018

asked on February 24, 2017

Wondering if LF forms 10 also stores files in SQL when a file is attached or uploaded, and if so what are the ways to get rid of these files from the SQL itself since most are saved to our repository anyways ?

Seems bit of an overhead if the file uploaded sits not only on the repository but also in the SQL itself ? Why not simply link to the tables that the LF main sql table uses ?

1 0

Replies

replied on February 24, 2017 • Show version history

Hello Sumeet,

Starting from Forms 10.1, you can delete all the data from the SQL database when you delete an instance. Unfortunately, there are no out-of-the-box solution to remove these files from the SQL database without deleting the associated instance as of now.

Warm regards,

0 0

replied on February 28, 2017

Hey,

By deleting instance you mean the "completed" or finished/pending instances correct ?? Or do you have to delete the entire process/instance ?

0 0

replied on February 28, 2017

Yes, deleting the "completed" or finished/pending instances will remove file attachments associated with that particular process.

0 0

replied on February 28, 2017 • Show version history

I am not sure if you would know, if there is some work being done on forms area with regards to this - overhead / duplication of files happenings if a user is saving it to repository ! The system should not be saving copy of it as well on the forms server if user opted to store file in repository. It puts bit of an overhead on not only storage but also the backup systems too.

1 0

replied on May 21, 2018

@████████

Here is a workaround:

https://answers.laserfiche.com/questions/130478/Clear--Reset-a-file-upload-field#130836

0 0

You are not allowed to follow up in this post.

Question

Question

Forms and Files uploaded - when and how they can be removed ?

Replies

Sign in to reply to this post.