General

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Fri, 26 Jun 2015 14:05:32 GMT

Hilary, Would you happen to know what would cause a form to submit to the form library but not to the list when there is no error by chance? Figured it out, had a typo in the XML.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Thu, 25 Jun 2015 15:03:35 GMT

That worked! my title still doesn't carry over, but its not nearly as important as the ID field. Thanks again Hilary for your help and support! really appreciate it. I'm still going to tinker and make some changes but I'm well on my way now!! :D Few issues I'm running into... If i open the form and make a change and hit submit again it repeats the same items in the list again, is there a way to just have it update the items when the form is submitted again so it doesn't duplicate the documents? I ended up getting the title to pull the name so that's working (list items are named the same thing as the form they are associated with. the only other issue I'm having, is that when i submit one form it makes the name "Requisition Form -" as the second part is suppose to be "Requisition Form - REQNumber (which is pulling the ID field) is it not possible to keep it that way? because if I go to submit a new form, the blank one just gets overwritten. If i set a workflow to run when a form is submitted, to delete the form without the full name would that be "too slow" if multiple people were to fill these out at a time? that would take care for the name not showing correctly and having it update that instead of creating a new form...

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Thu, 25 Jun 2015 14:44:46 GMT

Hi - set it to the ID field in the data fields folder instead. Query fields are how we tell the data connection what we want - data fields are where the returned data is. When in doubt, drag the data connection onto the form, add a button that executes the query, preview the form and experiment. :)

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Thu, 25 Jun 2015 14:30:05 GMT

Replying to my own post as im not sure why the format is like that and it makes my and im sure your eyes hurt. I ended up having to re-point the Copyfield values to themselves and now the data copies to the list. The only issue now is that my GET ID and title rules aren't working I will continue to tinker but my rules are attached does anyone see why they aren't pulling the info over? After I submit I query the form library, then try to set the form field (REQNumber) to the Query ID field on the form lib is that not correct?

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Wed, 24 Jun 2015 21:13:04 GMT

