Black Box ICOMP Скачать руководство пользователя страница 76

Страница: 76 / 92

724-746-5500 | blackbox.com

iCompel Data Engine - User Guide (V3.1.2)

Source Microsoft Excel spreadsheet

The above screen shots use the following spreadsheet (top left cell is

). This spreadsheet is included in the '

Black

Box Corporation iDE Media\ExcelExample

' folder as

huntley_sales.xls

Содержание ICOMP

Страница 1: ...iCompel Data Engine V3 1 2 V3 1 2 30971 Set up vibrant real time digital displays easily and affordably All in one plug and display unit works right out of the box...

Страница 2: ...case the user at his own expense will be required to take whatever measures may be necessary to correct the interference Changes or modifications not expressly approved by the party responsible for co...

Страница 3: ...del alcance de fuentes de calor como radiadores registros de calor estufas u otros aparatos incluyendo amplificadores que producen calor 11 El aparato el ctrico deber ser connectado a una fuente de po...

Страница 4: ...isher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While...

Страница 5: ...vanced Settings 26 2 4 Results 27 2 4 1 XML Output Format 28 2 4 2 Locating Media Items using the Media Item Finder 29 Copying and Modifying Media Items 30 2 4 3 Text Output Format 32 2 4 4 Custom Out...

Страница 6: ...System 58 6 3 Connecting to a Black Box iDigitalManager 7 62 Using the Excel Connector 62 7 1 Advanced Excel Settings 8 66 Using the Microsoft Exchange Connector 66 8 1 Advanced Exchange Server Setti...

Страница 7: ...Part I iCompel Data Engine Overview...

Страница 8: ...em The iCompel Data Engine product comprises of three components A manager application the Connection Manager which allows the user to manage which queries will be run automatically The Connection Man...

Страница 9: ...Part II Building a Connection...

Страница 10: ...ervice 2 1 The Connection Editor Application The iCompel Data Engine iDE Connection Editor is a Microsoft Windows application that allows the user to create view update and test iDE Connections This s...

Страница 11: ...st Query button and confirm that no errors are shown Please refer to the Connection Manager QuickStart section for details on how to add and automatically execute this Connection 2 3 Connectors and Da...

Страница 12: ...y the changes Note This Connector may require an additional license to operate 2 3 1 1 Basic Settings The Excel Filename field specifies the Microsoft Excel file the iCompel Data Engine iDE should pro...

Страница 13: ...t a named range then enter the range name only To select a range of cells from different worksheets then enter the specify worksheet name and cell range as above and surround with square brackets sepa...

Страница 14: ...y to provide hints to the iCompel Data Engine iDE about how dates and numbers are represented in the spreadsheet This is particularly important when the file contains values whose interpretation is la...

Страница 15: ...e spreadsheets By default this option is enabled Specifying Advanced Query Settings The Advanced Settings mode provides fine grained control over the data processed and written by the iDE It will not...

Страница 16: ...Pack 1 and above If earlier versions of Exchange Server are in use please use the WebDAV query method instead The query method in use is summarized at the bottom of the the Exchange page and can be al...

Страница 17: ...anced Microsoft Exchange Server Settings page provides fine grained control over the settings used to query the Exchange Server It will not normally be necessary to modify these settings 2 3 3 Google...

Страница 18: ...C to access and query the database In order to use the SQL Connector the user must create one or more valid ODBC System Data Source Name System DSN entries on the local PC Further information on this...

Страница 19: ...es it will be necessary to write data values using a specific locale representation The Write all data values using the following culture setting controls this If this option is enabled then a summary...

Страница 20: ...he XML Location page specifies where the XML will be retrieved from Schema Page The Schema page defines which element and attributes should be retrieved This setting allows the fields unused by the me...

Страница 21: ...the Schema tree Expand only Enabled Items Expands all enabled items and collapses the remainder Enable all Items This will enable all items Disable all Items Disables all items 2 3 6 Text Connector T...

