Re: Secondary Datasource submit issue

ineedhelp247 — Tue, 01 Jun 2010 17:58:46 GMT

Thanks for the reply. I did read this article before posting this one. What I ended up having to do was instead of sending the information to the web service as a dataset I sent it as a string. I then stripped out the differences between the main and secondary xml and read that information into the dataset on the web service which then worked out fine.

Re: Secondary Datasource submit issue

m3_del — Tue, 01 Jun 2010 17:38:38 GMT

Looks fairly complicated. I really only have one piece of knowledge that might be usful and that would be to explore the use of CAML to submit changes to the secondary data sources. This is working well for me.

Searching for CAML and/or UpdateListItems might get you started. My posting walks through my adventure to get this working and can be found here. http://www.infopathdev.com/forums/t/15477.aspx

Secondary Datasource submit issue

ineedhelp247 — Wed, 26 May 2010 19:19:44 GMT

I have only been working with Infopath for two days now so please be bare with me. The infopath form is broken down into four seperate sections so I have a main data source for section 1 and then three more for the next 3 sections. They are all able to query their respective databases fine and pull back the correct information. But when I attempt to create a submit button to insert any changes from the secondary's, infopath states that it successfully completed which it did not because the information did not change. The web service uses the same functions for all inserts so I would think if the main data source worked then the other should as well. After some testing I noticed that the web service did not recognize whatever was being passed to it when it attempted to submit to 2-4. I setup a listener and captured the output from both the main and secondary posts and the files appear different. This is the only thing that I can see that would be different. Could you please let me know if I am going in the wrong direction or else what I can do so I can get the secondary part to submit correctly.

Part 1 xml:

POST /Service1.asmx HTTP/1.1
SOAPAction: "http://localhost/PartOneInsert"
Content-Type: text/xml; charset="UTF-8"
User-Agent: SOAP Toolkit 3.0
Host: localhost:3261
Content-Length: 4394
Connection: Keep-Alive
Cache-Control: no-cache

<?xml version="1.0" encoding="UTF-8" standalone="no"?><SOAP-ENV:Envelope xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAPSDK3="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><tns:PartOneInsert xmlns:tns="http://localhost/"><tns:dsUpdated><xs:schema id="dspartone" targetNamespace="http://localhost/dspartone.xsd" attributeFormDefault="qualified" elementFormDefault="qualified" xmlns:mstns="http://localhost/dspartone.xsd" xmlns="http://localhost/dspartone.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"><xsd:import xmlns:xsd="http://www.w3.org/2001/XMLSchema" namespace="http://localhost/"/><xsd:import xmlns:xsd="http://www.w3.org/2001/XMLSchema" namespace="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"/><xsd:import xmlns:xsd="http://www.w3.org/2001/XMLSchema" namespace="http://schemas.microsoft.com/office/infopath/2003/changeTracking"/><xs:element name="dspartone" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"><xs:complexType><xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="part_one"><xs:complexType><xs:sequence><xs:element name="id_no" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int"/><xs:element name="ccbid" type="xs:int"/><xs:element name="requestor_name" minOccurs="0"><xs:simpleType><xs:restriction base="xs:string"><xs:maxLength value="50"/></xs:restriction></xs:simpleType></xs:element><xs:element name="date_submitted" type="xs:dateTime" minOccurs="0"/><xs:element name="department_name" minOccurs="0"><xs:simpleType><xs:restriction base="xs:string"><xs:maxLength value="50"/></xs:restriction></xs:simpleType></xs:element><xs:element name="business_system" type="xs:int" minOccurs="0"/><xs:element name="project_name" minOccurs="0"><xs:simpleType><xs:restriction base="xs:string"><xs:maxLength value="75"/></xs:restriction></xs:simpleType></xs:element><xs:element name="current_release" type="xs:int" minOccurs="0"/><xs:element name="release_requested" type="xs:int" minOccurs="0"/><xs:element name="requested_release_date" type="xs:dateTime" minOccurs="0"/><xs:element name="request_details" minOccurs="0"><xs:simpleType><xs:restriction base="xs:string"><xs:maxLength value="500"/></xs:restriction></xs:simpleType></xs:element><xs:element name="priority" type="xs:int" minOccurs="0"/><xs:element name="impact_of_missing_release_date" minOccurs="0"><xs:simpleType><xs:restriction base="xs:string"><xs:maxLength value="500"/></xs:restriction></xs:simpleType></xs:element><xs:element name="is_there_a_workaround" type="xs:int" minOccurs="0"/><xs:element name="if_yes_workaround" minOccurs="0"><xs:simpleType><xs:restriction base="xs:string"><xs:maxLength value="500"/></xs:restriction></xs:simpleType></xs:element></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType><xs:unique name="Constraint1" msdata:PrimaryKey="true"><xs:selector xpath=".//mstns:part_one"/><xs:field xpath="mstns:id_no"/><xs:field xpath="mstns:ccbid"/></xs:unique></xs:element></xs:schema><diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1"><dspartone xmlns="http://localhost/dspartone.xsd"><ns1:part_one xmlns:ns1="http://localhost/dspartone.xsd" diffgr:hasChanges="inserted" diffgr:id="part_one1">
      <ns1:id_no>0</ns1:id_no>
      <ns1:ccbid>1235050045</ns1:ccbid>
      <ns1:requestor_name>4</ns1:requestor_name>
      <ns1:date_submitted>2010-05-26T14:19:41</ns1:date_submitted>
      <ns1:department_name>4</ns1:department_name>
      <ns1:business_system>0</ns1:business_system>
      <ns1:project_name>4</ns1:project_name>
      <ns1:current_release>0</ns1:current_release>
      <ns1:release_requested>0</ns1:release_requested>
      <ns1:requested_release_date>2010-05-12T00:00:00</ns1:requested_release_date>
      <ns1:request_details></ns1:request_details>
      <ns1:priority>0</ns1:priority>
      <ns1:impact_of_missing_release_date></ns1:impact_of_missing_release_date>
      <ns1:is_there_a_workaround>0</ns1:is_there_a_workaround>
      <ns1:if_yes_workaround></ns1:if_yes_workaround>
     </ns1:part_one></dspartone></diffgr:diffgram></tns:dsUpdated></tns:PartOneInsert></SOAP-ENV:Body></SOAP-ENV:Envelope>

Part 2 xml:

POST /Service1.asmx HTTP/1.1
SOAPAction: "http://localhost/PartoneInsert"
Content-Type: text/xml; charset="UTF-8"
User-Agent: SOAP Toolkit 3.0
Host: localhost:3261
Content-Length: 1145
Connection: Keep-Alive
Cache-Control: no-cache

Newbie Questions

Re: Secondary Datasource submit issue

Re: Secondary Datasource submit issue

Secondary Datasource submit issue