To import one-time-dates from an MS-Excel file, use the Import from MS-Excel menu item of the one-time-dates toolbar menu in the holidays manager.

Importing one-time-dates from an Excel file consist of 2 parts:

•Preparing the Excel file.

•Importing into the currently selected holidays set.

Expected Column Layout

To import one-time-dates, make sure your Excel file contains the expected information in the expected columns:

Column A	Column A should contain the date. Date Format  Make sure you enter a date as 1/1/2024 or 3-5-2024, not as free text. If the date you supply is not understood, it will appear as Incorrect Date Format, as shown in the image on the right, in the Date column of the preview grid at the bottom of the import from Excel dialog.
Column B	Column B should contain the abbreviation(s) of the one-time-dates.   Any underscore character "_" (without the quotes) contained in this string will be replaced by a non-breaking space and any tilde character "~" (without the quotes) contained in this string will be replaced by a normal space.
Column C	Column C should contain the symbol(s) of the one-time-dates.
Column D	Column D contains the name of the one-time-dates.   You can include special character markers, such as &t or &s or &c, to include tabulations or returns in the one-time-dates names.   Using additional columns   Generally, the columns E-F-G-... to the right of column D are left empty, but there are cases when you might want to use these columns. Multiple Holidays Sets in the same Excel File If you have 2 or more lists of one-time-dates in the same Excel file, then you can specify, for each importation, which column to use, with column values starting at 4, which corresponds to the default column D. In the example on the right, taken from the middle section of the import from Excel dialog, the importation would use the text of column E as the names of the imported one-time-dates. ➢The importation could then be repeated using column D or G as the source for another holidays set. Multiline One-Time-Date Name Alternatively, you could have each one-time-date made-up of two or more sections that you want to differentiate as they are being imported. In the example on the right, taken from the middle section of the import from Excel dialog, the importation of each one-time-date will add the text from all the columns, separated by the &c hard return code, beginning with column D, until it reached the first blank column. Multiple Formats One-Time-Date Names The number of columns imported can be different for each one-time-date being imported; the concatenation of the columns text will continue for each row until there is a blank value for that specific row. For example, the above text in the Excel file's columns would be imported as follows. Note how the HTML tags and special characters can be placed in their own column, if the formatting has a recurring structure, or it can be mixed in the middle of any of the columns.

Importation Procedure

To import one-time-dates from an Excel file, prepared as described above:

1.Select the holidays set into which you want to import.

2.Use the toolbar menu of the one-time-dates tab of the holidays manager, and select the Import from MS-Excel menu item.

3.At the top of the import from Excel dialog, select an Excel file (both the XLSX and the XLS file extensions are accepted).

4.Use the preview to specify at which row to start the importation (as shown in the example on the right, make sure you do not include title headers in the rows selected for import).

➢IMPORTANT: If the dates you see in the preview are 4 years earlier than what you are expecting to see, then this is due to the way the Excel file was saved on the Macintosh.

5.Decide if you want to import the contents of only one specific column, or of all non-blank columns (in which case you should specify the text to be used to separate each column's text, as shown in the examples of the previous section covering Column D).

6.Click on the import button. Once importation is complete, a dialog will come up informing you of the number of one-time-dates successfully imported.

Contrary to the importation of recurring holidays, at this stage there is nothing else to do, and you can start using the imported one-times-dates immediately.

Topic 170000, last updated on 04-Nov-2023