To import month and day 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 consists of 2 parts:

•Preparing the Excel file.

•Importing the Excel file.

Expected Column Layout (preparing the Excel file)

To import slogans, make sure your Excel file contains the expected information in the expected columns (to be sure of using the proper format, make a copy of the Excel template file import_Slogans_MonthDay_XV4.xls located in your c:\qpp\Import\ folder, and use that copy to enter data):

Column A	Column A should contain the month (a number from 1-12)
Column B	Column B should contain the day (a number from 1-31)
Column C	Column C should contain the fully-qualified path to the graphics file (if any).
Column D	Column D should contain the page number of the graphics file of column C, if that file is a PDF or an INDD file.
Column E	Column E contains the slogan's text (if any).   You can include special character markers, such as &t or &s or &c, to include tabulations or returns in the slogans names.   Using additional columns   Generally, the columns F-G-H-... to the right of column E are left empty, but there are cases when you might want to use these columns. Multiple Slogans Sets in the same Excel File If you have 2 or more lists of slogans in the same Excel file, then you can specify, for each importation, which column to use, with column values starting at 5, which corresponds to the default column E. If, for example, you had specified column 6 in middle section of the import from Excel dialog, then the importation would use the text of column F as the names of the imported slogans. ➢The importation could then be repeated using column E or G as the source for another slogans set. Multiline Slogan Text Alternatively, you could have each slogan made-up of two or more sections that you want to differentiate as they are being imported. In the example on the right, taken from the middle section of the import from Excel dialog, the importation of each slogan will add the text from all the columns, separated by the &c hard return code, beginning with column E, until it reached the first blank column. Multiple Formats Slogan Names The number of columns imported can be different for each slogan being imported; the concatenation of the columns text will continue for each row until there is a blank value for that specific row. For example, the above text in the Excel file's columns would be imported as follows. Note how the HTML tags and special characters can be placed in their own column, if the formatting has a recurring structure, or it can be mixed in the middle of any of the columns.

To be sure of using the proper format, make a copy of the Excel template file import_Slogans_MonthDay_XV4.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

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 (both the XLSX and the XLS file extensions are accepted).

4.Use the the Start importing at row number setting 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.Use the Import all columns checkbox to specify 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 covering Column E).

6.Select the Graphics Alignment to use for all the imported slogans. Later, once these slogans have been imported into the slogans database, then you will be able to apply additional options (such as choosing the bounding box of imported PDF files, or choosing the cropping options of imported INDD InDesign files), either for all the slogans of the set or for each individual slogan.

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 specific dates slogans from Excel.

Topic 171610, last updated on 21-Nov-2024