InfoPath Dev

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

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