Qdabra qRules

Re: SaveToSharePoint Dynamic URL?

Jimmy — Thu, 02 Dec 2010 17:45:40 GMT

For your dynamic formula, try removing the spaces before and after the equals sign. That's most likely the issue.

For a non-dynamic formula, you need to either enclose the whole command in quotes:

"SaveToSharePoint /url=http://intranet.dci.com/eng/apd/project /xpath=/my:myFields/my:Attach"

or enter the command in the Value box without going into the formula editor

Re: SaveToSharePoint Dynamic URL?

Hilary Stoupa — Thu, 02 Dec 2010 17:39:47 GMT

You are using the main data souce, so do not need to specify a /dsname. What does the url from your 2DS look like? Does it have a trailing "/" already? Try pasting your concat formula into a dialog box expression, so that IP will pop up a message box in preview that shows you the formula after the concat has run.

The error you are getting when you use a non dynamic formula -- were you simply entering the string into the formula editor window instead of the "value" field for the rule?

Re: SaveToSharePoint Dynamic URL?

derrickgh — Thu, 02 Dec 2010 17:31:45 GMT

I am getting the error:

An error has occurred executing the rule. Required parameter unspecified: xpath
Usage is:

SaveToSharePoint
/url=SharePoint Library URL
[/dsname=Data Source Name]
/xpath=XPath to Picture(s) or Attachment(s)[/dsnamews=Data Connection Name for Copy web service]

Below is the formula I am using:

concat("SaveToSharePoint /url=", @ProjectSiteUrl, "/Shared Documents", " /xpath = /my:myFields/my:Attach", " /dsname = Main Connection")

Also, If I try to use a non dynamic formula for testing (SaveToSharePoint /url=http://intranet.dci.com/eng/apd/project /xpath=/my:myFields/my:Attach) I get the error:

Expected value type: end-of-string

Actual value: :
SaveToSharePoint /url=http-->:<--//intranet.dci.com/eng/apd/project /xpath=/my:myFields/my:Attach

Re: SaveToSharePoint Dynamic URL?

Hilary Stoupa — Tue, 30 Nov 2010 20:38:05 GMT

So, you could use a concat formula to create your SaveToSharePoint command. Instead of typing the command into the value box when creating the rule to set the Command node, you'd use a formula:

concat("SaveToSharePoint /url=", urlfield,"LibraryName "/xpath=<XPath To Attachment>")

where you use Insert field or group to insert the field (with any filters) that contains your URL where it says urlfield above, the words LibraryName with the name of your library, and you replace <XPath To Attachment> with the actual XPath to your attachment.....

Re: SaveToSharePoint Dynamic URL?

derrickgh — Tue, 30 Nov 2010 16:45:28 GMT

Thanks for the quick response. From the description above it looks like the SaveToSharePoint is what I would need. The form I have is a content type that is used on multiple project sites. The form will have multiple attachments that need to be submitted to that specific projects document library. I do have the URL to the project site is contained in the data source so if I could use that that would work.

Re: SaveToSharePoint Dynamic URL?

Hilary Stoupa — Tue, 30 Nov 2010 16:40:53 GMT

Hi -- AttachToSharePointList adds an attachment to an existing list item. SaveToSharePoint submits a file to a library. Which command you use would depend on what you are trying to achieve.

Can you tell me more about what you mean when you say "a dynamic URL based on the information contained in the form"? Is the URL used contained in a form field? Or do you want rule logic based on a field (i.e. Department = HR, save to one library, else another)?

Re: SaveToSharePoint Dynamic URL?

derrickgh — Tue, 30 Nov 2010 16:28:20 GMT

What would be the best way to accomplish this through AttachToSharePointList or SaveToSharePoint? Can you provide an example of what that function would look like?

Re: SaveToSharePoint Dynamic URL?

ErnestoM — Wed, 24 Nov 2010 22:35:47 GMT

Yes, it is theoretically possible to use the command this way. Let us know if you run into issues!

SaveToSharePoint Dynamic URL?

derrickgh — Wed, 24 Nov 2010 19:48:08 GMT

Hello - Is it possible to have the SaveToSharePoint command point to a dynamic URL based on the information contained in the form?