Страница 22: ...Copyright c 2009 2012 Black Box Corporation 724 746 5500 blackbox com 22 iCompel Data Engine User Guide V3 1 2 2 3 6 1 Basic Settings The Text page specifies where the text data will be retrieved from...

Страница 23: ...mat if applicable This is the default setting Use custom schema information settings The specified settings will be used This option provides very fine grained controlled over the file format Please r...

Страница 24: ...ecifying Column Headings The Column headings entry indicates how the iCompel Data Engine should detect column headings in the data The following options are available First row contains column heading...

Страница 25: ...eted as 1st of April in the UK or the 4th of January if in the US The Processing setting specifies the culture setting used when processing dates and numbers Note this setting does not control how dat...

Страница 26: ...tings will be shown the Text page Click the Advanced Settings button on the Text page to view or modify the settings Check the Enable advanced query capability box to configure the advanced query sett...

Страница 27: ...equired Note This format should be used when displaying included results on a iCOMPEL iCOMPEL Please ensure the included media Widgets Layout Packages are installed on each Destination Player before p...

Страница 28: ...tten on each iCOMPEL will be dependent upon to the Media Folder folder setting for the specified Username for each destination iCOMPEL The Media Folder folder setting is set per user on the Users page...

Страница 29: ...ng the Copy button These features are described on the following page Only the media items that are able to display the specified Data Source are displayed To display all results enable the Show all M...

Страница 30: ...mn are placed in a single folder providing easy grouping The Text file output format allows the results to be formatted displayed and managed using native iCOMPEL mechanisms which offers a number of b...

Страница 31: ...ination 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 settin...

Страница 32: ...be written Filename Filename Content ftp Player11407 media media dynamic_sample output row Name 00001 txt Joe Blogs ftp Player11407 media media dynamic_sample output row Name 00002 txt Janes Smith ftp...

Страница 33: ...ia item on the iCOMPEL should be set to UTF 8 Presentation Format File The Presentation Format file can be any text based format including HTML and XML and can have any extension Within the Presentati...

Страница 34: ...will be substituted exactly Encoding Data Values To ensure content is correctly interpreted values written to XML or HTML files will be encoded escaped The following characters are replaced Character...

Страница 35: ...and containing leading zeros The ext is the filename extension and is identical to the Presentation Format filename Note during the query execution exiting files in the folder which match the above p...

Страница 36: ...to copy results to are specified in the following control The list shows all iCOMPEL s the result s will be copied to At least one iCOMPEL s must be specified in order to successfully execute the que...

Страница 37: ...or network bandwidth concern when copying large numbers of results To use this setting check the Enable limit option and specify a number greater than zero in the limit count entry Note for performan...

Страница 38: ...plied when the Connection is made Active and not when the Connection is tested in the Connection Editor Please refer to the Managing Active Connections section for more information 2 6 Connection Prop...

Страница 39: ...Part III Monitoring and Managing Connections...

Страница 40: ...Connection Manager application will show a warning message if the iDE Service could not be contacted To automatically execute the Connection according to the schedule specified by the Connection it m...

Страница 41: ...citly requested to do so Please ensure anti virus and firewall software is set to allow the iCompel Data Engine to communicate with the iCompel Data Engine Service The Connection Manager application w...

Страница 42: ...nection open the Connection menu and select View Status Messages 3 4 Managing Connections The Active page shows the details and status for all Active executing Connections and allows Active Connection...

Страница 43: ...Actions page Undo or revert Changes If an action has been successfully performed a record of the action will be added to the Outstanding actions page The action can be undone by either Selecting the A...

Страница 44: ...then click the View button To view the currently Active Connection select the Connection in the Active page If there are modifications then the original Active Connection will be marked as read only...

Страница 45: ...status messages can be retrieved by clicking the Refresh button 3 5 Bulk Modify Connections If a new iCOMPEL iCOMPEL is added to an existing signage network or a iCOMPEL is replaced or user credentia...

Страница 46: ...Player network host name or IP address The Username and Password field specify the credentials for iCOMPEL defined user All fields must be specified Note the player is not added if doing so would exce...

