Black Box ICOMP, User Manual

Page: 31 / 92

Copyright (c) 2009 - 2012 Black Box Corporation
724-746-5500 | blackbox.com 31
Building a Connection
The general format is:
[player host name]:/[user media folder]/[relative output folder]/
[source data container name]/[source data column name]/nnnnn.txt
The relative output folder is specified on the Location page.
The source data container name setting indicates the source of the data. This is always set to row for the SQL
Connector.
The source data column name is the name of the column for which the results apply.
nnnnn.txt is the filename written, with one file for each column for each record.
nnnnn
is the record number,
counting from one and containing leading zeros to ensure the filename is always 5 digits long.
All files will be written to each iCOMPEL specified in the All Destination Players setting.
The exact location written on each iCOMPEL will be dependent upon the Media Folder folder setting the user
specified for each destination iCOMPEL. The Media Folder folder setting is set per user on the Users page of the
iCOMPEL.
Note during the query execution, exiting files in the folder which match the above pattern (
nnnnn.txt
), but which are
not included in the result of the current query will be deleted. This ensures the content of the folder always exactly
matches the results returned from the last query.
As both the source data container name and the source data column name are used in the filename, the
following characters, if present, will be removed and replaced with an underscore:
\
(backslash)
/
(forward slash)
:
(colon)
*
(asterisk)
?
(question mark)
"
(double quotes)
<
(left angle bracket)
>
(right angle bracket)
|
(pipe)
Note in all cases, the case is preserved, so Name is different from name .
Output Location Example
For example, if the Media Folder for user
fred
is: