Importing Saints/Namedays

Navigation:  Saints and Namedays >

Importing Saints/Namedays

Previous pageReturn to chapter overviewNext page

To import Saints from an Excel file, make sure your Excel file contains the information Q++ expects in the columns where it expects to find it :

 

Column A : Month (a number from 1-12).

 

Column B : Day (a number from 1-31).

 

Column C : Sex (M, F or a blank).

 

Column D : Nameday Name.

 

To be sure of using the proper format, make a copy of the Excel template file

 

 import_Saints.xls

 

located in your c:\qpp\Import\ folder, and use that copy to enter data (or do a cut/paste from another Excel file into that one.

 

Then use the Import button of the Saints and Namedays Manager. The Data Import From Excel dialog then appears :

 

1.Select an Excel file (the dialog accepts both the XLSX file extension as well as the traditional XLS file extension).

 

2.Use the preview to tell Q++ at which line to start the import (make sure you do not include title headers in the rows selected for import).

 

3.If you will always use the same format of displaying the Saints in your diaries, then it might be easier to enter the prefix and name into the column D (eg. Saint Olivier). otherwise you can have just the name in column D (eg. Olivier) and the sex in column C (eg. M). Then you can use a combination of various Saints Tokens to show the name and prefix or just the name.

 

4.Click on the IMPORT button.

 

Once importation is complete, a dialog will come up informing you of the number of Saints successfully imported.


Topic 171510 updated on 24-Apr-2016.
Topic URL: http://www.qppstudio.net/webhelp/index.html?importingsaints.htm