Re: SubmitToSharePointList not 'updating' list record

Hilary Stoupa — Tue, 18 Sep 2012 20:56:30 GMT

Well, you are the one who caught it- I hadn't even had time to look at your post yet. :-)

Glad it is resolved.

Re: SubmitToSharePointList not 'updating' list record

NICK1081 — Tue, 18 Sep 2012 20:17:36 GMT

that was it !

dadgumit.

now I'm embarrassed.

Good catch ! That's why you make the big bucks !

:-)

Re: SubmitToSharePointList not 'updating' list record

NICK1081 — Tue, 18 Sep 2012 20:04:57 GMT

son of a gun... I've got Title in there twice.

Could it be... ?

checking it now.

So, if this is it? Do I need to remove the current mapping resource and delete the mapping data connection ?

Re: SubmitToSharePointList not 'updating' list record

NICK1081 — Tue, 18 Sep 2012 19:30:51 GMT

absolutely.

I hope that's not where I screwed up. That would be embarrassing. Typical, for me, but still embarrassing.

<?xml version="1.0" encoding="utf-16"?>
<myFields lang="en-us">
<Mappings mappingName="ICM LIST">
    <ListCollection useName="false" ListName="ICM LIST">{D6764E13-1C0B-42B7-834F-94918228120D}</ListCollection>
    <IsRepeating>false</IsRepeating>
    <RepeatingGroup />
    <Relationships>
      <RelatedList />
      <RelatedListId />
    </Relationships>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:HiddenData/my:autonumber</FormField>
      <SharePointColumn>Title</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:ICM_NO</FormField>
      <SharePointColumn>ICMNO</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:ICM_Type</FormField>
      <SharePointColumn>ICMTYPE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:ICM_Date</FormField>
      <SharePointColumn>ICMDATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:Date_Reply_Req</FormField>
      <SharePointColumn>ICMDATEREPREQ</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:Closed_Date</FormField>
      <SharePointColumn>ICMCLOSEDDATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:Rev_Letter</FormField>
      <SharePointColumn>ICMREV</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Taxonomy/my:Rev_Date</FormField>
      <SharePointColumn>ICMREVDATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:TO_ORIGINATED_BY/my:TO</FormField>
      <SharePointColumn>ICMTO</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:TO_ORIGINATED_BY/my:ORIGINATED_BY</FormField>
      <SharePointColumn>ICMORIGIN</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Related_Data/my:ECP_PSCN</FormField>
      <SharePointColumn>ECP_PCSN</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Related_Data/my:JS_IPCD</FormField>
      <SharePointColumn>JS_IPCD</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Related_Data/my:CP</FormField>
      <SharePointColumn>CP</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="true" IsId="false" IsAttachment="false">my:myFields/my:Related_Data/my:SUBJECT</FormField>
      <SharePointColumn>SUBJECT</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="true" IsId="false" IsAttachment="false">my:myFields/my:Related_Data/my:REFERENCES</FormField>
      <SharePointColumn>REFERENCES</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="true" IsId="false" IsAttachment="false">my:myFields/my:Enclosures_Messages/my:ENCLOSURES_MESSAGE</FormField>
      <SharePointColumn>ENCLOSURES</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Author1</FormField>
      <SharePointColumn>AUTHOR1</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Author2</FormField>
      <SharePointColumn>AUTHOR2</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Author3</FormField>
      <SharePointColumn>AUTHOR3</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Author1_Date</FormField>
      <SharePointColumn>AUTHOR1DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Author2_Date</FormField>
      <SharePointColumn>AUTHOR2DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Author3_Date</FormField>
      <SharePointColumn>AUTHOR3DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:IC_TL1</FormField>
      <SharePointColumn>ICTIL1</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:IC_TL2</FormField>
      <SharePointColumn>ICTL2</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:IC_TL3</FormField>
      <SharePointColumn>ICTL3</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:IC_TL1_Date</FormField>
      <SharePointColumn>ICTL1DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:IC_TL2_Date</FormField>
      <SharePointColumn>ICTL2DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:IC_TL3_Date</FormField>
      <SharePointColumn>ICTL3DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Contracts_Procurement</FormField>
      <SharePointColumn>CONTRACTS1</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:Approvals/my:Cont_Proc_Date</FormField>
      <SharePointColumn>CONTRACTS1DATE</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:HiddenData/my:ICM_Source</FormField>
      <SharePointColumn>Source</SharePointColumn>
    </Mapping>
    <Mapping>
      <FormField IsRichText="false" IsId="false" IsAttachment="false">my:myFields/my:HiddenData/my:autonumber</FormField>
      <SharePointColumn>Title</SharePointColumn>
    </Mapping>
    <Batch OnError="Continue">
      <Method ID="1" Cmd="New">
        <Field Name="Title" />
        <Field Name="ICMNO" />
        <Field Name="ICMTYPE" />
        <Field Name="ICMDATE" />
        <Field Name="ICMDATEREPREQ" />
        <Field Name="ICMCLOSEDDATE" />
        <Field Name="ICMREV" />
        <Field Name="ICMREVDATE" />
        <Field Name="ICMTO" />
        <Field Name="ICMORIGIN" />
        <Field Name="ECP_PCSN" />
        <Field Name="JS_IPCD" />
        <Field Name="CP" />
        <Field Name="SUBJECT" />
        <Field Name="REFERENCES" />
        <Field Name="ENCLOSURES" />
        <Field Name="AUTHOR1" />
        <Field Name="AUTHOR2" />
        <Field Name="AUTHOR3" />
        <Field Name="AUTHOR1DATE" />
        <Field Name="AUTHOR2DATE" />
        <Field Name="AUTHOR3DATE" />
        <Field Name="ICTIL1" />
        <Field Name="ICTL2" />
        <Field Name="ICTL3" />
        <Field Name="ICTL1DATE" />
        <Field Name="ICTL2DATE" />
        <Field Name="ICTL3DATE" />
        <Field Name="CONTRACTS1" />
        <Field Name="CONTRACTS1DATE" />
        <Field Name="Source" />
        <Field Name="Title" />
      </Method>
    </Batch>
