Home

Chapter 2

1. 2 ICE DNE m 000 DER Ee th dati 7 a a a f M tl ij x Please layout excel and then click close button to next step 74 HN Sheet1 Sheet _ qe i T Ready NUM SCRL 7 Excel Logging Range Setting 7 1 Set the sampling direction as Multi Vertical Sheetl Multi Vertical CO Multi Horizontal C Single Vertical CO Single Horizontal Anywhere 7 2 Press Excel button and the system will open the editing Excel template sheet immediately You could be cdicked the right button to execute Excel then decided the range tase 8 m 5 8 Revision October 2010 Ea eer Vet Chapter 5 Writing Data in Microsoft Excel 7 3 In Excel template sheet the users can drag the mouse to select the selection range In this case C3 D20 is selected Then press Close button to finish Ba Microsoft Excel Tem461 Cz F qt AS 8 E F H a 1 cb ee ee 5 nl i ss B C 1 ll 22 Please decide the selection range and then click the close button Selection 1020 M 4 3 HN Sheet he TR Ready NUM
2. EN mE Print Typesetting Screen Screen 1j a Bank Screen Screen 1 Text Bank Screen Properties Detail S bm Background Color 255 255 2 Initial Macro Screen Open Macro 0 T Background Macro Screen Close Macro 0 Clock Macro Screen Cycle Macro 2 Screen Width 640 Screen Height 480 n B List Preview Output a xX Step Action 1 Create element gt J Delete element 2 Create element Create element ji gt Gh E EB EH Download USB 366 14 179 40 W 220 83 DOP AE10THTD1 65536 Colors NUM Record Output Change Window Position The following Remote Setting dialog box will appear Check the check box before Enable eServer Remote and set a password for network communication After OK button is pressed HMI networking is completed Compile the edited project file at the end of the programming and the edited project file could be transferred to HMI Romote Setting Enable eServer Remote Password 12345678 screen sample time in 100 z Revision October 2010 9 15 Oo TR Chapter 9 Writing Data in Oracle EZ erar 9 1 3 eServer Setting 1 After eServer is enabled eServer AW icon will appear at the bottom right of Windows screen Right click this icon and select Setting option from the pop up menu 5
3. mysql 17 hpn phpmyadmin 7 Create new database al az Collation Show MySQL runtime Tain I Shaw MySQL system variables Revision October 2010 8 27 12 Click on Structure link 09 Server localhost zi Database test Structure 77 feilmport Be Operations Privileges Table Action Records Type Collation Size Overhead il table general ci 1 0 KiB 1 table s Sum 0 MyISAM general ci 1 0 KiB OB t Check All Uncheck All With selected amp Print view Data Dictionary al Create new table on database test Name Number of fields 13 The recorded data will be shown at the bottom of the window 93 Server localhost gt Database test gt Table table1 4 E Browse Structure 501 Search X Insert E import Operations Drop Showing rows 0 29 109 total Query took 0 0392 sec SQL query 4 SELECT FROM table1 LIMIT 0 30 Edit Explain SQL Create PHP Code Refresh Query results operations 1 is Print view i Print view with texts Export 30 row s starting from record 30 Page 1 horizontal v mode and repeatheadersafter 100 cells T gt Time 4 X 10 19 2009 18 25 07 4
4. 2 Then open eServer window 2 eServer File View Wizad Tool Help 4 G mo 9 Project 22 eServer 3 Click File gt New or click icon to create a new project file View Wian Tool Help ibd 9 16 Revision October 2010 4 Select icon to enable ODBC Logging Wizard i Recipe Access Logging ODBC yea raS onn Location C Documents and Settings Tina Lee Desktop iol ae Add ta me current cres Wizard Logging Welcome to the ODBC Logging Wizard This wizard helps you how to logging data from HMI to Database To continue click Next Press Next button to go to next step Revision October 2010 Chapter 9 Writing Data in Oracle Er a Serva 5 Click New icon to access nodes link to HMI Wizard Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Llinakge name Please cick the following buttons to access nodes To continue dick Next Choose Transfer from Delta HMI option to transfer the HMI screen project file via network communication directly Transfer Path Please select the following 2 methods to link 1 CO Select a exist Screen DOP file from stroed media 2 Tansfer
5. DELTA ELECTRONICS INC www delta com tw industrialautomation IABU Headquarters Delta Electronics Inc Taoyuan 31 1 Xingbang Road Guishan Industrial Zone Taoyuan County 33370 Taiwan R O C TEL 886 3 362 6301 FAX 886 3 362 7267 Asia Delta Electronics Jiang Su Ltd Wujiang Plant3 1688 Jiangxing East Road Wujiang Economy Development Zone Wujiang City Jiang Su Province People s Republic of China Post code 215200 TEL 86 512 6340 3008 FAX 86 512 6340 7290 Delta Greentech China Co Ltd 238 Min Xia Road Cao Lu Industry Zone Pudong Shanghai People s Republic of China Post code 201209 TEL 021 58635678 021 58630003 Delta Electronics Japan Inc Tokyo Office Delta Shibadaimon Building 2 1 14 Shibadaimon Minato Ku Tokyo 105 0012 Japan TEL 81 3 5733 1111 FAX 81 3 5733 1211 Delta Electronics Korea Inc 234 9 Duck Soo Building 7F Nonhyun Dong Kangnam Gu Seoul Korea 135 010 TEL 82 2 515 5305 FAX 82 2 515 5302 Delia Electronics Singapore Pte Lid 8 Kaki Bukit Road 2 04 18 Ruby Warehouse Complex Singapore 417841 TEL 65 6747 5155 FAX 65 6744 9228 Delta Power Solutions India Pte Ltd Plot 28 Sector 34 Gurgaon 122001 Haryana India TEL 91 124 416 9040 FAX 91 124 403 6045 America Delta Products Corporation USA Raleigh Office P O Box 12173 5101 Davis Drive Research Triangle Park NC 27709
6. 7 4 User s fame sa Password User s password 0000 What do you want to name your new SQL Server database Press Next button to continue Revision October 2010 7 5 Chapter 7 Writing Data in Microsoft Access Microsoft SOL Server Database Wizard The wizard has all the information it needs to create your SOL Server database Finish Press Finish button to complete the settings Then click Design in the following pop up window to create a database table in Design EIE Objects Queries Database Diagrams Forms Reports Pages Macros Modules Groups Favorites 7 6 Revision October 2010 aoe d NT In the Table dialog box create a database like the following figure shown below Tablei Table DataType Data Lenath allow Hulls 1 Cid Description 50 Column Default value Formula Collation database default gt Format Input Mask After editing the table close the window to give a name for this table such as Table 1 Jablel a E DataType Length Allow Nl i 50 v char char char Choose Name Enter name For the table Cancel Help Columns Lookup Default value js Bowisula Formula Collation lt database default Format HADE Input
7. File Edit View Favorites Tools Help gt gt Tools ew ae Da appserverne EL Microsoft 50 U microsoft 50 Microsoft 50 appserv E The AppServ Open Project 2 5 10 for Windows 58 phpMyAdmin Database Manager Version 2 10 3 PHP Information Version 5 2 6 About AppServ Version 2 5 10 for Windows AppServ is a merging open source software installer package for Windows includes e Apache Web Server Version 2 2 8 e PHP Script Language Version 5 2 6 MySQL Database Version 5 0 51b phpMyAdmin Database Manager Version 2 10 3 ChangeLog README AUTHORS COPYING Official Site http vweww AppSereNetwork com Hosting support by http www AppServeHosting com Change Language mee Easy way to build Webserver Database Server with AppServ Done J Local intranet 10095 8 6 Revision October 2010 EZ a Ser Ver Chapter 8 Writing Data in MySQL 2 MySQL Settings Use phpMyAdmin built in AppServ to perform the relevant MySQL settings Open the browser type http localhost phpMyAdmin a Connect to localhost dialog box will display Enter root for username and your password for password The default administrator account is root but depending on your setup it may be a different user name Connect to localhost The server localhost at phpMyAdmin running on localhost requires a username and password Wa
8. Dapsaft 1 00 00 The system will detect if the HMI firmware is the same as the firmware included eServer If the HMI firmware is older than the firmware included in eServer a warning message will pop up to ask for updating the firmware After clicking Update Firmware Tool the following dialog box will appear for the users to select the communication interface the default setting is USB driver Press Update button to update HMI firmware automatically The function of Update Firmware Tool is the same as the function of Update Firmware provided in eServer click Tool gt Update Firmware Update Firmware Tool v1 2 Model Version Reinstall AES O 1 086 AES fC 1 086 AESOC16 1 086 940 1 086 10 16 108 ethemet 1 088 10 200 1 088 2 About Made Selection 10 615 2 0203 Revision October 2010 3 1 Chapter 3 Before Using eServer EZ erar 3 2 Networking Settings Ensure to observe the following instructions to complete PC networking settings before eServer operation 3 2 1 Setting PC Network Programs Documents Control Panel eFings Network Connections Search Printers and Faxes Help and Support Taskbar and Start Menu Run Shut Down Windows XP Professional Power on PC and start Windows Click Start gt Programs point to Control Panel and then select Network Con
9. device Bridge Connections 9 Repair this connection Creare Shorkeuk mil Rename this connection Delete Lu View status of this Rename connection Change settings of this Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Local Area Connection Properties General Authentication Advanced Connect using This connection uses the following Items Client For Microsoft Networks File and Printer Sharing for Microsoft Networks aas Packet Scheduler Internet Protocol TCP IP Install Jrwerstall Properties Description Transmission Control Pratacol Intermet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon notification area when connected Notify me when this connection has limited connectivity The Internet Protocol TCP IP Properties dialog box will open Choose Use the following IP address and enter the IP address numbers of the PC into the field of IP address and Subnet mask Revision October 2010 11 19 Internet Protocol TCP IP Properties General fou can get IF settings assigned automatically if pour network supports this capability Othenvise pou need to ask your network administrator for the appropriate
10. Pe sau 4 7 4 125 Sampling Conditions xxu bia p eet ve ob iubet 4 9 SCEUNG ENSE ext IN DEVE 4 10 Chapter 5 Writing Data in Microsoft Excel SM EE Cone er TETTE 5 Sb Create HMEPEOJSCE eie e iau i va tac 5 dicia UE 5 4 Chapter 6 ODBC Sampling Setting 6 1 Detailed Setting s Vidc cand 6 1 6 1 6 1 2 ODBC Open Data Base 6 3 Register 6 5 Samping 6 6 Chapter 7 Writing Data Microsoft Access cu NEUESTE 7 1 Database T 7 1 Create HMI Project File 7 13 TP PE nHHE 7 16 Chapter 8 Writing Data MySQL D d une a a rout atus td ort dune 8 9 T T Software 8 1 9 152 Create
11. 8 19 8 142 na te xen 8 22 Chapter 9 Writing Data Oracle EXA rS 9 1 ii Revision October 2010 EZ cerei Table of Contents 9 1 1 Software Installation 9 rene gs MET 9 13 9 1 3 eServer Setting 2 0 6 0 0000 eene 9 16 Chapter 10 Recipe Access Setting 10 1 Detailed 5 5 10 1 IURE 10 1 10 1 2 Register Setting 10 3 10 125 CoDdIitIOfiS EE dod 10 5 Chapter 11 Recipe Access Example IELI oe E aE ieie a eee LUAM Pes 11 1 Pille 11 2 BA 11 3 11 1 3 Setting and Condition Import 11 4 11 1 4 Setting and Condition 1 6 nnns 11 16 Appendix Upload Download via Ethernet Configuration Settings 1 1 6 nan 1 AL 3 Compile and Upload Downloa
12. V eens 2 1 2 1 1 2 1 Chapter 3 Before Using eServer 3 1 Jdpaate CE 3 3 2 Networking 5 RUE d CE 3 2 3 2 4 NeOWOFK sese dae bu doe PUE 3 2 2 2 2 TAMING 3 5 9 9 Starte SSN 3 6 UTI T 3 Seal 3Synenrontze FUlCLIOD 3 224 202 DISCONNECT FUMCUO MM EM 3 9 924 OSE 3 10 3 5 Make 3 11 Chapter 4 Excel Sampling Setting 4 1 Detaled 4 1 que SEU 4 4 1 2 Excel Template Sheet Design esee 4 3 4 1 3 Excel Logging Range 4 4 Revision October 2010 TableofContents Register
13. ji gt HM BEGG Download USB 366 14 179 40 W 220 83 DOP AE10THTD1 65536 Colors NUM Record Output Change Window Position The following Remote Setting dialog box will appear Check the check box before Enable eServer Remote and set a password for network communication After OK button is pressed HMI networking is completed Compile the edited project file at the end of the programming and the edited project file could be transferred to HMI Romote Setting Enable eServer Remote Password 12345678 screen sample time in 100 z Revision October 2010 5 3 Chapter 5 Writing Data in Microsoft Excel 5 1 2 eServer Setting 1 After eServer is enabled eServer AW icon will appear at the bottom right of Windows screen Right click this AW icon and select Setting option from the pop up menu Excel Visible fo 9 2 Then eServer window will open Peery rr rrr 5 4 Revision October 2010 Ead Chapter 5 Writing Data in Microsoft Excel 3 Click File gt New or click icon to create new project file File Viw Wired Tool Help dx Logging Logging Recipe Excel ODBC Access Wizard Logrzingz Welcome to the Excel Logging Wizard This wizard helps you how to logging data from HMI to Excel Attenation The wizard program only support Excel 2000 2003 2007 and Excel 2010 The new version of Exce
14. Data Source Mame OrcaleS QL Cancel Description Help TNS Service Test Connection User ID Application Oracle workarounds SOLS ener Migration Enable Result Sets Enable Quer Timeout v Read Only Connection Enable Closing Cursors Enable Thread Safety iv Batch amp utocommit Mode Commit only if all statements succeed Numeric Settings Use Oracle NLS settings T Data Source Name Enter ODBC data source name enter the name of the data source you want to access Description Enter some text to identify the connection TNS Service Name Must select XE in the TNS Service Name drop down list User ID Enter user name system to use for this connection This User ID is also the Username of Oracle database see the figure below ORACLE Database Express Edition Enter your database username and password Username Password Login Click here to learn how ta get started 9 8 Revision October 2010 EZ sers Chapter 9 Writing Data in Oracle 3 Create Database and Table 1 Start Database see the figure below Ira ret Help Backup Database L2 Get Started Restore Database ud Eun SQL Command Line Stop Database fg Cvacle Database 10p Expres Edition 2 1 2 Go to Database homepage ORACLE Database Express Edition Enter your databas
15. Variance Import Made War w No diee 1 1 Name 1 File Name File Name Length Controller PUER Path Ll IEmporti D i16bits HMI 500 IntemalMemory C Documents and Settings Tina Q Le 2 hmpor32 32 bits HMI None 1 setting tem Remark Excel Sheet index which the sampling data will be Unchangeable written If the users want to select 16 bit recipe enable 9 this option by checking the check box Recipe Bit type Unchangeable HMI Name Name of connecting HMI Unchangeable When Fixed is selected It is the file name of the imported file which could be changed and user defined When Variance is selected File Name It is the register address of a certain trigger element Please note When the data format is set to Word the data format of the sampling register address could be Unsigned only Revision October 2010 10 3 207 EZ sera Chapter 10 Recipe Access Setting setting tem Desnpion Remark File Name Number of characters by referring the user defined Length file name Controller Connecting controller Unchangeable Destination Path location where the imported file is Export Fixed M m m p Export Mode Fixed Usage Neme Exporti Eur Name Information Source Path 16 bits 43 Group 3
16. 1593016 K Destination Folder C oracleme 1593016 11287008 Space Required Space Available an Back Cancel Select the default directory C oraclexe and click on Next button for the next step To select a directory other than the default directory click Browse Oracle Database 10g Express Edition Install Wizard Specify Database Passwords ORACLE CATABAZE ifs Enter and confirm passwords for the database This password will be used for both the SS and the SYSTEM database accounts Enter Password HEHEHE Confirm Password EXXXNEMEXM Mate You should use the SYSTEM user along with the password you enter here to log in to the Database Home Page after the install is complete Then enter and confirm the password for the database Click on Next button for the next step 9 4 Revision October 2010 i eem Ver Chapter 9 Writing Data in Oracle Oracle Database 10g Express Edition Install Wizard Summary Review settings before proceeding with the Installation DATABASE LEFBEER bee Curent Installation Settings Destination Folder C soraclexe Fort for Oracle Database Listener 1521 for Oracle Services for Microsoft Transaction Server 2030 Fort for Listener The users can review the settings before proceeding with the I
17. Export Variance ae iM a Rep Export Mode variance No Usage Type Name File Name File Name Length Controller source Path 4 1 6 1 16 bits HMI 5100 2 Export32 1 32 bits None 1 Excel Sheet index which the sampling data will be Unchangeable written If the users want to select 16 bit recipe enable 9 this option by checking the check box Recipe Bit type Unchangeable HMI Name Name of connecting HMI Length and Group of the recipe Unchangeable It is the register address of a certain trigger element File Name Please note When the data format is set to Word the data format of the sampling register address could be Unsigned only 10 4 Revision October 2010 Ead c Sei Ver Chapter 10 Recipe Access Setting setting tem Remark File Name Number of characters by referring the user defined Length file name Controller Connecting controller Unchangeable Destination location where the exported file is Source Path located 10 1 3 Sampling Conditions This step is used to set the sampling conditions There are two kinds of options for selection 1 Const execute sampling repeatedly in a certain span of time This option is used to determine how long the sampling process is repeated The time unit can be defined as ms second minute or hour Detect Sca
18. How long would you like on your logging data 500ms one day jo 0 I zs To continue click Mext 2 Trigger Execute sampling when the trigger conditions are satisfied This option is used to determine how long the sampling process is repeated when the trigger conditions are met The detailed settings are described as follows Wizard Loggins Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition Sheeti To continue dick Next Revision October 2010 4 9 Chapter 4 Excel Sampling Setting EL cera Polling Cycle Sampling Cycle It is used to determine how long the sampling process is repeated The time unit is ms Logging Condition senting nem Remark Sampling type There are two kinds of options for selection Const and Trigger Const Execute sampling repeatedly in a certain span of time Trigger Execute sampling when the trigger conditions are satisfied HMI Name Name of connecting HMI Register Address 1 When the register address is set to Bit the selectable options are A Rising edge Triggered by rising edge B Falling edge Triggered by falling edge Controller Connecting controller Unchangeable 4 1 6 Output Setting This step is used to set how to output and save the sampling data Wizard Logring Output Setting Ecxel Sheet
19. Keyboard Regional and Language Taskbar and Start Menu Intel Graphics Power Options Printers and Faxes Speech System Network Connections Sounds and Audio Devices Scheduled Tasks Security Center Scanners and Cameras ES Wireless Network Set Windows Firewall User Accounts Double click Network Connections icon the following windows will appear Right click the Local Area Connection icon and then select Properties from the pop up menu 11 26 Revision October 2010 Ed eee ye Chapter 11 Recipe Access Example Network Connections File Edit View Favorites Tools Advanced Help sack eJ d Search Folders EHE Address Network Connections LAN or High Speed Internet Network Tasks Area Connection Create 4 Connected Disabl connection Change Windows Status Firewall settings Repair WM Disable this network device Bridge Connections 9 Repair this connection Creare Shorkeuk mil Rename this connection Delete Lu View status of this Rename connection Change settings of this Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Local Area Connection Properties ales General Authentication Advanced 0005020
20. USER CONNECTIONS 0 Edit Create PHP Gode User root Edit Privileges Global privileges Check All Uncheck All Note MySQL privilege names are expressed in English Administration Data Structure SELECT CREATE GRANT INSERT ALTER SUPER UPDATE INDEX PROCESS DELETE DROP RELOAD wl I4 FILE 4l CREATE TEMPORARY TARIFS Revision October 2010 8 13 3 Setting Windows Firewall Click Start and then click Control Panel In the Control Panel click Windows Security Center gt Windows Firewall Then click on the Exceptions tab Windows Firewall General Exceptions Advanced Windows Firewall iz blocking incoming network connections except for the programs and services selected below Adding exceptions allows some programs ta Work better but might increase your security risk Programs and Services Mame m File and Printer Sharing Network Diagnostics for Windows Remote Assistance Remote Desktop SMLM Proxy Module HP1006M C EE Framework Windows Live Messenger 8 1 Windows Live Messenger 8 1 Phone Windows Netheeting Add Program Display a notification when Windows Firewall blocks program What are the riskz of allowing exceptions ru Click Add Port button and the following Add Port dialog box will appear Add a Port Use these settings to open port through Windows Firewall
21. Use Failover Server Ma Use ANSI Quoted Identifiers Use ANSI Hull Paddings and warnings Yes Data Encryption Test Data Source Cancel 7 12 Revision October 2010 DOF Im 7 1 2 Create HMI Project File Start Screen Editor software program and click File gt New or click New icon to create a new project Then click Element gt Input gt Numeric Entry to create two numeric entry elements 3 and 6 on the screen In this case 10 inches color AE type DOP series HMI is used File Edit view Element Screen Tools Options Window Help 9 lt BIU m mim GubgBmem y Screen 1 i j wy Screen Screen 1 Screen Screen 1 Screen Properties Detail Background Color FS 053 495 2 Screen Open Macro 0 Screen Close 0 Screen Cycle Macro 0 Screen Width 640 Screen Height 450 E List L Preview Output a xX Step Action gt i Create elernent Delete elernent gt Create element 4 Create element 1 u Hh CQ a L EL 59 24 EDEN M X Be aj Record Output Download USB 630 201 DOP AE10THTD1 65536 Colors NUM Use Screen Cycle Macro and enter the following commands in macro command window
22. pop up and ask the users to enter the password Authorize TT qp eoo all passwords are the same password under Cancel Please enter 12345678 in the filed of the password at the first time 12345678 is the default setting value and the users can change it freely After the correct password is entered the icon will display on the tool bar at the left bottom corner When eServer performs reading please trigger the character input element TINA and the maintained button element on HMI Then the system will convert the recipe data to the record data of Tina csv file Please refer to the figure on next page 11 30 Revision October 2010 Delta Soft Simulator Y2 21 Kernel Ver R 2 74 diis Recipe Address 1 Delta Soft Simulator V2 21 Kernel Ver R 2 74 Recipe Address 1 nem 3 Revision October 2010 11 31 Chapter 11 Recipe Access Example On the other hand if incorrect or invalid password is entered the following error message dialog box will appear to alert the users 11 32 Revision October 2010 Appendix A Upload Download via Ethernet A 1 Configuration Settings The default setting of upload and download on Screen Editor is via USB If the users need to use Ethernet please a
23. NETHERLANDS B V Sales Office DE WITBOGT 15 5652 AG EINDHOVEN THE NETHERLANDS TEL 31 40 259 2860 FAX 31 40 259 285 Revision October 2010 Chapter 1 Introduction 1 1 eServer Data Collection Software eServer is a PC software used to help the customers collect and transfer production information and history data directly from production site to a PC in the office via Ethernet eServer also supports Microsoft Excel hereinafter Excel software functions such as formulas tables and graphs This allows that the collected data can be saved in user defined Excel file according to various purposes for the customers to easily and quickly create required production reports In addition it also supports ODBC interface which is able to save the collected data to a database for the purpose of management and use in production sites val hy Lu 200914122 30 er os oS suus 2 o ioe E vu A Factory Ethernet Device data Revision October 2010 1 1 Chapter 1 Introduction Bolt 1 2 Supported Models The supported models for eServer Data Collection Software are listed in the table below DOP AE57BSTD DOP series Extension Ethernet DOP AE57GSTD DOP AES7GSTD Module DOP EXINHJ AE is DOP AE Series DOP AE57CSTD required when using eServer
24. New or click New icon After the New dialog box is opened select Logging ODBC icon and press OK button Then the ODBC Logging Wizard will be activated and the following dialog box will appear Press Next button to continue Wizard Logging Welcome to the ODBC Logging Wizard This wizard helps you how to logging data from HMI to Database E So To continue click Next Click New icon to access nodes link to HMI Revision October 2010 6 1 Chapter 6 ODBC Sampling Setting Wizard Logging Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Llinakge name Please cick the following buttons to access nodes To continue dick Next Click 19 icon to link HMI screen project file There two methods available for selection 1 Select an existing Screen DOP file from stored media Open an existing screen project file and set the IP address of the connecting HMI Transfer Path Please select the following 2 methods to link 1 9 Select a exist Screen DOF file from stroed media CAD acuments and Settings shirley lanky DocumentssDemo_ IPAddess 172 1 amp 190 4 2 Tansfer from Delta HMI Cx 6 2 Revision October 2010 Ed cera Chapter 6 ODBC Sampling Setting 2 Transfer from Delta HMI Trans
25. Revision October 2010 8 23 Chapter 8 Writing Data in MySQL EZ sera 5 Click New icon to access nodes link to Wizard Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Llinakge name Please cick the following buttons to access nodes To continue dick Next Choose Transfer from Delta HMI option to transfer the HMI screen project file via network communication directly Transfer Path Please select the following 2 methods to link 1 CO Select a exist Screen DOP file from stroed media 2 Tansfer from Delta Press OK button to go to next step Address Setup Target 172151902 Press OK button to go to next step 8 24 Revision October 2010 aSser oa Chapter 8 Writing Data in MySQL 6 ODBC Data Source Setting Create an ODBC Data Source pointing to your database Please refer to the following settings Wizard ODBC Please indicate the following items Chooses a data source DSN and input user name and password ODBC Data Source User Name Password Database Driver table 1 table 1 To continue dick Next Press Next button to go to next step 7 Register Setting Set the register address of the sampling data Wizard Lorring Regis
26. Screen 1 Cycle Macro Revision October 2010 7 13 EZ cera Click Options Configuration and use Communication tab to select Ethernet and complete HMI networking settings shown as the figure below Then press OK button to finish the settings Configuration Standard Communication Print Default Others Recovery the IP address in HII DHCP HWI Hare HMI IF Address subnet IvIask Default Gateway eRemote DH 490 2 255 755 255 0 Revision October 2010 DOr Im Writing Data in Microsoft Access Next click Options Network Setting gold xl E Configuration Tm Alarm Setup SS 37 xm TUER WX i x 3 U Z qm m lw History Setup Biel a rms ahs hos D mt e Passowrd Table Setting amp 1 1 Screen 1 Tee Table Vek T Print Typesetting Segen Picture Bank Screen Screen 1 Text Bank Screen Properties Detail 255 255 2 Submacro Background Color Initial Macro Screen Open Macro 0 Background Macro Screen Close 0 Clock Macro Screen Cycle Macro 2 Screen Width 640 Ervironment Screen Height 450 n E List Preview Output Step Action 1 Create elem
27. one day 5 B Hour e Minute 5 5 Second 0 ms l Cancel 11 10 Revision October 2010 After completing all the settings please make sure that the IP address numbers of subnet masks of the PC 172 16 190 1 and HMI 1 72 16 190 11 are the same otherwise HMI may not be displayed in the list when finding node Networking Settings Ensure to observe the following instructions to complete PC networking settings before eServer operation Setting PC Network Programs Documents ieEFinigs control Panel Connections Printers and Faxes Help and Support Taskbar and Start Menu Search Run Shut Down Windows XP Professional Power on PC and start Windows Click Start gt Programs point to Control Panel and then e Network select Network Connections ennectiens E Control Panel File Edit wiew Favorites Tools Help 7 Search li Folders Address ao D t Ed i Fa we Control Panel A Ai Accessibility Odd Hardware Add or Administrative Automatic BDE Date and Time gt Switch Category view Options Tools Updates Administrator M 4 gt See Also Display Folder Options Fonts Game Intelig Internet Kevboard Windows Update Controllers Graphics Options a Help and Support tei wA B Network Phone and Power
28. with DOP AE series HMI DOP AESOTHTD product DOP AEIOTHTD DOP B10E615 DOP B Series DOP BO7E415 DOPBOSESIS 5 1 3 System Requirement Below are the system requirements to comply with the operating environment of eServer Monitor Support resolution 1024 x 768 or higher full color display Operation System Windows 2000 Windows XP Windows Vista Windows 7 Microsoft Office 2000 Microsoft Office 2003 Microsoft Office 2007 Printer Printer compatible with Windows 2000 Windows XP Windows Vista Windows 7 Supported Microsoft Office Software 1 2 Revision October 2010 Chapter 2 Software Installation 2 1 eServer Setup In this chapter it will introduce general functions of eServer with Windows The users can use it to design what they want Detail information for each function will be discussed in the following chapters 2 1 1 Software Installation To start the eServer setup please refer to the following steps Step 1 Please start up your computer to Windows 2000 Windows XP Windows Vista Windows 7 system gt Meenen cube p LITT 2 10 43 Revision October 2010 2 1 Chapter 2 Software Installation Ed cenar Step 2 Execute setup exe from Windows taskbar by clicking Start Run After pressing OK the system will setup automatically and the following dialog box will appear for selecting the desired display language
29. 1 2 Create HMI Project File Start Screen Editor software program and click File gt New or click New icon to create a new project Then click Element gt Input gt Numeric Entry to create two numeric entry elements 3 and 6 on the screen In this case 10 inches color AE type DOP series HMI is used File Edit view Element Screen Tools Options Window Help 9 lt BTU AH wm jw GubgBmem y S408 8 5 1 i j wy Screen Screen 1 Screen Screen 1 Screen Properties Detail Background Color FS 053 495 2 Screen Open Macro 0 Screen Close 0 Screen Cycle Macro 0 Screen Width 640 Screen Height 450 E List L Preview Output a xX Step Action gt i Create elernent Delete elernent gt Create element 4 Create element 1 lt HE EGR Etc d MOX Soe Download USB 630 201 DOP AE10THTD1 65536 Colors NUM Record Output Use Screen Cycle Macro and enter the following commands in macro command window Screen 1 Cycle Macro Revision October 2010 8 19 Click Options gt Configuration and use Communication tab to select Ethernet and complete HMI networking settings shown as the figure below Then press OK button to finish the settings
30. 13 24 58 08 5008 13 25 00 08 26 2009 13 25 01 08 26 2009 13 25 02 082262009 13 25 03 08 26 2009 13 25 04 10822612009 13 25 05 08 26 2009 13 25 06 _ 08 26 2008 13 25 07 10822612009 13 25 08 08 26 2009 13 25 09 08 25 2008 13 25 10 0826 2009 13 35 11 _ 25 2008 13 25 12 _ 08 26 2009 13 25 13 08 26 2009 13 25 14 08 26 2009 13 25 15 10 If the users want to pause or stop the sampling operation only right click eServer icon at the bottom right of Windows screen and select Pause or Stop option from the pop up menu the sampling operation will pause and stop immediately Revision October 2010 7 21 Chapter 7 Writing Data in Microsoft Access gestr Ver This page intentionally left blank 7 22 Revision October 2010 Chapter 8 Writing Data in MySQL Before creating testing example make sure to change the upload and download option Options gt Configuration on Screen Editor first The default setting of upload and download is via USB If the users need to use Ethernet please change the default setting by referring to Appendix A 8 1 Example This example is used to help the users to understand how to use eServer to read the data of the register addresses 3 and 6 every second record the data in MySQL via ODBC interface and save the collected data into the specified folder C Data 8 1 1 Software Installation 1 AppServ Introduction AppServ is a free and full featured software of Apach
31. 4 x ose uis uc A223 16 bits Length 3 Group 3 Condition As for the method of sampling condition select Trigger Execute sampling when the trigger conditions are satisfied a Select Trigger b Set Address to the register address of the trigger element In this case the trigger element is a maintained button element and its address is set to 0 0 C Select Format There are two options for selection Rising edge and Falling edge In this case it is set to Rising edge fa After completing all the settings please make sure that the IP address numbers of subnet masks of the PC 172 16 190 1 and HMI 1 72 16 190 11 are the same otherwise HMI may not be displayed in the list when finding node Networking Settings Ensure to observe the following instructions to complete PC networking settings before eServer operation Revision October 2010 11 17 Chapter 11 Recipe Access Example Setting PC Network Programs Documents iebFings Search Help and Support Run Shut Down Windows XP Professional Power on PC and e Network select Network Connections onnections Control Panel File Edit wiew Favorites Tools Help T Search li Folders EL sers Control Panel Connections Printers and Faxes Taskbar and Start Menu sta
32. Mask Click OK button and the following warning dialog will pop up Revision October 2010 7 7 Chapter 7 Writing Data in Microsoft Access Ed Sera Please press No button to complete the settings Microsoft Office Access There is na primary key defined Although a primary key isn t required it s highly recommended 4 table must have primary key For you to define relationships between this table and other tables in the database you want to return to table design and add primary key now 6 ODBC Setup In the Control Panel double click Administrative Tools E Control Panel File Edit View Favorites Tools Help 7 Search Folders Address Control Panel hn m Control Panel Accessibility Add Hardware gt Switch Ea Category View Options 5 Tar See Also Display Folder Options Windows Update Automatic Date and Time Updates Administrator G gt Game Intelit Internet Keyboard Controllers Graphics Options In the Administrative Tools double click Data Sources ODBC Administrative Tools File Edit view Favorites Tools Help Q Back 5 2 Search 22 Folders EHE Address dog Administrative Tools File and Folder Tasks kl Share this Folder Data Sources ODBC Shortcut 2 Other Places Local Security Policy Shortcut 2 Control Panel i Documents Dea
33. My DOCUMEeENCtS 2 omputer PIETIELWOFR PIGCeS 2 Recycle Bin instaiier Language z 1 Please select a language allel OK New Folder Step 3 After pressing OK the system will setup automatically and the users will get the following dialog box to choose destination location 1 1 Even ps 1 DE Select Installanon Folder Ed Choose Install Location Choose the Folder which to install EOF Setup will install eServer in the Following folder To install in a different Folder click Browse and select another Folder Click Next to continue Browse Space available 1 558 Space required 19 7 2 2 Revision October 2010 To select the default directory Program Files Delta Industrial Automation DOP eServer 1 0 click Next gt for the next step Setup will install in the directory indicated in the Destination Directory box at the bottom of the dialog box To select a directory other than the default directory click Browse A list of available directories appears Highlight the desired directory for the Delta eServer and click OK then Next gt for the next step If necessary click lt Back button to take you back through Setup dialog boxes by one Step 4 After pressing Next the following dialog bo
34. Repeat Add a new file new sheet Eee Location Example eServer_excelleServer Lyample ee M E Report File Name Data Auto Save o How long would you like to save your logging data lat pan ee o BH Day o E Hour 30 zi Minute click Finish There are two parts in this dialog box 1 Excel Sheet A Repeat 4 10 Revision October 2010 Ead ye Chapter 4 Excel Sampling Setting When the sampling data has been filled in the selection range to the full the system will write the data into the selection range from the first column or row repeatedly G10 INE NEN a WE 8 1 B Adda new file When the sampling data has been filled in the selection range to the full the system will open a new Excel file automatically and write the data into the new Excel file C Adda new sheet When the sampling data has been filled in the selection range to the full the system will open a new Excel sheet automatically and write the data into the new Excel sheet sheet Repeat Q Add a new file Add a new sheet 2 Output Setting Output Location ad Report File Data HM Auto Save How long would you like to save your
35. X 10 19 2009 18 25 08 10 19 2009 18 25 09 10 19 2009 18 25 10 10 19 2009 18 25 12 4 10 19 2009 18 25 13 4 X 10 19 2009 18 25 14 4 10 19 2009 18 25 15 v 8 28 Revision October 2010 Chapter 9 Writing Data Oracle Before creating testing example make sure to change the upload and download option Options gt Configuration on Screen Editor first The default setting of upload and download is via USB If the users need to use Ethernet please change the default setting by referring to Appendix A 9 1 Example This example is used to help the users to understand how to use eServer to read the data of the register addresses 3 and 6 every second record the data in Oracle via ODBC interface and save the collected data into the specified folder C Data 9 1 1 Software Installation 1 Oracle Introduction Oracle is a free and a database management system produced and marketed by Oracle Corporation In this example To download it go to http www oracle com technetwork database express edition downloads index html Please be sure to select Oracle Database 10g for Microsoft Windows Sun Quick Links ORACLE Welcome Lee Account Helo Sign Out United States Communities lama v Iwasntto w v Secure Searc Q Products and Services Downloads Store Support Education Partners About Oracle Technology Network Technology Network Database Database
36. and Folder Tasks kal Share this Folder 4 Data Sources ODBC Shortcut Other Places 7 kE Local Security Policy Shorkcut 2 control Panel G My Documents 54 Biu Pema 9 6 Computer Management Shortcut p kE Event Viewer Shortcut ZEB 4 Performance Shortcut Date and Time keyboard Revision October 2010 In the ODBC Data Source Administrator dialog box select System DSN tab click on Add button to add system data source 1 ODBC Data Source Administrator User DSN System DSN File DSN Drivers Tracing Connection Pooling About Sustem Data Sources 11 An ODBC System data source stores information about how to connect to the indicated data provider 45 ystem data source is visible to all users on this machine including HT services Cancel Apply Help Select Oracle in XE and then click on Finish button Create New Data Source Select a driver For which pou want to set up data source Microsoft Parados Driver Microsoft Paradox Treiber db Microsoft Text Driver Ext csv Microsoft Test Treiber tet csv Microsoft Visual Driver DO Jm Im Jm Imm b ad Revision October 2010 9 7 Chapter 9 Writing Data Oracle Now complete Oracle ODBC Driver Configuration as mentioned in the below dialog Oracle ODBC Driver Configuration
37. from Delta Press OK button to go to next step Address Setup Target 172151902 Press OK button to go to next step 9 18 Revision October 2010 EZ sers Chapter 9 Writing Data in Oracle 6 ODBC Data Source Setting Create an ODBC Data Source pointing to your database Please refer to the following settings Wizard Logzing ODBC Please indicate the following items Chooses a data source DSN and input user name and password ODBC Data Source OracdesQL User Name system Password Database Driver Orcale oracletable Table oracletable L4 Stamp _ oracletable TIME tom idoy VHM To continue click Next Press Next button to go to next step 7 Register Setting Set the register address of the sampling data Ped Logringe Register Setting gt gt gt Please input logging address in the following Cell z y re iel AMIN Address Form To continue dick Next mesi Revision October 2010 9 19 8 Select the Type as Trigger Then set the format of address 0 0 to Rising edge the format of address 0 2 to Falling edge respectively Press Finish button to continue Wizard Logging Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition oracetable 3 t Rising e
38. in HMI Enter into the system menu and set IP address to 172 16 190 11 Please see the figure below V2 1 System Setting e 2159 TR 172 16190 11 X EUR qm OB 00 00 00 00 00 11 28 Revision October 2010 After completing all the settings and make sure that the communication is good use the most updated Screen Editor program editing software to open the selected dpb file which just has been modified on eServer Then create two elements One is a character input element and its address is set to 100 The other is a maintained button element and its address is set to 0 0 Please refer to the figure below 52 I Screen 1 Select RCPNO FTT PLO TO HMI TO PLC Address Then compile it and download the recipe data to HMI After recipe data is downloaded to HMI successfully return to eServer save the file first and then run the recipe data Next trigger the numeric input element on HMI and the system will save the imported file to the destination path Please see the figure below File View Tool Help Save Run Press icon The following dialog box will pop up and ask the users if it is necessary to convert the file of Tina csv Revision October 2010 11 29 Chapter Recipe Access Example Atina csv E id rer Chreramte Check the box before Translate All and press OK button the following dialog box will
39. logging data I 0 0 Hour 30 B Minute Revision October 2010 4 11 egest ver P Chapter 4 Excel Sampling Setting Location Choose file destination location Report File Name Specify the name of the report file The users can add the date and time in the end of the file name The format of the date and time is specified by a string of characters which can be user defined and changed freely Please refer to the table below for the string representation String Format Representation 96d Date Auto Save When this option is enabled the system will back up the data in a period of specified time automatically in case the data will be lost due to abnormal operation when the power source is cut off unexpectedly or other accident occurs Revision October 2010 Chapter 5 Writing Data Microsoft Excel Before creating testing example make sure to change the upload and download option Options gt Configuration on Screen Editor first The default setting of upload and download is via USB If the users need to use Ethernet please change the default setting by referring to Appendix A 5 1 Example This example is used to help the users to understand how to use eServer to read the data of the register addresses 3 and 6 every second record the data in Excel report file meanwhile calculate the average value of the register addresses 3 and 6 by using Excel formula and save the collect
40. lt Setingtem Description Field which the sampling data will be written Table which the sampling data will be written HMI Name Name of connecting HMI Register Address l 2 data format setting will be disabled When the register address is set to Word this data format setting will be enabled and the available settings include BCD Signed Unsigned Hex Floating Char Character When the register address is set to Bit this Unit of the data length of the register Unchangeable Revision October 2010 1 2 3 When the register address is set to Bit this setting will be 1 one always When the register address is set to Word if the data format is set to BCD Signed Unsigned Hex and Floating the setting value of this field could not exceed 2 two When the register address is set to Word if the data format is set to Char Character the setting value of this field could be user defined and the max setting value could be set to 100 hundred 6 5 EL semp Chapter 6 ODBC Sampling Setting If the register address is set to Bit this integer setting cannot be set Integer If the register address is set to Word except Floating and Char Character when the other format is selected this integer setting can be set If the register address is set to Bit this fraction setting cannot be set If the register address is set to Word except Floating and Char Character
41. networking settings Windows Professional Programs Documents Settings Search Help and Support Run Control Panel Network Connections Printers and Faxes Taskbar and Start Menu Power on PC and start Windows Click Start gt Programs point to Control Panel and then select Network Connections amp Control Panel File Edit 3 T x Search Folders Ez View Favorites Tools Help Address G Control Panel a Control Panel e Switch to Category View See Also A Windows Update Help and Support Revision October 2010 Scanners and Cameras User Accounts Scheduled Tasks Windows Firewall Security Center x Wireless Network Set gt Administrative Automatic BDE Date and Time Tools Updates Administrator gt a Intel Internet Controllers Graphics Options Lh amp amp Phone and Power Options Printers and Regional and Modem Faxes Language Sounds and Speech System Taskbar and Audio Devices Start Menu gt Keyboard A 5 Appendix A Upload Download via Ethernet EZ cera Double click Network Connections icon the following windows will appear Right click the Local Area Connection icon and then select Properties from the pop up menu Network Connections File Edit View Favorites Tools Advanced Help sack 2 d Search j Folders EHE Address Netwo
42. settings C3 Obtain an IP address automatically gt Use the following IP address address 172 16 190 1 Subnet mask 285 255 255 Default gateway LLLI A H MQ Dbam UNS server autermalicalli 5 Use the following DMS server addresses Prefered ONS server Alternate DNS server Then press OK button to finish the settings Setting IP Address in HMI Enter into the system menu and set IP address to 172 16 190 11 Please see the figure below V2 1 System Setting e C C oes s 172 16190 11 cB dq dE OB 00 00 00 00 00 After completing all the settings and make sure that the communication is good use the most updated Screen Editor program editing software to open the selected dpb file which just has been modified on eServer Create a maintained button element and set its address to 0 0 11 20 Revision October 2010 EZ Sera Chapter 11 Recipe Access Example 1 1 Screen 1 SelectRCPNO TO PLC FLC Address Then compile it and download the recipe data to HMI After recipe data is downloaded to HMI successfully return to eServer save the file first and then run the recipe data Next trigger the numeric input element on HMI and the system will save the imported file to the destination path Please see the figure below Fie Too
43. vertical and the selection range includes column A the first column b When the sampling direction is horizontal and the selection range includes row 1 the first row c When the sampling direction is anywhere 4 6 Revision October 2010 Ead ye Chapter 4 Excel Sampling Setting The format of the date and time is specified by a string of characters which can be user defined and changed freely Please refer to the table below for the string representation String Format Representation 41 4 Register Setting This step is used to set the register address of the sampling data Wizard Lorem Register Setting x Please input logging address in the following Cell s aje ejej 9876543210 1 5 T To continue dick Next setting tem Description Remark index which the sampling data will be Unchangeable Excel Cell which the sampling data will be written Unchangeable HMI Name Name of connecting HMI Revision October 2010 4 7 Chapter 4 Excel Sampling Setting 1 When the register address is set to Bit this data format setting will be disabled 2 When the register address is set to Word this Format data format setting will be enabled and the available settings include BCD Signed Unsigned Hex Floating Char Character Unit of the data length of the register Unchangeable When the register address is set to Bit this setting will be 1 on
44. 0 Chapter 11 Recipe Access Example Before creating testing example make sure to change the upload and download option Options gt Configuration on Screen Editor first The default setting of upload and download is via USB If the users need to use Ethernet please change the default setting by referring to Appendix A 11 1 Creating Example Update Firmware Remember to update the firmware before using eServer To select this function click Start gt Programs gt Delta Industrial Automation gt HMI gt DOP eServer 1 00 0x gt Update Firmware Tool After clicking Update Firmware Tool the following dialog box will appear for the users to select the communication interface the default setting is USB driver Press Update button to update HMI firmware automatically Update Firmware Tool v1 2 USE Driver Model Version Ba Reinstall AES O 1 088 1 088 AESOCTS 1 088 940 1 08B t AE10C46 4 08B CO USB eEthemet 108B 200 1 08B 10 615 2 0203 About Update Mode Selection Start eServer To start eServer click Start gt Programs gt Delta Industrial Automation gt HMI gt DOP eServer 1 00 0x gt eServer 2007 Copyright All rights reserved Delta Electronics Inc Revision October 2010 11 1 Chapter 11 Recipe Access Example ELA cera 11 1 1 New Project Start eServer and cli
45. 22020 Connect using E Intell PRO 1000 Network Can Configure This connection uses the following Items Client For Microsoft Networks File and Printer Sharing for Microsoft Networks aas Packet Scheduler nenet Protocol TEFAF Install Jerstal Properties Description Transmission Control Pratacol Intermet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon notification area when connected Notify me when this connection has limited connectivity The Internet Protocol TCP IP Properties dialog box will open Choose Use the following IP address and enter the IP address numbers of the PC into the field of IP address and Subnet mask Revision October 2010 11 27 Internet Protocol TCP IP Properties General fou can get IF settings assigned automatically if pour network supports this capability Othenvise pou need to ask your network administrator for the appropriate settings C3 Obtain an IP address automatically gt Use the following address IP address TE 480 Subnet mask 255 255 2556 fj Default gateway Iram D NS server addiezz auteraticall 2 Use the following DNS server addresses Prefered ONS server Alternate DNS server Then press button to finish the settings Setting IP Address
46. Configuration Standard Communication Print Default Others Recovery the IP address DHCP HWI Hare eRemnte Address 132 16 190 2 Subnet Mask 255 1255 255 Default Gateway D 0 du B 8 20 Revision October 2010 EZ a Ser Ver Next click Options gt Network Setting Chapter 8 Writing Data in MySQL Configuration t Alarm Setup EP x U wb imr m lw History Setup 1 7 AA 2 E 5 Wm BH i Passowrd Table Setting Oe 4e x ES ES 4 7 B Property rer 1 Screen 1 Tag Table EM Ef Print Typesetting Screen Sereen 1 Ae Picture Bank Screen 1 Text Bank Screen Properties Detail 255 255 2 Submacro Background Color Initial Macro Screen Open Macro 0 Background Macro Screen Close Macro 0 Clock Macro Screen Cycle Macro 2 Screen Width 640 Environment Screen Height 450 E E List Preview Output HX Step Action 1 Create element gt J Delete element 2 Create element 4 Create element Y lt m Gh Ga S FF Change Window Position 2 HJ a E Record Output 366 14 179 40 W 220 H 83 Download USB DOP AELOTHTD1 65536 Colors NUM The following Remote Setting dialog box
47. Express Edition Database 119 Overview Downloads Documentation Community Learn More Popular Downloads Database Focus Areas Berkeley DB Enterprise Manager Database Options Oracle Database 10g Express Edition Downloads Database Express Edition Database EE and Oracle Database 10g Express Edition Database Upgrade E Enterprise Pack for Eclipse T 9 Oracle Database 10g Express Edition for Linux x85 Berkeley DB od Lot oe Fusion Middleware TimesTen in Memory Database Java amp GlassFish Database 109 Java SE Database Lite JDeveloper and ADF RDB MySQL Audit Vault NetBeans IDE Secure Backup Solaris Real Application Clusters SOL Developer VARIED VM VirtualBox Multimedia More Database Downloads Windows Revision October 2010 9 1 9 2 Technology Network Database 119 Database Focus Areas Database Options Database Express Edition Database Upgrade Berkeley DB TimesTen Database Database 10g Database Lite RDB Audit Vault Secure Backup Real Application Clusters Clusterware Then accept the license agreement and download OracleXEUniv exe which is the multi byte Unicode database for all language deployment Database Database Express Edition Overview Downloads Documentation Community Learn Popular Downloads Berkeley DB Oracle Databas
48. Files of type Cancel Revision October 2010 Chapter 11 Recipe Access Example Ead After selecting the recipe file and setting the IP address press OK button to go to next step Transfer Path Please select the following 2 methods to 1 2 Select exist Screen DOF file from stroed media nents and SettinassTINA G LEESHM practice HMl recipe dpb E IPAddess 172 16 190 11 12348 2 Tansfer from Delta HMI Cancel 11 1 3 Setting and Condition Import When the node is set correctly click Setting and complete the settings next There are two modes Import and Export available for selection Each mode provides two options Fixed or Variance from the drop down list for use Import Fixed Setting a Select Fixed b Check the check box to use 16 bit recipe as the example c User define the HMI Name and File Name file name of the imported file d Set Destination Path destination location where the imported file is located Rep Import a Y 32 bits impor 1 Condition As for the method of sampling condition select Const execute sampling repeatedly in a certain span of time a Select Const b Set Polling Cycle sampling cycle to 5s default setting value 11 4 Revision October 2010 Ead a SOK Vet Ch
49. Lxample GJ Report File Name Data Auto Save How long would you like to save your logging data o 2 tour Minute dick Finish 11 Press gt icon and enter the password Then the system will start sampling operation i e writing data in Excel file di passwords are the same password under No 1 Revision October 2010 5 11 Chapter 5 Writing Data Microsoft Excel 17 18 20 CRASS 171802 CREA OG 1741623 DS 24 2000 17 1824 ORI 17 18175 17 18 26 197 1827 D 24 2009 171828 Cas 2009 17129 DATATE 7 35 30 8 e002 17 18 31 19 TIRS 65527 gl 2 Q8 242009 1 7 16 33 1 1 12 If the users want to pause or stop the sampling operation only right click eServer wv icon at the bottom right of Windows screen and select Pause or Stop option from the pop up menu the sampling operation will pause and stop immediately The users also can use Excel Visible option to decide whether the Excel window displays on the screen or not Excel Visible pet Language Exit Revision October 2010 Chapter 6 ODBC Sampling Setting 6 1 Detailed Settings Please refer to the following steps to complete ODBC sampling setting i e how to log data from HMI to a database 6 1 1 Linkage Start eServer and click File gt
50. Options Printers and Regional and Connections ed Faxes Language 9 s d Scanners and Scheduled Security Sounds and Speech System Taskbar and Cameras Tasks Center Audio Devices Start Menu ED m User Accounts Windows Wireless Firewall Network Set Revision October 2010 11 11 Chapter 11 Recipe Access Example EL cera Double click Network Connections icon the following windows will appear Right click the Local Area Connection icon and then select Properties from the pop up menu Network Connections File Edit View Favorites Tools Advanced Help sack 2 d Search j Folders EHE Address Network Connections LAN or High Speed Internet Network Tasks 5 Creat Area Connection reate Connected connection ww Disable Change Windows Status Firewall settings Repair WM Disable this network device Bridge Connections 4 5 Repair this connection Creare Rename this connection Delete MD view status of this Rename connection Change settings of this Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Local Area Connection Properties General Authentication Advanced TTT Connect using E Intel R PROA1000 MT Network Con This connect
51. Rename this connection Delete Lu View status of this Rename connection Change settings of this Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Local Area Connection Properties General Authentication Advanced Connect using E Intell PROA 000 MT Network Con This connection uses the following tems Client For Microsoft Networks File and Printer Sharing for Microsoft Networks 105 Packet Scheduler tenet Protocol TEFAF Description Transmission Control Pratacal Intermet Protocal The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected me when this connection has limited no connectivity Revision October 2010 11 7 Chapter 11 Recipe Access Example EZ erar The Internet Protocol TCP IP Properties dialog box will open Choose Use the following IP address and enter the IP address numbers of the PC into the field of IP address and Subnet mask Internet Protocol TCP IP Properties General Y au can get IP settings assigned automatically if your network supports this capability uou need to ask your network administrator for the appropriate IP settings C3 Obtain an IP address automatical
52. SCRL 7 4 Check the check box before Enable Stamp Time and Date function and change the format to 6m 96d 96y H M S Once the sampling operation is enabled the sampling date and time will be recorded into the cells of B3 B20 Stamp Time and Date Tpye YM 8 Set the register addresses Wizard Lozzing Register Setting x Please input logging address in the following Cellie 4 To continue cick Next Revision October 2010 5 9 DOP uh Use the following dialog box to set the sampling register addresses Type FEC Derice Cond Cece Ait gt Internal Derry Word CO Internal Memory Bit PLC Station Number Defanli Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition Sheeti How long would you like on your logging data 500ms one day 0 2 Minute 2 Gecond 0 d ms To continue click Mext 10 Choose Add a new file in Excel Sheet and define the file location and file name shown as the figure below After enabling the function of Auto Save press Finish button to complete the settings 5 10 Revision October 2010 a ET oa 5 Writing Data in Microsoft Excel Wizard Logring Output Setting CO Add a new file C2 Add a new sheet Output 1 Location Example eServer_excel eServer
53. Server will try to reconnect during the configured time period Option El Lacal Host Synchronize Communication aont When the connection to EtherMet is disconnect the eServer will try reconnet during the configured time period Setretry time when disconnect E ODBC ODBC3 all settings are the same value under No 1 a For example see the above figure if the time is set to 15 seconds when the connection to Ethernet is disconnected the eServer will try to resume the communication for 15 seconds Revision October 2010 3 9 Chapter 3 Before Using eServer 3 4 3 Local Host When the type on Condition page is selected as Trigger it is necessary to set the PC Ethernet port number that you have connected The default setting is 12348 eServer Option Ef Local Host Synchronize i Crew Kc When the type on Condition page is selected as Trigger itis necessary to set Disconnect the PC ethernet port number that you have connected Cancel 3 10 Revision October 2010 Ead c SOK Ver Chapter 3 Before Using eServer 3 5 Make Runtime Shortcut Start eServer and click Tool gt Make Runtime Shortcut to create a eServer shortcut and E Tool activate eServer quickly There are two methods provided for ma
54. TA References Table Revision October 2010 9 11 Chapter 9 Writing Data Oracle Click on Finish button to complete the settings Columns Constramts Primary Key Constraint Name Type Column S Check Foreign key Availiable Columns Example Check Constraints Click on Create button to create a new table Columns Create Table Primary oe Please confirm your request Schema SYSTEM Table name ORACLETABLE 2 SQL Add When the following figure shows on the screen it indicates that a new table on Oracle database is created successfully Tables v Table Data Indexes Model Constraints Grants AQS INTERNET AGENTE AQS INTERNET AGENT PRIVS X S z Add Column Modify Column Rename Column Hullable UT XE E Column Name Data Type AQS QUEUES ELT e he EE TIME CHAR 100 Ver AQS QUEUE TABLES a ad Ec E DATA TE s AQS SCHEDULES DATA1 100 res DATAZ CHAR 100 Yes DEFS AGERROR DEFS CALLDEST DEFS DEFAULTDEST DEFS DESTINATION DEFS ERROR DEFS LOB DEFS ORIGIN DEF amp PROPAGATOR DEFS PUSHED TRANSACTIONS DEFS TEMPSLOB HELP DROS PARA Inr Statistics Ul Defaults Triggers Dependencies Drop Column Default Primary Key ORACLETABLE SQL Re
55. TDEST DEFS DESTINATION DEFS ERROR DEFS LOB DEFS ORIGIN DEFS PROPAGATOR its DEFS PUSHED TRANSACTIONS DEFS TEMPSLOB HELP Ane AAA A aA There are two recorded data shown on the screen When Rising Edge button 0 0 on HMI screen is pressed the writing operation will be triggered and the system will write the first data into the database When Falling Edge button 0 2 on HMI screen is pressed the writing operation will be triggered and the system will write the second data into the database ee im AQS QUEUE TABLES Fe 09 13 2010 120629 14311 42933 AQS SCHEDULES DEFS AQCALL ER 09 13 2010 12 06 35 14375 43125 DEFS_AQERROR DEFS CALLDEST DEFS DEFAULTDEST DEFS DESTINATION DEFS ERROR DEFS LOB DEFS ORIGIN DEFS PROPAGATOR DEFS PUSHED TRANSACTIONS DEFS TEMPSLOB HELP LOGMNRC DBNAME UID MAP 1 5 9 22 Revision October 2010 Chapter 10 Recipe Access Setting 10 1 Detailed Settings Please refer to the following steps to complete Excel sampling setting i e how to log data from HMI to Excel 10 1 1 New Project Start eServer and click File gt New or click New icon eServer File View Wizad Tool Help ds eg eServer After the New dialog box is opened select Recipe Access icon press OK button Logging ODBC EE New ProjectName Recipe Documents an
56. Ta find the port number and protocol consult the documentation For the program service want use L Port number 2305 5 C3 UDP What are the risks of apening Change scope Cancel Revision October 2010 In the Add a Port dialog box type MySQL in the Name text field and type the port number of the instance of the Database Engine such as 3306 for the default instance in the Port number text field Ensure that TCP is selected and click OK to complete the settings 4 Connector ODBC Installation Connector ODBC is a standardized database driver which can be downloaded from MySQL website at http dev mysgl com downloads connector odbc 5 1 html ix MySQL Connector ODBC 5 1 Setup Wizard Welcome to the Setup Wizard for Connector ODBC 5 1 The Setup Wizard will install MySQL Connector ODBC 5 1 release 5 1 6 your computer To continue click WARNING This program is protected by copyright law 5 ODBC Setup In the Control Panel double click Administrative Tools E Control Panel File Edit View Favorites Tools Help 2 7 p Search T Folders Address QF Control Panel v E X n i 1 2 Control Panel t T Accessibility Odd Hardware Add or Automatic BDE Date and Time gt Switch to Category view Options Remove i Updates Administrator gt See Also E L 7 Disp
57. U S A TEL 1919 76 7 39 197 FAX 1 919 767 3969 Delta Products Corporation Brazil Sao Paulo Office Rua Itapeva N 26 3 andar Bela vista ZIP 01332 000 S o Paulo SP Brasil TEL 55 11 3568 3875 55 11 3568 3865 Europe Deltronics The Netherlands B V Eindhoven Office De Witbogt 15 5652 AG Eindhoven The Netherlands TEL 31 40 2592850 FAX 31 40 2592851 We reserve the right to change the information in this catalogue without prior notice eServer M EN 20101023 DELTA ELECTRONICS INC eServer User Manual 5 js A Ver 2 00 02 0 Firmware ver 1 000 Build Tue Jun 5 11 20 58 2007 2007 Copyright All rights reserved Delta Electronics Inc Publication History Please include the Name of Manual and the Issue Version both shown as below when communicating with us regarding this publication Name of Manual eServer_M_EN_20101023 Issue Version eServer 001 Date 2010 10 23 Date Issue Version Description of Changes Revision October 2010 Table of Contents Chapter 1 Introduction 1 1 eServer Data Collection Software 1 1 I2 Supported MOGIS ui Pc neta 1 2 1 9 System usse uva Destra d dva Rica dc ente 1 2 Chapter 2 Software Installation 2 CSEE SOUR
58. Writing Data in Oracle Oracle Database 10g Express Edition Install Wizard Welcome to the InstallShield Wizard for Oracle Database 10g Express Edition The Installs hieldH Wizard wall install Oracle Database 104 Express Edition on pour computer To continue click Next ORACLE DATABASE EXPRESS EDITION Click on Next button to go to the next step Oracle Database 10g Express Edition Install Wizard License Agreement Please read the following license agreement carefully BEN ORACLE DATABASE EXPRESS EDITION LICENSE AGREEMENT To use this license you must agree to all of the following terms by either clicking the accept button or installing and using the program donot accept the terms in the license agreement lt Back Cancel The users must read license agreement before installation Choose accept the terms in the license agreement to continue Click on Next button to go to the next step Revision October 2010 9 3 Chapter 9 Writing Data Oracle at ema Oracle Database 10g Express Edition Install Wizard Choose Destination Location Select folder where setup wall install Files Setup will install Oracle Database 10a Express Edition in the following folder To install ta this folder click Hest Ta install to a different folder click Browse and select another folder fy Oracle Database 10g Express
59. ally and allow the users to design the desired Excel template sheet 2 Select an existing Excel file from stored media When this option is selected the system will allow the users to open an existing Excel file Wizard Logging Excel Template Designed Template Designed will provide a method to help you easy build sheet in Excel Please select the following options decide how to design a template C3 Select a exist Excel file from stroed media p M 3 continue click Next Press Next button to go to next step Revision October 2010 4 3 Chapter 4 Excel Sampling Setting 4 4 4 1 3 Excel Logging Range Setting This step is used to specify the logging range to which the sampling data will be written There are three parts in this dialog box Wizard Excel Logging Range Please select range that you want to logging Multi Vertical CO Multi Horizontal Single Vertical Ssingle Horizontal Anywhere You could be clicked the right button to execute Excel and then decided the range Selection Range Al Stamp Time and Date Tpye Serif Adj To continue cick Next 1 Sampling Direction Check Need to log data box to determine the sampling direction and select the data range that you want to log If Need to log data box is not checked the sampling direction will be disabled and the data range cannot be selected There are five different samplin
60. and the system will open the editing Excel template sheet immediately You could be clicked the right button to execute Excel then decided the range Selection Range Revision October 2010 4 5 Chapter 4 Excel Sampling Setting EZ cera In Excel template sheet use the mouse to decide the selection range After the desired range is selected press Close button to finish Microsoft Excel Tem461 EI C3 te SS 1 3 E F H __ 1 2 LIE An E L EM Tf CNN S cs D enr T 1 gt 14 ae 1 E 21 22 23 24 27 29 30 31 32 33 Please decide the selection range and then click the close button ES Selection D20 Close gt Sheet lt Ready NUM SCRL 3 Stamp Time and Date When this option is selected the sampling time and date will be written as well automatically when the sampling data is recorded The written position will be different depending on the setting sampling direction Generally the written position will be at the previous column or row before the selection range However if the following three conditions occur the function of Stamp Time and Date will be disabled a When the sampling direction is
61. apter Recipe Access Example Detect Scan Time How long would you like on your logging data 50015 one day 8 2 0 A Minute 5 Second 0 ms Cancel After completing all the settings on eServer use the most updated Screen Editor program editing software to open the selected dpb file which just has been modified on eServer Then compile it and download the recipe data to HMI The screen data will be shown as the figure below Delta Soft Simulator V2 21 Kernel Yer R 2 74 Select RCPNO Recipe Address 1 PLC TO HMI PLC Address After downloading the recipe data please make sure that the IP address numbers of subnet masks of the PC 1 72 16 190 1 and HMI 1 72 16 190 11 are the same otherwise HMI may not be displayed in the list when finding node Networking Settings Ensure to observe the following instructions to complete PC networking settings before eServer operation Revision October 2010 11 5 Chapter 11 Recipe Access Example E Setting PC Network Programs Documents Control Panel ieFings e Network Connections Search be Printers and Faxes Help and Support Taskbar and Start Menu Run Shut Down Windows Professional Power on PC and start Windows Click Start gt Programs point to Control Panel and then e Network select Network Connections 2nnection
62. arting Setup This will make it possible to update relevant system Files without having to reboot your computer Click to continue Click on Next button to go to the next step 8 2 Revision October 2010 c Serva Chapter 8 Writing Data in MySQL n AppServ 2 3 10 Setup License Agreement Please review the license terms before installing 4pp5ery 2 5 10 Press Page Down to see the rest of the agreement LESSER GENERAL PLIELIC LICENSE version 2 1 February 1999 Copyright 1211981 1999 Free Software Foundation Inc 59 Temple Place Suite 330 Boston 02111 1307 USA Everyone is permitted to copy and distribute verbatim copies of this license document but changing it is not allowed This is Ehe First released version of the Lesser GPL It also counts as the successor of the GNU Library Public License version 2 hence the version number 2 1 IF vou accept the terms of the agreement click I amp gree to continue You must accept the agreement to install AppServ 2 5 10 lt Back I Agree Cancel The users must read license agreement before installation Click on Agree button to continue amp AppServ 2 5 10 Setup Choose Install Location Choose the Folder in which to install AppServ 2 5 10 Setup will install 2 5 10 in the Following folder install in different folder click Browse and select another Folder Click Wext to continue Desti
63. ata source Microsoft Paradox Driver db Micrasaft Paradas T reiber Micragaft Text Driver Ist Microsott Test Treiber Micragaft Visual FoxPro Driver ODBC 5 1 Driver tte eee 54 ly Musae Connector ODBC Connection Parameters Data Source eServer Description Server localhost Pork 3306 User rook Password Database Details gt gt SE Help Connection Parameters Data Source Name Enter ODBC data source name eServer or enter the name of the data source you want to access Description Enter some text to identify the connection Revision October 2010 8 17 Oo o ae Chapter 8 Writing Data in MySQL TV Server Enter the default localhost or the name of MySQL server host that the users want to access User Enter user name root to use for this connection Password Enter the corresponding password for this connection Database The list of databases that the user has permissions to access will be shown automatically Click on Test button to verify the connection If the test succeeds the figure shown below will appear on the screen to indicate that MySQL connection is now available to use At this time click on OK button to complete the settings If the test does not succeed please review the settings Test Eesult Ed Connection successful Revision October 2010 8
64. aved in the destination path or not Please refer to the figure such as On the other hand if incorrect or invalid password is entered the following error message dialog box will appear to alert the users s qus hae m Password ESEIYEI ant connect ta HMI a all passwords are the same pazsvvord under Revision October 2010 11 9 Chapter Recipe Access Example Import Variance Setting a Select Variance b Check the check box to use 16 bit recipe as the example Set the File Name file name of the imported file to be the same as the register address of HMI In this case 100 character input element is used d Set File Name Length number of the imported characters In this case the File Name Length is set to 4 This is because the name of the imported file is Tina csv The system will refer to Tina these four characters and convert the imported file to Tina rcp and then save it to the destination path e Set Destination Path destination location where the imported file is located 1 0 a EMI Nee 1 7 Se Condition As for the method of sampling condition select Const execute sampling repeatedly in a certain span of time a Select Const b Set Polling Cycle sampling cycle to 5s default setting value Detect Scan Time How long would you like on your logging data S00ms
65. ck File New or click New icon File View Wizard Tool Help ET 2 Jj eServer IITIEEEM After the New dialog box is opened select Recipe Access icon and enter the file name Recipe for the Recipe Access database Then press OK button eet ODBC 11 2 Revision October 2010 11 1 2 Node Click 4 icon to link HMI screen project file There are two methods available for selection Here choose Select an existing Screen DOP file from stored media option to create a new node Select an existing Screen DOP file from stored media Open an existing screen project file HMI recipe dpb and set the IP address of the connecting HMI The IP address is set to 172 16 190 11 Please select the following 2 methods to link 1 Select a exist Screen DOF file from stroed media 172 16 190 11 12348 2 Tansfer from Delta HMI Press OK button to go to next step Look in Desktop E Documents Computer Samy Network Places 4 DOP eRemaote 1 0 082805 DOP eServer 1 0 FEB 23 2010 Beta exe 71 scrEdit 2 00 16 Build 17 201 exe S RCP eds page for 2 05 00 change page dpb J DOP Soft dpb deserves example dpb ES dap 9 Documents 016 File name My Network
66. crosoft Office Microsoft Office Access Microsoft Office Microsoft OfFice Tools Snaglt 7 Microsoft Office Access 2003 Microsoft Office Excel 2003 Microsoft Office InfoPath 2003 Microsoft Office Outlook 2003 Microsoft Office PowerPoink 2003 Microsoft Office Publisher 2003 Microsoft Office Word 2003 Startup Internet Explorer windows Media Player Delta Industrial Automation E Es Dis v 4 Revision October 2010 Then click New icon choose Project using new data to open new database file and set the directory to C Data Microsoft Access i i x Wd Adah Re Tools Window Adobe PD a question for help mL T New 2 Blank database l Blank data access page 2 Project using existing data File New Database p From existing Templates Search online For Templates on Office Online On my computer ENT Save as type Microsoft Office Access Project adp v Press Create button to enable Microsoft 501 Server Database Wizard Microsoft SOL Server Database Wizard What SQL Server would you like to use For this database ee DELTA SOL Select or the name PP of the donnecting 501 Please specify the lagin ID and password of an account Server with CREATE DATABASE privileges on this server
67. ctivate Screen Editor and select Options Configuration to access the configuration options and change the upload and download setting Nisus Window Help L ontieuratian Alarm Setup History Buffer Setup Password setting Table Prnt Typesetting Sound Network setting Recipe bits recipe Picture Bank Text Bank aubmacra Initial Backzround Clock Erevaronment Revision October 2010 1 Appendix Upload Download via Ethernet EZ cera In Configuration dialog box change the default setting of upload and download to Ethernet Then press OK to complete the setting Configuration General Control Block COM port Standard Upload D ownload en Setup Project Name USE gt Ethernet Default Other HM p e a PE COM Port jM HMI ser SES 355955 Goles Startup Delay Time 0 Mon valatile data location Setting Eje 00 The size of writing USE cache Default Clock Macro Priority Low Background macro update cycle 1 Lines 3 Security Password 1 2345670 Alarm History Recipe Show disk access eror message Starting Level Insufficient password level reminder Check password when download proc Buzzer Audio A 2 Revision October 2010 Ea eee vet Appendix A Upload Down
68. d Screen amp Recipe A 8 Revision October 2010 Table of Contents About this Manual User Information Be sure to store this manual in a safe place EZA Ser War Due to constantly growing product range technical improvement and alteration or changed texts figures and diagrams we reserve the right of this manual contained information change without prior notice Coping or reproducing any part of this manual without written consent of Delta Electronics Inc is prohibited Technical Support and Service Welcome to contact us or visit our web site http www delta com tw industrialautomation if you need any technical support service and information or if you have any question in using the product We are looking forward to serve you needs and willing to offer our best Support and service to you Reach us by the following ways ASIA DELTA ELECTRONICS INC TAOYUAN Plant 31 1 SHIEN PAN ROAD KUEI SAN INDUSTRIAL ZONE TAOYUAN 333 TAIWAN TEL 886 3 362 6301 FAX 886 3 362 7267 NORTH SOUTH AMERICA DELTA PRODUCTS CORPORATION Sales Office P O BOX 12173 5101 DAVIS DRIVE RESEARCH TRIANGLE PARK NC 27709 U S A TEL 1 919 767 3813 FAX 1 919 767 3969 JAPAN DELTA ELECTRONICS JAPAN INC Sales Office DELTA SHIBADAIMON BLDG 2 1 14 SHIBADAIMON MINATO KU TOKYO 105 0012 JAPAN TEL 81 3 5733 1111 FAX 81 3 5733 1211 EUROPE DELTRONICS
69. d Se ttings Tina Q LeeDesktopR Revision October 2010 10 1 Chapter 10 Recipe Access Setting Click ki icon to link HMI screen project file There are two methods available for selection 1 Select an existing Screen DOP file from stored media Open an existing screen project file and set the IP address of the connecting HMI Transfer Path Please select the following 2 methods to link 1 Select exist Screen DOF file fram stroed media CAD ocuments and Settingsshirley y Documents Deno Ibe IP Address 172 a 130 d E 2 Tansfer from Delta HMI 2 Transfer from Delta HMI Transfer the HMI screen project file via network communication directly Transfer Path Please select the following 2 methods to link 1 CO Select exist Screen DOF file fram stroed media 2 Tansfer from Delta HMI 172 15 130 4 Cancel Press OK button to go to next step 10 2 Revision October 2010 10 1 2 Register Setting This step is used to set the register addresses of the database There are two modes Import and Export available for selection After selecting the desired mode choose Fixed or Variance from the drop down list and complete the settings Import Fixed B NE Import Mode Fined Ne Usage Name T HMI Name 2 _ Destination Path DHECNSO ION _ EAT
70. dre To continue dick Next 9 Press gt icon After the password is entered the system will start sampling operation i e writing data in MySQL Server Gd eServer a ODBC ap 9 20 Revision October 2010 Ead Chapter 9 Writing Data in Oracle ODEBCI passwords are the same password under 1 10 If the users want to pause or stop the sampling operation only right click eServer WV icon at the bottom right of Windows screen and select Pause or Stop option from the pop up menu the sampling operation will pause and stop immediately rg Excel Visible Language Exit Revision October 2010 9 2 E esser ye Chapter 9 Writing Data in Oracle 11 Open the browser and go back to the Oracle database Click on Data link Tables ORACLETABLE 2 Table Indexes Model Constraints Grants Statistics Ul Defaults Triggers Dependencies 501 AQS INTERNET AGENTE e Add Column Modity Column Rename Column Drop Column Rename Copy Drop Truncate Create Lookup Table AQS INTE RNET AGENT PRIVS I 5 Column Mame Data Type Hullable Default Primary Key AQS QUEUES CHAR 100 Yes AQS QUEUE TABLES AOS SCHEDULES DATA CHAR 100 reg Z z Der anca DATAZ CHAR 100 Yes AQERROR CALLDEST DEFS DEFAUL
71. e always When the register address is set to Word if the data format is set to BCD Signed Unsigned Hex and Floating the setting value of this field Read Count could not exceed 2 two When the register address is set to Word if the data format is set to Char Character the setting value of this field could be user defined and the max setting value could be set to 100 hundred If the register address is set to Bit this integer setting cannot be set Integer If the register address is set to Word except Floating and Char Character when the other format is selected this integer setting can be set If the register address is set to Bit this fraction setting cannot be set If the register address is set to Word except Floating and Char Character when the other format is selected this fraction setting can be set Controller Connecting controller Unchangeable Fraction 4 8 Revision October 2010 aSser oa Chapter 4 Excel Sampling Setting 4 1 5 Sampling Conditions This step is used to set the sampling conditions There are two kinds of options for selection 1 Const execute sampling repeatedly in a certain span of time This option is used to determine how long the sampling process is repeated The time unit can be defined as ms second minute or hour Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition Sheeti
72. e 10g Release 2 10 2 0 1 Enterprise Manager Express Edition for Microsoft Windows Database EE and XE You must acceptthe OTN License Agreement for Oracle Database Express Edition to download this Enterprise Pack for Eclipse piwa Fusion Middleware 9 Accept License Agreement Decline License Agreement 2 Java amp GlassFish Oracle Database 10g Express Edition Western European Java SE OracleXE exe 165 332 312 bytes s J Single byte LATIN1 database for Western European language storage with the Database JDeveloper and ADF Homepage user interface in English only WsaoL Oracle Database 10g Express Edition Universal NetBeans IDE OracleXEUniv exe 216 933 372 bytes amp Solaris Multi byte Unicode database for all language deployment with the Database Homepage user interface available in the following languages Brazilian Portuguese Chinese Simplified and 501 Developer Traditional Enalish French German Italian Japanese Korean and Spanish gt VM VirtualBox After downloading OracleXEUniv exe click on Run button to install Oracle InstallShield Wizard Preparing to Install Oracle Database 10g Express Edition Setup is preparing the InstallShield Wizard which will quide through the program setup process Please wait Extracting Oracle Database 10g Express Edition msi Revision October 2010 DUDEN TEMPE Ed eee yel Chapter 9
73. e HTTP Server MySQL PHP and phpMyAdmin To download it go to http www appservnetwork com Package of AppServ e Apache HTTP Server It is a free and open source HTTP Server e MySQL It is a relational database management system e PHP It is a free and general purpose scripting language designed for web development e phpMyAdmin It is web based open source tool written in PHP for MySQL database management After double clicking the appserv win32 2 5 10 exe file downloaded from the website exe file the following dialog box will appear AppServ Open Project http www appservnetwork Revision October 2010 8 1 Chapter 8 Writing Data MySQL Open File Security Warning The publisher could not be verified Are you sure you want to run this software Mame appserw win32 2 5 10 exe Publisher Unknown Publisher Tope Application From Or Documents and Settings shirley Always ask before opening this File This file does have valid digital signature that verties ib publisher au should only run software from publishers you trust How decide what software to run Click on Run button to install AppServ n AppServ 2 5 10 Setup Welcome to the AppServ 2 5 10 oetup Wizard This wizard will quide vau through the installation of AppServ 2 5 is recommended that vau close all other applications before st
74. e username and password Username system Password eeeessse Click here to learn how to get started Enter username and password for the database and press Login button to enter into the database homepage Then select Object Browser OCRACLE Database Express Edition User SY STEM Home Object Browser Utilities Administration Revision October 2010 9 9 Chapter 9 Writing Data Oracle Press Create button ORACLE Database Express Edition SYSTEM Home gt Object Browser AQS_INTERNET_AGENTS AQS INTERNET AGENT PRIVS AQS QUEUES AQS QUEUE TABLES AQS SCHEDULES DEFS AQCALL DEFS AQERROR DEFS CALLDEST DEFS DEFAULTDEST DEFS DESTINATION DEFS ERROR DEFS LOB DEFS ORIGIN DEFS PROPAGATOR DEFS PUSHED TRANSACTIONS DEFS TEMPSLOB Click on Table link ORACLE Database Express Edition User SYSTEM Home gt Object Browser 9 Home Logout psd AQS INTERNET AGENTS AQS INTERNET AGENT PRIVS AQS QUEUES AQS QUEUE TABLES EH Table AQS SCHEDULES DEFS AQCALL EN View DEFS AQERROR 244 Index n Sequence DEFS ERROR 9 DEFS LOB DEFS ORIGIN DEFS PROPAGATOR DEFS PUSHED TRANSACTIONS 5 TEMPSLOB ala 9 10 Select the type of database object you wish to create E Package be Database Link Procedure ESH Matenalized View f x Function A Synonym Trigger Aoolicati
75. eck box to use 16 bit recipe as the example c Set the File Name file name of the imported file to be the same as the register address of HMI In this case 110 character input element is used d Set File Name Length number of the imported characters In this case the File Name Length is set to 4 This is because the name of the exported file is Tina csv This file will be open in Screen Editor and save the value into csv file e Set Source Path destination location where the exported file is located Tina csv file is saved T iti Enable Recipe Save In Windows XP Professional E 2010 03 12 1020 gt 42 Documents and Settings My Recent Program Files Documents Cy wINDOWS E E AddressBook txt eServer ini B RCP edx test edx Computer File name Save as hype All Filesl 11 24 Revision October 2010 E cer yai Rep Export Chapter 11 Recipe Access Example 2 E Export32 1 32 bits None 1 Condition As for the method of sampling condition select Trigger Execute sampling when the trigger conditions are satisfied a Select Trigger b Set Address to the register address of the trigger element In this case the trigger element is a maintained button element and its address is set to 0 0 c Select Format There are two options for selection Rising
76. eck the check box before Enable eServer Remote and set a password for network communication After OK button is pressed HMI networking is completed Compile the edited project file at the end of the programming and the edited project file could be transferred to HMI Romote 5etting Enable eServer Remote Password 12345678 Screen sample time in 100 Revision October 2010 3 5 Chapter 3 Before Using eServer 3 3 Start eServer To start eServer click Start gt Programs gt Delta Industrial Automation gt HMI gt DOP eServer 1 00 0x gt eServer 2007 Copyright All rights reserved Delta Electronics Inc 3 6 Revision October 2010 3 4 eServer Options Start eServer and click Tool gt Options to synchronize Time and Date settings and perform Disconnect function When the type on Condition page is selected as Trigger it is necessary to set the PC Ethernet port number that you have connected The default setting is 12348 Ug eServer 3 4 1 Synchronize Function Click Tool gt Options to enter eServer Option dialog box After the box before Synchronize Time and Date is checked the Synchronize function is enabled and the users can choose the source of synchronization function shown as the figure below When PC is selected it indicates that the time and date of HMI are both synchronized with the PC If a linkage node is selected it indicated that the time and date of HMI and PC are all synch
77. ect the SQL Server that the users want to access Create a Mew Data Source to SOL Server This wizard will help vou create an ODBC data source that you can use to connect to SOL Server What name do vou want to use to refer to the data source Name TEST How do vau want to describe the data source Description Which SQL Server do vou want to connect to Sener DELTA SBL i Cancel Help Press Next button to continue Choose how SQL Server should verify the authenticity of the login ID Enter the user s name and the password In this case the user s name is sa and the password is 0000 Press Next button to continue Create a New Data Source to SOL Server How should SOL Server verify the authenticity of the login DY C Windows NT authentication using the network login To change the network library used communicate with SUL Server click Client Configuration Chent Configuration iv Connect to SUL Server to obtain default settings for the additional configuration options lt Back Neo Cancel Help 7 10 Revision October 2010 ao m wi Change the default database to DELTA Press Next button to continue Create a New Data Source to SOL Server Change the default database to DELTA Attach database filename lea Lan maian Sto
78. ed data in the specified folder C Data 5 1 1 Create HMI Project File Start Screen Editor software program and click File gt New or click New icon to create a new project Then click Element gt Input gt Numeric Entry to create two numeric entry elements 3 and 6 on the screen In this case 10 inches color AE type DOP series HMI is used File Edit View Element Screen Tools Options Window Help jodH 9 OF w m v 2 Cee esas 11 Screen 1 vi eei v Screen Screen 1 Screen Properties Detail Background Color 255 255 2 Screen Open Macro 0 Screen Close Macro 0 Screen Cycle Macro 0 Screen Width 640 Screen Height 480 E List Preview Output Step Action i Create element J Delete element 2 Create element 4 Create element Y gt m Record Output EGR AMM FT ied rois Download USB 630 201 DOP AEI0THTDI 65536 Colors gp NUM Revision October 2010 5 1 207 Chapter 5 Writing Data in Microsoft Excel eet ver Use Screen Cycle Macro and enter the following commands in macro command window Screen 1 Cycle Macro Ken dh 3 3 1 2 6 6 3 Click Options gt Configuration and use Communication tab to select Ethernet and co
79. edge and Falling edge In this case it is set to Rising edge After completing all the settings please make sure that the IP address numbers of subnet masks of the PC 172 16 190 1 and HMI 1 72 16 190 11 are the same otherwise HMI may not be displayed in the list when finding node Revision October 2010 11 25 Chapter 11 Recipe Access Example Networking Settings EL sers Ensure to observe the following instructions to complete PC networking settings before eServer operation Setting PC Network Programs Windows XP Professional Search Help and Support Documents Control Panel Connections E Printers and Faxes 3 Taskbar and Start Menu Run Shut Down Power on PC and start Windows Click Start gt Programs point to Control Panel and then Network select Network Connections connections E Control Panel Fie Edit wiew Favorites Tools Help e Bact 7 Search li Folders Address EE E Control Panel gt Switch to Category view See Also Windows Update Help and Support Administrative Automatic Tools Updates aame Controllers Phone and amp Accessibility Odd Hardware Options Display Folder Options BDE Date and Time Administrator Internet Options
80. ent gt J Delete element 2 Create element Create element ji gt AM OM OX Soe Download USB 366 14 179 40 W 220 83 DOP AE10THTD1 65536 Colors NUM Record Output Change Window Position The following Remote Setting dialog box will appear Check the check box before Enable eServer Remote and set a password for network communication After OK button is pressed HMI networking is completed Compile the edited project file at the end of the programming and the edited project file could be transferred to HMI Romote Setting Enable eServer Remote Password 12345678 screen sample time in 100 z Revision October 2010 7 15 eem reno Chapter 7 Writing Data in Microsoft Access Ead eese Ver 7 1 3 Setting 1 After eServer is enabled eServer AW icon will appear at the bottom right of Windows screen Right click this icon and select Setting option from the pop up menu Excel Visible aud E O 2 Then eServer window will open eServer File View Tool Help Project 22 eServer 24344444243 3 Click File New or click icon to create new project file File View Tool Help 7 16 Revision October 2010 aL t3 ET E 4 Select icon to enable ODBC Logging Wizard i Recipe Access Logging ODBC yea raS onn TUM T C Docu
81. epair WM Disable this network device Bridge Connections 4 5 Repair this connection Creare Rename this connection Delete MD view status of this Rename connection Change settings of this Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Local Area Connection Properties General Authentication Advanced TTT Connect using E Intel R PROA1000 MT Network Con This connection uses the following tems Client For Microsoft Networks File and Printer Sharing for Microsoft Networks aos Packet Scheduler Frotocal Install Properties Description Transmission Control Pratacal Intermet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected me when this connection has limited er no connectivity Revision October 2010 3 3 Chapter 3 Before Using eServer EZ ciere The Internet Protocol TCP IP Properties dialog box will open Choose Use the following IP address and enter the IP address numbers of the PC into the field of IP address and Subnet mask Internet Protocol TCP IP Properties i Te nrnQ General Y au can get IP setting
82. erate a password Click Copy button to insert the password into the fields of Password and Re type Scroll the screen down and click on Check link to select all privileges Then click on GO button to create a new user Global privileges Check Uncheck All Jata SELECT INSERT UPDATE DELETE FILE Resource limits Note MySQL privilege names are expressed in English structure CREATE ALTER INDEX DROP CREATE TEMPORARY TABLES CREATE VIEW SHOW VIEW CREATE ROUTINE ALTER ROUTINE EXECUTE Note Setting these options to 0 zero removes the limit QUERIES PER HOUR 0 UPDATES PERHOUR O MAX CONNECTIONS PER HOUR 0 _ 5 4 Administration GRANT SUPER PROGESS RELOAD SHUTDOWN SHOW DATABASES LOCK TABLES REFERENGES REPLICATION CLIENT REPLICATION SLAVE CREATE USER Revision October 2010 EZ versa Chapter 8 Writing Data in MySQL A conformation message will be displayed as follows Server localhost HT Charsets Bi Engines amp SPrivileges Processes Export Databases A SOL Status Variables You have added a new user SQL query CREATE USER roots IDENTIFIED BY GRANT ALL PRIVILEGES TO root ze IDENTIFIED BY WITH GRANT OPTION MAX QUERIES PER HOUR 0 MAX CONNECTIONS PER HOUR 0 MAX UPDATES PER HOUR 0
83. es Null Default Extra Action Time varchar 50 utf8 general ci No E Datat varchar 50 utf8_general_ci E F ul T Bata2 varchar 50 8 general ci M E C xXx BM m EB Check Uncheck All With selected 2 7 in Print view a Propose table structure Add 11 field s At End of Table At Beginning of Table After Time Indexes Space usage Row Statistics Type Usage Statements Value P No index defined Data 0 B Tie 8 10 Revision October 2010 Sergey C Create New User Chapter 8 Writing Data in MySQL Click on Privileges link to open User overview page localhost ed Server version 5 0 51b community nt log Protocol version 10 ed Server localhost via TCP IP User root localhost phpMyAdmin 2 10 3 MySQL client version 5 0 51a Used PHP extensions mysql Language English Theme Style Original 5 charset UTF 8 Unicode EMySQL llati gt Font size 100 ily connection collation zi Es ci m documentation ETT wiki aCreate new database ElphphyAdr Collation 5 fat Official phpMyAdmin Homepage ChangeLog Subversion Lists Create Show MySQL runtime information Show MySQL system variables Processes Sets and Collatians Stora
84. fer the HMI screen project file via network communication directly Transfer Path Please select the following 2 methods to link 1 CO Select a exist Screen DOF file fram stroed media 2 Tansfer from Delta HMI a7 Be 190 4 Press OK button to go to next step 6 1 2 ODBC Open Data Base Connectivity This step is used to create an ODBC Data Source pointing to your database Wizard Lorzrinrz ODBC Please indicate the following items Chooses a data source DSN and input user name and password User Name Password Database Driver sqL Server Table 1 Table 1 Time and Date Tablel Time To continue dick Next ODBC Data Source Name of ODBC Data Source Name of Sampling Data Table Revision October 2010 6 3 Chapter 6 ODBC Sampling Setting EZ cera Time and Data Stamp Function Table which the time and date will be written Field which the time and date will be written Detail The format of the date and time is specified by a string of characters which can be user defined and changed freely Please refer to the table below for the string representation 6 4 Revision October 2010 Ead asServyva Chapter 6 ODBC Sampling Setting 6 1 3 Register Setting This step is used to set the register address of the sampling data Wizard Lozems Register Setting Address Table 33 Deu __ To continue click Next
85. g directions could be selected Please refer to the following table for explanation Multi Vertical When this option is selected multiple numbers of different register data could be logged into each vertical column in the selecting area simultaneously Multi Horizontal When this option is selected multiple numbers of different register data could be logged into each horizontal row in the selecting area simultaneously Revision October 2010 Ead eer a Chapter 4 Excel Sampling Setting Single Vertical When this option is selected only one number of register data could be logged into one cell for one time The sampling operation is in vertical direction The sampling operation of the second vertical column will not start unless the sampling operation of the first vertical column is done Please refer to the right diagram as ass 71 bito mm E Single Horizontal When this option is selected only one number of register data could be logged into one cell for one time The sampling 7 operation is horizontal direction sampling operation of the second AA horizontal row will not start unless the Sampling operation of the first horizontal row is done Please refer to the right diagram Anywhere When this option is selected the register data could be logged into any desired cell 2 Selection Range Press Excel button
86. ge Engines Reload privileges gePrivileges Databases amp 3Export amp amp lrmport out phpMyAdmin Click on Add a new User link to display the add new user page 9 Server localhost S5 Privileges Processes Asi Export t Status Variables Charsets Engines User overview Ho B E oH 1 4 WOO M WHS XQ TOW A Wy JShew a User Host Password Global privileges Grant Any USAGE 82 m localhost No USAGE No 5 production mysql com No USAGE No root 127004 ALL PRIVILEGES Yes of foot localhost Yes ALL PRIVILEGES Yes root production mysql com No ALL PRIVILEGES Yes t Gheck All Uncheck All Add anew User Remove selected users Revoke all active privileges from the users and delete them afterwards Drop the databases that have the same names as the users Revision October 2010 Chapter 8 Writing Data MySQL Login Information Generate Password User name Use text field Host Use text field Password Use text field He type Generate Login Information User name Enter user name root 5er jar Host Select Any host from the drop down menu and insert a 96 code Password Enter the desired password Re type Re enter the desired password General Password Click on Generate button to automatically gen
87. gines I gt Reload privileges Privileges Databases amp Export amp slmport phpMyAdmin Done Local intranet 100 Revision October 2010 8 7 Chapter 8 Writing Data MySQL A Create New Database Click on Databases link localhost phpMyAdmin 2 10 3 Server version 5 0 51b community nt log MySQL client version 5 0 51a phpMyAdmin gt Protocol version 10 Used PHP extensions mysql amp J Server localhost via TCP IP Language English v arame Pv hanva HE a E cn ser root localhos Theme Style Original v Database 3 4ySQL charset UTF 8 Unicode utf8 Font size 100 Databases 50 connection collation oS EiphpMyAdmin documentation utf8 unicode ci v wiki Please select a database Create new database ih ha psn shen pete 1 4 Official phpMyAdmin Homepage ChangeLog Subversion Lists Collation Create mesi res Show MySQL runtime information 8 Show MySQL system variables Processes Sets and Collations amp Storage Engines I gt Reload privileges Privileges amp 3Export BiLog out phpMyAdmin Enter the name of the new database In this case the name of the new database is entered as test Click on Create button for the next step 03 Server localhost Databa
88. ing process is repeated The time unit is ms Logging Condition senting nem Remark Sampling type There are two kinds of options for selection Const and Trigger Const Execute sampling repeatedly in a certain span of time Trigger Execute sampling when the trigger conditions are satisfied Register Address 1 When the register address is set to Bit the selectable options are A Rising edge Triggered by rising edge B Falling edge Triggered by falling edge Controller Connecting controller Unchangeable Format HMI Name Name of connecting HMI Revision October 2010 6 7 Chapter 6 ODBC Sampling Setting 6 8 This page intentionally left blank OT wm EZ 2 SOI War Revision October 2010 Chapter 7 Writing Data in Microsoft Access Before creating testing example make sure to change the upload and download option Options gt Configuration on Screen Editor first The default setting of upload and download is via USB If the users need to use Ethernet please change the default setting by referring to Appendix A 7 1 Example This example is used to help the users to understand how to use eServer to read the data of the register addresses 3 and 6 every second record the data in Microsoft Access database via ODBC interface and save the collected data into the specified folder C Data 7 1 1 Database Setting 1 Installing MSDE First download the free s
89. ion uses the following tems Client For Microsoft Networks File and Printer Sharing for Microsoft Networks aos Packet Scheduler Frotocal Install Properties Description Transmission Control Pratacal Intermet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected me when this connection has limited er no connectivity 11 12 Revision October 2010 The Internet Protocol TCP IP Properties dialog box will open Choose Use the following IP address and enter the IP address numbers of the PC into the field of IP address and Subnet mask Internet Protocol TCP IP Properties General Y au can get IP settings assigned automatically if your network supports this capability uou need to ask your network administrator for the appropriate IP settings C3 Obtain an IP address automatically Use the following IP address IP address 172 16 1 Subnet mask 255 255 255 Default gateway LE 4 blan server autoralicalli gt Use the following DNS server addresses Preferred DHS server m Alternate DNS server Advanced Then press OK button to finish the settings Setting IP Address in HMI Enter into the system menu and set IP address to 172 16 190 11 P
90. ipe gt Simulation CtrHtFa CHF Line Simulation Ch ES Upgrade firmware Finnvrare Information renis Options Window Help LESE Compile ChHE7 Download Screen Ctrl F9 Upload recipe Download Recipe On line Simulation CtrHF4 Off Line Sinilation ChHES Upgrade firmare Firmware Information Revision October 2010 Ea eee vet Appendix A Upload Download via Ethernet Then the following dialog box will appear Destination Static IP O Auto Seach type Source IP The users can check the box before Auto Search and the system will detect the connecting HMI automatically Destination Static IP el Auto Seach HMI Model toe Source IF Ad DOP BIGER15 172184180118 12346 When the connecting HMI is found press Start button and the system will start to upload or download the screen data via Ethernet immediately Revision October 2010 A 9 OUT Appendix A Upload Download via Ethernet EZ cera This page intentionally left blank A 10 Revision October 2010
91. irewall General Exceptions Advanced Windows Firewall is blocking incoming network connections except for the program and services selected below Adding exceptions allows some programs to work better but might increase your security risk Programs and Services Mame File and Printer Sharing Network Diagnostics For Windows Remote Assistance Remote Desktop SMLM Pros Module Framework Windows Live Messenger 8 1 Windows Live Messenger 8 1 Phone Windows Netheeting Add Programm Add Part Display notification when Windows Firewall blocks program What are the risks of allowing exceptions cen 7 2 Revision October 2010 EZ a Ser Ver Chapter 7 Writing Data in Microsoft Access Click Add Port button and the following Add a Port dialog box will appear Use these settings to open a port through Windows Firewall find the part Humber and protocol consult the documentation For the program service you Wart to use 201 Pert number 1433 amp TCP 3 UDP In the Add a Port dialog box type SQL in the Name text field and type the port number of the instance of the Database Engine such as 1433 for the default instance in the Port number text field Ensure that TCP is selected and click OK to complete the settings When SQL port is shown and selec
92. king Runtime Shortcut Please refer to the figure below Make Runtime Shortcut Runtime Shortcut Name DOP eServer Runtime How to activate There are two methods provided O Create eServer shortcut on desktop After starting up double clicking the eServer shortcut on desktop and the system will activate eServer immediately HMI Password 12345678 Install Uninstall Revision October 2010 Chapter 3 Before Using eServer EZ erar When selecting the desired method press Install button to finish the settings Make Runtime Shortcut x Runtime Shortcut DOP eServer Runtime How to activate eServer There are two methods provided Make eServer software program run on Windows startup After starting up the system will activate eServer automatically C rate a eser S eServer immediately 1 ODEC3 Install Uninstall If the users want to delete the shortcut please start eServer click Tool gt Make Runtime Shortcut and press Uninstall button to remove the shortcut Failure to follow the above instruction to delete the shortcut will result in system error or abnormal operation Runtime Shortcut Runtime Shortcut Name eServer Runtime How to activate There are two methods provided D Make eServer software program run on Windows startup After starting up the system will activate eServer au
93. l Help asa a n ea Save Run Press gt icon The following dialog box will pop up and ask the users to enter the password SESE EE HEE EE all passwords are the same password under Cancel Revision October 2010 11 21 Wr Chapter 11 Recipe Access Example esee Please enter 12345678 in the filed of the password at the first time 12345678 is the default setting value and the users can change it freely After the correct password is entered the icon will display the tool bar at the left bottom corner When eServer performs reading please trigger the maintained button element on HMI and enter the value of 4 Then the system will convert the recipe data to the data of 0223 rcp and show on HMI screen Please refer to the figure on next page 11 22 Revision October 2010 Delta Soft Simulator Y2 21 Kernel Ver R 2 74 eles Delta Soft Simulator V2 21 Kernel Ver R 2 74 Recipe Address 1 Revision October 2010 11 23 Chapter 11 Recipe Access Example Ea On the other hand if incorrect or invalid password is entered the following error message dialog box will appear to alert the users Er HM Im DINEM 1 Recipe HM ESeEIVel E3 Cant connect ta HMI a all passwords are the same password under No 1 Export Variance Setting a Select Variance b Check the ch
94. l might be unstable The maximum of sheet in Excel only support 128 pages To continue cick Next Press Next button to go to next step Revision October 2010 5 5 Chapter 5 Writing Data Microsoft Excel Ead eise Ver 5 Click New icon to access nodes link to Wizard Logzing Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Llinakge name Please click the following buttons to access nodes es To continue click Next Choose Transfer from Delta HMI option to transfer the HMI screen project file via network communication directly Press OK button to go to next step Transfer Path Please select the following z methods to link 1 CO Select exist Screen DOP file from stroed media 2 gt Tansfer Delta 472 190 2 IF Address Setup Hamne Target eRernote 172 186 1902 5 6 Revision October 2010 eserver Chapter 5 Writing Data in Microsoft Excel 6 Design Excel template sheet Select Create a new Excel file option and press Next button to go to next step Wizard Logging Excel Template Designed Template Designed will provide a method to help you easy build sheet in Excel Please select the following opti
95. lay Folder Options Fonts Game Intel Internet Keyboard Windows Update Controllers Graphics Options Revision October 2010 8 15 Chapter 8 Writing Data MySQL EZ sera In the Administrative Tools double click Data Sources ODBC EE Administrative Tools File Edit wiew Favorites Tools Help Back gt 7 Search Folders Address 4 Administrative Tools Computer Management File and Falder Tasks a Shortcut 2 Share this Folder Data Sources ODBC Event Viewer Shortcut Shortcut Other Places 2 2 KB gt Control Panel Local Security Policy 5 Performance eq Shortcut shortcut Lj My Documents 2 ZEE zd Dea mmn In the ODBC Data Source Administrator dialog box select System DSN tab and click on Add button to add system data source 1 ODBC Data Source Administrator User DSN System DSN File DSH Drivers Tracing Connection Pooling About System Data Sources Driver An ODBC System data source stores information about how to connect to the indicated data provider System data source is visible to all users on this machine including services Cancel Apply Help 8 16 Revision October 2010 Select MySQL ODBC 5 1 Driver and then click Finish button Create Mew Data Source Select a driver Far which vou want to set up a d
96. le Dim ane 3 9 aema qnd Hop the Shonen you disconnect When ecu drscoanrect and ss Use ANSI quoted identifiers Use ANSI nulls paddings and warnings Hee Hie baia v ena bl BTE d li reir _ 4 Press Finish button Create a New Data Source to SOL Server Use strong encryption for data Perform translation for character data Use regional settings when outputting currency numbers dates and times Save long running queries ta the log D SDECEIWE T EE en rm EIE le Long query time millisecands H Log ODBC driver statistics ta the log file E 3sDIEEHME laid TAT rem Cancel Help Revision October 2010 7 11 Chapter 7 Writing Data in Microsoft Access Press OK button to complete ODBC setup ODBC Microsoft SOL Server Setup new ODBC data source will be created with the Following configuratiors Microsoft SQL Server ODBC Driver Version 03 85 1117 Data Source Mame TEST Data Source Description Server I amp BLI SHIRLEY EH Database master Language Default Translate Character Data es Long Running Queres Log Driver Statistics No Use Integrated Security Use Regional Settings Ma Prepared Statements Option Drop temporary procedures on idisconnect
97. lease see the figure below gt System Setting Grek T 172 16190 11 1255255 0 AU Xe NE d OB 00 00 00 00 00 Revision October 2010 11 13 Chapter 11 Recipe Access Example Ea After completing all the settings and make sure that the communication is good use the most updated Screen Editor program editing software to open the selected dpb file which just has been modified on eServer Create a character input element and set its address to 100 T Sereen 1 og Select RCFNO Buter 1234 1234 100 SAK RK Recipe Address 1 i234 PLC Address Toren 1234 I gt Then compile it and download the recipe data to HMI After recipe data is downloaded to HMI successfully return to eServer save the file first and then run the recipe data Next trigger the character input element on HMI and the system will save the imported file to the destination path Please see the figure below Fie View Tool Help s Save Run 11 14 Revision October 2010 Press gt icon The following dialog box will pop up and ask the users to enter the password Authorize c I all passwords are the same password under Ma 1 Please enter 12345678 in the filed of the password at the first time 12345678 is the default setting value and the users can change it freely After the correct passw
98. load via Ethernet A 2 COM Port Settings If the users choose to use DHCP mode it is not necessary to set Ethernet IP address in COM Port tab Co nfiguration General COM port Control Black pork Move Lip aede Overwrite IP Printer Setup Default Modify Hove Down Obtain address automatically oY COMI Name c COM2 Okher Base Fort COM3 hemet Revision October 2010 A 3 Appendix Upload Download via Ethernet EZ erar If the users choose to use user defined IP address please set Ethernet IP address in COM Port tab and ensure that the domain name is the same as the IP address of the personal computer Co nfiguration General Control Black ERA BS Delete Move Up Printer Setup venere DeFault Modify MBSE LDW Obtain an IP address automatically Other COM HMI Name HMI COM2 Base Port HMI IP Address 172 16 190 11 Y COM3 Ethernet Subnet Mask 265 285 285 D Gateway upload downlaa 12346 After Ethernet IP address is set the users can enter into the system menu to verify if the address is written correctly or not Of E System Setting E oor Mu 172 16190 11 255255 0 CIN AD OB 00 00 00 00 00 A 4 Revision October 2010 Appendix A Upload Download via Ethernet Then observe the following instructions to complete PC
99. ly Use the following IP address IP address 172 16 1 Subnet mask 255 255 255 Default gateway LE 4 blan server autoralicalli gt Use the following DNS server addresses Preferred DHS server m Alternate DNS server Advanced Then press OK button to finish the settings Setting IP Address in HMI Enter into the system menu and set IP address to 172 16 190 11 Please see the figure below gt System Setting Grek T 172 16190 11 1255255 0 AU Xe NE d OB 00 00 00 00 00 11 8 Revision October 2010 Chapter 11 Recipe Access Example After networking settings are set correctly and successfully return to eServer save the file first and then run the recipe data Please see the figure below File Tool Help Save Run Press gt icon The following dialog box will pop up and ask the users to enter the password Authorize ixi qp eoo gases are the same under Please enter 12345678 in the filed of the password at the first time 12345678 is the default setting value and the users can change it freely After the correct password is entered the icon will display on the tool bar at the left bottom corner When eServer performs reading the system will examine and check if the saved file name Impe tB jay is s
100. ments and Settings Tina Q Lee DesktoptOt L EL current graject cres Wizard Logging Welcome to the ODBC Logging Wizard This wizard helps you how to logging data from HMI to Database To continue click Next Press Next button to go to next step Revision October 2010 207 ee Chapter 7 Writing Data in Microsoft Access Ead eise Ver 5 Click New icon to access nodes link to Wizard Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Llinakge name Please cick the following buttons to access nodes To continue dick Next Choose Transfer from Delta HMI option to transfer the HMI screen project file via network communication directly Transfer Path Please select the following 2 methods to link 1 Select a exist Screen DOP file from stroed media 2 gt Tansfer from Delta Hil ar ee A Press OK button to go to next step IF Address Setup E Search IP in Ethemet Update Hare Target IP eRemote 172161902 Press OK button to go to next step 7 18 Revision October 2010 DOF ET oa E cera Chapter 7 Writing Data in Microsoft Access 6 ODBC Data Source Setting Create an ODBC Data Source pointing to your database Please refer to the foll
101. mmn 7 8 Computer Management B Shortcut B kb Event Viewer i Shortcut i Performance Shortcut 2 KB Revision October 2010 Ed m Im Waal In the ODBC Data Source Administrator dialog box select System DSN tab and click on Add button to add system data source gt ODBC Data Source Administrator User DSN System DSN File DSN Drivers Tracing Connection Pooling About System Data Sources Mame Driver An ODBC System data source stores information about how to connect to the indicated data provider A System data source is visible to all users an this machine including services Cancel Apply Help Select SQL Server and then click on Finish button Create Mew Data Source Select a driver For which you want to set up data source Mame d Microsoft FoxPro Driver Microsoft ODBC for Oracle Microsoft Parados Driver Microsott Parados T reiber Microsott Test Driver tat csr Microsoft 7 ext Treiber Est Microsoft Visual FoxPro Driver Treiber gt Cancel Revision October 2010 7 9 Chapter 7 Writing Data in Microsoft Access In the Create a New Data Source to SQL Server dialog box do the following Enter the name of the data source and sel
102. mplete HMI networking settings shown as the figure below Then press OK button to finish the settings Configuration Standard Communication Print Default Others bienes v Recovery the IP address in HMI I DHCP Pp eve Eom HMI Name Remote JJ COMI O HMIIPAddess 172 16 2190 2 zl Base Port c COND Default Gateway D s Hb Ethernet Subnet Mask 5 2 Revision October 2010 DOr Im PASV Chapter 5 Writing Data in Microsoft Excel Next click Options Network Setting gold xl E Configuration Setup XT LEX a PT cam T Emm x 3 U Z qm im lw i History Setup Biel a rms ahs hos D mt e Passowrd Table Setting amp 1 1 Screen 1 Tee Table Vek T Print Typesetting Segen Picture Bank Screen Screen 1 Text Bank Screen Properties Detail C 255 255 2 Submacro Background Color Initial Macro Screen Open Macro 0 Background Macro Screen Close 0 Clock Macro Screen Cycle Macro 2 Screen Width 640 Ervironment Screen Height 450 E List 0 Preview Output a X Step Action 1 Create element gt J Delete element 2 Create element Create element
103. n Time How long would you like on your logging data S00ms one day B Hour m Minute Second 9 B ms Cancel 2 Trigger Execute sampling when the trigger conditions are satisfied This option is used to determine how long the sampling process is repeated when the 9 Mode Setting Tye Name Address Address Format Controller Cmm Tus HMI 00 Rising edge EL n ernal Memory ER Falling edge Internal trigger conditions are met The detailed settings are described as follows Revision October 2010 10 5 ae 4 Chapter 10 Recipe Access Setting Polling Cycle Sampling Cycle It is used to determine how long the sampling process is repeated The time unit is ms Logging Condition seughem Description Remark _ Sampling type There are two kinds of options for selection Const and Trigger Const Execute sampling repeatedly in a certain span of time Trigger Execute sampling when the trigger conditions are satisfied Type Register Address 1 When the register address is set to Bit the selectable options are A Rising edge Triggered by rising edge B Falling edge Triggered by falling edge Controller Connecting controller Unchangeable Format HMI Name Name of connecting HMI 10 6 Revision October 201
104. name Drop Truncate Create Lookup Table Revision October 2010 EZ aT Chapter 9 Writing Data in Oracle 9 1 2 Create HMI Project File Start Screen Editor software program and click File gt New or click New icon to create a new project Then click Element gt Input gt Numeric Entry to create two numeric entry elements 3 and 6 and click Element gt Button gt Maintained to create two maintained button elements 0 0 is for rising edge and 0 2 is for falling edge on the screen In this case 10 inches color AE type DOP series HMI is used 1 Screen 1 Rising Edge Falling Edge Revision October 2010 9 13 Click Options gt Configuration and use Communication tab to select Ethernet and complete HMI networking settings shown as the figure below Then press OK button to finish the settings Configuration Standard Communication Print Default Others Recovery the IP address DHCP HWI Hare eRemnte Address 132 16 190 2 Subnet Mask 255 1255 255 Default Gateway D 0 du B 9 14 Revision October 2010 Next click Options gt Network Setting File Edit View Element Screen Tools 3353 Window Help 9 DE Bey T 4 imr a LJ uc Alarm Setup History Setup aS D mt e i Passowrd Table Setting
105. nation Folder Space required 56 4MB Space available 477 3MB Select the default directory C AppServ and click on Next button for the next step To select a directory other than the default directory click Browse Revision October 2010 Chapter 8 Writing Data MySQL EZ sere AppServ 2 5 10 Setup Select Components Select the components you want bo install clear Ehe components WOU do nat want bo install Package Components Apache Server Database Hypertext Preprocessor phpMyAdmin z Back Cancel Then select the AppServ Package Components to install and click on Next button for the next step n AppServ 2 5 10 Setup Apache HTTP Server Information Please enter your server s information Server Mame e g wiww appservnebwork com Administrator s Email Address e g webmastera agmmail Apache HTTP Port Default 80 Specify Server Name Administrator s Email Address and Apache HTTP port for Apache Web Server When perform testing the Servo Name can be specified as localhost directly Click on Next button for MySQL Server Configuration settings 8 4 Revision October 2010 n AppServ 2 5 10 Setup UN MySQL Server Configuration M Q Te Configure the MySOL Server instance Please enter Root password For MySQL Server Enter root password Re ente
106. nections LE Control Panel File Edit View Favorites Tools Help Bact Search ae Folders ie address Ru m m Rm um 0 ve Control Panel A 6 X ETE Accessibility Add Hardware Add or Administrative Automatic BDE Date and Time g Switch to Category view Options Tools Updates Administrator T A z MA S BK WwW ud gt Display Folder Options Fonts Game Intel Internet Keyboard Windows Update Controllers Graphics Options Help and Support om EFi amp 5 Mail See Also Mouse Netiwork Phone and Power Options Printers and Regional and Connections Modem Faxes Language Ss o5 9 Wu Scanners and Scheduled Security Sounds and Speech System Taskbar and Cameras Tasks Center Audio Devices Start Menu User Accounts Windows Wireless Firewall Network Set 3 2 Revision October 2010 Double click Network Connections icon the following windows will appear Right click the Local Area Connection icon and then select Properties from the pop up menu Network Connections File Edit View Favorites Tools Advanced Help sack 2 d Search j Folders EHE Address Network Connections LAN or High Speed Internet Network Tasks 5 Creat Area Connection reate Connected connection ww Disable Change Windows Status Firewall settings R
107. nstallation Click on Install button to installing Oracle Database 10g Oracle Database 10g Express Edition Install Wizard Setup Status CATABASE Tu he Install5hieldH Wizard 1 installing Oracle Database 10g Express Edition Copying Files WREEEREEE The installation wizard is installing Oracle Database 10g Revision October 2010 9 5 Chapter 9 Writing Data Oracle Oracle Database 10g Express Edition Install Wizard InstallShield Wizard Complete EZ cer ar Setup has finished installing Oracle Database 10g Express Edition on your computer DATABASE EXPRESS EDITION Click on Finish button to complete Oracle Database 10g setup 2 ODBC Setup In the Control Panel double click Administrative Tools E Control Panel File Edit Favorites Tools Help 7 Search 2 Folders ab Address Control Panel Ji Control Panel gt Switch to Category View See Also Accessibility Odd Hardware Options Display Folder Options Windows Update E 1 Add or Remnowv Automatic Updates Administrator Internet Options Game Controllers Fonts Intel Graphics In the Administrative Tools double click Data Sources ODBC Administrative Tools Edit Help Search 2 Folders EHE File Tools Back 3 Address Favorites 2 4 Administrative Tools File
108. oftware MSDE from the Microsoft web site To download it go to http www microsoft com downloads details aspx familyid 4 13 744d 1 a0bc 4 7 9f bafa e4b278eb9147 amp displaylangzzh twzfilelist and a download link will redirect the users to download it After running the self extracting file open setup ini file within MSDE subdirectory for editing In the setup ini file under the Options tag insert SAPWD 0000 SECURITYMODE SQL The SAPWD is the password required for the system administrator SA login account In this case the SA login password is set to 0000 The users can set the desired password freely Once the setup ini file is saved double click setup exe to complete MSDE installation Revision October 2010 7 1 Chapter 7 Writing Data in Microsoft Access 2 Enabling MSDE Execute SVRNETCN exe 3 within C Program Files Microsoft SQL Server 80 Tools Binn subdirectory and enable Named Pipes and TCP IP options 5 SOL Server Network Utility General Network Libraries Instance s on this server I amp BLI SHIRLE Y EM Disabled protocols Enabled protocols Multiprotacal Named Pipes wink AppleTalk Banyan Vines Foce protocol encryption Enable WinSock proxy 3 Setting Windows Firewall Click Start and then click Control Panel In the Control Panel click Windows Security Center gt Windows Firewall Then click on the Exceptions tab Windows F
109. og box will open Choose Use the following IP address and enter the IP address numbers of the PC into the field of IP address and Subnet mask Internet Protocol TCP IP Properties General Y au can get IP settings assigned automatically if pour network supports this capability Otherwise need to ask your network administrator For the appropriate IP settings C3 Obtain an IP address automatically gt Use the following address address 172 16 190 1 Subnet mask 255 Je ni Default gateway 2 Use the following DNS server addresses Prefered ONS server Alternate DNS server Advanced Then press OK button to finish the settings Please note that if the IP address numbers of subnet masks of the PC and HMI are different HMI may not be displayed in the list when finding node Revision October 2010 7 Appendix A Upload Download via Ethernet EZ Te 24 cer year A 3 Compile and Upload Download Screen amp Recipe After completing PC networking settings compile the editing program immediately When compile operation is performed successfully choose Upload Screen amp Recipe or Download Screen amp Recipe next A 8 Options Window Help Compile 6 Download Screen amp Recipe Upload Screen amp Recipe Download Screen Ctr F9 Upload recipe Download Rec
110. on Exoress 2 1 0 00 29 Copyright 1999 2006 Oracle All rights reserved Revision October 2010 Help IN 2 dI c AA QAM V A AAJYNAALLL LLL ET te Ead eee yel Chapter 9 Writing Data in Oracle Enter the name of the table In this case the name of the new table is entered as oracletable Create three columns TIME DATA1 and DATA2 and select Type as CHAR Character Click on Next button for the next step reste Tabie Primary Ke D Table must pe N a ractet abe Preserve Case Column Hame Type Precision Scale Not Hull Move X TIME CHAR mo E Y BATA cua n wm paraa mo Select Datatype va Select Dat atype Add Column Select No Primary Key Click on Next button for the next step Table ORACLETABLE Primary Key No Primary Key Populated from a new sequence Constraints Populated from an existing sequence Not populated LOTT Click on Next button for the next step Foreign Key Columns Referenced Table Referenced Columns X Action Columns Primary Ke Add Foreign Key Add p m SS Disallow Delete Name O RACLETABLE fk Cascade Delete Q Set Null on Delete select Key Column s Key Column s TIME DATA DA
111. ons to decide how to design a template CO Select a exist Excel file from stroed media ES To continue click Next The system will enable Excel automatically Create a Excel template sheet as the figure below and enter the following formulas into the cells of E3 E22 in order Then press Close button in the dialog box which appears at the bottom right of Windows screen to go to next step Column Formula E3 AVERAGE C3 D3 E4 AVERAGE C4 D4 5 AVERAGE C5 D5 AVERAGE C6 D6 AVERAGE C12 D12 AVERAGE C13 D13 AVERAGE C14 D14 AVERAGE C15 D15 AVERAGE CI 6 D1 6 AVERAGE CI 7 D1 7 AVERAGE CI 8 018 AVERAGE CI 9 D1 9 E8 E9 AVERAGE C8 D8 AVERAGE C9 D9 AVERAGE C10 D10 AVERAGE C11 D11 E20 AVERAGE C20 D20 AVERAGE C7 D7 Revision October 2010 5 7 UD AT Va Chapter 5 Writing Data in Microsoft Excel Microsoft Excel Book11 9 File Edit Insert Format Tools Data Window Help Adobe POF Minitab ER didi n 2 8 zii e Bins f AVERAGE C3 D3 a 7 2 Data Average 4 WH M Se See 8 m ee 7 LL LLL ns or ae 8 oo i m ao 4 ee
112. ord is entered the icon will display on the tool bar at the left bottom corner When eServer performs reading please trigger the character input element on HMI and enter TINA these four characters Please refer to the figure below EJ Delta Soft Simulator 2 19 Kernel Ver R 2 73 g Revision October 2010 11 15 Chapter 11 Recipe Access Example Then the system will examine and check if the saved file name is saved in the destination path or not Please refer to the figure such as On the other hand if incorrect or invalid password is entered the following error message dialog box will appear to alert the users Linkage HMI Password 1 Recipe eServer ant connect ta HMI all passwords are the same pazsvvord under 11 1 4 Setting and Condition Export Export Fixed Setting a Select Fixed b Check the check box to use 16 bit recipe as the example c Information shows the length and the group of the recipe data d Set Destination Path destination location where the imported file is located Please note the value of the selected 0223 rcp file item d is the downloading value when the element is triggered on HMI un ars wow Le cc dr d 3 3 2 7 111 222 333 444 555 666 4 717 888 999 11 16 Revision October 2010 Chapter Recipe Access Example Fixed gt t c 4
113. owing settings Wizard Lozrmr ODBC Please indicate the following items Chooses data source DSN and input user name and password ODBC Data Source User Password Database Driver Table Stamp Tablel Time To continue dick Next Press Next button to go to next step 7 Register Setting Set the register address of the sampling data Wizard Logrzing Register Setting Please input logging address in the following Cell s Feld Mites Ades 2 Tabl Be Us continue click Next Revision October 2010 7 19 8 Set the sampling conditions to constant 5s Wizard Logging Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition Haw long would you like your logging data 500 one day Minute Second ms To continue cick Next Press Next button to continue 9 Press gt icon After the password is entered the system will start sampling operation i e writing data in Microsoft Access ODBCi I passwords are the same password under No 1 7 20 Revision October 2010 Writing Data in Microsoft Access fablel Table D8 26 2009 13 24 55 08 26 2009 13 24 56 08 26 2009 13 24 57 08 26 2009 13 24 58 B8 6 2009
114. r 2010 4 1 Chapter 4 Excel Sampling Setting EL a Ser Var Wizard Logging Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Please click the following buttons to access nodes To continue dick Next Click k icon to link HMI screen project file There are two methods available for selection 1 Select an existing Screen DOP file from stored media Open an existing screen project file and set the IP address of the connecting HMI Transfer Path Please select the following 2 methods to link 1 9 Select a exist Screen DOF file from stroed media CAD acuments and Settings shirley lanky DocumentssDemo_ IPAddess 172 16 190 4 2 Tansfer from Delta HMI Cancel 4 2 Revision October 2010 2 Transfer from Delta HMI Transfer the HMI screen project file via network communication directly Transfer Path Please select the following 2 methods to link 1 CO Select a exist Screen DOF file fram stroed media 2 Tansfer from Delta HMI ar 190 Press OK button to go to next step 4 1 2 Excel Template Sheet Design This step is used to create the desired Excel template sheet There are two methods available for selection 1 Create a new Excel file When this option is selected the system will activate Excel automatic
115. r rook password MySQL Server Setting Character Sets and Collations LITF 8 Unicode Old Password Support PHP MySQL Function Enable InnaDB Back Install Enter root password for MySQL database and complete the settings for MySQL Server Character Sets and Collations The users can select data storage language and collations from the drop down menu Old Password Support PHP MySQL API function When this option is selected the users can code PHP code with old MySQL API Enable InnoDB When InnoDB is used ensure to select this option Click on Install button to installing Apache f AppServ 2 5 10 Setup Installing Please wait while amp ppServ 2 5 10 is being installed Installing Apachez z Service Show details Revision October 2010 O Chapter 8 Writing Data MySQL Click on Finish button to complete AppServ setup n AppServ 2 5 10 Setup Completing the AppSery 2 5 10 Setup Wizard 2 5 10 has been installed on computer Click Finish to clase this wizard Start Apache Start MySQL Lors After installing AppServ the users can view the web site by pointing a web browser to http localhost If the following screen displays it indicates that Apache has been installed successfully A AppServ Open Project 2 5 10 Windows Internet Explorer yv http localhost i x Ires
116. rk Connections LAN or High Speed Internet Network Tasks 5 Creat Area Connection reate Connected connection eee Disable 2 Change Windows Status Firewall settings Repair WM Disable this network device Bridge Connections 4 5 Repair this connection Creare Rename this connection Delete MD view status of this Rename connection Change settings of this Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Local Area Connection Properties General Authentication Advanced TTT Connect using E Intel R PROA1000 MT Network Con This connection uses the following tems Client For Microsoft Networks File and Printer Sharing for Microsoft Networks aos Packet Scheduler Frotocal Install Properties Description Transmission Control Pratacal Intermet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected me when this connection has limited er no connectivity A 6 Revision October 2010 Ea eee vet Appendix A Upload Download via Ethernet The Internet Protocol TCP IP Properties dial
117. rning This server is requesting that your username and password be sent in an insecure manner basic authentication without a secure connection User name root v Password Remember my password Then it will connect to MySQL database 7 localhost localhost phpMyAdmin 2 10 3 Windows Internet Explorer Go Emm F gt 26 live se ej File Edit View Favorites Tools Help a localhost localhost phpMyAdmin 2 10 3 gt 8 e y localhost phpMyAdmin 2 10 3 3 Server version 5 0 51b community nt log gt MySQL client version 5 0 51a gt Protocol version 10 Used PHP extensions mysql Server localhost via TCP IP f language Engish ALIS En sy User root localhost Theme Style Original v Database 3 uySQL charset UTF 8 Unicode utf8 rrt Font size 100 Databases MySQL connection collation Ul a documentation utf8_unicode_ci sl EJohoMyAdmin wiki Please select a database Create new database jihad ath fat Official phpMyAdmin Homepage 1 gt ChangeLog Subversion Lists Colon ES 5 gt Show MySQL runtime information Show MySQL system variables Sets and Collations 8 5 En
118. ronized with the selected linkage eaneryer Option izi Local Host Synchronize 3i Communication Disconnect Timing i Synchronize whe Synchronize whe Current Local Time Thursday October 14 oe Revision October 2010 3 7 Chapter 3 Before Using eServer Ed cera After enable Synchronize function set the timing for synchronizing the time and date There are two selections for setting the timing one is Synchronize when starting and the other is Synchronize when the following cycle reaching Please refer to the figure below If Synchronize when starting is selected the time and date of HMI will be synchronized when eServer is started If Synchronize when the following cycle reaching is selected and the cycle time is set to 12 hours the time and date of HMI will be synchronized once every 12 hours eserver Option Local Host Synchronize zi Communication Disconnect Synchronize Time and Date Synchronize from Timing Synchronize when starting 0 2 2 0 2 Minute Current Local Time Thursday October 14 2010 09 12 07 3 8 Revision October 2010 Ead c SOK Ver Chapter 3 Before Using eServer 3 4 2 Disconnect Function This function allows the system to automatically resume the communication to Ethernet When the connection to Ethernet is disconnected the e
119. rt Windows Click Start Programs point to Control Panel and then Address gt Control Panel d 53 d v3 Control Panel A amp B 9 BY Accessibility Add Hardware gt Switch to view Options See Also Add or Remo Fonts e Network Display Folder Options Windows Update Help and Support Connections e Security Center Scheduled Tasks Scanners and Cameras x Windows Wireless Firewall User Accounts Network Set Date and Time Administrator Internet Options Regional and Language Taskbar and Start Menu Automatic Updates Administrative Tools Intel Keyboard Graphics Bs Controllers Phone and Modern Power Options Printers and Faxes E System g Sounds and Speech Audio Devices Double click Network Connections icon the following windows will appear Right click the Local Area Connection icon and then select Properties from the pop up menu 11 18 Revision October 2010 Network Connections File Edit View Favorites Tools Advanced Help sack eJ d Search Folders EHE Address Network Connections LAN or High Speed Internet Network Tasks Area Connection Create 4 Connected Disabl connection Change Windows Status Firewall settings Repair WM Disable this network
120. s E Control Panel File Edit View Favorites Tools Help Han 7 n 7 Search li Folders Address Control Panel 222 4 2 Ga v Control Panel Aij i 2 Accessibility Odd Hardware Add or Administrative Automatic BDE Date and Time Switch to Category View Options Remow Tools Updates Administrator Display Folder Options Fonts Sane Intel Internet keyboard Controllers Graphics Options See Also Windows LIpdabe Help and Support ge tss 2 e Network Phone and Power Options Printers and Regional and Connections Modem Faxes Language 9 g 9 Scanners and Scheduled Security Sounds and Speech System Taskbar and Cameras Tasks Center Audio Devices Start Menu User Accounts Windows Wireless Firewall Network Set Double click Network Connections icon the following windows will appear Right click the Local Area Connection icon and then select Properties from the pop up menu Revision October 2010 Ed eee ye Chapter 11 Recipe Access Example Network Connections File Edit View Favorites Tools Advanced Help sack eJ d Search Folders EHE Address r3 Network Connections Network Tasks Create new connection PRO Disable Change Windows Status Firewall settings Repair WM Disable this network 3 device Bridge Connections 9 Repair this connection Creare Shorkeuk mil
121. s assigned automatically if pour network supports this capability need to ask your network administrator the appropriate IP settings C3 Obtain an IP address automatically gt Use the following address IP address 2172 16 180 1 Subnet mask 255 258 g Default gateway 2 Use the following DNS server addresses Prefered ONS server Alternate DNS server Advanced Then press OK button to finish the settings Please note that if the IP address numbers of subnet masks of the PC and HMI are different HMI may not be displayed in the list when finding node 3 4 Revision October 2010 Ed c SOK Wait Chapter 3 Before Using eServer 3 2 2 Setting HMI Network Start Screen Editor software program and click Options gt Configuration Use Communication tab to select Ethernet and complete HMI networking settings shown as the figure below Then press OK button to finish the settings Configuration Standard Communication Print Default Others Add Recovery the IP address DHCP HMI eRemote com HMIIP Address 172 16 Subnet Mask 255 255 Base Port 3 COMI Default Gateway E oS Ethernet Then click Options Networking The following Remote Setting dialog box will appear Ch
122. ses by 3 Privileges phpliyAcmin Databases Database Collation Database E mysql utf8 general ci e Databases phpmyadmin uf bin yo Oi utf8_general_ci 8 Please select a database Total 3 utf8 general ci t CheckAIl Uncheck All With selected 2Enable Statistics new database test Collation Open new phpMyAdmin window 8 8 Revision October 2010 new database has been created 03 Server localhost gt Database test Structure 7501 A E 52 Operations 3 Privileges phplivAdmin 1 Database test has been created Database 4 SQL query test 0 v CREATE DATABASE test test 0 Edit Create PHP Code No tables found in database No tables found in database 19 Create new table on database test Number of fields B Create New Table Click on Structure link to create new table on database In this case the new table is named as tablel and the number of fields is set to 3 After Go button is pressed a new table on database will be created 4 Server localhost d Database test Fe structure 27 6 j Search fo fe E ta Imp Se Operations Privileges Ma tables found in database a Create new table on database test Name table1 Number of fields 3 Open new phphlyAdmin window Revision October 2010 8 9 Chapter 8 Writing Da
123. ta MySQL Ed yer Complete the settings by referring to the figure below and press Save button to save changes TA Server localhost Database test amp j Table table1 Field Type Length Values Collation Attributes Mull Time VARCHAR 50 I d notnul e pa vw v foma _ Data2 VARCHAR 50 WEIL Table comments Storage Engine Collation j OrAdd field s Go 1 if field type is enum or set please enter the values using this format a b c If you ever need to put a backslash ar a single quote amongst those values precede it with a backslash for 1 example xyz or For default values please enter just a single value without backslash escaping or quotes using this format a After the tablel has been created the screen will be shown as follows E Table table1 03 Server localhost Database test El Browse ES Structure 20501 j Search x Insert 82 Operations Drop 1 Table test tablet has been created SQL query CREATE TABLE tablet Time VARDAR 50 NOT HULL NOT NULL Data 50 NOT NULL ENGINE MYISAM Edit Greate PHP Cade Field Type Collation Attribut
124. ted in Windows Firewall dialog box it indicates that SQL Server port will not be blocked and the incoming connections to SQL Server will be allowed Revision October 2010 Windows Firewall General Exceptions Advanced Windows Firewall is blocking incoming network connections except for the programs and services selected below Adding exceptions allows some programs to Work better but might increase your security Fragrams and Services M File and Printer Sharing Network Diagnostics Far Windows P Remote Assistance Remote Desktop Windows Live Messenger 6 1 Windows Live Messenger 8 1 Phone Windows NetMeeting Add Fragram Add Port hates Display a notification when Windows Firewall blocks program What are the risks of allowing exceptions 7 3 20 ne 4 Activating SQL Server Double click the located at the bottom right of Windows screen to open the following SQL Server Service Manager dialog box and click Start Continue button 5i SQL Server Service Manager Server IDELTA SQL Name of SQL Server Services SQL Server zm b Start Continue T Pause m Stop M Auto start service when OS starts Running 4ABLI SHIRLE Y EN MSS LServer 5 Starting Microsoft Access Start Microsoft Access by clicking Start Programs Mi
125. ter Setting Please input logging address in the following Cell s TIT continue dick Next Revision October 2010 8 25 8 Set the sampling conditions to constant 5s Press Next button to continue Wizard Logging Logging Condition The Condition will provide 2 solutions to help you easy create parameters for Haw long would you like your logging data 500ms one day 9 Press gt icon After the password is entered the system will start sampling operation i e writing data in MySQL Server SE Se Set om passwords are the same password under No 1 8 26 Revision October 2010 Ed c SOK Wait Chapter 8 Writing Data in MySQL 10 If the users want to pause or stop the sampling operation only right click eServer WV icon at the bottom right of Windows screen and select Pause or Stop option from the pop up menu the sampling operation will pause and stop immediately Excel Visible pet 11 Open the browser type http localhost phpMyAdmin and select the test database from the Database drop down menu localhost ed Server version 5 0 51b community nt log phpM Protocol version 10 ea Server localhost via TCP IP fal User root localhost 2 Database 222 charset UTF 8 Unicode utf8 Databases 5 connection collation Databases _ unicode_
126. tomatically instal _ Uninstall 3 12 Revision October 2010 Ead eis err Vet Make Euutune Shortcut Chapter 3 Before Using eServer Runtime Shortcut Name eServer Runtime How to activate eServer There are two methods provided Make eServer software program run on Windows startup After starting up the system will activate eServer automatically Create a eServer sho ESEIVEI Install Uninstall Revision October 2010 7 Chapter 3 Before Using eServer EZ ciere This page intentionally left blank 3 14 Revision October 2010 Chapter 4 Excel Sampling Setting 41 Detailed Settings Please refer to the following steps to complete Excel sampling setting i e how to log data from HMI to Excel 4 1 1 Linkage Start eServer and click File gt New or click New icon After the New dialog box is opened select Logging Excel icon and press OK button Then the Excel Logging Wizard will be activated and the following dialog box will appear Press Next button to continue Wizard Logging Welcome to the Excel Logging Wizard This wizard helps you how to logging data from HMI to Excel Attenation The wizard program only support Excel 2000 2003 2007 and Excel 2010 The new version of Excel might be unstable The maximum of sheet in Excel only support 128 pages continue cick Next Click New icon to access nodes link to HMI Revision Octobe
127. when the other format is selected this fraction setting can be set Controller Connecting controller Unchangeable Fraction 6 1 4 Sampling Conditions This step is used to set the sampling conditions There are two kinds of options for selection 1 Const execute sampling repeatedly in a certain span of time This option is used to determine how long the sampling process is repeated The time unit can be defined as ms second minute or hour Wizard Logging Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition How long would you like on your logging data 500ms one day 9 Minute 5 2 Gerona A ms To continue dick Next 6 6 Revision October 2010 eserver Chapter 6 ODBC Sampling Setting 2 Trigger Execute sampling when the trigger conditions are satisfied This option is used to determine how long the sampling process is repeated when the trigger conditions are met The detailed settings are described as follows Wizard Logems Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition KIr Table 1 HMI Name Detail Format 30 0 Trigger Rising edge To continue click Next Polling Cycle Sampling Cycle It is used to determine how long the sampl
128. will appear Check the check box before Enable eServer Remote and set a password for network communication After OK button is pressed HMI networking is completed Compile the edited project file at the end of the programming and the edited project file could be transferred to HMI Romote Setting Enable eServer Remote 12345678 Password screen sample time in 3 Revision October 2010 8 21 Chapter 8 Writing Data MySQL 8 1 3 eServer Setting 1 After eServer is enabled eServer wv icon will appear at the bottom right of Windows screen Right click this icon and select Setting option from the pop up menu 5 2 Then open eServer window 2 eServer File View Wizad Tool Help 4 G mo 9 Project 22 eServer 3 Click File gt New or click icon to create a new project file Fle Vew Tool Help ibd 8 22 Revision October 2010 4 Select icon to enable ODBC Logging Wizard i Recipe Access Logging ODBC Logging Excel Location C Documents and Settings Tina Lee Desktop iol ae Add ta me current cres Wizard Logging Welcome to the ODBC Logging Wizard This wizard helps you how to logging data from HMI to Database To continue click Next Press Next button to go to next step
129. x will appear and ask the users to select the installation software i e DOP eServer Then click Install button to start DOP eServer installation DOP Setup Select Components E Main Program 5527 a Commoner ELTE Revision October 2010 2 3 Chapter 2 Software Installation EZ SOK Var Step 5 The system will start DOP eServer Installation DOP Setup Copying Files Extract ModbusRTLI HEX dli ston eat Cancel Completed 2 4 Revision October 2010 Chapter 3 Before Using eServer Before using eServer the users need to update HMI firmware and complete PC and HMI network settings Please ensure to read the following instructions fully so that the users could understand how to update HMI firmware and complete PC and HMI network settings correctly 3 1 Update Firmware Remember to update the firmware before using eServer To select this function click Start gt Programs gt Delta Industrial Automation gt HMI gt DOP eServer 1 00 0x gt Update Firmware Tool Screen Editor 2 00 20 DOP eRemote 1 00 04 Screen Editor 2 00 19 gt DOP eServer 1 0005 To eServer X Uninstall Wa Update Firmware Tool Fr DOP eRemote 1 00 05 eRemote 1 00 03 fan Delta Industrial Automation screen Editor 2 00 19 k

Chapter 2

Contents

Download Pdf Manuals

Related Search

Related Contents