Anyone who has used FDMEE to automate loads via OpenBatch has come across the problem of the “openbatch” directory filling up with archive directories. FDMEE creates an archive directory each time a Batch Execution is run, whether or not any files are processed. This not only clogs up the directory, but also makes it very difficult to find previously loaded files due to FDMEE’s naming convention for archived files.
A solution was needed to organize the archived directories, rename the directories with a date/time reference, and delete empty archive directories. This was accomplished using Custom script that is run after the OpenBatch procedure is completed.
We will walk through the default OpenBatch process to show the “out-of-the-box” functionality, as well as the process with the Custom script implemented.
Note: All screenshots and narrative relate to FDMEE version 18.104.22.168.200
In our example, we have one HFM application (TestApp) that will have OpenBatch procedures scheduled to load the application. We have created a directory with the application’s name under the “openbatch” directory. This is necessary to keep multiple application’s files/directories separated and for the Custom script to place the archived directories in the proper directory.
There are 3 Trial Balance files dropped into the application’s “openbatch” directory (TestApp) for processing.
The Batch Definition is setup as follows. Note that we define the “TestApp” application in the “Open Batch Directory” field. This is where the batch process retrieves the load files from.
The Batch Name is executed (usually via Schedule).
By default, FDMEE creates an archive directory in the “openbatch” directory. The naming convention is sequential, and not very informative.
The archived directory contains the 3 load files.
Now we attach the Custom “After Batch Script” script to the Batch Definition.
A directory with a text file was created to ensure that the script does not delete the application’s directory if it is empty.
We once again place the 3 Trial Balance files into the application’s “openbatch” directory for processing.
The Batch Name is executed.
Notice that after the batch is executed the “openbatch” directory only contains the “TestApp” directory.
The archive folder that FDMEE created was moved to the “TestApp” application directory and renamed with a date/time file name designation.
The 3 loaded files are archived in the directory.
The Custom script not only helps organize directories it, also keeps the “openbatch” directory clutter-free. Hopefully this helps clarify what the current FDMEE OpenBatch functionality is and what can be done with Custom script to enhance the ease of use.