Qdabra qRules

Qrules Injected form Error after Sharepoint patching

Rommel Sta. Juana — Mon, 24 Jun 2024 15:56:50 GMT

Hi, We had encountered the below the attached error for all our Qrules injected form after we had patch our SharePoint 2016 farm with the July 2023 update. Hope that someone can assist us. "DeserializeVersion1 failed with unhandled exception Microsoft.Office.Server.Security.SafeSerialization+BlockedTypeException: SafeSerialization[Context=EnhancedBinaryReader Deserialization]: type System.Collections.Generic.List`1[[System.Collections.Generic.KeyValuePair`2[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] not allowed. at Microsoft.Office.Server.Security.SafeSerialization.ValidatingSerializationBinder.ResolveAndValidateType(TypeName typeName, Type type) at Microsoft.Office.Server.Security.SafeSerialization.ValidatingSerializationBinder.BindToType(String assemblyName, String typeName) at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Bind(String assemblyString, String typeString) at System.Runtime.Serialization.Formatters.Binary.ObjectReader.GetType(BinaryAssemblyInfo assemblyInfo, String name) at System.Runtime.Serialization.Formatters.Binary.ObjectMap..ctor(String objectName, String[] memberNames, BinaryTypeEnum[] binaryTypeEnumA, Object[] typeInformationA, Int32[] memberAssemIds, ObjectReader objectReader, Int32 objectId, BinaryAssemblyInfo assemblyInfo, SizedArray assemIdToAssemblyTable) at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.ReadObjectWithMapTyped(BinaryObjectWithMapTyped record) at System.Runtime.Serialization.Formatters.Binary.__BinaryParser.Run() at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage) at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage) at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream) at Microsoft.Office.InfoPath.Server.Serialization.EnhancedBinaryReader.ReadSerializable() at Microsoft.Office.InfoPath.Server.DocumentLifetime.DocumentSessionState.<>c__DisplayClassc.b__8() at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) StackTrace: at Microsoft.Office.Server.Native.dll: (sig=0ccf5f82-afdd-4b7d-81a3-2161e9ff0209|2|microsoft.office.server.native.pdb, offset=28719) at Microsoft.Office.Server.Native.dll: (offset=2EAF6)"

qRule - finishedLoading

dapklp — Tue, 04 May 2021 13:36:53 GMT

In InfoPath, a new load rule starts with the default condition "None - Rule runs when form is opened" - Injecting qRules and copying the load rules to FinishedLoading , the condition remained the same, but I don't know what would make this field change. I viewed some early qRules UTube videos and I noticed that the rule in some were finishedLoading = TRUE. Is this what I need to change all of my copied rules to if I want them to automatically trigger?

An unexpected FileNotFound failure occurred loading assembly: Could not load file or assembly

David Alvarado — Mon, 20 Jul 2020 22:31:19 GMT

I just updated a browser enabled form to change a few dates and button labels and after publishing it back to the SharePoint Library (not the quick publish option) and uploading the template in Central Admin, the form has stopped working. The correlation id gives the following error. An unexpected FileNotFound failure occurred loading assembly: Could not load file or assembly 'file:///C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Template\Features\FT-01-74453b72-971a-819d-0676-e4d79c3ae732\Qdabra.Tools.RulesLibrary.Browser2013Admin.dll' or one of its dependencies. The system cannot find the file specified. Can you please tell me where I can grab the Qdabra.Tools.RulesLibrary.Browser2013Admin.dll so that I can place it in the correct folder on the server? Thank you!

Unable to save attachment via SubmitToSharePointList command

Arthur.Avanesyan — Thu, 16 Apr 2020 17:23:34 GMT

We are using SharePoint 2016 on premises and FormsViewer. SubmitToSharePointList command successfully creates and updates list items, but we have problem when trying to add attachment to the same list.

Here is the command used: SubmitToSharePointList /submit=ShPList /mapping=FilmAttachment /dsname=AddAttachment
All parameters and are correct. The corresponding list item is updated by this command, as I can see a new version added in version history without any change.

Attachment field of that list item stays blank.

qRules SaveToSharePoint Help (file name)

explosive0 — Tue, 19 Nov 2013 15:55:35 GMT

I've installed a trial version of qRules and have the SaveToSharePoint command working. When the file is saved to the SharePoint library, it prepends the date, time and an underscore to the file name. I do not want this; I want just the file name as it is attached. Is there a way of achieving this? Thanks

Can "SaveToSharePoint" or "SubmitToSharePointList" be used to save attachments on SP Online

sharepointing.and.lost — Thu, 14 Nov 2019 22:30:39 GMT

Hi! I'm wondering if it's possible to use said qRules to save attachments into SharePoint Online? I tried creating this but got the following errors:

