|
Importing Namedays |
  
|
Importing Namedays
|
Importing Namedays |
|
To import Namedays 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 : Date.
•Column B : Sex (M, F or a blank).
•Column C : Nameday Name.
When entering dates into your Excel file, make sure you enter a date as 1/1/2001 or 3-5-2001, not as free text. To be sure of using the proper format, make a copy of the Excel template file
import_Namedays.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. |
| 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. | 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. Click here for more information. |
| 4. | Click on the IMPORT button. |
Once importation is complete, a dialog will come up informing you of the number of Namedays successfully imported.