Qdabra qRules

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 23:28:03 GMT

Understood. Yes you are right I changed my xml mapping because I wanted to add the new field (etching). I must have chossen a different repeating group path when I remapped. I changed it back and all is well

Thanks again for your help. Thank godness you are an infopath God!

Re: Error with My Submit to sharepointlist Command

Hilary Stoupa — Tue, 13 Mar 2012 21:30:39 GMT

Did you change your mapping? The mapping file no longer points to a repeating group, thus the ID parameter would have to be the full path to the ID node instead of a relative path. Your current mapping file has "my:myFields" for the repeating group - your previous mapping file had my:myFields/my:Items/my:Item

Here's the mapping file you are currently using:

<my:Mappings>
    <my:IsRepeating>true</my:IsRepeating>
    <my:RepeatingGroup>my:myFields</my:RepeatingGroup>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:serial</my:FormField>
      <my:SharePointColumn>Title</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:partno</my:FormField>
      <my:SharePointColumn>partnumber</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:customerinfoline1</my:FormField>
      <my:SharePointColumn>cusinfo1</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:customerinfoline2</my:FormField>
      <my:SharePointColumn>cusinfo2</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:datemfg</my:FormField>
      <my:SharePointColumn>datemfg</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:hoselot</my:FormField>
      <my:SharePointColumn>hoselot</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:fitting1</my:FormField>
      <my:SharePointColumn>heat1</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:fitting2</my:FormField>
      <my:SharePointColumn>heat2</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:sonumber</my:FormField>
      <my:SharePointColumn>sonumber</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:ReviewStatus</my:FormField>
      <my:SharePointColumn>ReviewStatus</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Items/my:Item/my:Etching</my:FormField>
      <my:SharePointColumn>Etching</my:SharePointColumn>
    </my:Mapping>
</my:Mappings>

Here's the one you were using before:

<my:Mappings>
    <my:IsRepeating>true</my:IsRepeating>
    <my:RepeatingGroup>my:myFields/my:Items/my:Item</my:RepeatingGroup>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:serial</my:FormField>
      <my:SharePointColumn>Title</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:partno</my:FormField>
      <my:SharePointColumn>partnumber</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:customerinfoline1</my:FormField>
      <my:SharePointColumn>cusinfo1</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:customerinfoline1</my:FormField>
      <my:SharePointColumn>cusinfo2</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:datemfg</my:FormField>
      <my:SharePointColumn>datemfg</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:hoselot</my:FormField>
      <my:SharePointColumn>hoselot</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:fitting1</my:FormField>
      <my:SharePointColumn>heat1</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:fitting2</my:FormField>
      <my:SharePointColumn>heat2</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:sonumber</my:FormField>
      <my:SharePointColumn>sonumber</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:ReviewStatus</my:FormField>
      <my:SharePointColumn>ReviewStatus</my:SharePointColumn>
    </my:Mapping>
    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Etching</my:FormField>
      <my:SharePointColumn>Etching</my:SharePointColumn>
    </my:Mapping>
</my:Mappings>

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 21:15:16 GMT

Yea i tried to File save in xml after i copy table . did get an error

I also added the ID field to my main repeating table to make sure its getting copied over. And it seems fine.

Re: Error with My Submit to sharepointlist Command

Hilary Stoupa — Tue, 13 Mar 2012 21:03:00 GMT

Can you use File / Save As to save an XML file after your copy table command runs and check the XML for the ID node (or attach it here so I can)? Do all your "Etching" fields in SharePoint have values? I'm wondering if Copy Table is sometimes removing your main data source ID field.

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 20:47:35 GMT

Nope did not touch that command All I did to my ID field was move etching above it. I am using perview right now to work out errors before i post..

Re: Error with My Submit to sharepointlist Command

Hilary Stoupa — Tue, 13 Mar 2012 20:04:47 GMT

Did your command change at all? You didn't rename the ID field or anything, did you? Post your latest template, I'll take another look.

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 19:58:54 GMT

Sorry here is the error when i submit to sharepoint list

Failed to select node for SharePoint List Id

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 19:26:54 GMT

Ok so I moved the etching field up in the main to match the secondary Now they are in the right spot and the copy table command looks like its working fine . But of course i get another error when i try and sync to list now.

\Invalid command specified:

Re: Error with My Submit to sharepointlist Command

Hilary Stoupa — Tue, 13 Mar 2012 19:23:40 GMT

It doesn't look right to me. When I look at your secondary data source called Clearmarkinfo, you have Etching then ID. When I look at your main data source, the node order is ID then Etching. Like I said, Copy Table just copies one to one - first node from source to first node in destination. Thus, Etching from the 2ds is copied into Id in the main ds. ID from the 2ds is copied to Etching in the main ds. Not sure what orders the columns in the 2ds - probably the column order in the default view. In the main ds, you can right click a node and move it up or down. Move ID down in the main data source (as long as your form is not in production - don't go moving nodes around if you've already got XML filled out).

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 19:13:11 GMT

it looks right on my SDS. How do i change the order?

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 19:07:15 GMT

concat("CopyTable /dsnamesrc=Clearmarkinfo /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=ns1:SharePointListItem_RW[ns1:sonumber='", ., "'] /tabledest=/my:myFields/my:Items /rowdest=my:Item /empty=yes")

I dint see how this copy table command could be wrong but it seems to be putting the id number in the etching field do i have to re do a data connection or something?

Re: Error with My Submit to sharepointlist Command

Hilary Stoupa — Tue, 13 Mar 2012 19:06:59 GMT

Copy table doesn't have any mapping or anything - so the first field in the source gets copied to the first field in the destination. The second field in the source gets copied to the second field in the destination. Your data source you are copying from has Etching then ID. Your main data source has ID then Etching. Thus, ID is getting copied into your Etching field, I'd imagine.

While you are working through this, I'd display the secondary data on the form, and make sure my main data source values are all displayed as well (Etching, with its radio button control, is not showing its value to you).

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 18:39:22 GMT

rule is under sales order picker called copy table

Re: Error with My Submit to sharepointlist Command

Hilary Stoupa — Tue, 13 Mar 2012 18:35:53 GMT

Your mapping is right:

    <my:Mapping>
      <my:FormField my:IsRichText="false">my:Etching</my:FormField>
      <my:SharePointColumn>Etching</my:SharePointColumn>
    </my:Mapping>

What is your "concat copy table"? Where would I find that?

Re: Error with My Submit to sharepointlist Command

Glebron — Tue, 13 Mar 2012 18:11:46 GMT

Ahh I think I found the issue.. I changed the Yes/no to text and its bringing my Id into my etching field and vice versa. I checked my mapping's and they seem to be linked right. Could my concat copy table be right? Dose it have to be in the right order?