When defining data load detail for a file-based data load system, load data to a single period or a range of periods. For a single period, enter the file name in the data rule and run the rule for a single period. To load multiple periods, create a file for each period and append the period name or period key to the file name. When the rule is executed for a range of periods, the process constructs the file name for each period and uploads the appropriate data to the POV.
To define the data load details for a file-based source system:
In Category, select a category.
The categories listed are those that you created in the FDMEE setup, such as “Actual.” See Defining Category Mappings.
In Directory, enter the relative path where the file is located.
In the File Name field, enter the static name of the file.
If only the file name is provided, then data must be entered for a single period on the Rules Execution window.
To load multiple periods users can create a file for each period and append a period name or period key to the file name. When the rule is executed for a range of periods the process constructs the file name for each period and upload the appropriate to the POV.
Note:
Period names cannot include spaces when used in a batch script.
To navigate to a file located in a FDMEE directory, click Select and then choose a file on the Select screen. You can also select Upload on the Select screen, and navigate to a file on the Select a file to upload screen.
If you do not specify a file name, then FDMEE prompts you for the file name when you execute the rule.
To load data into multiple periods, in the File Name Suffix Type drop-down, select either Period Description or Period Key.
A suffix is appended to the file name, and FDMEE adds the file extension after adding the suffix. If you leave the file name blank, then FDMEE looks for a file with Suffix. When the file name suffix type is provided, then the file name is optional in this case, and it is not required on the Rule Execution window
If the file name suffix type is a period key, the suffix indicator and period date format are required (as the suffix set) in the file name, and must be validated as a valid date format. For example, you might specify:
1_Jan-2013.txt
1_Feb-2013.txt
1_Mar-2013.txt
In this case, when you run the rule, enter 1_.txt in the file name field and select "Period Name" for the suffix indicator. Then run the rule for January to March periods
In Period Key Date Format, specify the data format of the period key that is appended to the file name in JAVA date format (SimpleDateFormat).
From the Import Format drop down, select the format when importing the file for the location.
If the import format is not specified, then the import format from the Location is used.