|
|
| (23 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.Modbus Service:</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>
| |
| − | | |
| − | | |
| − | | |
| − | #Install '''WISE-PaaS Agent 3.3'''.
| |
| − | | |
| − |
| |
| − | | |
| − | #Stop the services '''SAWatchdog''' and '''AgentService_32''' from Task Manager.
| |
| − | | |
| − | | |
| − | | |
| − | #UnZIP the ODBC plugin package and install below files manually:
| |
| − | ##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 )
| |
| − | ##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 )
| |
| − | | |
| − |
| |
| − | | |
| − | #Open the file '''ODBC_Handler.ini '''and set the [Text] session
| |
| − | | |
| − | #FilePath: Set path of the CSV file locate, for example C:\Test
| |
| − | #FieldName & FieldDataType: Set data type of the each field include CSV file.
| |
| − | | |
| − | Support data type: timestamp, double, string, float, boolean.
| |
| − | | |
| − | For example: 1. TIME = timestamp 2. No#1EC = double 3. No#1ph = float ……
| |
| − | | |
| − |
| |
| − | | |
| − | '''[Setting]'''
| |
| − | | |
| − | #ODBCDriver=Microsoft Access Driver (*.mdb)
| |
| − | | |
| − | #ODBCDriver=MySQL ODBC 5.3 Unicode Driver
| |
| − | | |
| − | #ODBCDriver=PostgreSQL ANSI
| |
| − | | |
| − | #ODBCDriver=Microsoft Excel Driver
| |
| − | | |
| − | '''ODBCDriver=Microsoft Text Driver (*.txt; *.csv)'''
| |
| − | | |
| − | '''ReadOnly=0'''
| |
| − | | |
| − | '''…'''
| |
| − | | |
| − |
| |
| − | | |
| − | '''[Text]'''
| |
| − | | |
| − | '''FilePath=C:\Test'''
| |
| − | | |
| − | '''FieldName=TIME,No#1EC,No#1ph,No#2EC,No#1es,No#1e,No#1HumidityRatio,No#2ph'''
| |
| − | | |
| − | '''FieldDataType=timestamp,double,float,string,float,double,double,float'''
| |
| − | | |
| − |
| |
| − | | |
| − |
| |
| − | | |
| − | #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:
| |
| − | | |
| − |
| |
| − | | |
| − | <?xml version="1.0"?>
| |
| − | | |
| − | <XMLConfigSettings><BaseSettings>
| |
| − | | |
| − | '''<ModuleNum>1''''''8''''''</ModuleNum>'''
| |
| − | | |
| − | …
| |
| − | | |
| − | '''<ModuleName1''''''8''''''>''''''ODBC_''''''Handler</ModuleName1''''''8''''''><ModulePath1''''''8''''''>\module\''''''ODBC_''''''Handler.dll</ModulePath1''''''8''''''><ModuleEnable1''''''8''''''>TRUE</ModuleEnable1''''''8''''''>'''
| |
| − | | |
| − | </BaseSettings></XMLConfigSettings>
| |
| − | | |
| − |
| |
| − | | |
| − |
| |
| − | | |
| − | #Make sure the settings in the agent_config.xml are correct, include <ServerIP>, <DeviceName>, <DevID> and <WorkDir> of your machine, for example:
| |
| − | | |
| − |
| |
| − | | |
| − | <?xml version="1.0" encoding="utf-8" standalone="yes"?>
| |
| − | | |
| − | <XMLConfigSettings>
| |
| − | | |
| − | <BaseSettings>
| |
| − | | |
| − | <RunMode>RemoteConnect</RunMode>
| |
| − | | |
| − | <AutoStart>True</AutoStart>
| |
| − | | |
| − | ''' <ServerIP>''''''127.0.0.1''''''</ServerIP>'''
| |
| − | | |
| − | <ServerPort>1883</ServerPort>
| |
| − | | |
| − | <ConnAuth>fENl4B7tnuwpIbs61I5xJQ==</ConnAuth>
| |
| − | | |
| − | <TLSType>0</TLSType>
| |
| − | | |
| − | <CAFile/>
| |
| − | | |
| − | <CAPath/>
| |
| − | | |
| − | <CertFile/>
| |
| − | | |
| − | <KeyFile/>
| |
| − | | |
| − | <CertPW/>
| |
| − | | |
| − | <PSK>05155853</PSK>
| |
| − | | |
| − | <PSKIdentify/>
| |
| − | | |
| − | <PSKCiphers/>
| |
| − | | |
| − | </BaseSettings>
| |
| − | | |
| − | <Profiles>
| |
| − | | |
| − | ''' <DeviceName>''''''ODBCTEST''''''</DeviceName>''' | |
| − | | |
| − | ''' <DevID>0000D850E6C4CED3</DevID>'''
| |
| − | | |
| − | <SN>60A44CE9EA69</SN>
| |
| − | | |
| − | <DevType>IPC</DevType>
| |
| − | | |
| − | ''' <WorkDir>C:\Program Files (x86)\Advantech\RMM 3.''''''3''''''Agent\</WorkDir>'''
| |
| − | | |
| − | ''' <SWVersion>3.''''''3''''''.1''''''5''''''.0</SWVersion>'''
| |
| − | | |
| − | …
| |
| − | | |
| − |
| |
| − | | |
| − | #Prepare your data file (.csv) and copy the file into the folder you assigned in the ODBCHandler.ini.
| |
| − | | |
| − |
| |
| − | | |
| − | #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.
| |
| − | | |
| − |
| |
| − | | |
| − | Add your device and check if ODBC_Handler tab is created in the hardware information screen.
| |