Siemens 3964R User Manual Download Page 28 | Manualshive

Page: 28 / 40

background image

24

Reading Values from the I/O Server into Excel

Values may be read directly into Excel spreadsheets from the server by entering a DDE
formula into a cell using the following format:

=applicationname|topicname!itemname

Example formula:

=S3964R|S115U!DB10DW20KF

where:

S3964R

Is the name of the server

application name.

S115U

Is the exact topic name defined in the server for the
PLC.

DB10DW20KF

Is the actual location in the PLC that contains the data
value. This is the item name.

In this example, each time the value of

DB10DW20KF

changes in the

PLC,

the server

will automatically send the new value to the cell containing the formula in Excel.

Note

Refer to the Microsoft Excel manual for complete details on entering Remote

Reference formulas for cells.

«
...
26
27
28
29
30
...
»

Summary of Contents for 3964R

Page 1: ...Wonderware Siemens 3964R I O Server User s Guide Revision S June 2002 Wonderware ...

Page 2: ...a license or nondisclosure agreement This software may be used or copied only in accordance with the terms of these agreements 2002 Invensys Systems Inc All Rights Reserved Invensys Systems Inc 33 Commercial Street Foxboro MA 02035 949 727 3200 http www wonderware com Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized In...

Page 3: ...ition 7 S3964R Topic Definition 8 Configuring the I O Server Settings 10 Server Settings 10 Accessing I O Server Help 12 Contents 12 How to Use Help 12 About S3964R 12 Item Names S5 Item Syntax 13 Data Blocks Extended Range Data Blocks 13 Flags 14 Inputs 14 Outputs 15 System Data Area 15 Absolute Address 16 Timers 16 Counters 16 Item Point Naming Examples 17 Item Names S7 Item Syntax 18 Data Block...

Page 4: ...erver into Excel 24 Writing Values to the I O Server from Excel 25 Troubleshooting I O Server Communication Problems 26 Debugging Communication Between InTouch and an I O Server 26 Debugging Communication Between SuiteLink and an I O Server 28 Debugging Communication Between an I O Server and a PLC 29 Special Wonderware Logger Messages 36 Siemens REPTEL Errors 36 ...

Page 5: ...cations The server application provides the data and accepts requests from any other application interested in its data Requesting applications are called clients Some applications such as InTouch and Microsoft Excel can simultaneously be both a client and a server FastDDE provides a means of packing many proprietary Wonderware DDE messages into a single Microsoft DDE message This packing improves...

Page 6: ...arge node count The network transport protocol is TCP IP using Microsoft s standard WinSock interface Accessing Remote Items via the I O Server The communication protocol addresses an element of data in a conversation that uses a three part naming convention that includes the application name topic name and item name The following briefly describes each portion of this naming convention applicatio...

Page 7: ...ibed in detail later The configuration file is automatically saved to the directory in which the server is installed unless a different directory is specified To perform the required configurations start up the server by double clicking on its icon If the server starts up as an icon double click on the icon to open the server s window To access the options used for the various configurations open ...

Page 8: ...epeat these steps select a COM Port set configuration and click Save Select a communication port connected to the Siemens device Enter the amount of time in seconds that all PLCs connected via this communication port will be given to reply to commands from the server Note This timeout is sustained only when the PLC fails to respond When the PLC is responding normally there is no penalty The defaul...

Page 9: ...and Parity Click Defaults to reset the settings to their default values without saving changes Click Save to save settings for the selected COM Port The dialog box will remain displayed giving you the option to configure additional COM Ports Click Done to close the dialog box If the settings have not been saved the following dialog box will appear Click Yes to save settings for the COM Port Click ...

Page 10: ... it is started Note When the server initially starts up it attempts to locate its default configuration file by first checking the WIN INI file for a previously specified path If a path is not present in the WIN INI file the server will assume that the current working directory is to be used Click Defaults to reset the settings to their default values without saving changes Click OK to save the co...

Page 11: ...heir names will be listed in the Topics section of this dialog box Click this button to close the dialog box and accept any new definitions modifications or deletions made To modify or view an existing topic definition select its name in the list and click on this button The S3964R Topic Definition dialog box described below will appear displaying the selected topic definition To delete an existin...

