Use this format to import holiday calendar dates which occur during the contract period. The Holiday Calendar Import differs from the Fiscal Calendar Import in that only new or changed holidays are added or replaced by the import file. An existing holiday calendar will not be replaced, in its entirety, when a new holiday calendar is imported. Any holiday dates not affected by the import file remain unchanged by the import.
The description of a holiday date replaces an existing holiday description only if the holiday description field does not match. A blank holiday description field will not replace an existing one.
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 Characters |
Type |
Field Content |
1* |
3 |
A |
Global import type: enter HOL for Holiday Calendars |
2* |
9 |
A |
Holiday Date to be added or updated Valid Date Formats: See Creating Import Files for details. |
3 |
20 |
A |
Holiday description |
Each record must contain two commas, one after each field except the last field (even those being left blank), and end with a carriage return.
This record imports the Independence Day holiday on 04-Jul-07.
HOL,04-JUL-07,Independence Day