Win-DDE DYNAMIC DATA EXCHANGE 8VHU V *XLGH 8525-M278-O1 Rev 2.19 04/03/07 PO BOX 151 WEBB CITY, MO 64870 PH (417) 673-4631 FAX (417) 673-5001 http://www.cardinalscale.com Technical Support: Ph: 866-254-8261 techsupport@cardet.
Win-DDE 2.19 April 03, 2007 Specifications Cardinal Scale Manufacturing Company offers a complete line of digital weight indicators supported by the Win-DDE (Dynamic Data Exchange) server. Indicators can be interfaced to any type of external scale device including truck scales, tank scales, and platform scales. Up to 20 weight indicators may be connected to a single computer running Win-DDE. The computer must be properly configured with serial ports or network hardware to allow the connections.
Industrial control and monitoring: Rockwell Automation RSView, AutomationDirect LookoutDirect, Wonderware InTouch Database: Microsoft Access, Microsoft FoxPro Spreadsheets: Microsoft Excel, Lotus 1-2-3, Novell Quattro Pro Various configuration settings are available. DDE topic names, item names Indicator types Baud rate, parity, data bits, stop bits Continuous or on-demand communications Sample intervals Weight string format Win-DDE digital weight indicator DDE client program is also included.
6. The display will show “PrtY=”. Press “ENTER”. The display may show “0” indicating no parity. If the display does not show “0”, press the “0” key to make the display show “0”. Press “ENTER”. 7. The display will show “bits=”. Press “ENTER”. The display may show “8” indicating eight data bits. If the display does not show “8”, press the “8” key to make the display show “8”. Press “ENTER”. 8. The display will show “StoP=”. Press “ENTER”. The display may show “1” indicating one stop bit.
The computer must have a properly configured network card. If the computer is connected to a group of other computers a port may be available on a network hub or switch to connect the indicator. If no ports are available it will be necessary to add a new network hub or switch to provide additional connection ports. A normal straight-through Ethernet cable can be used to connect the indicator to the hub or switch.
The Win-DDE program will start. Win-DDE may be configured to start hidden, except for a system tray icon. - XP Click the “Win-DDE” icon in the system tray, usually at the bottom right of the display, to make the Win-DDE window appear. Configure the DDE Server Click “Tools” on the menu bar. Click “Setup Indicators…”. A dialog box will appear allowing up to 20 indicators to be configured.
1 - 20 Click the appropriate tab “1” – “20” to specify the indicator to be configured. Enabled Check the “Enabled” check box to enable the indicator. Name A descriptive name may be entered for the indicator. COMMUNICATIONS Profile For a SMA compatible indicator select the "SMA_DMD" option for the SMA format on-demand weight. The Cardinal 200 series indicators are SMA compatible. Both receive and transmit wires must be connected for on-demand communications.
For the 200 series indicator configuration described above select "9600." Parity For the 200 series indicator configuration described above select "N" for no parity. Data For the 200 series indicator configuration described above select "8" for eight data bits. Stop For the 200 series indicator configuration described above select "1" for one stop bit. TCP/IP To communicate with TCP/IP network indicators set the “Device Port” prompt to “TCP/IP”.
CAPTURE Win-DDE client applications will have access to the continuously updating weight and status information when connected to an indicator providing this data. Win-DDE may also be configured for additional capture features. Only some indicator models such as the Cardinal 220 allow on-demand weight and printout on the same communications port. Printer Output Check “Printer Output” to enable the Win-DDE feature of automatic printer output capture.
A Excel spreadsheet may be created as a template with headings and formulas. WinDDE may be configured to use the template file and create a new filename based on the date. When the date changes while Win-DDE is running the current Excel file is saved and the template file is again copied to create a new file for the new date. To configure this behavior save the blank excel file (header text may be in the file) to a specific path such as: “C:\WT.XLS”. Specify the capture filename as “C:\WT*” (Do not include
Indicator Profiles ID Change the “ID” to make a copy of the current profile. On-demand Check the “On-demand” check box to specify that the indicator is set for on-demand communications. Enquiry Set the “Enquiry” code that the computer will send to the indicator to request the on-demand weight. For SMA format this is W represented as %0AW%0D (% - indicates the next two characters are a hexadecimal code, 0A hex is a line-feed, 0D hex is a carriage return).
Interval (ms) Set the “Interval” for on-demand requests in milliseconds. 300 milliseconds is approximately three times a second. Start Chrs Set the character that is the last character sent from the indicator for a weight record. For SMA format this is a carriage return, represented as %0D. End Chrs Set the character that is the first character sent from the indicator for a weight record. For SMA format this is a line-feed, represented as %0A. Min Len Set the minimum length for a weight record.
Start Chrs: Specify the starting characters to indicate the character to start receiving a printout from the indicator. End Chrs: Specify the ending characters to indicate the end of a printout. Leave this field blank to indicate a timeout method of determine the end of the printout. 1 – 10 Click the appropriate tab to specify the printout field capture item to be configured. Find: Specify the data string to search for to indicate the item in the printout.
The “Commands” menu option is used to send commands to the weight indicator. Refer to the indicator profile to configure the data to be sent to the indicator for each command. Any commands that are not defined in the indicator profile will be disabled (shown in gray). Click “Zero” to send the zero command to the weight indicator. Some models of weight indicators do not support the capability of zeroing from the computer so this command may be ignored.
Click “Count…” to show the count sample dialog box. A number of items may be placed on the scale. Type the appropriate number in the “Sample Size:” prompt. A greater number of items will program greater counting accuracy. The items must have a uniform weight. Click the “Sample” button. The display will show: Place the correct number of sample items on the scale. Wait for the scale to stabilize and click the “OK” button. The “Average Piece Weight” prompt will automatically be set.
Click “Sound Options…” to display the sound options dialog box. Your computer must be equipped with a sound card and speakers for sound options to function. No Voice The DDE Server will not speak. Vocal Weight The DDE server will speak the weight. Vocal Count The DDE server will speak the count. If either “Vocal Weight” or “Vocal Count” is specified an additional selection for “Female Voice” or “Male Voice” is available.
The “Enable Sound Effects” check box should be checked to allow the The DDE Server will play up to 10 sounds in the form of wav files. For example a particular wav file may play when a weight of 24000 pounds is reached. Another wav file may play when a weight of 78000 pounds of the scale capacity is reached. Number tab Use the “Number” tab to specify the sound to edit from “1” through “10”. The prompts which follow will indicate the settings for the specified sound.
Help The “Help” menu option is used to access the “About box”. Click “About…” to display an about box which will give the version of the DDE server. The “http://www.cardinalscale.com” button may be clicked to open the Cardinal Scale main web page if the computer has internet access. Click the “OK” button to return to main Win-DDE screen. File The “File” menu option is used to access the “Exit” function.
Click “Exit” to close the DDE server or hide the server window. Click “Yes” to exit the Win-DDE server, or click “No” to keep Win-DDE running, but hide the server Window. Click the Win-DDE icon in the system tray to show the server window when it is hidden. Reading information from the server Three pieces of data must be specified by a DDE client program before any information can be obtained from a DDE server. • Application or Service - This is generally the program name, "WINDDE".
STR String Weight string, for example, "40500 LB G MO." WT Numeric weight, for example, 40500. STAT Number (Double) String INFO String OC Number (Boolean) BZ Number (Boolean) MO Number (Boolean) CZ Number (Boolean) UNITS Number (Integer) MODE Number (Integer) CNT Number (Integer) WT1 Number (Double) WT2 Number (Double) WT3 Number (Double) “ “ – Normal weight, “OC” – Over Capacity, “BZ” – Below Zero, “MO” – Motion, or “CZ” – Center-of-Zero.
OpenOffice Calc To read the weight value into a OpenOffice Calc cell enter the following: =DDE("WinDDE";"SCALE";"WT") This will provide automatically updating data in the spreadsheet cell.
You may create a chart based on the numeric cells. As the weight changes the value in the cell and the chart display will automatically update. Quattro Pro for Windows To read the weight string into a Quattro Pro for Windows spreadsheet cell enter the following: @DDELINK([WINDDE|SCALE]"STR") This will provide automatically updating data in the spreadsheet cell. To read the numeric weight into the cell replace the "STR" with "WT.
Microsoft Access A simple way to obtain DDE data in Microsoft Access is to create a form. Within the form create a text display box. In the properties setting for the text box select the "Control Source." Type the following: =DDE("WINDDE", "SCALE", "STR") This will make the weight string appear in the text box when the form is opened. This method will only obtain the information when the form is opened. The display will not update automatically.
The display shows a menu bar across the top of the window. The weight display is below the menu bar. Status indicators are placed below the weight display to show various conditions. A keypad for general scale functions is at the bottom right side of the window. DISPLAY This display shows the gross, tare, or net weight value. STATUS INDICATORS The status indicators show the condition of the indicator.
Gross, Tare, Net An arrow points to the Gross, Tare, or Net label to show the mode the indicator is in. Motion An arrow is visible above the Motion label when the indicator is in motion. Zero An arrow is visible above the Zero label when the gross weight is at zero. OC An arrow is visible above the OC label when the indicator is over capacity. Lb/Kg An arrow points to Lb or Kg to show whether the indicator is displaying the weight in pounds or kilograms.
The KB TARE key perform a Keyboard Tare function. When this key is pressed an additional display window appears. A new tare weight may be keyed in. Click OK to resume normal operations. The indicator will be placed in the Net mode. Print Pressing the Print key will cause a ticket to be printed using the default Windows printer. If the indicator is in motion the display will show: Click OK. When motion ceases, click the Print button again to print the ticket. WinWeigh Digital Indicator Cardinal Scale Mfg.
Zero Click the Zero key to zero the scale, if it is within the zero range. Info Click the Info key to provide a window with information about the software versions. MENU BAR A menu bar across the top of the indicator provides several functions. FILE Open - This command displays a standard windows file-open box to allow alternate indicator configuration settings to be loaded into memory. Save - This command saves any changes made to the configuration settings.
Push-Button Tare - This command performs the same function as the PB Tare button on the keypad. Keyboard Tare - This command performs the same function as the KB Tare button on the keypad. Lb/Kg - This command performs the same function as the Lb/Kg button on the keypad. Zero - This command performs the same function as the Zero button on the keypad. Configuration - This command provides a display window to edit the configuration settings.
MODE Gross - This command performs the same function as the keypad Gross key. Tare - This command performs the same function as the keypad Tare key. Net - This command performs the same function as the keypad Net key. STYLE Font - This command displays a standard Windows font setting box to allow selection of the display font for the weight display window. Keypad On - This command causes the keypad and the lower half of the Indicator to appear. See "Keypad Off." below.
Win-DDE is written in Microsoft Visual C++ using the Microsoft Foundation Classes. Win-DDE is a multi-threaded Win32 application providing high-performance. Win-DDE uses Winsock 1.1 or 2.0 for TCP/IP communications. Predefined Device Profile Information 205CAP – Permits print capture of gross, tare, and net weight. 205 Setup – 1. Press “*”. The display will show “Funct=”. Press “REVIEW”. 2. The display will show “PUO=” Press “ENTER”. The display will show “no”. Press “ENTER.” 3.
15. The display will show “GroSS=”. Press “ENTER”. The display will show the current tab setting for the gross weight. Press the “*” key to change the values and the “UNITS” key to move the cursor as necessary until the display shows “3.01”. Press “ENTER”. 16. The display will show “tArE=”. Press “ENTER”. The display will show the current tab setting for the tare weight. Press the “*” key to change the values and the “UNITS” key to move the cursor as necessary until the display shows “4.01”. Press “ENTER”.
6. The display will show “Sio?” Press “ENTER”. The display will show “no”. Press the “1/YES” key to change the display to “YES”. Press “ENTER”. 7. The display will show “bAUd=” Press “ENTER”. The display will show the current baud rate setting. For the default 9600 baud press the “9” and “6” key so that the display shows “96”. Press “ENTER”. 8. The display will show “PrtY=” Press “ENTER”. The display will show the current parity setting.
to “4.01” so that the net weight is provided on the fourth line of the output. Press “ENTER”. 17. The display will show “G ACC=”. Press “ENTER”. The display will show the current tab setting for the gross accumulator. Press the “0” key to change display to “0.00” sot that the gross weight accumulator is not provided on the output. Press “ENTER”. 17. The display will show “n ACC=”. Press “ENTER”. The display will show the current tab setting for the net accumulator.
How to get GROSS TARE NET from the 210 to WinDDE To get the output shown below the indicator tabs must be set correctly as well as some additional setup in WinDDE. The additional setup in WinDDE is not extensive, it is only a slight modification to the 210_CAP profile. If a profile named 210_PRINT does not exist it will need to be created, otherwise just choose the 210_PRINT. To create the 210_PRINT profile, choose the 210_CAP profile and click the edit button beside it.
Depending on the version of WinDDE, the Setup Indicators window should look similar to the screenshot below. Choose the correct Device Port and ensure that the communications setting are correct and press OK. 210PRINT – Permits print capture of gross, tare, and net weight. 210 Setup – 1. Press “*”. The display will show “Funct=”. Press “REVIEW”. 2. The display will show “PUO=” Press “ENTER”. The display will show “no”. Press “ENTER.” 2. The display will show “td=” Press “ENTER”. The display will show “12”.
12. The display will show “Cont2=” Press “ENTER”. The display will show the current setting for continuous data for serial port two. For printer capture the indicator must not be continuous. Press the “0/NO” key so that the display shows “no”. Press “ENTER”. 13. The display will show “Print?”. Press “ENTER”. The display will show “no”. Press the “1/YES” key to change the display to “YES”. Press “ENTER”. 14. The display will show “Port=”. Press “ENTER”.