You are viewing limited content. For full access, please sign in.

Question

Question

Is there a way to see where forms stores form attatchments?

asked on January 31, 2017

I am working on a semi-complex implementation and I need the direct route to a file attatchment inside a form.

Is there any way to know where they are stored as temp files? Storing them in the repository and that info is of little help since the file location changes (AFAIK) from file to file in a random manner.

0 0

Replies

replied on January 31, 2017

I do not believe they are stored as temp files, but actually in the Forms database.

0 0
replied on January 31, 2017

Is there any way I can find them in a standardized manner?

0 0
replied on January 31, 2017

There should be some tables that would relate them back to the instance ID that they belong to. The issue you will run into is that they are probably encoded within the database, so you can't just pull the image from the database. Something would need to decode it to create the image. I could be wrong about that, but that is how I understand it.

0 0
replied on January 31, 2017

Yeah that sounds very complicated.

Somehow my client's Forms attatchements for one of their BPs the route is a Windows folder directly, this was done by a different VAR and I can't figure out how they did it. And I need to reproduce it.

0 0
replied on January 31, 2017

Custom JavaScript?

0 0
replied on January 31, 2017

Oh I'm sure.

But you'd have to have access to the Attatchment to begin with, or store it independently somehow. I also suspect it may be something particular to this BP and not something universal to the Server.

0 0
replied on January 31, 2017

If you go to the JavaScript page for the form what is there?

0 0
replied on January 31, 2017 Show version history

Just a JS that opens the Attatchment from the Windows folder and puts it on an IFrame.

These guys were very much deliberately sneaky.

0 0
replied on January 31, 2017 Show version history

Forms attachments are stored in the database in binary format. You can read more about that here. Keep in mind that was written for Forms 10.1. It may have been different in older versions.

Anyway, without seeing the whole system, it's hard to say how exactly it accomplishes what you describe. It is possible for Workflow to look up the form attachment data, create a file from it and save that file on disk. But that could really only happen after the form is submitted. I don't know where the JavaScript snippet you mention would come in, unless that's a different form that is used later on in the BP.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.