Qdabra qRules

Re: CopyRichText - does not like my source

bsieloff — Mon, 11 Feb 2013 15:29:10 GMT

No DBXL, but I think the replace string function will work.

My replace string function reads as: ReplaceString /xpathsrc=/my:myFields/my:field6 /pattern=</?\w+((\s+\w+(\s*=\s*(?:".*?"|'.*?'|[^'">\s]+))?)+\s*|\s*)/?>

Thanks to the regex post from Phil Haack to save me hours of working that out.

Thank you Hilary, Ernesto & Patrick for your continued help and support.

-B

Re: CopyRichText - does not like my source

Patrick Halstead — Sun, 10 Feb 2013 00:52:01 GMT

Hi Bob,

Maybe you don't need to use Filter Owssvr. Maybe you can just use the DBXL Query SharePoint web method. That might give you the data in a format that can be copied into the field.

Just wondering ....

Re: CopyRichText - does not like my source

Hilary Stoupa — Fri, 08 Feb 2013 22:46:35 GMT

The error occurs when we try to set the inner XML of the destination node to the inner XML of the source - my guess is going to be because actual rich text has tags and the string representation in your source data does not - I tried this with a different owssvr.dll data source with the same result. I'm afraid this is likely just not going to work.

If you can use plain text, you might be able to use the ReplaceString function to try to clean up the text.

Re: CopyRichText - does not like my source

Hilary Stoupa — Fri, 08 Feb 2013 22:14:44 GMT

Yup - I grabbed your sample. I'm going to run this in debug real quick and see what's up - more soon.

Re: CopyRichText - does not like my source

bsieloff — Fri, 08 Feb 2013 22:10:33 GMT

oops, true.. I took a snapshot of the wrong field. Field4 is a rich text field too.

Re: CopyRichText - does not like my source

bsieloff — Fri, 08 Feb 2013 21:58:12 GMT

Re: CopyRichText - does not like my source

Hilary Stoupa — Fri, 08 Feb 2013 20:57:37 GMT

I'm confused again. You are copying to field4 in your command, but in your screenshot showing the data type for field1.

Re: CopyRichText - does not like my source

ErnestoM — Fri, 08 Feb 2013 20:46:22 GMT

If the form does not contain sensitive data, could you attach it to this forum post (via the Options tab), or email it to support at qdabra dot com? Thanks!

Re: CopyRichText - does not like my source

bsieloff — Fri, 08 Feb 2013 20:41:57 GMT

Hi Ernesto,

The field that the data is in (field1), is a rich text field

The data is from my secondary source in SharePoint

Re: CopyRichText - does not like my source

ErnestoM — Fri, 08 Feb 2013 20:19:17 GMT

Thanks. This seems to suggest /my:myFields/my:field4 is not a rich text field. Could we check whether it is?

Re: CopyRichText - does not like my source

bsieloff — Fri, 08 Feb 2013 19:43:15 GMT

Hi Ernesto,

When I clicked the "verify formula" it reformatted the command..

anyway, I did reformat and put into value field but it did not do anything, so I stuck the qrules results and error box out there. The data that I have has html tags and I wanted to render the text with formatting if possible in a new field (field4).

Here is a sample. my source text is above the results.

Re: CopyRichText - does not like my source

ErnestoM — Fri, 08 Feb 2013 17:21:41 GMT

You'll need a space between CopyRichText and /dsnamesrc

Also, I don't think you need to click FX to enter this command. You can enter the command directly into the Value field of the rule.

Re: CopyRichText - does not like my source

bsieloff — Fri, 08 Feb 2013 17:16:10 GMT

The source xpath is: /xml/rs:data/z:row/@ows_PublishingPageContent

The CopyRichText command looks like

CopyRichText/dsnamesrc = owssvr_sub_folder/xpathsrc = /xml/rs:data/z:row/@ows_PublishingPageContent /xpathdest=/my:myFields/my:field4

The error is: "CopyRichText/dsnamesrc" does not point to a valid location path of a field or group

Re: CopyRichText - does not like my source

ErnestoM — Fri, 08 Feb 2013 16:58:37 GMT

Hi-

You're right in using /dsnamesrc. What's the Error message returned after you've added /dsnamesrc to the command?

If you right click on the node (@ows_PublishingPageContent), and select CopyXpath, what xpath do you get? (You can paste it here if you can.)

Thanks.

CopyRichText - does not like my source

bsieloff — Fri, 08 Feb 2013 16:51:05 GMT

Hi,

Trying to get copyrichtext to work, but perhaps I'm doing something incorrect.

to test, setup button and told it set a fields value

in the "Field" field I selected the secondary data connection "QdabraRules (Secondary) and selected "Command"

and in the value I've placed

CopyRichText /xpathsrc=/xml/rs:data/z:row/@ows_PublishingPageContent /xpathdest=/my:myFields/my:field4

I keep getting an error that the source is incorrect, I then tried adding the switch: /dsnamesrc=owssvr_sub_folder (which is my dataconnect that calls owssvr.dll), but this did not help.

syntax issue?