Importing Specific Dates Slogans from an Excel File

Navigation:  Slogans > Importing Slogans > From Excel >

Importing Specific Dates Slogans from an Excel File

Previous pageReturn to chapter overviewNext page

Show/Hide Hidden Text

To import specific dates slogans from an MS-Excel file, use the import from Excel button located on the slogans sets toolbar.

 

Importing slogans from an Excel file consist of 2 parts:

 

Preparing the Excel file.

 

Importing into the currently selected slogans set.

 

Expected Column Layout

 

To import slogans, 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 the fully-qualified path to the graphics file (if any).

Column C

Column C contains the slogan's text.

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

Using additional columns

 

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.

 

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.

 

Importation Procedure

 

the file selection at the top of the import from Excel dialog

the file selection at the top of the import from Excel dialog

the specific dates slogans Excel file contents preview

the specific dates slogans Excel file contents preview

To import slogans from an Excel file, prepared as described above:

 

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

2.Use the toolbar menu of the slogans manager, and select the Import from MS-Excel menu item.

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 slogans successfully imported.

See also: importing cyclical and once-only slogans from Excel and importing month and day slogans from Excel.


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