Publié Wed, 12 Jun 2019 21:49:53 GMT par Michael Weingand Sales Engineer
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.
Publié Wed, 12 Jun 2019 22:11:10 GMT par Matthew Trembly Software Support Manager
Which field are you using for Document Name in the file cabinet configuration?
Publié Wed, 12 Jun 2019 22:51:35 GMT par Michael Weingand Sales Engineer
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?
Publié Thu, 13 Jun 2019 13:51:01 GMT par Matthew Trembly Software Support Manager
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. 
Publié Thu, 13 Jun 2019 20:21:33 GMT par Michael Weingand Sales Engineer
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.

 
Publié Thu, 13 Jun 2019 22:57:46 GMT par Matthew Trembly Software Support Manager
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.

 
Publié Thu, 13 Jun 2019 23:58:19 GMT par Michael Weingand Sales Engineer
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.

GV_Full__Name =DW_FIRST_NAME + “ “ + DW_LAST_NAME

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.
Publié Fri, 14 Jun 2019 13:59:31 GMT par Matthew Trembly Software Support Manager
What does the data assignment activity look like?
Publié Fri, 14 Jun 2019 16:41:40 GMT par Michael Weingand Sales Engineer
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.
Publié Fri, 14 Jun 2019 22:19:32 GMT par Matthew Trembly Software Support Manager
You're already assigning GV_Full__Name in the data assignment prompt.  Check out my attached revision.
Publié Fri, 14 Jun 2019 22:34:41 GMT par Michael Weingand Sales Engineer
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.