Page 12: ...is topic will appear in this field To select a different port click on the down arrow to open the list of communication ports Click on the name of the communications port to be associated with this topic Enter the address on the communications card in the PLC chassis Enter the frequency in milliseconds that the server will read poll the items points associated with this topic Set the option S7 Ite...

Page 13: ...lue will be polled and combined with the following pokes Note Different items points can be polled at different rates by defining multiple topic names for the same PLC and setting different update rates for each topic Once all the entries have been made click on the OK button to accept the entries and close the dialog box Click on the Cancel button to close the dialog box without saving changes Th...

Page 14: ...ly two to four times faster than the fastest rate desired to update data from the equipment Note The default protocol timer tick value will vary between servers Select this option if you are networking using Wonderware NetDDE To create a new default configuration file enter the complete path for the directory in which the file is to be saved in this field This new path will automatically be writte...

Page 15: ...r related problems that may arise such as missing adapter cards licensing failures or device drivers not loading will not be visible to the user until a log on is performed Disabling this option and rebooting the system will cause the server to run as a Windows NT application program once again Note It is highly recommended that the server is configured and communicating successfully prior to runn...

Page 16: ...used to access a list of basic instructions for using the Help file About S3964R This option is used to access miscellaneous information regarding the server such as the software version the copyright information license information etc Your FactorySuite system license information can be viewed through the license viewing utility that is launched from the About dialog box For more information on t...

Page 17: ...z Message 2 to 128 Left Byte D B X m DLn Integer 0 to 255 KF Integer 128 to 127 Right Byte D B X m DRn Integer 0 to 255 KF Integer 128 to 127 Word D B X m DWn Integer 0 to 65535 KF Integer 32768 to 32767 BCD Integer 999 to 999 KC Integer 0 to 999 KT Message 0 0 to 999 3 Double Word D B X m DDk Integer 2147483648 to 2147483647 BCD Integer 9999999 to 9999999 KG Real floating point Note All data bloc...

Page 18: ...CD Integer 9999999 to 9999999 KG Real floating point Note All flags are Read Only m 0 to 255 n 0 to 254 b 0 to 7 k 0 to 252 Inputs Data Format Items Suffix Tag Type Range Bit In b Discrete 0 or 1 En b Discrete 0 or 1 Byte IBn Integer 0 to 255 EBn Integer 0 to 255 KF Integer 128 to 127 Word IWm Integer 0 to 65535 EWm Integer 0 to 65535 KF Integer 32768 to 32767 BCD Integer 999 to 999 KC Integer 0 t...

Page 19: ... to 999 KT Message 0 0 to 999 3 Double Word QDk Integer 2147483648 to 2147483647 ADk Integer 2147483648 to 2147483647 BCD Integer 9999999 to 9999999 Note All Outputs are Read Only n 0 to 127 m 0 to 126 k 0 to 124 b 0 to 7 System Data Area Data Format Items Suffix Tag Type Range Word RSn Integer 0 to 65535 BSn Integer 0 to 65535 KF Integer 32768 to 32767 BCD Integer 999 to 999 KC Integer 0 to 999 K...

Page 20: ... to 999 3 Note All Absolute Addresses are Read Only h 0 to FFFF hex Timers Data Format Items Suffix Tag Type Range Word Tn Real 0 0 to 9990 0 Note All Timers are Read Only n 0 to 255 Counters Data Format Items Suffix Tag Type Range Word Cn Integer 0 to 65535 Zn Integer 0 to 65535 Note All Counters are Read Only n 0 to 255 ...

Page 21: ...4 value in controller is binary and has a range of 0 to 255 FD17KG or MD17KG flag double word 17 value in controller is binary floating point I106 3 or E106 3 bit 3 of input byte 106 FW29KC or MW29KC flag word 29 value in controller is in counter constant format DB7DW55KT data block 7 data word 55 value in controller is in timer constant format DB5S6 10 data block 5 starting data word 6 10 charact...

Page 22: ...teger 0 to 255 D B x BYTEm Integer 0 to 255 Char D B x CHARm Integer 128 to 127 Word D B x Wn Integer 0 to 65535 D B x WORDn Integer 0 to 65535 KT Message 0 0 to 999 3 Integer D B x INTn Integer 32768 to 32767 BCD Integer 999 to 999 Double Word D B x Dk Integer 0 to 2147483647 D B x DWORDk Integer 0 to 2147483647 Double Integer D B x DINTk Integer 2147483648 to 2147483647 BCD Integer 2147483648 to...

