Controls

Re: CopyRichText not removing HTML

Hilary Stoupa — Wed, 23 Mar 2016 18:10:45 GMT

Hey, this stuff has a learning curve - you are doing great & I'm glad you got it. :) Hope you can make the webinar next week - this thread has given me some good ideas for things to cover, so you have helped me as well.

Re: CopyRichText not removing HTML

Mariav — Wed, 23 Mar 2016 18:05:15 GMT

OMG Hilary, Please let me buy you a big basket of chocolates!!!! I did have to add a 'Query Receive_Forms' rule right before the QRules command line, but it finally worked!!!! And you had the patience of a Saint!!!!

Re: CopyRichText not removing HTML

Hilary Stoupa — Wed, 23 Mar 2016 17:18:01 GMT

I didn't see the missing single quote, thanks! It is hard to see, but you can see there is a single quote before the closing double quote after the = sign. We need one on either side. See how the error message returns the xpathsrc, and we have a single quote on one side of May 2016? Oh! and we are missing a closing bracket too!

concat("CopyRichText /dsnamesrc=Receive_Forms /xpathsrc=/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:OPS_x0020_Highlights[../d:Report_x0020_Period = '", ., "'] /xpathdest=/my:myFields/my:CC_Highlights")

concat("CopyRichText /dsnamesrc=Receive_Forms /xpathsrc=/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:OPS_x0020_Highlights[../d:Corp_x0020_Sales = 'CC' and ../d:Report_x0020_Period = '", ., "'] /xpathdest=/my:myFields/my:CC_Highlights")

Re: CopyRichText not removing HTML

Mariav — Wed, 23 Mar 2016 17:01:34 GMT

Thanks, I did sign up for the Webinar.

Both formulas came back with the same error below:

