To import Saints from an Excel file, make sure your Excel file contains the information Q++Studio 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
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.
|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++Studio 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.