Delta Electronics Ethernet Extension Module DOP Uživatelský manuál

www.deltaww.comDOP eServer User Manual2014-07-09Industrial Automation HeadquartersDelta Electronics, Inc. Taoyuan Technology CenterNo.18, Xinglong Rd.

Revision March, 2014 2-1 Chapter 2 Software Installation 2.1 eServer Setup In this chapter, it will introduce general functions of eServer with W

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-9 3. Windows Firewall Setting： Click 『Control Panel』『Windo

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-10 Revision March, 2014 Enable specific ports for the Named Pipes connection and

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-11 4. SQL Server User Authority： Start『SQL Server Surface A

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-12 Revision March, 2014 Choose authority of server to user. After choosing, click

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-13 5. Access 2007 Setting： Open Access 2007 and click『Add N

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-14 Revision March, 2014 Click『Create』. Edit the table name (Table1) and create

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-15 Select『Create New Database』and click『Next Step』. Choose

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-16 Revision March, 2014 Choose the table exporting to SQL Server. After choosing,

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-17 Setup the operation of the transfering database and click

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-18 Revision March, 2014 After finishing setup steps and the below window will sho

Chapter 2 Software Installation 2-2 Revision March, 2014 Step 2. Execute setup.exe from Windows taskbar by clicking “Start” > “Run”. After p

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-19 6. ODBC Setting： Click 『Control Panel』『Administrative T

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-20 Revision March, 2014 Input the name of ODBC and select connecting SQL Server.

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-21 Choose the corresponding database to be the default datab

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-22 Revision March, 2014 ODBC setup completes and can testing DSN.

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-23 8.1.2 Create HMI Project File Start DOPSoft software pro

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-24 Revision March, 2014 the settings. 8.1.3 eServer Setting Open a new Logging

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-25 Choose a HMI screen project file to link with this eServ

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-26 Revision March, 2014 ODBC Data Source Setting: input the ODBC Data Source name

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-27 Set the sampling conditions as constant, and set the va

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-28 Revision March, 2014 Save and Execute. After the password is entered, the sy

Chapter 2 Software Installation Revision March, 2014 2-3 Wlv To select the default directory C: \Program Files\Delta Industrial Automation\DOP e

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-29 eServer Logging Database： We can see that a『Database1SQL』

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-30 Revision March, 2014 This page intentionally left blank

