Script Spotlight: Moving Files with EMUE

Script Spotlight: Moving Files with EMUE

Candice Powers of Davis Health in Elkins, West Virginia, developed a script that is used to identify, sort, and move bulk payment files as soon as they have been scanned into the system. Once identified, the payment files are moved to a shared drive to be accessed by multiple users. This removes a once manual daily process and saves approximately two hours of work for one FTE.

While the process of organizing, renaming and moving files will be unique for each facility, there are a number of tools that EMUE offers to make this process flexible.

For this particular process, all of the files originate in the same directory. The name of the file along with the date determine the file's final destination. There is a directory corresponding to the particular insurance company, then the year, then there are directories for each month and finally for each day. A file called "10-15-08 BCBS.pdf" would be put into the following directory:

P:\Groups\Business Office\DM Bulk Payments\2008 DM Bulk Pmts\Blue Cross\10-2008 Blue Cross\10-15-08 BCBS.PDF

For Davis Health, the entire purpose of the script is to rename and move files. Since there is no interaction with the mainframe, there is no need to make a connection. To configure EMUE not to connect to the mainframe, this setting should be included in the script file:

SETSTARTUP RumbaInterfaceType "NoConnection"

The script is configured to process files as they arrive in the input file directory and then wait for more files to arrive. The following settings are needed to achieve this goal:

SETSTARTUP InputFile "P:\Groups\Business Office\EMUEMove\*.pdf"

SETSTARTUP WaitForInputFile "Yes"
SETSTARTUP WaitAgain "Yes"

The name of the input file (without the path or file extension) is retrieved with the built-in variable, &InputFileName. The first eight characters, which indicate the date, are copied into a variable called date. Then four more characters that indicated to which insurance company the file corresponded are copied from the input file name into a variable called remit.

Copy date &inputfilename 1 8
Copy remit &inputfilename 10 4

This path is constructed using the CONCATENATE command and finally the MoveFile command is used to move the file to the new directory.

Concatenate path "P:\Groups\Business Office\DM Bulk Payments\DM Bulk Payments\" year " DM Bulk Pmts\" bulkpmtfolder "\" actualdate " " lastfolder "\" &inputfilename ".PDF"
Movefile InputFile path

The name of the file could have been changed with the MOVEFILE command. Instead of specifying the file name as &InputFileName, it could have been changed to anything else. In the following line, the file is renamed "BulkPayments.pdf."

Concatenate path "P:\Groups\Business Office\DM Bulk Payments\DM Bulk Payments\" year " DM Bulk Pmts\" bulkpmtfolder "\" actualdate " " lastfolder "\BulkPayments.PDF"

Additionally, files can also be copied or deleted using the COPYFILE and DELETEFILE commands.

Please download this script from the EMUE\OLIE script library, using one of the links below.

If you are already a script library member, click here to download the script. (Login required)
If you are a Siemens SIGNATURE® or INVISION® client, and not yet a member of the script library you can click here to join for FREE and have unlimited access to this script plus over 60 more!