Страница 47: ...al to complete and automatically delays for a period of time if two scheduled simultaneous execution times have been missed The backoff time is dependent upon the Connection schedule as follows Period...

Страница 48: ...e Log messages will configure the Service to show detailed status messages These are typically used to diagnose problems Clear Log file when Service is started This setting is typically used to assist...

Страница 49: ...Part IV Application Licensing...

Страница 50: ...o receive the product License file Note the license is specific to the machine running the Wizard and is not transferable Licensing will need to be completed successfully on each Windows machine that...

Страница 51: ...n Licensing Adding a new License A new License can be added from the Add page Only licenses for this iCompel Data Engine installation on the local machine can be applied The application will restart w...

Страница 52: ...Copyright c 2009 2012 Black Box Corporation 724 746 5500 blackbox com 52 iCompel Data Engine User Guide V3 1 2...

Страница 53: ...Part V Deployment Considerations...

Страница 54: ...report The iDE media deployed to the Publisher must contain all required data values and special media to extract and correctly process Local Information values This is more flexible but has the same...

Страница 55: ...Media Folder is set to the folder containing the iDE media If deploying to multiple Players from a single Connection all Users referenced by the Connection must specify the same iCOMPEL User Home Fol...

Страница 56: ...Part VI Using the SQL Connector...

Страница 57: ...lp file 6 2 Using the SQL Connector on a 64bit Operating System This section is only relevant if the iCompel Data Engine is deployed to a 64bit operating system While the iCompel Data Engine will run...

Страница 58: ...tgreSQL ODBC driver psqlodbc_08_03_0400 zip from http wwwmaster postgresql org download mirrors ftp odbc versions msi psqlodbc_08_03_0400 zip 2 Open the ZIP file and execute the file psqlodbc msi This...

Страница 59: ...the Save button The System DSN should now appear in the list in the System ODBC Data Source Name list on the SQL Command tab in the Connection Editor You may need to click the Refresh button to updat...

Страница 60: ...data series orientation row Normally if we have a single row of data we don t have enough data to auto detect row headings Force detection for single row results such as this data process row_heading...

Страница 61: ...Part VII Using the Excel Connector...

Страница 62: ...is is specified by the Cell Range field The contents of the SELECT field will be processed to ensure field names are surrounded by square brackets Surround the SELECT field entry with double quotes to...

Страница 63: ...data output Note the result should be displayed using tabular media as only one record is present Data Detection and Scan Settings By default the Excel driver will examine the first 8 rows of data to...

Страница 64: ...Copyright c 2009 2012 Black Box Corporation 724 746 5500 blackbox com 64 iCompel Data Engine User Guide V3 1 2...

Страница 65: ...Part VIII Using the Microsoft Exchange Connector...

Страница 66: ...grained control over the settings used to query the Exchange Server It will not normally be necessary to modify these settings If Advanced Settings have been specified then a summary of the current se...

Страница 67: ...A call call name galfind If OWA is not enabled on your Exchange Server or is not accessible then please disable this feature If this feature is disabled then the resource alias must be entered in the...

Страница 68: ...Part IX Using the Google Calendar Connector...

Страница 69: ...c Please refer to the Google documentation to determine how to make your Calendar public Determine the unique Google Calendar URL 1 Open the Google Calendar page in a web browser 2 Click the Settings...

Страница 70: ...Part X Media Widgets...

Страница 71: ...d in the Widget Settings section 10 1 Installing Sample Layouts and Widgets All Media Widgets can be installed directly on the player using the iCOMPEL Layout Package feature Layout Packages are self...

Страница 72: ...t will be shown indefinitely To resume the programmed Schedule click the Activate Schedule and Layouts button at the top of the screen 10 2 Charts and Tabular Widgets Tabular Widget The Tabular widget...

Страница 73: ...Copyright c 2009 2012 Black Box Corporation 724 746 5500 blackbox com 73 Media Widgets Bar Chart Widget Using the default bar chart Widget settings results are shown as follows...

