Importing Saints/Namedays Exceptions from Excel

Navigation:  Saints and Namedays > Importing >

Importing Saints/Namedays Exceptions from Excel

Previous pageReturn to chapter overviewNext page
To import saints/namedays exceptions from an MS-Excel file, use the Import button located on the Saints/Namedays Exceptions tab of the the saints and namedays manager.

 

Importing saints/namedays exceptions from an Excel file consist of 2 parts:

 

Preparing the Excel file.

 

Importing into the currently selected holidays set.

 

Expected Column Layout

 

To import saints/namedays exceptions, 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/2021 or 3-5-2021, 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 M or F or nothing to indicate the gender.

 

If always use the same format of displaying the saints/namedays exceptions in your diaries, then it might be easier to enter the prefix and name into the column C (eg. Saint Olivier). Otherwise you can have just the name in column C (eg. Olivier) and the gender in column B (eg. M), in which case you can use a combination of various saints tokens to show the name and prefix or just the name.

Column C

Column C contains the saints/namedays exceptions name.

You can include special character codes, such as &t or &s or &c, to include tabulations or returns in the saints/namedays exceptions names.

Column D-E-F--...

Generally, the columns D-E-F-... to the right of column C 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 saints/namedays exceptions 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 saints/namedays exceptions.

The importation could then be repeated using column D or G as the source for another holidays set.

 

Importation Procedure

 

the Import from Excel dialog

the Import from Excel dialog

 

To import saints/namedays exceptions from an Excel file, prepared as described above:

the Excel file contents preview

the Excel file contents preview

 

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

2.Use the Import button located on the saints/namedays exceptions tab of the the saints and namedays manager.

3.At the top of the import from Excel dialog, select an Excel file (the dialog accepts both the XLSX file extension as well as the traditional XLS file extension).

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).

5.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.

6.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).

7.Click on the Import button. Once importation is complete, a dialog will come up informing you of the number of saints/namedays exceptions 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 saints/namedays exceptions immediately.


Topic 171520 updated on 19-Feb-2019.
Topic URL: https://www.qppstudio.net/webhelp_xv4/index.html?importingnamedays.htm