Qdabra qRules

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 20:00:38 GMT

It works now, sorry about the confusion. In the client, I am using a "dummy" user. In IPFS, my corporate user was able to submit the file fine, with the custom name. It's wierd, I can do the SubmitToSharePointList command with my dummy user.

Please understand that the anonymous access problem is not related to this at all. In IPFS, the SubmitToSharePoint list with ANY users when anonymous access is activated.

Anyway, the filename feature is great. Thanks for all of your help!

Re: SaveToSharePoint remove special characters?

Jimmy — Tue, 06 Sep 2011 19:25:48 GMT

Underscores and hyphens shouldn't be a problem. That filename looks like it should be fine. Are you able to save to this library when you don't use the /name parameter and use a file that doesn't have special characters in the name? This is starting to look like a permissions issue, or something of that nature. Could it be the anonymous access you were talking about in your other thread?

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 18:51:29 GMT

Still getting an error.

'Failed to save to SharePoint. URL = 'http://****/den/hr/Receipts/prguser_ACVS2011-09-06T124725.pdf'

Are hyphens or underscores a problem?

Re: SaveToSharePoint remove special characters?

Jimmy — Tue, 06 Sep 2011 18:34:04 GMT

SharePoint doesn't allow using colons in a filename. Could you using translate(now(), ':', '-') instead of just now()?

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 18:20:56 GMT

No problem.

Just a little background . . . this is an expense report, so it IS possible that the filename that I specified could already exist since I just concatted the job name and the user. I tried appending now() to the end of it, and received this error -

Failed to save to SharePoint. URL = 'http://****/den/hr/Receipts/prguser_ACVS2011-09-06T12:16:27.pdf'.

Shouldn't that file name have submitted?

Re: SaveToSharePoint remove special characters?

Jimmy — Tue, 06 Sep 2011 18:10:15 GMT

You are right about that bit of documentation. I do beg your pardon and apologize for all the trouble you're having here.

Could you please try specifying the parameter /overwrite=yes in this command? That should bypass the code that is having this issue and allow you to save. Is the Show value that you are appending to the end of the filename a way to ensure unique filenames so there is no danger of an actual overwrite?

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 17:17:40 GMT

I just looked at the guide, and it states "extension will be added by qRules"

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 17:16:17 GMT

Maybe I am not understanding the point of this command. I want to rename the file that gets saved to sharepoint because certain characters cause the file submittal to NOT work.

Why would I want to change the extension? I don't know if my users are going to attach a pdf, txt, or doc file.

I tried removing the spaces and received the same error.

Re: SaveToSharePoint remove special characters?

Jimmy — Tue, 06 Sep 2011 16:54:13 GMT

The file's name is Phillip Rguser_99? No extension (.txt, .jpg, .doc)? Could you see what happens if you remove the space in the file name?

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 16:16:11 GMT

And I still get "Failed while checking for existing file" in the QRules error node.

Re: SaveToSharePoint remove special characters?

shniggens — Tue, 06 Sep 2011 16:14:07 GMT

OK, so when I do this, I get this result in the text field -

SaveToSharePoint /url=http://*****/den/hr/Receipts /xpath=/my:myFields/my:PurchaseTable/my:Purchases/my:Receipts/my:Attachment /name=Phillip Rguser_99

Which is what I would expect, as it set the user name, and a number I assigned as the file name.

Re: SaveToSharePoint remove special characters?

Jimmy — Fri, 02 Sep 2011 03:11:42 GMT

Do the same thing you are doing to the Command node, but do it to some other field that you can display in your form. You can temporarily create a new field if you don't have one that you can temporarily use for that purpose.

Re: SaveToSharePoint remove special characters?

shniggens — Thu, 01 Sep 2011 18:48:22 GMT

Bear with me, because I still don't understand what you are saying. What do you mean set the value of that formula?

Re: SaveToSharePoint remove special characters?

Jimmy — Thu, 01 Sep 2011 17:34:40 GMT

I mean, when you use a rule to set the Command node to the value of the formula concat("SaveToSharePoint /url=http://*****/den/hr/Receipts /xpath=/my:myFields/my:PurchaseTable/my:Purchases/my:Receipts/my:Attachment /name=", FullName, "_", Show), use another rule action to set the value of that formula to a field that you can display, so that you can see what the actual command looks like when it is splayed out.

Re: SaveToSharePoint remove special characters?

shniggens — Thu, 01 Sep 2011 17:14:05 GMT

Jimmy:

Ok. When you run the command, could you use the same formula to set the command's actual value to a field in the form where it could be viewed? That may be illuminating.

I'm not sure I follow here. Take the output of the command somehow and set another field with it?

I tried making the error field multi-line, but there still wasn't anymore info.