to simplify it for me, i redid the check-in/check-out as a template part. Meaning creating it by itself and being able to add it into future forms as a custom control . my thinking now, is since i am going to use this in more than just this form, i can make it a custom control. I took out the previous check-in/check-out part and added the control according to the instructions of the pdf.
I did a preview. Again, the initial error returned.... just a little different this time:
The query cannot be run for the following DataObject: CheckOutFile_TemplatePart1
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:
Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
<detail><errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">Invalid URI: The format of the URI could not be determined.</errorstring></detail>
My question are this
1.) I did use the file picker for setup of the pageUR which also calls for you to verify the formula which i did. I also followed your instructions and setup the FormName to be the concatenation of the actual forms submit.
concat(substring-before(substring-after(processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), 'Forms/template.xsn"'), concat(EventNames, "-", DateSubmitted), ".xml")
I verified it as stated in the form and it is good. (the EventNames and DateSubmitted) are file picked. When i clicked the Edit XPath, the actual XPath is there so i know this is right.....
I think now i am as close as ever, outside of the error.