I am using the SubmitToSharePoint command to submit a form to a form library and repeating table data to a list. The form has an attachment field and I am using the add attachment WS and the qruleslink and qrulesfilename functions to strip the attachment, add it to the savings list and put the attchment link in the form. Everything is working fine except when I click on the qruleslink or the qrulesfilename in the form, the attachment opens as read-only and cannot be saved back to the list. The Save As link is pointing back to the item id but does not save it back to the item.
https://server/teams/lean/tracker/Lists/Savings/Attachments/297
If I open the item in the list, click the attachment link in the list item, the Excel file opens, I can edit it and then save it back to the list.
I do no have the link or filename in a section to ensure the section is not preventing me from editing. Is there something that I have missed to allow me to open the attachment from the link, edit and save it back to the list? I double checked the walkthrough and it looks like I did everything correctly.
I am using Excel 2010 and Office 365, I have full admin access to SP.
When I click on save I get the error: The file https://server/teams/lean/tracker/Lists/Savings/Attachments/297 is read-only. To save a copy, click OK, then give the workbook a new name in the save as dialog box.
Here is my mapping file:
<myFields lang="en-us">
<Mappings mappingName="Savings">
<ListCollection useName="false" ListName="Savings">{C1339C88-7419-425B-ABB4-D1238EC1C294}</ListCollection>
<IsRepeating>true</IsRepeating>
<RepeatingGroup>my:myFields/my:Savings/my:group2</RepeatingGroup>
<Relationships>
<RelatedList />
<RelatedListId />
</Relationships>
<Mapping>
<FormField IsRichText="false" IsId="true" IsAttachment="false">my:ID</FormField>
<SharePointColumn />
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVMTH</FormField>
<SharePointColumn>Saving_x0020_Month</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVYEAR</FormField>
<SharePointColumn>Saving_x0020_Year</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVAMT</FormField>
<SharePointColumn>Saving_x0020_Amount</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVTYPE</FormField>
<SharePointColumn>Savings_x0020_Type</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVDOCID</FormField>
<SharePointColumn>SaveID</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVTITLE</FormField>
<SharePointColumn>Title</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SavDivision</FormField>
<SharePointColumn>Sav_x0020_Division</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="false">my:SAVALL_TOT</FormField>
<SharePointColumn>SAVING_TOTAL</SharePointColumn>
</Mapping>
<Mapping>
<FormField IsRichText="false" IsId="false" IsAttachment="true">/my:myFields/my:Files</FormField>
<SharePointColumn />
</Mapping>
<Batch OnError="Continue">
<Method ID="1" Cmd="New">
<Field Name="Saving_x0020_Month" />
<Field Name="Saving_x0020_Year" />
<Field Name="Saving_x0020_Amount" />
<Field Name="Savings_x0020_Type" />
<Field Name="SaveID" />
<Field Name="Title" />
<Field Name="Sav_x0020_Division" />
<Field Name="SAVING_TOTAL" />
</Method>
</Batch>
</Mappings>
<SharePointListURL>https://server/teams/lean/tracker</SharePointListURL>
</myFields>