Publicado Wed, 12 Jun 2019 21:49:53 GMT por Michael Weingand
Hi folks,
Is there a way to Automatically name a document while downloading it from one of the fields, like the Last_Name field?  My customer does a search then downloads the file and manually renames the file.  They download quite a few files, every day and it takes lots of man hours to rename each file.
Publicado Wed, 12 Jun 2019 22:11:10 GMT por Matthew Trembly
Which field are you using for Document Name in the file cabinet configuration?
Publicado Wed, 12 Jun 2019 22:51:35 GMT por Michael Weingand
Document Type.  I guess if I change this to Last Name then this is what the downloaded file name would be.  Is this where you are going with this?
Publicado Thu, 13 Jun 2019 13:51:01 GMT por Matthew Trembly
Yes, that's it.  If you want something fancier, you can add a hidden field such as "Filename" or something and have AIX or Workflow update it so the filename is LNAME_DOCTYPE or similar. 
Publicado Thu, 13 Jun 2019 20:21:33 GMT por Michael Weingand
I tried this with workflow but get errors. Am I doing this wrong?  I created a variable.  Then I created this Assign Data with a Arithmetic Expression. Then assigned the variable to the Full Name field. It's bombs at this expression.  Not sure how to concantonate if this is not it.

Publicado Thu, 13 Jun 2019 22:57:46 GMT por Matthew Trembly
Compare with this: DW_VENDOR_NAME + "_" + DW_INVOICE_NUMBER

When this customer has to view, download, or send this file cabinet document as an email attachment it has a useful filename.

Publicado Thu, 13 Jun 2019 23:58:19 GMT por Michael Weingand
Hi Mathew.  This is what I have and I get an error about Expression of type 'String' expected.
This is what I have in the Arithmetic Expression.  I also set to Validate.


The screen shot shows part of the error when running a test on Workflow manager.   I am thinking I am missing something to make this a string.
Publicado Fri, 14 Jun 2019 13:59:31 GMT por Matthew Trembly
What does the data assignment activity look like?
Publicado Fri, 14 Jun 2019 16:41:40 GMT por Michael Weingand
Here is a zip of my entire workflow.  Just updating a variable, then using that variable to update the field.  Later I would use it to update a few different fields in different ways, hence the variable.
Publicado Fri, 14 Jun 2019 22:19:32 GMT por Matthew Trembly
You're already assigning GV_Full__Name in the data assignment prompt.  Check out my attached revision.
Publicado Fri, 14 Jun 2019 22:34:41 GMT por Michael Weingand
Thanks Matt.  Yep this is what I saw in your last screen shot and made the change to my workflow.  I was trying to think of it as a calculation not as setting data to a variable that I was already in.  In other words, what I was doing, was causing the background script to be GV_Full__Name =GV_Full__Name =DW_FIRST_NAME + “ “ + DW_LAST_NAME if you were looking and the SQL statement.

You must be signed in to post in this forum.