Toshiba T-PSV Operation Manual Download Page 27 | Manualshive

Page: 27 / 38

background image

26

DDE Server T-PSV

5. Using Excel as DDE Client

5.2 Starting up T-PSV from Excel

It is possible to start the T-PSV (go to on-line) from Excel by the following procedure.

(1) Open the Excel file.

(2) The following message will be displayed when you open the file.

The workbook you opened contains automatic links to information in another workbook.
Do you want to update this workbook with changes made to the other workbook?
(in case of Excel 97)
Then click [Yes] button.

(3) Then the following message will be displayed.

Remote data not accessible. Start application 'PLCSRV. EXE'?
Click [Yes] button.

(4) T-PSV will start data gathering with the latest configuration setting.

«
...
25
26
27
28
29
...
»

Summary of Contents for T-PSV

Page 1: ...UM TS03 E044 PROGRAMMABLE CONTROLLER PROSEC T SERIES DDE SERVER T PSV Version 1 1 OPERATION MANUAL TOSHIBA CORPORATION ...

Page 2: ... Toshiba Corporation reserves the right to make changes and improvements to this publication and or related products at any time without notice No obligation shall be incurred other than as noted in this publication This publication is copyrighted and contains proprietary material No part of this book may be reproduced stored in a retrieval system or transmitted in any form or by any means electri...

Page 3: ...cedure 15 3 1 Operation procedure 15 4 Configuration File 17 4 1 Example of the configuration file 17 4 2 Inside the configuration file 18 4 2 1 Connection setting 19 4 2 2 Serial setting 19 4 2 3 PLC setting for Ethernet 20 4 2 4 PLC setting for Serial 20 4 2 5 Tag setting 21 5 Using Excel as DDE Client 24 5 1 Reading PLC data into Excel spreadsheet 24 5 2 Starting up T PSV from Excel 26 5 3 Writ...

Page 4: ...ile specifies the PLC communication method data sampling timing Tag name designation etc This file is CSV format which can be edited by Excel etc DDE client application Excel Visual Basic etc The PLC s data can be displayed on Excel spreadsheet by designating the Tag name with the DDE expression Data writing into the PLC is also possible by using VBA T PSV program The T PSV is a program to gather ...

Page 5: ... Ethernet interface Up to 64 PLCs can be connected to the T PSV The transmission speed is 10Mbps In this configuration personal computer s Ethernet port is used 2 RS485 Computer link connection The RS485 computer link connection is available with T1S T2E T2N T3 T3H S2T S2 and S3 These PLCs have an RS485 computer link port on the CPU module Up to 32 PLCs can be connected to the T PSV The transmissi...

Page 6: ...20 connection Up to 64 PLCs can be connected to the T PSV via TOSLINE S20 The transmission speed is fixed at 9 6kbps In this configuration personal computer s Serial port is used to connect with the loader port of the TOSLINE S20 station Note TOSLINE S20 is a Toshiba s high speed control data network Three types of network configuration are available co axial bus optical bus and optical loop The t...

Page 7: ...net Serial RS232C Communication speed 10Mbps 1200 2400 4800 9600 or 19200 bps Number of PLC connected Max 64 RS485 computer link max 32 Programmer port 1 TOSLINE S20 max 64 Either 1 system of above Communication port support 1 Ethernet port 1 Serial port or both Data update cycle setting 3 cycles setting per interface High 0 2 second or more Middle 0 3 second or more Low 0 4 second or more Number ...

Page 8: ...Install the T PSV To install the T PSV into your hard disk insert the T PSV master disk into the floppy disk drive then operate as follows Windows Start menu Settings Control Panel Double click Add Remove Programs Double click here Click here ...

Page 9: ...8 DDE Server T PSV 2 Getting Started Click Install Then follow the message displayed on the screen You will install the T PSV from floppy disk Its installation program is A Setup exe Click here ...

Page 10: ...Operation Manual 9 2 Getting Started When you select the T PSV installation program correctly the T PSV installation wizard will be started as follows Click Next to start installation ...

Page 11: ...on folder is c Program Files Toshiba T PSV If you change the installation folder click Browse and select the folder Click Next and follow the message to proceed the installation When T PSV is installed normally the following screen will be displayed Click Finish ...

Page 12: ...d normally let s startup the T PSV The detailed operation setup procedure will be explained in the following sections This section introduces basic operation for starting up and finishing the T PSV and T PSV screen description To startup the T PSV select T PSV from the Start menu Click here ...

Page 13: ...s follows Configuration file open dialog is displayed only at the initial starting up Once a configuration file is designated the T PSV will be started with the latest configuration at the next time As you can see a sample configuration file Sample csv has been installed with the T PSV Let s select the Sample csv here ...

Page 14: ... the PLC s response time Status shows the communication status between the T PSV and the PLC as follows Stopped Communication with the PLC is not executing Receiving Data is receiving from the PLC within the specified update cycle Cycle over Data could not be received within the specified update cycle Timeout There is no response from the PLC within the specified timeout setting Error Error respon...

