Re: update sql database using infopath

Patrick Halstead — Sun, 24 Mar 2013 18:34:24 GMT

Hi, Luis Carvalho!

Yes, there are two ways to accomplish this:

1) Install DBXL Server and add the special Event Receiver to synchronize your forms

· The XML to SQL mapping will be conditional based on the workflow state

· No changes to the form are required

· The Event Receiver is in beta, but will ship in v2.8 (in the next month)

2) Configure the workflow to call DBXL Server’s SubmitDocument Web method

· Requires a custom workflow to call the Web method (or out-of-box Nintex, K2, ShP 2013)

· No changes to the form are required

· Works fine with DBXL v2.7 (no additional tools needed)

For the lookups, you just need to add a query to your form that calls QueryDB Web method to get the correct value from the DB. If the fields already have the correct value no change is needed.

I hope this answers your question.

Please let us know if you would like to see a demo of the above techniques. Our support lead, Ernesto Machado, is a fluent Portuguese speaker.

Thanks,

Patrick

update sql database using infopath

luiscarvalho — Sat, 23 Mar 2013 21:02:41 GMT

Hi!

I have the following business requirement:

We have an InfoPath form published to a SharePoint library, and when this form is submitted to the library (after going through an approval workflow), it needs to create a new record in a table in a backend database.

the table at the backdend database has some fields that are lookups to other tables so I assume this further complicates the task.

is this possible with DBXL?

thank you.

Luis Carvalho

Qdabra Database Accelerator

Re: update sql database using infopath

update sql database using infopath