Qdabra qRules

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Wed, 13 Apr 2016 17:26:43 GMT

Yes, it has tested in the browser and everything works. I was also able to move the sub-folder creation rules to the button controls where the files are triggered for uploading. I also like that I don't see another web service data connection to create the folders.

Everything is working as expected, and all affected controls are set to always post back. I'm getting ready to do final testing, documenting and then incorporate this into my development copy of my project form.

Re: Save attachments in repeating tables, and save them to folders

Hilary Stoupa — Wed, 13 Apr 2016 17:17:56 GMT

Great news, I'm glad you have it working. One thing - if you haven't tried it in the browser yet, be sure to set postback to always on any buttons / controls that execute qRules commands (under the control properties, under the browser tab).

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Wed, 13 Apr 2016 17:12:46 GMT

Thank you for all your help! I have a working prototype. that meets all my needs for this project. :)

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Wed, 13 Apr 2016 12:12:54 GMT

Thank you -I will certainly incorporate both of those things.

Re: Save attachments in repeating tables, and save them to folders

Hilary Stoupa — Tue, 12 Apr 2016 17:47:24 GMT

One thing that will help you is if you put the QdabraRules ExecutionHistory repeating History group on your form while doing your initial development work. Then you can see the results of these concat formulas. I would not use that default in the form name field - instead, in the rule where you set the field, translate the now() function to remove unwanted chars.

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Tue, 12 Apr 2016 17:26:02 GMT

One step closer Hilary!

I added the rule to create the folder when the form loads at the same time the formName is created.

I might work for us because we will need the folder existing before documents are added to the InfoPath form.

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Tue, 12 Apr 2016 16:41:14 GMT

No errors, just doesn't create it.

formName is generated when a new file is opened, the initial rule is set under the Form Load rules, if formName is blank set to concat("CM-",now()).
The formName field has a default value of translate(., ' ~#%&*{}<>:?\/|"+.[]…', "____________________") so that the invalid characters get translated into underscores.

The first rule on the TestOnly (Create folder) button is disabled, this one will create a folder named 'test'. Its the Rule(dynamic foldername) I'm trying to get worked out. Do you think the 'translate' function putting a wrench in the works?

Re: Save attachments in repeating tables, and save them to folders

Hilary Stoupa — Tue, 12 Apr 2016 16:27:19 GMT

Are you getting an error with that formula? What is the value of the "formName" field?

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Tue, 12 Apr 2016 16:21:34 GMT

I am unclear on the /name parameter for this command. is this just the 'path' to where the folder is to be created, or is it to include the actual new folder name to create as well.

Yes!

This command created a folder called 'test' in my designated library.
CreateSharePointFolder /name=test /siteurl=http://nacertspfe01.stoneridge.com/CDCM6 /library=CMDocs2

I need to have the name parameter pull in the forms formName I tried this concat but I don't think it is correct. Does each parameter need to be separated?

concat("CreateSharePointFolder /siteurl=http://nacertspfe01.stoneridge.com/CDCM6 /library=CMDocs2 /name=", formName)

Re: Save attachments in repeating tables, and save them to folders

Hilary Stoupa — Tue, 12 Apr 2016 15:38:39 GMT

Have you tried using the qRules command for creating a folder, instead of just the web service directly? CreateSharePointFolder - it is in the command overview.

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Tue, 12 Apr 2016 15:27:32 GMT

I added another button to test just the 'create folder' and it doesn't seem to be functioning, new version attached. No error is returned to qRules, the dataconnectons dataFields result does return 'servererror' but nothing more than that. Both the form library and the destination documents library have contribute for all users so it shouldn't be a permission issue. Since SharePoint isn't throwing up a guid to track down in the logs, I'm not sure where to go next.

Re: Save attachments in repeating tables, and save them to folders

Hilary Stoupa — Tue, 12 Apr 2016 14:52:18 GMT