</Mappings>
<SharePointListURL>https://tcc1.xxx.com/eot/icm/icm/</SharePointListURL>
</myFields>

Re: SubmitToSharePointList not 'updating' list record

Hilary Stoupa — Tue, 18 Sep 2012 15:46:56 GMT

Can I see your mapping.xml, please?

Re: SubmitToSharePointList not 'updating' list record

NICK1081 — Tue, 18 Sep 2012 15:40:44 GMT

The id is getting in the xml - I have it displayed at the bottom of the form with other 'diagnostic' data... and I disabled the other rules in order to check exactly what you mentioned.

thanks.

Re: SubmitToSharePointList not 'updating' list record

Hilary Stoupa — Tue, 18 Sep 2012 15:21:19 GMT

Have you verified the ID field is getting populated in your XML? You aren't perhaps submitting your XML to the SharePoint library prior to running the SubmitToSharePointList command?

SubmitToSharePointList not 'updating' list record

NICK1081 — Tue, 18 Sep 2012 15:13:05 GMT

I'm having problems with the SubmitToSharePointList qRules command. When I create a new record in the forms library, it works great (see illustration).

However, when I update the forms record, the related List record is not updating. I get the error shown in the illustration.

I understand what the error is telling me about the existing list record, but I'm not sure how to fix it.

Help please.

Qdabra qRules

Re: SubmitToSharePointList not 'updating' list record

Re: SubmitToSharePointList not 'updating' list record

Re: SubmitToSharePointList not 'updating' list record

Re: SubmitToSharePointList not 'updating' list record

Re: SubmitToSharePointList not 'updating' list record

Re: SubmitToSharePointList not 'updating' list record

Re: SubmitToSharePointList not 'updating' list record

SubmitToSharePointList not 'updating' list record