Question

Extract image file from Laserfiche Form Submission

Forms

Updated December 29, 2022

asked on December 19, 2022 • Show version history

Hi guys,

I'm new to the Laserfiche Form creation and would like to ask for help. I just started using SQL Server as well and don't have any SQL background so kindly explain it to me in a simple manner as possible (sorry!).

Background:

We have this form that uses the "File Upload" field and our guys use their iPads to take a photo, upload it, complete the form and submit it.

Our form is not connected to a workflow and it doesn't use a "Save to Repo" process. It only have the "Start" and "End" processes and we use a stored procedure to extract data from the Laserfiche default data table in SQL Server.

I use Excel to report on the data submissions from the form and as part of that data, there's a filename of the image (as attached) however I don't have any idea where the image is stored and how I can get access to it.

Can you please guide me on how I can access the image files?

Thank you in advance and apologies if my question is pretty vague. I'll try to explain further if it is not clear.

Regards,

Rem

Image submitted info.PNG (22.32 KB)

| Download

0 0

Replies

replied on December 19, 2022

I believe the attachment files are stored as binary in the Forms table "[dbo].[cf_bp_attachment_data]".

I am not sure if there is another way to get the attachment file itself though.

1 0

replied on December 19, 2022

Thanks Jonathan for responding. I had a look at that table and yes, the query to get the file_name is included in that stored procedure that we use to extract submitted forms data.

Still wondering though how I can see the images being uploaded if it is stored in a specific file path within the server and if it is, how can I access it without having to log in the server if that makes sense?

0 0

replied on December 29, 2022

The file content location depends on your process "File Storage Location" setting.

By default it is saved in database table "[dbo].[cf_bp_attachment_data]" in column "[attachment]" in varbinary format, you may try suggestions from sql - Script to save varbinary data to disk - Stack Overflow to extract it as file.

When "File Storage Location" is changed to a location in local drive, column "[attachment]" would be empty and you have to login to server and access the hard drive for the file content.

1 0

You are not allowed to follow up in this post.

Question

Question

Extract image file from Laserfiche Form Submission

Replies

Sign in to reply to this post.