If you have a fiscal calendar already in your global file, MPM completely overwrites it with the imported fiscal calendar. If a problem occurs during the import, the fiscal calendar import is aborted and no fiscal calendar data is imported.
The records in the fiscal calendar import file must be arranged in ascending date order. The month label is included only in the first fiscal calendar record. MPM automatically assigns subsequent month labels in consecutive order.
To successfully import your data, the import file has be in comma delimited ASCII file format.
In the table that follows, an * indicates a required field.
In the Type column:
A = alphanumeric
N = numeric
Y/N = Yes or No
For more information on the table, see Import File Formats Legend.
|
Field Position |
No. of Chars |
Type |
Field Content |
|
1* |
3 |
A |
Global import type: enter CAL for Fiscal Calendars |
|
2* |
9 |
A |
Fiscal Start Date; enter the first day of the fiscal month. Valid Date Formats: See Creating Import Files for details. |
|
3 |
5 |
A |
Month label. Months must be in MMMYY format only, where MMM=month and YY=year of first month of the calendar. Include this label in the first record only. |
|
4 |
7 |
N |
Equivalent man month hours; enter a value of zero through 9999.99. |
Each record must contain three commas, one after each field except the last field (even those being left blank), and end with a carriage return.
This record imports the fiscal month of January 2007 that starts on 01-Jan-07 and contains 160 equivalent person month hours.
CAL,01-JAN-07,JAN07,160