InfoPath Dev

I've installed a trial version of qRules and have the SaveToSharePoint command working. When the file is saved to the SharePoint library, it prepends the date, time and an underscore to the file name. I do not want this; I want just the file name as it is attached. Is there a way of achieving this? Thanks

Yes, there is a way to do this.

1. In a rule before your SaveToSharePoint rule, execute the GetAttachmentAttribute command with /attr=name. This will return the name of the attachment to the Qdabra Rules result node.
2. In your SaveToSharePoint rule, you'll need to use a formula instead of just setting the value to a string in your rule to set the Command field - formula will look something like this:
   concat("SaveToSharePoint /url=http://server/site/docLibrary /xpath=/my:myFields/my:Images/my:Image /name=", Result)

So, basically, you use qRules to get the name of the attachment, then you add the "name" param to your SaveToSharePoint command. You may also want to add the /overwrite param to your SaveToSharePoint command so that you can control what happens if there are multiple attachments saved to the same library that have the same name (which is why we add the date and time info to files by default).

Hi Hilary,

How can I add overwrite parameter in below formula?

concat("SaveToSharePoint /url=http://server/site/docLibrary /xpath=/my:myFields/my:Images/my:Image /name=", Result)

Thanks In Advance

Hi Hilary!

I tried adding a concat function in the QRulesFilename part but it doesn't generate the filename.

My formula is: concat("SaveToSharePoint /url=http://server/site/docLibrary /xpath=/my:Form/my:group36/my:group37/my:group38/my:AttachSection /name=", concat(SystemGeneratedCode,"_",@qRulesNewFileName))

Checking the document library, it returns "SystemGeneratedCode_". Even if I upload multiple items, it just returns one "SystemGeneratedCode_" file.

I'm using this on a repeating table and can confirm that concat("SaveToSharePoint /url=http://server/site/docLibrary /xpath=/my:Form/my:group36/my:group37/my:group38/my:AttachSection /name=",@qRulesNewFileName) works even on multiple files uploaded at the same time.

Looking at the documentation, I think you'll need to use namexpath instead. Is AttachSection your repeating group? I'd probably add a field there with a default calculated value that concats the system generated code with the file name - or whatever you wish to use. Then you can use namexpath=my:NewField (whatever the name of your field is). Does that make sense?

Just tested and it worked! Thanks a lot for this, Hilary :D

Hilary Stoupa:

Looking at the documentation, I think you'll need to use namexpath instead. Is AttachSection your repeating group? I'd probably add a field there with a default calculated value that concats the system generated code with the file name - or whatever you wish to use. Then you can use namexpath=my:NewField (whatever the name of your field is). Does that make sense?