Home

e-Server-User Manual(CURVE).cdr

1. S a Ee d e f g No og ia C o E Detain EE C E E A SA E T 2 C Import32 1 32bits HMI None 1 RCP O Revision July 2012 12 11 Chapter 12 Recipe Access Example eServer 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 Q Mode Setting Condition b HMI Name Format Controller Import1 1 Comst fa Ss Detect Scan Time How long would you like on your logging data SO0ms one day 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 172 16 190 100 are the same otherwise HMI may not be displayed in the list when finding node 12 12 Revision July 2012 EZ a Ser War Chapter 12 Recipe Access Example Networking Settings Ensure to observe the following instructions to complete PC networking settings before eServer operation Setting PC Network Programs Documents Control Panel eLtings Search Network Connections F rinters and Faxes Help and Support Ta askbar and Start Menu Run Windows XP Professional Shut Down Power on PC and start Windows Click Start gt Programs point to Control Panel and then Network select Network Connections annections E Control Panel File Edit wiew Favorites Tools
2. 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 July 2012 OOS at ae Kad aSer Ver Chapter 3 Before Using eServer 3 2 2 Setting HMI Network Start DOPSoft software program and click Options gt Communication Setting gt Ethernet gt LocalHost set HMI IP Address and check the Application eRemote eServer function Enable Communication Setting Communication Setting Device LocalHost SMTP Localhost fe Chrenanite IF Obtain an IF address automatically HMI HMI HMI IP Address subnet Wask Gateway IP uploadidowrdoad port Modbus TCP Server Port Application eRermote eserver Enable eh TE 12345678 acar Time 100 Part Comen Interrupt eo S times then ignore 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 Revision July 2012 3 5 Chapter 3 Before Using eServer eserver A MELTA 3 4 eServer Options Start eServer and click Tool gt Options to synchronize Time and Date settings and perform Disconnect function gt Fle View izard Make Rumntime hortcut Update Firmware ig eServer 3 4 1 Local Host When the type on Condition page is selected as Trigger it is necessary to set the PC Ethernet port number that
3. 1 When the register address is set to Bit this setting will be 1 one always 2 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 3 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 Revision July 2012 4 9 aserver i a 4 Excel Sampling Setting If the register address is set to Bit this integer setting cannot be set If the register address is set to Word except iteger Floating and Char Character when the other J format is selected this integer setting can be set When Read Count is 2 Format is floating it can be set Integer 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 When Read Count is 2 Format is floating it can be set Fraction Controller Connecting controller Unchangeable Fraction 4 10 Revision July 2012 eserver 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 t
4. 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 Revision July 2012 12 5 Chapter 12 Recipe Access Example eServer Controller Detect Scan Time How long would you like on your logging data SO0ms one day After completing all the settings on eServer use the most updated DOPSoft program editing software to open the selected dps 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 2 21 Kernel er R 2 74 Select RCPNO 1 Recipe Address 1 9 18 27 PLC TO HMI z 8 i6 2 Pe Css Ce HMI TO PLC PLC Address L E SSS Ee S After downloading the recipe data please make sure that the IP address numbers of subnet masks of the PC 172 16 190 1 and HMI 172 16 190 100 are the same otherwise HMI may not be displayed in the list when finding node 12 6 Revision July 2012 Networking Settings Ensure to observe the following instructions to complete PC networking settings before eServer operation Setting PC Network Programs Documents ettings Control Panel Network Connections Search Printers and Faxes Help and Support Taskb
5. Length defined file name Controller Connecting controller Unchangeable Destination location where the exported file is Auto Refresh on Startup function for user could Auto Refresh on select when execute recipe at first No matter what Startup the condition set to Trigger or Const if check auto refresh on start up function then eServer will execute Import or Export recipe at first time Revision July 2012 11 5 Jt at ee Chapter 11 Recipe Access Setting Mid a Ser Ver 11 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 second minute or hour Mode seting condition Type HWI Harme Detail Format Controller l ra Detect Scan Time How long would you like on your logging data 500ms one day Sihor 0 tinute FS Second 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 Mode Setting Condition Type HWI Hare Detal Format Controller Trigger Avil 0 0 Fusing edge Internal Ivlemory Export ot 1 Trigger Avil 0 2 Falling edge Internal Ivlemory Polling Cycle Sam
6. Network Connections Search ey Printers and Faxes Help and Support Taskbar and Start Menu RUM Shut Down Power on PC and start Windows Click Start gt Programs point to Control Panel and then select Network Connections Revision July 2012 A 5 Appendix A Upload Download via Ethernet Control Panel File Edit Tools Help Back view Favorites Pi AO Search Key Folders iia Address 6 amp Vg Control Panel a R Accessibility Add Hardware Add or gt Switch to Category View Options Remov See Also w o amp Administrative Automatic BDE Tools Updates Administrator l x Intel Internet Graphics Options ey Phone and Power Options Printers and Modem Faxes x p Speech System KR D GB Display Folder Options Fonts g Game Controllers b amp 4 windows Update Help and Support Sounds and Audio Devices Scheduled Tasks Scanners and Cameras User Accounts Windows Firewall Security Center _ eee Wireless Network Set A 6 E asSerya KEk G Control Panel bast 2 Date and Time Keyboard e Regional and Language Taskbar and Start Menu Revision July 2012 eServer Appendix A Upload Download via Ethernet 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
7. Revision July 2012 eserver Chapter 10 Writing Data in Oracle Oracle Database 10g Express Edition Install Wizard Summary Review settings before proceeding with the Installation GATE ADE CRP REE CNT Current Installation Settings Destination Folder C oraclexe Port for Oracle Database Listener 1521 Port for Oracle Services for Microsoft Transaction Server 2030 Fort for HTTP Listener 8080 The users can review the settings before proceeding with the Installation Click on Install button to installing Oracle Database 10g Oracle Database 10g Express Edition Install Wizard Setup Status CPATAB ASE RPE SS KHTI The InstallShieldA Wizard ts installing Oracle Database 10g Express Edition Copying Files The installation wizard is installing Oracle Database 10g Revision July 2012 10 5 Oracle Database 10g Express Edition Install Wizard InstallShield Wizard Complete Setup has finished installing Oracle Database 10g Express Edition on your computer ORACLE DATABASE EXPRESS EDITION Finish Click on Finish button to complete Oracle Database 10g setup 2 ODBC Setup In the Control Panel double click Administrative Tools E Control Panel Fie Edit View Favorites Tools Help a i Back FS P Search Wey Folders fides veg Control Panel x i q Accessibility Add Hardware G Switch ta Category View Options Updates Administrator
8. d Back Search progranu and files D Shut doam Enable the Named Pipes and TCP IP communication protocol Ale Action Vew Help ETEENI a 59L Server Configuration Maneqger Local S SOL Server 2005 Services di Sissi Server 2005 Weweork Se guration 3 Fratorcecl Mare Statues 2 Sharad Merri Enabled a Mamed n pes Enabled a CEIP S nabled Disabled BeF Frotocols tor MYSOLEKPRESS E 4 SO Matte Client Configuration 72 nik Revision July 2012 8 7 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Restart the instance of SQL server 8 8 Fle Action View Help e Ale lial Bl Owe A SOL Server Conf quration Manaqer iLocal B SOL Server 2005 Services il i SOL Server 2005 Newrork Configuration 3 a Frotocels tor SULERPRESS a Frotocols tor MY SULERPRESS gt 8 SO Native Cliant Contiguratinn 4 nik Name SSL Server Ersal SErvVEr State Ruming Runring Running FA aServ r Start Mrde Auboribekir Autometic Autometic Revision July 2012 ad aSer ver 3 Windows Firewall Setting Click Control Panel gt Windows Firewall then enter the Advanced Settings as p a waa t Contro Panel Al Control Panel tems t Winecows Firewall Control Panel Home Help protect your computer with Windows Firewall Alluw a predam i ealure Windows Firewal can hep prevent hackers or malicious software from caining access to your comput
9. A NELTA IABU Headquarters Delta Electronics Inc Taoyuan Technology Center No 18 Xinglong Rd Taoyuan City Taoyuan County 33068 Taiwan TEL 886 3 362 6301 FAX 886 3 371 6301 Asia Delta Electronics Jiangsu Ltd Wujiang Plant 3 1688 Jiangxing East Road Wujiang Economic Development Zone Wujiang City Jiang Su Province People s Republic of China Post code 215200 TEL 86 512 6340 3008 FAX 86 769 6340 7290 Delta Greentech China Co Ltd 238 Min Xia Road Pudong District ShangHai P R C Post code 201209 TEL 86 21 586356 78 FAX 86 21 58630003 Delta Electronics Japan Inc Tokyo Office 2 1 14 Minato ku Shibadaimon Tokyo 105 0012 Japan TEL 81 3 5733 1111 FAX 81 3 5733 1211 Delta Electronics Korea Inc 1511 Byucksan Digital Valley 6 cha Gasan dong Geumcheon gu Seoul Korea 153 704 TEL 82 2 515 5303 FAX 82 2 515 5302 Delta Electronics Int l S Pte Ltd 4 Kaki Bukit Ave 1 05 05 Singapore 417939 TEL 65 6747 5155 FAX 65 6744 9228 Delta Electronics India Pvt Ltd Plot No 43 Sector 35 HSIIDC Gurgaon PIN 122001 Haryana India TEL 91 124 4874900 FAX 91 124 4874945 Americas Delta Products Corporation USA Raleigh Office P O Box 12173 5101 Davis Drive Research Triangle Park NC 27709 U S A TEL 1 919 767 3800 FAX 1 919 767 8080 Delta Greentech Brasil S A Sao Paulo Office Rua Itapeva 26 3 andar Edificio Itapeva One Bela V
10. i e writing data in MySQL Server gt File View Wizard Tool Help me SI oF all passwords are the same password under No 1 10 If the users want to pause or stop the sampling operation only right click eServer Wy 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 d Pause top 11 Open the browser type http localhost phpMyAdmin and select the test database from the Database drop down menu 9 26 Revision July 2012 eserver Chapter 9 Writing Data in MySQL localhost ea Server version 5 0 51b community nt log ag H Protocol version 10 fa Server localhost via TCP IP t User root localhost Database fIMySQL charset UTF 8 Unicode utf8 Databases _ 2 MIMySQL connection collation Databases ee utf8_unico de ci mysql 17 phpmyadmin 7 Create new database test 1 Collation w Show MySQL runtime information Show MySQL system variables 12 Click on Structure link 4 Server localhost Database test Structure 7 Search 5 Operations Table Action Records Type Collation Size Overhead tablet Le iT A 0 MySAM utf8_general_ci 1 0 KiB 1 table s sum 0 MyISAM utf8 general_ci 1 0 KiB OB ts Gheck All Uncheck All With selected a Print view amp Data Dictiona
11. B 7 U Languaget Hrama a e a E e Eee Qanmagk gna amatas Hos HGH Qu FQ 2 1 Screen_l Property o x Screen _1 v o Screen_ O Screen Name Screen _1 4 Screen Properties Detail Background Color _JRGB 252 252 252 A Screen Macro Screen Open Macro 0 E Screen Close Macro 0 Screen Cycle Macro 2 Width 1024 Height 600 Output ox i Step Action an gt 1 Cut element gt J Paste element gt 3 Move element Record Ouput Hn eo eas EH He eo oe Download USB 798 185 DOP B10E615 65536 Colors Rotate 0 degree Use Screen Cycle Macro and enter the following commands in macro command window Revision July 2012 5 1 Chapter 5 Writing Data in Microsoft Excel eServer EE Screen 1 Screen Cycle Macro E mwa 8 B oe w Screen 1 Screen Cycle Wacro 153 3 1 S6 6 3 Click Options gt Communication Setting gt Ethernet gt LocalHost set HMI IP Address and check the Application eRemote eServer function Enable Then press OK button to finish the settings Communcaton Sethng Corinuncation Setting Device LocalHost SMTP Localhost Overwrite IP Obtain an IF address automatically HAI HAI HWI IF Address 172 subnet Wask aa Ethernet Gateway IP uploadidowndoad port NWodbus TCP Server Port Application eRermoteleserver Enable eh Password 12345678 ocan Time 100 Fort 12348 Comen Interrupt eS times then ignore 5 2 Revision July 2012 5 1 2 eServer Settin
12. Create three columns TIME DATA1 and DATA2 and select Type as CHAR Character Click on Next button for the next step DET create Tavie G JIT Table Name oracletable Preserve Case Table name must be specified Constraints Column Name Type Precision Scale Not Null Mowe Confimn O va w o v 100 O va Po Select Datatype va id z Po Select Datatype Fi Select No Primary Key Click on Next button for the next step Columns a _ Primary Key Cancel Previous Next gt Table name ORACLETABLE Primary Key No Primary Key Populated fram a new sequence Constraints Populated fram an existing sequence Not populated Confirm Click on Next button for the next step Columns soe neue E E Foreign Keys Cancel Previous Next gt See Foreign Key Columns Referenced Table Referenced Columns Action Constraints Add Foreign Key Add Confirm Disallow Delete Name ORACLETABLE_fk Cascade Delete Set Null on Delete Select Key Columns Key Column s References Table IN Revision July 2012 10 11 Chapter 10 Writing Data in Oracle eserver Click on Finish button to complete the settings Columns Constraint Name Type Column S Check Primary Key Add Constraint Add Confirm Check Unique Name OQRACLETABLE_ck1 Availiable Columns Example Check Constraints Click on Create button to create a new table
13. DOF ae PT fh MAaServ Table of Contents Chapter 9 Writing Data in MySQL 9 P EXON DIC ssensxestzacsensdvantieseienesancscnenescanienenesacesasaeanabeqsiooensaraseieniseuiasassameneiezeete 9 1 SLL lt SOPEWale IMSEAL AU OM ecsei tans ccs tians cicadas Rina cet Rinan cee acecee ace eaeaeniataten etnies 9 1 9 1 2 Create HMI Project Fil zccencsacasoneeasenonsnasagenetesesenansanneseresasaseracenexsaavisauasexetse 9 19 OS eSI VEr SN iraran aa aiarar 9 21 Chapter 10 Writing Data in Oracle TOST SE IMPE a a TTT 10 1 10 1 1 Software Installato Mesene eae E E A E E EEEE 10 1 TOL Crede HMI PrO ECE FIG pronare a A eautieiacbiasweeutias 10 13 TOES COV een 010 a N N N 10 15 Chapter 11 Recipe Access Setting di I Detaled eo o Ge e ne a ne ee ee er 11 1 LE Ll SINS PCY SU cpt sian casita eee EE AETERNA 11 1 a2 Register SeN sir cctrcictesienictscutenianiatacestetoniaituecucneatalenteadetes EEEE AR 11 4 Lel Sampling GON GUOWMS scossi naan APENES RAIAN APIP IAPA pE RAR EPE 11 6 Chapter 12 Recipe Access Example 121 Creating EXAMP ome a A ee re 12 1 12i NEW PPO CCU comi otaestechancumasanassmeanaa en daaianneaaaneneraamaeimasunecinenmmannaenidans 12 2 22 INO CLC aera oa eee tod ee toe eee toe eee poe ioe toe ee noe ee neces tee cent 12 4 12 1 3 Sern and Condition IMPO E aseinaan aN 12 5 12 1 4 Setting and Condition EXpOrt s ssessesserssrrerrrrsrrrerrrerrrerrrrerrrerrrerrrerre 12 19 Appendix A Upload Download via
14. Okhers Please specific the cell default value when the desired hmi is disabled Ho HWI Default Value l HMI This function only at Excel and ODBC logging and have to fill with default value when uncheck usage If use Recipe logging this function does not have to fill with default value so uncheck usage node at Recipe just means without connection Excel When user create multi nodes but it does not need to use one of them eServer provide function for user could select if execute node to logging data or not Revision July 2012 4 17 Chapter 4 Excel Sampling Setting Step1 Uncheck eServer node to logging eserver P cS Node setting Address Condition Output A Lt 4 No J Enable SHIM Name IP Port COMI L eServer 172 16 190 123 12348 nia B fA HmBoEs5 172 116 190 151 12348 Delta DVF PLC Step2 If uncheck usage each node it have to fill with some default numeric data at Output setting Users could fill with empty or some numeric like 222 gb eServer CADocuments and Settings tina q lee T Wak Bl eServereserver edx i File View Tool Help MAREA SSAA Project View q x Azok a F eServer 6 A Excel Wizard a Excels Type HWI Harme Detail Format Controller 1 Trigger HIW1 BOTES15 200 0 Falling edge Internal Memory CH es WE mere eServer node is logging data to Sheet 1 But O Hmi this node had uncheck to logging so if set a oe HMI B07E515 to trigger it it wi
15. 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 July 2012 7 1 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Bi eserv r 2 Enabling MSDE Execute SVRNETCN exe D within C Program Files Microsoft SQL Server 80 Tools Binn subdirectory and enable Named Pipes and TCP IP options SQL Server Network Utility General Network Libraries Instance s on this server IABU SHIRLEY EM Y Disabled protocols Enabled protocols Named Pipes TCP IPF Enable gt gt Banyan Wines lt lt Disable Force protocol encryption Enable winSock proxy OK Cancel Apply Help 3 Setting Windows Firewall e 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 is blocking incoming network connections except for the programe and services selected below Adding exceptions allows some programs to work better but might increase your security risk Programs and Services Name File and Printer Sharing Netwo
16. 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 HMI Name Name of connecting HMI en Revision July 2012 6 9 This page intentionally left blank 6 10 Revision July 2012 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Before creating testing example make sure to change the upload and download option Options gt Environment on DOPSoft 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 software MSDE from the Microsoft web site To download it go to http www microsoft com downloads details aspx familyid 413744d1 aObc 479f bafa e4b278eb9147 amp displaylang zh tw filelist 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
17. Table tablei table Time and Date Table Feld Detail Stamp table Time rmdir nH ral To continue click Mext ODBC Data Source Name of ODBC Data Source Select wanted connection Database Driver Database like MySQL SQL Server and Oracle Name of Sampling Data Table 6 4 Revision July 2012 eServer Chapter 6 ODBC Sampling Setting ODBC sampling setting provide refreshica button This function could help user to select the table after press this refresh button in Wizard setting a e xo Node setting Address Condition Output Chooses a data source DSW and input user name and password Database Driver My SOL w Table Time and Date Table Field Detail S00 Time and Data Stamp Function 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 String Format Representation Revision July 2012 6 5 6 1 3 Register Setting This step is used to set the register address of the sampling data Wizard Logring Register Setting lt To continue dick Next setting tem Description 2 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 1 When the register address is set to Bit this data format setting will b
18. Use the following IF address IF address Tf2 16 190 1 Subnet mask 255 255 2755 Q Default gateway Obtain OAS setver address automatically Use the following DNS server addresses Preferred 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 100 Please see the figure below DUP B e System Setting e OFF 172 16 190 100 AH 255255 0 0 0 0 0 OB 00 00 00 00 00 Revision July 2012 12 15 After completing all the settings and make sure that the communication is good use the most updated DOPSoft program editing software to open the selected dps file which just has been modified on eServer Create a character input element and set its address to 100 m 1 creen 1 Jog la Select RCPNO HEE Buffer 1234 234 224 100 SOR CIR AOI AGK gt a HMI TO PLO Then compile it and download the recipe data to HMI After recipe data is downloaded to HMI successfully please trigger the character input element on HMI and enter TINA these four characters at first then return to eServer save the file first and then run the recipe data Wizard 30l Help 12 16 Revision July 2012 DOr ENAN an Press L icon The following dialog box will pop up and ask the users to enter the password all passwords are the
19. cccccececeecececeeeseeseaeaeeeeseseeaeaeeneataesteneananenes 1 1 l2 SUDDOTEEG MOG EI S wrcsenuscysscrsisdarcanscesndanaesieniieeese EE 1 2 ES System REGUINCIMGME aeee iriiri ririri l 2 Chapter 2 Software Installation ZN eServer SEUD ase E EEEN 2 1 2l SOFLWAFE NStallatiON rrenan aa erara idrara 2 1 Chapter 3 Before Using eServer ZL UAIS call wa re On a a T T A 3 1 22 NGCUWOV KINO SEINO S icieccatessecte sstaiciscis E E EA AAA EN 3 2 SZ CNO PE NGWO K oiee nE a a eau a N N E 3 2 322 CNO AMENETWOI K aranana a asta emebes 3 5 So mes iE e A S Cet ee E E E E E ee T eer rr te 3 5 234 CCNV ODUONS cara a a a nciaabaieueenendorserireds 3 6 gA SVyOCArONZE FUNCIO sia nsssteniersnpnatantaviaineidaelantdcudmailla eatin uatleudiatedlaetdnucdeastdatatlstlaeausn 3 6 34 2 Disconnect FUNCION vr ucencaceutencaceutedvatetacedeadecedisuatedateretedatcietedaitietedetcisteves 3 8 Deo LOGal THOSE eee a a a T 3 10 3 4 4 Environment Language Setting ccccccceeececeeeeeseeeeaeseeeeaeseeseaesneatarsneatas 3 10 3 5 Make Runtime SdORCUL nuit eee ie iinet iain 3 12 Chapter 4 Excel Sampling Setting Al Detaled Settihg ana rn na oT 4 1 A Ni KAKI E crearanse a a alnle ieateuieiat eno eiete nate una SENEN 4 1 4 1 2 Excel Template Sheet Design cccccccecececeeeeeeeeeeeeeeeeeeeaeseeneanaeeneananenes 4 4 Revision July 2012 i OO ea 4 aa 4 1 3 Excel Logging Range Setting ccccccsesceceeeeeeeeeeseeeeaeseeeeaesteaegesteanstsnen
20. 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 Logring Logging Condition The Condition will provide 2 solutions to help you easy create parameters For trigger condition RR Type HWI Marne Detail Format Detect Scan Time How long would yau like on Your logging data SO0ms one day o tHour O Minute Second 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 6 8 Revision July 2012 Wizard Logring Logging Condition The Condition will provide 2 solutions to help you easy create parameters For trigger condition BR tablel Type HWI Marne Detail Format Trigger HMI 0 0 Rising edge To continue click Mex Polling Cycle Sampling Cycle It is used to determine how long the sampling process is repeated The time unit is ms Logging Condition Setting item Description Remark O No Condition number Unchangeable 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
21. s Network Connections File Edit View Favorites Tools Advanced Help Back k J pe Search Wa Folders mi Address Network Connections LAN or High Speed Internet Seni sec A RET A ERI Network Tasks ca Create a new a Meee connection meee Disable Change Windows Status Firewall settings Repair wt Disable this network i ee device Bridge Connections a Repair this connection mi Rename this connection View status of this Rename connection Change settings of this scale connection Create Shortcut 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 Authentication Advanced Connect using Eg Intel R PR01000 MT Network Con This connection uses the following thems E Clent for Microsoft Networks zi File and Printer Sharing for Microsott Networks fi o05 Packet Scheduler Internet Protacal TCFIF install ee LE Description Transmission Control Protocol lnternet Protocol The default wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected Notify me when this conmection has limited or no connectivity ok treet Revision July 2012 A 7 Appendix A Upload Download via Ethernet E aServer The Internet Protocol TCP IP Properti
22. 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 Logring 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 To continue cick Next Click New icon to access nodes link to HMI Revision July 2012 4 1 Chapter 4 Excel Sampling Setting Wizard Logring Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Lneige name Please click the following buttons to access nodes i M g Pa eSeryo Freee To continue click Next Click 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 a exist Screen DOP file from stroed media CAD acuments and Sethngs shirley lanky Documents Dema C IPA
23. 12 If the users want to pause or stop the sampling operation only right click eServer Mw 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 Pause stop Excel isible 5 12 Revision July 2012 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 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 Logrimg Welcome to the ODBC Logging Wizard This Wizard helps you how to logging data From HMI to Database To continue click Mext Click New icon to access nodes link to HMI Revision July 2012 6 1 Chapter 6 ODBC Sampling Setting eserver Wizard Logging us 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 bo access nodes Elk H To continue click Mex Click ki icon to link HMI scree
24. 51a gt Used PHP extensions mysql Language B English wj Theme Style Original v gt Font size 100 v phpMyAdmin documentation phpMyAdmin wiki Official phpMyAdmin Homepage gt ChangeLog Subversion Lists phpMyAdmin Done Revision July 2012 Local intranet 100 9 7 A Create New Database Click on Databases link localhost phpMyAdmin 2 10 3 F fd Server version 5 0 51b community nt log gt MySQL client version 5 0 51a phpisyAdmin gt Protocol version 10 gt Used PHP extensions mysql 9 Server localhost via TCP IP S Language O English b AHA yai SS SS ee User root localhost Theme Style Original v ti H Database MySQL charset UTF 8 Unicode utf8 b Beg toe 100 w Databases MySQL connection collation Bi cnoayadiwn docunentation Fe utf8_unicode_ci v Bacay in wiki Please select a database Create new database Pera We Official phpMyAdmin Homepage gt ChangeLog Subversion Lists Collation geLog Lists Show MySQL runtime information Show MySQL system variables sProcesses Character Sets and Collations kJ Storage Engines I gt Reload privileges Privileges amp Export almport ElLog 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 3 Server local
25. 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 Warning This server is requesting that your username and password be sent in an insecure manner basic authentication without a secure connection root we Remember my password User name Password Then it will connect to MySQL database localhost localhost phpMyAdmin 2 10 3 Windows Internet Explorer a 4 Al gt xX s c p File Edit View Favorites Tools Help X z e w i ai localhost localhost phpMyAdmin 2 10 3 ai B mn v Page iG Tools PMA localhost phpMyAdmin 2 10 3 php yAdmin Database l Databases __ v Please select a database Server version 5 0 51b community nt log gt Protocol version 10 3 Server localhost via TCP IP gt User root localhost MySQL charset UTF 8 Unicode utf8 2MySQL connection collation utf8_unicode_ci v Create new database Collation v Show MySQL runtime information E Show MySQL system variables Processes Character Sets and Collations Storage Engines I gt Reload privileges Privileges Databases Export Elmport EXLog out gt MySQL client version 5 0
26. IINA Q LEE DELTA 000A fitexample dps File Edit View Element Screen Tools Options Window Help EBB AC xa BCA BS Alm VAATE ACA ALL A AAJA BTU Languaget v Fai E E an E a E a Qanman GNAM amatas Oos JALA Fae i Propert ox 1 Screen_1 SEE eS LN Screcr_ v m A Screen Name Screen 1 Screen Properties Detail A Background Color _JRGB 252 252 252 TR Screen Macro E 3 HHH Screen Open Mal 0 Screen Close Macro 0 Screen Cycle Macro 2 Width 1024 Height 600 6 Hee i 0 0 Momentary 0 2 Moment Output Step Action 11 Modify element property gt iJ Modify element property 13 Modify element property 1 Modify element property Record Ouput NE haga e a FF ih EHH Ft eis Download USB 893 173 DOP B10E615 65536 Colors Rotate 0 degree Use Screen Cycle Macro and enter the following commands in macro command window MS Screen 1 Screen Cycle Macro CS GK GB E gi ae seeen Screen Cycle Macro 153 3 1 S6 6 3 Revision July 2012 10 13 ao SS am Or al Chapter 10 Writing Data in Oracle Ed SOK Var Click Options gt Communication Setting gt Ethernet gt LocalHost set HMI IP Address and check the Application eRemote eServer function Enable Then press OK button to finish the settings Communcaton Sethng Communication Setting Device LocalHost SMTF Localhost fe Chrenaite IF Obtain an IF addr
27. Instellao27 path c agrom Alles 236 Miagesof SSL Server Tou can isal a default instance or you can zpedfy a meamed Peslarive Provide a name tor tie instance For a dakault inetalaton d Deteult metence acd dick Next To upgrade cr existing default instanec dick Ccfautingteree Te upgrade a7 cxisting named insterce select Natec iskane sod spedfy the instance nate D De feud esbance Hamed insterue i EQLExpress k Ta wlew A lst of ecg instences and comnnnents cick an Tistaled mscances gt Revision July 2012 8 3 Choose the authentication mode Set as below figure and click Next The authentication mode soedfies the acari uscd when oonnectng to O server Select the authentication moce to use for this inecellaticn Wincows Authentication Mod D Viwed Mode Windows Authestication and SOI Server Authentcation pedaf the sa logon password haley Enter password Confirm password Contiguration Options Configure uscr anc administator accounts Snable User Instance This opton enabler usec without admiverator oerriesons bo run a ceparate instance othe OO Server Pepress Datahare Fogine Add aacr to the SQL Server Adrinistrator role This apton adds the uscr who is runrirg the SQL Scorve Exprzas instalation program to the SOL Server Sweter Admrietrater role By default were on Micraec Wirdaws tnta ONeArat Svstenm are nctmerchers of the SO Server System Admioe tater cole 8 4 R
28. Liinakge name Please click 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 7 16 Revision July 2012 Eli Ser Ver Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Transfer Path Please select the Following 2 methods to 1 Select a exist Screen DOP file From stroed media oo 0 1 zoe E After searching HMI IP in Ethernet select HMI Name is HMI IP is 172 16 190 100 press OK IF Address Setup Search IP in Ethernet HMI Mame HMI Model HMI DOP B10E615 lz 16 190 100 2348 eServer will ask user to input the authorize password to connected with HMI The default password is 12345678 Upload Authorize Press OK button to go to next step 6 ODBC Data Source Setting Create an ODBC Data Source pointing to your database Please refer to the following settings and press refresh button to select table Revision July 2012 7 17 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Ria eServet Wizard Logging ODBC e Please indicate the Following items Chooses 4 data source DSN and input user name and password ODBC Data Source User Mame Password Database Driver Table Time and Date Table Field tarip Tablel Time vottl foley H ral To continue click Next Press Next button to go to
29. New Data Source to SOL Server Use strong encryption for data i Perform translation for character data E Use regional settings when outputting currency numbers dates and timez M Save long running queries to the log file CAROCHME 1 shiley lan LOCALS 17 emp Que Long query time milliseconds eo qr Log ODBC driver statistics to the log file E COCUME1 shiley la LOCALS 7 Temps TAT Browse lt Back Cancel Help Revision July 2012 7 11 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7 12 eServer Press OK button to complete ODBC setup ODBC Microsoft SOL Server Setup A new ODBC data source will be created with the following configuration Microsoft SOL Server ODBC Driver Version 03 85 1117 Data Source Name TEST Data Source Description Server LABL SHIRLEY EM Database master Language Default Translate Character Data Yes Log Long Running Queries Mo Log Driver Statistics No Use Integrated Securty No Use Regional Settings Mo Prepared Statements Option Drop temporary procedures on disconnect Use Falloyver Server No Use ANSI Quoted Identitters Yes Use ANSI Null Paddings and Warmings Yes Data Encryption No cance Revision July 2012 Riad Ser Vet Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7 1 2 Create HMI Project File Start DOPSoft software program and click File gt New or click New icon to create a new pro
30. O shorts eServer Lai rver immediately La HMI Password l Install runtime shortcut success l ODECI 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 Revision July 2012 3 13 Chapter 3 Before Using eServer Make Runtime Shortcut Runtime Shorkcuk Mame DOP eServer Runtime How to activate eServer There are two methods provided O Make eServer software program run on Windows startup After starting up the swstem will activate eServer automatically Install Uninstall 3 14 Revision July 2012 EZ aSservyar Chapter 3 Before Using eServer Make Runtime Shortcut Runtime Shorkcuk Mame DOP eServer Runtime How to activate eServer There are two methods provided O Make eServer software program run on Windows startup After starting up the swstem will activate eServer automatically Create 4 256 eServer sho HMI Password ODECI Install Uninstall Revision July 2012 3 15 E k Eia zg Chapter 3 Before Using eServer eV ver This page intentionally left blank 3 16 Revision July 2012 Chapter 4 Excel Sampling Setting 4 1 Detailed Settings Please refer to the following steps to complete Excel sampling setting i e how to log data from HMI to Excel 4
31. Press Next button to go to next step Revision July 2012 eServer 4 1 3 Excel Logging Range Setting Chapter 4 Excel Sampling 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 Loggmg Excel Logging Range Please select range that you want to logging Multi Vertical Multi Horizontal Single Vertical Single Horizontal Anywhere then decided the range f ears Me eh P ret E3 Adi Adv Ad3 You could be dicked the right button to execute Excel and Selection Range Al jf Al Stamp Time and Date Tpye De m fat To continue dick 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 sampling 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 Revision July 2012 4 5 Chapter 4 Excel Sampling Setting eServer Multi Horizontal When this option is selected multiple numbers of different register data could be logged into each horizontal row
32. Then press Close button to finish Ee E Microsoft Excel Tem461 C3 1 4 Pu 3 om m ET gt gt Data Average DIV 0 DIVI0 DIVI0 DIV0 DIV 0 DIVI0 DIV 0 DIV O DIV 0 DIV O DIVID DIV O DIV 0 DIVI0 DIVI0 DIVV0 DIVI0 DIVJ0 Yorn Sods oy YH YM S DATA 1 DATA 2 _ E es SFE ee aaa a _ rr E S ee _ ee eras U ns E eee a See a es ee ee ff eee SSE as aa Please decide the selection range and then click the close button Selection C3 D20 3A M 4 gt ah Sheet lt gt Ready NUM SCRL 7 4 Check the check box before Enable Stamp Time and Date function and change the format to Yam d Yey HAMS 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 Somi ed sey SH YM 35 8 Set the register addresses Wizard Lozping Register Setting Please input logging address in the following Cellia To continue dick Next Revision July 2012 5 9 Use the following dialog box to set the sampling register addresses Type PLO Device Word PLO Device Pit Internal Ivlemory i Word C Internal Memory Bit PLC Station Humber Default 9 Set Logging Condition Sampling Time to 5s Wizard Logging Logging Condition The Condition w
33. UVEC bate Soul ce Admir User 00 Jser Dzta Sources Tnver J3A5E Fles Microsoft Access dBASE Diver Co ndg Cece ies Microsch Cecel Drwsr ods dax alsm x WS Access Database Microscft Access Diver 0 mdb accdg An ODBC Leer cate eource doree idotmation about haw te sonrecd to the indicated data prowicer A User data source s ony weble to you and can anb 2e usec on the cument machine select a diver for which you want to setup a data source Version Company 00 6000 16356 Microsoft Corpora m E Revision July 2012 8 19 Input the name of ODBC and select connecting SQL Server Ths wizard wil ha wou cresre ar ODSC dala sourc thet you car use to comment ww SQL Server What name do you want te use to rote to the data source Hame c ewe how da you wont ia describe the data source Deectiction Which SQ Sewer do vouwart ta connect ta Server ala aiia a n ee a a e RCARRIL_O LTIPSMYsQ_EXPRESS RCARRIL_O LTP SQLEXPRESS Choose the authentication method show as below figure and click Next How shoule SOL Serve verify tre suthenticity cf ihe login ID Wilh Windows NT authectication usina the netewerk bagin IN Wih SQL Server autenticaton using a login 1D and password entered hy the wiser To change the network library used tc communicate witi SUL Server cick Cent Cerricuration Connecd ta SO Sere
34. X PARER BEEE A E E E O Arial 710 7 B Z UE 2S 2 8 Se FF aA Snagit pj window x A is lt E3 X amp AVERAGE C3 D3 LF A ea L ee a Enka g m i ae DATA 1 DATA 2 Data Average Amid hy WHAM S o o DIV 0 a QO 7 2 Ooo eS v E pI DS a E D Ooo v Ooo o S e D ypy j a o e ke ee Ooo o S e w E Ooo o S e D IV Ooo o S e D E Ooo o S e Dv C a a ee ee C a a aa ooo ko y AA a a WOO wW NINININI INI ROP ROP N NIN gt gt gt gt gt gt gt J ml Mi 0 0 0 wi 0m0 l ul Nn Sm CO OO So oo l S J Please layout excel and then click close button to nest step EGS F P E L w M 4 gt mN Sheet1 Sheet2 Sheet3 I lt gt Ready NUM SCRL 7 Excel Logging Range Setting 7 1 Set the sampling direction as Multi Vertical Sheetl Multi Vertical a a ee Multi Horizontal Single Vertical Single Horizontal Anywhere 7 2 Press Excel button and the system will open the editing Excel template sheet immediately 4 WwW You could be clicked the right button to execute Excel and then decided the range Selection Range 5 8 Revision July 2012 eserver 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
35. a mt 2 1 Screen_1 pioperty x a Screen_1 v E O Screen Name Screen _1 4 Screen Properties Detail Background Color _JRGB 252 252 252 A Screen Macro ui Screen Open Macro 0 gE Screen Close Macro 0 Screen Cycle Macro 2 Width 1024 Height 600 Output ox Step Action gt 1 Cut element J Paste element gt 3 Move elernent Record Ouput HM eo ears EH He eo oe Download USB 798 185 DOP B10E615 65536 Colors Rotate 0 degree Use Screen Cycle Macro and enter the following commands in macro command window MS Screen 1 Screen Cycle Macro SS tel A lS E Bi a A Screen 1 Screen Cycle Macro 153 3 1 S6 6 3 Click Options gt Communication Setting gt Ethernet gt LocalHost set HMI IP Address and check the Application eRemote eServer function Enable Then press OK button to finish the settings Revision July 2012 9 19 Chapter 9 Writing Data in MySQL Communmcaton Sethng Coronurication Setting Device SMTP Localhost EE Chrenatite IF Obtain an IP address automatically HII HWI IP Address subnet Wask Ethernet Gateway IP uploadidowrdoad port Modbus TCP Server Port Application eRemoteleserver Enable eh Password Scan Tire Fort _ Corm Interrupt times then ignore 9 20 HKI Via 12345678 100 12348 E asSerya Revision July 2012 9 1 3 eServer Setting 1 After eServer is st
36. network device Bridge Connections amp Repair this connection Create Shortcut mij Rename this connection Delete view status of this Rename connection Change settings of this connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then press Properties button Revision July 2012 12 21 Chapter 12 Recipe Access Example eServer Local Area Connection Properties We TSE 2 2 General Authentication Advanced _ Connect using This connection uses the following items cy File and Printer Sharing for Microsoft Networks i as Packet Scheduler Install Uninstall Properties Description Transmission Control Protocol Internet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected Notify me when this connection has limited of no connectivity I ox tenes 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 Ed General ou can get F settings assigned automatically if your network supports this capabi
37. 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 en 4 1 6 Output Setting This step is used to set how to output and save the sampling data 4 12 0 Revision July 2012 eServer Chapter 4 Excel Sampling Setting Wizard Logging Dutput Setting Ecxel Sheet O Add a new file Add a new sheet Mutpuek ll ht Cl Location C Program Files Delta Industrial Automati a 3 E Report File Mame Data _ voH vol a d Period p Auto Save How long would you like to save your logging data o S ay o 2 Hour 30 Minute click Finish There are two parts in this dialog box 1 Excel Sheet A Repeat 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 EJ Microsoft Excel Tem2E1 G10 7 f 18 18 18 18 18 a J a ig 18 18 18 18 18 18 18 18 32721 08 24 2009 17 18 33 B Add anew 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 Revision July 2012 4 13 C Add anew sheet When the sampling data has been filled in the selection range to the full
38. same password under Mo 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 password Is entered the lll icon will display on the tool bar at the left bottom corner When eServer performs reading due to enable auto refresh on startup it will auto import recipe to destination path but if disable enable auto refresh on startup please trigger the character input element on HMI and enter TINA these four characters then wait for 5 second to import recipe to destination path Please refer to the figure below E Delta Soft Simulator 2 19 Kernel Yer R 2 73 mE Revision July 2012 12 17 Chapter 12 Recipe Access Example eserver 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 eServer x Password input fail all passwords are the same password under Mo 1 12 18 Revision July 2012 DOF p D an i ma 12 1 4 Setting and Condition Export Export Fixed Setting a Press to add file name as 0223 rcp of export file b Select Fixed c Check the check box to use 16 bit recipe as the example d Set Destination Path destination location wh
39. specified as localhost directly Click on Next button for MySQL Server Configuration settings 9 4 Revision July 2012 ok AppServ 2 5 10 Setup Eak AS MySQL Server Configuration Mi T S Q Configure the MySOL Server instance Please enter Root password for MySQL Server Enter root password i Re enter root password e er sy MySQL Server Setting Character Sets and Collatians UTF 6 Unicode w Old Password Support PHP MySQL API Function Enable InnoDB 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 AppServ 2 5 10 Setup Installing Please wait while AppServ 2 5 10 is being installed Installing 4pache Service Show details Revision July 2012 9 5 Click on Finish button to complete AppServ setup AppServ 2 5 10 Setup Completing the Appsery 2 5 10 Setup Wizard Soper 2 5 10 has been installed on your computer Click Finish to close this wizard Start Apache Start MySQL ois After installing AppServ please restart the computer After restart computer users can v
40. the system will open a new Excel sheet automatically and write the data into the new Excel sheet Ecxel Sheet Repeat Add a new file Add a new sheet 2 Output Setting Output File Pees C Documents and Settings TINA Q LEE DELT Report File Mame Data _SsHteMS o5 Auto Save amp Record d y Period i Fixed gt Auto Save How long would you like to save your logging data Day Hour Minute Overwrite the file when saving Auto Save when power off Follow the last stop logging position IF either of the above check boxes is checked the history records will be memorized You can press Clear History Record the right button to clear the history records A Location Choose file destination location B 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 Mn yd Date Qe Revision July 2012 Year Hour C 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 Auto save function include Period and Fixed Period is correspo
41. the following dialog box will pop up and ask the users to enter the password all passwords are the same password under Mo 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 password Is entered the icon will display on the tool bar at the left bottom corner When eServer performs reading due to enable auto refresh on startup eServer will auto convert the recipe to Tina csv recipe value but if disable auto refresh on startup please trigger the character input element 100 and input TINA then trigger the maintained button element 0 0 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 Revision July 2012 12 33 1 Delta Soft Simulator 2 21 Kernel Fer R 2 74 eles Select RCPNO 2 Trigger Rising edge sim f 1 Input TINA first cress 1 PLC Address Delta Soft Simulator 2 21 Kernel Yer R 2 74 Recipe Address 1 PLC Address 12 34 Revision July 2012 On the other hand if incorrect or invalid password is entered the following error eServer X Password input fail all passwords are the same password under Mo 1 Revision July 2012 12 35 2 et A Chapter 12 Recipe Access Example Ea aSer Ve This page intentionally left blank 12 36 Revisi
42. you have connected The default setting is 12348 3 6 Revision July 2012 eeserver Chapter 3 Before Using eServer eServer Option Local Host Synchronize ie Communication When the type on Condition page is selected as Trigger it is necessary to set Disconnect fi the PC Ethernet pork number that you have connected i Environment Language Fort Murmber 12348 0 65535 Revision July 2012 3 7 Chapter 3 Before Using eServer 3 8 eserver 3 4 2 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 synchronized with the selected linkage eserver Option Local Host Synchronize Communication O Disconnect Synchronize Time and Date El Environment Timing Synchronize whe Synchronize whe Current Local Time Monday July 23 201 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 re
43. 0 DIVV0 DIV 0 DIV 0 DIV0 5 5 5 5 SERE DI0l pa a4 Please decide the selection range and then click the close button Selection C3 D20 3A 4 gt a Sheet lt gt 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 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 Revision July 2012 4 7 Chapter 4 Excel Sampling Setting eserver 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 Representation Mn When change time stamp to m d WH M S gt Excel will automatically transfer General type to Text type of Format Cells Therefore if set the value to 03 09 12 58 36 gt it will corresponding to 2011 3 9 12 58 36 If y
44. 0 100 press OK IF Address Setup IP Address Search IP in Ethernet HMI Mame HMI Model HMI DOP B10E615 lz 16 190 100 eServer will ask user to input the authorize password to connected with HMI The default password is 12345678 Upload Authorize 6 Design Excel template sheet Select Create a new Excel file option and press Next button to go to next step 5 6 Revision July 2012 eServer Chapter 5 Writing Data in Microsoft Excel Wizard Logeme Excel Template Designed Template Designed will provide a method to help you easy build a sheet in Excel Please select the following options to decide how to design a template Select a exist Excel file from stroed media EF To continue dick 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 E20 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 column AVERAGEICS 05 E6 AVERAGE C6 D6 E8 E9 AVERAGE C8 D8 AVERAGE C9 D9 AVERAGE C10 D10 AVERAGE C11 D11 E7 AVERAGE C7 D7 Revision July 2012 5 7 Chapter 5 Writing Data in Microsoft Excel Bid a Ser Ver EJ Microsoft Excel Book11 BE ea File Edit View Insert Format Tools Data Window Help Adobe PDF Type a question for help f
45. 36 Colors Rotate 0 degree Use Screen Cycle Macro and enter the following commands in macro command window E Clock Macro ls b amp El a a amp Clock Macro 15100 100 1 IF 100 1000 Sioo o EHD IF Click Options gt Communication Setting gt Ethernet gt LocalHost set HMI IP Address and check the Application eRemote eServer function Enable Then press OK button to finish Revision July 2012 8 23 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Ria eSer Vet the settings Communication Setting Corinuncation Setting Chrenatite IF Obtain an IP address automatically HWI HIvil HMII IP Address 172 16 190 110l subnet Wask Ethernet Gateway IP uploadidowrdoad port Modh TCP Server Port Application eRemoteleserver Enable eh Pee 12345678 ucar Time 100 a gt 3 Fort 4 Corm Interrupt times then ignore 8 1 3 eServer Setting Open a new Logging ODBC project file Wizard Tool Help Click New icon to access nodes link to HMI 8 24 Revision July 2012 Wizard Logging Ed 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 To continue dick Next Choose a HMI screen project file to link with this eServer project Wizard Logging Ed Linkage eServer will need some information such as commun
46. 4 Server localhost Variables Charsets Jj Engines SePrivileges Processes Asi Export A BE G B E F amp I td ELMAN EFE ERE a EU U WA T Showa User Host Password Global privileges Grant am USAGE No ae Any localhost Mo USAGE No oe Any production mysqlcom No USAGE No gy mo 127001 No ALL PRIVILEGES Yes a foot localhost Yes ALL PRIVILEGES Yes amp root production mysg cam No ALL PRIVILEGES Yes oe l Check All Uncheck All ek 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 July 2012 9 11 Login Information User name Use text field root Host Use text field Password Use text field ee nee apasal Generate Password Login Information User name Enter user name root Host Select Any host from the drop down menu and insert a code Password Enter the desired password Re type Re enter the desired password General Password m Click on Generate button to automatically generate a password m Click on Copy button to insert the password into the fields of Password and Re type Scroll the screen down and click on Check All link to select all privileges Then click on GO button to create a new user Global privileges Check All Uncheck All Note MySQL privilege names are exoressed in English Data Structure Admi
47. Access 2007 database i Please suedly the lunin ID and oassiard ul eri aual wth CREATE DATABASE privieges or this server Use Trusted Connection Logn ID Passveu u Winhatdo vou Want 0 name your Tew SQL Servar database Erish Revision July 2012 8 15 Choose the table exporting to SQL Server After choosing click gt Upsizing Wizard Who males do you Want 10 export bo SUL Server Availabe Tables Sclected Teble Tablici abeta Einish Setup the attributes of the transfering table and click Next lne Upsizing Wizard can xport table atribu n acdibon to daz What table attributes do you want to upsize Detaults W Tasle pelationships a UseDRI A Use triggers What data eotions da you want bo include 400 limestanp Pell la aales Mes lel wigere veike Only create tre table sfucture dan tupsze any det Hb ance Erish 8 16 Revision July 2012 Bal eSer Ver Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Setup the operation of the transfering database and click Next he Upszinc Wizard can modify the existng azpiata ar creat a new aoplicaton to work with the SOL Server databace What application changes do you want co make Create a new Access chent serve applicator ShsersVodrigo carlloeskina Database iCS ac
48. Columns Create Table Primary Key 7 Please confirm your request Foreign Key Schema SYSTEM Table name ORACLETABLE Constraints Confirm SQL When the following figure shows on the screen it indicates that a new table on Oracle database is created successfully ORACLETABLE Table Data Indexes Model Constraints Grants Statistics Ul Defaults Triggers Dependencies SQL AQS_INTERNET_AGENTS 5 Add Column Modify Column Rename Column Drop Column Rename Copy Drop Truncate Create Lookup Table eee eee Column Name Data Type Nullable Default Primary Key AQS QUEUES TIME CHAR 100 Yes AQS QUEUE TABLES zs AQS_SCHEDULES me k sities ia DEFS AQCALL i DATAZ CHAR 100 Yes DEFS_AQERROR 1 3 DEFS_CALLDEST DEFS_DEFAULTDEST DEFS_DESTINATION DEFS ERROR o DEF _LOB DEFS_ORIGIN DEFS_ PROPAGATOR DEFS PUSHED TRANSACTIONS DEFS_TEMPSLOB HELP POO NARA 11M WA x Lill 10 12 Revision July 2012 10 1 2 Create HMI Project File Start DOPSoft 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 Momentary to create two maintained button elements 0 0 and 0 2 on the screen In this case 10 inches color Bl1OE615 type DOP series HMI is used E DOPSoft C Documents and Settings
49. Data Sources Name Driver Configure 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 on this machine including NT services OF Cancel Apply Help Select SQL Server and then click on Finish button Create New Data Source Name Microsol FoxPro YFP Orrver db Microsol ODBC for Oracle Microgott Paradox Driver db Microgott Paradox Treiber db Microgott Text Driver tek cev Microsott Text Treiber tet csy Microsoft Visual FoxPro Driver osFro T reber hMi b b b P M reich ea Revision July 2012 7 9 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Bia eSer Ver In the Create a New Data Source to SQL Server dialog box do the following Enter the name of the data source and select the SQL Server that the users want to access Create a New Data Source to SOL Server This wizard will help you create an ODBC data source that you can use to connect to SQL Server What name do vou want to use to refer to the data source Name TEST How do vou want to describe the data source Descriptions Which SQL Server do you want to connect to Server DELTA SGL Nest Cancel Help Press Next button to continue Choose how SQL Server should verify t
50. Ethernet AT Environment SUE I Chests ate aac eee a a a a OA A 1 A2 COMMUNICATION SERINO askre A 3 A 3 Compile and Upload Download All Data snsesnnennresnrnsrrrsrrrerrresrrnerererrnee A 9 Revision July 2012 iii Table of Contents About this Manual User Information Be sure to store this manual in a safe place a e a EP y aig EZ 28C val 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 TAOQYUAN 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 I
51. For you to define relationships between this table and other tables in the database Do you want to return to table design and add a primary key now 6 ODBC Setup In the Control Panel double click Administrative Tools E Control Panel Fie Edit View Favorites Tools Help ae r wi a Search Ij Folders F3 i A ape i CACK es x EE co t F iV Control Panel R D Accessibility Odd Hardware Add or Automatic BDE Date ani Time g Switch to Category view Options Remo Updates Administrator KR E B P S Display Folder Options Fonts Game Intel Internet Keyboard Controllers Graphics Options See Also D Windows Update In the Administrative Tools double click Data Sources ODBC H Administrative Tools File Edit View Favorites Tools Help a O Back J a pe Search Wee Folders Hee Address 4 Administrative Tools gt 5 Computer Management _ Shortcut 2 KB File and Folder Tasks Lo Share this folder Event viewer Shortcut Other Places lt b g Control Panel Local Security Policy EA Performance p Shortcut A Shortcut G My Documents 2 KB 2 EB flo anc kar 7 8 Revision July 2012 In the ODBC Data Source Administrator dialog box select System DSN tab and click on Add button to add system data source ODBC Data Source Administrator User DSN system DSN File DSN Drivers Tracing Connection Pooling About Sistem
52. GE installer Language x l J Please select a language A 7 OK Cancel 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 i Fair L i T z wh 7 k a C DOP Setup Select Installation Folder F Choose Install Location Choose the Folder in which ta install DOF Setup will install eServer in the Following Folder To installin a different Folder click Browse and select another Folder Click Next to continue Browse Space available 1 566 Space required 19 7MB 2 2 Revision July 2012 To select the default directory C Program Files Delta Industrial Automation DOP eServer 1 00 xx 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 one by one Step 4 After pressing Next the following dialog box 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 Mai
53. Help Back pi Fa Search Wee Folders Address Vg Control Panel Accessibility Odd Hardware Administrative Automatic BDE Date and Time g Switch bo Category View Options ban Tools Updates Administrator See Also a A N F T Display Folder Options Game Intel Internet keyboard h Windows Update Controllers Graphics Options o Help and Support gs Fi i m gt b aa e Network Phone and Power Options Printers and Regional and Connections Modem Faxes Language 3 B oe P Scanners and Scheduled Security Sounds and Speech System Taskbar and Cameras Tasks Center Audio Devices Stark Menu 2 e a 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 July 2012 12 13 Chapter 12 Recipe Access Example Network Connections File Edit View Favorites Address sy Network Connections ah Network Tasks A Create a nev connection Change Windows Firewall settings aj Disable this network device a Repair this connection mj Rename this connection view status of this connection Change settings of this Tools ack k ag pi Advanced Help Search Wee Folders Ei E asSerya EEE a wt EJ co _ LAN or High Speed Internet wr ocal Grea Connection an ected B i le a sonnected Disab
54. Language os Synchronize SS e Communication a Disconnect iJ F Environment Revision July 2012 3 11 AO i am Or Sal Chapter 3 Before Using eServer Kad a Server 3 5 Make Runtime Shortcut Start eServer and click Tool gt Make Runtime Shortcut to create a eServer shortcut and activate eServer quickly q eserver CADocuments and pettiness TIN AO LEE DELT a il eServer There are two methods provided for making Runtime Shortcut Please refer to the figure below Make Runtime Shortcut Funtime Shorkcuk Mame 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 O Create a eServer shortcut on desktop After starting up double clicking the eServer shortcut on desktop and the system will activate eServer immediately HMI Password No __ Linkage HMI Password l IDB PServer PEG SEE Install Uninstall 3 12 Revision July 2012 eserver Chapter 3 Before Using eServer When selecting the desired method press Install button to finish the settings Make Runtime Shortcut Runtime Shorkcuk Mame DOP eServer Runtime How to activate eServer There are two methods provided O Make eServer software program run on Windows startup After starting up the swstem will activate eServer automatically Create a ecer wee eble clicking the
55. NC 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 NETHERLANDS B V Sales Office DE WITBOGT 15 5652 AG EINDHOVEN THE NETHERLANDS TEL 31 40 259 2860 FAX 31 40 259 2851 Revision July 2012 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 aL ILE see Ethernet Device data po aa D1 95 p2 23 D3 90 Revision July 2012 Chapter 1 Introduction eve Ver 1 2 Supported Models The supported models for eServer Data Collection Software are listed in the table below DOP AE57BSTD DOP AES7GSTD AE57GSTD DOP series Extension Ethernet ee Meat DOP EXLNHJ1AE is DOP AE Series DOP AE57CSTD AE57CSTD required when using eServer with DOP AE seri
56. Properties Authentication Advanced Connect using Eg Intel R PR01000 MT Network Con This connection uses the following thems E Clent for Microsoft Networks zi File and Printer Sharing for Microsott Networks fi o05 Packet Scheduler Internet Protacal TCFIF install ee LE Description Transmission Control Protocol lnternet Protocol The default wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected Notify me when this conmection has limited or no connectivity ok treet Revision July 2012 3 3 DOr Fe 4t aa Chapter 3 Before Using eServer E a Ser Ver 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 fou can get IF settings assigned automatically if your network supports this capability Otherwise You need to ask your network administrator for the appropriate IP settings Obtain an IP address automatically Use the following IP address IP address 172 16 190 1 Subnet mask 255 255 255 q Default gateway Use the following DNS server addresses Prefered DHS server Alternate ONS server
57. See Also KR S Display Folder Options Fonts Game Intel Internet Keyboard Controllers Graphics Options Automatic BDE Date and Time W Windows Update In the Administrative Tools double click Data Sources ODBC Administrative Tools File Edit View Favorites Tools Help pack gt a Ka Search gt Folders E Address k Administrative Tools ri om Computer Management File and Folder Tasks i EES 2 KE of Share this Folder f Data Sources ODBC Event viewer a Shortcut i Shortcut Other Places i 5 OU KB ZKE G Control Panel Local Security Policy Pe Performance 3 g Shortcut AAH Shortcut 4 My Documents KB PSAI ZKE EI Mu amantar 10 6 Revision July 2012 In the ODBC Data Source Administrator dialog box select System DSN tab and click on Add button to add system data source ODBC Data Source Administrator User DSN system DSN File DSN Drivers Tracing Connection Pooling About Sistem Data Sources Add Aemoave Configure 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 on this machine including NT services OK Cancel Apply Help Select Oracle in XE and then click on Finish button Create New Data Source Microgott ODBC tor Oracle Microsoft Parados Driver db Microgott Parados T reber db Microsoft Text Driver txts cev M
58. Server Enable specific ports for the Named Pipes connection and the TCP IP connection Due to the connection default port no are 1433 and 1434 we set local connection port as 1433 1434 Gereral 3 Provocak aid Se Fratacals anc pris tae Mrlocel type Pralosel numb Local pert 433 44 Bample 20 43 S030 0 Ferue pull Example 0 43 5000 50 70 OmMiTe are ontel Message Frotaccl CMP settings eam mare aha t ota anc pcre 8 10 Revision July 2012 4 SQL Server User Authority Start SQL Server Surface Area Configuration lairterance Mirrosaft Garces Default Programs lelp and Support Microsoft Sibverligh r SOL Server Management Studio Express iy SC Serwer Conciquration Manager woe Arco figuration Shut dawn men Click the Add New Administrator 5 ti SQL Server 2005 Surface Area Confiquratic s Micrasoft IE Windus Server System SOL Server 2005 Minimize SQL Sever 200b Surface Area SL Server DOO improves marageasilty and securty by giving adwnitetore more control over the surface crea or loca and emye Inslaices of SQL Server 2005 Wilh the SQL Server 2005 Surace Aree Configuration 0013 you ca sasl Disable unused seywees end tetwork protecok ov remote connections Ceable unused features of SOL Server compenerts For new installations ise hese teos to enable recured fealuez services and network pretocals that are deabled by defaddl Fa
59. 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 3 LISH Driver Model Name Version AESOC16 1 08 AEg40 1 08C AE1OC1E 1 08 AE10C100 1 08C Mode Selection AE10C200 1 08 meee R Ous Ra Ethernet aioee1s 3 0036 B07E415 3 0036 B07E515 3 0036 y About Update BOSES15 3 0036 Revision July 2012 3 1 DOP i Chapter 3 Before Using eServer ce 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 eClings Search Printers and Faxes Help and Support el Taskbar and Start Menu Run Windows XP Professional Shut Down Power on PC and start Windows Click Start gt Programs point to Control Panel and then y Metwork select Network Connections nnections y amp Control Panel File Edit View Favorites Tools Help Back T pi pa Search gt Folders FEE Address oe z4 T F Tite fi Ja Ji Control Panel m smni G Accessibility Add Hardware Add or Administrative Automatic BDE Date and Time g Switch to Category View Options Tools U
60. Username system Enter username and password for the database and press Login button to enter into the database homepage Then select Object Browser ORACLE Database Express Edition User SYSTEM Home Administration Utilities Press Create button Revision July 2012 10 9 ORACLE Database Express Edition Q O Home Logout Help User 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 bral Bonk T T Click on Table link ORACLE Database Express Edition O 7 User SYSTEM Home gt Object Browser AQS_INTERNET_AGENT_PRIVS AQS_QUEUES gt AQS_QUEUE_TABLES Table Sj Package t Database Link AQS_SCHEDULES ms DEFS_AQCALL lt View Procedure E69 Materialized View ae oes H G x Function Cfg Synonym DEFS_DEFAULTDEST DEFS_DESTINATION DEFS_ERROR Type DEFS_LOB DEFS_ORIGIN DEFS_PROPAGATOR DEFS_PUSHED_TRANSACTIONS DEFS_TEMPSLOB v ro Sequence FES Trigger Application Express 2 1 0 00 39 Language zh tw Copyright 1999 2006 Oracle All rights reserved i 10 10 Revision July 2012 aor BEP oh ale Ea aSserVer Chapter 10 Writing Data in Oracle Enter the name of the table In this case the name of the new table is entered as oracletable
61. agreement before installation Click on I Agree button to continue FA AppServ 2 5 10 Setup Eak Choose Install Location Choose the Folder in which to install AppServ 2 5 10 Setup will install AppServ 2 5 10 in the Following Folder To install in a different folder click Browse and select another Folder Click Next to continue Destination 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 July 2012 9 3 AppServ 2 5 10 Setup Eak Select Components Select the components you want to install clear the components vou do not want to install Apper Package Components Apache HTTF Server MySOL Database FHF Hypertext Preprocessor phpMyAdmin Then select the AppServ Package Components to install and click on Next button for the next step AppServ 2 5 10 Setup Eak Apache HTTP Server Information Please enter vour server s information Server Mame e g www appservnetwork com lO ii Administrator s Email Address e g webmaster qmail corn O Apache HTTP Fort 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
62. and SQL Developer Clusterware Traditional English French German Italian Japanese Korean and Spanish 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 guide you through the program setup process Please wait Extracting Oracle Database 10g Express Edition rst Cancel 10 2 Revision July 2012 Zor ee ae Ea aSerVer Chapter 10 Writing Data in Oracle Oracle Database 10g Express Edition Install Wizard Welcome to the InstallShield Wizard for Oracle Database 10g Express Edition The Installs hieldA Wizard will install Oracle Database 10g Express Edition on Your 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 CATABASE EKFARI Bi Ti ORACLE DATABASE 10g EXPRESS EDITION LICENSE AGREEMENT To use this license you must agree to all of the following terms by etther clicking the accept butten or installing and using the program hal Print 0 do not accept the terms in the license agreement Back Cancel The users must read license agreement before installation Choose I accept the terms in the license agreement t
63. anl j li al Help Aala Lok Press icon The following dialog box will pop up and ask the users to enter the password all passwords are the same password under Mo 1 12 24 Revision July 2012 Oo et an 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 fll icon will display on the tool bar at the left bottom corner When eServer performs reading due to enable auto refresh on startup eServer will auto convert recipe value to 0223 rcp recipe value without trigger 0 0 but if disable auto refresh on startup please trigger the maintained button element on HMI Then the system will convert the recipe data to the data of 0223 rcp and show on HMI screen Revision July 2012 12 25 Chapter 12 Recipe Access Example Bi eserver Please refer to the figure on next page Delta Soft Simulator 2 21 Kernel Ver R 2 74 eles Delta Soft Simulator 2 21 Kernel Fer R 2 74 F x i Recipe Address 1 12 26 Revision July 2012 eserver Chapter 12 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 Ho Linkage HWI Password l Recipe HWI ai eServer Password input fail all passwords are the same password under Mo 1 Export Varia
64. ar and Start Menu RUM E ot amp Be _ a x wi io Shut Down Power on PC and start Windows Click Start gt Programs point to Control Panel and then Network select Network Connections 2nnections E Control Panel File Edit View Favorites Tools Help Back k Bi pe Search gt Folders EE Address va Control Panel Accessibility Add mariaa Administrative Automatic BDE g Swikch to Category View Options Li Tools Updates Administrator See Also gi x Display Folder Options Same Intel Internet D windows Update Controllers Graphics Options Help and Support ca Fi i a E aa Q b amp amp Network Phone and Power Options Printers and Connections Modem Faxes o g P eane and Scheduled Security Sounds and Speech System Cameras Tasks Center 4udio Devices 2 e a User Accounts Windows Wireless Firewall Network Sek Revision July 2012 Date and Time gt Keyboard Regional and Language Taskbar and Start Menu 12 7 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 s Network Connections m Es Ah F Fie Edit View Favorites Toos Advanced Help ae Back k J pe Search Wa Folders mi Address Network Connections iy G0 LAN or High Speed Internet ah Network Tasks
65. art and then click Control Panel In the Control Panel click Windows Security Center gt Windows Firewall Then click on the Exceptions tab General Exceptions Advanced Windows Firewall i 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 risk Programs and Services Mame M File and Printer Sharing Network Diagnostics for Windows sF Remote Assistance Remote Desktop SMLE Proxy Module HPTOOBMC EXE UPrAP Framework Windows Live Messenger 6 1 Windows Live Messenger 6 7 Phone Windows Netheeting Add Program Display a notification when Windows Firewall blacks a program What are the risks of allowing exceptions Click Add Port button and the following Add a Port dialog box will appear Add a Port Use these settings to open a port through Windows Firewall To fnd the port number and protocol consult the documentation for the program or service you want to USE Port number 3306 TCP O UDP what are the risks of opening a port Change scope 9 14 Revision July 2012 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 fie
66. arted eServer window will open P eServer File View Wizard Tool Help Me Nee ao eServer Initialize Wizard Tool Help 3 LE Logging Logging Recipe Excel ODBC Access New Project Name ODBC Location C Documents and Settings Tina Lee Desktop in Add to the current project Revision July 2012 9 21 Chapter 9 Writing Data in MySQL 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 5 Click New icon to access nodes link to HMI Wizard Logging fx Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Liinakge name Please click 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 9 22 Revision July 2012 Transfer Fath Please select the Following 2 methods to 1 Select a exist Screen DOP file From stroed media oo 0 1 zoe E After searching HMI IP in Ethernet select HMI Name is HMI IP is 172 16 190 100 press OK IF Address Setup IP Address Search IP in Ethernet HMI Mame HMI Model HMI DOP B10E615 lz 16 190 100 2348 eServer will ask user to input the a
67. ate ONS server l e a gal 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 100 Please see the figure below DUP B e y System Setting e OFF 172 16 190 100 PRP 255255 0 0 0 0 0 OB 00 00 00 00 00 Revision July 2012 12 31 After completing all the settings and make sure that the communication is good use the most updated DOPSoft program editing software to open the selected dps 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 l Screen l select RCPNO ERRE gurer 1234 1234 1234 100 EOK OKOE HOR HE GK Rising Edge Falling Edge iE Then compile it and download the recipe data to HMI After recipe data is downloaded to HMI successfully trigger the numeric input element 100 and input TINA on HMI then return to eServer save the file first and then run the recipe data Wizard 30l Help Press gt icon The following dialog box will pop up and ask the users if it is necessary to convert the file of Tina csv 12 32 Revision July 2012 eServer Chapter 12 Recipe Access Example Translated File Path Marne Ce itina csy Overwrite All Check the box before Translate All and press OK button
68. blisher You should only run software from publishers you trust How canl decide what software to run Click on Run button to install AppServ AppServ 2 5 10 Setup Welcome to the AppSery 2 9 10 Setup Wizard This wizard will guide you through the installation of AppServ eo li It is recommended that you close all other applications before skarting Setup This will make it possible to update relevant system Files without having to reboot your computer Click Next to continue P s Q O AN www appservnetwork com Click on Next button to go to the next step 9 2 Revision July 2012 Chapter 9 Writing Data in MySQL eal eserver ok AppServ 2 5 10 Setup License Agreement Please review the license terms before installing AppServ 2 5 10 Press Page Down to see the rest of the agreement GU LESSER GENERAL PUBLIC LICENSE Version 2 1 February 1999 Copyright 0 1991 1999 Free Software Foundation Inc 59 Temple Place Suite 330 Boston MA 02111 1507 USA Everyone is permitted to copy and distribute verbatim copies of this license document but changing it is not allowed This is the First released version of the Lesser GPL It also counts as the successor of the GNU Library Public License version 2 hence we the version number 2 1 IF you accept the terms of the agreement click I Agree to continue You must accept the agreement to install AppServ 2 5 10 The users must read license
69. 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 risk Programs and Services Name File and Printer Sharing Network Diagnostics for Windows F Remote Assistance Remote Desktop Windows Live Messenger 3 1 Windows Live Messenger 6 7 Phone Windows NetMeeting EE Sis Drapes sad ot Display a notification when Windows Firewall blocks a program what are the risks of allowing exceptions Revision July 2012 7 3 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Bilal ey Server 4 Activating SQL Server Double click the EJ located at the bottom right of Windows screen to open the following SQL Server Service Manager dialog box and click Start Continue button SQL Server Service Manager AE EK Server DELTA SGL Name of SQL Server Services SaL Semer Y p b StartContinue E li Pause E Stop W Auto start service when OS starts Running WIABU SHIRLEY EN MSSOLServer 5 Starting Microsoft Access Start Microsoft Access by clicking Start gt Programs gt Microsoft Office gt Microsoft Office Access fas Microsoft Office fin Microsoft Office Tools k a SnagIt 7 a Microsoft Office access 2003 a tartup gt a Microsoft Office Excel 2003 E Internet Explorer Microsoft Office InfoPath 2003 G windows Media Player Micro
70. ca Create a new a T connection meee Disable Change Windows Status Firewall settings Repair Disable this network a device Bridge Connections a Repair this connection mi Rename this connection View status of this Rename connection Change settings of this scale connection Create Shortcut 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 Authentication Advanced Connect using Eg Intel R PR01000 MT Network Con This connection uses the following thems E Clent for Microsoft Networks zi File and Printer Sharing for Microsott Networks fi o05 Packet Scheduler Internet Protacal TCFIF install ee LE Description Transmission Control Protocol lnternet Protocol The default wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected Notify me when this conmection has limited or no connectivity ok treet 12 8 Revision July 2012 eServer Chapter 12 Recipe Access Example 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 as General fou can get IF setti
71. ccess 2UU User intertace za A Organize all your cbyecks using Lhe new easy atiesa S klas madii anm Aamua Input the file name and select the file type as Access 2007 then confirm it Desktop Search Desxton Crganec Wow folder file lt 2 a p e Je Microsoft Office A Detos E samer Pile Folder a Sr Faworiles E Desktop m Downloads T Recent Places Ji File Folder My Desk p File Foleer a a Libraries ia fa Databases e E Documerts Microsoft Office Access 2007 Dat b a Misir I3 KR b E Pictures Seure Aucess 35L VPN b E te ee Internet Shoricut I Hide Folders Revision July 2012 8 13 Click Create Getting Started with Microsoft Office Access O l 4 Featured Online Templates Cortacts Tssues Events Marketing pro ects Projects l R 3 i Blank Database Os oft A More on utice Urtine Create a Microsoft Office Access detebass that does Office Online AP rot ntan any existing data or objects Traiting Templates Duwnlueds File Na What s new in Access 2007 declare g 5 Databave1 accdb jax The new Access 2007 contains more powerful tools Set the latest contert walle working In tie 2007 PS E ta aelp you quirkly track repat and thare Mirroieft Office system c Users yodrgo carrila Pesktop informaticn in manageakle environmen Learn gt bSuldeto Access 2UU Userinterace more anom Ie PENES Al MAE OTENE O
72. ce name eServer or enter the name of the data source you want to access Description Enter some text to identify the connection Revision July 2012 9 17 Chapter 9 Writing Data in MySQL eServer 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 Result Connection successful 9 18 Revision July 2012 9 1 2 Create HMI Project File Start DOPSoft 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 BLOE615 type DOP series HMI is used TE C Documents and Settings TIN A Q LEE DELTA 000A fii example dps DOPSoft File Edit View Element Screen Tools Options Window Help ASRR XRG MRSS lho JAA o eh ACA AL A A A AY BIU Languaget v Fai E E a T E in E a Qanman GNAM aetas Ooos H i
73. d Recipe iS On line Simulation Ctrt F4 OFF Line Simulation CtritF5 Update Pirnrvrare Get Fireware Information Reset HII ie Optons Window Help Ef Compile CtrltF 7 Rebuild All Download All Data CtrltF2 Upload all Data Cel Download Screen Ctrl F Upload recipe Download Recipe A Orline Simulation Cit D OffLine Simulation Ctrl F5 Update Firmware Get Fireware Information Reset HII Revision July 2012 A 9 Appendix A Upload Download via Ethernet eserver Then the following dialog box will appear Destination Static IP Auto Seach Model type Source IP Ad Port The users can check the box before Auto Search and the system will detect the connecting HMI automatically Destination Static IP e Auto Seach Model type Source IF Ad Fort DOP BIUEB15 172 16 190 100 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 A 10 Revision July 2012
74. d or Remo Fonts Network Connections Security Center _ Wireless Network Set BDE Dake and Time Administrator es Internet keyboard Controllers Graphics Options b amp amp Phone and Power Options Printers and Regional and Modem Faxes Language 2 v a Sounds and Speech System Taskbar and Audio Devices Stark Menu Automatic Updates Intel Administrative Tools Game 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 July 2012 12 29 Chapter 12 Recipe Access Example Network Connections File Edit View Favorites Back k ag pi Address sy Network Connections ah Network Tasks A Create a new connection Change windows Firewall settings aj Disable this network device a Repair this connection mj Rename this connection view status of this connection Change settings of this Tools Advanced Help Search Wee Folders Ei E asSerya EEE a wt EJ co _ LAN or High Speed Internet wr ocal Grea Connection an ected B i le a sonnected Disable E a InteR PR Status Repair Bridge Connections Create Shortcut Rename Properties connection The Local Area Connection Properties dialog box will open Use General tab to select Internet Protocol TCP IP Then p
75. data E Tablel Table 28 2011 13 52 40 12082011 13 52 51 O 1208 2011 12 52 53 O 1208 2011 12 53 03 O 1208 2011 13 53 13 O 1208 2011 12 53 15 O 1208 2011 13 53 16 O 1208 2011 13 53 29 O 1208 2011 12 53 31 4 20 0 Revision July 2012 Chapter 5 Writing Data in Microsoft Excel Before creating testing example make sure to change the upload and download option Options gt Environment on DOPSoft 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 collected data in the specified folder C Data 5 1 1 Create HMI Project File Start DOPSoft 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 B1OE615 type DOP series HMI is used TE C Documents and Settings TINA Q LEE DELTA 000A fii example dps DOPSoft File Edit View Element Screen Tools Options Window Help ASB Tye DARE S Alho RAJCI amp h AALALA A A A
76. ddess 172 16 190 4 u 2 Tansfer from Delta HMI F 4 2 Revision July 2012 eserver Chapter 4 Excel Sampling Setting 2 Transfer from Delta HMI Transfer the HMI screen project file via network communication directly Transfer Fath Please select the Following 2 methods to 1 Select a exist Screen DOP file From stroed media IF Address Search IP in Ethernet HMI Name HMI Model mii DOP BINE6G1S 172 16 190 100 2343 HMI DOP BIOEG1S ip l6 190131 12348 eServer will ask user to input authorize password to upload HMI project The default security password is 12345678 After input password finished press OK Upload Authorize Revision July 2012 4 3 4 4 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 automatically 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 Logerinmg Excel Template Designed Template Designed will provide a method to help you easy build a sheet in Excel Please select the following options to decide how to design a template To continue dick Next
77. e disabled Unit of the data length of the register Unchangeable Read Count 6 6 L 2 oN 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 Revision July 2012 eServer Integer Fraction eS S Chapter 6 ODBC Sampling Setting If the register address is set to Bit this integer setting cannot be set 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 When Read Count is 2 Format is floating it can be set Integer 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 When Read Count is 2 Format is floating it can be set Fraction Controller Connecting controller Unchangeable Revision July 2012 6 7 6 1 4 Sampling Conditions This step is used to set the sampling conditions There are two kinds of options for selection 1 Const
78. en click Next The seeced omzomen are beng canficurec Product Status OSL Setup Support Ales Sup tristed 4 IL Native dicrt Soup frisied SOL VSS Writer 521p frisied VE L Server Catabaze Sersces 2p trisred Help lt lt back Next al amel The report of the SQL Server installation shows Click Finish 8 6 Setup has firishad contguretan of Moossct SOL Server 2005 Reter to the setup arrar logs tor mformaben descibing any talurais hat occurred during swup Uik Aneh exit the mstalzton wizard Summary Loc To minkniz the server surface ares of 50 Servar 2005 some atures and services ere cisabled by detult for new instaletions To configure the surface ares of SQ_ Serve us the Configuring and Monoging SGL Senmecr Expross m orimpoved manrsgeabiliy enc security GL 7 cere 2000 prides crue cunbul ove bre SQL freer SU ace area un your sesleri Torrie the surface area the tollawing datault COT iguratior have beer applied to your instance y SLL server om TORIP eontections are disahled ee a ae Revision July 2012 2 SQL Server Configuration Setup Start SQL Server Configuration Manager 5 NMainterance Alirmsaft Games Default Frograrrs COSOM AICE kelp and Support Microsoft scalar PEE r E I IA l re SQLS aaa Mla salamna zinkom Studio Express lt a Sener C Coigaon exes Reporin g SL Germir Eram Arca Conf SET 1 ey pe bi
79. er through Windows Firewall through the Internet or a retwork My Change notification settings How dose a Firewall help protect my computeri La Tum Wordows Firewall or or What are network locetions off l ay TE For your secunty come settings are managed by your system administrator i Updat Firewall settir Tmuhlesinnt my network plate your Fire se Lins Windows Firewall i mot using thz recommended setting to protect your computer ay Use rerommended settings Wihial are Die recermercded selling Choose Inbound Rules then click New Rule Input the name of new import rule and choose the connection action Tile Action View lelp 8 HLEBA Inbound Rules F Marne Oeserver ODBC rr Remae fr Oi IF Remote Gr Sr Remoze Gra HF skyRoom Microsoft Offic Esope DTeamviewer Teamviewer Fe Teamviewer Re Teamviewer Fe Trens Mirm CH Trenc Wicro O Trenc Micro OF eranchCacre eranchCace franh aras E Ei Oulbuu Be Correction Secunty Hules WB New Ruc Y Fiker by Pro ie i Y Hker by state T Fiker by Group b View p E Montoring Refresh cap epot Ustu 4 Diszkle Rule f Cut Re Copy x Delete Dock the connection Revision July 2012 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8 9 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 E a
80. ere 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 Ii fee DOD 444 D29 bbb Pe siate J99 e Enable Auto Refresh on Startup nm ae iio p Export e b d e 2 Type HMI Name Information Modify Recipe Suto Refresh on Startup 1 _JEmortt is bits HMI Length 3 Group 3 0223 3p a EJ 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 as Rising edge Mode e Harme Controller Export Internal WIernory Revision July 2012 12 19 Chapter 12 Recipe Access Example eServer 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 172 16 190 100 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 2 Documents Settings Search Help and Support Run Windows XP Professiona 2 Shut Down Network Co
81. ers want to pause or stop the sampling operation only right click eServer Mw 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 P Run Pause top E o DELE Exit 7 20 Revision July 2012 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Before creating testing example make sure to change the upload and download option Options gt Environment on DOPSoft 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 100 every second record the data in Microsoft Access database via ODBC interface and save the collected data into the specified folder 8 1 1 Database Setting 1 Install SQL Server 2005 Express Edition Presently only SQL 2005 Express and SQL Server 2008 can used in Windows 7 OS so we choose SQL Server 2005 Express as the database server To download it go to http www microsoft com downloads details aspx familyid 3181842A 4090 4431 ACDD 9A1C832E65A6 amp displaylang zh tw and a download link will redirect the users to download it SQLEXPR_CHT EXE is for x64 bits OS and SQLEXPR_CHT32 EXE is for x32 bits OS Revision July 2012 8 1 After running the se
82. es 4 5 424 REGISTER SeN urrira aadunn eset 4 9 ALS Sampin COMMONS aieea a diate idan bicker 4 11 AO OURO SCLIN seentucsccencceasnanasenesenasesaseranenesesasaieesterencreuerasdus serene asexsndveseraie 4 12 Ale MOUNT SCE wcesrseersccxescasscsarensceqesncncerssens cane tacees te vetenstecansnetsvatenssevadees tere0e 4 17 Chapter 5 Writing Data in Microsoft Excel 3b EXIM eR rn gen err OR rene Rete ee ee ee on none Ren eer 5 1 SEL Create HMIProject FIE pe ee 5 1 SRE CVT S Aa a a a N 5 3 Chapter 6 ODBC Sampling Setting opel Detailed Setting ee ee N a an 6 1 O EN ACS er aE a E A E 6 1 6 1 2 ODBC Open Data Base CONNECHIVILY ccccceceeeeseeteeeeeeeteeeeeseeeteatsneataneas 6 4 6L Register Setting ersero devs A EENE AEEA 6 6 6 14 Sampuing C ONAION S saaTs AE AAAA ADAADA PIE ERARA 6 8 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Fl EXAMI eee i E ne nee ee 7 1 Plead Database Setin saetce cacti cect east dechantedact dasa aamaenwesanacie enue rasemaenbesaeaneraauntion 7 1 Pl 2 Create iM PRO lGCC Fl Cuno ENAA 7 13 PMs CIVET SOU El NG baci oie caress oeeecate ewes ae essa teen ta eoien ea tenean a eteeunn aces unten 7 15 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 8 1 EXMP See eee een ee ee ere ee eee 8 1 6 1 1 Database Sere iG aa A OAE ERAEN EREE 8 1 l 2 Create HMI Project File cea a nnr rr erara 8 23 6 1 3 9ervVer SEttNO horoia aa a 8 24 ii Revision July 2012
83. es HMI DOP AE8OTHTD1 AE80THTD1 DOP AE8OTHTD1 product DOP AELOTHTD1 AE10THTD1 eo BO7E415 DOP B07E515 BO7E515 DOP B Series ee BO8E515 pormi B10E615 1 3 System Requirement Below are the system requirements to comply with the operating environment of eServer Printer Printer compatible with Windows 2000 Windows XP Windows Vista Windows 7 Operation System Windows 2000 Windows XP Windows Vista Windows 7 Microsoft Office 2000 supported Microsoft Microsoft Office 2003 Office Software Microsoft Office 2007 1 2 Revision July 2012 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 Recycle Bin a pinternebe Explorer Revision July 2012 2 1 Oo at a Chapter 2 Software Installation A eservaer Step 2 Execute setup exe from Windows taskbar by clicking Start gt Run After pressing OK the system will setup automatically and the following dialog box will appear for selecting the desired display language ad My Documents pA My Computer W Vi MerAork HE
84. es 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 You can get IF settings assigned automatically if your network supports this capability Otherwise pou need to ask your network administrator for the appropriate IP settings Obtain an IP address automatically Use the following IP address IP address 172 16 190 1 Subnet mask 255 255 255 q Default gateway Use the following DNS server addresses Prefered ONS server Alternate ONS server ox treat 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 tn the list when finding node A 8 Revision July 2012 Appendix A Upload Download via Ethernet A 3 Compile and Upload Download All Data After completing PC networking settings compile the editing program immediately When compile operation is performed successfully choose Upload all Data or Download all Data next Options Window Help T od le ket Compile Ctrt F Rebuild All E Download All Data CtitF3 Upload all Data Cell Download Screen CtltFo Upload recipe Downloa
85. ess automatically HMI HMI HWI IP Address Te subnet Tylask 255 Ethernet Gateway IP uploadidowrdoad port Modbus TCP Server Port Application eRermote eserver Enable eh TE 12345678 acar Time 100 Port 12343 Come Interrupt ETS times then ignore 10 14 Revision July 2012 10 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 2 Then open eServer window eServer File View Wizard Tool Help P eServer eServer Initialize Wizard Tool Help Revision July 2012 10 15 4 Select icon to enable ODBC Logging Wizard a Logging Logging Excel ODBC Location C Documents and Settings Tina Lee Desktop Ol Add to the current project Wizard Logeime 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 10 16 Revision July 2012 EZ a Serer Chapter 10 Writing Data in Oracle 5 Click New icon to access nodes link to HMI Wizard Logeing Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information Liinakge name Please click the following buttons to access nodes To con
86. eters tor tigger concition M Lot x tables Revision July 2012 8 27 Save and Execute fo cServer File View Wizard Tool gt Help iaoject Jarice a c i eServer i Cec After the password is entered the system will start sampling operation and write data in o 8 E iH FRI Setirg Address Coiditian Output Microsoft Access all passwords are the same password urder Mo 1 cares 8 28 Revision July 2012 eServer Logging Database We can see that a Database1SQL file is existed in the folder as the original created access 2007 file in Logging data shows as below figure a l al i T atahate ole zel SOl M Ciad SS __SL SESE gt gt EE gt E gt E gt E gt _ ESSSSS n_n Home Create External Data Database Tools Acrobat wk ec Fg t r E fe Cu Calibri 4 Copy Paste F Format Painter Clipboard F i data2 1 02 14 2011 13 14 993 2 02 14 2011 13 19 990 500 3 O2N42011 13 24 1003 Revision July 2012 8 29 2 et A This page intentionally left blank 8 30 Revision July 2012 Chapter 9 Writing Data in MySQL Before creating testing example make sure to change the upload and download option Options gt Environment on DOPSoft first The default setting of upload and download Is via USB If the user
87. evision July 2012 Bal eSer Ver Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Setup the error report way Set as below figure and click Next Error and Usage Report Sattings Help MicrosoPt improve some of the SOL Server 2005 comporent F anc services f Automataly scnd Errar roparta Fer SQL Server 2005 to Microsoft or vour corporate zrror F repordng eerver rror reports include inccrmaticn regarding the cond tion of SOL Server ALl ahan an arar arnouirred your hardware ooiguratcn and ether cata Aor reports mey unintentonal y Indude personal Information which wil nat be used by Micrasct Altoamatealy send Teat ire leaga daca tor SO Server 3005 to Mirasa Rage data indud s anonynous information about your harcwere zorfiguratian and how vou use our sotse and sevis By installing Mirosott SOL Server 2005 SOL Server and ite comporents wil be 2r figured to aworatrally senc fatal serere eer reports to Womsatt aor a Corporate Arrar R parhng Serve MiuwsefLuses eru rep ts bo mprove SOL Server funrclunalily and beat all information 35 conmidental Setup completely and start to install Sctup sready to begin installador Se lp has nougn Information to stat cooying he program fles To oroceed cick Instal To chang avy ol your insLalla jon sellines dik Back To exil setup dick Corel SIH Server Hhatahase Servies Jatabece Services Revision July 2012 8 5 The progress of installation shows as and th
88. fer 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 Revision July 2012 eserver Option Communication Disconnect E Environment Language cancel Revision July 2012 3 9 Oo i ae Chapter 3 Before Using eServer Kad a Server 3 4 3 Disconnect Function This function allows the system to display warning message when the HMI connection to Ethernet is disconnected the eServer will showing the warning message after the configured time period eServer Option El Local Host anrec Synchronize Communication aim Disconnect F d When the connection to Ethernet is disconnected the eServer will J i Environment bry bo reconnect and show warning message Language fd Excell be ODBC Recipes all settings are the same value under Mo 1 For example see the above figure if the time is set to 15 seconds when the connection to Ethernet is disconnected the eServer will display warning message after 15 seconds 3 4 4 Environment Language Setting User could change eServer interface language we provide English Traditional Chinese and Simplified Chinese to select 3 10 Revision July 2012 eServer Option aie es
89. g 1 After eServer is started eServer window will open ge eServer File View Wizard Tool Help eServer Initialize Wizard Tool Help 4 Select Logging ODBC Revision July 2012 5 3 Chapter 5 Writing Data in Microsoft Excel eserver Wizard Logring 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 To continue cick Next Press Next button to go to next step 5 Click New icon to access nodes link to HMI Wizard Loggins 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 click Next 5 4 Revision July 2012 eServer Chapter 5 Writing Data in Microsoft Excel 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 1 Select a exist Screen DOF File From stroed media o o 0 1 ame E Revision July 2012 5 5 Chapter 5 Writing Data in Microsoft Excel eServer After searching HMI IP in Ethernet select HMI Name is HMI IP is 172 16 19
90. g This function default is enable it means when logging data is not full with data range it will keep saving data into the same file If disable this function it means when logging data is not full with data range it will save as file and will not overwrite data m Set one minute to auto save file scan time is five minutes data range is 20 disable overwrite the file when saving When time arrived one minute the data range still not full and due to disable overwrite the file when saving option the file will save as file according to one minute m Set one minute to auto save file scan time is five minutes data range is 20 enable overwrite the file when saving QO Revision July 2012 eser ver Chapter 4 Excel Sampling Setting When time arrived one minute the data range still not full and due to enable overwrite the file when saving option the data will overwrite to the same file until the data range full and will according to repeat add a new file or add a new sheet to save file E Auto Save when power off This option provide when HMI power off eServer will auto save the currently data F Follow the last stop logging position When user enable this function it means eServer follow the last stop logging position to continue logged and will not clear the previously data G Clear History Record User could press this Clear History Record button to clear all previously logging data 4 1 7 Other Setting
91. gging data eServer will display error message and stop logging b If set allow nulls for null and does not set default value eServer will fill with empty to replace data Revision July 2012 4 19 c If set allow nulls for null and does set default value like 222 eServer will fill with 222 to replace data Step1 Uncheck HMI BO7E515 node to logging SG g oO Mode Setting Address Condition Output i A Lot Enable HMI Name Port cont cont fetus O HMI B07E515 172 16 190 151 12348 Delta DYP PLC 7 200 eServer 172 16 190 123 12348 wa Delta DVP O Link wa Step2 Table 1 is logging data to HMI BO7E515 node Set trigger for eServer node at Table 1 E Tablel Table g ENa DataType Lent gt a F 50 We p cE c3 2 50 v F TE char 50 vd Mode setting Address Condition Output ae Gi y t char 50 We E char 50 vd Tablet Tablez char 50 y char 50 y Type HWI Harme Detail Format Controller char a yf Trigger eServer 0 0 Fusing edge Internal Memor Trigger EDEIVEr 0 2 Falling edge Internal Memory HMI B07E515 node is logging data to Table1 But this node had uncheck to usage so if set eServer Filled with empty node to trigger it it would log data like Data Base fill with default value for empty or some value Columns Lookup Default Yalue k mii Step3 When trigger on 0 0 and 0 2 at eServer node the table1 would fill with empty
92. he 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 SQL Server very the authenticity of the login 1D Co With Windows NT authentication using the network login ID jf With SQL Server authentication using a login IO and password entered by the user To change the network library used to communicate with SQL Server chick Client Configuration Client Configuration Connect to SOL Server to obtain default settings for the additional configuration options Login ID te Password p Cancel Help 7 10 Revision July 2012 Riad Ser Vet Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Change the default database to DELTA Press Next button to continue Create a New Data Source to SOL Server iw Change the default database to DELTA Attach database filename pandae o Create temporar stored procedures for prepared SUL statements and drop the stored procedures f rly when vou disconnect When pou disconnect and as appropriate while you are connected W Use ANSI quoted identifiers M Use ANSI nulls paddings and warnings Use the talover SQL Server if the piman SEL Seneris not a allable lt Back Next gt Cancel Help Press Finish button Create a
93. host g Databases J 2 Variables 2 Charsets KJ Engi Privileges Processes phpMyAdmin aleae Databases Database a Collation i Database mysql utf8_general_ci g Databases _ x 0 phpmyadmin utf8_bin g8 a test utf8_general_ci g Please select a database Total 3 utf8_general_ci t__ Check All Uncheck All With selected Enable Statistics A Note Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server Create new database test Collation Open new phpMyAdmin window 9 8 Revision July 2012 A new database has been created a Server localhost gt a Database test Pe Structure SAL JO Search z Operations 8 Privileges phpMyAdmin Database test has been created Database testpasbeenereated Database SQL query test 0 i CREATE DATABASE test test 0 Edit Create PHP Code No tables found in database No tables found in database ud Create new table on database test Name 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 f Database test eo Privileges fej Structure sor y s H ate Export fl Sa Operations No tables fo
94. ication setting symbol etc And Linkage will help you how to link original project information Transfer Path Ea Please select the following 2 methods to L Select a exist Screen DOP file from stroed media C Documents and Settings Vanturn lina m HMI dpb 2 Tansfer from Delta HMI To continue dick Next Revision July 2012 8 25 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Ea aSer Ver ODBC Data Source Setting input the ODBC Data Source name account and password Press the refresh button and select the table name and click then chooses the field as below figure Wizard Logrimg ODBC Please indicate the Following items Chooses a data source DSM and input user name and password ODBC Data Source TEST User Name rodrigo carrllo Password EERE ee Database Driver SOL Server Table Table1 Table1 Tine and Date Table Feld Detal Stamp Tabli Time zonrn H ol To continue click Mext Set the register address to the corresponding field as below figure 8 26 Revision July 2012 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 pas Register Setting Please input logging addressir the follawing Calls aa iu To continue dics Next Bad Next gt Conce Firisn Set the sampling conditions as constant and set the value as 5s Lagging Condition The Cond tion will provide 2 solutions to hep you easy create pavan
95. icrogott Text Treiber tet cew Microgott Visual FoxPro Driver cle in sE a a z Back Cancel Revision July 2012 10 7 Now complete Oracle ODBC Driver Configuration as mentioned in the below dialog Oracle ODBC Driver Confizuraton OK Data Source Hame OracleSQL kK ae Cancel Description Pn Help TNS Service Name RE Test Connection User ID systerr Application Oracle Workarounds SQLServer Migration Enable Result Sets W Enable Quer Timeout w Read Only Connection Enable Closing Cursors Enable Thread Safety i Batch Autoconumt Mode Commit only if all statements succeed X Numeric settougs Tse Oyacle HLS settings s Data Source Name Enter ODBC data source name or 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 3 Create Database and Table 1 Start Database see the figure below ia Oracl Database 10g Expres Edition fin set Help Ea Backup Database fl Get Started Ea Restore Database CO Rum SOL Command Line A Stop Database 2 Go to Database homepage 10 8 Revision July 2012 ORACLE Database Express Edition Database Login Enter your database username and password
96. iew the web site by pointing a web browser to http localhost If the following screen displays it indicates that Apache has been installed successfully gt AppServ Open Project 2 5 10 Windows Internet Explorer G y v L http localhost o i v ti X f sarc Iel File Edit wiew Favorites Tools Help PERR e A x a gt we k 88 eres 000 CO appserverne C Microsoft 5Q C Microsoft 5Q C Microsoft sa AppServ X fe Gl ab Ey Page amp Tools The AppServ Open Project 2 5 10 for Windows 38 phpMyAdmin Database Manager Yersion 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 e MySQL Database Version 5 0 51b e phpMyAdmin Database Manager Version 2 10 3 ChangeLog README AUTHORS COPYING Official Site http AvwewAppServNetwork com Hosting support by http AvwwwAppServHosting com Change Language memm z Easy way to build Webserver Database Server with AppServ Done Local intranet 100 9 6 Revision July 2012 eserver Chapter 9 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
97. ill provide 2 solutions to help you easy create parameters For trigger condition Lok Detect Scan Time How long would you like on your logging data 500ms one day To continue click Next 10 Choose Add a new file in Excel Sheet and define the file location and file name shown as the figure below Selected Period in Auto Save and set one minute then press Finish button to complete the settings 5 10 Revision July 2012 Wizard Logging Output Setting Ecxel Sheet O Repeat Odd a new file Add a new sheet Output Location C Documents and Settings tina g lee Tw al EESE PETINE Report File Name Data_oH M5 oo Auto Save How long would vou like bo save your logging data Day Hour Minute 11 Press Le icon and enter the password 12345678 Then the system will start Sampling operation i e writing data in Excel file all passwords are the same password under Mo 1 Revision July 2012 5 11 DOr et A Chapter 5 Writing Data in Microsoft Excel E aSey Ver ina Erel Teme ao ET T ACAO 171B16 C2008 171817 DATATO 17 16 15 DATACDOS 17 16 19 URTATI 1T16 20 DEDALO T 1621 Deme 17 18 22 AEH e008 171023 CAAA EO0 LTRS DDATO 17 1625 CAHOON 1T 1827 ORM OWO Tbs Haden 17 1029 DRAAD 1 T1850 BAe 2009 171851 CARO 17 18 32 ORGANS 17 18 33 baa ad fem e ne Pe fg ae e eS oe oS OS BE I Be Pee E gt 7 K a A ip EUM
98. ime 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 BR No Type HKI Harme Detail Format Const wa 58 a mwa Detect Scan Time x How long would vou like on your logging data fone second one day ae To continue click Mex 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 Revision July 2012 4 11 Wizard Lorring Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition A Lt E Sheetl HMI 0 0 Rising edge To continue cick Next Polling Cycle Sampling Cycle It is used to determine how long the sampling process IS repeated The time unit is ms Logging Condition Setting item Description Remark No Condition number Unchangeable 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
99. in the selecting area simultaneously 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 Single Horizontal 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 horizontal direction The sampling operation of the second 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 and the system will open the editing Excel template sheet immediately 4 You could be cicked the right button to execute Excel afid then decided the range Selection Range QB Revision July 2012 eserver Chapter 4 Excel Sampling Setting In Excel template sheet use the mouse to decide the selection range After the desired range Is selected press Close button to finish EJ Microsoft Excel Tem461 C3 fe 4 i Data Average DIV 0 DIV 0 DIV 0 DIV 0 Time midi wy YH M S SSS s s D IV DIVV
100. ista 01332 000 Sao Paulo SP Brazil TEL 55 11 3568 3855 FAX 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 2012 08 09 eve vel A ELTA DOP eServer User Manual www delta com tw ia Publication History Please include the Name of Manual and the Issue Version both shown as below when communicating with us regarding this publication Date Issue Version Description of Changes 2010 10 23 eServer 001 1 First Edition 1 Add Time stamp of Format Cells explanation P4 7 2011 03 14 Server 002 ie Add CHO08 Database Access 2007 at Windows7 explanation Fixed ODBC setting interface for Wizard Fixed Excel setting interface for Wizard Fixed Tools gt Options gt Disconnect interface of function menu P3 10 Fixed Screen Editor example to DOPSoft example Add Tool gt Options gt Environment interface of function P3 10 Add Excel Overwrite the file when saving and Other setting function P4 16 P4 20 Add Recipe Auto Refresh on Startup function PL1 4 P11 5 P12 5 P12 11 P12 16 P12 17 P12 19 P12 25 P12 27 P12 28 P12 32 P12 33 2012 07 19 eServer 003 Revision July 2012 Table of Contents Chapter 1 Introduction 1 1 eServer Data Collection SOFTWAIE
101. ister Setting Please input logging address in the following Cell s 53 To continue dick Next 8 Select the Type as Trigger Then set the format of address 0 0 to Rising edge and the format of address 0 2 to Falling edge respectively Press Finish button to continue Wizard Logring Ed Logging Condition The Condition will provide 2 solutions to help you easy create parameters for trigger condition oracletable Rising edge s To continue dick Next 10 20 Revision July 2012 eserver Chapter 10 Writing Data in Oracle 10 Press LE icon After the password is entered the system will start sampling operation i e writing data in MySQL Server Wizard Tool Help all passwords are the same password under No 1 Cancel 10 If the users want to pause or stop the sampling operation only right click eServer Wy 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 July 2012 10 21 20 ay e Chapter 10 Writing Data in Oracle a aservar 11 Open the browser and go back to the Oracle database Click on Data link ORACLETABLE e e Table Data ndexes Model Constraints Grants Statistics Ul Defaults Triggers Dependencies SQL A083 INTERNET_AGENTS a Add Column Modify Column Rename Column Drop Column Rename Copy Drop Tru
102. ject 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 BLOE615 type DOP series HMI is used TE C Documents and Settings TIN A Q LEE DELTA 000A fii example dps DOPSoft File Edit View Element Screen Tools Options Window Help ASRR XRG MRSS lho JAA o eh A AALA AA AY BITU Languaget E w f E E s ie ia E a Qanman GNAM aetas Oos GatQOu FQ 2 1 Screen_1 Property Oo x EY Screen _1 v oO O Screen Name Screen _1 4 Screen Properties Detail A Background Color _JRGB 252 252 252 pom Screen Macro a Screen Open Macro 0 H Screen Close Macro 0 Screen Cycle Macro 2 Width 1024 Height 600 Output Ox Step Action gt 1 Cut element J Paste element gt 3 Move elernent Record Ouput Hh a a a G ears SH HF ee Download USB 798 185 DOP B10E615 65536 Colors Rotate 0 degree Use Screen Cycle Macro and enter the following commands in macro command window MS Screen 1 Screen Cycle Macro SS tel A lS E Bi a A Screen 1 Screen Cycle Macro 153 3 1 S6 6 3 Click Options gt Communication Setting gt Ethernet gt LocalHost set HMI IP Address and check the Application eRemote eServer function Enable Then press OK button to finish the settings Revision July 2012 7 13 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Ria eSer
103. ld 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 mysql com downloads connector odbc 5 1 hAtmi i MySQL Connector ODBC 5 1 Setup Wizard Welcome to the Setup Wizard for hlySOL Connector ODBC 5 1 The Setup Wizard will install MySQL Connector ODBC 5 1 release 5 1 6 on your computer To continue click Next WARNING This program is protected by copyright law 5 ODBC Setup In the Control Panel double click Administrative Tools E Control Panel Seles Fie Edit View Favorites Tools Help ae Back k Bi 1a Search gt Folders Ei 6 x 5 Accessibility Odd Hardware Add or Options Remo A Display Folder Options Fonts Address Eni E Control Panel A G Switch to Category view See Also b Automatic BDE Date and Time Updates Administrator a e co Y Intek Internet Keyboard Controllers Graphics Options D Windows Update Revision July 2012 9 15 In the Administrative Tools double click Data Sources ODBC H Administrative Tools Fie Edit View Favorites Tools Help Q eck amp Dy Search Folders Hab Address U Administrative Tools 5 Computer Management File and Folder Tasks L For kELIk be Share this Folder 9 Data Sources ODBC p Event Viewer Shortcut Shor
104. le E a InteR PR Status Repair Bridge Connections Create Shortcut Rename 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 8 Intel R PROA1000 MT Network Con This connection uses the following items El Clent for Microsott Networks File and Printer Sharing for Microsott Networks T o05 Facket Scheduler il Internet Protocal TCRVIP Install Description Hinmnstall Properties Transmission Control Protocol lnternet Protocal The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected Motify me when this conmection has limited or no connectivity ok treet 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 12 14 Revision July 2012 eServer Chapter 12 Recipe Access Example Internet Protocol TCP IP Properties General You can get IF settings assigned automatically if your network supports this capability Otherwise pou need to ask your network administrator for the appropriate IP settings E Obtain an IF address automatically
105. le via ODBC interface and save the collected data into the specified folder C Data 10 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 v ORACLE r Welcome Lee Account Helo Sign Out United States Communities Ilama v wantto v Secure Search Q Products and Services Downloads Store Support Education Partners About Oracle Technology Network v Oracle Technology Network Database Database Express Edition Database 11g Overview Downloads Documentation Community Learn More Popular Downloads Berkeley DB Database Focus Areas Database Options Oracle Database 10g Express Edition Downloads Enterprise Manager Database EE and XE Database Express Edition Oracle Database 10g Express Edition Oracle Database 10g Express Edition for Linux x86 e Database Upgrade Enterprise Pack for Eclipse e Fusion Middleware Berkeley DB Smaa TimesTen In Memory Database Java EE amp GlassFish Database 109 Java SE Database Lite amp JDeveloper and ADF RDB MySQL Audit Vault NetBeans IDE Secure Backup Solaris Real Application Clusters SOL Developer Clusterware VM VirtualBox Mul
106. lf extracting file starting the installation of SQL Server Installing Prerequisites Installs software comands required paw ie mealg Sl Server SOL Server Compcnent Update well install the follaving components regqured for SOL Serve Setup Poros SO Serwa 2005 Selup Supponi Ales Ihe ragared componant wera metaled Succassf ly _ _ _ _ Hest Cancel Check system configuration then click Next aystem Confguraton Check Wait wile te systen is coeceed for potent el install ston 134 Total 12 Giss fMiininum Haviwear Seq ire ert scree tla Reboot Reqaremert SLocess Defa nztellzion Pata Pemussion Re Success Indemed eplorar Reqlrement LCCese CON Fua Catzleg Requirement Success AST Net Version Gecisteater airs Weaning Meszeces Minium HODAC Versi Rogorene dl Eule l Fadhlan Charge Cha Surress Report 8 2 Revision July 2012 Feature selection Set as below figure and click Next Fealure Selec Select the progam features you want msbialec Chick an ioen in the allowing lizz bo cianga how ature is netaled eshure description lh Database Services Installs tia SOIL Server Jetabase Client Components Engine tecle hor managing relabora Conmectyizy Components and YML cots and reclicaaan A Sothvare Development Fit This talue reyd 87 FB on yuu hard crue thes 7 of 3 subteetires s2ected 72 scbTatresrecure LU ME sn your hare drive
107. lity Othenwise you need to ask Your network administrator for the appropriate IF settings Obtain an IF address automatically fe Use the following IP address IP address 172 16 190 1 Subnet mask ETERA Default gateway an ry K Ae e E a e e a a ee lel OLAI LHS j VE a l FALL LEa Le Use the following DNS server addresses Prefered ONS server Altemate ONS server e s g Then press OK button to finish the settings 12 22 Revision July 2012 iid ASOT Ver Chapter 12 Recipe Access Example Setting IP Address in HMI Enter into the system menu and set IP address to 172 16 190 100 Please see the figure below e System Setting e OFF 172 16 190 100 AH 255255 0 0 0 0 0 0B 00 00 00 00 00 After completing all the settings and make sure that the communication is good use the most updated DOPSoft program editing software to open the selected dps file which just has been modified on eServer Create a maintained button element and set its address to 0 0 Revision July 2012 12 23 Chapter 12 Recipe Access Example eserver l Screen_l Select RCPNO Hee Buffer HMC HHH HCH K E i Rising Edge Falling Edge PLO TO HMI HMI TO PLO 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 Wiz
108. ll log data like BC output fill with default value 222 4 18 Report File Name Output File C Documents and Settings tina g lee TWO Leal Data Heh5 Location Auto Save amp Record 4 Period Fixed bo Auto Save How long would you like to save your logging data Day Hour Minute Auto Save when power off Follow the last stop logging position IF either of the above check boxes is checked the history records will be memorized You can press the right button to clear the history records Others Please specific the cell default value when the desired hmi is disabled Ho HII Default Value 222 1 eServer 2 HWI B07E515 ex 3 12 08 201 4 12 08 201 Revision July 2012 eserver Chapter 4 Excel Sampling Setting ODEC ODBC logging also provide user could select usage node or not And the default value is according to each ODBC data base setting to data table for allow nulls and default value Tablel Table ColmName Data Type Length Allow Null ime char s0 Y IE o datal char 50 y datad char 50 y O dats char 50 y o data4 char 50 y O data5 char SO y o data5 char SO y data char 50 y data char 50 y E aa a eB Columns Lookup A Formula Collation database default gt Format hal Allow nulls have three kinds of state a If set allow nulls for not null and uncheck usage then lo
109. n Program ye fests k 7 4 Piven four moza over 4 component tg zaa its lascrecion ss O a Revision July 2012 2 3 2 4 Chapter 2 Software Installation Step 5 The system will start DOP eServer Installation E pop Setup Copying Files Extract ModbusRTU HEX dl Show details Step 6 DOP eServer has been installed successfully Press Close to finish the installation E pop Setup Completed Completed CLE Revision July 2012 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 xx gt Update Firmware Tool fgg Delta Industrial Automation C DOP eRemote 2 00 00 gt fm DoPsoft 1 00 01 0 Screen Editor 2 00 23 m DopSoft 1 00 00 fay DOF eServer 1 00 14 fh SSEIVEL if Tninstall Ra Update Firmware Tool The system will detect if the HMI firmware is the same as the firmware included in 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
110. n 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 a exist Screen DOP file from stroed media CA Documents and settings sshirley lai y DocumentssDenc_ IPAddess 172 16 190 4 2 Tanesfer from Delta HMI Cl T 6 2 Revision July 2012 eServer Chapter 6 ODBC Sampling Setting 2 Transfer from Delta HMI Transfer the HMI screen project file via network communication directly Transfer Path Please select the Following 2 methods to 1 Select a exist Screen DOP file From stroed media IF Address Search IP in Ethernet HMI Name HMI Model mii DOP BINE6G1S 172 16 190 100 2343 HMI DOP BIOEG1S ip l6 190131 12348 eServer will ask user to input authorize password to upload HMI project The default security password is 12345678 After input password finished press OK Upload Authorize Revision July 2012 6 3 6 1 2 ODBC Open Data Base Connectivity This step is used to create an ODBC Data Source pointing to your database Wizard Logring ODBC Please indicate the Following items Chooses a data source DSW and input user name and password ODBC Data Source User Name root Password kutata at ts i ts a Database Driver My SOL
111. ncate Create Lookup Table Ehei E ae bina Column Name Data Type Nullable Default Primary Key AQS QUEUES E TIME CHAR 100 Yes AQS QUEUE TABLES we AQS SCHEDULES aled aest o e 5 DEFS_AQCALL DATAZ CHAR 100 Yes DEFS_AQERROR 1 3 DEFS_CALLDEST DEFS_DEFAULTDEST DEFS_DESTINATION DEFS_ERROR DEFS_LOB DEFS_ORIGIN DEFS_PROPAGATOR DEFS_PUSHED_TRANSACTIONS DEFS_TEMPSLOB HELP LOMO NARAMIF 1M MAD A LILI 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 Oo ndia uiie i aT ie aT AQS_QUEUE_TABLES R 0973 2010 12 06 29 14311 42933 AAS SCHEDULES DEFS_AQCALL FA 0913 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 paj uss 10 22 Revision July 2012 Chapter 11 Recipe Access Setting 11 1 Detailed Settings Please refer to the following steps to complete Excel sampling setting i e how to log data from HMI to Excel 11 1 1 New Project Start eServer and click File gt New or click New icon B eServer Logging Logging E
112. nce Setting a Select Variance b Check the check 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 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 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 in CA f Enable Auto Refresh on Startup Revision July 2012 12 27 V Enable Recipe Save in Se Windows eP Professional C we E F EP Ej 2010 03 12 4 i Documents and Settings My Recent Program Files Documents Tina WINDOWS B AddressBook txt eserver ini RCP edx Address Tim D20 tH tina cs xls My Documents 5 hy Computer 2 My Network Save as type All Files s T Rep Export Internal Memory Mode a 2 d ER age Nare Type EMI Nane File Name Length Controller Somce Path f nto Refresh on Startup A Exporti ii ld bits HMI 100 2 O Export32 1 32bits HMI None E 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
113. nding to user custom time if period time set to one minute it means every minute save file and refer to Excel sheet to repeat add a new file or add a new sheet g 2 oo Node Setting Address Condition Output Output File Location Report File Name Data SHISh S E Auto Save amp Record dP Period Eid p Auto Save How long would vou like to save vour logging data Overwrite the file when saving Guto Save when power off Follow the last stop logging position IF either of the above check boxes is checked the history records will be memorized You can press Clear History Record the right button to clear the history records Fixed time format is 24h A day could only save one time If set fixed time to 15 hour it means it will save file at 15 hour in a day and refer to Excel sheet to repeat add a new file or add a new sheet Revision July 2012 4 15 Chapter 4 Excel Sampling Setting g T wo Mode Setting Address Condition Output Output File reo C Documents and Settings TINA Q LEE DELT Report File Mame Data _SeH M S5 Auto Save amp Record d a eiod Fixed b Overwrite the file when saving Auto Save when power off Follow the last stop logging position IF either of the above check boxes is checked the history records will be memorized You can press M Clear History Record the right button to clear the history records D Overwrite the file when savin
114. next step 7 Register Setting Set the register address of the sampling data Wizard Logems Register Setting Please input logging address in the following Cell s To continue cick Next 7 18 Revision July 2012 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 EE Detect Scan Time How long would you like on your logging data SOO0ms one day o Slt f Eomae sean To continue click Next Press Next button to continue 9 Press icon After the password 12345678 is entered the system will start sampling operation i e writing data in Microsoft Access Wizard Tool Help ODBC1 so ta a oo _Jall passwords are the same password under No 1 Revision July 2012 7 19 Table1 Table 8 26 2009 13 24 51 0826 2009 13 24 52 08 26 2009 13 24 53 08 26 2009 13 24 54 08 26 2009 13 24 55 08 26 2009 13 24 56 08 26 2009 13 24 57 08 26 2009 13 24 58 08 26 2009 13 24 59 08 26 2009 13 25 00 08 26 2009 13 25 01 08 26 2009 13 25 02 08 26 2009 13 25 03 08 26 2009 13 25 04 08 26 2009 13 25 05 __losr26r2009 13 25 06 08 26 2009 13 25 07 08 26 2009 13 25 08 08 26 2009 13 25 09 08 26 2009 13 25 10 08 26 2009 13 25 11 08 26 2009 13 25 12 08 26 2009 13 25 13 08 26 2009 13 25 14 08 26 2009 13 25 15 Record I4 4 10 If the us
115. ngs assigned automatically if your network supports this capability Otherwise You need to ask your network administrator for the appropriate IP settings Obtain an IP address automatically Use the following IP address IP address 172 16 190 1 Subnet mask 255 255 255 q Default gateway Use the following DNS server addresses Prefered ONS server Alternate ONS 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 100 Please see the figure below Revision July 2012 12 9 DUP B e System Setting e OFF 172 16 190 100 PAH 255255 0 0 0 0 OB 00 00 00 00 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 Wizard sol Help Press LP icon The following dialog box will pop up and ask the users to enter the password all passwords are the same password under Mo 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 password is entered the d icon will display on the tool bar at the left bottom corner 12 10 Revision July 2012 eserver Chapter 12 Recipe Access Exam
116. nistration SELEGT CREATE GRANT INSERT ALTER SUPER UPDATE INDEX PROCESS DELETE DROP RELOAD FILE CREATE TEMPORARY TABLES CREATE VIEW SHOW VIEW CREATE ROUTINE ALTER ROUTINE EXECUTE SHUTDOWN SHOW DATABASES LOCK TABLES REFERENCES REPLICATION CLIENT REPLICATION SLAVE CREATE USER Resource limits Note Setting these ootions to 0 zero removes the limit MAX QUERIES PER HOUR 0 MAX UPDATES PER HOUR 0 MAX CONNECTIONS PER HOUR 0 MAX USER_CONNECTIONS 0 9 12 Revision July 2012 eServer Chapter 9 Writing Data in MySQL A conformation message will be displayed as follows 4 Server localhost Charsets Eg Engines SePrivileges Processes 3 Export fi Databases 2 SQL Status Variables You have added a new user SQL query CREATE USER root i IDENTIFIED BY GRANT ALL PRIVILEGES ON TO rootie S IDENTIFIED BY WITH GRANT OPTION MAX QUERIES PER_HOUR 0 MAA CONNECTIONS PER_HOUR 0 MAA_UPDATES PER_HOUR 0 MAA_USER_CONNECTIONS O Edit Create PHP Code User root Edit Privileges Global privileges Check All Uncheck All Note MySQL privilege names are expressed in English Data structure Administration SELECT CREATE GRANT INSERT ALTER SUPER UPDATE INDEX PROCESS DELETE DROP RELOAD wl SHEIT OCA lvl FILE vl CREATE TEMPORARY TARI FS Revision July 2012 9 13 3 Setting Windows Firewall E Click St
117. nnections 4 Printers and Faxes ee Taskbar and Start Menu Power on PC and start Windows Click Start gt Programs point to Control Panel and then Network select Network Connections annections 12 20 Revision July 2012 E Control Panel File Edit View Favorites Tools Help Back Address Vg Control Panel Accessibility Odd Hardware Administrative Automatic BCE Date and Time e Switch to Category view Options bes Tools Updates Administrator 13 v a e gt See Also R i ca v Display Folder Options Game Intel Internet Keyboard h Windows Update Controllers Graphics Options Help and Support ga a iii RB lt gt Leet Mail Network Phone and Power Options Printers and Regional and Connections Modem Faxes Language Spaai and Scheduled Security Sounds and Speech System Taskbar and Cameras Tasks Center Audio Devices Start Menu OF User Accounts Windows Wireless Firewall Network Sek 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 a pa Search Folders Ei LAN or High Speed Internet Network Tasks B ocal Area Connmectio mn Create a new Connected connection A PRE Disable Change Windows Status Firewall settings Repair wt Disable this
118. nsfer From Delta HMI oo o i lia D After finishing the auto search please select IP address is 172 16 190 100 IF Address Setup Search IP in Ethernet HMI Name HMI Model HMI DOP B10E615 172 16 190 100 12348 HMI DOP BOYESIS lr 16 190 177 laa Press OK button to input authorize password default password is 12345678 Upload Authorize 12 4 Revision July 2012 oo eT aT At ev Ver Chapter 12 Recipe Access Example Input correct password then eServer will get HMI data like HMI Name IP address as below 3 Be Mode Setting Condition BRR Ho HII Name IP Port COMI z COMI z COM3 1 HMI 172 116 190 175 12348 Delta DVF PLO 12 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 File Name as Import16 H MA S d Select Format to RCP Set Destination Path destination location where the imported file is located f Enable Auto Refresh on Startup gt Rep Import e p Ea a cd a i Name Type HMI Name Importl 1 16bits HMI 2 E Tmports2tl 34bits HMI HAMAS E nE Aee e Documents and Settings TINA Q e Inport HYI RCP
119. nterface the default setting is USB driver Press Update button to update HMI firmware automatically Update Firmware Tool 1 3 WISH Driver Model Name Version AESOC16 1 08 AEgA0 1 08C AE1OC1E 1 08C AE10C100 1 08C gt AE1OC200 1 08C 7m R Ouse Ea Ethemet 510E615 3 0036 BOTE4145 3 0036 BOTES145 3 0036 7 About Update BOUSES15 3 0036 Mode Selection Start eServer To start eServer click Start gt Programs gt Delta Industrial Automation gt HMI gt DOP eServer 1 00 xx gt eServer Revision July 2012 12 1 A RELTA 12 1 1 New Project Start eServer and click File gt New or click New icon ge eServer i File View Wizard Tool Help oi ht X08 smR 4 P eServer 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 12 2 Revision July 2012 Logging ODBC Revision July 2012 12 3 Chapter 12 Recipe Access Example eServer 12 1 2 Node Click Ej icon to link HMI screen project file There are two methods available for selection Here choose Select Transfer from Delta HMI option to create a new node Select Transfer from Delta HMI Via Ethernet to search IP address of the connecting HMI Transfer Path Please select the Following 2 methods to 1 Select a exist Screen DOP file From stroed media is s sOOSOOOSOOSOCOCOCOCOCONONOCig 2 Ta
120. o continue Click on Next button to go to the next step Revision July 2012 10 3 Chapter 10 Writing Data in Oracle Ei g Serv r Oracle Database 10g Express Edition Install Wizard Choose Destination Location Select folder where setup will install files FATA ASE CEP IHT Setup will install Oracle Database 10g Express Edition in the following folder To install to this folder click Next To install to a different folder click Browse and select another tolder Oracle Database 10g Express Edition BSG016 K Destination Folder Choracleme Browse Space Required on L 1593016 K Space Available on C 112857005 K mb b f ai alla Hel lt Back Next gt 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 FATAB ASE ERFARNE BA Toe Enter and confirm passwords for the database This password will be used for both the SS and the SYSTEM database accounts Enter Password SESE SIS Confirm Password ESSN Note You should use the SYSTEM user along with the password you enter here to log in to the Database Home Page after the install i complete lt Back Cancel Then enter and confirm the password for the database Click on Next button for the next step 10 4
121. ol for Vista Mele Protect Your SOL Server on Windows Vicks Granting administative rights to Windows Visa user User te provision DELTACORP vodrgo carllo Windows Veta users that are member af the Windows Adrrinistraters group are not automaticaly crammed permission to connecttc SOL Server and they are nol culomatically grarted administratv anvieges Selecd the adninist ative pivilegee needed by Windowe urar DELTACO R P rodrigo cerlla Fovilages chat will b grantec to D LTACORP odrga camllo fy SCLEXPRESS OP Member co SOL Sever SysAdmin 2 07 SOLEXPRESS Available Inv leges a WYSGLEXPRESS AE Member of SQL Server SysAdmn role on MYSQ_EXPRESS 8 12 Revision July 2012 5 Access 2007 Setting Open Access 2007 and click Add New Database then click icon Getting Started with Microsoft Office Access o plates ei Pra j Cortacts Marketing pro ects gt rojects O A y 23 7 vy Blank Database Os Off N More on Utice Urne Create a Microsoft Office Access detebass that does Office Online aE rot ntan any existing data or objects Training Templales Duwilueds File Name What s new in Access 2007 z 2 Databace1 a i az The new Access 2007 contains Nore powerful tools Get tre latest contert walle working In tne 2007 c Us y d ril p arta ta aelp you quirkly track repat and share Micraictt Office istam ee i pekenga aka a pain gt budeto A
122. on July 2012 Appendix A Upload Download via Ethernet A 1 Environment Settings The default setting of upload and download on DOPSoft is via USB If the users need to use Ethernet please activate DOPSoft and select Options gt Environment to access the configuration options and change the upload and download setting Since Window Help Configuration Corrumiation Setting Alarm Setup History Buffer Setup Password setting Taz Table Pant Typesetting sound Setting Recipe 42 bits recipe Picture Bark Text Bank Sab macro Trutial Nlacro Backeround yvlacro Clock Nlacro Revision July 2012 A 1 In Environment dialog box change the default setting of upload and download to Ethernet Then press OK to complete the setting Environment syster Path D a a Output Path C Program Files Delta Industrial Automation DOPSoft 1 00 07 SerEditA ppitout ial Options Toolbars Windows Text Bar Bitmap Bar Soorm Bar Layout Bar Property Table Output Bar Upload Dowrload O USB O FPE COM Fort AutoSave Time Interval Auto Open Last File when starting ScrEchtor Center Drawing Area Include Picture Data when wploading Auto Convert Input Address To Tag Hame Auto reboot after fievrare upgrading Remstall HWI USB Driver Uronstall HMI USB Driver Revision July 2012 A 2 gt Communication Setting If the users choose to use DHCP mode please into Options gt Comm
123. ou would like to use the custom format in Excel please set the time stamp column and press right key of mouse into Format Cells to change the General type to Text type EJ Microsoft Excel Book JE File Edit View Insert Format Tools Data Window Help Number Alignment ia Font Border Patterns l Protection i Category Sample Number Currency Accounting Text Format cells are treated as Date text even when a number is in khe Time cell The cellis displayed exactly as Percentage entered Fraction QB Revision July 2012 eserver Chapter 4 Excel Sampling Setting 4 1 4 Register Setting This step is used to set the register address of the sampling data Wizard Lorene Register Setting x Please input logging address in the following Cell s RIESE 987654352105 1 2 a 4 To continue dick Next OO oen O Remark pares index which the sampling data will be Unchangeable Excel Cell which the sampling data will be written Unchangeable HMI Name Name of connecting HMI Register Address 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
124. p Link SOL Sever Lables lu eaisling auplice iu AD File Name O No applcatiar changes Help Cance Complete setup steps and click Finish Upsiz Wii ard Ihe Upsizing Weard has all the mfomaacn it needs to upsize your database Du yuu wean l wegen Lee resullriy AGP fie afta die upsizing operation is complete D Keep the Database fic open Revision July 2012 8 17 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Ea eaSer Ver After finishing setup steps and the below window will show then click Open Warning It is net possible to debermince that this content came from a trustworthy source You should File Fah C Wsers podrigo carillo Des lt toc Database 1105 adp This file might contain unsafe content that could harm your compute Do vou want to open this tle ar cancel the operation More information SQL transfering reporting will turn up and close it Ej d ee Word i ple FLU raa Tew File Twe More Refresh Excel SacrePoint FOF Fages Fages All List of XFS i More Data Close Preview Upszing Wizard Report Database Rime toa behea Corre ei oe ee ae aE L el Eros lane label Tae wa wkd r ees old 8 18 Revision July 2012 Bal eSer Ver Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 6 ODBC Setting Click Control Panel gt Administrative Tools gt Data Source ODBC then enter the User DSN and add a new item
125. pdates Administrator See also E3 E EZ F T E gt Display Folder Options Game Intel Internet Keyboard h Windows Update Controllers Graphics Options 4 Help and Support i G B gt eA ia w Mail Network Phone and Power Options Printers and Regional and Connections Modem Faxes Language 3 E o g Y Scanners and Scheduled Security Sounds and Speech System Taskbar and Cameras Tasks Center Audio Devices Stark Menu oF a User Accounts Windows Wireless Firewall Network Sek 3 2 Revision July 2012 eServer Chapter 3 Before Using eServer 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 s Network Connections m Es Ah F Fie Edit View Favorites Toos Advanced Help ae Back k J pe Search Wa Folders mi Address Network Connections iy G0 LAN or High Speed Internet ah Network Tasks ca Create a new a T connection meee Disable Change Windows Status Firewall settings Repair Disable this network a device Bridge Connections a Repair this connection mi Rename this connection View status of this Rename connection Change settings of this scale connection Create Shortcut 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
126. ple When eServer performs reading due to enable the auto refresh on startup eServer will execute import recipe to destination path But if disable the auto refresh on startup eServer will wait for 5 second then the eServer execute import recipe to destination path After import recipe user could examine and check if the saved file name is saved in the Import 6 190 destination path or not Please refer to the figure such as Wiknk2 a On the other hand if incorrect or invalid password is entered the following error message dialog box will appear to alert the users Ho Linkage HWI Password WII EEE l Fecipel H x Password input fail all passwords are the same password under No 1 Import Variance Setting a Select Variance b Check the check 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 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 Select Format as RCP f Set Destination Path destination location where the imported file is located g Enable Auto Refresh on Startup oe Rep Import
127. pling Cycle It is used to determine how long the sampling process IS repeated The time unit is ms Logging Condition Setting item Description Remark O No Condition number Unchangeable Sampling type There are two kinds of options for selection Const and Trigger Const Execute sampling repeatedly in a certain span of time 11 6 Revision July 2012 Descri Deseription a Execute sampling when the trigger conditions are satisfied HMI Name Name of connecting HMI TF Register Address and set Const time a 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 Revision July 2012 11 7 Chapter 12 Recipe Access Example Before creating testing example make sure to change the upload and download option Options gt Environment on DOPSoft 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 12 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 xx gt Update Firmware Tool After clicking Update Firmware Tool the following dialog box will appear for the users to select the communication i
128. r in obtain cedaut settings fortha acdiicnal corriquraten options Locin ID rocrigo carilla Password 8 20 Revision July 2012 Choose the corresponding database to be the default database E Creste temporary sored procedures for prepared SOL statements and Hop tis sored proradi Ou ahe yoa daome When you decannect and as epoccpnale while you zre noirne send Les ANSI ousted idantfisce F Les ANS rule paddinge and waminge m Lsa the ellower SQL Server f iHe prmery SQL Server is not avaiable Setup as below figure and click Finish to finish the ODBC setup Change Ure language uf SQL Server syslen messages lu C Uee etroarg encryption for data F Fefun bangali ui dharate tala m Uee regional zettinge when outputting cure icy number datae ana times C Save long unning quenes to he log fle CAUsers0 Ma CAR App DatasLocal Tempi Prowse Long que time riliseconce 30000 E Log ODBC dover statstcs to che bg fle CAUsers RODRIG CAR AppData LocalsTemp s Browse Revision July 2012 8 21 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Ria Servet ODBC setup completes and can testing DSN 8 22 ODBC Microsoft SQL Serer Set Anew DSC dara souca wil be created with tre following Gur fir alio Microsofi SGL Serve ODBC Diver Vesion 06 01 7600 Data Source Nome Serverl Data Source Descaption Sever ROAIR _LO LTPSSOLEXPRESS Da
129. r of characters by referring the user Length defined file name Controller Connecting controller Unchangeable Destination Path Destination location where the imported file is located Auto Refresh on Startup function for user could Auto Refresh on select when execute recipe at first No matter what the condition set to Trigger or Const if check auto AAUP refresh on start up function then eServer will execute Import or Export recipe at first time 11 4 Revision July 2012 a ia ee ga E a SOK Wat Chapter 11 Recipe Access Setting Export Fixed Bez Rep Export Mode Fixed v No Usage Name Type HMI Name Information Modify Recipe Auto Refresh on Startup 1 O Epot i6bits HMI Length 3 Group 3 0223 rcp o x Export Variance as i Rep Export Mode Emre z Usage Hame Type HWI Hame File Marne File Hame Length Controller source Fath Auto Refresh on Startup l L Exportl tl l bits HMI 100 4 Intermal Memory C1 2 E Exportsa l 32 bits HAI Hone l E Description Remark No Excel Sheet index which the sampling data will be Unchangeable written Besa If the users want to select 16 bit recipe enable J this option by checking the check box Modify Recipe Edit recipe directly for selected file It is the register address of a certain trigger File Name element Note The register only could be set to Word File Name Number of characters by referring the user
130. r uugraved iislances use Leese louis Lo idercily ard disable wiused fealures se viuse and prulucols Users will advirissalive privileges un Micmsul Windus Wisla ad bler versivns willna unge hare adil clite arvleges on this SQ Server nstallatoan by celal Ta eexpircitl acd yourseF as a SO Ssnver administrator click on the welus liik i Read nor about configurnng the SAL Server surface arez Conhiqure Su lace Area for localhosl charge arp tan as Surface Ares Configuration for Services and Connections Ta suTarte Area Configuration tmr Featines Revision July 2012 8 11 Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7 Ria eServet Choose authority of server to user After choosing click gt L E x e Help Protect Your SOL Server on Windows Vista Granting adrministative rights to Windows Vista user User te provision DELTACO RF rodrga carlo Windows Veta users that are member of the Windows Adririsraters group are not autameticelhy crarced sermission to conmecttc SOL Server and they are nol culomatically granted administratv aivleges Selecd the advinist tive pivilegee needed by Windowe ueer DELTACORP wodriga cerrllo Avaliable onvleges Frvvleges hat will b grantec to J LTACORP sodrga calla WYSGLEXPRESS A Member of SAL Server SyzAdmnirole on MYSQ_EXPRESS SOLFEXPRESS Wanker Click OK and finish the setup er Provisi illo on ROARRILL it mee i SQL Server 2005 User Provisioning To
131. ress Properties button Local Area Connection Properties General Authentication Advanced Connect using ES Intel R PROA1000 MT Network Con This connection uses the following items Client for Microsott Networks Z File and Printer Sharing for Microsoft Networks 2 gas Packet Scheduler E Internet Protacal TCP IP Install Description Uninstall Properties Transmission Control ProtacolInternet Protocol The default Wide area network protocol that provides communication across diverse interconnected networks Show icon in notification area when connected Notify me when this connection has limited or no connectivity ox Cerea 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 12 30 Revision July 2012 eServer Chapter 12 Recipe Access Example Internet Protocol TCP IP Properties General fou can get F settings assigned automatically if your network supports this capability Othenwise you need to ask Your network administrator for the appropriate IF settings Obtain an IF address automatically Use the following IP address IF address Tf2 16 190 1 Subnet mask 255 255 255 Q Default gateway Obtain ONS server address automatically Use the following DNS server addresses Prefered ONS server Altern
132. rganize all your cbyecks using Lhe mew easy access Edit the table name Table1 and create data column date datal data2 TE Ery Hame Create Futernal Mata Natabhace Tools q i EFA p Pros aE md A helete Bows View Primary Builder Test Vocation Property Indexe Kay Fules rion Lookup Column zhet View Showy hice All Tables _ ia Taldel A Data Type EA tablet Table AutoNumber Execute Database Tool gt SQL Server Ca E ee ab c Too Ms i 7 P j Hame Create Futernal Mata Database Tools Arrnhak Design ES Tg kun Macro aS I Froperty sheet 24 Database Lorumenter Hig Create Shortt Menu from harrn See Object Mependencies 4A Analyre Perfcrmenre YBa ema Relaticnships Basle We Convert flacoos to Visual Basic fa Message Bor Bee Analyze Table Macro Showy lide Analyze All Tables ooon Talle x FAA table Table dataz Text 8 14 Revision July 2012 Select Create New Database and click Next Step Upsizing Wizard lhe Upsizng Weerd allows you to easily upsize your HiTosaft Access database to a Microsoft SO Server catabace You car Teate a nen SOL Server database cr upsize to an exastog SOL Server databare Which do you want to do B Ater you dick the Neact butten you ll supply information for the new database Fih Choose SQL Server instance to use and input the name for new SQL Server Database which is transferred from
133. rk Diagnostics for Windows P Remote Assistance Remote Desktop SMLM Proxy Module HP1006M C EXE UPnP Framework Windows Live Messenger 3 1 Windows Live Messenger 8 1 Phone l i Windows NetMeeting Add Program Add Port Edit Display a notification when Windows Firewall blocks a program what are the risks of allowing exceptions m 7 2 Revision July 2012 Ria eSer Vet Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Click Add Port button and the following Add a Port dialog box will appear Add a Port Use these settings to open a port through Windows Firewall To find the part number and protocol consult the documentation for the program or service you want to use Fort number 1433 TCP UDP What are the risks of opening 4 port 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 selected 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 Windows Firewall General Exceptions Advanced Windows Firewall is
134. ry ul Create new table on database test Number of fields 13 The recorded data will be shown at the bottom of the window Revision July 2012 9 27 wal 3 Server localhost gt Database test gt Table table1 E Browse Structure 2 SQL Search cinsert ffjExport Ej Import Operations Empty Drop Showing rows 0 29 109 total Query took 0 0392 sec SQL query SELECT FROM table1 LIMIT 0 30 Edit Explain SQL Create PHP Code Refresh Query results operations Sp Print view amp Print view with full texts Export row s starting from record Page number in mode and repeat headers after cells Time 10 19 2009 18 25 07 10 19 2009 18 25 08 10 19 2009 18 25 09 10 19 2009 18 25 10 10 19 2009 18 25 12 10 19 2009 18 25 13 10 19 2009 18 25 14 10 19 2009 18 25 15 Ul T gt al ee O RE lees ares Tei eee jas oOo 7 xX Mae ates rye lets 9 28 Revision July 2012 Chapter 10 Writing Data in Oracle Before creating testing example make sure to change the upload and download option Options gt Environment on DOPSoft 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 10 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 Orac
135. s 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 MySQL via ODBC interface and save the collected data into the specified folder C Data 9 1 1 Software Installation 1 AppServ Introduction AppServ is a free and full featured software of Apache HTTP Server MySQL PHP and phpMyAdmin To download it go to http www appservnetwork com Package of AppServ Apache HTTP Server It is a free and open source HTTP Server MySQL It is a relational database management system PHP It is a free and general purpose scripting language designed for web development 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 com Revision July 2012 Open File Security Warning The publisher could not be verified Are you sure you want to run this software Name appserv wind2 2 5 10 exe Publisher Unknown Publisher Type Application From C Documents and Settings shirley laiiDesktop Mancel Always ask before opening this file This file does not have a valid digital signature that verifies its pu
136. s 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 Ace Import Usage Hare Type HWI Marne File Harme Forriat Destination Fath Auto Refresh on Startup l U Tmportl tl l bits HMI Importl _sHr hI RCF C Documents and Settings TIHA LEE a Ll Imports2 1 34bits HMI Importa Holy ROP L Import Variance eo Rep Import Mode Variance v No Te Name Type HMI Name File Name File Name Toreth Format Controller Destination Path Auto Reiiesh on Startup 1 pa Importl 1 l bits HMI 100 4 RCP Internal Memory C Documents and Settings TINA Q L _ 2 Import32 1 32bits HMI None 1 RCP E setting tem Description remark No Excel Sheet index which the sampling data will be Unchangeable written desea If the users want to select 16 bit recipe enable J this option by checking the check box Recipe display name Recipe Bit type Unchangeable HMI Name Name of connecting HMI Unchangeable 1 When Fixed is selected It is the file name of the imported file which could be changed and user defined File Name 2 When Variance is selected It is the register address of a certain trigger element Note The register only could be set to Word Provide user could save recipe as RCP and CSV file File Name Numbe
137. se Press Finish button to complete the settings Then click Design in the following pop up window to create a database table in Design view E adp1 Project DELTA Access 2000 file format Sele OUeres Database Diagrams Forms Reports Pages Macros Modules Groups Favorites 7 6 Revision July 2012 In the Table dialog box create a database like the following figure shown below BELG Table Data Type Length allow Mulls char s y char char l Columns Default value Precision Identity Identity Seed Identity Increment Ts Rowiauid Formula Collation lt database default Format Decimal Places Input Mask After editing the table close the window to give a name for this table such as Table 1 ox amp Table1 Table Data Type Length Allow Nulls 50 yf Choose Name Enter a name For the table Cancel Help Columns Default value Precision Identity Identiti Seed Identity Incr Ts Romada Formula Collation lt database default Format Decimal Places Input Mask Click OK button and the following warning dialog will pop up Revision July 2012 7 1 Please press No button to complete the settings Microsoft Office Access There is no primary key defined Although a primary key isn t required it s highly recommended A table must have a primary key
138. soft Office Outlook 2003 n Delta Industrial Automation gc Microsoft Office PowerPoint 2003 Microsoft Office Publisher 2003 1 4 Revision July 2012 Ria eSer ver Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Then click New icon and choose Project using new data to open a new database file and set the directory to C Data FJ Microsoft Access IE x Eo i pn ea Type a question for help File New Database x New Save in v AIA X Gy EB gt Toos Blank database My Recent Documents 3p From existing file Templates Search online for peN Templates on Office Online On my computer My Network Places Save as type Microsoft Office Access Project adp ses 2 Ready NUM Press Create button to enable Microsoft SQL Server Database Wizard Microsoft SOL Server Database Wizard what SOL Server would you like to use For this database ocal or the name of the donnecting SQL Please specify the login ID and password of an account with CREATE DATABASE privileges on this server Use Trusted Connection password yassword 0000 what do you want to name your new SOL Server database Finish Press Next button to continue Revision July 2012 7 5 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System Rial eSer vet Microsoft SOL Server Database Wizard The wizard has all the information it needs to create your SOL Server databa
139. tabase Dstabase 1 SGL Lancuage Detaull ranzlate Character Dats Yee bay Jung Running Queries Nu Log Orver Statistics No Uas Regonal Scttinca ho Preparec Statements Option Crop temporary procedures on dis oannect Uss Teilover Server Na Use ANSI Qued dente Yes Uss ANSI Yull Faddngs and Wamirgs Yes Daa Biwrypliwi Ao TestDate Suse l C ra Revision July 2012 8 1 2 Create HMI Project File Start DOPSoft software program and click File gt New to create a new project Then click Element gt Input gt Numeric Entry to create a numeric entry element 100 on the screen In this case BLOE615 series HMI is used TE C Documents and Settings TINA Q LEE DELTA 000A fiy example dps DOPSoft File Edit View Element Screen Tools Options Window Help See xa BM RE H l ho AAJ amp h AAS AL AAA A AY BTU Languaget Fai E E an e a E a Qanman N aA amatas oP eRT eI a e 2 1 Screen_1 itoperty Screen _1 v O Screen Name Screen _1 Screen Properties Detail Background Color _JRGB 252 252 252 A Screen Macro a Screen Open Macro 0 E Screen Close Macro 0 Screen Cycle Macro 2 Width 1024 Height 600 Output ox Step Action gt J Delete element gt 5 Delete element gt 4 Modify element property gt 7 Modify elernent property Record Ouput HH a a a le ya FF ii EH HE eos Download USB 892 274 DOP B10E615 655
140. tcut Other Places a EKE jJ FE G Control Panel ff Local Security Policy SLEEN Performance Shortcut Aa HF Shortcut E My Documents 2 KE A ZEB GA he Caraciiker In the ODBC Data Source Administrator dialog box select System DSN tab and click on Add button to add system data source ODBC Data Source Administrator Sistem 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 on this machine including NT services OK Cancel Apply Help 9 16 Revision July 2012 Select MySQL ODBC 5 1 Driver and then click on Finish button Create New Data Source Select a driver for which you want to set up a data source Microsoft ODBC for Oracle Microgott Parados Oriwer db Microgott Paradox Treiber db Microsoft Text Driver tek cev Microgott Text Treiber tat cev Microgott Visual FoxPro Driver MySQL ODBC 5 1 Driver iw cancel Now specify the Connection Parameters as mentioned in the below dialog MySQL Connector ODBC Data Source Configuration am Myst Connector ODBC Connection Parameters Data Source Mame eServer Description Server localhost Pork 3306 User rook Password ee Database Details gt gt Cancel Help Connection Parameters Data Source Name Enter ODBC data sour
141. timedia More Database Downloads Windows le Revision July 2012 10 1 Then accept the license agreement and download OracleXEUniv exe which is the multi byte Unicode database for all language deployment Oracle Technology Network Database Database Express Edition Database 119 Overview Downloads Documentation Community Learn More Popular Downloads Database Focus Areas Berkeley DB Database Options Oracle Database 10g Release 2 10 2 0 1 Enterprise Manager E nee tae Express Edition for Microsoft Windows Database EE and XE Database Upgrade You must accept the OTN License Agreement for Oracle Database Express Edition to download this Enterprise Pack for Eclipse Berkeley DB sai Fusion Middleware D Decline License Agreement _ TimesTen In Memory Database Java EE amp GlassFish Database 109 Oracle Database 10g Express Edition Western European Java SE OracleXE exe 165 332 312 bytes Single byte LATIN1 database for Western European language storage with the Database Database Lite JDeveloper and ADF RDB Homepage user interface in English only MySQL Audit Vault Oracle Database 10g Express Edition Universal NetBeans IDE Secure Backup OraclexXEUniv exe 216 933 372 bytes Solaris Multi byte Unicode database for all language deployment with the Database Homepage user a or Real Application Clusters interface available in the following languages Brazilian Portuguese Chinese Simplified
142. tinue 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 1 Select a exist Screen DOP file From stroed media After searching HMI IP in Ethernet select HMI Name is HMI IP is 172 16 190 100 press OK Revision July 2012 10 17 IF Address Setup IP Address Search IP in Ethernet HMI Mame HMI Model HMI DOP BIOEG1S eServer will ask user to input the authorize password to connected with HMI The default password is 12345678 Upload Authorize Cancel Press OK button to go to next step 6 ODBC Data Source Setting Create an ODBC Data Source pointing to your database Please refer to the following settings and press refresh button to select table 10 18 Revision July 2012 EZ a Ser Wat Chapter 10 Writing Data in Oracle Wizard Logring ODBC Please indicate the Following items Chooses a data source DSW and input user name and password ODBC Data Source OraclesOe User Name system Password ee Database Driver Oracle Table ORACLETABLE ORACLET ABLE Time and Date Table Feld Detail Starp ORACLET TIME rdin rH vol To continue click Mext Press Next button to go to next step 7 Register Setting Set the register address of the sampling data Revision July 2012 10 19 Wizard Logemgs Ed Reg
143. trigger element In this case the trigger element is a maintained button element and its address is set to 0 0 c Select Format as Rising edge Mode Setting p E Hame d HWI Harme Controller Exportl 1 intemal Memory 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 172 16 190 100 are the same otherwise HMI may not be displayed in the list when finding node 12 28 Revision July 2012 zo S Server Networking Settings Chapter 12 Recipe Access Example Ensure to observe the following instructions to complete PC networking settings before eServer operation Setting PC Network Programs Documents lettings Search Help and Support Run Windows XP Professional Shut Down Control Panel Network Connections F Printers and Faxes Ta askbar and start Menu Power on PC and start Windows Click Start gt Programs point to Control Panel and then z Network select Network Connections annections E Control Panel File Edit wiew Favorites Tools Help x pi Fa Search Wee Folders amp amp Accessibility Odd Hardware Options Folder Options Display co Back Address Vg Control Panel x Ea Switch bo Category View See Also Sp Windows Update 2 Help and Support Ss Scheduled Tasks Scanners and Cameras Windows Firewall User Accounts E Ad
144. und in database 3 Create new table on database test Name table 1 Number of fields ao Open new phpMyAdmin window Revision July 2012 9 9 Complete the settings by referring to the figure below and press Save button to save changes ta Server localhost f Database test gt Table table1 Field Type Length Values Collation Attributes Null Del Data VARCHAR 50 lel vj i I nota f Data2 VARCHAR 50 vy oY notte Table comments Storage Engine Collation ee ee v l z Or Add 1 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 or a single quote amongst those values precede it with a backslash for M example xyz or a b 2 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 4 Server localhost Database test gt EJ Table table E Browse fF Structure SaL J Search clinsert S Expot fZiimport E Operations Empty Drop a Table test tablet has been created SQL query CREATE TABLE tablet Time VARCHAR 50 NOT NULL Datat VARCHAR 50 NOT NULL Data VARCHAR 50 NOT NULL ENGINE MYISAM Edit Greate PHP Code Field Type Collation Attributes Nul Default E
145. unication Setting gt Ethernet gt LocalHost to enable Obtain an IP address automatically Communcaton Sethng Corinuncation Setting Device LocalHost SMITF Localhost fe Chrenaite IF Ethernet uploadidowndoad port Modbus TCP Server Port Application eRermoteleserver Enable eh Peed 12345678 ocan Tire 100 Fort _ Corm Interrupt RE times then ignore Revision July 2012 A 3 Appendix A Upload Download via Ethernet Eid 2Sey Ver If the users choose to use user defined IP address please into Options gt Communication Settings gt Ethernet gt LocalHost and set HMI IP Address then ensure that the domain name Is the same as the IP address of the personal computer Communcaton Setting Corinuncation Setting Device LocalHost SMTP Localhost Ovenyrite IF Obtain an IF address automatically HMI IP Address 1 I Ta i 190 11 subnet Wask 255 455 455 U Gateway IP uploadidowndoad port Modbus TCP Server Port Application eRermoteleserver Enable eh Perwa 12345678 ocan Time 100 Fort _ Corm Internypt Eas times then ignore After Ethernet IP address is set the users can enter into the system menu to verify if the IP address is written correctly or not A 4 Revision July 2012 a Sra PE fr 4 BAAR EC ube Back Home iJ Nest la B f HMI Name HMI DHCP VOFF IP fae Vrs Programs Documents settings IE Control Panel
146. uthorize password to connected with HMI The default password is 12345678 Upload Authorize Press OK button to go to next step 6 ODBC Data Source Setting Create an ODBC Data Source pointing to your database Please refer to the following settings and press refresh button to select table Revision July 2012 9 23 Chapter 9 Writing Data in MySQL Bid a Ser Ver Wizard Logrme ODBC Please indicate the Following items Chooses a data source DSW and input user name and password ODBC Data Source eServer User Mame root Password kuta a ats ts s pa Database Driver My SOL Table table table 1 Time and Date Table Feld Detail Starp table Datal Por yodl roy rH sal To continue click Mex Press Next button to go to next step 7 Register Setting Set the register address of the sampling data 9 24 Revision July 2012 Wizard Logging Ed Register Setting Please input logging address in the following Cell s To continue dick Next 9 Set the sampling conditions to constant 5s Press Next button to continue Wizard Logring Logging Condition The Condition will provide 2 solutions to help you easy create parameters For trigger condition RR Detect Scan Time How long would yau like on Your logging data 500ms one day To continue click Mex Revision July 2012 9 25 9 Press LE icon After the password is entered the system will start sampling operation
147. vet Communmcaton Sethng Coronurication Setting Device LocalHost SMTP Localhost EE Chrenatite IF Obtain an IP address automatically HWI HII HWI IP Address Via Subnet ask Ethernet Gateway IP uploadidowrdoad port Modhe TOF Server Port Application eRemoteleserver l Enable Ep Pasewrord 12345678 scan Tire 100 Port 12348 Come Interrupt ag times then ignore 7 14 Revision July 2012 Ria eSer Vet Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 7 1 3 eServer Setting 1 After eServer is started eServer window will open g eperver File View Wizard Tool Help MATEA MENETI P eServer eServer Initialize 4 Select icon to enable ODBC Logging Wizard E E Logging Logging Recipe Excel ODBC Access New Project Name ODEC Location C Documents and Settings Tina Lee Desktop Ol esd Add to the current project Revision July 2012 7 15 Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System 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 5 Click New icon to access nodes link to HMI Wizard Logging fx Linkage eServer will need some information such as communication setting symbol etc And Linkage will help you how to link original project information
148. xcel ODBC New Project Name Locaton Revision July 2012 11 1 Chapter 11 Recipe Access Setting eServer 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 Select a exist Screen DOP file from stroed media CAD ocuments and settings shirley laH y Documents Dema la IP Addess 172 2 Tansfer from Delta HMI 2 Transfer from Delta HMI Transfer the HMI screen project file via network communication directly Transfer Fath Please select the Following 2 methods to 1 Select a exist Screen DOP file From stroed media After searching HMI IP in Ethernet select HMI Name is HMI IP is 172 16 190 100 press OK 11 2 Revision July 2012 eserver Chapter 11 Recipe Access Setting IF Address Setup IP Address Search IP in Ethernet HMI Mame HMI Model HMI DOP BIOEG1S lz 16 190 100 2343 eServer will ask user to input the authorize password to connected with HMI The default password is 12345678 Upload Authorize Cancel Revision July 2012 11 3 Oo a Te Chapter 11 Recipe Access Setting Bid Ser Vet 11 1 2 Register Setting This step i
149. xtra Action Time varchar 50 utf8_general_ci No E f x BT Data1 varch ar50 utf8_general_ci No I 7 x Data2 varchar 50 utf8_general_ci No fe z H fo t CheckAl Uncheck All With selected E A Se Print view Propose table structure 2 Add 1 field s At End of Table At Beginning of Table OAfter Time Indexes Space usage Row Statistics Type Usage Statements Value fh No index defined Data O B Revision July 2012 207 te E a Ser Ver C Create New User Chapter 9 Writing Data in MySQL Click on Privileges link to open User overview page localhost fa Server version 5 0 51b community nt log Protocol version 10 Server localhost via TCP IP User root localhost MySQL charset UTF 8 Unicode utf8 MySQL connection collation utf unicode ci oCreate new database Collation Show MySQL_ runtime information eI Show MySQL system variables Processes KilCharacter Sets and Collations Storage Engines I gt Reload privileges Databases Expor falmport Log out phpMyAdmin 2 10 3 t MySQL client version 5 0 51a F Used PHP extensions mysql amp Language English 7 wa Theme Style Original t Font size 100 v ElphpMyAdmin documentation EjphpMyAdmin wiki fat Official phpMyAdmin Homepage F ChangeLog Subversion Lists phpMyAdmin Click on Add a new User link to display the add new user page

e-Server-User Manual(CURVE).cdr

Contents

Download Pdf Manuals

Related Search

Related Contents