Data Mining ActiveX
Contents
1. 0 0cccccee cece eect eee eee eee ee eee eee eee nnns sss senes ananas 7 CONNECTING TO A MULTIDIMENSIONAL DATA MINING DATA SOURCE c cccccccccccccncnnnnnnnnnonononononnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnos 11 CONNECTING TO A ONE DIMENSIONAL DATA MINING DATA SOURCE sese nhhnnh nennen nnne 14 FONT lee 17 GOLUNMNS ALAS T E T 18 GREATING COLUNIN unico 18 PIDIN COLUMN E PN 20 WEBAGGES Sisuratan HR 21 VIEWING DATA IN THE RUNTIME GRID eelseseeeseeeeeeeee nnne nnnm nnnm nnne nnn nnn nnn nenne nnn nnns nnns 22 TE SUNG YOURDATA TAC Sd ete ee e e reos 22 VIEWING ONE DIMENSIONAL ARRAYS oococcccccccoonoooonnnnnnonnnnncnnnonnnnn RRE nn nnne ner nnns 23 VIEWING MUCTIDIMENSIONAL ARRAY Sid cence eect inn da eel E en tpt De ts 24 vim ereweroisi usi 25 REFRESHING THE DATAGRID cosas 26 DATA MINING ACTIVEX OLE AUTOMATION REFERENCES sess nn nennen nennen nnns enar nnn nnns 26 AUTOMATION INTERFACE Saa ti 26 CONTROL PRORER TIE S tornillo iia 27 CONTROEMETTODS ato olle dias 31 Ill Data Mining ActiveX User s Manual IV Introduction Data Mining ActiveX DATA MINING ACTIVEX2. Macros Employees Order Details Orders Products Modules Shippers EEEHBSEEHG E Groups Suppliers Customers Table in Northwind Database 6 The selected data tag appears in the Data Mining Properties dialog box under the Point Name list as shown in the figure below You have the following additional options e Add Tags You can choose additional data items to add to the list When multiple data items are selected click the up and down arrow buttons to change the order in which the data items are displayed in the Data Mining ActiveX Grid The Position number indicates the position of each data item in the grid display e Change Tag Opens the Unified Browser enabling you to replace the currently selected data item with a different data item e Delete Tag Removes the selected data item from the list e Show Path Displays the full path i e server name and location of the selected data item s Data Mining Properties DataSourcell4 T ag4 Change Tag Delete Tag Show Path Cancel Help Data Mining List of Tags Present Inside the Grid T Click OK to return to the General tab Then click OK again When you enter the display into runtime mode you will see the multidimensional array of data items from the Customers table displayed in the Data Mining Grid as shown in the figure below The columns of data e g Customer ID Company Name Contact Name Contact Title etc match the columns in the 13 D
3. opc oa Database Access E 2h Databases Fy Aocess_onmection Doun HEJ DetaSourcell 8 armrecordset Ed Datasourcene M amrefresh E EJ DataSourcen3 GDL astScanTine 3 DataSource 4 28 ERE CategoryN f DataSourcens5 Selecting a Data Tag From the Unified Data Browser 5 This example data access tag AccessConnection DataSource04 Tag4 is a multidimensional array i e reads data from multiple columns in the specified database table that reads data from the Customers table in the Northwind mdb database The figure below shows this table as viewed in Microsoft Access As you can see it has several columns of data e g Customer ID Company Name Contact Name Contact Title etc Click OK Data Mining ActiveX ES Customers Table EBBITTTTIUNETTTUUITUTERESTTTICTTIEENTTCUNDTEENUNNNI IIT TERES ALF Alfreds Futterkiste Maria Anders Sales Representative Obere Str 57 ANATR Ana Trujillo Emparedade Ana Trujillo Owner Avda de la Constitucit ANTON Antonio Moreno Taqueri Antonio Moreno Owner Mataderos 2312 AROUT Around the Horn Thomas Hardy Sales Representative 120 Hanover Sq BERGS Reralunds snahhk n Christina Reralor Order Administrator Hernvsv nen H BLAUS ER ets n BLONP BOLID BONAP BOTIM amp H Tables mo Create table in Design view Create table by using wizard BSBE CACTU P Create table by entering data ge Queries Categories Ea Forms E Record 14 4 4 i Reports a Pages
4. Description Sets gets the widths for the horizontal or vertical grid lines when corresponding grid line style property GridHorizLinesStyle or GridVertLinesStyle is set to 1 solid line For all other line styles these properties must be set to 1 Example Sets both horizontal and vertical grid lines to solid line style 2 pixels wide ThisDocument DBMining1 GridHorizLinesStyle 1 ThisDocument DBMining1 GridVertLinesStyle 1 ThisDocument DBMining1 GridHorizLinesWidth 2 ThisDocument DBMining1 GridVertLinesWidth 2 GridTitleBackColor Type OLE COLOR Description Sets gets the background color for the grid s title bar Example Sets title bar background color to dark blue ThisDocument DBMining1 GridTitleBackColor GRB 0 0 127 GridTitleTextColor Type OLE COLOR Description Sets gets the text color for the grid s title bar Example Sets grid s title bar text color to yellow ThisDocument DBMining1 GridTitleBackColor GRB 255 255 0 HeaderColor Type OLE COLOR Description Sets gets the background color for grid s column headers Example Sets color of grid s column header to dark green ThisDocument DBMining1 GridTitleBackColor GRB 0 127 0 IsConnected Type Boolean Description This is read only property indicating that control is connected to the server Example If ThisDocument DBMining1 IsConnected Then gt do something here End lf 29 Data Mining ActiveX User s Manual 30 MaxRecord
5. My Configs cfg dbm LoadConfigURL BSTR newVal as Boolean Loads the configuration file specified in the URL string newVal Example Dim ret As Boolean ret DBMining1 LoadConfigURL http localhost cfg dbm ReplaceHost BSTR OldHostName BSTR NewHostName as Long It works over data source tags data mining tags and path name attributes and replaces node name substring within URL path only Returns 0 on success and HRESULT when something fails Example similar to ReplaceTag VBA example works only in configure mode replaces host name in whole display Dim Status As Long Status ThisDisplay ReplaceHost Host1 Host2 if Status lt gt O then there was no replacement performed or an error occurs If Status 0 Then MsgBox No replacements Else MsgBox Tags replaced End lf ReplaceHostEx BSTR OldHostNameSubstring BSTR NewHostNameSubstring BOOL MatchCase BOOL MatchWholeWord as Long It works over data source tags data mining tags and path name attributes and replaces node name substring within URL path only and supports case sensitivity wildcard strings and MatchWholeWord flag Returns 0 on success and HRESULT when something fails Example 31 Data Mining ActiveX User s Manual 32 similar to ReplaceTag VBA example works only in configure mode replaces host name in whole display regarding case and whole words options Dim Status As Long Status ThisDisplay ReplaceHostEx Host1 H
6. Applications VBA and Microsoft Visual C Data Mining ActiveX To access the Automation interface from VB and VBA the Data Mining ActiveX must be made available by choosing Project gt Components from the main menu in the VB or VBA development environment and selecting Smar DBGrid in the list of available components Control Properties AutoSelectRow Type Boolean Description If true when the user clicks on a cell the whole row will be highlighted AutoUpdatelnterval Type Short Description Sets gets the number of seconds between automatic updates Available only for ADO connections Example ThisDocument DBMining1 AutoUpdatelnterval 60 BackColor Type OLE_COLOR Description Sets gets the background color of the column Example Dim column As OGridColumnWrapper Set column ThisDisplay DBMining1 GetColumn 1 column ModifyBackColor True column BackColor RGB 0 255 0 The above example will change the background color for column 1 to green BlinkOnUpdate Type Boolean Description Sets gets whether or not the Database Mining ActiveX will blink on update Example ThisDocument DBMining1 BlinkOnUpdate True BorderType Type String Description Sets gets control s border appearance Can be one of the following 0 none 1 flat border 2 8D border Example Sets 3D look for the control s border ThisDocument DBMining1 BorderT ype 2 ConnectionString Type String Description Sets
7. The Data Mining ActiveX is included in the ProcessView installation and it can be inserted into any container that has the capability to embed ActiveX objects including GraphWorX Visual Basic forms Microsoft Word and Microsoft Excel The basic purpose of the Data Mining ActiveX is to read data from a specified data source e g Microsoft Access Microsoft SQL Server and ODBC databases and display the chosen data set in a data grid during runtime mode Data Mining ActiveX Features Key features of the Data Mining ActiveX include e Data Mining Grid for displaying data during runtime e Support for open database connections including Microsoft Access Microsoft SQL Server Microsoft Excel Oracle and ODBC databases e raceWorX support e Global aliasing support e Column aliasing for data items e Column hiding e Auto manual grid refresh updates e View the Data Mining ActiveX via WebHMI Inserting the ActiveX Into a Display To insert the Data Mining ActiveX choose Insert Object from the Edit menu in GraphWorX or click the Data Mining ActiveX button on the ActiveX toolbar The Data Mining ActiveX will appear as shown below Tenine Tag Messa AURA Verd ile of ange foo ly 4 AOS i EUR e jer S a sae eae Oe nee oats EE NETUS ay NAR EA A QUE Coal eak cede TTT 7 Ce SACR RM omquesser COMPETIDO S nave E ELIT P Hamer e oes E a muse TENIA fi Data Mining ActiveX Data Mining ActiveX User s Manual D
8. column position 3 and another for column position 13 can also click the button to select a global alias from the global alias browser 18 Data Mining ActiveX Column Alias Property E E X Alias Mame Column Position Column 1l cena Column Alias Property 3 The new column alias and position number appear in the under the Column Name list as shown in the figure below You have the following additional options e Add Alias You can add additional column aliases to the list When multiple column aliases are selected click the up and down arrow buttons to change the order in which the columns are displayed in the Data Mining ActiveX Grid The Position number corresponds to the position of each data item in the Grid display e Delete Alias Deletes the selected column alias from the list e Rename Column Alias Enables you to change the name of the selected column alias e Column Alias Properties Opens the Column Alias Property dialog box for the selected column alias General Fonts Columns Alias Web Access Position Add Alias E Colia Taba H Rename Column Alias a Delete Alias Column Alias Properties Show Columns M Header Show Rows Mw Header Cancel Apply Help Editing Column Alias Properties 4 When you enter the display into runtime mode you will see the associated data items displayed in the Data Mining Grid with the substituted column aliases a
9. side To do that you have to check the quality of your data tags using OPC DataSpy 1 Start OPC DataSpy from the Windows Start menu by selecting Programs gt ICONCS ProcessView gt OPC DataSpy 2 In OPC DataSpy expand the tree control and browse to your data tag Right click on the data tag s and select Monitor from the pop up menu as shown in the figure below Data Mining ActiveX S tG OPC Items E E My Computer ESI DPC Data Access m E SMAR AlarmServer 1 l pgs SMAR DatabaseOPCServer 3 5 AccessConnection 15 DataManipulahor 1 5 DataSource t 9 Data5ouros02 j BColumn 2 palastscanTime E imauecordset gj Darefresh Mol gt gt Datasa 4 5 DataSov 2 Dataso DER A lc4t Browsing for Data Tags in OPC DataSpy 3 The data tag s now appear in under the Data Monitor tree control as shown in the figure below The tag quality is indicated in the right hand pane If the tag quality is good then the tag is ready for data mining If the tag quality is bad go back to the Database Mining Configurator and check your data source and data item configurations ELT OPC Items Name mmm Source Value Qualty T Nader il SMAR DatabaseOPCServer Ac Eat A Good Non specific Bs Network Neighborhood Mb Internet ith Ger amp roker El gl Connected JE GenBreker Mordor El Data Monitor i SMAR DatabeseOPCSer 2 Alarm Monitor Data Tag Quality Indicated in DataSpy Data M
10. AA USER S MANUAL iveX Acti ining Data Mining ActiveX Data Mining Activex eee pps mene cee E nee o re E arman 030 00 030 0 5 555 bb Mun eget EN 7 DE 71 rasa EST Genet ee puc i 0621 0 0621 UCR EAHA Bee SN 88 60 1 88 60 qm AAA Canes Congressar o El sues Inii Harid noct I ei 55 e J5 Data M 91 24 491 24 a 604 5 604 071 5 n 1 195 j 13 5 555 5 55 0452 0 a 1 55 _ 171 5 171 0241 0 0241 140 678 4067 _ 171 5 171 i ai 7675 3 7675 Familia Arquibal Aria Cruz Marketing A Rua Or S30 SP 05442 030 Brazil 11 55 ANAL euelsus n Su MAY 06 Data Mining ActiveX VERSION 8 PVI EWDMI ME Specifications and information are subject to change without notice Up to date address information is available on our website web www smar com contactus asp Table of Contets TABLE OF CONTENTS DATA MINING ACTIVEX qum ER 5 INTRODUCTION cri e e e a a a a 5 DATA MINING ACTIVEX FEATURES scssi e e a R a E ao a a a a eea a E 5 INSERTING THE ACTIVEX INTO A DISPLA Enri 9 DATA MINING ACTIVEX PROPERTIES o ooccccccnocccnnccononccnncccnooccnnconnnconcnonnnncnnononnnncnnnnonnnnrnnnnnnnrnnnrnrnnnrnnnonrnnnnrnnnonnnanennnos 6 GENERA PLI 6 CONNECTING TO AN ADO DATA SOURCE
11. Data Mining Activex Customer D CompanyName Contacte ContactTite Adress Ciy Region PostalCode country Phone Fax Alfreds Futterkis Maria Anders Ana ius aus Ana WE Bon app Eitu Dollar M Elizabeth Li Familia Arquibal Aga Cruz Sales Repre Obere St Berli Owner e MERA A Rua Or So SP 12209 T2F 8M4 EC2 ENT 1010 05442 030 German 030 00 030 0 Mexico 5 555 5 55 Mexico 5 555 UK 1705 070 Dee 912449124 Canada 604 5 604 UK 171 5 Argentin 1 Dune 51788 Viewing Data Items in Runtime Mode Multidimensional Array Data Mining ActiveX Viewing Combined Arrays It is possible to view data from a one dimensional array and data from a multidimensional array in the same grid display For example the data tags selected in the Data Mining Properties below contain two different types of arrays Tag2 is one dimensional and Tag4 is multidimensional Tag2 will yield only one column of data in the grid display while Tag4 will produce many columns When you enter the display into runtime the data from both arrays will be displayed side by side in the Data Mining ActiveX Grid Data Mining Properties E d E X T Add Tags DataSourcel Tag DataSourcell4 T ag4 2 E Change Tag Delete T ag Show Path LIF Cancel Help Data Mining Properties Combining Data Sources Thus it is recommended that you use some column aliases to distinguish between the two di
12. Design view pelos Create table by using wizard up Create table by entering data Queries Categories Forms ic usto mers Employees Order Details Orders Products Shippers Suppliers Customers Table in Northwind Database The selected data tag appears in the Data Mining Properties dialog box under the Point Name list as shown in the figure below You have the following additional options Add Tags You can choose additional data items to add to the list When multiple data items are selected click the up and down arrow buttons to change the order in which the data items are displayed in the Data Mining ActiveX Grid The Position number indicates the position of each data item in the Grid display Change Tag Opens the Unified Browser enabling you to replace the currently selected data item with a different data item Delete Tag Removes the selected data item from the list Show Path Displays the full path i e server name and location of the selected data item s Data Mining Properties Add Tags DataS ourcell Tage Change Tag ui Delete T aq Show Path Cancel Help Data Mining List of Tags Present Inside the Grid Click OK to return to the General tab Then click OK again When you enter the display into runtime mode you will see the one dimensional array of data items from the Customers table displayed in the Data Mining Grid as shown in the figure below The grid displays the entire rowset A
13. NTON in the Customer ID column in the connected Northwind mdb database as defined by the connected AccessConnection DataSource02 Tag2 data tag Data Mining ActiveX The array can be a horizontal array i e view an entire rowset or it can be a vertical array i e it shows the values in a column No matter what array you want to view in the grid it is always shown as a column Thus even though the example shown in the figure below displays a rowset the data in the row are displayed in the grid as a column Data Mining Activex CustomerlD Viewing Data Items in Runtime Mode One dimensional Array NOTE If you want to browse for data mining tags on a remote computer go to the OPC DA tab of the Unified Data Browser and browse to the computer in the Network Neighborhood tree Fonts The Fonts tab of the Data Mining ActiveX Properties dialog box shown below is similar to many fonts property screens The Font field determines the font and the Font Style field determines whether the text will be Regular Bold Italic or Bold Italic The Effects section allows for strikeout or underlining and the Sample section shows a real size example of the font style and size you have chosen General Fonts Columns Alias web Access Property Mame Font Font Font Style Size vis Sans Serif Regular 12 Tp Modem No 20 Effects Strikeout Underline Tr Monotype Corsiva Sample Tr Monotype Sorts Tp Monotyp
14. a Mining radio button on the General tab of the Data Mining ActiveX Properties dialog box 2 Click the Connection parameters button This opens the Data Mining Properties dialog box as shown below 3 To create a connection click the Add Tags button as shown in the figure below Data Mining Properties Delete Tag Change Tag Show Path Cancel Help Data Mining Properties I 14 Data Mining ActiveX 4 This opens the Unified Data Browser Select one or more data tags from the Unified Data Browser as shown in the figure below In this example we will use the following one dimensional database mining tag SMAR DatabaseOPCServer 3 AccessConnection DataSource02 Tag2 This tag is defined in the DBOPCServerExample mdb example data mining configuration database which is included in the ProcessView installation in the Program Files Smar ProcessView Examples Database Mining Examples directory This configuration database connects to the Northwind mdb Microsoft Access database For more information about database mining examples configuring database access items and how to load the DBOPCServerExample mdb configuration database please refer to the Database Mining Configurator help documentation For an example of how to use global aliasing in the Data Mining ActiveX please refer to the DBOPC GlobalAlias gdf file in the Program Files Smar ProcessView Examples Database Mining Examples directory in the ProcessView installat
15. ata Mining ActiveX User s Manual connected Northwind mdb database as defined by the connected AccessConnection DataSource04 Tag4 data tag Data Mining Activex Joustomerio CompanyName ContactName ContactTite Adress Joy Region PostalCode country Prone Fax Alfreds Futterkis Maria Anders Sales Repre Obere St Berli 12209 German 030 00 030 0 05021 Mexico 5 555 5 55 05023 Mexico 5 555 WAITDP UK 171 5 171 5 95822 Sweden 0921 1 0921 German 0621 0 0621 France 88 60 188 60 Spain 91 55 91 5 France 9124491 24 T2F8M4 Canada 604 5 604 ECZ EHT iUK 75 1010 Argentin 1 135 1 13 05022 Mexico 5 555 5 55 Switzerl 0452 0 05432 043 Brazil 11 55 WX16LT UK 171 5 171 52066 German 0241 0 0241 France 406784067 UK 171 5 171 Ernst Handel Austria 7675 3 7675 Familia Arquibal Aria Cruz Markoni A Rua Or So SP 05442 030 Brazil 11 55 Viewing Data Items in Runtime Mode Multidimensional Array NOTE If you want to browse for data mining tags on a remote computer go to the OPC DA tab of the Unified Data Browser and browse to the computer in the Network Neighborhood tree Connecting to a One Dimensional Data Mining Data Source A data mining connection is a connection to a data source through a preconfigured data mining tag i e a data tag that was configured using the Data Mining Configurator To connect to a Data Mining data source 1 Select the Dat
16. ata Mining ActiveX Properties Double clicking the Data Mining ActiveX opens the Data Mining ActiveX Properties dialog box which contains the following property pages e General e Fonts e Columns Alias e Web Access General The General tab of the Data Mining ActiveX Properties dialog box shown below allows you to connect to the desired data source General Fonts Columns Alias Web Access Title Data Mining ActiveX ADO DB Status Mat connected v Auto Update every 300 sec Configuration File LocalFile URL Path Not Assigned Data Source Type f ADO C Data Mining Connection parameters Cancel Apply Help Data Mining ActiveX Properties General Tab Configure the following General tab settings e Title Enter a title for the Activex e About Clicking the About button displays both technical support information and the About Box which contains registration and serial number information as well as system resource information such as memory and disk space available e Auto Update Used only for ADO Data Source type Specifies the frequency in seconds at which the Data Mining ActiveX updates data from the connected database e Configuration File By default information is stored as part of the container application s document file You can also store information as part of a separate dbm file To save the dom file under Configuration File click Save As to open the Save Con
17. ck the check box next to Column 1 as shown in the figure below Click OK 20 Data Mining ActiveX General Fonts Columns Alias web Access iti Add Alias C Column 1 Column 1 Column 2 L alumn 2 x Delete Alias Column 3 Column 3 Column 4 Column 4 TI Show Columns Column 5 Column 5 Header Column 5 Column 6 Column Column 7 Show Hows e Header Cancel Apply Help Hiding a Column When you start runtime mode you can see that Column 1 is now hidden and the first column is now Column 2 as shown in the figure below You can also hide the column headers and row headers To hide the column names in the Grid uncheck the Show Columns Header check box on the Columns Alias tab To hide the row names or numbers in the Grid uncheck the Show Rows Header check box on the Columns Alias tab Data Mining Activex 1 Grid Display With Hidden Columns Web Access The Web Access tab of the Data Mining ActiveX Properties dialog box shown below allows you to access the currently connected database over the Internet via a Remote Data Service RDS The RDS which is hosted by an Internet Information Server IIS enables the downloading of data from the connected database to a client over the Internet Simply specify the URL name or IP address of the primary IIS Web server in the Primary Internet Information Server for RDA field as shown in the figure below The Remote Recordset Page Size field s
18. control of the Global Alias Browser Select a global alias by double clicking the alias name e g Floor in the figure below The alias name appears at the top of the browser which automatically adds the lt and gt delimiters to the alias name Click the OK button lt Floor gt Global Aliases yh gi Aliases Building BuildingIdent Building human readable identification string f Floor PloorCaption FloorIdent Floor human readable identification string Room Room_aption R oomident Room human readable identification string RoomTemper ce Selecting an Alias From the Global Alias Browser e Data Source Type The Data Mining ActiveX allows you to connect to two types of data sources ADO and Data Mining An Active Data Object ADO connection is a direct connection to a data source A data mining connection is a connection to a data source through a preconfigured data mining tag i e a data tag that was configured using the Data Mining Configurator To define your database connections clicking the Connection Parameters button ADO and Data Mining data source connections are described in detail in the sections below Connecting to an ADO Data Source An Active Data Object ADO connection is a direct connection to a data source To connect to an ADO data source 1 Select the ADO radio button on the General tab of the Data Mining ActiveX Properties dialog box 2 Click the Connection parameter
19. d it allows you to use or not to use the local settings configuration file Example ThisDocument DBMining1 UseLocalSettings True Data Mining ActiveX Control Methods AboutBox Shows About dialog box Example ThisDocument DBMining1 AboutBox Connect As Boolean lt forces the control to establish connection to database using the information set in ConnectionString and QueryText If control is already connected the current connection will be closed and a new connection will be established This method can be used in VBA scripts automatically to switch the Database Mining ActiveX between different connections Return Value On success returns TRUE if for any reason connection cannot be established returns FALSE Example Dim strConnString as String strConnString Provider Microsoft Jet OLEDB 4 0 _ Data Source c alarms SomeOtherDatabase mdb _ User ID Admin Password SYSTEM ThisDocument DBMining1 ConnectionString strConnString ThisDocument DBMining1 QueryText Select from Table ThisDocument DBMining1 Connect ThisDocument DBMining1 Refresh LoadConfigFile BSTR newVal as Boolean It loads the configuration file specified in newVal Example Dim ret As Boolean ret DBMining1 LoadConfigFile C My Configs cfg dom SaveConfigFile BSTR newVal as Boolean It saves your current Database Mining ActiveX configuration to the file specified in newVal Example Dim ret As Boolean ret DBMining1 SaveConfigFile C
20. e Sorts 2 1 Tp M5 Outlook AaBbryZz MS Sans Serif Cancel Apply Help Data Mining ActiveX Properties Fonts Tab 17 Data Mining ActiveX User s Manual Columns Alias The Columns Alias tab of the Data Mining ActiveX Properties dialog box shown below allows you to create column names and associate each name with a column that is displayed in the Data Mining ActiveX Grid General Fonts Columns Alias Web Access iti Add Alias Column 1 Column 1 Column 2 Column 2 S Delete Alias Show Columns q Header Show Rows ca Header Cancel Apply Help Data Mining ActiveX Properties Columns Alias Tab Creating Column Aliases To create a new column alias 1 On the Columns tab click the Add Alias button as shown in the figure below General Fonts Columns Alias Web Access iti Add Alias a Delete slias Show Columns q Header Show Rows ca Header Cancel Apply Help Adding a Column Alias 2 This opens the Column Alias Property dialog box as shown in the figure below In the Alias Name field specify a column name Then specify a Column Position number which corresponds to the position of the column where the alias will be applied in the Grid display Click OK NOTES With column aliasing you can define aliases for the columns that you need Column positions do not need to be sequential For example you could define two aliases one for
21. elow Data Mining ActiveX Customer D ae ContactName Contact ite Addres gassssusususuusussessuscussusscusses uusseuusussssusccessusccsusssusrusssussrcessusesussussusussesususressures Avda d PPP EEE eee bE eee M atade PEPER AS Se ee ence Rene eee ESE ROR E SEER OSES CORSE ROSES ROSE SEER ORE ESSS ESCO ROSE SSSR OSE E OSE SSE ROSES SOSH SSSR OSE SSSR ESE ORE SEE ROSES ROSE SSS SORES EOS ESSE ROSE SESS ROSES OSE SSS ROSE ROR E SEER SSE SEOO ESSE ROSE OSES ESSE ESR E SSE ESSSE SO SOGE ESSE ORES ESSE ESE ESEEEESES See e eee Renee eee REE ORES EE EROS ROSE SSSR SESE OSE SEER OSE ESSS ESSE ROSE SSE ROSSER OSE SEE ROSES EOS ESSE SOSH SSSR ESSE ORE SEE ROSES ROSE SSE ROSES HORE SSE ROSE SEES ROSES OSE SSE ROSE ROR E SERRE ESEOO ESSE SOSH OSES ESSE ROSE SSE ESSSE SOS SOGE SOO E OSE E SEE ESE ESSE EEEES PEPE EE eee SPEER ee eee 011410910110 E E j A AS e E B s Beverages Victoria Ashwo Sales Repre Fauni A AOS A A A eee Refreshing Data in Grid Data Mining ActiveX OLE Automation References 26 This reference describes the OLE Automation features available in the Data Mining ActiveX Automation Interfaces The Data Mining ActiveX provides a COM interface that allows automation interfaces run from within the ActiveX container to manipulate the Data Mining ActiveX control as it is running The interface is available to all programming languages that support COM including Visual Basic VB Visual Basic for
22. eme bere Str 5 Ana Trujillo Emparedadc Ana Trujillo Owner Avda de la Constitucic Antonio Moreno Taqueri Antonio Moreno Owner Mataderos 312 Around the Horn Thomas Hardy Sales Representative 120 Hanover Sq Reralunds snahhk n Christina Reralur Order Adrministratnr Reraiwvsv nen A gei Northwind Database lolx Objects Create table in Design view BA Tables mao Create table by using wizard uu Create table by entering data ge Queries Categories IB Farms Record aja i Reports a Pages Macros Employees Order Details Orders Products Modules Shippers 880000066 Groups suppliers Favorites Customers Table in Northwind Database 5 Click the Connect button to connect to the database The traffic light icon changes to green when the connection is successful as shown in the figure below Click OK to return to the General tab Then click OK again Data Source Connection Data Source Connection Data Provider HE Access CMS SOL Sener C ODE OLE DB Connection Sting Provider Miciosofl Jet OLEDB 4 Password Dala Sowce C Program Bund Files SMAR ProcessView Examp Mining ExamplesMorthwnd mdb Persist Secuii lr o T rue OSI d Siria Query Select From Customers Connection Status CONNECTED Database Connection 6 When you enter the display into runtime mode you will see the data items from the Customers table displayed in the Data Mining Grid as sh
23. ending on which data provider you selected Click the OK button Click the Help button at any time to view the Microsoft Data Link help documentation Data Mining ActiveX E Data Link Properties E xl Provider Connection Advanced All Specify the following to connect to Access data 1 Select or enter a database name Jon Miscellaneous N orthwind databases Northwind mde zu 2 Enter information to log on to the database User name amp dmin Password MW Blank password Allow saving password Test Connection Cancel Help Specifying a Data Source The data source reference appears in the Database Connection dialog box in the OLE DB Connection String field as shown below In the Query field you must type in a database query to define which recordset will be read from the connected data source In this example we will use the following query Select From Customers This query will read all data from the Customers table in the Northwind mdb database The figure below shows this table as viewed in Microsoft Access As you can see it has several columns of data e g Customer ID Company Name Contact Name Contact Title etc NOTE For more information about writing database queries please refer to the Microsoft SQL server or Oracle help documentation Data Mining ActiveX User s Manual E Customers Table ae cee Seal TENERE TT RR Alfreds Futterkiste Mara Anders Sales m
24. fferent sets of data In the example configuration shown in the figure below Column 1 represents the single column from Tag2 and the other columns 2 6 represent the columns from Tag4 General Fonts Columns Alias Web Access iti Add Alias fa One Dimensional Array Column 1 Muli Dimensional Array Column 2 s Delete Alias Mult Dimensional Array Column 3 Mult Dimensional Arap Column 4 n Show Columns Multi Dimensional Aray Column 5 Header Mult Dimensional Array Column 6 Multi Dimensional Array Column 7 Show Flows n Header Cancel Apply Help Column Names for Combined Arrays When you enter the display into runtime mode you can clearly distinguish between the two sets of data produced by each of the data tags as shown in the figure below 25 Data Mining ActiveX User s Manual Data Mining Activex c Dimensional Array eee MultiDimensional Array MultiDirnensional Array EMultiDimensional Array Alfreds aa Maria lel Sales Representative Viewing Combined Arrays in the Grid Display Refreshing the Data Grid The Data Mining ActiveX automatically updates data from the connected data source ADO data connections only at the frequency in seconds you specified in the Auto Update field in the Data Mining ActiveX General tab To manually update the data in the Grid right click on the data during runtime mode and select Refresh Grid from the pop up menu as shown in the figure b
25. figuration Info dialog box Enter a name for the dbm file in the File Name field and then click Save You can also open an existing configuration file by clicking the Load button on the General tab and browsing for the file The ActiveX will attempt to load the configuration file If URL Path is selected the ActiveX will use the specified network URL path upon loading the file The ActiveX cannot be saved to a URL path To create a URL file save a configuration to a local file and copy the file to the desired network location When the URL Path option is selected you can also enable the Use Local Settings option which if checked stores runtime changes to a local copy of the remote configuration file It will use this local file every time the HTML page that hosts the Viewer is loaded inside the Web browser Data Mining ActiveX You can also select aliases to use for the configuration file Clicking the button and selecting Insert Global Alias from the pop up menu opens the Global Aliases tab of the Unified Data Browser as shown in the figure below Select a global alias from the Unified Browser which includes all global aliases in the global alias database This eliminates the need to manually type in the alias name All global aliases that are configured in the Global Alias Engine Configurator are conveniently available to choose from inside the browser The tree control of the Global Alias Engine Configurator is mimicked in the tree
26. font to Arial 14 pt use the following statements With ThisDocument DBMining1 Font Name Arial Size 14 End With ForeColor Type OLE COLOR Description Sets gets foreground usually font color property of the Database Mining ActiveX Example ThisDocument DBMining1 ForeColor RGB 0 0 0 GridBackColor Type OLE COLOR Description Sets gets color value used to paint the gaps between rightmost column and right edge of the grid last row and bottom edge of the grid and row headers column the back area of the grid Example ThisDocument DBMining1 GridBackColor RGB 0 127 0 GridDefRowHeight Type Integer Description Sets gets the default row height for data grid Example ThisDocument DBMining1 GridDefRowHeight 16 Data Mining ActiveX GridHorizLinesColor and GridVertLinesColor Type OLE COLOR Description Sets gets color for horizontal or vertical grid lines Example ThisDocument DBMining1 GridHorizLinesColor RGB 127 127 127 ThisDocument DBMining1 GridVertLinesColor RGB 127 127 127 GridHorizLinesStyle and GridVertLinesStyle Type Integer Description Sets gets style for horizontal or vertical grid lines Can be one of the following 0 no line 1 solid line 2 dot line 3 dash line 4 dashdot line 5 dashdotdot line Example ThisDocument DBMining1 GridHorizLinesStyle 20 ThisDocument DBMining1 GridVertLinesStyle 2 GridHorizLinesWidth and GridVertLinesWidth Type Integer
27. gets ADO connection string used by the Database Mining ActiveX control to access data Example Dim strConnString as String strConnString Provider Microsoft Jet OLEDB 4 0 _ Data Source c alarms AWXLog32 mdb _ User ID Admin Password SYSTEM ThisDocument DBMining1 ConnectionString strConnString DataSourceType Type Short Description Sets gets the Database Mining ActiveX connection type o ic ADO 1 Database Mining 27 Data Mining ActiveX User s Manual 28 DBMiningTitle Type String Description Sets gets the title shown in the window title bar of the Database Mining ActiveX control during runtime mode DisplayGridTitle Type Boolean Description Sets gets Boolean value that controls the visibility of the grid title bar Example ThisDocument DBMining1 DisplayGridTitle TRUE EnableAutoUpdate Type Boolean Description Enables disables automatic updates for ADO connections Example ThisDocument DBMining1 EnableAutoUpdate True EnableWebAccess Type Boolean Description Enables disables Database Mining ActiveX Web access for ADO connections Example ThisDocument DBMining1 EnableWebAccess True FileName Type BSTR Description Sets gets the name of the Database Mining ActiveX configuration file Example ThisDocument DBMining1 FileName C ADBMiningConfig dbm Font Type StdFont Description Returns a reference to the control s default font Example To set control s default
28. ing Properties dialog box as shown below 3 Tocreate a connection click the Add Tags button as shown in the figure below Data Mining Properties E x Delete Tag Change Tag Show Path Cancel Help Data Mining Properties 4 This opens the Unified Data Browser Select one or more data tags from the Unified Data Browser as shown in the figure below In this example we will use the following multidimensional database mining tag SMAR DatabaseOPCServer 3 AccessConnection DataSource04 Tag4 11 Data Mining ActiveX User s Manual 12 This tag is defined in the DBOPCServerExample mdb example data mining configuration database which is included in the ProcessView installation in the Program Files Smar ProcessView Examples Database Mining Examples directory This configuration database connects to the Northwind mdb Microsoft Access database For more information about database mining examples configuring database access items and how to load the DBOPCServerExample mdb configuration database please refer to the Database Mining Configurator help documentation For an example of how to use global aliasing in the Data Mining ActiveX please refer to the DBOPC GlobalAlias gdf file in the Program Files Smar ProcessView Examples Database Mining Examples directory in the ProcessView installation e gt ME m amp S i eK rep Selected Item IDs 1 SMAR DatabaseOPCSarver 3u amp ccessConnechbon DataSourceQ4 Tag4
29. ion e cp fe fey fF Selected Item IDs 1 SMAR DataBaseOPCSarver 3vVAccessConnecbon DataSourceQO2 Tag melo pm X Ge ec ta Database Access El Us Databases 8 AccessConnection ar column E E Dataseurcent a Recordset DataSourcellz inn Refresh M EJ DataSource 3 E DataSourcel4 E El DatasourceOs E E DataSourceds caso E k i LastScanTime Selecting a Data Tag From the Unified Data Browser 5 This example data access tag AccessConnection DataSource02 Tag2 is a one dimensional array i e reads data from a single column in the specified database table that reads data from the Customers table in the Northwind mdb database The figure below shows this table as viewed in Microsoft Access As you can see it has several columns of data e g Customer ID Company Name Contact Name Contact Title etc This particular tag reads data only from the ANTON rowset in the Customer ID column Click OK 15 Data Mining ActiveX User s Manual 16 E Customers Table CustomerID Company Name Alfreds Futterkiste Maria Anders Sales Representative Obere Str 57 Ana Trujillo Emparedadce Ana Trujillo Owner Avda de la Constitucic Antonio Moreno Taquerk Antonio Moreno Owner Mataderos 2312 Around the Horn Thomas Hardy Sales Representative 120 Hanover Sq Reralunds snahhk n Christina Reralur Order Administratnr Fiernivsv nen H gei Northwind Database E al Create table in
30. onitor Viewing One Dimensional Arrays The figure below shows a one dimensional array in runtime mode This example refer to the Connecting to a One Dimensional Data Mining Data Source section above for details displays the entire rowset ANTON in the Customer ID column in the connected Northwind mdb database as defined by the connected AccessConnection DataSource02 Tag2 data tag You can change the column width by moving the column dividers The array can be a horizontal array i e view an entire rowset or it can be a vertical array i e it shows the values in a column No matter what array you want to view in the grid it is always shown as a column Thus even though the example shown in the figure below displays a rowset the data in the row are displayed in the grid as a column 23 Data Mining ActiveX User s Manual 24 Data Mining Actives m Customerl O Viewing Data Items in Runtime Mode One dimensional Array Viewing Multidimensional Arrays The figure below shows a multidimensional array in runtime mode This example refer to the Connecting to a Multidimensional Data Mining Data Source section above for details displays columns of data e g Customer ID Company Name Contact Name Contact Title etc that match the columns in the connected Northwind mdb database as defined by the connected AccessComnection DataSource04 Tag4 data tag You can change the column width by moving the column dividers
31. ost2 True True if Status lt gt O then there was no replacement performed or an error occurs If Status 0 Then MsgBox No replacements Else MsgBox Tags replaced End lf SaveConfigFile BSTR newVal as Boolean It saves your current Database Mining ActiveX configuration to the file specified in newVal Example Dim ret As Boolean ret DBMining1 SaveConfigFile C My Configs cfg dbm SetDBType short NewDBT ype Sets the database type Example DBMining1 SetDBT ype 1 GetGridCellValue long ColNum long RowNum as VARIANT It takes inside the grid buffer the current cell value with column number equal to Colnum and row number equal to RowNum
32. own in the figure below The columns of data e g Customer ID Company Name Contact Name Contact Title etc match the columns in the connected Northwind mdb database 10 Data Mining ActiveX Data Mining Activex ouster Comparta Contactame Conecte Ades or Region PostalCode county Prone ra Rut Alfreds Futterkis Maria pnus Sales Repre Obere St Berli j German 030 00 030 0 Mexico 5 555 5 55 Mexico b 555 WAI IDP UK 171 5 171 S 95822 Sweden 0921 1 0921 68306 German 0621 0 0621 67000 France 88 60 1 88 60 28023 Spain 91 55 91 5 13008 France 912449124 T2F8M4 Canada 604 5 604 EC25NT UK 1010 Argentin 1 135 on 3 05022 Mexico 5 555 5 55 Switzerl 0452 0 05432 043 Brazil 11 55 WXIeLT UK 171 5 171 52066 German 0241 0 0241 UK 1705 171 lEmstHandel Roland Mend Ki Gra Austria 7675 8 7675 Familia Arquibal Aria Cruz Marketing A Rua Or S o SP 05442 030 Brazil 11 55 Table Column Displayed in Data Mining ActiveX Grid Connecting to a Multidimensional Data Mining Data Source A data mining connection is a connection to a data source through a preconfigured data mining tag i e a data tag that was configured using the Data Mining Configurator To connect to a Data Mining data source 1 Select the Data Mining radio button on the General tab of the Data Mining ActiveX Properties dialog box 2 Click the Connection parameters button This opens the Data Min
33. pecifies the size of the recordset portion in the database records 21 Data Mining ActiveX User s Manual You also may designate a redundant IIS Web server by specifying the URL name or IP address of the redundant IIS Web server in the Backup Internet Information Server for RDA field as shown in the figure below For more information about Remote Data Access please refer to the AlarmWorX Remote Database Access Manager help documentation The Web Access tab only applies when you are connecting via an ADO database connection If you are using a data mining tag you need only supply the node name or IP address of the server in front of the tag name General Fonts Columns Alias Web Access iW Access curently connected database over the Internet via ADS Primary Internet Information Server for Remote Data Access p Example http ebHHMI SameCompany com Backup Internet Information Server for Remote D ata Access Mas Number of database records to download 2048 Cancel Apply Help Data Mining ActiveX Properties Web Access Tab Viewing Data in the Runtime Grid 22 Once you have established your data source connections you are ready to view the data in the Data Mining ActiveX Grid Testing Your Data Tags Before you try to connect to data sources and view your data tags it is highly recommended that you verify if the tags present inside the display are well configured from the server
34. s Type Long Description Sets gets the maximum number of records that the Database Mining ActiveX will download using a Web access RDS connection Example ThisDocument DBMining1 MaxRecords 1024 QueryText Type String Description Sets gets the SQL statement used with an ADO connection to populate the data grid in runtime mode Example Dim strQry as String strQry ThisDocument DBMining1 QueryText MsgBox strQry RemoteDataServer Type BSTR Description This is the Internet Information Server used with the Web access RDS connections Example ThisDocument DBMining1 RemoteDataServer http localhost RemoteDataServerBackup Type BSTR Description This is the backup URL used with Web access RDS connections if the connection with the server specified on RemoteDataServer property fails Example ThisDocument DBMining1 RemoteDataServerBackup http localhost ShowColsHeader and ShowRowsHeader Type Boolean Description Show hide the rows columns headers URLPathName Type BSTR Description Sets gets the URL path for a configuration file over the Web Must set URLPathUsed to True for this to take effect Example ThisDocument DBMining1 URLPathName http www smar com dbminingcfg dom URLPathUsed Type Boolean Description Enables disables the use of a URL path Example ThisDocument DBMining1 URLPathUsed True UseLocalSettings Type Boolean Description When the URL path is enable
35. s button This opens the Database Connection dialog box as shown below 3 Under Data Provider select from Microsoft Access Microsoft SQL Server or ODBC Open Data Base Connectivity as shown in the figure below In this example we will select Microsoft Access Data Mining ActiveX User s Manual Data Source Connection E X bala Source Cannes Data Provider MS Access C MS SOL Server C ODBC OLE DB Connectors Sima Provider Mictosoft JeLOLEDB 4 0Passwomd Dala Sowce CVogeem pui Files SMAR ProcessView Examples Database Mining Connection Examples HNorthaind mdb Persist Secunty Infaz T rue Quer Select From Customers z DISCONNECTED Connect Conmecton Stale Connecting to a Database 4 Click the Build Connection String button This opens the Microsoft Data Link Properties dialog box as shown in the figure below In the Connection tab specify the data source and then click OK In this example we will use the Northwind mdb Microsoft Access database which is included in the ProcessView installation in the Program Files Smar ProcessView Examples Database Mining Examples directory For more information about database mining examples please refer to the Database Mining Configurator help documentation All data source connections are made through the Data Link Properties dialog box The Connection tab settings may vary dep
36. s shown in the figure below You can change the column width by moving the column dividers Data Mining Active Column Aliases Displayed in Data Mining Grid 19 Data Mining ActiveX User s Manual Hiding Columns Suppose that you have configured a database connection that reads a data set with multiple columns and you have created a column alias for each column of data that is read from the database as shown in the figure below You can hide each columns from the display by simply unchecking the check box next to the column ICONICS ICONICS Data Mining ActiveX Properties X General Fonts Columns Alias Web Access iti Add Alias Column 1 Column 1 Column 2 Column H2 A Delete Alias Column 3 Column 3 Column 4 Column 4 T Show Columns v Column olumn Bader Lol 5 Col H5 Head Column 6 Column 6 Column Y Column 7 Show Flows q Header Cancel Apply Help Multiple Column Aliases For example in runtime mode the grid display appears as shown in the figure below As you can see the column alias names are displayed at the top of the grid Column 1 contains some data e g abbreviations cryptic characters etc that may not make sense to some users and therefore should be removed from the display Thus we will hide Column 1 Data Mining Activex Alfreds Futt Maria And Sales iod Obere Str IESU Grid Display With Multiple Columns Go back to the Columns Alias tab and unche
Download Pdf Manuals
Related Search