Action: CopyRichText. Arguments: dsnamesrc: Receive_Forms
xpathsrc: /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:OPS_x0020_Highlights[../d:Report_x0020_Period = 'May 2016
xpathdest: /my:myFields/my:CC_Highlights
. Details: This is an unclosed string.. Stack: at MS.Internal.Xml.XPath.XPathScanner.ScanString()
at MS.Internal.Xml.XPath.XPathScanner.NextLex()
at MS.Internal.Xml.XPath.XPathParser.ParseEqualityExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseAndExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseOrExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseExpresion(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParsePredicate(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseStep(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseLocationPath(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParsePathExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseUnionExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseMultiplicativeExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseAdditiveExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseRelationalExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseEqualityExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseAndExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseOrExpr(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseExpresion(AstNode qyInput)
at MS.Internal.Xml.XPath.XPathParser.ParseXPathExpresion(String xpathExpresion)
at System.Xml.XPath.XPathExpression.Compile(String xpath, IXmlNamespaceResolver nsResolver)
at System.Xml.XPath.XPathNavigator.SelectSingleNode(String xpath, IXmlNamespaceResolver resolver)
at Qdabra.Tools.RulesLibrary.Commands.GetValidNode(XPathNavigator start, String xpath, String errorMessage)
at Qdabra.Tools.RulesLibrary.Commands.CopyRichText()
at Qdabra.Tools.RulesLibrary.Commands.RunCommand(String commandName)
at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

Re: CopyRichText not removing HTML

Hilary Stoupa — Wed, 23 Mar 2016 15:11:30 GMT

Okay - for your latest form that was attached, I think the only issue you had was missing a space before the /xpathdest parameter.

Concat formulas must be entered in the formula editor. If you need the end string to have quotes in it, like surrounding text in an XPath filter, you can use single quotes.

You can always test your syntax by directly entering the string you hope to create from your concat formula into the command field and tabbing out (after putting that field on the form, of course) - and the Execution History shows you the command that was run, so after your rule runs, you can go verify that the syntax is what you expected.

EDITED TO ADD: On March 31, 2016, I'm presenting our free weekly webinar with qRules 101 as the topic - you seem to be getting the hang of it just fine, but you may want to attend just in case there is any new info that would be helpful? http://www.qdabra.com/en/training/FreeWebinar.aspx

Re: CopyRichText not removing HTML

Mariav — Wed, 23 Mar 2016 13:23:11 GMT

Attached is the form, at first I had hand typed in the concat function, then used the fx button. Since all my errors came from any formula that pointed to items in quotes, I played around with using fields to supply to filters. Then reverted to just trying one filter, to see if I could get that to work.

Attached is my form, plus a screenshot of the error I was getting for quote.

Screen shot of error: https://drive.google.com/file/d/0B4aMjDV14cTUWUN6WTAwZndLUHM/view?usp=sharing

Re: CopyRichText not removing HTML

Hilary Stoupa — Tue, 22 Mar 2016 22:09:27 GMT

Can you attach your form in a reply again so I can see what you are doing?

Re: CopyRichText not removing HTML

Hilary Stoupa — Tue, 22 Mar 2016 22:08:44 GMT

The concat formula needs to go in the formula editor (click the fx button) not just in the value for the rule. :)

Re: CopyRichText not removing HTML

Mariav — Tue, 22 Mar 2016 21:31:16 GMT

If I take out all filters, except for report period, I get the following error.... Concat and CopyRichText don't seem to play nice together.

Required parameter unspecified: xpathdest. Usage is:

CopyRichText
[/dsnamesrc=Data Source Name (Source)]
/xpathsrc=XPath to Node (Source)
[/dsnamedest=Data Source Name (Destination)]
/xpathdest=XPath to Node (Destination)

Re: CopyRichText not removing HTML

Mariav — Tue, 22 Mar 2016 20:20:50 GMT

Sorry for the delay, we have Office 365 and I had to change my password... which meant none of my data connection worked for 24 hours until all the servers replicated. Ugh!

I added the error field, and I love that idea, thanks!! Below is the error I get from qRules

"Invalid command specified: concat"

I have tried adjusting the syntax a few different ways, below was my last attempt.

Re: CopyRichText not removing HTML

Hilary Stoupa — Mon, 21 Mar 2016 14:38:24 GMT

Hi - I think you might want to try a concat here, since you are involving multiple data sources:

concat("CopyRichText /dsnamesrc=Receive_Forms /xpathsrc=

/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:OPS_x0020_Highlights[../d:Report_x0020_Period = '", Report_Period , "' and contains(../d:Corp_x0020_Sales, "Corp")]

/xpathdest=/my:myFields/my:CC_Highlights ")

With Report Period from the main data source picked with the field picker, so it is passed in as a value. Do you have the qRules Error node or Execution History somewhere on your form so you can see any returned error messages while you are working on your form? I usually leave those on till I have the design work done, then either move them to a debug view, or just take them off the form. Makes the dev process easier. :)

Re: CopyRichText not removing HTML

Mariav — Sun, 20 Mar 2016 16:42:28 GMT

Figured part of it out. I was filtering the data first and pulling it into my form then trying to use the CopyRichText. If I pull directly from the SP list to populate the field, it works beautifully.

Now my question is, can I use xpath statements in the command to determine which SP list item it retrieves back? Below in bold, is what I would like to be able to add to the command line, I have already tried many variations but they all are cause nothing to be returned.

CopyRichText /dsnamesrc=Receive_Forms /xpathsrc=

/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:OPS_x0020_Highlights[../d:Report_x0020_Period = xdXDocument:get-DOM()/my:myFields/my:Report_Period and contains(../d:Corp_x0020_Sales, "Corp")]

/xpathdest=/my:myFields/my:CC_Highlights

Re: CopyRichText not removing HTML

Mariav — Sun, 20 Mar 2016 15:28:28 GMT

To clarify, I read on another post that on the submission form (the one that feeds the results into this form), the richtextbox needed be set as plain text in SP first ... then I should set up my connection in IP, after that I could go back into SP and swap it back to rich text.

I am not sure if this makes a difference or not?

My perfect scenario would be to pull all the matching SP list data that matches the report period, and each field displays as plain text, keeping the original paragraph/line breaks and tabs/indentations.

Re: CopyRichText not removing HTML

Mariav — Sun, 20 Mar 2016 15:08:42 GMT

I reconfigured my connection so that it would recognize the field as XHTML, and it strips the HTML but I have no line breaks.

Re: CopyRichText not removing HTML

Hilary Stoupa — Sun, 20 Mar 2016 13:58:15 GMT

The issue I see in your form vs. the form I created to test is that in my test form, the data type for the Rich Text column from the secondary data source is XHTML. That is what CopyRich text is going to work with - it copies the XHTML from one node to another. In your form, the Rich Text column from your secondary data source is NOT XHTML - it is something different. That's why I asked what the list settings are on your column.... for my test, I used the middle option of Rich Text in my SharePoint list.