I would still test w/out the dsnamews parameter. You'll have to set it to full trust when you preview it, but can set it back to domain when you publish to sandbox. Have you tested just the create folder command?

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Tue, 12 Apr 2016 14:46:43 GMT

This is just a test form to workout the logic. It is a SP2013 IPFS browser form sandboxed. It will not be deployed through central admin.

Re: Save attachments in repeating tables, and save them to folders

Hilary Stoupa — Tue, 12 Apr 2016 14:36:52 GMT

You can attach a file under the options tab in a reply. Is this a browser or a filler form? You probably don't need the dsnamews parameter. Have you tried just creating the folder to see if there is any error on that command?

Re: Save attachments in repeating tables, and save them to folders

Laurie Wheeler — Tue, 12 Apr 2016 13:47:45 GMT

I'm trying to create the rules that will create the folder and upload the files into the folder, and my commands is returning an error:

Action: SaveToSharePoint. Arguments: url: http://nacertspfe01.stoneridge.com/CDCM6/CMDoc2/CM-2016-04-12T09_43_23 xpath: /my:myFields/my:Files dsnamews: CopyIntoItems . Details: <nativehr>0x80070003</nativehr><nativestack></nativestack>There is no file with URL 'http://nacertspfe01.stoneridge.com/CDCM6/CMDoc2/CM-2016-04-12T09_43_23/2016041209433713828_927-415-01-C OBS.pdf' in this Web.. Stack: Server stack trace: at Microsoft.SharePoint.SPFile.SaveBinaryInternal(Stream file, Int64 fileSizeToSave, SPFileStreamManager spmgr, Boolean isBackgroundSave, String checkInComment, Boolean checkRequiredFields, Boolean autoCheckoutOnInvalidData, Boolean bIsMigrate, Boolean bIsPublish, Boolean bForceCreateVersion, String lockIdMatch, SPUser modifiedBy, DateTime timeLastModified, Object varProperties, SPFileFragmentPartition partitionToCheck, SPFileFragmentId fragmentIdToCheck, SPFileFragmentPartition[] fragPartitionsToDelete, String csvPartsToDelete, Stream formatMetadata, String etagToMatch, Boolean bSyncUpdate, SPLockType lockType, String lockId, TimeSpan lockTimeout, Boolean refreshLock, Boolean requireWebFilePermissions, Boolean failIfRequiredCheckout, Boolean validateReqFields, Guid newDocId, Boolean bypassMaxFileCheck, Boolean bypassQuotaCheck, Boolean bypassVirusScan, SPVirusCheckStatus newVirusStatus, Int32 newVirusVendorId, String newVirusInfo, Byte[] newVirusInfoEx, Boolean bUseTimeLastModified, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage, String& etagReturn, Boolean& ignoredRequiredProps, SPFileInfo& fileProps) at Microsoft.SharePoint.SPFile.SaveBinary(Stream file, SPFileSaveBinaryParameters parameters) at Microsoft.SharePoint.SPFile.SaveBinary(Stream file, Boolean checkRequiredFields, Boolean createVersion, String etagMatch, String lockIdMatch, Stream fileFormatMetaInfo, Boolean requireWebFilePermissions, String& etagNew) at Microsoft.SharePoint.SPFile.SaveBinary(Byte[] file) at Microsoft.SharePoint.SPFile_SubsetProxy.SaveBinary__Inner(Byte[] file) at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.SharePoint.SPFile_SubsetProxy.SaveBinary(Byte[] file) at Microsoft.SharePoint.SPFile.SaveBinary__Inner(Byte[] file) at Microsoft.SharePoint.SPFile.SaveBinary(Byte[] file) 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()

Here is my command in the rule to upload the file attachments. This is a repeating table. the Rule does not have any conditions associated. the rule before creates the folder, which by the error, the URL would be correct, but the folder isn't getting created.

concat("SaveToSharePoint /url=", SharePointSiteUrl(), url, " /xpath=/my:myFields/my:Files", " /dsnamews=CopyIntoItems")

I would upload the form, but there is no mechanism for me to upload it into this posting.