Microsoft excel files – Compix AutoCast 3.1 User Manual

Page 32

Advertising
background image

Chapter 3 Importing Data

In addition to text (*.txt) files, Microsoft Excel files can be used to fulfill templates in AutoCast. Microsoft Excel files can be used with
the MultiData and Watch functions to create one or more pages. While Crawl pages cannot be populated by Microsoft Excel files,
Rolls can and should be treated as still pages.

Prepare the Microsoft

Excel File

For Excel files to properly populate
aliases and create one or multiple
pages, certain conventions must be
followed.
1. Image file names can be used to
access images for populating image
alias objects.
2. The first row of data must be
the list of aliases corresponding to
the alias names within the desired
template.
3. Format the cells to display num-
bers as text to ensure that all data is
displayed as entered.

Microsoft Excel Files

MultiData Function

Create more than one page from
a single Microsoft Excel file. Once
pages are created and added to the
PlayList, their content remains the
same, even if changes are saved to
the original file.

Watch Function

Create one page from a single Mi-
crosoft Excel file. Even after a page
is added to the PlayList, it may be
updated when changes are saved to
the original file.

Alias names corresponding to those in the desired template.

To set up the MultiData function for Microsoft Excel files, follow the steps in the

MultiData Function subsection under the Text Files section in this chapter.

To set up the Watch function for Microsoft Excel files, follow the steps in the Watch

Function subsection under the Text Files section in this chapter.

Tip

All rows following the first contain data to populate the template. Each row populates a new page with the Mul-
tiData function. If using the Watch function, the file would populate only one page using only the second row.

34

Compix Media AutoCast

Document No: 2.3.003 Revision: 2.2 Updated: 9/12/2012

Advertising