Page 15: ...tatus bar Split Changes the screen split position Status Hold Holds the status display except Receiving Refresh Displays the latest status Data Start Starts data gathering on line Stop Stops data gathering off line Help About T PSV Displays the version information of the T PSV Toolbars 2 4 Finish the T PSV To finish the T PSV select File Exit Stops data gathering red color when enable Starts data ...

Page 16: ...ings for the connection PLC information IP address for Ethernet station number for serial PLC model etc Tag setting tag name corresponding PLC register update cycle designation etc Refer to section 4 for the configuration file setting details A sample configuration file Sample csv has been installed together with the T PSV in the same folder You can use this file to create your configuration file ...

Page 17: ...folder for your reference 3 Execute the T PSV Execute the T PSV and open the configuration file you created If PLCs are connected on the communication line you can start the data gathering on line Then you will see the communication status on the T PSV screen 4 Execute the DDE client application When you start the DDE client application and the DDE link is established you will see the data is upda...

Page 18: ...the configuration file is shown below Excel 97 screen Note that the configuration file must be CSV comma delimited format When you create and save the file by Excel specify as CSV format In CSV format comma is used to separate each column Therefore you cannot use comma even in the comment line ...

Page 19: ... on Ethernet IP address port number PLC model etc T TA 1st Tag of 1st PLC Tag name corresponding PLC register device update cycle etc T 2nd Tag of 1st PLC Ditto PE 2nd PLC on Ethernet IP address port number PLC model etc T TA 1st Tag of 2nd PLC Tag name corresponding PLC register device update cycle etc T 2nd Tag of 2nd PLC Ditto C Connection setting Ethernet or serial update cycle setting etc If ...

Page 20: ...setting Low update cycle in second Low speed update cycle setting Minimum 0 4 0 1 s increments It must be larger than middle speed setting 4 2 2 Serial setting If the connection setting is serial the serial setting is required The serial setting specifies the computer s communication port baudrate data bit length parity and stop bit length The setting details and the column order are as follows Se...

Page 21: ... Serial This is the PLC setting for serial connection It specifies the PLC name PLC station address and PLC model The setting details and the column order is as follows Setting ID PS PLC name Any name within 15 characters Station address 1 to 32 If TOSLINE S20 is used it is 1 to 64 PLC model T1 T1S T2 T2E T2N T3 T3H S2T S2 or S3 Programmer port Yes or No If programmer port is used set Yes Note Whe...

Page 22: ... designation Setting ID T Tag name Any name within 13 characters Register device address PLC s register device address Allowable types are X Y Z L R S XW YW W LW RW SW T C D F T or C 18 types Allowable address is dependent on the PLC type Update cycle HIGH MIDDLE or LOW upper and lower cases are not distinguished Data type INT integer DINT double word integer UINT unsigned integer UDINT unsigned d...

Page 23: ...t distinguished TA line only Data type INT integer DINT double word integer UINT unsigned integer UDINT unsigned double word integer HEX hexadecimal DHEX double word hexadecimal REAL floating point data BOOL logic BCD binary coded decimal or DBCD double word BCD Default is INT integer upper and lower cases are not distinguished Setting example TA PLC2NAM0 D0000 HIGH INT PLC2NAM1 INT TA PLC2NAM248 ...

Page 24: ... 2147483648 to 2147483647 Occupies 2 Tags UINT 0 to 65535 UDINT 0 to 4294967295 Occupies 2 Tags HEX 0 to FFFF DHEX 0 to FFFFFFFF Occupies 2 Tags BOOL 0 or 1 False or True 0 1 is for data writing only REAL 3 40282E 38 to 3 40282E 38 Occupies 2 Tags BCD 0 to 9999 DBCD 0 to 99999999 Occupies 2 Tags Bank number 1 15 at 8K bank T3H 1 2 at 64K bank T3H 1 8 at 64K bank S2T Bank type A 8K bank T3H only B ...

Page 25: ...nformation in another workbook Do you want to update this workbook with changes made to the other workbook in case of Excel 97 Then click Yes button By the above operation DDE link will be established If you start the data gathering with T PSV the data of the Excel cell will be changed By using the Chart wizard function of Excel you can monitor the data in the graph view Note 1 When you modify cha...

Page 26: ...nd W Display format is fixed to INT 0 or 1 This method is useful when using the continuous address designation 2 PLC status monitor The PLC status can be monitored by using the following expression PLC operation mode Plcsrv T PLC name mode This DDE function gives the following data according to the PLC current operation mode 1 HALT 2 RUN 3 RUN F 4 HOLD 6 ERROR Display format is fixed to INT PLC st...

Page 27: ...splayed when you open the file The workbook you opened contains automatic links to information in another workbook Do you want to update this workbook with changes made to the other workbook in case of Excel 97 Then click Yes button 3 Then the following message will be displayed Remote data not accessible Start application PLCSRV EXE Click Yes button 4 T PSV will start data gathering with the late...

