This exercise is intended for new users of DBXL who want to orient themselves to its features and interface. This exercise will go through configuring a form’s data connection to submit to the DBXL Web Service, verification of success, and accessing the submitted form.
Tutorial
The Qdabra DBXL Web Service stores three metadata properties for all forms: title, author, and description. When InfoPath submits the form to the database, these three fields will be stored to identify the submitted form. You can use a secondary data source or data from within your form to specify these three properties.
The following steps will illustrate how to configure a Submit button to use DBXL’s Submit Document Web Service.
1. Modify the form to incorporate a submit button
a) Click Controls in the right-hand task pane.
b) Click on Button. A button control will appear in your form’s view.
c) Double-click the button to display properties, as seen in Figure 1.
Figure 1
d) Select Submit Options from the Action drop-down.
e) Click the button labeled Submit options.
f) Check the box labeled Allow users to submit this form.
g) From the Send form data to a single destination dropdown.
h) Select Web service from the options in the dropdown, as seen in Figure 2.
Figure 2
i) Click Add to add a new data connection to your form.
j) Enter the name of the Qdabra DBXL Web Service. The URL is http://<servername>/QdabraWebService/DBXLDocumentService.asmx. Click Next. InfoPath will attempt to connect to the web service and show you a list of methods.
k) From the list of methods, select the operation named SubmitDocument and click Next.
l) Skip the first parameter.
m) Select the second parameter, named tns:xml. Select the Entire Form radio button and check the Submit as a string checkbox. The end result can be seen in Figure 3.
Figure 3
n) Select tns:name parameter. Select the radio button Field or group in the Parameters options section. Click the Modify button to the right of the textbox. In the Select a Field or Group dialog box, make sure the Main data source is selected. Select any field from your form; this will be stored as your form name. Click OK.
o) Repeat Step 13 for tns:author and tns:description, selecting fields in your form as appropriate.
p) Click Next. Click Finish. Click OK. Click OK.
q) Save the form and close InfoPath.
2. Modify the configuration in DAT
a) In the DAT, click Edit for the form’s configuration.
b) Attach the recently modified form and click Save.
3. Fill out and submit the form
a) Return to the configuration list and click on Open.
b) Fill out your form and click on your new Submit button.
4. Verify the result
a) Back in DAT, click to Edit the configuration.
b) Click on the Documents tab to verify that the data has been submitted.