Qdabra qRules

Re: Post Attachments

DaFlea — Tue, 28 Apr 2009 16:36:56 GMT

I belive his error is due to not haveing full trust enabled in the form security area.

I am able to submit files to my document library without the Form living on the same box as the document library. I am just using preview mode localy to test the form function as I make changes to it during development.

Your error appears to be the same one I was reciving before I changed the security to full trust.

Doug

Re: Post Attachments

ErnestoM — Mon, 27 Apr 2009 14:56:53 GMT

Yes, please let us know if there were any steps that weren't clear in our documentation and we can work to correct this. Thanks.

Re: Post Attachments

Patrick Halstead — Mon, 27 Apr 2009 14:30:53 GMT

Hi JBorean,

Thank you for the excellent feedback. We will work on better documentation around the areas you mentioned. We are planning an update to the tool this summer to include other features like OCR and Encryption. We will probably release better documentation for the current version before those features come out. If you have other features you'd like to see, please chime in.

If you have time and can provide more detail around the areas that were troublesome for you, that would be wonderful! :)

Re: Post Attachments

jborean — Sun, 26 Apr 2009 12:10:47 GMT

I went ahead and started from scratch again and have it working on a basic level. I am not sure if or why this would matter, but I built all of my tables and sections first this time and then added my attachment control first (after of course opening and saving a blank form and injecting it). I have kept the attachment as first in my data sources. I then set about adding all of my other controls while testing it each time for continued function... so far, so good.

Now I would just like it to function like the demo video which is showing qRules in action with DBXL rather that SharePoint. I do not like the look of how it functions on a form being used for sharepoint at this time. Maybe I am doing something wrong but here us what I get after clicking the button to send it to SharePoint:

<The Click here to attach a file control is still visible, which is fine because I want it to remain for adding more files>

Q Rules Link: <big long crazy hyperlink>
Q Rules Filename: <Samebig long crazy hyperlink>

What I want is for there to be a hyperlink with just the file name/type showing just like in the demo. There also came the question for how to organize the file attachments once they get sent to the portal. Would it be possible to have the control send the attachments to a folder in the document library that is created and associated to the form by it own unique identifier/name? Meaning the form gets it's name from a field in the form and all of the attachments are sent to a folder likewise generated the same way rather than just dumping them into a document library with no way of associating all of the files to specific forms. This is particularly an issue when considering portability or backing them up.

Best Regards,

Jason

PS: You were incorrect about the control not working in preview mode... it works just fine.

UPDATE: I used conditional formating to hide the Attachment control and the duplicate hyperlink. I also finally got the repeating control to work for multiple attachments. My only complaint at this point is the Date/Time stamp added to the from of the files. Would it at least be possible to dynamically select the original file name for the text displayed for the hyperlink?

Other than that we could use some much better instructions and examples of how to set this up, particularly for SharePoint. Perhaps if I have time I will make an example of how I got it to work and resolutions to my obtacles. But thanks for the awesome tool! I will work hard to outgrow it and explore your other solutions.

Re: Post Attachments

ErnestoM — Fri, 24 Apr 2009 17:09:57 GMT

This command will not work on Preview mode. The InfoPath form and the SharePoint Document Library must live on the same machine.

Re: Post Attachments

jborean — Fri, 24 Apr 2009 12:44:09 GMT

I am having a similar error... it's been a while. Any clues on this one yet?

