MediaXtreme MediaZone
Keywest Technology
14563 W. 96
th
Terrace
Lenexa, Kansas 66215
800.331.2019
www.keywesttechnology.com
135
23 Mar 2009
Change 06
The player is also capable of using local Excel data as variables. All the above procedures still
apply, but the player software will recognize a data file extension of .xls as Excel instead of
standard Text.
In this case every worksheet is opened, and every cell that contains data is read, and inserted into
the Player SUBSTITUTE.VAL under the variable name Sheet<sheet><column><row>, where
<sheet> is the number for the sheet (starting at 1), <column> is the name of the column (starting
with A), and <row> is the number of the row (starting at 1). So an example of the first cell in the
first sheet would be Sheet1A1. If the contents of that cell were "Blue", then the line that would
be inserted into the player SUBSTITUTE.VAL would be "Sheet1A1=Blue".
This still requires the user to open SUBSITUTE.VAL on the editor PC and add variables for
each Excel Cell that is planned to be used. An entry of “Sheet1A1=#S1A1” would be
appropriate on the editor pc side (in other-words, on your editor PC, you will have variables
such as #S1A1 on .PAG files, and when those .PAG files play on the player, #S1A1 will be
replaced by whatever data is in the local .xls file listed in the path).
File Transfer Protocol (FTP) Data
Along the same lines as the local file procedures listed above, data may also be stored on remote
FTP servers. These remote files may be Text (.txt) or Excel (.xls) as listed above.
To setup, on the player, follow the above procedures to access the Player’s SETTINGS.INI file.
Open with Notepad and scroll down to the Data Acquisition category, which will appear as
below if no data has ever been entered:
[Data Acquisition]
Ftp Address=
Ftp Folder=
Ftp File=
Ftp Username=
Ftp Password=
Local File=
Ftp Refresh=
Local Refresh=
To access the remote ftp data, we simply must enter the proper FTP data…as follows:
[Data Acquisition]
Ftp Address=ftp.myserver.com
Ftp Folder=mydatafolder
Ftp File=my.txt
Ftp Username=username
Ftp Password=password
Local File=
