Home
Display - Service, Support
Contents
1. Cells B4 B8 will display the roles of the OSx stations Cells A4 A8 will display the station names Figure A 8 Node_Roles Function SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 13 Using the aGlance Cold Link Functions continued Null2Blank Excel reads a null text string as no change and does not update the cell For example if the value of a TEXT tag changes from Boiler 1 On to null empty then Excel sees no change and continues to display Boiler 1 On in the cell The Null2Blank command replaces the null value with blanks that Excel can read as a changed value Whenever you intend to request data from a tag attribute that is a text string for either a hot or a cold link run the Null2Blank command from the Command function first Figure A 9 e ServerName field the prefix osx must appear in front of the OSx station name Command field enter nul12b1anx in this field InputRange field OSx does not use this field for this function OutputRange field OSx does not use this field for this function aGlance IT Macro Tool x AAG Functions ServerName A 3 osxstation1 Command nul12blank InputRange OutputRange Try it Paste it Help Pause Close Paste it Cell 1 2 3 4 5 6 7 8 9
2. Entries that you type from the keyboard are indicated with the courier font Items that you select on the screen or keys that you press on the keyboard are indicated with this bolded font Items that you select on a cascaded menu are linked in the manual text with arrows The first term indicates where to click the main menu bar For example Controls gt Change System State tells you to click Controls on the main menu bar then select Change System State from the pull down menu Controls Startup Change System State Change System Stat wv Operate Logoff wv Offline Logon V Shutdown OSx OSxiterminal 4 Shutdown OSx and Linux OK Cancel viii Preface SIMATIC PCS 7 OSx 4 1 2 aGlance The Other Manuals The SIMATIC PCS 7 OSx manual set consists of several manuals If you cannot find the information that you need in the SIMATIC PCS 7 OSx aGlance User Manual refer to these other manuals SIMATIC PCS 7 OSx System Administration Manual This manual describes how to configure network nodes and printers and how to archive data and back up files SIMATIC PCS 7 OSx Process Configuration Manual This manual describes the primary tasks required to configure your OSx station for controlling your process SIMATIC PCS 7 OSx Graphical Editor Manual This manual describes how to create the graphical displays used with OSx SIMATIC PCS 7 OSx Hardware Manual This manual describes the various hardware components of the sys
3. If OSx is running select Controls gt Logon on the menu bar and log in as root Click Controls gt Change System State and select Shutdown OSx Press the left mouse button to bring up a root menu select New Xterm and log in as root Inbertithe CD iwith thetitle BIMATIC PCS 7DOSx V4 1 2 Disk Gn the CD ROM drive Type install new and press Enter The screen prompts you for the SIMATIC PCS 7 OSx Options Activation Key Enter the key exactly as it appears on the options license A list of options appears that includes all options that are currently licensed for the station For example Number Installed Licensed Description 1 Yes Yes E4 1 2 Supervisor S W 2 No No E4 1 2 HP X Terminal S W 3 Yes Yes E4 1 2 Tektronix X Terminal S W 4 No No E4 1 2 RDT Oracle S W 5 No No E4 1 2 RDT Sybase S W 6 No No E4 1 2 One User OSx aGlance Server S W 7 Yes Yes E4 1 2 Ten User OSx aGlance Server S W If this is a supervisory station or if other options have been previously installed the above list appears first and you are then prompted to enter the new OSx Options Activation Key Your new key includes all previous options licensed for this station as well as aGlance Installation of aGlance begins and may take several minutes When the installation is complete the following prompt appears Enter the number of an option to install re install or enter a new OSx Options Activation Key or enter q to quit Type q
4. requested data points StatusRange E 3 F 10 Try it Paste it Help Pause Close Cells E3 F10 will display error messages if any Figure A 14 GetHistory Function SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 21 Using the aGlance Cold Link Functions continued GetHistStat GetTags The GetHistStat function is not supported by OSx Use the GetTags function Figure A 15 to retrieve a list of tag names ServerName field the prefix osx must appear in front of the OSx station name MatchString field optional enter a text search string You can use the standard wildcard match any and match single characters StartIndex field optional enter an integer or cell reference with the integer as the contents of the cell The server uses the index as a placeholder when there is more data to return than there are output cells The default is zero which directs the server to return values starting at the beginning of its database If you use a cell reference you can view the entire list by pressing Try it without having to enter a new StartIndex every time OutputRange field select one or more cells to display the data requested from OSx A non zero index value in the upper left corner indicates that the server has additional data to send Use this index value in subsequent calls to retrieve additional tag names To take advantage of this feat
5. When using hot links reduce the number of points per hot link as the rate of change of the points that you are monitoring increases This allows the server to keep up with rapidly changing data and to send that information to the client Different Values for Monitors hot links and Excel aGlance macro requests for data cold links the Same Data may return different values for the same data point Values greater than Point 32767 stored in the OSx database are displayed as negative values in a monitor request while displaying correctly in an Excel aGlance macro request For example 32769 in the OSx database is displayed as 32769 in an Excel aGlance macro request for a data point but is displayed as 32767 in a monitor request for the same data point Version 3 2 of the Excel aGlance Add in corrects this problem Closing a Session To end an OSx aGlance session you can use the macro tool and select the Disconnect function or you can exit Excel It is not necessary to log off OSx SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 9 A 3 Some Guidelines A 10 Using the aGlance Cold Link Functions Consider the guidelines below as you use the Excel add in macros to create cold links to the process When you display a macro function you must fill in the function fields before executing the function For fields that do not require ranges you can either type the data directly in the field or click a cell cont
6. B 3 Command client_login InputRange B 4 B 5 OutputRange Try it Paste it Help Pause Close Paste it Cell 1 2 3 4 5 6 7 8 9 Figure A 7 Client_Login Function A 12 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance Node_Roles Use the Node_Roles command Figure A 8 with the Command function when you need to know the current roles for the OSx stations If you send the Node_Roles command to a station that is out_of service all station are reported as out_of service even if they are not e ServerName field the prefix osx must appear in front of the OSx station name e Command field enter the following node_roles InputRange field OSx does not use this field for this function e OutputRange field select a double column of cells to display the names and roles of the Osx stations l m T fi i A aGlance IT Macro Tool x osxstation1 AAG Functions command ServerName A 2 Node1 Primary_Role Node2 Backup_Role Command node_roles Node3 Sysadmin InputRange Node4 Normal_Role Node5 Out_of_Serv X Try it Paste it Help Pause Close Paste it Cell A 4 B 8 OutputRange 1 2 3 4 5 6 7 8 9
7. Figure A 9 Null2Blank Function A 14 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance Disconnect Use the Disconnect function Figure A 10 to end a session with the server For the ServerName field the prefix osx must appear in front of the OSx station name osxstation1 AAG Functions Disconnect ServerName A 3 Try it Paste it Help Pause Close Paste it Cell OSNO AORA o N e Figure A 10 Disconnect Function SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 15 Using the aGlance Cold Link Functions continued Get Use the Get function Figure A 11 to retrieve a list or a table of individual tag attribute or tag attribute bit data values e ServerName field the prefix osx must appear in front of the OSx station name e Tag Range field select the range of cells that contain the tag names for the requested data values e AttrRange field this field is not optional for OSx The AttrRange is a range of cells that contain tag attribute names or tag attribute bit names The bit specified must be in the bit_defs relation for that attribute OutputRange field select one or more cells to display the data requested from OSx e StatusRange field optional select the range of cells to display any error messages that occur This range must contain the same number of
8. cells as the OutputRange A osxstation1 AAG Functions ServerName A 2 TagRange C 1 E 1 AttrRange B 2 B 4 000 jon ON OutputRange Z C 2 E 4 StatusRange Try it Paste it Help Pause Close C 6 E 8 aste it Cell Cells C6 C8 D6 D8 and E6 E8 Cells C2 C4 D2 D4 and E2 E4 will display error messages if any will display the requested values Figure A 11 Get Function A 16 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance GetAttributes Use the GetAttributes function Figure A 12 to retrieve a list of attribute names for a set of tags e ServerName field the prefix osx must appear in front of the OSx station name e TagRange field select the range of cells that contain the tag names for which you need attributes e MatchString field optional enter a text search string You can use the standard wildcard match any and match single characters e StartIndex field optional enter an integer or cell reference with the integer as the contents of the cell The server uses the index as a placeholder when there is more data to return than there are output cells The default is zero which directs the server to return values starting at the beginning of its database If
9. error messages that occur This range must contain the same number of cells as the OutputRange You can however extend the size of these cells refer to the Excel manual for a procedure F aGlance IT Macro Tool x osxstation1 10 00 00 Error 10300 Invalid tag specified AAG Functions SetHistEvent y Server Name 453 y i TagRange C 1 AttrRange C 2 Startindex 0 OutputRange 1 C93 C510 StartTime 10AM FRI EndTime 12PM FRI lo bo by bs bn le oo ro be y La RBR TimeRange B 3 B 10 StatusRange sps3 p 10 Cells B3 B10 will display the _Iry it Paste it Help _Pause Close appropriate time for each data point Paste it Cell Cells C3 C10 will display the oo requested data points Cells D3 D10 will display error messages if any Figure A 13 GetHistEvent Function SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 19 Using the aGlance Cold Link Functions continued GetHistory Use the GetHistory function Figure A 14 to retrieve a list of historical trend values interpolated across a time period ServerName field the prefix osx must appear in front of the OSx station name Tag Range field select the range of cells that c
10. 16 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance Input enter the values that you are writing e Status Range optional but recommended designate a location to display error messages This location must be the same size as the input location e List Counts enter integers to represent the number of tag names and the number of attribute names Refer to the user documentation that accompanies your client software for more detailed information OSx logs all tag value changes to the OSx database in the Operator Change Log with the last eight characters of the IP address in the place of the User ID SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx OaGlance 1 17 Using the SIMATIC PCS 7 OSx aGlance Functions continued Monitoring Tag Values Hot Links To establish a hot link that monitors a list or a table of tag attribute data values continuously your client must issue function calls to initiate the hot link to retrieve the data and to close the hot link Refer to the user documentation that accompanies your client software for more detailed information about how to issue these functions Your client must provide the server with the following parameters in one or more of the function calls Server Name the prefix osx must appear in front of the OSx station name Tag Names designate the tag names for the requested data values Attribute Names designate the attribute names
11. 2 describes how to plan your interface with OSx e Section 1 3 describes the installation procedures e Section 1 4 describes the functions supported by aGlance e Section 1 5 suggests troubleshooting strategies e Appendix A describes how to use aGlance with Excel If You Need Help If you have difficulty with your system contact the Siemens Energy amp Automation Inc Technical Services Group in the U S A at 800 333 7421 A Outside the U S A call 49 911 895 7000 SIMATIC PCS 7 OSx 4 1 2 aGlance Preface vii Conventions Used The procedures in the various manuals give you step by step instructions in the Manual Set about how to carry out tasks Typically the last step of any procedure requires that you select the OK or Save button or press Enter To save space and avoid redundancy this last step does not appear in the procedure However you need to finish each procedure with one of these actions OK OK Saves information that you have entered and closes the window Save Saves information that you have entered and does not close the Save window Cal Cancel Closes the window without saving any information that you entered and terminates any action that you initiated Dismiss Dismiss Closes the window without undoing any changes that you have entered However if you press Dismiss before you press Enter the changes that you made are discarded The different fonts used in the manual set have the following meanings
12. 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance Any application that is compatible with Axeda s aGlance IT can communicate with the aGlance server Siemens offers two aGlance client packages as options These are the Standard Edition client and the Professional Edition client The aGlance IT Standard Edition includes the following components e Add ins for Lotus 1 2 3 and Excel provide access to aGlance IT client functions as spreadsheet macro functions Ease of use tools allow you to browse through process data without ever writing a macro function e The aGlance IT DDE Bridge allows all DDE client capable applications including Excel and Lotus 1 2 3 to hot link to process information systems through aGlance IT Client applications receive notification of changes in process values e aGlance IT client applications developed using NetOLE the aGlance IT VB custom control or the aGlance IT C API can be deployed In addition to the features of the Standard Edition the aGlance IT Professional Edition enables you to develop clients in Visual Basic and Visual C C Once you have developed the Visual Basic and C C programs using the Professional Edition you can deploy them using the aGlance IT Standard Edition e The aGlance IT client API is implemented as a VB custom control VBX This enables the developer to use all the standard VB language features such as Variant variable types and On Error GOTO when deali
13. Disconnect function 1 19 from Excell A 15 E Ending a session 1 19 from Excel Error messages Excel cold links A 4 hot links macros opening a session F Functions Excel client_login get attributes ll put A 24 put history A 25 Index 1 Functions continued OSx supported disconnect 1 19 get attributes get history 1 14 get histor event 1 12 get tags 1 10 hot link 1 18 node_roles 1 9 null2blank OSx login put G Get attributes function 1 11 from Excel Get function from Excel Get history event function 1 12 from Excel Get history function from Excell A 20 Get history status function 1 9 from Excel Get tags function from Excel History event getting 1 12 from Excel History status getting 1 9 from Excel History getting from Excel History writing 1 9 from Excel Index 2 Host station changing 1 6 choosing 1 6 connection type station role Hosts file editing 1 8 editing from Excel A 2 Hot link in Excel system capacity 1 6 troubleshooting A 8 Hot link function 1 18 Installation client 1 8 PCS 7 OSx aGlance 1 7 IP address 1 6 1 8 editing from Excel A 2 L Link See Hot link and Cold link ListServers function from Excel Logging into OSx from Excel M Monitoring tag values 1 18 N Node roles command 1 9 from Excell A 13 Null
14. PCS 7 OSx aGlance Functions continued Writing Tag Values To write a list or a table of tag attribute data values you must first be logged in with your client login Your client must provide the server with the following parameters e Server Name the prefix osx must appear in front of the OSx station name Tag Names designate the tags you are writing e Attribute Names designate the attributes you are writing Write data only to attributes of process I O tag types for example DO LOOP or AI The process I O tag types are described in the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual Because Excel and Lotus 1 2 3 convert all integer values to floating point values you can only write floating point data This means that you cannot write integer or bit values to attributes of selected OSx tags from these applications a data type mismatch would occur Refer to the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual for valid attributes You can only write to attributes having a domain of FLOAT32 STRING or CISTRING A WARNING O Writing data to tags other than process l O tags may result in database values that could cause unpredictable operation by the controller Unpredictable operation by the controller can cause death or serious injury to personnel and or damage to equipment When you write data write only to one of the process l O tags 1
15. and tag attribute is the tag and attribute to which you are creating the hot link For more information consult the user documentation or the online help that accompanies your Excel add in software Figure A 4 shows an example of a hot link in a spreadsheet cell Cell A1 contains the hot link command which is displayed in the cell content field AAGDDE osxnodel 1p_0 pv lp_l pv lp_2 pv lp_3 pv This hot link requests the process variables for four loops in a controller The process variable data is displayed in cells A1 A4 and is updated as the process variables change NOTE When you are using the macro tool hot links that you have configured on that spreadsheet do not update until you close the macro tool A 6 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance DE osxnodel lp_0O pv lp_l pv lp_2 pv lp_3 pv Ca EE ae A A 0 789999 0 1948 0 9137 19 23 E Na SC DON Ow Figure A 4 Cell Containing Example of Hot Link Syntax SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 7 Using the aGlance Option continued Troubleshooting Hot Links If you have trouble with a hot link first verify spelling and punctuation in the AAGDDE hot link command You can use the cold link macro tools Get Tags and Get Attributes to check the spelling of tag and attribute names
16. for the requested data values Output designate a location for the list of data values List Counts enter an integer to represent the number of tag names the number of attribute names the number of values requested and error information These lists must all be the same size Error Information designate a location to display error messages Monitor_Type designates whether monitoring will be done by polling or by event A non null value indicates polling Monitor_ID identifies the monitor request for the monitor cancel function A value of zero indicates that all monitoring is to be cancelled 1 18 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance Hot Link Update Delay Ending a Session For Linux UNIX and Windows Excel clients it is recommended that you process updates from the server at the rate that the server is sending them This helps prevent server client communication problems which could cause the server to shut down You have the option of configuring a millisecond delay in the aGlance server which delays monitor update messages to the client The default is 500 ms 0 5 seconds and the range is 0 to 999 ms This delay allows the client to remove incoming messages from the message buffer making room for the next message s from the server This reduces the possibility of the client s becoming unable to keep up with the server processing For information about changing the le
17. links the Excel add in displays one or both of the following prompts This document contains links Re establish links or Remote data not accessible Start application AAGDDE EXE In either case click Yes to resume data acquisition 4 Continue your spreadsheet operations The procedures for defining cold links and new hot links are described below Working within a If your aGlance IT add in software is installed you can now begin Session acquiring data from the OSx server and recording it in your spreadsheet Cold Links Consider these guidelines for cold links e Click aGlance on the Excel menu bar to display the aGlance IT options Figure A 2 If aGlance does not appear on the menu bar see page A 3 for a procedure that you can use to add it to the menu bar File Edit View Insert Tools Data a ae Macro Tool al rurale sd a Wizara i 10 y Gan Browse Data Browse History Insert Macro Sheet Example Sheets Figure A 2 Selecting the aGlance Options A 4 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance e Click Macro Tool to display the first aGlance IT macro function You can click the display tool to see a list of all the functions Figure A 3 Click the Command function and enter the Node_Roles command to make sure that the s
18. match any and match single characters Start Index optional enter an integer The server uses the index as a placeholder when there is more data to return than there are output locations A value of zero directs the server to return values starting at the beginning of its database Output Range designate a location for the list of attribute names Tag Count enter an integer that represents the number of tags Attribute Count enter an integer that represents the number of entries in the output To retrieve a list or a table of tag attribute data values your client must provide the server with the following parameters Server Name the prefix osx must appear in front of the OSx station name Tag Names designate the tag names for the requested data values Attribute Names designate the attribute name or the attribute bit name for the requested data values For example you can use the status attribute alone or you can use a bit name such as status active or status 1 The bit specified must be in the bit_defs relation for that attribute Output Range designate a location for the list of data values Error Information optional but recommended designate a location to display error messages This location must be the same size as the output location List Counts enter integers to represent the number of tag names and the number of attribute names Refer to the user documentation that ac
19. text strings reading from Excel Null2blank command from Excel O OSx aGlance capabilities 1 2 OSx login function from Excel OSx station See Host station P PCS 7 OSx aGlance installing 1 7 planning setup Planning PCS 7 OSx aGlance setup 1 6 Put function from Excel Put history function 1 9 from Excell A 25 S Server changing 1 6 defined 1 2 Station names designating 1 8 designating from Excel A 2 A 3 Station role host station 1 6 Station roles getting 1 9 from Excel T Tag names getting from Excel Tag values getting from Excel monitoring TCP IP address editing from Excel Trend data getting 1 12 1 14 from Excell A 20 A 22 Troubleshooting hot links WwW Writing tag values 1 16 Station names designating from Excel A 3 Symbols aGlance adding to Excel toolbar A 3 capabilities 1 5 components aGlance IT client application programs 1 3 components Professional Edition Standard Edition 1 3 aGlance IT configuration utility editing from Excel Index 3 Index 4 Customer Response We would like to know what you think about our user manuals so that we can serve you better How would you rate the quality of our manuals Excellent Good Fair Poor Accuracy Organization Clarity Completeness Graphics Examples Overall design Size Index Would you be interested in giving us more detailed comment
20. the following null2blank NOTE Client_Login Node_Roles and Null2Blank are server specific extensions to the aGlance Command function Refer to your client documentation to determine how to send these commands to OSx aGlance Getting Tag Names To retrieve a list of tag names your client must provide the server with the following parameters e Server Name the prefix osx must appear in front of the OSx station name e Match String optional enter a text search string You can use the standard wildcard match any and match single characters e Start Index optional enter an integer The server uses the index as a placeholder when there is more data to return than there are output locations A value of zero directs the server to return values starting at the beginning of its database e Output designate a location for the list of tag names e Tag Count enter an integer that represents the number of entries in the output 1 10 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance Getting Attribute Names Getting Tag Values To retrieve a list of attribute names for a set of tags your client must provide the server with the following parameters Server Name the prefix osx must appear in front of the OSx station name Tag Names designate the tag names for the requested data values Match String optional enter a text search string You can use the standard wildcard
21. you use a cell reference you can view the entire list by pressing Try it without having to enter a new StartIndex every time OutputRange field select one or more cells to display the data requested from OSx A non zero index value in the upper left corner indicates that the server has additional data to send The system uses this index value in subsequent calls to retrieve additional attribute names To take advantage of this feature you must change the StartIndex field to reference this cell for example B2 A osxstation1 STATUS UNITS aGlance IT Macro Tool x CHANGE L_RANGE AAG Functions GetAttributes vi A ServerName A 2 TagRange C 1 E 1 MatchString Startindex 2 1 OutputRange B 2 BE 5 Try it Paste it Help Pause Close Paste it Cell ANS le Cells B2 B5 will display the requested attribute names B1 shows the index returned by OSx to access further attributes Now when you request tag values with the Get function you can use cells C2 E5 for the output range Figure A 12 GetAttributes Function SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 17 Using the aGlance Cold Link Functions continued GetHistEvent Use the GetHistEvent function Figure A 13 to retrieve a li
22. ATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance What Are the With the components listed above SIMATIC PCS 7 OSx aGlance supports Capabilities the following types of information exchange e Hot link automatically retrieves tag data as that data changes e Cold link reads tag data on demand e History retrieval reads trend data on demand e Write operation allows you to write new values to selected tags SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 5 1 2 Planning the SIMATIC PCS 7 OSx aGlance Setup Determining Hot The hot link or monitor provides your application with tag data that is Links updated every time the tag values change For a Windows application the aGlance IT Client Runtime program must be running in order to enable hot links This is not necessary for a Linux or UNIX application Before you establish the hot links you need to consider these points e OSx aGlance supports up to 16 tag points per hot link e Up to 256 hot links are permitted for each client e Up to ten clients can connect to the OSx aGlance server Choosing the Host You must purchase the aGlance option for each station that you want to Station use as an aGlance server Having more than one server on the system provides you a backup capability in the event that one station acting as server fails You can also divide the data acquisition tasks allowing one server to provide trending data for exampl
23. E 5 OutputRange StatusRange Try it Paste it Help Pause Close Paste it Cell do ura C 7 E 9 RBR On Figure A 6 Example of the Fields of a Macro Function SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 11 Using the aGlance Cold Link Functions continued Command Use the Command function when you need to use the OSx custom functions Client_Login Node_Roles and Null2blank Client_Login Use the Client_Login command Figure A 7 with the Command function when you need to write data to a tag Use your OSx User ID and password A login is not necessary when you only want to read data e ServerName field the prefix osx must appear in front of the OSx station name e Command field enter the following client_login InputRange field if the User ID has a password select two adjacent cells one must contain the OSx User 1D and the other must contain the password If the User ID does not have a password select one cell for the User ID To hide the contents of these cells from unauthorized users refer to the user documentation for Excel OutputRange field OSx does not use this field for the Client_Login function osxstation1 Jean aGlance IT Macro Tool x secrtwrd AAG Functions command ServerName
24. SIEMENS SIMATIC PCS 7 OSx aGlance User Manual Order Number 6ES7 6550XX058BD1 Manual Assembly Number 2811152 0001 Original Edition A DANGER DANGER indicates an imminently hazardous situation that if not avoided will result in death or serious injury DANGER is limited to the most extreme situations a WARNING WARNING indicates a potentially hazardous situation that if not avoided could result in death or serious injury and or property damage ACAUTION CAUTION used with a safety alert symbol indicates a potentially hazardous situ ation that if not avoided could result in minor or moderate injury CAUTION CAUTION used without the safety alert symbol indicates a potentially hazardous situation that if not avoided could result in property damage NOTICE NOTICE indicates a potential situation that if not avoided could result in an undesirable result or state Copyright 2002 by Siemens Energy amp Automation Inc All Rights Reserved Printed in USA Reproduction transmission or use of this document or contents is not permitted without express consent of Siemens Energy amp Automation Inc All rights including rights created by patent grant or registration of a utility model or design are reserved Since Siemens Energy amp Automation Inc does not possess full access to data concerning all of the uses and applications of customer s products we do not assume responsibility
25. Sx and Linux 3 When the Power down message appears power down the station and power it back up again after 15 seconds When the station rejoins the system it automatically resynchronizes with the primary and restarts the OSx aGlance server lee station goes to Fangd You must re register station names and addresses from the client side Unexpected data such as N A It is probably a communications failure Resolve the network problem data not available REF and reissue the cold link command Hot links clear automatically when communication problem or you view them If NAME appears in a cell instead of values expected NAME invalid syntax appears in check the aGlance IT DDE server message window for a message spreadsheet cells indicating that the server has gone out of service Table continues on next page 1 20 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance Table 1 1 PCS 7 OSx aGlance Troubleshooting continued Some fields such as AttrRange are optional for the client but not for Invalid Parameters message appears OSx Check Section A 3 for special restrictions and fill in all necessary fields Also consult your online help or client software manuals Tag values do not agree exactly with OSx database Expect rounding of values in data retrieval When an excessive number of RBE messages are generated in OSx Close and reopen the application and or use fewer hot links or points your
26. Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance e Use the cold link macro Get to check the value s that should be changing Ifthe value returned by the macro does not match that displayed by the hot link the hot link has failed Refer to Section 1 5 for help If you notice that a hot link does not seem to be updating properly when you open your spreadsheet close the spreadsheet and reopen it to restart the hot links Sometimes a hot link is disabled because OSx has been set to the Offline state and then back to the Operate state Hot Link Update For Linux UNIX and Windows Excel clients it is recommended that you Delay process updates from the server at the rate that the server is sending them This helps prevent server client communication problems that could cause the server to shut down You have the option of using a configurable millisecond delay in the OSx aGlance server which delays monitor update messages to the client The default is 500 ms 0 5 seconds and the range is 0 to 999 ms This delay allows the client to remove incoming messages from the message buffer making room for the next message s from the server This reduces the possibility of the client s becoming unable to keep up with the server processing For information about changing the length of the delay contact the Siemens Energy amp Automation Inc Technical Services Group in the U S A at 800 333 7421 In other countries call 49 911 895 7000
27. You can also view the aGlance IT DDE Server window Figure A 5 which displays error messages but does not indicate which hot link command the error references To view the DDE Server window return to the Windows Program Manager window and select Start gt Programs gt aGlance gt aGlanceDDE Bridge The DDE Server window appears E aGlance IT DDE Server x Fie EO Help g Show Errors Show Trace Figure A 5 aGlance IT DDE Server Window If you attempt to open a 257th hot link one more than the maximum allowed OSx returns an initial value to the client However the system does not update the value and the hot link is invalid The aGlance IT DDE Server window displays the following error message All available hot links in use If a hot link appears to have failed values are no longer changing as expected do the following e Check the aGlance IT DDE Server window for error messages Note that if several values are changing rapidly for each active hot link error messages may have scrolled out of the window and beyond the range of the scroll bar A network transport error Remote system error Connect request refused may indicate a network problem such as pulled or broken cable at the client This can cause the OSx aGlance server to shut down Refer to Section 1 5 for help in restarting the server e Verify that the number of active hot links has not exceeded 256 A 8
28. aining the appropriate data In the example shown in Figure A 6 select the ServerName field and either click cell A3 or type in the server name directly For fields that are identified as ranges click the spreadsheet cell or range of cells that contains the data that must go into the field Excel places the cell reference not the data in the field In the example shown in Figure A 6 select the OutputRange field and drag the cursor on cells C3 to E5 Although most fields contained within brackets are optional this is not invariably true for OSx Fields that are not optional are identified within the text of this manual In Figure A 6 the AttrRange field appears in brackets but it is not optional for OSx When you are using the macro tool hot links that you have configured on that spreadsheet do not update until you close the macro tool If you need help click the Help button Be sure to refer to the function description in this manual for differences in how OSx handles the function If you have trouble with a particular command first check all tag and attribute names using the available macro tools such as Get Tags and Get Attributes Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance osxstation1 AAG Functions cet ServerName A 3 TagRange C 2 E 2 AttrRange B 3 B 5 ahh kD EE bii C 3
29. ange is a range of cells that contain attribute names Write data only to attributes of process I O tag types for example LOOP or AI The process I O tag types are described in the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual e ServerName field the prefix osx must appear in front of the OSx station name e Tag Range field select the range of cells that contain the tag names for the data values being written to the server A WARNING Writing data to tags other than process I O tags may result in database values that could cause unpredictable operation by the controller Unpredictable operation by the controller can cause death or serious injury to personnel and or damage to equipment When you write data write only to one of the process l O tags InputRange field select a range of cells that contain a set of values to be sent to the server NOTE Because Excel and Lotus 1 2 3 convert all integer values to floating point values you can only write floating point data This means that you cannot write integer or bit values to attributes of selected tags from these applications a data type mismatch would occur Affected tags are the following CTR IVAR DO DO10 and all of the device tag types You can only write to attributes having a domain of FLOAT32 STRING or CISTRING Refer to the chapter on defining tag in the SIMATIC PCS 7 OSx Process Configuration Manual for va
30. client may not be able to keep per hot link to lessen the load up Hot links may stop updating If OSx is still running change system state to Offline and then back to Operate If you want to write to tag values you must log in again on the client In order to restart the server on the original station transition OSx to the Offline state and then back to Operate again To avoid setting all OSx stations Offline you can follow these steps instead 1 Set the station where the server has shut down to Out_of Service 2 Shut down the station by selecting Controls Change System State on the menu bar and choosing Shutdown OSx and Linux 3 When the Power down message appears power down the Server fails and aGlance does not work station and power it back up again after 15 seconds When the station rejoins the system it automatically resynchronizes with the primary and restarts the aGlance server Text values do not change to reflect Use the Null2blank command to force client recognition of empty an empty string strings Refer to page 1 10 Reading Null Text Strings To verify that the hot link has failed request a tag value through a cold link and compare it with the hot link value Verify that the number of hot links has not exceeded 256 Verify that the number of tag points per hot link has not exceeded 16 Check client error messages for corrective procedures The aag_admin utility does not aGlance does not require t
31. companies your client software for more detailed information SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx OaGlance 1 11 Using the SIMATIC PCS 7 OSx aGlance Functions continued Getting Trend Data To retrieve a list of actual historical trend points for a time period you must first be logged in with your client login Your client must provide the server with the following parameters Server Name the prefix osx must appear in front of the OSx station name Tag Name designate the tag name for the requested data values Attribute Name designate the bit name or the attribute name for the requested data values For example you can use a bit name such as status active or status 1 or you can use the status attribute alone If you specify an attribute name aGlance attempts to retrieve analog trend data If you specify a bit name aGlance attempts to retrieve digital trend data The text following the dot is the bit name The number following the dot is a number from 1 to 16 corresponding to the bit number in the status attribute Refer to the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual for more information about bit names Start Index optional enter an integer The server uses the index as a placeholder when there is more data to return than there are output locations A value of zero directs the server to return values starting at the beginning of its database Outpu
32. conds A colon between fields is optional If AM or PM is not specified the system defaults to a 24 hour clock For examples see the GetHistEvent function A 20 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance IntervalTime field enter a text string to represent the time interval between samples of historical data For correct syntax refer to the appendix on time strings in the SIMATIC PCS 7 OSx Reports Manual TimeRange field optional select the range of cells to display an actual time string for each set of samples OSx formats these values so that you can use them as the StartTime in subsequent commands StatusRange field optional select the range of cells to display any error messages that occur This range must contain the same number of cells as the OutputRange You can however extend the size of these cells refer to the Excel manual for a procedure aGlance IT Macro Tool x osxstation1 AAG Functions Nc ETT Server Name A 3 lv TagRange C 1 D 1 COON WAUN eL AttrRange C 2 D 2 OutputRange C 3 C 10 StartTime 2 pm Mon IntervalTime 5 min TimeRange B 3 B 10 Cells B3 B10 will display the appropriate time for each data point Paste it Cell Cells C3 D10 will display the
33. e Using the aGlance IT Administration Tool 000 ccc eee e eens Selecting the aGlance Options 000 cece eet enna Displaying the aGlance Macro Functions 00 cece eee ete Cell Containing Example of Hot Link Syntax 0000 c cece aGlance IT DDE Server Window 0 cc cee ene e nee eas Example of the Fields of a Macro Function 2 0 ccc cece eee tenes Client_Login Function 0 0 0 c cece eee nett n eens Node Roles Functhon asi ccco c 3 acs dice oder eee wie Ride ies dda whee hi ede Lh a aes Null2Blank Function 0 0 0 eee nent teen eee n teen eens Disconnect Function 0 ccc een en ene ene teen nen eens Get FUNCION ii owes aed ade lA de a ee Wee ee eee ewes ek di GetAttributes Function 0 or GetHistEvent FUNCION sessed araia dite ri GetHistory FUNCHION 0 nen AEEA EA ENAN AENEA GetTags FUNCION iia iaa ee ee ee Put Function Contents Vv List of Tables 1 1 OSx aGlance Troubleshooting Contents Preface Purpose of This The SIMATIC PCS 7 OSx aGlance User Manual describes the data Manual exchange capability between Windows Linux UNIX and VMS application programs and SIMATIC PCS 7 OSx This option allows you to read process data from the OSx database directly into your remote application program You can also write data to selected OSx tags e Section 1 1 defines the capabilities of SIMATIC PCS 7 OSx aGlance e Section 1
34. e while another provides hot links and yet another provides cold links Use these guidelines when you determine which OSx stations are to be servers e OSx Station Role In most cases do not choose the primary which is the busiest station on the system Choose a non primary unless you anticipate extensive work with trending in this case the primary can supply trending data most efficiently Because of the configuration work being done on the station with the sysadmin role the sysadmin may not be a good choice as a server Any other role is acceptable except for out_of service Connection Type Either an operator or a supervisory station is an appropriate choice for a server You can change the station acting as server at any time by changing address information within the client The new station must have the aGlance option installed Obtaining When you configure the application client you need to know the IP address IP Addresses of each station that is to be a server If the OSx station communicates on two networks you need both network IP addresses 1 6 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance 1 3 Installing the SIMATIC PCS 7 OSx aGlance Option Installation OSx Side SIMATIC PCS 7 OSx 4 1 2 aGlance If you ordered aGlance with your SIMATIC PCS 7 OSx system it is already installed for you If you ordered the aGlance option at a later date follow the steps below to install it 4 0
35. e server with your OSx User ID and password You do not need to log in when you only want to read data The OSx aGlance server requires the following parameters from the client e Server Name the prefix osx must appear in front of the OSx station name e Command enter the following client_login e Input the input must include the OSx User ID and the OSx password To determine the roles of the OSx stations your client must provide the server with the following parameters e Server Name the prefix osx must appear in front of the OSx station name Command enter the following node_roles e Output designate a location for the list of station names and roles SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 9 Using the SIMATIC PCS 7 OSx aGlance Functions continued Reading Null Text Some clients read a null text string as no change and do not update the Strings value For example if the value of a TEXT tag changes from Boiler 1 On to null empty then some clients see no change and continue to read the value as Boiler 1 On The Null2Blank command replaces the null value with blanks that these clients can read as a changed value Whenever you intend to request data from a TEXT tag for either a hot or a cold link run the Null2Blank command from the Command function first e ServerName the prefix osx must appear in front of the OSx station name e Command enter
36. either for customer product design or for any infringements of patents or rights of others which may result from our assistance MANUAL PUBLICATION HISTORY SIMATIC PCS 7 OSx 4 1 2 aGlance User Manual Order Manual Number 6ES7 6550XX058BD1 Refer to this history in all correspondence and or discussion about this manual Event Date Description Original Issue 7 02 Original Issue 2811152 0001 LIST OF EFFECTIVE PAGES Pages Description Cover Copyright Original History Effective Pages Original ili x Original 1 1 1 21 Original A 1 A 25 Original Index 1 Index 3 Original Registration Original Pages Description Trademarks SIMATIC SINEC and STEP are registered trademarks and S5 and S7 are trademarks of Siemens AG PCS APT Series 505 and TISOFT are trademarks of Siemens Energy amp Automation Inc Adobe and Acrobat are registered trademarks of Adobe Systems Inc aGlance and Net OLE are trademarks of Axeda Inc Epson is a registered trademark of Seiko Epson Kabushiki Kaisha Excel is a trademark and Windows and MS DOS are registered trademarks of Microsoft Corporation HP DeskJet LaserJet and PaintJet are registered trademarks of Hewlett Packard Company IBM is a registered trademark of International Business Machines Corporation Intel is a registered trademark of Intel Corporation Internet is a registered trademark of Internet Inc Lantr
37. his utility execute Add the following code to one of the source files of the client and recompile the client int getdtablesize void Client unable to communicate with server Error message return 60 AAG E SCKSET appears This overrides the standard library function getdtablesize and returns a value that the aGlance libraries can successfully use This affects only those clients that run on an OSx station A hot link appears to have failed Values are not updating SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 21 1 22 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance A 1 A 2 A 3 Appendix A Using aGlance with Excel Configuration Hints for Excel 0cce eee ee eee eee Recommended Hardware and Software Entering Station Names and Addresses Adding aGlance to the Tool Bar 0 ccc cnet tenet n eens Using the aGlance Option 0 0c cece eee eee Opening a SESSION we suae naana aaa a aS ia a a ien ae a a ae Working within a Session Cold Links 000 cece eee eee teens Working within a Session Hot Links 000 cece eee tenet eee eens Troubleshooting Hot Links 0 cece ene eens Hot Link Update Delay sas sa esaad aaa aaah aa cece ene eee Different Values for the Same Data Point oocccccccccccccncnc eee CIOSING a SESSION srs faeces eee a ead whe E ES waka ea Ro a a Using the aGlance Cold Link Function
38. ield select one or more cells to display the data requested from OSx If N A appears in one or more output cells there are no trend values for those cells This occurs if the number of output cells exceeds the number of trend values for the requested time period StartTime and EndTime fields enter a character string with a maximum total length of 21 characters to represent the starting and ending points for the required historical trend These two fields require both a time such as 9 30AM or 1400 and a date such as FRI or TODAY or OCT 14 A 18 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance You can specify time using a number with one to six digits The system accepts a one or two digit number as hours a three or four digit number as hours and minutes and a five or six digit number as hours minutes and seconds A colon between fields is optional If AM or PM is not specified the system defaults to a 24 hour clock The following are examples of legitimate start or end times 10AM FRI 10AM FRI 2 DAYS 10 10 00 MON NEXT DAY For more information refer to the appendix on time strings in the SIMATIC PCS 7 OSx Reports Manual TimeRange field optional select the range of cells to display an actual time string for each set of samples OSx formats these values so that you can use them as the StartTime in subsequent commands e StatusRange field optional select the range of cells to display any
39. iii A 2 A 3 Using the aGlance Option 0 0c cece eee Opening a SeSSiON sc pees pede rr daa tai Working within a Session Cold Links 000 cece eee eee eens Working within a Session Hot Links 000 cece eee eee teens Troubleshooting Hot Links 0 a tne nee etnies Hot Link Update Delay 0 cece e ete Different Values for the Same Data Point 00 c cece eect eee Closing a Session 0 6 ected eee e eee Using the aGlance Cold Link Functions Some Guidelines siii di ai doa dase a dna aid iba ca COMMANA Dee E tn enn nent E teen ene eee eee nnn DISCONNECT iria rai ar dia ai baits asad ya nay aaa neon E O gee pee whe GetAtlributes qiiis a aia a dota Do a ase lap acd dae ve GetHIStEVONO creiras aaran den a hae ae Son bee ee waa ARA GEMISTO cs ciar a a A eee lanes a e ta a eae GOlHisiSA di ad CA an ia aia A R E TAN A A A a T E E TN A LisStSErnveiS ui AW aaa diet E a A EAE dew ies daa ERIA Node Roles sc coi a ea a a EERE E id la Nul2Blanie ainia aria dono a iria coa a A ARO PUDEISTONY siaaa a a A R does Gere deed A Contents List of Figures 1 1 1 2 1 3 A 1 A 2 A 3 A 4 A 5 A 6 A 7 A 8 A 9 A 10 A 11 A 12 A 13 A 14 A 15 A 16 aGlance on the SIMATIC PCS 7 OSx System 0 occocccccccccccc SIMATIC PCS 7 OSx aGlance Data Exchange with Windows Clients Relationship of Count to Time Count 00 ccc cette ete e ne
40. ink Update Delay Ending a Session 1 5 Troubleshooting SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx OaGlance 1 1 1 1 Defining SIMATIC PCS 7 OSx aGlance What Can SIMATIC PCS 7 OSx aGlance enables you to read and write to the OSx aGlance Do for database from an application running on a Windows Linux UNIX or VMS Me computer Figure 1 1 In this context aGlance acts as a server which is a system or program that provides services to a client The client is the computer that requests and receives information from the server OSx aGlance is available in two versions one for one client and one for up to ten clients The OSx aGlance option provides easy and inexpensive access to process data for managers accountants and others who need such data OSx aGlance translates and transmits data in the correct format for the application program If the client application is a spreadsheet such as Excel you can read OSx tag data and historical trend data directly into the spreadsheet You can also write new values to selected tags Windows Linux UNIX or VMS OSx Stations with SIMATIC PCS 7 Computer with aGlance IT Client OSx aGlance Server Option Read Write Data LJ LJ ft fe 09000 0000 Control Nodes Figure 1 1 aGlance on the SIMATIC PCS 7 OSx System 1 2 Using SIMATIC PCS
41. led information SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 13 Using the SIMATIC PCS 7 OSx aGlance Functions continued Getting To retrieve a list of historical trend values interpolated across a time period Interpolated Trend you must first be logged in with your client login Your client must provide Data the server with the following parameters e Server Name the prefix osx must appear in front of the OSx station name Tag Names designate the tag names for the requested data values e Attribute Names designate the bit names or the attribute names for the requested data values For example you can use a bit name such as status active or status 1 or you can use the status attribute alone If you specify an attribute name aGlance attempts to retrieve analog trend data If you specify a bit name aGlance attempts to retrieve digital trend data The text following the dot is the bit name The number following the dot is anumber from 1 to 16 corresponding to the bit number in the status attribute Refer to the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual for more information about bit names Output Range designate a location for the set of trend data e Starting Time enter a character string with a maximum total length of 21 characters to represent the starting point for the required historical trend You can specify time using a number with one
42. lid attributes A 24 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance StatusRange field optional select the range of cells to display any error messages that occur This range must be the same size and shape as the InputRange osxstation1 Put ServerName 2 3 TagRange C 2 E 2 AttrRange B 3 InputRange C 3 E 3 StatusRange c 4 E 4 CONAnUP WN Try it Paste it Help Pause Close Cells C4 E4 will display error Paste it Cell messages if any Figure A 16 Put Function PutHistory The PutHistory function is not supported by OSx SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 25 A 26 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance A Accessing station role tag attribute names 1 11 tag names tag values 1 11 text tag datal 1 10 trend data trend data interpolated Address TCP IP editing from Excel A 2 Attributes getting from Excel Bit tag attributes 1 11 C Client application programs 1 3 defined 1 2 installing 1 8 Client_login command 1 9 from Excel Cold link defined 1 5 Excel macro in Excel Command function from Excel Components aGlance 1 4 Configuration Excel A 2 Index Connection type host station 1 6 D
43. n Do the appropriate application specific configuration such as specifying names for the OSx stations Since your application may be case sensitive make sure that the case matches that of the station name you specify in the hosts file The order of the station names may determine the order that the client attempts to access them If a network fails you may want to reorder the station names to avoid timeout delays If you have installed two networks be sure to enter a station name for each network Follow the conventions above using A and B to differentiate between the two networks If you are using a Windows application and want to establish hot links with your process install the aGlance Client Runtime option 1 8 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance 1 4 Using the SIMATIC PCS 7 OSx aGlance Functions OSx Login Getting Station Roles This section describes the basic read write commands supported by the OSx aGlance server and lists the parameters that the client application must supply to the server Consult the documentation that accompanies your client software for details about how your client supplies these parameters Appendix A provides examples for using aGlance with Excel NOTE SIMATIC PCS 7 OSx does not support client commands that write to trend data or that read trend statistics When you need to write data to a tag you must log in to OSx In order to log in your client must provide th
44. ng with aGlance IT function All client functions except monitoring are supported e All features of the client C language API are available to the developer SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 3 Defining SIMATIC PCS 7 OSx aGlance continued What Components Are Required The components that you need to link a client with the OSx server are listed below Figure 1 2 shows how the following components interact to allow communication between a client application and the OSx server e Installed and operating SIMATIC PCS 7 OSx system Connection for the Windows Linux UNIX or VMS computer to the Industrial Ethernet using the TCP IP network protocol e Application such as Excel or Lotus 1 2 8 e Application aGlance IT add in from your Siemens distributor if necessary e aGlance Client Runtime program for DDE support for Windows applications from Axeda Inc e The SIMATIC PCS 7 OSx aGlance option from your Siemens distributor OSx Station Windows Computer U U pal eal Ethernet Network OSx Database Client Runtime Client Application pal Links Windows Oe Computers a Ta OSx aGlance Colg Li Server O ae Application Add in l Server Side Client Side Figure 1 2 SIMATIC PCS 7 OSx aGlance Data Exchange with Windows Clients 1 4 Using SIM
45. ngth of the delay contact the Siemens Energy amp Automation Inc Technical Services Group in the U S A at 800 333 7421 In other countries call 49 911 895 7000 Linux and UNIX clients need to use the monitor_type and interval parameters of the Monitor function for best performance with the initial release of aGlance The monitor_type must be non null to indicate polling When using hot links reduce the number of points per hot link as the rate of change of the points that you are monitoring increases This allows the server to keep up with rapidly changing data and to send that information to the client To end an aGlance session you must enter the server name with the prefix osx in the client disconnect function SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 19 1 5 Troubleshooting Table 1 1 describes various troubleshooting strategies for OSx aGlance If you need further assistance call the Siemens Technical Services Group in the U S A at 800 333 7421 In other countries call 49 911 895 7000 Table 1 1 OSx aGlance Troubleshooting OSx goes to Offline state and you get a Network Transport Error message When OSx returns to Operate state try again to read data If you want to write to tag values you must log in again Try requesting data again before assuming an error Then check the Unexplained Network Transport Error state of the OSx station which may have failed developed message a
46. onal OSx features PCS 7 Features e SIMATIC PCS 7 OSx Remote Data Transfer Manual This manual describes the remote data transfer feature which allows you to transmit data collected from the process by an OSx station to an Oracle database on the remote computer for historical records and other purposes e SIMATIC PCS 7 OSx X Terminal User Manual This manual describes how to connect and operate an X terminal as an extension of an OSx station Preface SIMATIC PCS 7 OSx 4 1 2 aGlance Chapter 1 Using SIMATIC PCS 7 OSx aGlance 1 1 Defining SIMATIC PCS 7 OSx aGlance 2 0 cece eee eee eee What Can aGlance Do for Me What Components Are Required What Are the Capabilities 1 2 Planning the SIMATIC PCS 7 OSx aGlance Setup 02cc cece o Determining Hot Links Choosing the Host Station Obtaining IP Addresses 1 3 Installing the SIMATIC PCS 7 OSx aGlance Option ooooooccccccn eee Installation OSx Side Installation Client Side 1 4 Using the SIMATIC PCS 7 OSx aGlance Functions ocoococccccc OSX LOJN 00022005 Getting Station Roles Reading Null Text Strings Getting Tag Names Getting Attribute Names Getting Tag Values Getting Trend Data Getting Interpolated Trend Data Writing Tag Values Monitoring Tag Values Hot Links Hot L
47. onix is a registered trademark of Lantronix Linux is a registered trademark of Linus Torvalds Lotus and 1 2 30 are registered trademarks of Lotus Development Corporation Network Computing Devices is a registered trademark of Network Computing Devices Inc Oracle is a registered trademark of Oracle Corporation PostScript is a registered trademark of Adobe Systems Inc Red Hat is a registered trademark of Red Hat Inc TI is a trademark of Texas Instruments Inc Tektronix is a registered trademark of Tektronix Inc UNIX is a registered trademark of X Open Company Ltd VMS is a registered trademark of Compaq X Window System is a trademark and Motif is a registered trademark of the Open Group XESSS9 is a licensed registered trademark and AIS is a registered trademark of Applied Information Systems Inc Other trademarks are the acknowledged property of their respective holders Contents PIGlaGe 2 da e de ed ac wen Chapter 1 Using SIMATIC PCS 7 OSx aGlance o oooooocooccooccnnc o 1 1 1 2 1 3 1 4 1 5 Defining SIMATIC PCS 7 OSx aGlance 2 0 cece eee eee What Can aGlance Do for Me 0 0 nee nee een eae What Components Are Required 000 c cee eee eee eee What Are the Capabilities 0 c eee eee eee Planning the SIMATIC PCS 7 OSx aGlance Setup 02ecc cece eee eee eee Determining Hot LINKS 0 cc eect tenet ne
48. ontain the tag names for the requested historical data values AttrRange field this field is not optional for OSx The AttrRange is a range of cells that contain bit names or attribute names For example you can use a bit name such as status active or status 1 or you can use the status attribute alone If you specify an attribute name OSx aGlance attempts to retrieve analog trend data If you specify a bit name aGlance attempts to retrieve digital trend data The text following the dot is the bit name The number following the dot is a number from 1 to 16 corresponding to the bit number in the status attribute Refer to the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual for more information about bit names OutputRange field select one or more cells to display the data requested from OSx If N A appears in one or more output cells the previous cell value if any is the last trend value available for the requested point StartTime field enter a character string with a maximum total length of 21 characters to represent the starting point for the required historical trend This field requires both a time such as 9 30AM or 1400 and a date such as FRI or TODAY or OCT 14 You can specify time using a number with one to six digits The system accepts a one or two digit number as hours a three or four digit number as hours and minutes and a five or six digit number as hours minutes and se
49. ppears communication problems or changed to the Offline state Verify the client configuration of the OSx station address You must re register station names and addresses before using the alternate network Use the A B network designation after the station name For Linux UNIX or VMS users contact your system administrator For Windows users follow these steps 1 Either switch cables on the client to the other network or toggle the T Box switch to the other network 2 Access the Windows Network Setup in the Program Manager and configure the client to use the other network 3 Exit and restart Windows With two OSx networks installed either one network or one network card in the OSx station fails This indicates a network problem such as pulled or broken cable at the client This can cause the aGlance server to shut down at the OSx station where you are connected Correct the problem and then connect to another station where aGlance is loaded to resume your aGlance work In order to restart the server on the original station transition OSx to A Network Transport Error Remote the Offline state and then back to Operate again To avoid setting all system error Connect request refused OSx stations Offline you can follow these steps instead appears 1 Set the station where the server has shut down to Out_of Service 2 Shut down the station by selecting Controls gt Change System State on the menu bar and choosing Shutdown O
50. s 00 cece eee eee eee eee Some Guidelines cian ina ada liada COMMON laa ad DISCONNGCH atinada aa O nash amp cart acne ha ter dank ms aust a eb at agua A acre at a banteh me a neediest GetAtIHbDUTES Zion a A A A a T da aid GetHistEvent o o o o o o oooo cnet e teen enn een een a GEHST Ys caca dew lobed da A eerie anon dee SAIS US CAE rai ae nent ga ut E E E E E E E E E ana CTT AIS ii iaa Be nye ape antares ria aaa pate ape a LISTSCIVENS uan dile 4d ee aaa Node Roles 2d 2200 e uereiu ss adtaueduneiGws taa dae ba sanded Noull2BlanK zo correr aa AA daca eis dole dew aa PUE a ee dead aed deh E E E ARE a da di dea cee dor PULISIONY cada dd que teed sie ae AG ana aa sate a SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 1 A 1 Configuration Hints for Excel Recommended Hardware and Software Entering Station Names and Addresses The following components are the minimum requirements for using Excel with aGlance IT e 80886 or higher computer e Windows 95 Windows 98 Windows NT 4 0 or Windows 2000 e Excel 5 0 or higher e Connection for the Windows Linux UNIX or VMS computer to the ethernet using the TCP IP network protocol e Application aGlance IT Standard Edition V3 2 or higher from your Siemens distributor for both Excel Addin and DDE connections to miscellaneous Windows applications if necessary The Excel add in requires you to designate the station name and address for the server in
51. s about our manuals Yes Please send me a questionnaire No Thanks anyway Your Name Title Telephone Number Company Name Company Address Manual Name SIMATIC PCS 7 OSx 4 1 2 aGlance User Manual Edition Original Manual Assembly Number 2811152 0001 Date 7 02 Order Number 6ES7 6550XX058BD1 FOLD 3000 BILL GARLAND ROAD POBOX 1255 JOHNSON CITY TN 37605 1255 SIEMENS ENERGY 8 AUTOMATION INC BUSINESS REPLY MAIL FIRST CLASS PERMIT NO 3 JOHNSON CITY TN POSTAGE WILL BE PAID BY ADDRESSEE ATTN TECHNICAL COMMUNICATIONS M S 519 SIEMENS ENERGY amp AUTOMATION INC P O BOX 1255 JOHNSON CITY TN 37605 1255 FOLD NO POSTAGE NECESSARY IF MAILED IN THE UNITED STATES
52. st of actual historical trend points for a time period ServerName field the prefix osx must appear in front of the OSx station name Tag Range field select the cell that contains the tag name for the requested historical data values AttrRange field this field is not optional for OSx The AttrRange is a cell that contains a bit name or an attribute name For example you can use a bit name such as status active or status 1 or you can use the status attribute alone If you specify an attribute name OSx aGlance attempts to retrieve analog trend data If you specify a bit name aGlance attempts to retrieve digital trend data The text following the dot is the bit name The number following the dot is a number from 1 to 16 corresponding to the bit number in the status attribute Refer to the chapter on defining tags in the SIMATIC PCS 7 OSx Process Configuration Manual for more information about bit names StartIndex field optional specify a spreadsheet cell where the index sent by the server will appear The server uses this index as a placeholder when there is more data to return than there are output cells By default the server returns values starting at the beginning of its database and uses the start index to update additional sets of values If you do not specify a spreadsheet cell in this field or if you specify a constant the server sends only the first set of data that fits in the output range OutputRange f
53. t Range designate a location for the set of trend data 1 12 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance e Starting Time Ending Time for each of these enter a character string with a maximum total length of 21 characters that represents the starting or ending point for the historical trend You can specify time using a number with one to six digits The system accepts a one or two digit number as hours a three or four digit number as hours and minutes and a five or six digit number as hours minutes and seconds A colon between fields is optional If AM or PM is not specified the system defaults to a 24 hour clock The following are examples of legitimate start or end times 10AM FRI 10AM FRI 2 DAYS 10 10 00 MON NEXT DAY For more information refer to the appendix on time strings in the SIMATIC PCS 7 OSx Reports Manual Time Range optional designate a location that will display an actual time string for each set of samples when they are received from OSx OSx formats these values so that you can use them as the Starting Time in subsequent commands e Status Range optional but recommended designate a location to display error messages This location must be the same size as the output location e List Counts enter integers to represent the number of tag names and the number of attribute names Refer to the user documentation that accompanies your client software for more detai
54. tation has the correct role Do not attempt to acquire data from a station that is out of service e If you need to write tag data as well as read it click the Command function and enter the Client_Login command to log in to OSx Use your OSx User ID and password e Refer to Section A 3 for a description of the SIMATIC PCS 7 OSx aGlance cold link functions CECI Eto Lolo x AAG Functions GetTags Help Macro Tool Wizard Server Name Match String Startindex OutputRange Try it Paste Paste it Cell GetTags GetAttrib Get Put GetHistory GetHistEvent GetHistStats PutHistory Disconnect Command ListServers Browse Data Browse History Insert Macro Sheet Example Sheets Figure A 3 SIMATIC PCS 7 OSx 4 1 2 aGlance Displaying the aGlance Macro Functions Using aGlance with Excel A 5 Using the aGlance Option continued Working within a Session Hot Links If you have installed the aGlance IT Client Runtime option you can create up to 256 hot links to the OSx database Edit a cell and enter the hot link syntax for acquiring the necessary tag data For example to create a hot link to the attribute of one tag enter the following AAGDDE osx lt node_name gt lt tag attribute gt where node_name is the name of the OSx station
55. tem and how to install them SIMATIC PCS 7 OSx Reports Manual This manual describes how to create reports on your process and your OSx configuration SIMATIC PCS 7 OSx Recipe Manual This manual describes advanced configuration tasks involving the creation and use of recipes SIMATIC PCS 7 OSx Batch Programming Manual This manual describes advanced configuration tasks involving the use of BCL the Batch Control Language and creating batch programs SIMATIC PCS 7 OSx Operator Manual This manual describes how to carry out the various tasks that the process operator must do when the system is in the Operate state You may photocopy all or portions of this manual as a reference for your operators SIMATIC PCS 7 OSx Interface to S5 Controllers Manual This manual describes the OSx interface with SIMATIC S5 controllers SIMATIC PCS 7 OSx Interface to S7 Controllers Manual This manual describes the OSx interface with SIMATIC S7 controllers SIMATIC PCS 7 OSx Library Manual This manual describes function blocks used to program the S7 400 controllers to interface with OSx Be sure to check the Readme File for information that did not become available until after the publication deadlines for the OSx manuals Select Help gt About OSx from the main menu bar and then click on the Show Readme button at the bottom of the About OSx dialog box SIMATIC PCS 7 OSx 4 1 2 aGlance Preface ix Optional SIMATIC The following manuals are available for opti
56. the hosts file and in the aGlance IT Configuration Utility on the client computer Editing the Hosts File Use any ASCII editor to edit the hosts file on the client computer to add the TCP IP address es of the OSx station If you have two networks installed for OSx you may want to enter an address for each network using the characters A and B to differentiate For example your hosts file may have the following entries 204 109 10 250 NodelA OSx Nodel Network A 224 199 11 240 Nodel1B OSx Nodel Network B If your client computer is connected to Network A you can log in to OSx Station1 by connecting to NodelA If your client computer is connected to Network B you can log in to Osx Station1 by connecting to Node1B If you connect your Excel computer to the two networks through a T box then you can easily change from one network to the other in the event of a network failure A 2 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance Adding aGlance to the Tool Bar Editing the aGlance IT Configuration Utility To open the aGlance IT Excel add in in your Windows Program Manager window click Start gt Programs gt aGlance gt aGlance IT Administration The Administration dialog box appears Figure A 1 Enter the station name for the server If your SIMATIC PCS 7 OSx system has two networks make two entries following the conventions noted above for the hosts file Make sure that the case matches that of the station name
57. to quit and press Enter Reboot the system The station is now ready to use OSx aGlance Using SIMATIC PCS 7 OSx aGlance 1 7 Installing the SIMATIC PCS 7 OSx aGlance Option continued Installation Client Side You must install all the aGlance IT software and the application program on the Windows Linux UNIX or VMS computer that is to be the client Refer to the user documentation that accompanies these products and follow these general guidelines Install and run the application such as Excel Edit the hosts file on the client computer to add the IP address es of the OSx station If you have two networks installed for OSx you may want to enter an address for each network using the characters A and B to differentiate For example your hosts file may have the following entries 204 109 10 250 StationlA OSx Stationl Network A 224 199 11 240 Station1B OSx Stationl Network B If your client computer is connected to Network A you can connect to OSx Station1 through Network A by using the Server Name Station1A If your client computer is connected to Network B you can connect to OSx Station1 through Network B by using the Server Name Station1B If you connect your client computer to the two networks through a T box then you can easily change from one network to the other in the event of a network failure If applicable install any additional aGlance products needed by the application such as the Excel add i
58. to six digits The system accepts a one or two digit number as hours a three or four digit number as hours and minutes and a five or six digit number as hours minutes and seconds A colon between fields is optional If AM or PM is not specified the system defaults to a 24 hour clock For examples see the Getting Trend Data portion of Section 1 4 e Interval Time enter a text string to represent the time interval between samples of historical data 1 14 Using SIMATIC PCS 7 OSx aGlance SIMATIC PCS 7 OSx 4 1 2 aGlance Time Range optional designate a location to display an actual time string for each set of samples when they are received from OSx OSx formats these values such that you can use them as the Starting Time in subsequent commands e Status Range optional but recommended designate a location that will display error messages This location must be the same size as the output location Count enter an integer to represent the number of points for which values are being requested Refer to Figure 1 3 for an example Time Count enter an integer to represent the number of time intervals Refer to Figure 1 3 for an example Tagi Tag2 Tag3 Attribute 1 Attribute2 Attribute3 Output Time Count 4 Area Count 3 Figure 1 3 Relationship of Count to Time Count SIMATIC PCS 7 OSx 4 1 2 aGlance Using SIMATIC PCS 7 OSx aGlance 1 15 Using the SIMATIC
59. tt eee Choosing the Host Station 0 0 ccc cece ent ee teens Obtaining IP Addresses 00 cece eee e eee eens Installing the SIMATIC PCS 7 OSx aGlance Option oooococccccnn eee Installation OSx Side 2 eee eee eee eee eas Installation Client Side 0 0 00 eee eee eee eas Using the SIMATIC PCS 7 OSx aGlance Functions ee ee eee eee OSX LOGIN 2432 coc bee ee A ee A Ae ae ee D G Getting Station Roles ia iii a da ah tame eee a aca AAA Reading Null Text StringS 0 c cece eens GettingTag Names viii a a A A da astute beter Getting Attribute Names o o oooococooccooon e nent nee n nets Getting Tag Valles aii isc pia aria chew hae ida ae EGS ee ered A ee Getting Trend Data secs ead a dd ad adn Getting Interpolated Trend Data 0 0 ccc teen tee teens Writing Tag ValU S cogcr atar ood exes ead eens ee EEEN deed eee eee ee es Monitoring Tag Values Hot Links 00 cece cette eens Hot Link Update Delay 0 cece ene eee eens Ending a SOSSION viviera AAA ee need wee A AA TroubleShooung wie ecede cee cece estes Piece cede ee ete eee cele oe eaten nee ci Appendix A Using aGlance with Excel 0eeeee eee eee eee A 1 Configuration Hints for Excel 00 ccc eee eee eee eee Recommended Hardware and Software Entering Station Names and Addresses Adding aGlance to the Tool Bar 0 2 ccc cect net n eens Contents
60. ure you must change the StartIndex field to reference this cell for example B1 A 22 Using aGlance with Excel SIMATIC PCS 7 OSx 4 1 2 aGlance osxstation1 AAG Functions ServerName A 3 MatchString loop Startindex B 1 10 OutputRange 8 2 B 10 11 12 Try it Paste it Help Pause Close 13 Paste it Cell 14 15 clon o aa ona Cells B2 B10 will display the requested tag names Cell B1 will display the start index Figure A 15 GetTags Function ListServers The ListServers lists all servers running on the host station You can specify that attributes such as name and host appear in the output This function is supported by the aGlance IT Add in Refer to your add in manual or to online help for information SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 23 Using the aGlance Cold Link Functions continued Node_Roles See the Command function Null2Blank See the Command function Put Use the Put function Figure A 16 to write a list or a table of individual tag attribute data values OSx logs all tag value changes to the OSx database in the Operator Change Log with the last eight characters of the IP address in the place of the User ID e AttrRange field this field is not optional for OSx The AttrR
61. you specify in the hosts file For the Transport protocol select ONC When you select the Add button the station name appears in the Server Host Transport field The order of the station names in the Server Host window determines the order in which aGlance attempts to access them If a network fails you may want to reorder the station names to avoid timeout delays EI CaGlance IT Administration Tool x Server Hosts Proxies Permissions Server Host Transport OoOO e ONC C ACA Server Host Transport List Servers sco29a ONC Replace Add Remove MoveUp MoveDown OK Cancel Apply Help Figure A 1 Using the aGlance IT Administration Tool If the aGlance menu bar selection does not show up in the Excel tool bar you can add it by following these steps 1 Open an Excel spreadsheet 2 Select Tools Addins An Add in dialog box appears 3 Click the aGlance IT Version 3 2 Addin item in the Add ins list An X should appear in the box preceding the item 4 Select OK Excel adds the aGlance item to the menu bar SIMATIC PCS 7 OSx 4 1 2 aGlance Using aGlance with Excel A 3 A 2 Using the aGlance Option Opening a Session To open an aGlance session with Excel refer to your documentation for Excel and the aGlance IT add in and follow the steps below 1 Open Windows and run the Excel program 2 Open a spreadsheet file 3 If you have already created a sheet that contains hot
Download Pdf Manuals
Related Search
Related Contents
Sterling Plumbing BB121250 User's Manual User manual VIVOTEK SD8363E surveillance camera Samsung WF0500NXW User Manual Belkin Charger Kit FINEPIX S8600 Series Bedienungsanleitung 標準機と比較して 約2倍のパック能力 両サイドシール方式で左右同時に Copyright © All rights reserved.
Failed to retrieve file