Difference between revisions of "Installation Guide for the ODBC Plugin"
Line 14: | Line 14: | ||
<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">RMM 3.3 Agent Plus Setup_3.3.18.exe</font></font> | ||
+ | |||
+ | <font face="Droid Sans Mono, sans-serif"><font size="3"></font></font> | ||
+ | |||
+ | |||
+ | |||
+ | |||
<font face="Droid Sans Mono, sans-serif"><font size="3">2.ODBC Plugin:</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" size="3">ODBCPlugin_standard_v1.0.xxxx.zip</font> | ||
+ | |||
+ | <font face="Droid Sans Mono, sans-serif" size="3"></font> | ||
+ | |||
+ | |||
Line 27: | Line 37: | ||
− | + | <span style="font-size:medium;">1.Install '''WISE-PaaS Agent 3.3'''.</span> | |
+ | |||
+ | <span style="font-size:medium;"></span> | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | <span style="font-size:medium;">2.Stop the services '''SAWatchdog''' and '''AgentService_32''' from Task Manager.</span> | ||
+ | |||
+ | <span style="font-size:medium;"></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 include CSV file.</span> | |
− | For example: 1. TIME = timestamp 2. No#1EC = double 3. No#1ph = float …… | + | <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> | ||
| | ||
− | '''[Setting]''' | + | <span style="font-size:medium;">'''[Setting]'''</span> |
− | #ODBCDriver=Microsoft Access Driver (*.mdb) | + | #<span style="font-size:medium;">ODBCDriver=Microsoft Access Driver (*.mdb)</span> |
− | #ODBCDriver=MySQL ODBC 5.3 Unicode Driver | + | #<span style="font-size:medium;">ODBCDriver=MySQL ODBC 5.3 Unicode Driver</span> |
− | #ODBCDriver=PostgreSQL ANSI | + | #<span style="font-size:medium;">ODBCDriver=PostgreSQL ANSI</span> |
− | #ODBCDriver=Microsoft Excel Driver | + | #<span style="font-size:medium;">ODBCDriver=Microsoft Excel Driver</span> |
− | '''ODBCDriver=Microsoft Text Driver (*.txt; *.csv)''' | + | <span style="font-size:medium;">'''ODBCDriver=Microsoft Text Driver (*.txt; *.csv)'''</span> |
− | '''ReadOnly=0''' | + | <span style="font-size:medium;">'''ReadOnly=0'''</span> |
− | '''…''' | + | <span style="font-size:medium;">'''…'''</span> |
− | | + | <span style="font-size:medium;"> </span> |
− | '''[Text]''' | + | <span style="font-size:medium;">'''[Text]'''</span> |
− | '''FilePath=C:\Test''' | + | <span style="font-size:medium;">'''FilePath=C:\Test'''</span> |
− | '''FieldName=TIME,No#1EC,No#1ph,No#2EC,No#1es,No#1e,No#1HumidityRatio,No#2ph''' | + | <span style="font-size:medium;">'''FieldName=TIME,No#1EC,No#1ph,No#2EC,No#1es,No#1e,No#1HumidityRatio,No#2ph'''</span> |
− | '''FieldDataType=timestamp,double,float,string,float,double,double,float''' | + | <span style="font-size:medium;">'''FieldDataType=timestamp,double,float,string,float,double,double,float'''</span> |
| |
Revision as of 10:41, 17 January 2018
Overview
This document is a quick start guide for user to know how to install ODBC Plugin.
In this document, you may follow the steps to install and configure the plugin.
Required Package
1.RMM Agent:
RMM 3.3 Agent Plus Setup_3.3.18.exe
2.ODBC Plugin:
ODBCPlugin_standard_v1.0.xxxx.zip
How to install ODBC Plugin
1.Install WISE-PaaS Agent 3.3.
2.Stop the services SAWatchdog and AgentService_32 from Task Manager.
3.UnZIP the ODBC plugin package and install below files manually:
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 )
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 )
4.Open the file ODBC_Handler.ini and set the [Text] session
4.1FilePath: Set path of the CSV file locate, for example C:\Test
4.2FieldName & 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 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.