Page 23: ...to 65535 MWORDn Integer 0 to 65535 KT Message 0 0 to 999 3 Integer FINTn Integer 32768 to 32767 MINTn Integer 32768 to 32767 BCD Integer 999 to 999 Double Word FDk Integer 0 to 2147483647 MDk Integer 0 to 2147483647 FDWORDk Integer 0 to 2147483647 MDWORDk Integer 0 to 2147483647 Double Integer FDINTk Integer 2147483648 to 2147483647 MDINTk Integer 2147483648 to 2147483647 BCD Integer 9999999 to 99...

Page 24: ...5535 EWwnn Integer 0 to 65535 IWORDn Integer 0 to 65535 EWORDn Integer 0 to 65535 KT Message 0 0 to 999 3 Integer IINTn Integer 32768 to 32767 EINTn Integer 32768 to 32767 BCD Integer 999 to 999 Double Word IDkn Integer 0 to 2147483647 EDdnk Integer 0 to 2147483647 IDWORDk Integer 0 to 2147483647 EDWORDk Integer 0 to 2147483647 Double Integer IDINTk Integer 2147483648 to 2147483647 EDINTk 21474836...

Page 25: ...to 32767 AINTn Integer 32768 to 32767 BCD Integer 999 to 999 Double Word QDkn Integer 0 to 2147483647 ADdnk Integer 0 to 2147483647 QDWORD k Integer 0 to 2147483647 ADWORD k Integer 0 to 2147483647 Double Integer QDINTk Integer 2147483648 to 2147483647 ADINTk 2147483648 to 2147483647 BCD Integer 9999999 to 9999999 Note All Outputs are Read Only m 0 to 255 b 0 to 7 n 0 to 254 k 0 to 252 Timers Data...

Page 26: ...em DB100DR2 DB100 CHAR8 S7 item corresponds to S5 item DB100DL4KF DB30 W10 S7 item corresponds to S5 item DB30DW5 DB40 INT20 S7 item corresponds to S5 item DB40DW10KF DB100 D4 S7 item corresponds to S5 item DB100DD2 DB100 DINT4BCD S7 item corresponds to S5 item DB100DD2BCD DB100 REAL4 S7 item correspont to S5 item DB100DD2KG FDINT17 or MDINT17 S7 item corresponds to S5 item FD17 IDINT17 or EDINT17...

Page 27: ...d to monitor the status of communications with the PLC Monitoring the Status of Communications with InTouch InTouch supports built in topic names called DDEStatus and IOStatus that are used to monitor the status of communications between the server and InTouch For more information on the built in topic names DDEStatus and IOStatus see your online InTouch User s Guide Using DDEStatus and IOStatus i...

Page 28: ...s the name of the server application name S115U Is the exact topic name defined in the server for the PLC DB10DW20KF Is the actual location in the PLC that contains the data value This is the item name In this example each time the value of DB10DW20KF changes in the PLC the server will automatically send the new value to the cell containing the formula in Excel Note Refer to the Microsoft Excel ma...

Page 29: ...atement instead of the actual cell reference The applicationname and topicname portions of the formula must be enclosed in quotation marks POKE channel itemname Data_Reference POKEs the value contained in the Data_Reference to the specified item name actual location in the PLC via the channel number returned by the previously executed INITIATE function Data_Reference is the row column ID of the ce...

Page 30: ...rt both DDE and SuiteLink However the SuiteLink protocol is only supported on the Windows NT Version 4 0 or later operating system Servers respond to data requests made by other applications Requesting applications are called clients When WindowViewer acts as a client and requires the value of an item it contacts the server and requests the item s value The server will report the value and update ...

Page 31: ...ns dialog box appears listing all Access Names defined in the WindowMaker 2 In the Access Names list select the Access Name referencing the server and click Modify The Modify Access Name dialog box will appear 3 Verify the server s program name in the Application Name box is correct If it is wrong then correct it and click OK else click Cancel The server s exact executable name must be typed in th...

