InfoPath Dev

Okay I got DBXL working with Sharepoint 2007 and InfoPath 2007 installation.  I'm using SubmitDocument web service. It INSERTS new data from form into SQL table but if DocID exists it is not UPDATEing the row, its adding another new row.  Is there a differenct web service I should use or can I control this using rules somehow? 

Hi Doreen,

Glad to hear DBXL is up and running.

When a form is submitted via the DBXL Document Service (SubmitDocument), a set of processing instructions (PIs) are inserted into the XML form.

If the form is later reopened, modified and resubmitted, this will (or at least should) overwrite the same existing form.

So there are essentially two scenarios:

1. New form -> no DBXL PI -> submits new data

2. Existing form -> DBXL PI exists -> overwrites

I'm a little surprised that this is not what you're currently experiencing. Can you describe what you're seeing? You can keep an eye on the Documents tab in DAT as well to see whether a new DocID is added or an existing one overwrtten when you resubmit.

Thanks.

I am glad to hear that SubmitDocument should overwrite if exists but that is not happening in my case.  Each submit is creating a new row.  In DAT I only see added documents.    I am not sure what info you need to troubleshoot. 

 Not sure if this has anything to do with it but my one submit button on the form submits to webservice and submits to SharePoint list.  It is not duplicating in SharePoint, just in the database.

Can you describe the step by step process? i.e.

1. Click Open for your doctype.

2. Fill out the form

3. Click Submit

4. Go to the Documents tab in DAT

5. Click Open on the existing document

6. Make changes and resubmit.

If the steps vary from the above, let us know what they are. Thanks!

I open an existing form in SharePoint library.

I make changes on 3 fields.

Click submit button.

I have SQL open, and refresh the database where I see new row appear.

In DAT documents tab, click refresh, new item is there too.

Thanks.

How are the forms making it to the SharePoint form library? Did you set up a SharePoint mapping in the DBXL Admin Tool?

I wrote it into the submit button. I did attempt to disable the rules and add sharepoint mapping but I can't get that right either. 

UPDATE: I figured out the problem >>ME<< While delving into why my SharePoint mapping attempts failed, it caused me to  look at my URL closer and I realized I installed DBXL on my production SharePoint server, not on my developement server.  I published form to SharePoint library on development server, not production.  So I was mapping to wrong SharePoint server where DBXL was not installed! urgh!  Once I moved the library to production, updated data connections in form, updated DAT doctype, save, reshredded, the mapping worked fine AND the UPDATEs starting working too! I spend all afternoon on this - Time to go home! Yeah!!!!