Submissions Database v6.2 - converting submission data to file or XML
We're having some issues where Forms are reported to be filled out and submitted, but nothing actually coming in.
I've done what I could to convert the content column in SQL back to XML and I *think* it is working so far. I am indeed getting XML data.
We specifically need to search for values in certain controls to confirm is a submission actually came in or not.
Is there an official way to convert submission data? (using .NET/MS SQL)
-
Hi Bill,
I am not completely sure I understand your problem. Are your forms integrated with a different backend system to which you are posting the form submission data? But you are not seeing the expected data reach the backend?
Can you download and send us one of your form zip files so I can see your configuration?
Thanks,
Prajakta
0 -
Form submissions are still going directly into the default configured database, which is MS SQL in our case.
When I browse through the submission data in the database itself, it is stored in long hex strings.
0x3C70303A41707....... (and on and on).
When you look at submissions in the web, you see all data in the XML format.
We would like to be able to search submission data on a large scale to see if submissions actually exist, directly from the database if possible. For example, search 500 submissions for someone's last name.
However we'd need to first convert the long submission data (0x3C70303A41707....) into actual text.
I know the Data API can be used, but if possible we would like to query the database directly.
I've just been looking how to convert the actual submission data from the database into regular text without using the Data API or the web interface/Submission Repository GUI.
Using either SQL or .NET.
0 -
We tried using the Data API to search submissions via Sharing/Access Control (using the "Who can view submissions" in Access Control), but thus far we've only had luck querying submissions using the user credentials of the user that actually designed the forms.
There are other automated processes that are using the Data API via this Form Designer account, so we don't want to risk API calls "tripping over each other" (assuming that's possible) if there are several separate programs trying to use the same account in API calls.
This is why we were looking to directly query the database.
0 -
Hi Bill,
We do not recommend accessing the database directly. If any data is altered during this access, it might upset the frevvo server setup. Data API is the only recommended way if you need this.
Another alternative is to upgrade your frevvo server to v7.1 or later release. We have added submission filtering by field data in these versions of frevvo. Please see this documentation. So with this feature, you will be able to search your submissions as needed within frevvo application itself.
Thanks,
Prajakta
0
Please sign in to leave a comment.
Comments
4 comments