|
|
(2 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
− | <font face="Droid Sans Mono, sans-serif"><font size="6">Overview</font></font>
| + | <span style="font-size:large;">'''Please refer [http://ess-wiki.advantech.com.tw/view/ODBC_Service ODBC Service]'''</span> |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="3">This document is a quick start guide for user to know how to install ODBC Plugin.</font></font>
| |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="3">In this document, you may follow the steps to install and configure the plugin.</font></font>
| |
− | | |
− | | |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="6">Required Package</font></font>
| |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="3">1.RMM Agent:</font></font>
| |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="3">RMM 3.3 Agent Plus Setup_3.3.18.exe</font></font>
| |
− | | |
− | | |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="3">2.ODBC Plugin:</font></font>
| |
− | | |
− | <font face="Droid Sans Mono, sans-serif" size="3">ODBCPlugin_standard_v1.0.xxxx.zip</font>
| |
− | | |
− | | |
− | | |
− | <font face="Droid Sans Mono, sans-serif"><font size="6">How to install ODBC Plugin</font></font>
| |
− | | |
− | | |
− | | |
− | <span style="font-size:medium;">1.Install '''WISE-PaaS Agent 3.3'''.</span>
| |
− | | |
− | | |
− | | |
− | <span style="font-size:medium;">2.Stop the services '''SAWatchdog''' and '''AgentService_32''' from Task Manager.</span>
| |
− | | |
− | | |
− | | |
− | <span style="font-size:medium;">3.UnZIP the ODBC plugin package and install below files manually:</span>
| |
− | | |
− | <span style="font-size:medium;">3.1.Copy the files '''ODBC_Handler.ini '''to the folder where the WISE-PaaS Agent installed. ( by default, the path is C:\Program Files (x86)\Advantech\RMM 3.3 Agent )</span>
| |
− | | |
− | <span style="font-size:medium;">3.2.Copy the file '''ODBC_Handler.dll '''to sub-folder \module where the WISE-PaaS Agent installed. ( by default, this path is C:\Program Files (x86)\Advantech\RMM 3.3 Agent\module )</span> | |
− | | |
− | | |
− | | |
− | <span style="font-size:medium;">4.Open the file '''ODBC_Handler.ini '''and set the [Text] session</span>
| |
− | | |
− | <span style="font-size:medium;">4.1FilePath: Set path of the CSV file locate, for example C:\Test</span>
| |
− | | |
− | <span style="font-size:medium;">4.2FieldName & FieldDataType: Set data type of the each field name which includes CSV file. The item of FieldDataType content belong FieldName that is corresponding </span><span style="font-size:medium;">position.</span>
| |
− | | |
− | <span style="font-size:medium;"> Support data type: timestamp, double, string, float, boolean.</span>
| |
− | | |
− | <span style="font-size:medium;"> For example: 1. TIME = timestamp 2. No#1EC = double 3. No#1ph = float ……</span>
| |
− | | |
− | <span style="font-size:medium;"> [[File:Sop fieldname example.JPG|350x140px|RTENOTITLE]]</span>
| |
− | | |
− |
| |
− | | |
− | <span style="font-size:medium;">'''[Setting]'''</span>
| |
− | | |
− | <span style="font-size:medium;">#ODBCDriver=Microsoft Access Driver (*.mdb)</span>
| |
− | | |
− | <span style="font-size:medium;">#ODBCDriver=MySQL ODBC 5.3 Unicode Driver</span>
| |
− | | |
− | <span style="font-size:medium;">#ODBCDriver=PostgreSQL ANSI</span>
| |
− | | |
− | <span style="font-size:medium;">#ODBCDriver=Microsoft Excel Driver</span>
| |
− | | |
− | <span style="font-size:medium;">'''ODBCDriver=Microsoft Text Driver (*.txt; *.csv)'''</span>
| |
− | | |
− | <span style="font-size:medium;">'''ReadOnly=0'''</span>
| |
− | | |
− | <span style="font-size:medium;">'''…'''</span>
| |
− | | |
− | <span style="font-size:medium;"> </span>
| |
− | | |
− | <span style="font-size:medium;">'''[Text]'''</span>
| |
− | | |
− | <span style="font-size:medium;">'''FilePath=C:\Test'''</span>
| |
− | | |
− | <span style="font-size:medium;">'''FieldName=TIME,No#1EC,No#1ph,No#2EC,No#1es,No#1e,No#1HumidityRatio,No#2ph'''</span>
| |
− | | |
− | <span style="font-size:medium;">'''FieldDataType=timestamp,double,float,string,float,double,double,float'''</span>
| |
− | | |
− |
| |
− | | |
− | <span style="font-size:medium;">5.Open the file '''\module\module_config.xml''' and add the new session <ModuleNameXX>, <ModulePathXX> and <ModuleEnableXX> for keep ODBC_Handler configurations, also remember to update total module number for the session '''<ModuleNum>''', for example:</span>
| |
− | | |
− | <span style="font-size:medium;"><?xml version="1.0"?></span>
| |
− | | |
− | <span style="font-size:medium;"><XMLConfigSettings><BaseSettings></span>
| |
− | | |
− | <span style="font-size:medium;">'''<ModuleNum>1''''''8''''''</ModuleNum>'''</span>
| |
− | | |
− | <span style="font-size:medium;">…</span>
| |
− | | |
− | <span style="font-size:medium;">'''<ModuleName1''''''8''''''>''''''ODBC_''''''Handler</ModuleName1''''''8''''''><ModulePath1''''''8''''''>\module\''''''ODBC_''''''Handler.dll</ModulePath1''''''8''''''><ModuleEnable1''''''8''''''>TRUE</ModuleEnable1''''''8''''''>'''</span>
| |
− | | |
− | <span style="font-size:medium;"></BaseSettings></XMLConfigSettings></span>
| |
− | | |
− | | |
− | | |
− | | |
− | | |
− | <span style="font-size:medium;">6.Make sure the settings in the agent_config.xml are correct, include <ServerIP>, <DeviceName>, <DevID> and <WorkDir> of your machine, for example:</span>
| |
− | | |
− | <span style="font-size:medium;"><?xml version="1.0" encoding="utf-8" standalone="yes"?></span>
| |
− | | |
− | <span style="font-size:medium;"><XMLConfigSettings></span>
| |
− | | |
− | <span style="font-size:medium;"> <BaseSettings></span>
| |
− | | |
− | <span style="font-size:medium;"> <RunMode>RemoteConnect</RunMode></span>
| |
− | | |
− | <span style="font-size:medium;"> <AutoStart>True</AutoStart></span>
| |
− | | |
− | <span style="font-size:medium;"> ''' <ServerIP>''''''127.0.0.1''''''</ServerIP>'''</span>
| |
− | | |
− | <span style="font-size:medium;"> <ServerPort>1883</ServerPort></span>
| |
− | | |
− | <span style="font-size:medium;"> <ConnAuth>fENl4B7tnuwpIbs61I5xJQ==</ConnAuth></span>
| |
− | | |
− | <span style="font-size:medium;"> <TLSType>0</TLSType></span>
| |
− | | |
− | <span style="font-size:medium;"> <CAFile/></span>
| |
− | | |
− | <span style="font-size:medium;"> <CAPath/></span>
| |
− | | |
− | <span style="font-size:medium;"> <CertFile/></span>
| |
− | | |
− | <span style="font-size:medium;"> <KeyFile/></span>
| |
− | | |
− | <span style="font-size:medium;"> <CertPW/></span>
| |
− | | |
− | <span style="font-size:medium;"> <PSK>05155853</PSK></span>
| |
− | | |
− | <span style="font-size:medium;"> <PSKIdentify/></span>
| |
− | | |
− | <span style="font-size:medium;"> <PSKCiphers/></span>
| |
− | | |
− | <span style="font-size:medium;"> </BaseSettings></span>
| |
− | | |
− | <span style="font-size:medium;"> <Profiles></span>
| |
− | | |
− | <span style="font-size:medium;">''' <DeviceName>''''''ODBCTEST''''''</DeviceName>'''</span>
| |
− | | |
− | <span style="font-size:medium;">''' <DevID>0000D850E6C4CED3</DevID>'''</span>
| |
− | | |
− | <span style="font-size:medium;"> <SN>60A44CE9EA69</SN></span>
| |
− | | |
− | <span style="font-size:medium;"> <DevType>IPC</DevType></span>
| |
− | | |
− | <span style="font-size:medium;">''' <WorkDir>C:\Program Files (x86)\Advantech\RMM 3.''''''3''''''Agent\</WorkDir>'''</span>
| |
− | | |
− | <span style="font-size:medium;">''' <SWVersion>3.''''''3''''''.1''''''5''''''.0</SWVersion>'''</span>
| |
− | | |
− | <span style="font-size:medium;"> …</span>
| |
− | | |
− | <span style="font-size:medium;"> </span>
| |
− | | |
− | <span style="font-size:medium;">7.Prepare your data file (.csv) and copy the file into the folder you assigned in the ODBCHandler.ini.</span>
| |
− | | |
− | <span style="font-size:medium;"> </span>
| |
− | | |
− | <span style="font-size:medium;">8.Re-start '''SAWatchdog''' and '''AgentService_32''' and open the RMM 3.3 web page, for example [http://127.0.0.1:8080 http://127.0.0.1:8080] if you install RMM 3.3 Server and Agent in same host. then input user id & password to login.</span>
| |
− | | |
− | <span style="font-size:medium;"> </span>
| |
− | | |
− | <span style="font-size:medium;">9.Add your device and check if ODBC_Handler tab is created in the hardware information screen.</span>
| |
− | | |
− | | |
− | | |
− | <span style="font-size:medium;">10. Finally you can see the last set of data as below.[[File:ODBC RMM info table.jpg|RTENOTITLE]]</span>
| |