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.
Commenti su questo manuale