Newbie Questions

Re: Submitting data to secondary data source

Hilary Stoupa — Tue, 07 May 2019 15:15:19 GMT

I replied to your new thread, but wanted to add this here as well: https://www.infopathdev.com/forums/t/26246.aspx has some step by step guidance.

Re: Submitting data to secondary data source

ncodename.sabir — Tue, 07 May 2019 06:16:25 GMT

Hi, I couldn't caught up how did you managed to do this. Do you have a step by step guide on how to do this?

Re: Submitting data to secondary data source

m3_del — Fri, 21 May 2010 14:28:33 GMT

I am very glad. Thank you for sticking with me on this! I have learned more about infopath this week then all my previous encounters before! Thanks again!

Re: Submitting data to secondary data source

Hilary Stoupa — Fri, 21 May 2010 00:40:13 GMT

Well, that is an odd one! Good job figuring it out, tho. You must be quite pleased to be done with this one!

Re: Submitting data to secondary data source

m3_del — Thu, 20 May 2010 17:43:40 GMT

Ok, so I got rid of the on change rule for the checkbox and made a rule for on submit that changes the field[@Name='Virtualized'] to the checkbox value. This works as intended. Strange that the same exact rule for the checkbox onchange is unable to remain consistent in the web form version

Re: Submitting data to secondary data source

m3_del — Wed, 19 May 2010 17:40:38 GMT

No Errors on Design checker.

Here are my two rule sets that I have the first group applies when I change the server drop down. The second applies when I change the value of the virtualized check box. (btw how do I put code into its own section on these boards? I am not seeing a code tag) The first set work both when i preview the form and when I publish the form and open in my browser (ie8). The second however, works in preview mode. But once I publish and try it in the browser when I change the checkbox value both ID and Virtualized change to true or false. This is obviously overriding the ID field. Screenshots below to illustrate.

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[@Name='Virtualized']" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Virtualized[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"></xsf:assignmentAction>

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/@ID" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"></xsf:assignmentAction>

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[@Name='ID']" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"></xsf:assignmentAction>