SaveToSharePoint:
Action: SaveToSharePoint. Arguments: url: https://site/qdabratospodoclib xpath: /my:myFields/my:group1/my:group2/my:AttachFile name: .
Details: The Web application at https://site/qdabratospodoclib/2019111506274409709_samplefile0.pdf could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.. Stack: at Microsoft.SharePoint.SPSite.LookupSiteInfo(SPFarm farm, Boolean contextSite, Boolean swapSchemeForPathBasedSites, Uri& requestUri, Boolean& lookupRequiredContext, Guid& applicationId, Guid& contentDatabaseId, Guid& siteId, Guid& siteSubscriptionId, SPUrlZone& zone, String& serverRelativeUrl, Boolean& hostHeaderIsSiteName, Boolean& appWebRequest, String& appHostHeaderRedirectDomain, String& appSiteDomainPrefix, String& subscriptionName, String& appSiteDomainId, Uri& primaryUri)
at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, Boolean swapSchemeForPathBasedSites, SPUserToken userToken)
at Microsoft.SharePoint.SPSite..ctor(String requestUrl)
at Qdabra.Tools.RulesLibrary.Commands.SaveFileToSharepoint_Browser(String& base64Value, String& fileUrl, XPathNavigator fileNode, String requestedFileName, String fileNameXPath, String overwriteExisting, Boolean preserveName)
at Qdabra.Tools.RulesLibrary.Commands.SaveToSharePoint_Browser(String url, String domName, String nodeXPath, String fileName, String fileNameXPath, String overwriteExisting, String copyServiceName, String copyServiceUrl, Boolean clear, Boolean preserveName)
at Qdabra.Tools.RulesLibrary.Commands.SaveToSharePoint()
at Qdabra.Tools.RulesLibrary.Commands.RunCommand(String commandName)
at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

SubmitToSharePointList:
Error ocurred submitting data to list: The Web application at https://site/ could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

Trigger for Qrules Finished Loading

Deeayrian — Wed, 12 Jun 2019 20:15:01 GMT

I have a form that has been using qRules for a long time.
The form used to require custom code, so qRules was manually added to the form per your instructions and everything worked fine.
Recently we removed all of the custom code from the form and then re-injected qRules.
Almost all of the qRrules functionality works, except for passing along parameters to a new form and grabbing those parameters with the GetInputParameter command

The GetInputParameter commands are all set on the QRules FinishedLoading field and are set to run only if QRules FinishedLoading is true.
While Troubleshooting, I am finding that the FinishedLoading field isn't always set to true automatically. Can you help me understand when FinishedLoading is set to true automatically?

To test it further, I copied the URL with parameters and pasted it into the browser. The form opens but doesn't mark FinishedLoading to true so the parameters are never loaded.
However, if I remove 80% of the parameters from the URL and enter it much shorter, it works. The FinishedLoading is marked true and the parameters are loaded.

But I need all of the parameters passed and I have been able to do this for years up until the recent re-injection of Qrules into the form. Does the newer version of Qrules that I injected behave differently than older version when it comes to this?

We have Urgent Customer orders that need to be created and linked to the original form, but we aren't able to do so due to this issue so your prompt response is greatly appreciated.

Thank you much!

SharePoint 2013 Forms Library

JohnSM — Fri, 03 May 2019 12:50:16 GMT

I am using InfoPath 2013 to customize SP List forms. I am interested in qRules and need to know if these Lists forms need to be published to a Form Library in order for qRules to work?

I've read how you need to create a InfoPath form template before publishing to a Forms Library, but the forms I have are already created.

Thanks,
John

Sorting GetTermSets

zanne — Wed, 19 Sep 2018 14:06:04 GMT

I have reviewed the document Define Termsets and use qRules to load them into your form.pdf. I followed the instructions and in my DEV environment the terms were sorted properly. In my QA environment they were not sorting properly. So I tried the transform and sort commands that Hilary had helped me with on another form. Now the dropdown is blank. I'm thinking it is probably due to the Termsets.xslt file.

Any help is appreciated.

Delete row from a repeating table using QRules

Jeroen de Lang — Wed, 04 Jan 2012 12:47:32 GMT

I have searched the forums and the Internet, but somehow the answers eludes me. How can i make a Rule that only deletes the current row in a repeating table? I can delete a specific line number, but how to retrieve that?

The Form template has been published to the server but it can only be opened in the InFoPath Filler because it contains Features that are not compatible with Web browsers

blphu — Tue, 26 Jan 2016 17:37:47 GMT

Hello everyone,

I know this has been posted before and I looked at some of the solutions suggested in this forum. However, I am lost. I am on Office 365/SharePoint environment. I have tried all different Security and Trust settings on my form but nothing seems to work. Could someone please point me in the direction?

Thanks so much!

Multiple Repeating Tables to Save to SharePoint List(s)

zanne — Thu, 16 Aug 2018 15:29:47 GMT