Page 28: ...ur VBA code go to the menu View Toolbars Forms 9 Select the button item from the Form Toolbar and paste it onto the Excel sheet 10 Assign Macro dialog is displayed Then select the macro name that you created Rtecord1 and click OK button 11 Then when you click the button your VBA code will be executed 12 If your T PSV is already started the data will be written into the PLC Note that the data to be...

Page 29: ...l sData As String As Long Record1 Macro Date 2000 11 07 UserName Sample Sub Record1 Dim lRet As Long Dim szData As String szData Sheets Sheet1 Range A1 Value lRet PlcPoke SWITCHI1 szData End Sub This sample writes the data of cell A1 into the Tag named SWITCH1 Above sample VBA code is included in the sample Excel file PlcBook xls which is installed in your computer together with T PSV ...

Page 30: ...before serial setting Continuous Register Tag cannot be used for Device Bit data In the Tag setting Device bit data is designated as continuous address Tag Use Register for the continuous address Tag Continuous Register Tag must be started with TA In the Tag setting the starting address Tag is missing The starting address Tag TA is necessary Continuous Register Tags and Individual Tags cannot be u...

Page 31: ...gh middle or low IP address is duplicated In the PLC setting IP address is duplicated Set the IP address correctly IP address is not correct In the PLC setting illegal IP address is used Set the IP address correctly Item must be separated by comma In the configuration file setting items are not separated by comma Separate each item by comma Use CSV format Low speed cycle must be greater than Middl...

Page 32: ...for one PLC in Low speed cycle Only one block is allowed Multiple Continuous Register Tags per one PLC cannot be used in Middle speed cycle In the Tag setting multiple blocks of continuous address Tags are designated for one PLC in Middle speed cycle Only one block is allowed No machine plc file The PLC definition file machine plc could not be found Install the T PSV again No Baudrate setting In t...

Page 33: ...ng In the Tag setting update cycle high middle or low is not designated for a Tag Set the update cycle Only 1 Ethernet connection is allowed In the configuration file more than one 1 Ethernet connections are designated Only 1 Ethernet connection is allowed Only 1 Serial connection is allowed In the configuration file more than one 1 serial connections are designated Only 1 serial connection is all...

Page 34: ...evice must be 10 characters or less Register Device is not correct In the Tag setting invalid register device type or invalid address is designated Check the register device Register Device is out of the allowable range In the Tag setting register device address is out of the range Set the register device correctly Runtime Error Program pass name R6028 unable to initialize heap Windows heap memory...

Page 35: ...ter that cannot designate as double word Set the data type correctly The expanded F Register cannot be used for the Individual Tags In the Tag setting expanded F register is designated as the individual address Tag Expanded F register access is available as the continuous address Tag The expanded F Register cannot be used for the selected PLC type In the Tag setting expanded F register is designat...

Page 36: ...ng for the Connection Name exceeds the maximum MAX 64 for each connection In the configuration file the number of PLCs for one connection exceeds 64 Reduce the PLCs The number of TAGs exceeds the maximum Max 4096 in total In the configuration file more than 4096 Tags are designated The maximum number of Tags is 4096 Timeout is out of allowable range In the connection setting timeout setting is mor...

Page 37: ...36 DDE Server T PSV ...

Page 38: ...TOSHIBA CORPORATION Industrial Equipment Department 1 1 Shibaura 1 chome Minato ku Tokyo 105 8001 JAPAN Tel 03 3457 4900 Fax 03 5444 9268 ...

Reviews:

No comments

Related manuals for T-PSV

eTrex H - Hiking GPS Receiver

Brand: Garmin Pages: 100

Brand: Xerox Pages: 204

Altiware HPBX 5.0A

Brand: Altigen Pages: 490

Brand: SanDisk Pages: 11

Brand: Octel Pages: 64

OPEN WORKGROUP SUITE SMALL BUSINESS EDITION 9.3 - ADMINISTRATION 10-2007

Brand: Novell Pages: 30

Brand: Acer Pages: 20

Brand: Acer Pages: 33

Brand: Acer Pages: 118

Unity Express 8.0 Voice-Mail System

Brand: Cisco Pages: 50

TELEPRESENCE MANAGEMENT SUITE PROVISIONING

Brand: Cisco Pages: 16

Unified MeetingPlace H.323/SIP

Brand: Cisco Pages: 54

PVDM2 24DM - Digital Modem Module

Brand: Cisco Pages: 48

TELEPRESENCE MANAGEMENT SUITE SECURE SERVER

Brand: Cisco Pages: 34

Brand: Cisco Pages: 8

Unified Videoconferencing Manager

Brand: Cisco Pages: 22

SMART BUSINESS COMMUNICATIONS SYSTEM

Brand: Cisco Pages: 27

MDS 9222i - Multiservice Modular Fabric Switch

Brand: Cisco Pages: 40

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