Web Services

Re: Connection Lost

fredarwin — Wed, 09 Nov 2005 14:54:37 GMT

Ok Patrick, here we go:

1.Scenario.
I am using a library document site(sharepoint) to store infopath xml, when i need create new or edit doc from this site then infopath is open and throught his webservices i save data to sql server database and then i send the new doc or editing doc to the same library document site.

2.The problem.
My xml doc have a master/detail data and one of the steps during the publishing of the InfoPath Form to the SharePoint Site ask me:
"Choose a function to use on repeating data:"
For the detail data(repeating data) i choose: "Merge"
For master data (Not repeating data) i choose:"First"

The problem here is for repeating data because the xml diffgram format held both rows versions:current and original data and on sharepoint site when i check a view (for example:"All Forms") and show me xml data mapped to library columns and for reapeating data this show me duplicate data.

Thats my problem!!

Fred Darwin Villareal

Re: Connection Lost

Patrick Halstead — Wed, 09 Nov 2005 08:28:40 GMT

Hi Fred,
What is the data flow of your solution? You have InfoPath submitting to an XML Web service. How is SharePoint involved? I need to understand what you are trying to do before I can understand the question.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Connection Lost

fredarwin — Tue, 08 Nov 2005 17:25:33 GMT

I understand right now what happened in my infopath xml.
Look:
1.My connection lost, is because a dataset as a disconnected datasource when data are updated via webservice then infopath dont know if data has changed and for this primary reason dont let me change data until i make a requery.
2.When sending and retrieving a DataSet from an XML Web service, the DiffGram format is implicitly used and in this format recreate the contents including column values from both the Original and Current row versions.
For this reason when i send my XML Infopath document to Sharepoint Document Library Sharepoint read the xml and interpret as a duplicate data because dont know recognize beetween original and current data.

Now my new question is:
What to recommend to solve this and not to see in sharepoint duplicated data.

thanx

Fred Darwin Villareal

Re: Connection Lost

fredarwin — Tue, 08 Nov 2005 00:47:48 GMT

Exactly AndersR, u'r right that is happened, i understand now, thank you for clarify i need it, now
i do a requery as you tell me then it let me change data but when i saved data for second time in the xml file the data are duplicated.
why??

sample:

<RetrieveDataResult>
<NewDataSet xmlns=""> <Products xmlns:diffgr="urn:schemas-microsoft...
<idproduct>167</idproduct>
.
</Products>

<_xdns0:originalData xmlns:_xdns0="http://schemas.micro.
<NewDataSet xmlns="">
<Products xmlns:diffgr="urn:schemas-microsoft...
<idproduct>167</idproduct>
.
</Products

Fred Darwin Villareal

Re: Connection Lost

AndersR — Mon, 07 Nov 2005 21:47:08 GMT

What exactly is the error message?

Sounds a bit to me like your data is stale: if you query a data base through a web service and update, you cannot edit your data until you re-query your data. This ofcourse is to ensure that someone else has changed the data since you retrieved them.

Just a guess.
//AndersR

Re: Connection Lost

fredarwin — Mon, 07 Nov 2005 13:54:57 GMT

Thanks Patrick,

Someone with a litle more experience in webservices?
I dont understand why after send data to my service to save then i can not change data again?
Anybody?

Fred Darwin Villareal

Re: Connection Lost

Patrick Halstead — Mon, 07 Nov 2005 05:46:52 GMT

Hi Fred,
I have no idea.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Connection Lost

fredarwin — Sun, 06 Nov 2005 20:21:06 GMT

Hi,

My problem:
I have a sumit/receive webservice when i send data to my submit connection this data are saved succesfully, but after this i try to edit any datafield in infopath form and infopath tell me that i need to recovey my connection for modify my data
why the connection is lost?

thanx

Fred Darwin Villareal