Importing Specific Dates Slogans from an Excel File

Navigation:  Slogans > Importing Slogans > From an Excel File >

Importing Specific Dates Slogans from an Excel File

Previous pageReturn to chapter overviewNext page

To import Specific Dates Slogans 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 : The fully-qualified path to the graphics file (if any).

 

Column C,D,E, ... : Slogan Text (see the import dialog for more info).

 

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_Slogans_SpecificDates.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 Slogans 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.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 Slogans successfully imported.


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