Страница 74: ...opyright c 2009 2012 Black Box Corporation 724 746 5500 blackbox com 74 iCompel Data Engine User Guide V3 1 2 Line Chart Widget Using the default line chart Widget settings results are shown as follow...

Страница 75: ...Copyright c 2009 2012 Black Box Corporation 724 746 5500 blackbox com 75 Media Widgets Pie Chart Widget Using the default pie chart Widget settings results are shown as follows...

Страница 76: ...x com 76 iCompel Data Engine User Guide V3 1 2 Source Microsoft Excel spreadsheet The above screen shots use the following spreadsheet top left cell is A1 This spreadsheet is included in the Black Box...

Страница 77: ...ow event summaries for between a week and a month The diary Widget shows all events with all day events spanning the days on which they apply and appear with a solid background Up to six different res...

Страница 78: ...ll events except all day events are shown Up to six different resources can be represented on a single Timeline widget Different resources are shown in different colors and in separate columns The min...

Страница 79: ...file as it is possible to stop the media from displaying correctly If this is done the original configuration file can be found in the Black Box iDE Media media source folder Many other options are a...

Страница 80: ...tyle and Update Options application display_style This mandatory parameter specifies how the data should be shown One of the following values must be specified case is not important TABULAR LINE_CHART...

Страница 81: ...O Examine the data to determine if row headings are present This is the default value YES Assume first row is column headings NO Assume no column labels are present data headings column_labels data he...

Страница 82: ...e shown on alternate row a zebra strip Default is true specifying the zebra strip will be shown tabular zebra background_colour Optional value which specifies the Zebra strip background color If the c...

Страница 83: ...he bar colors Specified as a list of colors with prefixing hex symbol with the pipe symbol separating values chart series line_width The width in pixels of each Line Chart series line Optional and def...

Страница 84: ...ARY TIMELINE ROOM_SUMMARY Diary and Timeline Display Options calendar options day_count Number of days to display If specified this must be a positive number For the Timeline Widget this defaults to 3...

Страница 85: ...splay The following views are available DAY WEEK MONTH The default is week calendar diary week_starts_on Day number the week starts on expressed as 0 6 where 0 is Sunday Defaults to 1 for Monday 10 4...

Страница 86: ...central readout panel The default value is Available calendar room_summary label event free The label used for free timeline events The default value is Free calendar room_summary label timeline toda...

Страница 87: ...Part XI Contact Black Box...

Страница 88: ...com 88 iCompel Data Engine User Guide V3 1 2 11 Contact Black Box If you have any questions about the iCompel Data Engine or iCOMPEL please contact Black Box Network Services on Name Contact Email te...

Страница 89: ...us Messages 44 Connection Windows Service Overview 40 Connector Microsoft Excel 12 Microsoft Exchange Server 16 SQL 18 Text 21 22 23 25 Text Connector query settings 25 Text format 23 XML 19 20 Contac...

Страница 90: ...g installed Licenses 50 Limiting record count 36 Log Files Configuration 47 Diagnostics 47 View 47 M Managing Connections Adding 42 Creating 42 Outstanding Actions 43 Overview 42 Removing 42 Viewing o...

Страница 91: ...t Details and settings 30 U Updating Media Item properties 29 User Management 55 V View Status Messages Overview 41 44 W Widget Configuration Bar chart 82 Bar chart Widget settings 80 Diary 85 Diary W...

Страница 92: ...tection products to media converters and Ethernet switches all supported by free live 24 7 Tech support available in 30 seconds or less Copyright 2010 All rights reserved Black Box and the Double Diam...

Результаты поиска

Содержание ICOMP

Отзывы:

Похожие инструкции для ICOMP

Бренды по названию

Популярные бренды

Black Box ICOMP, Руководство пользователя

Результаты поиска

Содержание ICOMP

Отзывы:

Похожие инструкции для ICOMP

Бренды по названию

Популярные бренды