hiteksoftware.com

[Robert]

User support request:

Once a week we have to pick up XX_YYY 011013.xlsx.pgp and AA_BBB 011013.xlsx.pgp files from one directory, move them to other directory, let’s call it TEST. Then we have to decrypt them. After that they should be named XX_YYY 011013.xlsx and AA_BBB 011013.xlsx. Is there any way to use a variable for Filename and Rename Filename in Decrypt Task, since the filenames are change every time. The only stable part of them is XX_YYY *.xlsx.pgp and AA_BBB *.xlsx.pgp.

Then I have to send email to my coworker with attached files. Is this the any way to use variables for file names in the Attach File line of Send Email Task instead of C:\TEST\XX_YYY 011013.xlsx,C:\TEST\AA_BBB 011013.xlsx?

[Robert]

a) You should move the 2 files to a temp folder (say c:\temp ) where we can decrypt the files and email them.

b) Then move these 2 files from c:\temp to final resting folder.


1) In your copy task (move option), for the filename field try:
XX_YYY^AA_BBB

target folder:
c:\temp

This should move both files.

2) In your decrypt task:

source folder:
c:\temp

filename field:
XX_YYY^AA_BBB

rename filename field:
.xlsx.pgp<REPLACE>.xlsx


3) In your email task:
attachment field:
[DIR]c:\temp[FILE]XX_YYY^AA_BBB


4) finally another move task from c:\temp to final resting folder.
source folder:
c:\temp

filename field:
XX_YYY^AA_BBB