<xsf:assignmentAction targetField="../my:virtualized" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Virtualized[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"></xsf:assignmentAction>

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[@Name='Virtualized']" expression="."></xsf:assignmentAction>

Image of the form after I select a server. It successfully grabs the "Virtualized" value from the secondary datasource as you can see both the checkbox and the table at the bottom are set to true.

When I uncheck the check box you can see that both the ID and Virtualized fields change to false. This behaivior is not mirrored when I open the form in Infopath and use the preview function.

Re: Submitting data to secondary data source

Hilary Stoupa — Wed, 19 May 2010 16:51:06 GMT

Both changing to what? If you use the Design Checker on your form, are there any errors? This could be because of the filtered XPath for the rule targets....

Re: Submitting data to secondary data source

m3_del — Wed, 19 May 2010 16:46:09 GMT

So here we are I think I finally have it working!

At least when I preview in Infopath...

When I publish and try in the web browser I end up with the ID and Virtualized Fields both changing instead of just one. Can I expect these forms not to work in web format? I am not sure that is a big deal, just would be nice to know for sure.

BTW thank you so much for your patience with me on this! I am glad I finally have it working definately learned a lot on the way.

Re: Submitting data to secondary data source

Hilary Stoupa — Wed, 19 May 2010 16:38:26 GMT

See how in your expression for the ID field you have a filtered XPath?

expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"

While in your expression for the Virtualized field you do not? So the expression for the Virtualized field will currently always return the first Virtualized node in the Regional Servers data source. I'm going to guess that the same filter in the working expression would work in your expression for the virtualized field.

Your intial XPaths to the fields were incorrect. Instead of this: Field[../@Name='ID'], you'd want: Field[@Name='ID'].

Re: Submitting data to secondary data source

m3_del — Wed, 19 May 2010 16:31:50 GMT

Ok,

Here is what is mostly working now.

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[2]" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Virtualized"></xsf:assignmentAction>

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[1]" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"></xsf:assignmentAction>

Now the ID field is updating but the virtualized always says true...getting closer

Re: Submitting data to secondary data source

m3_del — Wed, 19 May 2010 15:34:53 GMT

Here is the modified (unworking) manifest.xsf. For the first and last assignmentAction I have added in [../@Name='Virtualized'] and [../@Name='ID'] I have also tried without the @ symbol. I understand this as "change the value of the field where the name equals Virtualized" Am I reading this correctly? I am slowly starting to "get it", thanks for your help!

<xsf:ruleSet name="ruleSet_5">
<xsf:rule caption="Rule 1" isEnabled="yes">

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[../@Name='Virtualized']" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Virtualized"></xsf:assignmentAction>

<xsf:assignmentAction targetField="xdXDocument:GetDOM("update")/Batch/Method/Field[../@Name='ID']" expression="xdXDocument:GetDOM("Regional Servers")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ID[xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Title = ../d:Title]"></xsf:assignmentAction>

</xsf:rule>
</xsf:ruleSet>

Re: Submitting data to secondary data source

Hilary Stoupa — Tue, 18 May 2010 23:01:41 GMT

I'm sorry, I forgot about that IP limitation for rules. Here's a blog post that explains how to do this in the manifest.

Re: Submitting data to secondary data source

m3_del — Tue, 18 May 2010 22:48:56 GMT

When I add a second Field in the CAML and I add a control source on the form it is a repeating field. There is now no way for me update the fields via rules. Is this something that can not be done natively in infopath? When I tell Infopath to update "field" on the update datasource it fills in both ID and Virtualized with the same data.

After selecting a server This is what my form looks like

Re: Submitting data to secondary data source

Hilary Stoupa — Tue, 18 May 2010 22:17:50 GMT

Put a control on your form bound to your update datasource, so you can verify what your resulting CAML looks like after your rules run. You also need to add another Field node to your XML for your update data source -- as I mentioned early on, you need <Field Name="ID"></Field>.

Your CAML should probably look something like this prior to being submitted:

<?xml version="1.0" encoding="UTF-8"?>
<Batch OnError="Continue">
    <Method ID="15" Cmd="Update">
        <Field Name="ID">15</Field>
        <Field Name="Virtualized_x003f_">true</Field>
    </Method>
</Batch>

"15" is an ID I just made up. You may or may not have an item with an ID of 15. I really really really encourage you to try the U2U CAML Query Builder -- it is free and can help you get your CAML right.

Re: Submitting data to secondary data source

m3_del — Tue, 18 May 2010 17:01:36 GMT

I am still just baffled by this method to update a secondary data source. Here is everything I have that is (I think) related to updating a field. Maybe you can see where I have gone wrong.

List GUID and Field I want to update names ----> List=%7BFAB4BBFC%2D0EAC%2D4BBF%2D87D7%2D1BC8BFFEF76E%7D&Field=Virtualized%5Fx003f%5F

CAML that I have

<?xml version="1.0" encoding="UTF-8"?>
<Batch OnError="Continue">
    <Method ID="1" Cmd="Update">
        <Field Name='Virtualized_x003f_'></Field>
    </Method>
</Batch>

When I change the drop down box for server name these are the rules that apply

@ID is the Method ID under the caml Datasource I believe I have it changing to the row ID of the Server List where the server name selected matches the server name in the list. I also set the Virtualized (check box @name in CAML) field to match what the server list already has for that field for that server.

This shows the form and the checkbox that associates with the Name field on the CAML datasource

Shows the Submit Options

Submit rules to submit both main form data and web service submit

Showing my data sources

Web Service Submit datasource details

The field ListName and its default value of the Regional Servers GUID list at the top of this post.

Maybe this will help someone see where I have gone wrong. I am not in a position that can buy additional software for this. Thanks for the help, it is much appriciated! Also if I have left any key info out, please let me know!