I don't think it's my XML file, I disabled my rule that sets my field values along with the new and update as you suggested and the form uploads without errors, but still nothing as far as the list is concerned. I forced the CopyTitle to sue the formName field so it would name it the same... So what I did was I set the title field to use the formName for the value, and i submit to the form library with no error (this is without the submit to webservice rule after the copytitle) Once I add that next rule step "submit to webservice" that's when that error comes back, so it's got to me something on the server that's causing the issue, possibly the certificate. ill attempt to reset the IIS in about an hour or so. Took old cert out the trust put new one in and rebooted IIS services, still no luck :( still tinkering i refuse to give up! **UPDATE** - Still working on the issue but found an error in the eventlog. Added my new certs (got new error so... progress i hope hah) Type: DataAdapterException, Exception Message: The remote server returned an error: (500) Internal Server Error. Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Cannot access a closed Stream. The remote server returned an error: (500) Internal Server Error.) Ok, So I found this information which is the error message im getting: "Cannot Access A Closed Stream" number 4 would apply to me but it's not empty... do I have to have the { } or no brackets? or does it matter. 3.1.4.31 UpdateListItems SharePoint The UpdateListItems operation is used to make inserts, updates, and deletions to specified list items in a list. The protocol client sends an UpdateListItemsSoapIn request message (section 3.1.4.31.1.1) and the protocol server responds with an UpdateListItemsSoapOut response message (section 3.1.4.31.1.2), as follows: 1.If the specified listName is a valid GUID and corresponds to the identification of a list on the site, use that list. 2.If the specified listName is not a valid GUID or does not correspond to the identification of a list on the site, check if the listName corresponds to the list title of a list on the site and if so, use that list. 3.If listName does not correspond to a list from either of these checks, the protocol server SHOULD return a SOAP fault with error code 0x82000006. This indicates that the list does not exist or might have been deleted by another user. 4.If listName is an empty string, the server SHOULD return the SOAP fault: "Cannot access a closed Stream". 5.Otherwise, the protocol server MUST process the batched operations on the list, and return success or failure conditions per each operation. No really sure why my text is not being formatted like yours... sorry about that.. I figured out the submission to the list issue though. for my XML file I was using when i needed to use (it submits to the list now, but now my data isn't showing up, just items in the list which say (no title) for the title and no other info is carrying over. will tinker with it some more.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Wed, 24 Jun 2015 20:54:48 GMT

Try something like this for your Add List Items test XML file:

<Batch OnError="Continue">
<Method ID="1" Cmd="New">
<FieldRef Name="Title" CopyTitle="" />
</Method>
</Batch>

And disable your rules that set Cmd to new or update, disable your rule that sets the field values and then just add a rule to set "copy title" - so you can test.

Or, drag the secondary data source for Add List Items onto your form so you can try manually setting values and submitting (add a button with a rule to submit to the lists web service). Then you can experiment to see what works.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Wed, 24 Jun 2015 20:07:27 GMT

Thanks for your help an patients Hilary im still learning, and new to SharePoint development and infopath. I changed the name formula and got rid of the username and now and replaced those two items with REQNumber (even though its not pulling the ID as my REQNumber (yet) but now, it is submitting only once! so I'm getting there! Still getting the error: You do not have permissions to access a Web service that provides data required for this form to function correctly. Correlation ID:43c6e8a0-0ebf-4a01-9f97-4471efd735f6 I'm going to try to see why by doing a few searches. ***UPDATE*** Ok, so looking into it more it appears since i have SSL enabled on my site it could be a certificate issue. Im going to attempt to reset the IIS services after i attach the up to date cert in the trusted root authority. (cant do it now since its the production server) but will let you know what happens tonight.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Wed, 24 Jun 2015 19:31:22 GMT

In the data connection, select the form name field in your form for the form name.

Do not use a default value for the form name.

Instead, add a form load rule with the condition IF FORM NAME IS BLANK to set the form name.

Do you understand why you are currently getting multiple files in the library? Your rule submits the form 2 times, which is fine - but the first time "now()" is one value and the next time it is a whole different value.... leading the form not being able to overwrite as there is nothing in the library with the same name.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Wed, 24 Jun 2015 19:08:11 GMT

The formName has translate(concat("Requisition Form - ", userName(), " - ", now()), " :", "") as the default value but i also have the same fx in the form name when i created the data connection should i just point that to the formName field? Update after pointing to the formName it only submitted once, but put the formula as the "name" will try to put it back in the connection but take it out of formname as the default value.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Wed, 24 Jun 2015 18:19:18 GMT

Referring back to just the library submit and the two copies, did you also change your logic for creating the form name? As long as you have a formula including username and now as part of the form name, the form name will change every time you submit. Use a form field for the form name and set the value only one time instead.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Wed, 24 Jun 2015 18:14:41 GMT

Hilary, The list has standard columns (created from within SharePoint) so nothing special there. I am able to access the lists.asmx web server in the browser. (currently nothing is getting added to the list only the form library.) Will attempt to change the "Add List Item test XML". As far as the "allow overwrite if file exists" being deselected i edited and added it, but yet I'm still getting two copies. I even went as far as going into the List and making the title a non required field with no luck still :(

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Wed, 24 Jun 2015 17:54:40 GMT

Oh. I see why your form submits twice. Because you have it submitting twice in the rules. In your library submit connection you have "allow overwrite if file exists" deselected - you'll want that selected. Your form name uses "now()" in it, so it is going to change every submit. I generally add a field to the form for FormName and have a form load rule that, if the field is blank, sets the value. That way the form name is stable for the life of the form.

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Wed, 24 Jun 2015 17:49:30 GMT

You may also want to try just setting the title to start with - so modify your Add List Item test XML file to only have the title field, don't attempt any updates, but see if you can get your submit to the lists web service to just add a new item with the title populated.... Any required fields in your list? Any "choice" or "lookup" columns?

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

Hilary Stoupa — Wed, 24 Jun 2015 17:47:39 GMT

When you say the new form submits once, what do you mean? Your new form only submits to the library one time? Or does this form also submit to the library two times?

Are you able to access the lists.asmx web service in the browser?

Is the listItemID field being populated, currently? That is, are you failing when you try to add new items to your list, or when you try to add existing items?

Re: "InfoPath Dashboard - Displaying Repeating Data in Libraries -- February 28, 2013 Webinar" .XSN?

spassler — Wed, 24 Jun 2015 17:30:03 GMT

Thanks Hilary. I tried with the new form i created (attached). and it submits once. I cant get it to pull the ID value in the REQNumber field, but that might be because of the error im getting (still not pushing to the list) Error from when in sharepoint: You do not have permissions to access a Web service that provides data required for this form to function correctly. Correlation ID:bbf4ee5f-679f-47cc-96a0-750c90156bc2 -------------------------------------------------------------------------------- You do not have permissions to access a Web service that provides data required for this form to function correctly. Correlation ID:bbf4ee5f-679f-47cc-96a0-750c90156bc2 Error from when previewing and submitting: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Cannot access a closed Stream. Grr spoke too soon still submitting twice. ...continuing to tinker.