My InfoPath form has multiple repeating tables that I want to save to separate sharepoint lists. Is this possible using Qdabra SaveToSharepointList? Can we have multiple Mapping files? What is the best way to accomplish what I need?

ExecuteSqlQuery Invalid command?

CCBSMF — Wed, 06 Jun 2018 17:25:27 GMT

Hi all. I am utilizing the QRules command ExecuteSqlQuery and it works great. But now its giving me some weird behavior? It says its an invalid command for only 2 rows of data that I'm inserting into sql. Obviously the command is good for the other 8 rows of repeating data. so I questioned the data itself, but when I take the SQL insert command to SSMS and run it. Works like a charm. I'm puzzled with this one. Can anyone please assist? Attached is the XML saved form and a screenshot. I posted this in another area and will remove it as it is best suited in the qRules forum.

SendEmail command and repeating groups

CCBSMF — Tue, 22 May 2018 21:41:56 GMT

Hey Gang. I want to send emails to a group of users from a repeating group. My question is, do I need to handle this at the RG level or can I do this command from the button itself and get them each an email? I was thinking of just having the button set a Boolean field within the repeating group, then have that field fire the command for the emails per row. Thoughts? Advice?

Saveto SharePoint multiple attachments error

CCBSMF — Tue, 15 May 2018 22:44:26 GMT

