Rename an archived file

In order to successfully rename a file, a valid format should be supplied.

Note: It is important to remember that no error-checking is performed when you enter the name of the archive and save the changes.

If the archive name is incorrect, a message will be recorded in MeasFileImport.log, and the archiving process will fail. However, the file parsing process associated with the original File Import task will continue.

In the event that the file import archiving task is unsuccessful, you will receive a message that reads: "Archival of file "yourfilename" to location "yourlocation" using protocol "FTPS" failed." along with a description of the error.

Here is an example of a format that can be used in order to successfully rename an archived file:

{origFilename(8,7)}.{YY}.{MM}.{DD}.{HH}.{EXT}

• Leave this field blank if no rename is desired.

• {origFilename (#,#)} - This is a substring of the original archive file name. This allows you to truncate the original file name. The first digit starts at a specified character position, and the second digit specifies the length. For an example of how to truncate the original file name, see Example 3 listed below.

• {YY} - 4-digit Year

• {MM} - Month

• {DD} - Day

• {HH} - Hour

• {MI} - Minute

• {SS} - Second

• {EXT} - File extension

• Any characters

  Note: If you are going to use braces ({) as additional characters, you will need to use the escape character (a backslash) before entering the brace. For example, \{.

If the Archive task is run multiple times, the file will be archived multiple times. If the name is the same as the original, multiple records with the same name will be logged in the database.

However, only the most recent version will still be archived.

Example 1

The original filename is OriginalCurrent.CSV.

The desired output looks like this: OriginalCurrent.2016.08.20.09.15.CSV

In order to achieve the desired output, you must enter information as a string in the following format: {origFilename}.{YY}.{MM}.{DD}.{HH}.{MI}.{EXT}

In this instance, the original filename is entirely retained (there is no new name that prefaces the {origFilename}). The characteristic that makes this archived string unique, then, is the timestamp information. This archived file contains information for OriginalCurrent that was gathered on August 20th, 2016 at 09:15 A.M..

Example 2

This outlines how the formatting should appear when the {origFilename} is replaced entirely by a NewName.

The desired output looks like this: NewName.2016.08.20.09.15.CSV.

In order to achieve the desired output, you must enter the information as a string in the following format: NewName.{YY}.{MM}.{DD}.{HH}.{MI}.{EXT}

In this instance, there are no traces of the original filename in the string. The Archive will be saved with the new name and unique timestamp.

Example 3

The original filename is OriginalCurrent.CSV.

This example demonstrates what happens when part of the original filename is used. It is possible to truncate the original filename such that it is only used in part. For example, see the format string below:

format string = {origFilename(8,7)}.{YY}.{MM}.{DD}.{HH}.{EXT}

Note: After the origFilename, there is a bracket with two numbers listed: (8,7). These two numbers dictate the characters that should be parsed for by the File Import tool. Remember, the original filename in this instance is OriginalCurrent. The numbers in the bracket indicate the first character, and total number of characters to be used. The syntax used by the File Import tool begins counting at zero, making C the first character used in the example. The parser will search for a string beginning at the eighth character (counting from zero), for a result like the one below:

output = Current.2016.08.20.09.CSV