Page 32: ...ly the item naming conventions used by each server are consistent with the names used by the equipment manufacturer For more information on the Wonderware Logger see your online FactorySuite System Administrator s Guide If you are still experiencing problems continue with the following troubleshooting section Debugging Communication Between SuiteLink and an I O Server If you have successfully appl...

Page 33: ...tion cards that use the National 16450 and 16550 UARTs seem to be less susceptible to level and timing problems Cards based on other chips may work but we recommend using the National cards Some of the highly integrated UART chips most notably Winbond and UMC have a tendency for their transmitters to hang requiring re initialization of the UART If this occurs you may have to restart the server or ...

Page 34: ...nother communications port or another computer Note A common misconception is that if you can connect to a PLC with a DOS program that the same communication port will work in Windows this is not the case Windows is an entirely different environment than DOS What type of UART is on the COM port If it is not a 16550 then you must lower your baud rate to 9600 or slower Only the 16550 UART can sustai...

Page 35: ...ts that are available Does your computer lock up Verify the COM port s IRQs do not conflict with each other or with any other communication boards in the computer If the PLC or field device has more than one COM port verify that you are connected to the correct port The COM port on your computer uses the RS 232 hardware communication standard Meaning you must connect the cable from the COM port to...

Page 36: ...con The System Properties dialog box will appear Click the Device Manager tab and select the COM port that you are using for the server For example 6 Click Properties The Properties dialog box will appear Click the Port Settings tab ...

Page 37: ...k bar Point to Settings then click Control Panel in the menu The Control Panel dialog box will appear 2 Double click the Ports icon the Ports dialog box will appear 3 Select a port and click the Settings button The Settings for COMx dialog box appears 4 Click Advanced The Advanced Settings for COMx dialog box appears 5 Set the Interrupt Request Line IRQ value to the minimum Lowering this setting m...

Page 38: ...does not appear you do not have Administrator privileges 10 If the User Properties dialog box does appear click on the Groups button and verify Administrators is in the Member of list If you experience occasional or random communication errors in the Wonderware Logger for example Response Timeouts check for noise Do the physical cables run past any known noise sources such as photocopiers fluoresc...

Page 39: ...f the server user s guide for the exact name of the configuration file If possible reinstall the Windows operating system Some of the files that are installed on your computer or the NT registry may have been corrupted or accidentally modified If these troubleshooting suggestions do not solve your problem there may be a problem with your computer There are many subtle differences between the vario...

Page 40: ...pected Follow on Establish Link Error Old Error Code 0x2714 Failed on the follow on link establishment Response BCC Error Old Error Code 0x2715 Failed to receive the BCC response from the COM CP52x card Note Server versions 4 11 or earlier will report Wonderware Logger error numbers 27xx in the following format CP52X REPTEL ERROR CODE 2712 SYSSTAT Server version 5 0 and higher will report Wonderwa...

Reviews:

No comments

Related manuals for 3964R

Brand: Unisys Pages: 20

Brand: Xerox Pages: 2

UniServer BT716F

Brand: H3C Pages: 44

Brand: Hawking Pages: 40

BladeCenter HS21 1885

Brand: IBM Pages: 140

Sun Fire Netra 1280

Brand: Sun Microsystems Pages: 10

Brand: Magnimage Pages: 42

PRIMERGY RX300 S6

Brand: Fujitsu Pages: 132

PRIMERGY RX300 S5

Brand: Fujitsu Pages: 112

PRIMERGY RX2540 M4

Brand: Fujitsu Pages: 86

PRIMERGY RX2540 M6

Brand: Fujitsu Pages: 121

PRIMERGY RX4770 M6

Brand: Fujitsu Pages: 468

PRIMERGY RX2540 M1

Brand: Fujitsu Pages: 92

PRIMERGY RX2540 M5

Brand: Fujitsu Pages: 112

PRIMERGY RX2540 M4

Brand: Fujitsu Pages: 639

PRIMERGY RX2540 M2

Brand: Fujitsu Pages: 602

PRIMERGY RX2530 M5

Brand: Fujitsu Pages: 486

PRIMERGY RX2540 M1

Brand: Fujitsu Pages: 438

Brands by name

0 1 2 3 4 5 6 7 8 9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Popular brands

Load more brands