Action: SaveToSharePoint
Arguments: System.Collections.Generic.Dictionary`2[System.String,System.String]
Details: Request for the permission of type 'System.Net.WebPermission. System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Stack:   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   at System.Security.CodeAccessPermission.Demand()
   at System.Net.HttpWebRequest..ctor(Uri uri, ServicePoint servicepoint
   at System.Net.HttpRequestCreator.Create(Uri Uri)
   at System.Net.WebRequest.Create(Uri requestUri, Boolean useUriBase)
   at System.Net.WebRequest.Create(String requestUriString)
   at Qdabra.Tools.RulesLibrary.Commands.SaveFileToSharepoint(String& base64Value, String& url)
   at Qdabra.Tools.RulesLibrary.Commands.SaveToSharepoint(String url, String domName, String nodeXPath)
   at Qdabra.Tools.RulesLibrary.Commands.SaveToSharepoint()
   at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand(Application application, XmlFormHostItemformHost, XPathNavigator commandsNavigator)

This happened in Preview mode... I will try uploading it to a document library on the same site as the library I plan on submitting the attachments too and will report my results.

Here is the value I used for my action on the button: SaveToSharePoint /url=http://www.mydomain.mydomain.mydomain.scom.com/sites/SiteName/Lists/Attachments /xpath=/my:myFields/my:ActionData/my:Attachments/my:AttachFile1

This is a secure military site so I used generic names. I sure hope you have figured this out... :)

Re: Post Attachments

ErnestoM — Wed, 18 Mar 2009 20:12:50 GMT

qRules is the right solution in this case, not DBXL, but it looks like you have a SharePoint permissions issue that I haven't stumbled upon. Certainly trying to submit from Preview mode should fail, but with the form opened from its SharePoint Form Library, submitting to a separate document library, should work. I've asked others to look into this to see if we can come up with some additional help.

Re: Post Attachments

minkokiss — Wed, 18 Mar 2009 19:15:00 GMT

Ernesto, Do you happen to have any more ideas on why the error might be occurring? Can I do what I am looking for with DBXL as opposed to Qrules? Please let me know Best Regards, Minko

Re: Post Attachments

minkokiss — Tue, 17 Mar 2009 21:37:13 GMT

I actually tried both. Both fail with the same error message.

Re: Post Attachments

ErnestoM — Tue, 17 Mar 2009 21:11:24 GMT

Where is the form located? Are you opening (or previewing) from your local machine, or are you opening the InfoPath template from a SharePoint form library?

Re: Post Attachments

minkokiss — Tue, 17 Mar 2009 19:51:45 GMT

Thanks for the follow up Ernesto.

I tried this but I got the exact same error message.

I am logged on to the Domain on our corporate network and have Admin Permissions to all Libraries I am playing with. Based on the error message it seems that the issue is with the authentication from qRules.

Is there a way I can pass userid and password as arguments to be used in the authentication to the Sharepoint Library? Also does the sharepoint library need to be a specific type with specific columns? (document, picture, custom list)

Thanks for all your help. Minko

Re: Post Attachments

ErnestoM — Tue, 17 Mar 2009 18:43:36 GMT

Hi, I believe we have identified the issue. You need a separate document library where the images will be stored. From your description it sounds like you are trying to store the images in the same library as the forms, which is not the intended behavior. Can you try creating a separate document library to store the images, change the rule to upload to it, and try again?

Thanks.

Re: Post Attachments

minkokiss — Tue, 17 Mar 2009 13:29:39 GMT

Yes I apologize I used the incorrect term. I meant attributes.

Here is the form attached. I have obscured the URL of the sharepoint and changed to something generic.

Thank you for your help

Link to File

Re: Post Attachments

ErnestoM — Mon, 16 Mar 2009 21:41:40 GMT

Hi Minko,

Would it be possible to tell us more about your data source? The Image attachment control is supposed to have two attributes, qRulesLink and qRulesFilename, so I'm confused when you say that these are fields.

If you'd like to attach your form template I can give it a look.

SendtoSharepoint functionality of qrules

minkokiss — Mon, 16 Mar 2009 21:16:56 GMT

I just downloaded Qrules 1.5 and followed all the steps in the userguide to get it to work with the Sharepoint Library of my choice but am getting an error.

The error is as follows:

Action: SaveToSharePoint
Arguments: System.Collections.Generic.Dictionary`2[System.String,System.String]
Details: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Stack:   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
   at System.Security.CodeAccessPermission.Demand()
   at System.Net.CredentialCache.get_DefaultCredentials()
   at Qdabra.Tools.RulesLibrary.Commands.SaveFileToSharepoint(String& base64Value, String& url)
   at Qdabra.Tools.RulesLibrary.Commands.SaveToSharePoint(String url, String domName, String nodeXPath)
   at Qdabra.Tools.RulesLibrary.Commands.SaveToSharePoint()
   at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand(Application application, XmlFormHostItem formHost, XPathNavigator commandsNavigator)

I have performed the following steps:

Installed qRules and injected the DLL
Added the two fields qRulesLink and qRulesFilename
have the field as a base64 image on the form
created a form library in sharepoint and published the template to the form library
created a column in the form library of "image" type to host the image

Can somebody provide any assistance on that?

I can provide the form and any other information that you might need.

Best Regards,

Minko