Hi All i have an InfoPath Filler form that has a section to allow the user to submit to a fileserver, multiple attachments. I've done this before on a couple of forms, some to sharepoint the others to the fileserver but each time they utilized the qRulesFilename for the naming convention. Works beautifully. Now I want to specify a filename, made sure it's datetime stamped and all, but only one of the files will actually succeed. The second or latter files always fails. I am using the namexpath switch and it is a relative path to the filename attribute. My Filename node is repeating and NOT in a repeating group but it in a container non repeating folder. Please HELP! I'm up against a wall and cannot meet my deadline if this piece isn't working. :( ** P.S. ** i forgot to mention if i remove the namexpath switch and let qRules name it, all files update perfectly.

Multiple Attachment controls to save in list using SubmitToSharePointList

Jhoanna — Thu, 19 Apr 2018 22:30:52 GMT

Hello,

Hope you can assist me with this question, how is it possible to save attachments in a list item. To consider also that the second control is in a repeating section

I tried but it only extracted & saved the first attachment, is it because of the mapping or attachment control in the list?

Hope this is not a limitation, thank you!

Copy to SharePointList in a repeating section using QRule

Jhoanna — Sun, 14 Jan 2018 08:20:28 GMT

Hello,

can we use the Copy to SharePointList with validation? Example it will only write/update to the list if the status is Submitted

Thanks

Error loading form code assembly

Arthur.Avanesyan — Fri, 02 Feb 2018 08:56:50 GMT

When I try to upload InfoPath form templates to SharePoint 2016 server, I receive the following error: Error loading form code assembly: Could not load file or assembly 'Microsoft.Office.InfoPath, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. Location: Qdabra.Tools.RulesLibrary.dll These forms are successfully uploading to SharePoint 2013 server.

SubmitToSharePointList command not mapping all records by ID

GwenW — Wed, 07 Feb 2018 19:57:49 GMT

I'm not sure what the culprit is, but my map is only writing one record, instead of all the records in the bundle. It's not an error (it's a success in the qRules history).

In on map (with repeating group thing set up) I actually think it's overwriting the first record ID with all the records because the data from the last record now appears in the ID for the first record (lowest ID number). So, I think there is something wrong with my ID hookup... In the map that I tried without the repeating group thing set (so the fields are the full path in the map), it seems like it's only writing the first record in the bundle (no overriding data for the wrong ID).

Here is my submit command: SubmitToSharePointList /submit=Submit /mapping=mapping_EditModel_Split1 /id=/my:myFields/my:sec_ModelEdits_A/my:sec_ModelEdits_Submit_A/my:subMod_ID (I haven't ever had to put the full path with the ID before either (not sure why I am now), but when I just put the field, I get an error.)

The only thing really different from anything I've done before is I'm using check boxes in which I read data from the list, the user edits it and then I push back (the only other time I've used checkboxes, I only captured data and pushed to the list). So, maybe it's something with checkboxes?

At first, I had checkboxes in the form, but my list columns were text. So, I created different columns to use and made them Yes/No (thinking this would help), but I still get the same issue.

Any help is greatly appreciated. My brain has hurt for days trying to figure it out. LOL

SharePoint 2010/InfoPath 2010/qRules 8.1

Qdabra InfoPath to SharePoint List Tool error: Error occurred in function GetListColumns()

GwenW — Tue, 30 Jan 2018 22:20:54 GMT

Hi, I'm using the Qdabra InfoPath to SharePoint List Tool and getting the error seen in the screenshot below. I can get it to work with some of the lists in the sites, then others I get this error. Thoughts? :)

SharePoint 2010/InfoPath 2010/qRules 8.1

Thanks!

Gwen

Failed to select the destination node

zanne — Thu, 25 Jan 2018 18:17:24 GMT

I am getting the error "Failed to select the destination node" on my form.

Here is the command I am using:

Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=append

Here is the error I'm getting:

Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=appendfalseFailed to select the destination node.Transform /sourceds=RepeatingTableData /destpath=/my:myFields/my:repeatingTable /xsltfile=LastWeeksData.xslt /excluderoot=true /placement=appendfalseFailed to select the destination node.

I looked at the LastWeeksData.xslt file and the xsl looks correct to me. I confirmed the names of the fields in both the form and the secondary list.

Here is the XSLT:

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"
    xmlns:d="http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields"
    xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2016-03-14T16:40:08"

>

<xsl:template match="/">
<my:repeatingTable>
  <xsl:apply-templates select="/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:FormID !='']"/>
</my:repeatingTable>
</xsl:template>

<xsl:template match="d:SharePointListItem_RW">
<my:rtColumns>
  <my:matterNumber>
   <xsl:value-of select="d:ClientMatterNumber"/>
  </my:matterNumber>
  <my:clientName>
   <xsl:value-of select="d:ClientMatterName"/>
  </my:clientName>
  <my:description>
   <xsl:value-of select="d:Description"/>
  </my:description>
  <my:partner>
   <xsl:value-of select="d:Partner"/>
  </my:partner>
  <my:comments>
   <xsl:value-of select="d:Comments"/>
  </my:comments>
  <my:ST>
   <xsl:value-of select="d:ST"/>
  </my:ST>
  <my:LT>
   <xsl:value-of select="d:LT"/>
  </my:LT>
  <my:thisMonth>
   <xsl:value-of select="d:ThisMonth"/>
  </my:thisMonth>
  <my:RowID>
   <xsl:value-of select="d:ID"/>
  </my:RowID>
  <my:FormName>
   <xsl:value-of select="d:FormName"/>
  </my:FormName>

</my:rtColumns>
</xsl:template>

</xsl:stylesheet>

Here is the repeating table node

Here is the source list:

FormatDate sometimes returns dd/MM instead of MM/dd

Deeayrian — Mon, 16 Oct 2017 23:09:00 GMT

Hello,

We have a form that has input done by people in Mexico and in the US. Because of this I had to change the formatting on the date picker field in the field's properties to 3/14/2001 without the * because if you use the * it will pull up whatever date settings are on that user's computer. We want the date to always show as MM/dd/yyyy.

On the date picker field, I have a rule set that when it changes, it sets a different field called "custDateFormatted" and I have the code set to perform this action: concat("FormatDate /date=", ., " /format=MM/dd/yyyy")

This works fine 90% of the time. However, sometimes when the user enters a date, such as 8/2/2017 in the date picker field, it shows up as 8/2/2017 in that date field, but the qRules code above translates it as 02/08/2017 in the custDateFormatted field.
This happens even when the person is using an US computer. That same person can enter the date on many other forms in the same system and it gets entered correctly, but sometimes it shows up wrong.
In addition, this is happening to many different people, sporadically.
The problem is that the dates being entered are customer due dates. So if the due date is actually August 2nd but it wrongfully shows up as Feb 8th, then obviously we will miss our customer due date, so this is a huge issue.

Do you have any idea why this would be happening so sporadically? Is there any other ways I an force the date to always translate as MM/dd/yyyy?

Thank you in advance.

SubmitToSharePoint List failing if one field is blank

ShaneHarvy — Mon, 07 Aug 2017 18:45:06 GMT

Hello, I have a form that is submitting to a list where some of the linked fields will submit every time and some may not. As I am using the qRules SubmitToSharePoint List command, I am finding that it works if every field is submitted, but the command will fail if one of the fields is blank. Is this expected behavior? I could have sworn that in a previous form, blank submit to a field in a list was supported. Thank you as always for your help!

Setting the value of a field in repeating table after Insert

ShaneHarvy — Fri, 21 Jul 2017 13:09:47 GMT

I have created a rule that triggers Insert to create a new instance of a repeating table. After this function, I am trying to use GenerateGuid to create a GUID and then I want to put that guid in a field in the row I just created. I am assuming I should use SetValue, but I am having trouble getting the syntax to find the node I just created to set the value to. Any help would be appreciated!

SendEmail issue with /View and /body or /intro

CCBSMF — Tue, 01 Aug 2017 22:36:22 GMT

Hey Everyone. I have a small issue with the SendEmail command. It seems that you cant specify /intro and/or /body if you use /view. The view seems to take precedence and you don't see the intro or the body text once the email comes across. Something I'm missing or maybe doing wrong?