Revision March, 2014 9-1 Chapter 9 Writing Data in MySQL Before creating testing example, make sure to change the upload and download option (Opti

Chapter 9 Writing Data in MySQL 9-2 Revision March, 2014 Click on Run button to install AppServ. Click on Next button to go to the next step.

Chapter 9 Writing Data in MySQL Revision March, 2014 9-3 The users must read license agreement before installation. Click on I Agree button to

Chapter 9 Writing Data in MySQL 9-4 Revision March, 2014 Then, select the AppServ Package Components to install, and click on Next button for t

Chapter 9 Writing Data in MySQL Revision March, 2014 9-5 Enter root password for MySQL database and complete the settings for MySQL Server. Ch

Chapter 9 Writing Data in MySQL 9-6 Revision March, 2014 Click on Finish button to complete AppServ setup. After installing AppServ, please res

Chapter 9 Writing Data in MySQL Revision March, 2014 9-7 2. MySQL Settings Use phpMyAdmin built-in AppServ to perform the relevant MySQL setting

Chapter 9 Writing Data in MySQL 9-8 Revision March, 2014 A. Create New Database Click on Databases link. Enter the name of the new database. In

Chapter 2 Software Installation 2-4 Revision March, 2014 Step 5. The system will start DOP eServer Installation. Step 6. DOP eServer has bee

Chapter 9 Writing Data in MySQL Revision March, 2014 9-9 A new database has been created. B. Create New Table Click on Structure link to crea

Chapter 9 Writing Data in MySQL 9-10 Revision March, 2014 Complete the settings by referring to the figure below and press Save button to save c

Chapter 9 Writing Data in MySQL Revision March, 2014 9-11 C. Create New User Click on Privileges link to open User overview page. Click on Add

Chapter 9 Writing Data in MySQL 9-12 Revision March, 2014 Login Information: User name: Enter user name root Host: Select Any host from the dro

Chapter 9 Writing Data in MySQL Revision March, 2014 9-13 A conformation message will be displayed as follows.

Chapter 9 Writing Data in MySQL 9-14 Revision March, 2014 3. Setting Windows Firewall Click Start and then click Control Panel. In the Control

Chapter 9 Writing Data in MySQL Revision March, 2014 9-15 In the Add a Port dialog box, type MySQL in the Name text field and type the port numb

Chapter 9 Writing Data in MySQL 9-16 Revision March, 2014 In the Administrative Tools, double-click Data Sources (ODBC). In the ODBC Data Sourc

Chapter 9 Writing Data in MySQL Revision March, 2014 9-17 Select MySQL ODBC 5.1 Driver and then click on Finish button. Now specify the Connect

Chapter 9 Writing Data in MySQL 9-18 Revision March, 2014 Server: Enter the default localhost or the name of MySQL server host that the users wa

Revision March, 2014 3-1 Chapter 3 Before Using eServer Before using eServer, the users need to update HMI firmware and complete PC and HMI networ

Chapter 9 Writing Data in MySQL Revision March, 2014 9-19 9.1.2 Create HMI Project File Start DOPSoft software program and click File > New

Chapter 9 Writing Data in MySQL 9-20 Revision March, 2014

Chapter 9 Writing Data in MySQL Revision March, 2014 9-21 9.1.3 eServer Setting 1. After eServer is started, eServer window will open. 3. Cli

Chapter 9 Writing Data in MySQL 9-22 Revision March, 2014 Press Next button to go to next step. 5. Click New icon to access nodes (link to HMI

Chapter 9 Writing Data in MySQL Revision March, 2014 9-23 After searching HMI IP in Ethernet, select HMI Name is HMI, IP is 172.16.190.100, pre

Chapter 9 Writing Data in MySQL 9-24 Revision March, 2014 Press Next button to go to next step. 7. Register Setting: Set the register address

Chapter 9 Writing Data in MySQL Revision March, 2014 9-25 9. Set the sampling conditions to constant 5s. Press Next button to continue.

Chapter 9 Writing Data in MySQL 9-26 Revision March, 2014 9. Press icon. After the password is entered, the system will start sampling operat

Chapter 9 Writing Data in MySQL Revision March, 2014 9-27 12. Click on Structure link. 13. The recorded data will be shown at the bottom of t

Chapter 9 Writing Data in MySQL 9-28 Revision March, 2014

Chapter 3 Before Using eServer 3-2 Revision March, 2014 3.2 Networking Settings Ensure to observe the following instructions to complete PC ne

Revision March, 2014 10-1 Chapter 10 Writing data in SQL Server 2005 Before giving the example, please setup the upload/download mode for DOPSo

Chapter 10 Writing Data in SQL Server 2005 10-2 Revision March, 2014 SQL Server 2005 Express Configuration check. Click Next.

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-3 Select the installation element. It is suggested to check all and then clic

Chapter 10 Writing Data in SQL Server 2005 10-4 Revision March, 2014 SQL Server Authentication Mode. Select Windows Authentication Mode and click N

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-5 Error and Usage Report Settings. Setup Do not send error report here. Then,

Chapter 10 Writing Data in SQL Server 2005 10-6 Revision March, 2014 Display setup progress. After all setting is finished, click Next. Complet

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-7  Installation of SQL Server Management Studio Express: Download Microsoft

Chapter 10 Writing Data in SQL Server 2005 10-8 Revision March, 2014 Select【I accept the terms in the license agreement】, then click Next. Please

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-9 Use default setting, click Next directly. Please click Install.

Chapter 10 Writing Data in SQL Server 2005 10-10 Revision March, 2014 The installation might take 1 ~ 2 minutes. Then, the following window will po

Chapter 3 Before Using eServer Revision March, 2014 3-3 Double-click Network Connections icon, the following windows will appear. Right-click th

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-11  Configuration setting of SQL Server communication: Enable『SQL Server Co

Chapter 10 Writing Data in SQL Server 2005 10-12 Revision March, 2014  Firewall setup:  XP setting Enter「Control Panel」「System and Security 」

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-13  Win 7 Setting Enter「Control Panel」「System and security 」「Windows Fire

Chapter 10 Writing Data in SQL Server 2005 10-14 Revision March, 2014 Select Port for further setting.

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-15 Enable specific ports for the Named Pipes connection and the TCP/IP connec

Chapter 10 Writing Data in SQL Server 2005 10-16 Revision March, 2014 Please select Allow the connection.

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-17 Select all then click Next.

Chapter 10 Writing Data in SQL Server 2005 10-18 Revision March, 2014 Enter the Name of this rule. eServerODBC is the entered name in this example.

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-19 After the setting is completed, double click eServerODBC properties to che

Chapter 10 Writing Data in SQL Server 2005 10-20 Revision March, 2014  Setting of SQL Server Authorization: Enter『SQL Server Surface Area Configu

Chapter 3 Before Using eServer 3-4 Revision March, 2014 The Internet Protocol (TCP/IP) Properties dialog box will open. Choose Use the following

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-21 Select Avaliable privileges. Then, press『>』. Press OK.

Chapter 10 Writing Data in SQL Server 2005 10-22 Revision March, 2014  Setting of SQL Server 2005 Database: Click Start  All Program  Microsoft

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-23 Go to the window of 【Object Explorer】. Right click【Database】, then select

Chapter 10 Writing Data in SQL Server 2005 10-24 Revision March, 2014 When establishing the database, 『Test』 has been created in【Databases】 which

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-25 Then, please click Save to save the column name, see as below. A Choose Na

Chapter 10 Writing Data in SQL Server 2005 10-26 Revision March, 2014  ODBC Setting: The installation of SQL Server 2005 and SQL Server Managem

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-27

Chapter 10 Writing Data in SQL Server 2005 10-28 Revision March, 2014 Please select SQL Server as the driver. Then, click【Finish】. Please note th

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-29 Please select 【With Windows NT authentication using the network login ID (

Chapter 10 Writing Data in SQL Server 2005 10-30 Revision March, 2014 Use the default value and click【Finish】. It shows ODBC is installed, which

Chapter 3 Before Using eServer Revision March, 2014 3-5 3.2.2 Setting HMI Network Start DOPSoft software program and click Options > Communi

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-31 Click【SQL Server ODBC Data Source Test】and test some items. If no problem

Chapter 10 Writing Data in SQL Server 2005 10-32 Revision March, 2014 10.1.2 Create HMI Project File Enable DOPSoft. B10E615 is created in this exa

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-33 Enter「Selection」「Communication Setting」「Ethernet」 setup HMI IP Address

Chapter 10 Writing Data in SQL Server 2005 10-34 Revision March, 2014 10.1.3 eServer Setting 1. Open a new project of Logging (ODBC) and click「 」

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-35 Add nodes. Select the screen project and click【OK】, then click【Next】.

Chapter 10 Writing Data in SQL Server 2005 10-36 Revision March, 2014 This page is for setting ODBC. Please refer to the following description: ODB

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-37 Please add the logging address ($100, $200, $300) which is set by screen p

Chapter 10 Writing Data in SQL Server 2005 10-38 Revision March, 2014 Click【save 】 first then click【execute 】. Please enter the password to ac

Chapter 10 Writing Data in SQL Server 2005 Revision March, 2014 10-39 10.1.4 View Data from SQL Server 2005 Database Go to SQL Server Management

Revision March, 2014 11-1 Chapter 11 Writing Data in Oracle Before creating testing example, make sure to change the upload and download option (O

Chapter 3 Before Using eServer 3-6 Revision March, 2014 3.4 eServer Options Start eServer and click Tool > Options to synchronize Time and

Chapter 11 Writing Data in Oracle 11-2 Revision March, 2014 Then, accept the license agreement and download OracleXEUniv.exe, which is the mult

Chapter 11 Writing Data in Oracle Revision March, 2014 11-3 Click on Next button to go to the next step. The users must read license agreemen

Chapter 11 Writing Data in Oracle 11-4 Revision March, 2014 Select the default directory C:\oraclexe, and click on Next button for the next ste

Chapter 11 Writing Data in Oracle Revision March, 2014 11-5 The users can review the settings before proceeding with the Installation. Click o

Chapter 11 Writing Data in Oracle 11-6 Revision March, 2014 Click on Finish button to complete Oracle Database 10g setup. 2. ODBC Setup In the

Chapter 11 Writing Data in Oracle Revision March, 2014 11-7 In the ODBC Data Source Administrator dialog box, select System DSN tab and click on

Chapter 11 Writing Data in Oracle 11-8 Revision March, 2014 Now complete Oracle ODBC Driver Configuration as mentioned in the below dialog. Dat

Chapter 11 Writing Data in Oracle Revision March, 2014 11-9 Enter username and password for the database and press Login button to enter into

Chapter 11 Writing Data in Oracle 11-10 Revision March, 2014 Click on Table link.

Chapter 11 Writing Data in Oracle Revision March, 2014 11-11 Enter the name of the table. In this case, the name of the new table is entered as

Revision March, 2014 i Table of Contents Chapter 1 Introduction 1.1 eServer Data Collection Software ...

Chapter 3 Before Using eServer Revision March, 2014 3-7

Chapter 11 Writing Data in Oracle 11-12 Revision March, 2014 Click on Finish button to complete the settings. Click on Create button to create

Chapter 11 Writing Data in Oracle Revision March, 2014 11-13 11.1.2 Create HMI Project File Start DOPSoft software program and click File >

Chapter 11 Writing Data in Oracle 11-14 Revision March, 2014 Click Options > Communication Setting > Ethernet > LocalHost, set HMI IP A

Chapter 11 Writing Data in Oracle Revision March, 2014 11-15 11.1.3 eServer Setting 1. After eServer is enabled, eServer icon will appear at

Chapter 11 Writing Data in Oracle 11-16 Revision March, 2014 4. Select icon to enable ODBC Logging Wizard. Press Next button to go to next

Chapter 11 Writing Data in Oracle Revision March, 2014 11-17 5. Click New icon to access nodes (link to HMI). Choose Transfer from Delta – HMI

Chapter 11 Writing Data in Oracle 11-18 Revision March, 2014 eServer will ask user to input the authorize password to connected with HMI. (The

Chapter 11 Writing Data in Oracle Revision March, 2014 11-19 Press Next button to go to next step. 7. Register Setting: Set the register addre

Chapter 11 Writing Data in Oracle 11-20 Revision March, 2014 8. Select the Type as Trigger. Then, set the format of address $0.0 to Rising edge

Chapter 11 Writing Data in Oracle Revision March, 2014 11-21 10. Press icon. After the password is entered, the system will start sampling o

Chapter 3 Before Using eServer 3-8 Revision March, 2014 3.4.2 Synchronize Function Click Tool > Options to enter eServer Option dialog box.

Chapter 11 Writing Data in Oracle 11-22 Revision March, 2014 11. Open the browser and go back to the Oracle database. Click on Data link. Ther

Revision March, 2014 12-1 Chapter 12 Recipe Access Setting 12.1 Detailed Settings Please refer to the following steps to complete Excel sampling

Chapter 12 Recipe Access Setting 12-2 Revision March, 2014 Click icon to link HMI screen project file. There are two methods available for sel

Chapter 12 Recipe Access Setting Revision March, 2014 12-3 eServer will ask user to input the authorize password to connected with HMI. (The de

Chapter 12 Recipe Access Setting 12-4 Revision March, 2014 12.1.2 Register Setting This step is used to set the register addresses of the datab

Chapter 12 Recipe Access Setting Revision March, 2014 12-5 Export - Fixed Export - Variance Setting Item Description Remark No. Excel Sheet in

Chapter 12 Recipe Access Setting 12-6 Revision March, 2014 12.1.3 Sampling Conditions This step is used to set the sampling conditions. There a

Chapter 12 Recipe Access Setting Revision March, 2014 12-7 Setting Item Description Remark Trigger: Execute sampling when the trigger conditions

Revision March, 2014 13-1 Chapter 13 Recipe Access Example Before creating testing example, make sure to change the upload and download option (O

Chapter 13 Recipe Access Example 13-2 Revision March, 2014 13.1.1 New Project Start eServer, and click File > New or click New icon After

Chapter 3 Before Using eServer Revision March, 2014 3-9

Chapter 13 Recipe Access Example Revision March, 2014 13-3

Chapter 13 Recipe Access Example 13-4 Revision March, 2014 13.1.2 Node Click icon to link HMI screen project file. There are two methods avai

Chapter 13 Recipe Access Example Revision March, 2014 13-5 Input correct password then eServer will get HMI data like HMI Name, IP address as be

Chapter 13 Recipe Access Example 13-6 Revision March, 2014 After completing all the settings on eServer, use the most updated DOPSoft program e

Chapter 13 Recipe Access Example Revision March, 2014 13-7 Networking Settings Ensure to observe the following instructions to complete PC netw

Chapter 13 Recipe Access Example 13-8 Revision March, 2014 Double-click Network Connections icon, the following windows will appear. Right-click

Chapter 13 Recipe Access Example Revision March, 2014 13-9 The Internet Protocol (TCP/IP) Properties dialog box will open. Choose Use the follow

Chapter 13 Recipe Access Example 13-10 Revision March, 2014 After networking settings are set correctly and successfully, return to eServer, sa

Chapter 13 Recipe Access Example Revision March, 2014 13-11 When eServer performs reading, due to enable the auto refresh on startup, eServer wi

Chapter 13 Recipe Access Example 13-12 Revision March, 2014 ConditionAs for the method of sampling condition, select Const (execute sampling rep

Chapter 3 Before Using eServer 3-10 Revision March, 2014 3.4.3 Disconnect Function This function allows the system to display warning message

Chapter 13 Recipe Access Example Revision March, 2014 13-13 Networking Settings Ensure to observe the following instructions to complete PC net

Chapter 13 Recipe Access Example 13-14 Revision March, 2014 The Local Area Connection Properties dialog box will open. Use General tab to selec

Chapter 13 Recipe Access Example Revision March, 2014 13-15 Then, press OK button to finish the settings. Setting IP Address in HMI Enter into

Chapter 13 Recipe Access Example 13-16 Revision March, 2014 After completing all the settings and make sure that the communication is good, use

Chapter 13 Recipe Access Example Revision March, 2014 13-17 Press icon. The following dialog box will pop-up and ask the users to enter the pa

Chapter 13 Recipe Access Example 13-18 Revision March, 2014 Then, the system will examine and check if the saved file name is saved in the desti

Chapter 13 Recipe Access Example Revision March, 2014 13-19 13.1.4 Setting and Condition - Export Export – Fixed Settinga. Press : to add fi

Chapter 13 Recipe Access Example 13-20 Revision March, 2014 After completing all the settings, please make sure that the IP address numbers of s

Chapter 13 Recipe Access Example Revision March, 2014 13-21 Double-click Network Connections icon, the following windows will appear. Right-cli

Chapter 13 Recipe Access Example 13-22 Revision March, 2014 The Internet Protocol (TCP/IP) Properties dialog box will open. Choose Use the foll

Chapter 3 Before Using eServer Revision March, 2014 3-11

Chapter 13 Recipe Access Example Revision March, 2014 13-23 Setting IP Address in HMI Enter into the system menu and set IP address to 172.16.1

Chapter 13 Recipe Access Example 13-24 Revision March, 2014 Then, compile it and download the recipe data to HMI. After recipe data is download

Chapter 13 Recipe Access Example Revision March, 2014 13-25 Please enter 12345678 in the filed of the password at the first time (12345678 is th

Chapter 13 Recipe Access Example 13-26 Revision March, 2014 Please refer to the figure on next page: Trigger $0.0

Chapter 13 Recipe Access Example Revision March, 2014 13-27 On the other hand, if incorrect or invalid password is entered, the following error

Chapter 13 Recipe Access Example 13-28 Revision March, 2014 ConditionAs for the method of sampling condition, select Trigger (Execute sampli

Chapter 13 Recipe Access Example Revision March, 2014 13-29 Networking Settings Ensure to observe the following instructions to complete PC net

Chapter 13 Recipe Access Example 13-30 Revision March, 2014 The Local Area Connection Properties dialog box will open. Use General tab to selec

Chapter 13 Recipe Access Example Revision March, 2014 13-31 Then, press OK button to finish the settings. Setting IP Address in HMI Enter into

Chapter 13 Recipe Access Example 13-32 Revision March, 2014 After completing all the settings and make sure that the communication is good, use

Chapter 3 Before Using eServer 3-12 Revision March, 2014 3.5 Make Runtime Shortcut Start eServer and click Tool > Make Runtime Shortcut to c

Chapter 13 Recipe Access Example Revision March, 2014 13-33 Check the box before Translate All and press OK button, the following dialog box wi

Chapter 13 Recipe Access Example 13-34 Revision March, 2014 $100 $0.0 (1) Input “TINA” first (2) Trigger Rising edge

Chapter 13 Recipe Access Example Revision March, 2014 13-35 On the other hand, if incorrect or invalid password is entered, the following error

Chapter 13 Recipe Access Example 13-36 Revision March, 2014 This page intentionally left blank

Revision March, 2014 A-1 Appendix A Upload/Download via Ethernet A.1 Environment Settings The default setting of upload and download on DOPSoft

Appendix A Upload / Download via Ethernet A-2 Revision March, 2014 In Environment dialog box, change the default setting of upload and download

Appendix A Upload / Download via Ethernet Revision March, 2014 A-3 A.2 Communication Setting If the users choose to use DHCP mode, please into O

Appendix A Upload / Download via Ethernet A-4 Revision March, 2014 If the users choose to use user-defined IP address, please into Options >

Appendix A Upload / Download via Ethernet Revision March, 2014 A-5 Then, observe the following instructions to complete PC networking settings.

Appendix A Upload / Download via Ethernet A-6 Revision March, 2014

Chapter 3 Before Using eServer Revision March, 2014 3-13 When selecting the desired method, press Install button to finish the settings. If th

Appendix A Upload / Download via Ethernet Revision March, 2014 A-7 Double-click Network Connections icon, the following windows will appear. Righ

Appendix A Upload / Download via Ethernet A-8 Revision March, 2014 The Internet Protocol (TCP/IP) Properties dialog box will open. Choose Use th

Appendix A Upload / Download via Ethernet Revision March, 2014 A-9 A.3 Compile and Upload / Download All Data After completing PC networking set

Appendix A Upload / Download via Ethernet A-10 Revision March, 2014 Then, the following dialog box will appear. The users can check the box be

Chapter 3 Before Using eServer 3-14 Revision March, 2014

Chapter 3 Before Using eServer Revision March, 2014 3-15

Chapter 3 Before Using eServer 3-16 Revision March, 2014 This page intentionally left blank.

Table of Contents ii Revision March, 2014 4.1.3 Excel Logging Range Setting ...

Revision March, 2014 4-1 Chapter 4 Excel Sampling Setting 4.1 Detailed Settings Please refer to the following steps to complete Excel sampling se

Chapter 4 Excel Sampling Setting 4-2 Revision March, 2014 Click icon to link HMI screen project file. There are two methods available for sel

Chapter 4 Excel Sampling Setting Revision March, 2014 4-3 2. Transfer from Delta – HMI: Transfer the HMI screen project file via network communi

Chapter 4 Excel Sampling Setting 4-4 Revision March, 2014 4.1.2 Excel Template Sheet Design This step is used to create the desired Excel templ

Chapter 4 Excel Sampling Setting Revision March, 2014 4-5 4.1.3 Excel Logging Range Setting This step is used to specify the logging range to w

Chapter 4 Excel Sampling Setting 4-6 Revision March, 2014 Sampling Direction Diagram Multi-Horizontal: When this option is selected, multiple n

Chapter 4 Excel Sampling Setting Revision March, 2014 4-7 In Excel template sheet, use the mouse to decide the selection range. After the desire

Chapter 4 Excel Sampling Setting 4-8 Revision March, 2014 The format of the date and time is specified by a string of characters which can be us

Chapter 4 Excel Sampling Setting Revision March, 2014 4-9 4.1.4 Register Setting This step is used to set the register address of the sampling

Chapter 4 Excel Sampling Setting 4-10 Revision March, 2014 Setting Item Description Remark Integer 1. If the register address is set to Bit, th

Table of Contents Revision March, 2014 iii Chapter 9 Writing Data in MySQL 9.1 Example ...

Chapter 4 Excel Sampling Setting Revision March, 2014 4-11 4.1.5 Sampling Conditions This step is used to set the sampling conditions. There ar

Chapter 4 Excel Sampling Setting 4-12 Revision March, 2014 Polling Cycle (Sampling Cycle): It is used to determine how long the sampling proces

Chapter 4 Excel Sampling Setting Revision March, 2014 4-13 There are two parts in this dialog box: 1. Excel Sheet A. Repeat When the sampling

Chapter 4 Excel Sampling Setting 4-14 Revision March, 2014 C. Add a new sheet When the sampling data has been filled in the selection range to

Chapter 4 Excel Sampling Setting Revision March, 2014 4-15 %y Year %H Hour %M Minute %S Second C. Auto Save: When this option is enabled, the s

Chapter 4 Excel Sampling Setting 4-16 Revision March, 2014 D. Overwrite the file when saving This function default is enable, it means when lo

Chapter 4 Excel Sampling Setting Revision March, 2014 4-17 When time arrived one minute, the data range still not full, and due to enable overwr

Chapter 4 Excel Sampling Setting 4-18 Revision March, 2014 Step1. Uncheck eServer node to logging. Step2. If uncheck usage each node, it have t

Chapter 4 Excel Sampling Setting Revision March, 2014 4-19 ODBC： ODBC logging also provide user could select usage node or not. And the default

Chapter 4 Excel Sampling Setting 4-20 Revision March, 2014 c. If set allow nulls for null and does set default value like 222, eServer will fil

Table of Contents iv Revision March, 2014 13.1.3 Setting and Condition - Import ...1

Revision March, 2014 5-1 Chapter 5 Writing Data in Microsoft Excel Before creating testing example, make sure to change the upload and download op

Chapter 5 Writing Data in Microsoft Excel 5-2 Revision March, 2014 Click Options > Communication Setting > Ethernet > LocalHost, set H

Chapter 5 Writing Data in Microsoft Excel Revision March, 2014 5-3 5.1.2 eServer Setting 1. After eServer is started, eServer window will open.

Chapter 5 Writing Data in Microsoft Excel 5-4 Revision March, 2014 Press Next button to go to next step. 5. Click New icon to access nodes (li

Chapter 5 Writing Data in Microsoft Excel Revision March, 2014 5-5 Choose Transfer from Delta – HMI option to transfer the HMI screen project fi

Chapter 5 Writing Data in Microsoft Excel 5-6 Revision March, 2014 After searching HMI IP in Ethernet, select HMI Name is HMI, IP is 172.16.190.

Chapter 5 Writing Data in Microsoft Excel Revision March, 2014 5-7 The system will enable Excel automatically. Create a Excel template sheet as

Chapter 5 Writing Data in Microsoft Excel 5-8 Revision March, 2014 7. Excel Logging Range Setting 7.1 Set the sampling direction as Multi-Verti

Chapter 5 Writing Data in Microsoft Excel Revision March, 2014 5-9 7.3 In Excel template sheet, the users can drag the mouse to select the selec

Chapter 5 Writing Data in Microsoft Excel 5-10 Revision March, 2014 Use the following dialog box to set the sampling register addresses. 9. Se

Table of Contents Revision March, 2014 v About this Manual… User Information Be sure to store this manual in a safe place. Due to constantly grow

Chapter 5 Writing Data in Microsoft Excel Revision March, 2014 5-11 11. Press icon and enter the password 12345678. Then, the system will star

Chapter 5 Writing Data in Microsoft Excel 5-12 Revision March, 2014 12. If the users want to pause or stop the sampling operation, only right-c

Revision March, 2014 6-1 Chapter 6 ODBC Sampling Setting 6.1 Detailed Settings Please refer to the following steps to complete ODBC sampling setti

Chapter 6 ODBC Sampling Setting 6-2 Revision March, 2014 Click icon to link HMI screen project file. There are two methods available for sele

Chapter 6 ODBC Sampling Setting Revision March, 2014 6-3 2. Transfer from Delta – HMI: Transfer the HMI screen project file via network communica

Chapter 6 ODBC Sampling Setting 6-4 Revision March, 2014 6.1.2 ODBC (Open Data Base Connectivity) This step is used to create an ODBC Data Sourc

Chapter 6 ODBC Sampling Setting Revision March, 2014 6-5 ODBC sampling setting provide refresh button. This function could help user to select t

Chapter 6 ODBC Sampling Setting 6-6 Revision March, 2014 6.1.3 Register Setting This step is used to set the register address of the sampling da

Chapter 6 ODBC Sampling Setting Revision March, 2014 6-7 Setting Item Description Remark Integer 1. If the register address is set to Bit, this

Chapter 6 ODBC Sampling Setting 6-8 Revision March, 2014 6.1.4 Sampling Conditions This step is used to set the sampling conditions. There are t

Revision March, 2014 Publication History Please include the Name of Manual and the Issue Version both shown as below when communicating with us

Chapter 6 ODBC Sampling Setting Revision March, 2014 6-9 Polling Cycle (Sampling Cycle): It is used to determine how long the sampling process i

Chapter 6 ODBC Sampling Setting 6-10 Revision March, 2014 This page intentionally left blank

Revision March, 2014 7-1 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Before creating testing example, make s

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-2 Revision March, 2014 2. Enabling MSDE Execute SVRNETCN.exe () within

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-3 Click Add Port button and the following Add a Po

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-4 Revision March, 2014 4. Activating SQL Server Double-click the loc

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-5 Then, click New icon and choose Project using ne

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-6 Revision March, 2014 Press Finish button to complete the settings.

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-7 In the Table dialog box, create a database like

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-8 Revision March, 2014 Please press No button to complete the settings.

Revision March, 2014 1-1 Chapter 1 Introduction 1.1 eServer Data Collection Software eServer is a PC software used to help the customers collec

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-9 In the ODBC Data Source Administrator dialog box

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-10 Revision March, 2014 In the Create a New Data Source to SQL Server d

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-11 Change the default database to DELTA. Press Ne

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-12 Revision March, 2014 Press OK button to complete ODBC setup.

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-13 7.1.2 Create HMI Project File Start DOPSoft so

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-14 Revision March, 2014

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-15 7.1.3 eServer Setting 1. After eServer is star

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-16 Revision March, 2014 Press Next button to go to next step. 5. Clic

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-17 After searching HMI IP in Ethernet, select HMI

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-18 Revision March, 2014 Press Next button to go to next step. 7. Regi

Chapter 1 Introduction 1-2 Revision March, 2014 1.2 Supported Models The supported models for eServer Data Collection Software are listed in t

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Revision March, 2014 7-19 8. Set the sampling conditions to constant 5s.

Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7-20 Revision March, 2014 10. If the users want to pause or stop the sam

Revision March, 2014 8-1 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Before creating testing example, make sure to change the u

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-2 Revision March, 2014 After running the self-extracting file, starting the insta

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-3 Feature selection. Set as below figure and click『Next』.

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-4 Revision March, 2014 Choose the authentication mode. Set as below figure and cl

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-5 Setup the error report way. Set as below figure and click

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-6 Revision March, 2014 The progress of installation shows as , and then click『Nex

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Revision March, 2014 8-7 2. SQL Server Configuration Setup： Start『SQL Server Confi

Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8-8 Revision March, 2014 Restart the instance of SQL server.