Difference between revisions of "Installation Guide for the ODBC Plugin"

Revision as of 09:28, 18 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 name which includes CSV file. The item of FieldDataType content belong FieldName that is corresponding position.

     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

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:

<?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>

6.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>

   …

7.Prepare your data file (.csv) and copy the file into the folder you assigned in the ODBCHandler.ini.

8.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.

9.Add your device and check if ODBC_Handler tab is created in the hardware information screen.

10. Finally you can see the last set of data as below.