Home

ws02-edmc1-v2 user`s manual

1. SPL1801_00 se Realtime 3ampling SPURO Select the copy to store and click Create Table Perform the database storage settings and J SPUHOI_O1 create the data table in the EDMS database Bj sPUgOo1_02 3 SPUROI_03 Copy sampling SPU 01 Create Table Specify the data table name Data table name Mame SPU O1 Copy sampling Comments Task Select the variables to store in the data table Select the variables to store in the data table If the number of fields in the data table is exceeded reduce the number of variables to store Display the EDMS database list Display the full list of EDMS databases Y Created table Click the OK Button 48 Data Table Storage Operations Section 4 5 4 5 Data Table Storage Operations This section describes the procedure for storing data in a database 4 5 1 Controlling Data Storage from a List Database storage settings can be enabled or disabled and data storage can be stopped or started from a list of database storage setting files These oper ations are possible for one or for more than one database storage setting files at the same time 1 2 3 1 Select the SPU Unit connected to the database on the Database Storage Tab Page As shown below a pane that enables controlling database stor age for the databases set for the selected SPU Unit will be displayed E EDMS Console File Database Storage Help File Copy Database Storage
2. Data collection name Copied yymmdd O First Record Time Last Record Time we N i Copied hhmmss e O Consecutive number First record yymmdd a First record hhmmss NX SN Ww PS Last record yymmdd Last record hhmmss Consecutive number from source file xa x Unique ID SPU unit check interval 104 8 C Set the computer time to match the PLC Operating Procedures Section 3 2 The following items can be selected from the Advanced Setting Window lem Description O Folder to copy to Shows the save path for copied files A path can entered directly or it can be selected or created by clicking the Button Default values see note can be restored by clicking the Restore Defaults Button Note The default values are as follows SPU_Unit_namelCopy_name files are saved to the EDMS DatalCopy Files folder in My Documents Format of the copied file Specifies the name of a copied file using one or a combi nation of objects such as the month day and year or the hour minutes and seconds the file was copied the data collection name or consecutive file numbers Standard formats can be specified from the Template Area or they can be edited to specify a non standard for mat Examples of actual file names are available in the Sample file Monitoring cycle of the Sets the monitoring cycle in seconds for determining unit whether or not copying is possible The default setting is 10
3. ff SPU units SPU 01 SPUHOI Realtime Sampling gh SPU 01_00 Sampling Name SPUHO IP address 192 168 39 191 Database Storage List Copy Enable Storage Sta Copy Status l Start Realtime Sampling Enabled Stopped Stopped Sampling Disabled ae Stopped Stop Sampling Disabled Running Sampling3 Disabled Stopped The copy task M start stop too Enable Disable fy SPU 01_02 gh Sampling2 SPU 01 J SPU 01_03 gh Sampling3 SPU HO1 If this option is selected copying data will be started and stopped at oe the same time as database storage is started and stopped If this option is not selected the copy operation will function independently Note The Database Storage List Area shows the collection pattern set ting files for which database storage has been set To control data storage from this list set up database storage first 2 Select one or more collection pattern setting files in the list 3 Click the Start Stop Enable or Disable Button Note The Start and Stop Buttons can be used only for database storage settings that have been enabled To use the Start and Stop But tons first click the Enable Button to enable the database storage settings 49 Data Table Storage Operations Section 4 5 50 SECTION 5 Troubleshooting and EDMS Capabilities This section provides information on troubleshooting errors that can occur with the SPU
4. 1 Administrator privileges are required to use the EDMS Console Log on as the administrator 2 Only one copy of the EDMS Console can be run at the same time 2 2 2 Exiting the EDMS Console Select Exit from the File Menu of the EDMS Console The EDMS Console will close 2 3 Basic Operating Procedures The basic operating procedures are given below Perform the procedure in 2 3 1 Procedural Flow for Copying Data to use the EDMS Console copy func tion to copy data from SPU Units to the computer Perform the procedure in 2 3 2 Procedural Flow for Database Storage to store the data copied to the computer in a database 2 3 1 Procedural Flow for Copying Data 2d 1 Connect a computer with the EDMS Console installed to a SYSMAC SPU Unit via a LAN cable The method is the same as that for the SPU Console 2 Select Program OMRON EDMS EDMS Console from the Windows Start Menu to start the EDMS Console Refer to 2 2 1 Starting the EDMS Console and 3 2 1 Procedural Flow 3 Register the SPU Units specify the IP addresses 12 Basic Operating Procedures 10 Section 2 3 Refer to 3 2 3 Registering SPU Units Click the Refresh Button to update the list if necessary Refer to 3 2 4 Updating the List of SPU Units and Copies as Re quired The List of Copied Files Pane will be updated in the SPU Copy Tree Select the Copy of file and Activate this copy Options Refer to 3 2 5 Setting Files to Copy Click the Advanced Set
5. spu 01 realtime sampling 06051 9 100958 000 spu 01 realtime sampling 06051 9 100958 000 s No of copies 36 File Size C Register to Bookmarks Display Folder First Record 5 19 2006 10 18 01 Al 5 19 2006 10 18 02 AM 5 19 2006 10 18 04 AM 5 19 2006 10 18 05 AM 5 19 2006 10 18 07 4M 5 19 2006 10 18 08 AM 5 19 2006 10 18 10 AM 5 19 2006 10 18 11 AM 5 19 2006 10 18 13 AM 5 19 2006 10 18 14 AM 5 19 2006 10 18 16 AM 5 19 2006 10 18 17 AM 5 19 2006 10 18 19 AM 5 19 2006 10 18 20 AM 5 19 2006 10 18 22 AM 5 19 2006 10 18 23 AM 5 19 2006 10 18 25 AM 5 19 2006 10 18 26 AM Y Operation Advanced f File MA Details Display Log ltem Filename File size No of records First record Last record Copied Path CiDocuments List of Copied Files 17 Window Configuration of Copy Function Section 3 1 Copy Settings Copy Settings Operation Area Status Area 18 The Copy Information Window consists of the following panes Name Deseripti n Copy Settings Selects the copy function and starts or stops copying List of Copied Files Displays the files that have been copied to the computer File Details The details on a file copied to the computer will be displayed if the file name in the File Copy List Pane is clicked The Copy Setting Pane is used to select the copy function or to start and stop copying a file selected from the SPU Copy Tree It is also used to display copy status co
6. tem Overview Section 1 1 1 1 3 EDMS Structure The EDMS consists of the following programs EDMS Console FinsGateway Service Copy Setting Window Copy Task Service Database Storage Setting Window Database Storage Service Microsoft NET Framework1 1 Microsoft Windows 2000 XP The Copy Task Service copies files from an SPU Unit and saves them to a computer hard disk on the same network The service operates in the back ground and is used to monitor SPU Units Copy Task Service Database Storage Service The Database Storage Service stores the files that are copied to the computer into a database The service operates in the background EDMS Console The EDMS Console is a user interface program that provides access to the setting windows It accesses the Copy Setting Window for example to allow the user to input Copy Task Service settings specify operations and monitor operating conditions The program displays the files that have been copied to the computer in a list that can be used for data management The Database Storage Windows enable setting the database storage service controlling the storage operation and monitoring operating status 1 1 4 EDMS Specifications Item Description WS02 EDMCT V2 System require Intel Pentium Celeron or compatible processor ments CD ROM drive Required for installation Display Super VGA 800 x 600 or better high resolution video adaptor and monitor Mouse supported b
7. 3 1 Database Storage Settings 4 4 1 EDMS Database Settings The EDMS database is the database to which the EDMS is connected The following databases are supported Microsoft Access Microsoft SQL Server and Oracle The EDMS database settings for each are different and are described below for each type of database 40 Detailed Database Storage Settings Section 4 4 Microsoft Access Select Microsoft Access in the Database type Field in the EDMS Database Settings Dialog Box EDMS Database Settings Set the EDMS database Database type Microsoft Access Name Mew EDMS database Comments Enter the following data to connect to the database Select an mdb file or enter a filename To create a new mdb file click Create Database name Username Password Specify username and password Test Connection The items that can be set are listed below o lem Description O Enter any desired name for the EDMS database settings Comments Enter a description of the EDMS database This field may be left blank Database name Select or enter the file path name of the Microsoft Access database file mdb To specify and existing mdb file click the Select Button and select the file To create a new mdb file click the Create Button and enter the file name User name and To used a password protected Microsoft Access database Password select the Specify user name and password Option and enter the use
8. Always use the power supply voltages specified in the operation manuals e Take appropriate measures to ensure that the specified power with the rated voltage and frequency is supplied Be particularly careful in places where the power supply is unstable e Install external breakers and take other safety measures against short cir cuiting in external wiring e Do not apply voltages to the Input Units in excess of the rated input volt age e Do not apply voltages or connect loads to the Output Units in excess of the maximum switching capacity e Disconnect the functional ground terminal when performing withstand voltage test e Always ground the system to 100 Q or less when installing the product N Caution Do not operate the product in the following locations e Locations subject to direct sunlight e Locations subject to temperature or humidity outside the range specified in the specifications e Locations subject to condensation as the result of severe changes in tem perature e Locations subject to corrosive or flammable gases e Locations subject to dust especially iron dust or salts e Locations subject to water oil or chemicals e Locations subject to shock or vibration N Caution The SYSMAC SPU Unit must be installed referring to the CS Series CPU Unit Operation Manual Cat No W339 or the CU Series CPU Unit Operation Man ual Cat No W393 xvii Precautions for Safe Use xviii N Caution N Caution
9. N Caution N Caution N Caution N Caution N Caution N Caution N Caution N Caution N Caution N Caution N Caution N Caution 4 Take appropriate and sufficient measures when installing systems in the fol lowing locations e Locations subject to static electricity or other forms of noise e Locations subject to strong electromagnetic fields e Locations subject to possible exposure to radioactivity e Locations close to power supplies Always turn OFF the power supply to the PLC before attempting any of the fol lowing Not turning OFF the power may result in malfunction or electric shock e Mounting or dismounting SYSMAC CPU Units or Memory Cassettes e Assembling the Units e Setting DIP switches or rotary switches e Connecting cables or wiring the system e Connecting or disconnecting the connectors Do not disassemble repair or modify the products Make sure that all the mounting screws terminal screws and cable connector screws are tightened to the torque specified in the reference manuals when mounting the SYSMAC SPU Unit and PLC Leave the label attached to the Unit when wiring Remove the label after the completion of wiring to ensure proper heat dissipa tion Use crimp terminals for wiring Do not connect bare stranded wires directly to terminals Double check all wiring before turning ON the power supply Wire all connections correctly Mount the products only after carefully check
10. Personnel in charge of designing FA systems e Personnel in charge of managing FA systems and facilities e Personnel qualified in computer application technology e Personnel qualified in network application technology General Precautions N WARNING The user must operate the product according to the performance specifica tions described in the operation manuals Before using the product under conditions which are not described in the manual or applying the product to nuclear control systems railroad systems aviation systems vehicles combustion systems medical equipment amuse ment machines safety equipment and other systems machines and equip ment that may have a serious influence on lives and property if used improperly consult your OMRON representative Make sure that the ratings and performance characteristics of the product are sufficient for the systems machines and equipment and be sure to provide the systems machines and equipment with double safety mechanisms This manual provides information for programming and operating the Unit Be sure to read this manual before attempting to use the Unit and keep this man ual close at hand for reference during operation It is extremely important that a PLC and all PLC Units be used for the speci fied purpose and under the specified conditions especially in applications that can directly or indirectly affect human life You must consult with your OMRON representative bef
11. SPU Units can be used to automatically design databases You can thus store data in a database with only a few easy set tings even if you have no knowledge of databases Also databases can be linked to EQView WS02 EQMC1 V1 to graphically display the data stored in databases by the EDMS 4 1 2 Procedural Flow for Database Storage Note 1 2 3 The basic procedure for making the settings required to start database stor age and for controlling database storage is given below 1 Refer to the SPU Console Operation Manual Cat No V231 for SPU Console operating methods 2 Refer to SECTION 3 Copy Function for operating methods for the file copying function of the EDMS Console 1 Use the SPU Console to set the data to be collected from SPU Units Be sure to set three or more data collection files Refer to the SPU Console Operation Manual Cat No V231 2 Select File SPU Device from the menu bar to place the EDMS Console online with an SPU Unit Refer to the 3 2 3 Registering SPU Units 3 Enable copying files in the EDMS Console s File Copy Window Refer to the 3 2 5 Setting Files to Copy 4 Setup database storage on the EDMS Console s Database Storage Win dow Refer to the 4 3 7 Database Storage Settings 5 Start database storage on the EDMS Console s Database Storage Win dow Refer to the 4 3 2 Starting Database Storage and 4 5 Data lable Storage Operations 4 1 3 Automatically Creating Databas
12. Tab and select Services 3 Select Copy Task Service 4 Click the Start Button 3 3 2 Stopping the FinsGateway Copy Task Service Select Program FinsGateway FinsGateway Configuration from the Windows Start Menu 1 2 3 1 OMRON FinsGateway Settings File Network EventMemor View Tool Help ToolBar PY E ta Basic DocoMemo Ino Service Settings CPU_UNIT FgwSocke Map gent NameSpa Networks Networks and Unit i r Networks and Units CopyTaskService Startup Auto v FgwSocketProxy a e Path c program filestomron Map gent E NameSpaceServer rice R ee ETN_UNI Status unning Stop E gt CopyTaskService El Memories EventMemories 5 Event Conditions He FINS Data Areas I Start SCM at log in Display and change the status of the services 2 Press the Basic Tab and select Services 3 Select Copy Task Service 4 Click the Stop Button 28 SECTION 4 Database Storage Function This section provides operating procedures for the data storage function of the SPU Data Management Middleware 4 1 Overview of Database Storage Function 0 0 000 cee eens 30 4 1 1 The Database Storage Function oooooooooo 00 eee eee 30 4 1 2 Procedural Flow for Database Storage o oooooooo oo 30 4 1 3 Automatically Creating Database Tables 30 4 2 Database Storage Tap Pace c2 c 5 Ga bones Porn An ey ede nese tee 32 4 2 1 Displaying th
13. The abbreviation PLC means Programmable Controller PC is used however in some Program ming Device displays to mean Programmable Controller Visual Aids The following headings appear in the left column of the manual to help you locate different types of information Note Indicates information of particular interest for efficient and convenient opera tion of the product 12 056 1 Indicates lists of one sort or another such as procedures checklists etc OMRON 2005 All rights reserved No part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means mechanical electronic photocopying recording or otherwise without the prior written permission of OMRON No patent liability is assumed with respect to the use of the information contained herein Moreover because OMRON is con stantly striving to improve its high quality products the information contained in this manual is subject to change without notice Every precaution has been taken in the preparation of this manual Nevertheless OMRON assumes no responsibility for errors or omissions Neither is any liability assumed for damages resulting from the use of the information contained in this publication TABLE OF CONTENTS PRECAUTIONS rain 1 Intended AUdiCnCe seta abi dia 2 General Precattions A a ass 3 Saret PECHOS dire E a aio a EEA 4 Precautions tor Sale OSG niko ne adds E E RR EA 5 Comtormanc t
14. m SPU 01 192 168 39 191 E Jud Enabled copies Lal Realtime Sampling SPUO1 La Sarnplingl SPU 01 Lal Sampling2 SPU 01 Ld Sampling3 SPU 01 G Bookmarks SPUHO 192 168 39 191 Name IP address Sampling 5 19 2006 10 03 03 4M Status SPU unit time Copy List Sampling Idle Sampling2 Collecting Sampling3 Collecting Start Copying Enabled Enabled Enabled Stopped Running Stopped Stop Copying Copy Task Service Section 3 3 SPU Unit Information Window SPU Data Tree O EDMS Console Current status Active co Ld Sampling 1 SPU Unit1 ookmark Realtime Sampling SPU Unit1 Ld Sampling 1 SPU Unit1 gt ltem Description UU Displays the name of the SPU Unit IP address Displays the IP address of the SPU Unit Status Displays the current status of the SPU Unit including idle status sampling status changes to settings active sta tus and initialization SPU Unit time Displays the current time of the SPU Unit clock Load Settings Button Loads SPU Unit settings and reloads settings when a change is made Copy List Lists the copied files for a specified SPU Unit as well as the copy status conditions Start Copying Button Starts copying a file selected from the Copy List Stop Copying Button Stops copying a file selected from the Copy List Enable Button Enables copying for the copy setting file selected in the Copy List Disable Button Disables copy
15. press of a button or start copying and database storage automatically in the background on computer startup SYSMAC SPU Data Management Middleware EDMS Computer SPU Unit CS series CPU Unit CSV files Database Storage Function The collected data can be Ethernet stored in a database either at the press of a button or o in the background after starting the computer Copy Function The collected data can be copied to the computer either at the press of a button or in the background after starting the computer e Save copied files to any folder on the computer see note and automati cally create file names using any combination of objects i e any text string time or consecutive file numbers Note By default a file named SPU_Unit_namelcopy_name will be creat ed and saved in the EDMS Data Copy Files folder in My Docu ments e Display data in a list that shows the file name file size time of start record and time of last record e A log enables easy copy database storage and error status confirmation e Collecting data is continued by the SPU Unit even if network interference or some other problem shuts down the computer Files that have not been copied to that point will start being copied when the system is restored if they are stored on Memory Card e The specified PLC and SPU Unit clocks are periodically synchronized with the computer clock to maintain consistent time throughout the sys
16. s Set the time of PC to that Synchronizes the SPU Unit and CPU Unit clocks to the of the unit computer clock The setting is reflected in all copies from the same SPU Unit This function is only available with SPU Units version 1 2 or later Note When enabling the Set the time of PC to that of the unit setting confirm that the personal computer clock is setting is accurate 3 2 7 Starting Copying Files Either of the following methods can be used to start copying files e Clicking the Start Button e Copying automatically on computer startup Clicking the Start Button Click the Start Button from the Operations Area GG EDMS Console File Help File Copy Database Storage ff SPU units Realtime Sampling Copy SPU 01 192 168 39 191 5 Seen Sampling Name SPURO Start Ld Sampling1 Copy Realtime Sampling Operation Sampling2 Advanced La Sampling3 Cornments th Enabled copies Ld Realtime Sampling SPU 01 ieee Stopped El Samplingl SPUXD1 Enable this copy C Register to Bookmarks Se i Display Log Ll Sampling2 SPU 01 Automatically copy at computer startup Ld Sampling3 SPU 01 Bookmarks File Copy List Display Folder Filename File Size First Record SPUHO1 Realtime Sampling 06051 9 100936 0 5 19 2006 10 18 01 AM Filename SPU 01 Realtime Sampling 06051 9 100936 0 5 19 2006 10 18 02 AM File size SPU 01 Realtime Sampling 06051 9 100936 0 5 19 2006 10 18 04 AM No of records SPU 01 Rea
17. 06 10 18 01 AM Filename SPUHO1 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 02 AM File size SPU 01 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 04 AM No of records SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 05 AM First record SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 07 AM Last record SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 08 AM Copied 5 19 2006 10 0 SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 10 AM Path CADocuments SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 11 AM SPUHO1 Realtime Sampling 060519 100947 0 35KB 5 19 2006 10 18 13 AM SPU 01 Realtime Sampling 060519 100947 0 35KB 5 19 2006 10 18 14 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 16 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 17 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 19 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 20 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 22 AM SPUHO1 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 23 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 25 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 26 AM Refresh No of copies 36 The Status Area displays the following status conditions tem on Stop
18. 60 57107 2005 6 40 54 PM 460 54702005 6 41 04 Pr 459 541042005 7 41 34 Pr 460 571072005 7 41 44 PM 460 594102005 7 41 54 PM 459 941022005 7 42 04 PM 460 547102005 7 42 14 PM 460 541042005 7 42 24 Pr 460 5941022005 7 42 34 PM 460 Time of last record 54102005 6 40 43 PM 460 54102005 6 40 53 PM 460 5 10 2005 6 41 03 PM 460 54102005 6 41 13 PM 460 54102005 7 41 43 PM 460 571072005 7 41 53 PM 460 54102005 7 42 03 PM 460 941022005 7 42 13 PM 459 54702005 7 42 23 PM 460 541042005 7 42 33 PM 460 94102005 7 42 43 Ph 460 The following items are displayed for each file that has been copied Display Tem The name of the copied data file The size of the copied data file Time of start record The time of the start record registered for a copied data file Displayed in milliseconds ms Time of last record The time of the last record registered for a copied data file Displayed in milliseconds ms The Display of Folder Button can be clicked to display the copied folders Details on data files that have been copied to the computer will be displayed when a file name is selected in the File Copy List Pane File name SPl Unitl Sarmoling 1 050510 194916 00065 csy File size 1EB Record count 10 Time of start rec 5 70 2005 6 40 34 PM 460249766 Time of last rec 5 70 2005 6 40 43 PM 460098338 Cooled time 51 O2005 6 49 16 Ph File oath C Documents and SetinaslocsiMy Documents EO MiS The following it
19. BE RESPONSIBLE FOR WARRANTY REPAIR OR OTHER CLAIMS REGARDING THE PRODUCTS UNLESS OMRON S ANALYSIS CONFIRMS THAT THE PRODUCTS WERE PROPERLY HANDLED STORED INSTALLED AND MAINTAINED AND NOT SUBJECT TO CONTAMINATION ABUSE MISUSE OR INAPPROPRIATE MODIFICATION OR REPAIR X Application Considerations SUITABILITY FOR USE OMRON shall not be responsible for conformity with any standards codes or regulations that apply to the combination of products in the customer s application or use of the products At the customer s request OMRON will provide applicable third party certification documents identifying ratings and limitations of use that apply to the products This information by itself is not sufficient for a complete determination of the suitability of the products in combination with the end product machine system or other application or use The following are some examples of applications for which particular attention must be given This is not intended to be an exhaustive list of all possible uses of the products nor is it intended to imply that the uses listed may be suitable for the products e Outdoor use uses involving potential chemical contamination or electrical interference or conditions or uses not described in this manual e Nuclear energy control systems combustion systems railroad systems aviation systems medical equipment amusement machines vehicles safety equipment and installations subject to separate i
20. Data Management Middleware and provides information on the capabilities of the SPU Data Management Middleware dal EroubleshooUs sr ica xh eae nnea aes VERS CSS EA 52 5 1 1 Troubleshooting the File Copy Function 52 5 1 2 Troubleshooting the Database Storage Function 53 dz PDMS Capabilities os acca sete as ees 54 51 Troubleshooting Section 5 1 5 1 Troubleshooting 5 1 1 Troubleshooting the File Copy Function All errors that occur while using the file copying function are logged The cause of the error can sometimes be determined by checking the log Refer to 3 2 9 Checking the Log for details on the checking procedure Display of log SPU Uniti EventiD Description Information Informatior Error Information Informatior Informatior of 102005 541022005 5102005 54102005 9410 2005 541022005 6 04 06 PM 6 00 46 PM 8 00 46 PM 7 59 38 PM 01 30 PM 2 50 55 PM Copy ID 1 12 started Copy ID 1 is stopped Error occured in copy ID 1 during file monit Copy ID 1 13 started Copy ID 1 iz stopped Copy ID 1 is started The following table lists the most common errors probable cause and required corrective action Event ID Probable cause 85 Available hard disk space An insufficient amount of hard Delete unnecessary files and make sure below disk space is available there is sufficient space available for copied files 97 Initialization failed The SPU Unit power
21. MC Electromagnetic Compatibility stan dards are as follows Unit Board CS1W SPU01 EN 61000 6 2 EN 61000 6 4 CS1W SPU02 CJ1W SPU01 The EN 61000 6 4 radiated emission standard is based on 10 m regulations Low Voltage Directive Always ensure that devices operating at voltages of 50 to 1 000 V AC and 75 to 1 500 V DC meet the required safety standards for the PLC EN 61131 2 When switching a load with a high inrush current such as an incandescent lamp suppress the inrush current as shown below SECTION 1 Overview This section provides an overview of the SPU Data Management Middleware and its capabilities and specifications Med Go deste ds te we aoe ace aA RO Z blb SOR Wale OVEl VIEW 44a bn ieee eae Ws Roe leads 2 LSD NO 2 FiIS EDMS SCURE aeae aa Ae lt 5 3 Tele4 EDMS Specifications 3 1 1 5 Software Package Contents 0 0 cece eee 5 Overview Section 1 1 1 1 Overview 1 1 1 Software Overview The SYSMAC SPU Data Management Middleware hereafter the EDMS is software that reads CSV format files from an SPU Unit and copies the files to a specified folder on a computer hard disk over an Ethernet network With version 2 0 or higher the collected data can be stored in a database 1 1 2 Features e Use easy settings to write data automatically from the SPU Unit to a com puter hard disk The collected data can also be stored in a database e Start and stop copying and database storage at the
22. MS database and click Create Table 1 The database storage details will be set and the data table will be created in the EDMS database Select any collection EDMS database pattern setting file Specify the data table name Data table name Database type Access Database C Documents and SettingssocesMy DocumentsSEDMS Data D atabaseSPU HO Comments Sampli00 2 Click Select the variables Task to store in the database Select the variables to store in the data table Select the variables to store in the data table IF the number of fields in the data table iz exceeded reduce the number of variables to store Display the EDMS database list Display the full list of EDMS databases 2 Click Select the variables to store in the database The Select Variables Dialog Box will be displayed Cial Select Variables Select the variables to store to the data table Varable Name Address Comments 0000 Tagoooo BM_ooood 2 0001 Tag0001 Dm 00007 2 0002 Tagoooe BM_oooo2 0003 Tag0D03 De _00003 2 0004 Tag0004 Dm _00004 2 0005 Tag Dos Dm _00005 0006 Tag0006 Dr 4_00006 The number of variables that can z 0007 Tag0007 DM_0000 be stored in a database depends on 2 aE aa a ae the type of database If more than Fomo Taqim FEN the allowable number of variables IS E 0011 Tag 011 DM 00017 registered the number of variables A 0012 T ae 2 must be reduced in this wndow 7 All variables registered
23. PU Unit version 1 2 or later only and CPU Unit clocks are periodically synchronized with the computer clock Overview Section 1 1 1 1 5 Software Package Contents EDMS Installation Program Microsoft NET Framework Version 1 1 Redistributable Package FinsGateway Version 2003 Operation Manual The WS02 EDMC1 V2 software package contains the following items The EDMS installation program is used to install the Copy Task Service and EDMS Console on a computer Microsoft NET Framework Version 1 1 is required to run the SPU Console The Redistributable Package provided in the software package can be used to install NET Framework on the computer The FinsGateway version 2003 communications middleware is required to run the SPU Console This operation manual is included in PDF format in the software package Overview Section 1 1 SECTION 2 Installation and Starting Exiting This section describes how to install and uninstall the software and how to start and exit the EDMS Console 2 1 Installing and Uninstaller 6 ie wee be eek sinless 8 Ziel Prorto Instalacion tas Pita oe aoe eeu 8 L2 Tastalline the EDMS tanda iaa arica 8 2 1 3 Installing Microsoft NET Framework o oooooooooo oo 9 2 1 4 Installing FinsGateWaYrossmicir dara rd das 10 2 1 5 Installing the MDAC ordre ia 10 2 1 6 Uninstalling EDMS 000 ias di 11 2 2 Starting and Exiting the EDMS Console 0 0 0 0 12 2 2 1 Starting the EDMS C
24. SYSMAC CS CJ Series WS02 EDMC1 V2 SYSMAC SPU Data Management Middleware USER S MANUAL SYSMAC CS CJ Series WS02 EDMC1 V2 SYSMAC SPU Data Management Middleware User s Manual Revised June 2006 Notice OMRON products are manufactured for use according to proper procedures by a qualified operator and only for the purposes described in this manual The following conventions are used to indicate and classify precautions in this manual Always heed the information provided with them Failure to heed precautions can result in injury to people or dam age to property DANGER Indicates an imminently hazardous situation which if not avoided will result in death or serious injury Additionally there may be severe property damage N WARNING Indicates a potentially hazardous situation which if not avoided could result in death or serious injury Additionally there may be severe property damage N Caution Indicates a potentially hazardous situation which if not avoided may result in minor or moderate injury or property damage OMRON Product References All OMRON products are capitalized in this manual The word Unit is also capitalized when it refers to an OMRON product regardless of whether or not it appears in the proper name of the product The abbreviation Ch which appears in some displays and on some OMRON products often means word and is abbreviated Wd in documentation in this sense
25. Task Service 28 3 32 Stopping the FinsGateway Copy Task Service 28 15 Window Configuration of Copy Function Section 3 1 3 1 Window Configuration of Copy Function The File Copy Window consists of the following parts Names Description SPU Copy Tree Displays the Copy Tree for all SPU Units Select an SPU Unit to display the SPU Unit Information Pane Select Copy of file to display the Copy Information Window SPU Unit Information Displays SPU Unit information and operations Pane Copy Information Window Displays copy information and operations 3 1 1 SPU Copy Tree The following pane shows the Copy Tree for all SPU Units SFU unit fl SPU Unitl 192 168 39 207 Lal Realtime Sampling e AA Fj Sampling 2 Lal Sampling 3 Gl SPU Unit2 192 168 39 236 TP Active copy Realtime Sampling SPU Unit1 La Sampling 1 SPU Unit1 ookmar La Realtime Sampling SPU Unitl La Sampling 1 SPU Unitt The SPU Copy Tree displays the following information Display SPU Units Displays all registered SPU Units as well as the sampling collec tion pattern file names registered to the SPU Units Active Copy Displays all files for Units with Activate this copy selected on the Copy Information Window Bookmark Displays all files for Units with Register to Bookmark selected on the Copy Information Window Refresh Button Click the Refresh Button to update the list as requir
26. Tel 1 847 843 7900 Fax 1 847 843 8568 OMRON ASIA PACIFIC PTE LTD 83 Clemenceau Avenue 1411 01 UE Square Singapore 239920 Tel 65 6835 3011 Fax 65 6835 271 1 OMRON CHINA CO LTD Room 2211 Bank of China Tower 200 Yin Cheng Zhong Road PuDong New Area Shanghai 200120 China Tel 86 21 5037 2222 Fax 86 21 5037 2200 Authorized Distributor Cat No V232 E1 02 Note Specifications subject to change without notice ls ad This manual is printed on 100 recycled paper
27. a guide for the user in determining suitability and does not constitute a warranty It may represent the result of OMRON s test conditions and the users must correlate it to actual application requirements Actual performance is subject to the OMRON Warranty and Limitations of Liability ERRORS AND OMISSIONS The information in this manual has been carefully checked and is believed to be accurate however no responsibility is assumed for clerical typographical or proofreading errors or omissions xiii XIV PRECAUTIONS This section provides general precautions for using the SYSMAC SPU Data Management Middleware The information contained in this section is important for the safe and reliable application of the SYSMAC SPU Data Management Middleware You must read this section and understand the information contained before attempting to set up or operate the SYSMAC SPU Data Management Middleware 1 Intended Adie acta AAA xvi 2 General Precautions cia da xvi 3 Salely PreCautiOns 24341 alaba ta ia A ENE xvi 4 Precautions for Sate Usabilidad xvii 5 Conformance to EC DirectiveS ooooooooo ooo eee nee XX 5 1 Applicable Directives 1d ds da XX 5 2 EN XX XV Intended Audience 1 2 3 XVI Intended Audience This manual is intended for the following personnel who must also have knowledge of electrical systems an electrical engineer or the equivalent e Personnel in charge of installing FA systems e
28. age Settings Section 4 4 4 4 3 Confirming Connection to the Database Use the following procedure to confirm that connection to the database is pos sible for the registered EDMS database settings 1 2 3 1 Select the name of the database in the EDMS Database List Dialog Box 2 Click the Test Connection Button The following dialog box will be displayed if the database is successfully connected to OMRON EDMS Console ES P y Database connection successful The following dialog box will be displayed if connection was not possible Check the database structural settings OMRON EDMS Console Database connection Failure e DBNETLIB ConnectionOpen Connect SOL Server does nok exist or access denied 45 Detailed Database Storage Settings Section 4 4 4 4 4 Selecting the Variable to Store in the Data Table The variables that are stored in the data table can be specified By default all variables are set for storage in the data table 1 2 3 1 As shown below select any collection pattern setting file and display the Database Storage Setting Pane H EDMS Console Fie Database Storage Help File Copy Database Storage AAA AS SPU units Realtime Sampling A SPUD aaa Realtime Sampling Marne SPUHO1 ah SPUHOT_O0 a Sampling Copy Realtime Sarnpling Comments ra EDMS databases To store this copy to the database set the following data fg SPU O1_ 00 gh Realtime Sampling SPU 01 Select the ED
29. anged e g using the Change sampling settings instruction The 7 segment display will count up consecutively from P1 and to PE while the instruction is being executed Restarting the SYSMAC SPU Unit or turning OFF the power at this during these displays may corrupt the system files that are being changed Do not turn OFF the Unit power supply while setting information is being transferred to the Unit Otherwise invalid information may be transferred and the Unit may malfunction Conformance to EC Directives Applicable Directives Concepts Note e EMC Directives e Low Voltage Directive EMC Directives OMRON devices that comply with EC Directives also conform to the related EMC standards so that they can be more easily built into other devices or the overall machine The actual products have been checked for conformity to EMC standards see the following note Whether the products conform to the standards in the system used by the customer however must be checked by the customer EMC related performance of the OMRON devices that comply with EC Direc tives will vary depending on the configuration wiring and other conditions of the equipment or control panel on which the OMRON devices are installed The customer must therefore perform the final check to confirm that devices and the overall machine conform to EMC standards Applicable EMS Electromagnetic Susceptibility and EMI Electromagnetic Interference Standards in the E
30. ase storage Repeat the above proce dure for each collection pattern setting file for which data is to be stored in a database Note Data tables must be recreated if the number of variables in the SPU Unit is changed f the data tables are not recreated the data types of variables will not match the data types of the fields and it may not be possible to store data correctly in the database To recreate the data tables delete the database storage settings and then make the database storage settings again Basic Database Storage Procedure Section 4 3 4 3 2 Starting Database Storage Use the following procedure to start storing data into a database 1 2 3 1 Click the Database Storage Tab 4 Click the Start Button This button is displayed when the Enable the database storage settings Option is selected Refer to Status and Log Dis plays below for details on the Display Log Button IN Saran O EDMS Console File Database Storage Help File Copy Database Storage YA LA SPU units Realtime Sampling 1 ff sPuso1 Click the Database E pl Name A Operatio Stor age Tab Copy Realtime Sampling Comments Stopped d Sampling3 Status o EJ EDMS databases A 3 SPURO1_00 Select the database gh Realtime Sampling SPU 01 EDMS Database storage setting file Name SPUHO1_00 Comments Sampli00 Database type Access Refer to EDMS Database Inf
31. ator 2 Insert the EDMS installation disk into the CD drive The following installation program will start automatically EDMS Console OMRON EDMS Version 2 0 Install EDMS Please install the following software when itis necessary OMRON Corporation 2005 2006 All Rights Reserved If the installation program does not start automatically execute the follow ing file CD ROM_drive SetupLauncher exe 3 Click Install EDMS The OMRON EDMS Version 2 0 Setup Program will start 4 Follow the instructions provided by the program Installing and Uninstalling Section 2 1 Note 1 If Microsoft NET Framework or other operating requirements for the EDMS are not met a warning message will be displayed and the setup program will end If that happens install the required software and then install the EDMS 2 If EDMS version 2 0 is installed without installing version 1 0 files will not be copied correctly Always uninstall any previous version of EDMS and then install the new version 2 1 3 Installing Microsoft NET Framework Microsoft NET Framework version 1 1 is required to run the EDMS Install it using the following procedure if it is not already installed Microsoft NET Framework version 1 1 is provided on the EDMS installation disk as a Redis tributable Package that can be installed Using the Redistributable Package 1 2 3 1 Start the computer and log on as the administrator 2 Insert the EDMS installat
32. base Storage Procedure Section 4 3 Status and Log Displays The current status of the EDMS is displayed in the Status Area Displays the current status of the EDMS Operation Status The following status is displayed in the Status Area Status O Description oloppeo Storage of data into the database is stopped Data is being stored into the database The database storage settings are not enabled or the DBReg istService is not running Click the Display Log Button to select a log file and display it in a text editor The log is a set of up to 5 text files in ring format that record errors The file names are DBRegist_1 log to DBRegist_5 log Note 1 An error will be recorded in a log file when data cannot be stored in a da tabase for some reason 2 The CSV file for which the error occurred will be saved in a folder called bad which will be automatically created in the copy folder EDMS Database Information The EDMS Database Area displays information on the database for the data bases storage settings that are currently being edited An example is shown below Displays and hides the EDMS Database Area EDMS Database Mame SP0401_00 Comments Sampli 00 Database type Access Database name C Documents and Settingssocs My DocumentsEDMS Data DatabaseSPUHOT_ 00 mdb Data table name EDMSO0000 Clear Data If the Clear Database Button is pressed the data currently in the data table w
33. called SYSMAC SPU Units and copies the files to the hard disk of a network computer for storage into a database You must be thor oughly acquainted with EDMS functions and performance characteristics to ensure proper use of the product and optimize SYSMAC SPU Unit operation Please read this manual and all related manuals listed in the following table and be sure you under stand the information provided before attempting to install or operate the SPU Data Management Mid dleware Be sure to read the precautions provided in the following section WS02 EDMC1 V2 V232 Describes the installation and operation of the SYSMAC SYSMAC SPU Data Management Mid SPU Data Management Middleware dleware User s Manual this manual WS02 SPTC1 V1 V231 Describes the operation of the SYSMAC SPU Console SPU Console Ver 1 2 Operation Manual CS1W SPU01 SPU02 V229 Describes the installation and operation of the SYSMAC CJ1W SPU01 SPU Units SPU Units Operation Manual Precautions provides general precautions for using the SPU Data Management Middleware and related devices Section 1 provides an overview of the SPU Data Management Middleware and its capabilities and specifications Section 2 describes how to install and uninstall the software and how to start and exit the EDMS Con sole Section 3 provides operating procedures for the copy function of the SPU Data Management Middle ware Section 4 provides operating procedures for the data storage functi
34. ced setting Displays a window to enable setting the folder to copy to the format of the file name the copy monitoring cycle and whether or not to synchronize the SPU Unit clock to the computer clock Refer to 3 2 6 Selecting Advanced Set ting as Required ltem OO Description Current copy status Displays starting started copying stopped warnings and errors Button Description Display of log Used to check whether copying has started or stopped as well as the date and time that errors have occurred Window Configuration of Copy Function List of Copied Files File Details Section 3 1 The List of Copied Files Pane displays a list of all data files that have been copied from the SPU Unit to the computer Display of folder List of copied file File name SPU Unit Sampling 1 050570 184916 00065 csv SPU Unitl Sampling 1 050510 184916 00066 csv SPU Unit Sampling 1 050510 184916 00067 cev SPU Unitl Sampling 1 050510 194916 00068 csv SPU Unitl Sampling 1 050570 195054 000635 cev SPU Unit Sampling 1 050510 195054 00070 csv SPU Unitl Sampling 1 050510 195054 000F1 csv SPU Unit Sampling 1 050591 0 195054 0007 2 csv SPU Unitl Sampling 1 050510 195105 00073 csv SPU Unit Sampling 1 050510 195115 00074 csv SPU Unit Sampling 1 050570 195125 00075 csv File size 1KB 1F B 1KB 1 B 1 B 1KB 1F B 1KB 1 B 1KE 1KE Time of start record 57107 2005 6 40 34 PM 460 594102005 6 40 44 Pr 4
35. e Database Storage Tab Page 32 4 2 2 Exiting the EDMS Console 24 co Ada darias 33 4 3 Basic Database Storage Procedure 0 0 cece cece ee eens 33 4 3 1 Database Storage Settings 0 ccc ee ees 33 4 3 2 Starting Database Storage cee ee eee 37 4 4 Detailed Database Storage Settings 20 0 0 0 cece eee es 40 4 4 1 EDMS Database Settings oooooooooorrrrr rra 40 4 4 2 Changing and Deleting EDMS Databases 44 4 4 3 Confirming Connection to the Database 45 4 4 4 Selecting the Variable to Store in the Data Table 46 4 4 5 Database Storage Settings Based on the EDMS Database 47 4 5 Data Table Storage Operations iodine caba diia 49 4 5 1 Controlling Data Storage from aLiSt oo oooooo o 49 29 Overview of Database Storage Function Section 4 1 4 1 4 1 1 Overview of Database Storage Function This section describes the database storage function added for EDMS version 2 0 The Database Storage Function The database storage function takes data collected by SPU Units and auto matically stores it in databases This enables easily creating information sys tems using SPU Units for database management of quality control data or manufacturing results There is no need to write programs to store data in databases so the cost of constructing systems is greatly reduced The setting information in
36. e Tables 30 The database storage function of the EDMS Console can automatically cre ate tables to store data from CSV files into a database based on SPU Unit setting information This greatly reduces the work required to design the data base and lets you build a database system even if you do not have knowledge of databases The following three types of tables are created from the setting information in SPU Units i e from settings for variables and collection patterns e Data tables Overview of Database Storage Function Section 4 1 Data Tables Variable Tables Note e Variable tables e Administrative tables These tables are described in order in the following sections The database storage service stores data from CSV files into data tables An empty data table is made according to the format in the CSV file Tables can be named automatically or manually and each database can contain more than one data table Automatically assigned names are in the form EDMS00007 i e a serial number is added after EDMS The fields in a data table correspond 1 1 to the fields in the CSV file Fields include index fields and other header fields as well as the data fields that are used to store the actual data apes RECORD_INDEX Long integer A header field that stores an index for the record This field corresponds to column 0 in the CSV file TIME_STAMP Time A header field that stores the time year month day of mon
37. e setting the database storage options 1 2 3 1 Click Database storage option settings to set options for database stor age The following dialog box will be displayed Database Storage Options Do not delete the copied file IF this option 12 OFF the copied data file willbe deleted when the data is stored into the database If this option i ON the data file will not be deleted 4 CS folder will be created and the data file will be moved to that folder Folder check interval 1 i 3 Specify the check interval for the copy folder The database storage service will store the data to the database each time it finds a data file in the copy folder e Select the Do not delete the copied file Option if you do not want to de lete the file of data copied from the SPU Unit after the data in the file has been stored in the database If this option is selected the copied files will be moved to a folder called CSV automatically created in the copy folder after database storage has been completed e To change the interval at which the EDMS checks for data files in the copy folder set the desired interval in seconds in the Folder check in terval Field 2 Click the OK Button 39 Detailed Database Storage Settings Section 4 4 Data Table Display This section describes the Data Table Display Area Select the database file Select the data display time range Displays the stored data The to display for Microsoft Data is di
38. ed if SPU Units are regis tered deleted or changed using the procedures in 3 2 3 Registering SPU Units The list of SPU Units and copied files will be updated and displayed in the SPU Copy Tree 16 Window Configuration of Copy Function Section 3 1 3 1 2 SPU Unit Information Pane Select an SPU Unit from the SPU Copy Tree to display the SPU Unit Informa tion Pane SPU Unit Information Pane Ae e a Displays SPU Unit information such ERAS as the Unit name and IP address Loads SPU Unit settings and is used to re load settings i e following a setting change File Help SPU le Hel Copy Tree File Copy Database Storage a ve n SPU units SPU 01 Details SPU 01 192 168 39 191 EP Enabled copies Nae APURO Ld Realtime Sampling SPU 01 IP address 192 168 39 191 La Sampling1 SPUXO1 La Sampling2 SPU 01 Status Sampling Lal Sarmpling3 SPU 01 SPU unit time 5 19 2006 10 03 03 AM Bookmarks Copy List eee Ie UE o aia Eme Start Copyings Realtime Sampling Collecting Enabled Running Sampling Idle Enabled Stopped Stop Copying Sampling2 Collecting Enabled Running e Sampling3 Collecting Enabled Stopped AA Starts or stops copying files from the List of copy Displays a list of copied files and lists the copy status conditions of specified SPU Units l T The SPU Unit Information Pane is described in the following table Name gt Descrip
39. ems are displayed in the Details of File Pane Properly name The name of the copied data file The size of the copied data file The number of records registered to a copied data file Time of start record The time of the start record registered to a copied data file Time of last record The time of the last record registered to a copied data file 19 Operating Procedures Section 3 2 Property name Copied time The date and time that a data file was copied File path The path for saving a copied data file 3 2 Operating Procedures 3 2 1 Procedural Flow 1 2 3 1 10 Connect a computer with the EDMS Console installed to a SYSMAC SPU Unit via a LAN cable The method is the same as that for the SPU Console Select Program OMRON EDMS EDMS Console from the Windows Start Menu to start the EDMS Console Refer to 3 2 2 Starting the EDMS Console Register the SPU Units specify the IP addresses Refer to 3 2 3 Registering SPU Units Click the Refresh Button to update the list if necessary Refer to 3 2 4 Updating the List of SPU Units and Copies as Re quired The List of Copied Files Pane will be updated in the SPU Copy Tree Select the Copy of file and Activate this copy Options Refer to 3 2 5 Setting Files to Copy Click the Advanced Setting Button if necessary to specify the folder to copy to the name of the copied file or the monitoring cycle for determining whether or not copying is poss
40. ents and Settingsocs My Documents EDMS Data Data Select an mdb file or enter a filename To create a new mdb file click Create Database name Username Password Specify username and password Test Connection OK Cancel e Click the Test Connection Button OMRON EDMS Console EJ 1 Database connection successful e Click the OK Button e The EDMS Database Settings Dialog Box will return e Click the OK Button e The Database Storage Tab Page of the EDMS Console will return 35 Basic Database Storage Procedure Section 4 3 36 Th e d atabase sto rag e 7 Specify the data table name Data table name setting file S that are Database type cre ated are di spl ayed q Database C Documents and Settings ocs My Documents EDMS Data Database SPURO The database storage setting files that are created are also displayed i in the EDMS database tree exceeded reduce the number of variables to store The variables that are stored in Database storage operations are also possible from the EDMS database tree A list of the EDMS databases that are regis default Refer to 4 4 4 Selecting e Select the database that was just created as shown below EDMS database bi SPUHOT O0 i peci the daa ra aren EDME daba Ie 5 Click the Create Table Button to create the EDMS database tables e To specify the name of the data table select the Specify the data table name Option before clicking the Create Table Button I
41. f this option is not selected the EDMS Console will automatically name the data ta ble e The following dialog box will be displayed if the tables are created nor mally OMRON EDMS Console X 1 Created table e Click the OK Button e The Database Storage Tab Page will return 3 EDMS Console DER File Copy Database Storage ff SPU units ff SPuHOI 7 Realtime Sampling Name SPUHO Copy Realtime Sampling Comments The name of the data table that is created is displayed 3 EDMS databases J SPU 01_00 ah Realtime Sampling SPUHO1 To store this copy to the database set the following data Select the EDMS database and click Create Table The database storage details will be set and the data table will be created in the EDMS database EDMS database Access Comments Sampli00 Task Select the variables to store in the data table Select the variables to store in the data table If the Tin ecof fields in the data table is Display the EDMS database list Diggtfiy the full list of EDMS databases the data table can be specified All variables are stored by tered can be displayed and the databases the Variable to Store in the Data can be edited Refer to 4 4 2 Changing and Table for details Deleting EDMS Databases for details This completes setting up datab
42. g 06051 9 100957 000 spu 01 realtime sampling 06051 9 100957 000 spu 01 tealtime sampling 06051 9 100957 000 spu 01 tealtime sampling 06051 9 100957 000 spu 01 realtime sampling 06051 9 100958 000 spu 01 tealtime sampling 06051 9 100958 000 spu 01 tealtime sampling 06051 9 100958 000 spu 01 tealtime sampling 06051 9 100958 000 lt C Register to Bookmarks Display Folder First Record 5 19 2006 10 18 01 A 5 19 2006 10 18 02 AM 5 19 2006 10 18 04 AM 5 19 2006 10 18 05 AM 5 19 2006 10 18 07 AM 5 19 2006 10 18 08 4M 5 19 2006 10 18 10 4M 5 19 2006 10 18 11 AM 5 19 2006 10 18 13 AM 5 19 2006 10 18 14 4M 5 19 2006 10 18 16 AM 5 19 2006 10 18 17 AM 5 19 2006 10 18 19 4M 5 19 2006 10 18 20 AM 5 19 2006 10 18 22 AM 5 19 2006 10 18 23 4M 5 19 2006 10 18 25 AM 5 19 2006 10 18 26 AM File Size Operation em Display Log Item Filename File size No of records First record Last record Copied Path CiDocuments No of copies 36 Disabling the Copy Function Stop copying files and then clear the Activate this copy Option from the Copy Information Window to disable the copy function Displaying SPU Unit Information Select an SPU Unit from the SPU Copy Tree to check the Unit s settings i e the IP address or current time to display a list of copies for that Unit or to start and stop copying 3 EDMS Console File Help File Copy Database Storage ff SPU units
43. g data storage An application such as Excel is Close the CSV file Cannot open CSV file using the CSV file preventing it being opened for database stor age Data is stored in the error log as follows Date time error number service name data source name block name error details e The service name data source name and block name will tell you the data storage service in which the error occurred e The error details include the cause of the error what record the error occurred in and other details The error details that are actually re corded depend on the error that occurs 53 EDMS Capabilities Section 5 2 5 2 EDMS Capabilities The copying and database storage capabilities of the EDMS are affected by the following factors e Operating Environment The operating environment includes the capabilities of the computer net work database and other factors e Load on the SPU Unit The load on the SPU Unit includes the SPU Unit cycle time the number of variables being sampled the collection patterns being used etc e Unit Monitoring Cycle and Number of Copies Made The copying and database storage performance of the EDMS is not limited by any specific restrictions for these factors We assume however that you will test the application before actual implementation to confirm that the required capabilities can be provided by the actual system to be used We recommend that you completely test a
44. g from the most recent event The following items will be displayed o ltem Description The type of event such as data or error The date the event occurred The time the event occurred Event ID The event ID unique to the application The event details 2 Press the F5 Key to update the event display Note The log uses the Windows Event Log and can be viewed from the Windows Event Viewer 25 Operating Procedures Section 3 2 3 2 10 3 2 11 3 2 12 26 Stopping Copying Files Click the Stop Button to stop copying files 3 EDMS Console File Help File Copy Database Storage M SPU units fl SPU 01 192 168 39 191 Realtime Sampling La Sampling1 La Sampling2 La Sampling3 i Enabled copies La Realtime Sampling SPU 01 Ld Samplingl SPU 01 La Samplina2 SPUXO1 Ld Sampling3 SPU 01 Bookmarks Name SPU 01 Copy Realtime Sampling Comments Enable this copy C Automatically copy at computer startup Filename SPU 01 Realtime Sampling 060519 100936 0 SPU 01 Realtime Sampling 06051 9 100936 0 SPU 01 Realtime Sampling 06051 9 100936 0 SPU 01 Realtime Sampling 06051 9 100946 0 SPU 01 Realtime Sampling 060519 100946 0 SPU 01 Realtime S ampling 06051 9 100946 0 SPU 01 Realtime Sampling 06051 9 100946 0 SPU 01 Realtime Sampling 060519 100946 0 SPU 01 Realtime S ampling 06051 9 100947 0 SPU 01 Realtime Sampling 06051 9 100947 0 spu 01 realtime samplin
45. he SPU Unit can be checked using the 05 IP Address Display LAN1 command 3 2 4 Updating the List of SPU Units and Copies as Required Click the Refresh Button to update the list whenever SPU Units have been newly registered changed or deleted in the SPU Device Window The list of SPU Units and copied files will be updated and displayed in the SPU Copy Tree 21 Operating Procedures Section 3 2 3 2 5 3 2 6 22 Setting Files to Copy Select the file to copy in the SPU Copy Tree and then select the Activate this copy Option from the Copy Information Window 3 EDMS Console File Copy Database Storage SPU units Realtime Sampling Copy a SPU O01 192 168 39 191 1 ud Realtime Start F Sampling Select this option e Sampling Operation F Sampling Advanced Ly J Sampling3 Comments jab Enabled copies La Realtime Sampling SPUXOD1 El Sampling1 SPU 01 C Register to Bookmarks i Display Log Lal Samp ling2 SPU 01 C Automatically copy at computer startup Lal Sampling3 SPU 01 Bookmarks a t Display Folder Filename File Size First Record Item SPUHO1 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 01 4M Filename SPUHO1 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 024M File size SPUHO1 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 04AM No of records SPUHO1 Realtime Sampling 060519 100946 0 35KB 5 19 200610 18 054M First record SPUHO1 Realtime Samp
46. ible Refer to 3 2 6 Selecting Advanced Setting as Required Click the Start Button to start copying or select the Start copying automat ically on computer startup and restart the computer Refer to 3 2 7 Starting Copying Files Copying will start and the Copy Information Window will be displayed Refer to 3 2 7 Starting Copying Files Check the copy status conditions in the Status Area Refer to 3 2 8 Checking the Copy Status Conditions Click the Display of log Button Refer to 3 2 9 Checking the Log 3 2 2 Starting the EDMS Console Select Program OMRON EDMS EDMS Console from the Windows Start Menu to start the EDMS Console 20 Operating Procedures Section 3 2 3 2 3 Registering SPU Units Register the SPU Units with the files that will be copied 1 2 3 1 Select SPU Device from the File Menu SPU Device ES SPU unit list SPU Unitl 192 169 39 207 2 SPU Unit2 192 169 395 236 Confirmation 2 Click the New Button to register the SPU Unit Destination Setting Specify either the IP address for the SPU unit and the name IP address 192 168 399 237 ex 192 168 0 1 or SPU Detault SPU Urits e Specify the IP address of the SPU Unit in the P Address Field e Specify any text string in the Name Field to identify the SPU Unit that will be registered If nothing is entered in the field then the IP address will be entered in the Name Field automatically Note The FINS address of t
47. ill be cleared leaving an empty data table The data table will not be deleted Tasks This section describes operating methods for the Task Area Enables the database Automatically stores data in the storage setting file that is database for the database storage currently selected setting file that is currently selected W Enable the database storage settings Automatically store to this database at computer startup Delete database storage settings Database storage option settings Delete these database storage settings Perform advanced storage settings for thie database 38 Basic Database Storage Procedure Section 4 3 Deleting Database Stop database storage before deleting the database storage settings Storage Settings q Pis de 1 Click Delete database storage settings to delete the database storage settings The following window will be displayed OMRON EDMS Console r Delete the databaze storage settings Check the bos below to delete the data table at the same time Delete the data table E e Select the Delete the data table Option to delete the data table at the same time 2 Click the OK Button Note If the Delete the data table Option is selected the data table and variable tables will be deleted at the same time along with all data that has been stored Do not select the Delete the data table Option unless you want to delete the data as well Database Storage Options Stop database storage befor
48. in the Database type Field in the EDMS Database Settings Dialog Box EDMS Database Settings Set the EOMS database Database type Oracle Database Mame Nem EDMS database Comments Enter the following data to connect to the database Database name Enter the Oracle service name or the net service name as the database name Username Password Test Connection Cancel The items that can be set are listed below lem Description Enter any desired name for the EDMS database settings Comments Enter a description of the EDMS database This field may be left blank Database name Specify the Oracle database service name or the network ser vice name User name and Enter the user name and password Password When connecting to an Oracle database on a remote machine install the Ora cle client first and then set the network service 43 Detailed Database Storage Settings 4 4 2 Changing and Deleting EDMS Databases Use the following procedure to change or delete EDMS database settings 1 2 3 1 Select a collection pattern setting file and display the Database Storage Setting Pane ENS File Database Storage Help File Copy Database Storage R ff SPU units Realtime Sampling fal sPuao Se Realtime Sampling al EDMS databases J SPUHOI_OO Pa l gh Realtime Samplina s PUH 01 1 Select any collection pattern setting file 2 Click Display the EDMS database list 2 Clic
49. in the SPU Unit 5 are selected by default d variables Varables selected 100 Total variables 100 Maximum variables storable to the data table 251 Cancel 46 Detailed Database Storage Settings Section 4 4 3 Select the variables to store in the database using the check boxes and then click the OK Button Note 1 There are limits to the number of variables that can be stored in a data table The limit depends on the type of database being used Microsoft Access 251 Microsoft SQL Server 1 020 Oracle Database 996 2 If the limit to the number of variable is exceeded reduce the number us ing step 3 above 3 Even if the data table is deleted when deleting the database storage set tings the settings for the variables selected for storage in the database will not be deleted Thus if the data table is recreated a data table with the same variables will be created 4 4 5 Database Storage Settings Based on the EDMS Database In the basic setting procedures in 4 3 1 Database Storage Settings setting methods were described so that the collection pattern setting file was selected and then the EDMS database into which the data was to be stored was set In the following procedure the EDMS database is selected first and then the data to be copied into it is specified l2 3i 1 Select the EDMS database on the Database Storage Tab Page The fol lowing window will be displayed El EDMS Console AE Fi
50. ing 060519 100946 0 35KB 5 19 2006 10 18 08 AM Copied SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 10 AM Path CADocuments SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 11 AM SPU 01 Realtime Sampling 060519 100947 0 35KB 5 19 2006 10 18 13 AM SPUHO1 Realtime Sampling 060519 100947 0 35KB 5 19 2006 10 18 14 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 16 AM SPUHO1 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 17 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 19 AM SPU 01 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 20 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 22 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 23 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 25 AM SPU 01 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 26 AM lt C Automatically copy at computer startup EventlD Description Information 5 10 2005 8 04 06 PM Copy ID 1 is started Information 5 10 2005 8 00 46 PM Copy ID 1 is stopped Error 5 10 2005 8 00 46 PM Error occurred in copy ID 1 during file monit Information 5 10 2005 7 59 38 PM Copy ID 1 is started Information 5 10 2005 7 51 35 PM Copy ID 1 is stopped Information 5 10 2005 7 50 53 PM Copy ID 1 is started Only events for the selected copy will be displayed They are displayed in order of occurrence startin
51. ing for the copy setting file selected in the Copy List Note When an SPU Unit setting has been changed click the Load Setting Button to reflect the change in the EDMS Console Otherwise copying will be exe cuted using the previous settings and may not execute properly 3 3 Copy Task Service The FinsGateway Copy Task Service is a Windows service that is used by the EDMS Normally the service starts automatically without any action on the part of the user If it does not start automatically however start it manually as described in the start stop procedures below 27 Copy Task Service Section 3 3 Starting the FinsGateway Copy Task Service Select Program FinsGateway FinsGateway Configuration from the Windows Start Menu 3 3 1 1 23 i m OMRON FinsGateway Settings File Network EventMemory View Tool Help Tool Bar pz E ta Basic DacoMemo Info Service Settings Network 3 BIWOIKS EN 6 5 EN Networks and Unit i ir Networks and Units CopyTaskService 38 Drivers 1 Services 463 CPU_UNIT FgwSocketProxy Map gent E gt NameSpaceServer 363 ETN_UNIT CPU_UNIT FgwSocke Map gent NameSpa ETN_UNIT MAME ES rice lt lt E Path c program filesomron Status Stopped 83 CopyTaskService Bl Memories EventMemories 5 Event Conditions Fh FINS Data Areas Start I Start SCM at log in Display and change the status of the services 2 Click the Basic
52. ing the terminal blocks Be sure that the terminal blocks Memory Units expansion cables and other items with locking devices are properly locked into place Check the user program for proper execution before actually running it on the Unit Resume operation only after transferring to the new SYSMAC SPU Unit and PLC the contents of the DM Area HR Area and all other data required for resuming operation Do not place objects on the cable or other wiring lines Precautions for Safe Use N Caution N Caution N Caution N Caution N Caution N Caution N Caution N Caution Caution N Caution N Caution N Caution N Caution N Caution Always use the power supply voltages specified in this manual Do not pull on the cables or bend the cables beyond their natural limit Confirm that no adverse effect will occur in the system before attempting any of the following e Changing the operation mode of the PLC e Force setting force resetting any bit in memory e Changing the present value of any word or any set value in memory Before touching a Unit be sure to first touch a grounded metallic object to dis charge any built up static electricity Do not remove the Memory Card when the CARD indicator is lit Otherwise the files on the Memory Card may be corrupted Do not turn OFF the power supply while the Memory Card is being accessed Otherwise the files on the Memory Card may be corrupted Obse
53. ion disk into the CD drive The following installation program will start automatically 5 EDMS Console OMRON EDMS Version 2 0 Please install the following software when itis necessary Microsoft NET Framework 1 1 OMRON Corporation 2005 2006 All Rights Reserved If the installation program does not start automatically execute the follow ing file CD ROM_drive SetupLauncher exe 3 Click Microsoft NET Framework 1 1 The Microsoft NET Framework 1 1 Setup Program will start 4 Follow the instructions provided by the program Using a Windows Update Microsoft NET Framework version 1 1 can also be installed using a Microsoft Windows Update An Internet connection is required to use Windows Update Note 1 Windows Update is a utility that comes with Microsoft Windows e With Windows 2000 select Windows Update from the Windows Start Menu e With Windows XP select Windows Update from All Programs on the Windows Start Menu 2 Microsoft NET Framework must be version 1 1 to use the EDMS Version 1 0 version 2 0 or any other version will not work Always install Mi Installing and Uninstalling Section 2 1 crosoft NET Framework version 1 1 Only one version of Microsoft NET Framework can be installed on any one computer 2 1 4 Installing FinsGateway FinsGateway version 2003 ENT UNIT must be installed to run the EDMS If an earlier version of the program is installed be sure to uninstall the earlier version pr
54. ior to installing version 2003 The computer must be restarted to complete the installation 123 1 Start the computer and log on as the administrator 2 Insert the EDMS installation disk into the CD drive The following installation program will start automatically EDMS Console OMRON EDMS Version 2 0 Please install the following software when itis necessary FinsGateway 2003 OMRON Corporation 2005 2006 All Rights Reserved If the installation program does not start automatically execute the follow ing file CD ROM_drive SetupLauncher exe 3 Click FinsGateway 2003 The OMRON FinsGateway Version 2003 Embedded Edition ETN_UNIT Setup Program will start 4 Follow the instructions provided by the program 5 Restart the computer to complete the installation 2 1 5 Installing the MDAC MDAC Microsoft Data Access Components 2 6 or higher is required to run the EDMS Install it using the following procedure if it is not already installed 1 2 3 1 Start the computer and log on as the administrator 10 Installing and Uninstalling Section 2 1 2 Insert the EDMS installation disk into the CD drive The following installation program will start automatically 5 EDMS Console OMRON EDMS Version 2 0 Please install the following software when itis necessary MDAC 2 8 SP1 OMRON Corporation 2005 2006 All Rights Reserved If the installation program does not start automatically execute the f
55. k Display the EDMS database list or select EDMS Database List SPU 01 Realtime Sampling Comments Specify the data table name Database type Database Comments Task To store this copy to the database set the following data Select the EDMS database and click Create Table The database storage details will be set and the data table will be created in the EDMS database EDMS database Access CA Documents and Settings oce4My Documents EDMS Data atab S ampli0o Select the variables to store in the data table Select the variables ta store in the data table If the number of fields in the data table ig exceeded reduce the number of variables to store Display the EDMS database list Display the full list of EDMS databases from the Database Storage Menu The EDMS Database List Dialog Box will be displayed Hill EDMS Database List Name SP0801_00 SPU O1_01 5P0801_02 SP0801_03 3 Select the EDMS database and click the Properties or Delete Button Note To delete or change the setting for an EDMS database the data base storage settings for the corresponding EDMS database must first be deleted Refer to Tasks under 4 3 2 Starting Database Database Type Access Access Access Access Storage 44 Database Mame C Documents and Setting C Documents and Setting C Documents and Setting C Documents and Setting Section 4 4 Data table name Detailed Database Stor
56. le Copy Database Storage ff SPU units SPU O1 00 fil sPuao Realtime Sampling Database type Access SPU 01_00 J I 5 Database C Documents and Settingssoce My Documentss EOMS Datat Databases SPU La Sampling Comments SampliiO a Sampling E EDMS databases Store the copy to this EDMS database ae PLIRO 00 ES Realtime Sampling SPURO Select the copy to store and click Create Table Perform the database storage settings and la SPU O1_O1 create the data table in the EDMS database 3 SPUROI_02 J SPUHOI_O8 Cony hs Specify the data table name Data table name Marne Copy Comments Task Select the vanables to store in the data table Select the variables to store in the data table If the number of fields in the data table is exceeded reduce the number of variables to store Display the EDMS database list Display the full list of EDMS databases 47 Detailed Database Storage Settings Section 4 4 2 Specify the collection pattern setting file in the Copy Field and then click the Create Table Button The EDMS database tables will be created El EDMS Console Fie Database Storage Help File Copy Database Storage ffl SPU units SPU O1_ 00 fal SPuao Realtime Sampling Database type Access ah SPU 01_00 El arctic Database CADocuments and SethngssocssMy DocumentsSEDMS Data Database PL La Sampling Comments SampliOO La Sampling EL EDMS databases Store the copy to this EDMS database
57. ling 060519 100946 0 35KB 5 19 2006 10 18 07AM Last record SPUHO1 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 084M Copied SPUHO1 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 10AM_ Path SPUHO1 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 11 AM SPUHO1 Realtime Sampling 060519 100947 0 35KB 5 19 2006 10 18 13 AM SPUHO1 Realtime Sampling 060519 100947 0 35KB 5 19 2006 10 18 14 AM SPUHO1 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 15 AM SPUHO1 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 17 AM SPUHO1 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 19 AM SPUHO1 Realtime Sampling 060519 100957 0 35KB 5 19 2006 10 18 20 AM SPUHO1 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 22 AM SPUHO1 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 23 AM SPUHO1 Realtime Sampling 060519 100958 0 35KB 5 19 2006 10 18 25 AM SPUHO1 Realtime Sampling 050519 100958 0 35KB 5 19 2006 10 18 26 AM Y s Stopped Status No of copies 36 Other options operations and status conditions are enabled when the Acti vate this copy Option is selected Selecting Advanced Setting as Required Click the Advanced Setting Button to display the following window Restore Defaults New Filename Format AERA AIDA DABE Sample SPUH01 Realtime S ampling 041130 103000 00001 csv Template Format Standard Unit name we N Z 0
58. ll of the above factors and suitably set up the system to achieve the required performance some examples of actual trials that can be performed are given below Copying and Database Storage with a Short Cycle without Losing Data Set the SPU Unit as follows e Increase the number of files e Decrease the number of collection patterns e Decrease the number of variables stored as data Decrease the number of copies Copying Large Quantities of Data Set the SPU Unit as follows e Increase the number of files e Increase the cycle times for collection patterns e Decrease the number of variables stored as data Increase the Unit monitoring time 54 Revision History A manual revision code appears as a suffix to the catalog number on the front cover of the manual Cat No V232 E1 02 Revision code The following table outlines the changes made to the manual during each revision Page numbers refer to the previous version Revision code Date Revised content June 2005 Original production 02 June 2006 Changes and additions for version 2 0 55 OMRON Corporation Technology Development Center H Q Shiokoji Horikawa Shimogyo ku Kyoto 600 8530 Japan Tel 81 75 344 7123 Fax 81 75 344 7172 Regional Headquarters OMRON EUROPE B V Wegalaan 67 69 NL 2132 JD Hoofddorp The Netherlands Tel 31 2356 81 300 Fax 31 2356 81 388 OMRON ELECTRONICS LLC 1 East Commerce Drive Schaumburg IL 60173 U S A
59. ltime Sampling 06051 9 100946 0 5 19 2006 10 18 05 AM First record SPU 01 Realtime Sampling 06051 9 100946 0 5 19 2006 10 18 07 AM Last record SPU 01 Realtime Sampling 06051 9 100946 0 5 19 2006 10 18 08 AM Copied SPU 01 Realtime Sampling 06051 9 100946 0 5 19 2006 10 18 10 AM Path SPU 01 Realtime Sampling 06051 9 100946 0 5 19 2006 10 18 11 AM SPUHO1 Realtime Sampling 06051 9 100947 0 5 19 2006 10 18 13 AM SPU 01 Realtime Sampling 06051 9 100947 0 5 19 2006 10 18 14 AM SPU 01 Realtime Sampling 06051 9 100957 0 5 19 2006 10 18 16 AM SPU 01 Realtime Sampling 06051 9 100957 0 5 19 2006 10 18 17 AM SPUHO1 Realtime Sampling 06051 9 100957 0 5 19 2006 10 18 19 AM SPU 01 Realtime Sampling 06051 9 100957 0 5 19 2006 10 18 20 AM SPUHO1 Realtime Sampling 06051 9 100958 0 5 19 2006 10 18 22 AM SPU 01 Realtime Sampling 06051 9 100958 0 5 19 2006 10 18 23 AM SPU 01 Realtime Sampling 06051 9 100958 0 5 19 2006 10 18 25 AM SPU 01 Realtime Sampling 06051 9 100958 0 5 19 2006 10 18 26 AM Refresh lt No of copies 36 23 Operating Procedures Section 3 2 Copying will begin and the files that have been copied will be displayed in the List of Copied File Pane in the order they were copied Automatically Starting Copying at Computer Startup 1 2 3 1 Select the Start copying automatically on computer startup Option from the Operations Area Note Files can be copied automa
60. nditions Copy of Sampling 1 Name gt SPU Unitl Copy Sampling 1 Dperation Activate this copy Register to Bookmark Start copying automatically on computer startup Copy settings are selected using the following options Option Description Activate this When this option is selected files are copied to a computer hard copy disk Copying files will start when the Start Button is clicked in the Operation Area If the Start copying automatically on computer startup Option is selected a maximum of 256 files can be copied automatically when the computer starts Files that have this option selected are displayed under Active cop les in the SPU Unit Copy Tree This option is available only when two or more is set in the Number of files Field from the SPU Console Register to These options will be Files that have this option selected are Bookmark available if a file has the registered under Bookmark in the SPU Activate this copy Option Copy Tree Start copying selected Otherwise they Files that have this option selected are automatically on Wl be grayed out copied automatically on computer star computer star tup without having to click the Start tup Button from the Operation Area Button Description Start Starts copying files to the computer automatically if the files have the Activate this copy Option selected Stops copying files to the computer Advan
61. ndustry or government regulations e Systems machines and equipment that could present a risk to life or property Please know and observe all prohibitions of use applicable to the products NEVER USE THE PRODUCTS FOR AN APPLICATION INVOLVING SERIOUS RISK TO LIFE OR PROPERTY WITHOUT ENSURING THAT THE SYSTEM AS A WHOLE HAS BEEN DESIGNED TO ADDRESS THE RISKS AND THAT THE OMRON PRODUCTS ARE PROPERLY RATED AND INSTALLED FOR THE INTENDED USE WITHIN THE OVERALL EQUIPMENT OR SYSTEM PROGRAMMABLE PRODUCTS OMRON shall not be responsible for the user s programming of a programmable product or any consequence thereof xii Disclaimers CHANGE IN SPECIFICA TIONS Product specifications and accessories may be changed at any time based on improvements and other reasons It is our practice to change model numbers when published ratings or features are changed or when significant construction changes are made However some specifications of the products may be changed without any notice When in doubt special model numbers may be assigned to fix or establish key specifications for your application on your request Please consult with your OMRON representative at any time to confirm actual specifications of purchased products DIMENSIONS AND WEIGHTS Dimensions and weights are nominal and are not to be used for manufacturing purposes even when tolerances are shown PERFORMANCE DATA Performance data given in this manual is provided as
62. o EC DIE CAES aria tr ede A A SECTION 1 CIVEEVIEW asi ai ES E a AAA A aar E a RN SECTION 2 Installation and Starting ExitIND8 oo o o o o o 22 Installing and Uninstalling aria oa ead ee ee 2 2 Starting and Exiting the EDMS Console 0 0 ccc ee eens 2 3 Basic Operating Procedutess ada eee A Dad SECTION 3 Copy FUNCUON is andas 3 1 Window Configuration of Copy Function esaesa asasena sanaaa eee 322 Operans Procedu Seenen a a eb eh ea soda eee eee Der CODY Mask Sele cee akin usc Men O eek eet SECTION 4 Database Storage Function ccceccccccsccens 4 1 Overview of Database Storage Function 1 0 0 0 0 eee eee ees 4 2 Database Storage Tab Pace casi subi rindan dhe dh ea iene backs 4 3 Basic Database Storage Procedure cesiocia sarita iia 4 4 Detailed Database Storage Settings n n nunnana nannan 45 Data Table Storage Operations cis we ee E dened wee SECTION 5 Troubleshooting and EDMS Capabilities SE roubleshOoune 4 2 4 iraa eee Suds DAD AN OALA 32 EDMS Capabilities lia A A A eee he R yvision HIStory issues xvii XX 12 12 15 16 20 27 29 30 32 33 40 49 51 52 54 55 vii About this Manual This manual describes the installation and operation of the WS02 EDMC1 V2 SYSMAC SPU Data Management Middleware EDMS and includes the sections described below The EDMS reads files from SYSMAC Storage and Processing Units
63. ollow ing file CD ROM_drive SetupLauncher exe 3 Click MDAC 2 8 SP1 The Microsoft Data Access Components 2 8 SP1 Setup Program will start 4 Follow the instructions provided by the program 2 1 6 Uninstalling EDMS Follow the procedure below to uninstall the EDMS 1 2 3 1 Start the computer and log on as the administrator 2 Select Control Panel from the Windows Start Menu 3 Execute Add or Remove Programs Add or Remove Applications in Windows 2000 4 Select OMRON EDMS Version 2 0 from Currently installed programs and click the Add or Remove Button The setup maintenance program will start 5 Select the Remove option from the setup maintenance program and click the Next Button Follow the instructions provided by the program 11 Starting and Exiting the EDMS Console Section 2 2 2 2 Starting and Exiting the EDMS Console 2 2 1 Starting the EDMS Console Select Program OMRON EDMS EDMS Console from the Windows Start Menu to start the EDMS Console The following window will be displayed when the EDMS Console starts EDMS Console File Help File Copy Database Storage SPU O1 192 168 39 191 DP Enabled copies Name La Realtime Sampling SPUXOD1 Copy Lal Sampling1 SPU 01 al Sampling2 SPU 01 Comments Ld Sampling3 SPU 01 Bookmarks File Copy List Hile Details Filename File Size i d Item Filename File size No of records First record Last record Copied Path Refresh Note
64. on of the SPU Data Management Middleware Section 5 provides information on troubleshooting errors that can occur with the SPU Data Manage ment Middleware and provides information on the capabilities of the SPU Data Management Middle ware 1X Read and Understand this Manual Please read and understand this manual before using the product Please consult your OMRON representative if you have any questions or comments Warranty and Limitations of Liability WARRANTY OMRON s exclusive warranty is that the products are free from defects in materials and workmanship for a period of one year or other period if specified from date of sale by OMRON OMRON MAKES NO WARRANTY OR REPRESENTATION EXPRESS OR IMPLIED REGARDING NON INFRINGEMENT MERCHANTABILITY OR FITNESS FOR PARTICULAR PURPOSE OF THE PRODUCTS ANY BUYER OR USER ACKNOWLEDGES THAT THE BUYER OR USER ALONE HAS DETERMINED THAT THE PRODUCTS WILL SUITABLY MEET THE REQUIREMENTS OF THEIR INTENDED USE OMRON DISCLAIMS ALL OTHER WARRANTIES EXPRESS OR IMPLIED LIMITATIONS OF LIABILITY OMRON SHALL NOT BE RESPONSIBLE FOR SPECIAL INDIRECT OR CONSEQUENTIAL DAMAGES LOSS OF PROFITS OR COMMERCIAL LOSS IN ANY WAY CONNECTED WITH THE PRODUCTS WHETHER SUCH CLAIM IS BASED ON CONTRACT WARRANTY NEGLIGENCE OR STRICT LIABILITY In no event shall the responsibility of OMRON for any act exceed the individual price of the product on which liability is asserted INNO EVENT SHALL OMRON
65. onsol s ious ace sacetiew eda asadsaaads 12 22 2 Exiting the BDMS Console omar ria arta 12 2 3 Basic Operating Procedures ssl da We eden dead Sales 12 2 3 1 Procedural Flow for Copying Data o ooooooooooo 12 2 3 2 Procedural Flow for Database Storag8 o ooooooooo 13 Installing and Uninstalling Section 2 1 2 1 Installing and Uninstalling 2 1 1 Prior to Installation e Make sure that the computer on which EDMS will be installed conforms to the conditions specified in 1 1 4 EDMS Specifications before attempting to install the software e The following software must be installed on the computer before EDMS is installed 1 2 3 Microsoft NET Framework version 1 1 FinsGateway Version 2003 ETN_UNIT Microsoft Data Access Components MDAC 2 6 or higher 4 SPU Console Only if the SPU Console is to be used All of the above software except for SPU Console can all be installed from the EDMS installation disk The installation and uninstallation procedures for the EDMS are provided below along with the installation procedures for the Microsoft NET Frame work first FinsGateway and the MDAC ed a Note Administrator privileges are required to install and operate the EDMS 2 1 2 Installing the EDMS Use the following procedure to install the EDMS If EDMS version 1 0 is already installed uninstall version 1 0 before installing version 2 0 1 2 3 1 Start the computer and log on as the administr
66. or mation Database name C Documents and Settingssocs My Documents EDMS Data D atabase SPU 01_00 mdb below for details on the information dis Data table name EDMS00111 played in the EDMS Database Area Task V Enable the database storage settings F Automatically store to this database at computer startup 3 a Delete database storage settings Database storage option settings Delete these database storage settings Perform advanced storage settings for this database Select the Enable the database storage settings Option Data Table Display Select mdb file C Documents and Settings ocs My Docu m Display time 1s v Refer to Tasks below for detail on the Task Area Refer to Data Table Display below for details on the Data Table Display Area Total records 0 Records displayed 0 2 Select the database storage settings 3 Select the Enable the database storage settings Option in the Task Area e To set database options refer to Database Storage Options on page 39 4 Click the Start Button The EDMS will start storing data into the database e For the default setting copying data will be started automatically if data is not already being copied Refer to 4 5 1 Controlling Data Storage from a List for details e Click the Update Button to display the contents of the data table Refer to Data Table Display below for details on data tables e To stop data storage click the Stop Button 37 Basic Data
67. ore applying a PLC System to the above mentioned appli cations Safety Precautions N WARNING N WARNING N WARNING N WARNING Do not attempt to take any Unit apart while the power is being supplied Doing so may result in electric shock Do not touch any of the terminals or terminal blocks while the power is being supplied Doing so may result in electric shock Fail safe measures must be taken by the customer to ensure safety in the event of incorrect missing or abnormal signals caused by broken signal lines momentary interruptions or other causes Emergency stop circuits interlock circuits limit circuits and similar safety measures must be provided in external control circuits Not doing so may result in serious accidents Precautions for Safe Use 4 N Caution Execute online editing only after confirming that no adverse effects will be caused by extending the cycle time Otherwise the input signals may not be readable N Caution Confirm safety at the destination node before transferring a program to another node or changing contents of the I O memory area Doing either of these without confirming safety may result in injury N Caution Tighten the screws on the power supply terminals to the torque specified in the operation manual The loose screws may result in burning or malfunction 4 Precautions for Safe Use N Caution Observe the following precautions for safe use of the SYSMAC SPU Unit and PLC e
68. ped Copying has stopped Copying cannot be executed but monitoring continues Copying cannot be executed and monitoring stops 24 Operating Procedures Section 3 2 3 2 9 Checking the Log EDMS provides a log that allows the copy start and stop status conditions as well as the date and time that errors have occurred to be checked If an error or some other problem prevents files from being copied the cause can some times be determined by checking the log 1 2 die 1 Click the Display of log Button to check the log KB EDMS Console File Copy Database Storage LLL Sea M SPU units Realtime Sampling Copy a SPU O1 192 168 39 191 Realtime Sampling Name SPU 01 Ld Sampling Copy Realtime Sampling Fj Sampling2 Fj Sampling3 Comments iat Enabled copies La Realtime Sampling SPU 01 F Samplingl SPUXD1 7 Enable this copy C Register to Bookmarks d Sampling2 SPU 01 Lal Sampling3 SPU 01 Bookmarks File Copy List Display Folder Filename File Size First Record SPU 01 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 01 AM Filename SPU 01 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 02 AM File size SPUHO1 Realtime Sampling 060519 100936 0 35KB 5 19 2006 10 18 04 AM No of records SPU 01 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 05 AM First record SPUHO1 Realtime Sampling 060519 100946 0 35KB 5 19 2006 10 18 07 AM Last record SPU 01 Realtime Sampl
69. r name and password Options Microsoft Access databases are restricted to a file size of 2 GB There is an option to change files to store data when this limit is exceeded Click the Options Button to set this option Access Options File change Change at file size IF the file is set to be changed at a specific size a new file will be created when the mdb file reaches the specitied size The date Will be automatically added to the filename Example filename Access0_20060519121722_1 Date time format yyh biddHH mms File size 1000 MB 41 Detailed Database Storage Settings Section 4 4 Note Microsoft SQL Server 42 The items that can be set are listed below ltem O Description O File change Specify the method for changing files The following settings are possible e File size default e Number of records e Do not change Date time format Specify the format for the file name after changing files A time stamp will be automatically added to the file name according to the format set here File size If the file size is used to trigger changing files specify the file size in megabytes Number of records Ifthe number of records is used to trigger changing files spec ify the number of records 1 If changing files is not specified the mdb file may reach 2 GB If that hap pens only the first 2 GB of data will be stored Be sure to maintain the database so that a file size of 2 GB is not e
70. rve the operating conditions e g operating temperature specified for the Memory Card that is used For operating details consult the manufacturer of the Memory Card OMRON has verified the operation only for the Memory Cards sold by OMRON The operation or write performance of any other Memory Cards may not be according to specifications We recommend backing up all PC Cards and Memory Cards in case data is accidentally deleted or files are corrupted The PC card slot is strictly for Memory Cards and cannot be used for Modem Ethernet or other Cards Only insert Memory Cards into the PC card slot Be sure the Memory Card is properly seated in the guide when it is inserted Otherwise it may cause the Unit to malfunction Be sure to lock the Memory Card in place after it is inserted into the PC card slot Otherwise the Card may come out and cause the Unit to malfunction Check to see which way the Memory Card is facing before inserting it into the PC card slot The Memory Card or the guide may be damaged if the Memory Card is forced into the slot the wrong way Check the 7 segment display to see which instruction is being executed before pressing the Enter Key The Unit may malfunction if the wrong instruc tion is executing when the Enter Key is pressed X X Conformance to EC Directives 5 9 5 5 XX 1 2 N Caution N Caution Never restart the SYSMAC SPU Unit or turn OFF the power while settings are being ch
71. splayed backward in time display is refreshed when this Access only from the currently stored data button is clicked again Data Table Display Select mdb file C Documents and Settingssoces My Docu Display time 1s RECORD_IN TIME_STAM TIME_STAM SAMPLING DATA_O DATA_1 DATA_2 DATA 3 A 1745 200605191 11232036 1746 1351 1641 21845 18248 1746 2006705 191 41838801 1747 1351 1641 21845 18248 1747 200605191 72445566 1748 1351 1641 21845 18248 P 1748 PONRANAATS 1 10305331 1743 1351 1 41 21R4A 18248 5 has Total records 1767 Records displayed 22 The total number of records is displayed along with the number of records for the time range specified for the Display time In this example there are a total of 50 442 records and 9 records displayed over the last second Note Ifthe Display time Field is set to 1 second data that is stored at the same time and second as the last data that was stored will be displayed In the following example the records with record indices of 1 and 2 will be displayed but the record with a record index of 0 will not be displayed RECORD _ TIME STAMP TIME STANP_ SAMPLING_ DATA_0 DATA_1 INDEX NANO INDEX 2006 04 11 978897702 1 62241 18006 16 28 47 978 1 2006 04 11 80890182 2 62241 18006 16 28 48 080 2 2006 04 11 182882662 3 62241 18006 16 28 48 182 4 4 Detailed Database Storage Settings This section described the detailed database storage settings that are not described in 4
72. splaying the Database Storage Tab Page PEE fee 1 Select Program OMRON EDMS EDMS Console from the Windows Start Menu The EDMS Console will start 32 Basic Database Storage Procedure Section 4 3 2 Click the Database Storage Tab in the EDMS Console The following window will be displayed Teessvccecesccecesuccecteeeaseceseccceeeeceeee ry File Copy Database Storage SPU units ff sru J EDMS databases 4 2 2 Exiting the EDMS Console Select Exit from the File Menu of the EDMS Console The EDMS Console will close 4 3 Basic Database Storage Procedure This section provides the basic procedures for setting up database storage Here the basic setting procedure when setting up database storage for the first time and the data storage procedure are described 4 3 1 Database Storage Settings The settings required for database storage are described in this section Here we assume that the SPU Units have already been set Refer to the SPU Con sole Ver 1 3 Operation Manual Cat No V231 and the SPU Units Operation Manual Cat No V229 for information on setting SPU Units We also assume that the EDMS Console has been connected online with SPU Units and copying data has been enabled on the File Copy Tab Page Refer to SECTION 3 Copy Function 33 34 Basic Database Storage Procedure Section 4 3 1 2 3 1 Start the EDMS Console Click the Database Storage Tab in the EDMS Console The follo
73. supply is Turn ON the SPU Unit power supply 101 Incorrect copy setting turned OFF Network interference Check the cables hub and other connec tions and make sure that the network is free of interference SPU Unit collection settings Click the Load setting Button to reload the do not match copy settings SPU Unit settings and then enter the copy settings The Enable the User Authori Clear the selection zation Option is selected in the Unit settings The SPU Unit power supply is Turn ON the SPU Unit power supply turned OFF Network interference Check the cables hub and other connec tions and make sure that the network is free of interference Files can no longer be copied Stop copying files and then change the from the SPU Unit because SPU Unit settings settings or some other factor has changed Copying failed Insufficient space available on Delete unnecessary files and make sure the hard disk there is sufficient space available for copied files The number of files for data Increase the setting in the Number of files collection is set to 2 Field from the Collection Setting Panel of the SPU Console Unit monitoring cycle is too Shorten the unit monitoring cycle from the long Advanced Setting Window Lost file s Error occurred while monitor ing files 52 Troubleshooting Section 5 1 5 1 2 Troubleshooting the Database Storage Function Note All errors that occur while using the da
74. tabase storage function are logged The cause of the error can sometimes be determined by checking the log Refer to 3 2 9 Checking the Log for details on the checking procedure The main errors that can occur the assumed causes and the required correc tions are listed in the following table Error message Assumed cause Correction Data conversion The data type of the variable set Correct the data type of the vari with the SPU Console is differ able with the SPU Console ent from the actual data type in Then use the EDMS Console to the PLC delete the database storage set tings and then recreate the table The data type of a variable Use the EDMS Console to being collected by the SPU delete the database storage set Console has been changed and tings and then recreate the no longer agrees with the data __ table type in the database A variable for collection has been deleted or added with the SPU Console so the number of CSV file fields does not agree with the number of database fields Database stor The database is not started Start the database and then age failure start data storage If the database is connected Correct the problem with the remotely then there may be a network and then start data stor network problem preventing a age connection to the database There is some problem with the Correct the problem with the database that is causing errors database and then start data when storin
75. table Example DATA_0 NAME Text string The name of the variable set with SPU Console NAME S Text string The variable description set with SPU Console DATATYPE_NAME Text string The data type of the variable Example UINT 31 Database Storage Tab Page Section 4 2 Field name Field type Description DDRESS_MEMORY Text string The memory name of the variable Ae Example DM ADDRESS_OFFSET The address offset of the variable ADDRESS_BIT Integer The bit position of the variable This field is used only for BIT variables It is NULL empty for any other type of variable PLC_DATA_FORMAT Text string Data format in the PLC Administrative Table The administrative table manages the correspondence between data tables and variable tables There is only one administrative table in each database The name is always EDMS_SYSTEM The administrative table can be searched to find details on the data tables and variable tables in the database DATA_TABLE Text string The name of a data table pe ESN Blanle conse VARIABLE_TABLE _ Text string The name of a variable table eS ES SOURCE Text string The name of the SPU Unit are Blane SPUSPU Uniram PATTERN Text string The name of the collection pattern set with the SPU Console e pee Example SPU pattern name 4 2 Database Storage Tab Page This section describes the display methods for the Database Storage Tab Page i e the Database Storage Setting Pane 4 2 1 Di
76. th hour minutes and seconds that the data was collected This field corresponds to column 1 in the CSV file TIME STAMP NANO _ Long integer A header field that stores the time milli seconds and less the data was col lected This field corresponds to column 2 in the CSV file SAMPLING_INDEX Long integer A header field that stores the sampling index This field corresponds to column 3 in the CSV file Depends on data Data fields which store the actual data type of variable Field names consist of Data_ followed by a serial number starting from 0 Data fields correspond to columns 4 and on in the CSV file Data tables must be recreated if the number of variables in the SPU Unit is changed f the data tables are not recreated the data types of variables will not match the data types of the fields and it may not be possible to store data correctly in the database To recreate the data tables delete the database storage settings and then make the database storage settings again Variable tables store the attributes variable information on the data stored in the data tables The tables are automatically named by the EDMS Console Variable tables and data tables correspond 1 1 Each record in a variable table corresponds to one data field in the data table A variable table can be searched to find details on the variables stored in the data table Field ype FIELD NAME Text string The name of the field in the data
77. the down arrow on the right side of the EDMS database Field and select Add a new EDMS database EDMS database Specify the data Add a new EDMS database as Basic Database Storage Procedure Section 4 3 e The EDMS Database Settings Dialog Box will be displayed Here we will describe an example for Microsoft Access EDMS Database Settings Set the EDMS database Database type Microsoft 4ccess Name ew EDMS database Comments Enter the following data to connect to the database Database name Create Select Options Select an mdb file or enter a filename To create a new mdb file click Create Username Password Specify username and password Test Connection Cancel Select the type of database to be created in the Database type Field Here Microsoft Access is selected Enter a name in the Name Field Enter a comment if desired optional Enter the name of the database in which to store the data in the Data base name Field To create a new database click the Create Button A new database is being created in this example To use an existing database click the Select Button To enable specifying a user name and password select the Specify user name and password Option Setting Example EDMS Database Settings Set the EDMS database Database type Microsoft Access peer SPU 01_00 Comments Sampli 00 Enter the following data to connect to the database C Docum
78. tically at computer startup without click ing the Start Button by selecting this option Files will not start copying immediately however just by selecting and enabling the option 2 There are two ways to start copying a Click the Start Button b Restart the computer 3 To stop copying files click the Stop Button in the Operations Area Note When the space available on the drive where the files are stored drops to 5 a warning will occur when it drops to 2 5 an error will occur and copying files will stop Make sure there is sufficient space available on the drive before copying files 3 2 8 Checking the Copy Status Conditions Files that have been copied will be added to the List of Copied File Pane in the order they were copied The current status conditions can be checked from the Status Area E EDMS Console File Help File Copy Database Storage B ffl SPU units Realtime Sampling Copy SPU O1 192 168 39 191 Realtime Sampling Name SPURO1 Stop Samplingl Dperation La Copy Realtime Sampling AAA El Sampling2 Advanced El Sampling3 Comments ine Enabled copies d Realtime Sampling SPU O1 eae El Samplingl SPUXOD1 Enable this copy Register to Bookmarks E i Display Lo Ll Sampling2 SPU 01 Automatically copy at computer startup Bei Ld Sampling3 SPU 01 Bookmarks File Copy List Display Folder Filename File Size First Record SPUHO1 Realtime Sampling 060519 100936 0 35KB 5 19 20
79. ting Button if necessary to specify the folder to copy to the name of the copied file or the monitoring cycle for determining whether copying is possible Refer to 3 2 6 Selecting Advanced Setting as Required Click the Start Button to start copying or select the Start copying automat ically on computer startup and restart the computer Refer to 3 2 7 Starting Copying Files Copying will start and the Copy Information Window will be displayed Refer to 3 2 7 Starting Copying Files Check the copy status conditions in the Status Area Refer to 3 2 8 Checking the Copy Status Conditions Click the Display of log Button Refer to 3 2 9 Checking the Log 2 3 2 Procedural Flow for Database Storage Always perform the procedure given in 2 3 1 Procedural Flow for Copying Data before performing the following procedure to store the copied data in a database 1 2 3 I Use the SPU Console to set the data to be collected from SPU Units Be sure to set three or more data collection files Refer to the SPU Console Operation Manual Cat No V231 Select File SPU Device from the menu bar to place the EDMS Console online with an SPU Unit Refer to the 3 2 3 Registering SPU Units Enable copying files in the EDMS Console s File Copy Window Refer to the 3 2 5 Setting Files to Copy Set up database storage on the EDMS Console s Database Storage Win dow Refer to the 4 3 1 Database Storage Settings Start database s
80. tion SPU Unit Information Displays the copy status conditions and lists copied files Pane for an SPU Unit selected from the SPU Copy Tree It can also be used to start and stop copying 3 1 3 Copy Information Window Select a file from the SPU Copy Tree to display the Copy Information Window Copy Information Window Copy Settings SPU CopyTree f4 EDMS Console SPU 01 192 168 39 191 Realtime Sampling F Samplingl La Sampling2 Lal Sampling3 jak Enabled copies La Realtime Sampling SPU O1 d Samplina1 SPURO1 La Sampling2 SPU 01 Ld Sampling3 SPU 01 G Bookmarks Name SPUHO 1 Copy Realtime Sampling Comments Enable this copy C Automatically copy at computer startup Filename SPU 01 Realtime Sampling 060519 100936 0 SPU 01 Realtime Sampling 060519 100936 0 SPU 01 Realtime Sampling 06051 9 100936 0 SPU 01 Realtime Sampling 06051 9 100946 0 SPUHO1 Realtime Sampling 06051 9 100946 0 SPU 01 Realtime Sampling 06051 9 100946 0 SPU 01 Realtime Sampling 06051 9 100946 0 SPU 01 Realtime Sampling 06051 9 100946 0 SPU 01 Realtime Sampling 06051 9 100947 0 SPU 01 Realtime Sampling 06051 9 100947 0 spu 01 realtime sampling 06051 9 100957 000 spu 01 realtime sampling 06051 9 100957 000 spu 01 realtime sampling 06051 9 100957 000 spu 01 realtime sampling 06051 9 100957 000 spu 01 realtime sampling 06051 9 100958 000 spu 01 realtime sampling 06051 9 100958 000
81. torage on the EDMS Console s Database Storage Win dow Refer to the 4 3 2 Starting Database Storage and 4 5 Data Table Storage Operations 13 Basic Operating Procedures Section 2 3 14 SECTION 3 Copy Function This section provides operating procedures for the copy function of the SPU Data Management Middleware 3 1 Window Configuration of Copy Functi0M o oooooooooooooooooo 16 Sell lt SPU Copy Dress aia a a 16 3 1 2 SPU Unit Information Pane scx 3503 6 5 5 host one 6 ae h 5 nanne 17 3 1 3 Copy Information Window 0 0 ce eee eee 17 32 Operatino Procedu S mareos So Ree Se Soar koa aos Dia 20 Jal Procedural Eloy csi oia hae ea he 20 3 2 2 Starting the EDMS Console 0 0 0 cece ee 20 3 2 3 Resisterma PUTAS oe eee a 2i 3 2 4 Updating the List of SPU Units and Copies as Required 21 3 2 3 Set ne Files 10 COPY cad aaa canal 22 3 2 6 Selecting Advanced Setting as Required 22 3 2 7 Starting Copying Files 0 0 0 0 cece eee nes 23 3 2 8 Checking the Copy Status Conditions 0005 24 522 9 iIChecking the LOG ads oh couch ito Sedans Ghee eee eee 25 3 2 10 Stopping Copying Files ba ida 26 3 2 11 Disabling the Copy Function 0 0 cece eee 26 3 2 12 Displaying SPU Unit Information 0004 26 323 Copy Task Servicii tie oe sce oh sere Shah ie shore vasa o ios ba 21 3 3 1 Starting the FinsGateway Copy
82. utive file numbers the date or time of the start record and the date or time of the last record Copy monitoring Settable cycle for monitoring when copying is enabled cycle Default 10 s Status indicators Used to check starting started monitoring copying copying stopped and error status conditions Log display Press the Display of log Button to display the operating status or an error log list that shows the month day year time event ID and description Database storage function Data files that are copied to a specified folder on a computer hard disk are stored in a database The function is enabled only when three or more is set in the Number of files Field from the SPU Console Settable number of 65 max data base storage services Database storage Start Button or automatically on computer startup start conditions Storage timing Files will be automatically stored in the database as soon as storable files are detected Applicable data Microsoft Access bases Microsoft SQL Server Oracle Database Settable cycle for monitoring when there are storable files Copy folder monitor ing cycle Default 10 s Status indicators Used to check whether storage is in progress monitoring for storable files or stopped Log display Press the Display of log Button to display the operating status or an error log list that shows the month day year time and description SPU clock synchronization function The S
83. wing window will be displayed 4 EDMS Console File Database Storage Help File Copy Database Storage y Realtime Sampling LA Sampling o La Sampling3 J EDMS databases 3 Select the collection pattern setting file for the data to be stored in the da tabase In this example the file called Realtime Sampling is selected The window will change as shown below 4 EDMS Console File Database Storage Help File Copy Database Storage ff SPU units Realtime Sampling ff sPuso Lg Realtime Sampling Name SPU O1 La Sampling a ES Sampling2 Copy Realtime Sampling La Sampling3 E Comments J EDMS databases To store this copy to the database set the following data N Select the EDMS database and click Create Table i The database storage details will be set and the data table will be created in the EDMS Select the collection database pattern setting file for EDMS database v which to store data in T Specify the data table name Data table name the database Database type Database Comments Task Select the variables to store in the data table Select the variables to store in the data table If the number of fields in the data table is exceeded reduce the number of variables to store Display the EDMS database list Display the full list of EDMS databases 4 A new EDMS database will be registered If an EDMS database is already registered it can be selected e Click
84. xceeded 2 If changing files is specified changing files may not be possible if the mdb file is opened by any other application 3 If changing files is specified the mdb file with previously stored data will be renamed according to the date time format and a new mdb data stor age file will be created The name of the mdb file in which data is stored will not change even after the file is changed Select Microsoft SQL Server in the Database type Field in the EDMS Data base Settings Dialog Box EDMS Database Settings Set the EOMS database Database type Microsoft SOL Server Mame New EDMS database Comments Enter the following data to connect to the database Server name Database name Username Password Test Connection Cancel The items that can be set are listed below o lem Description Enter any desired name for the EDMS database settings Comments Enter a description of the EDMS database This field may be left blank Server name Specify the name or IP address of the server running the Microsoft SQL Server database Detailed Database Storage Settings Section 4 4 Description Enter the name of the Microsoft SQL Server database Oracle Database Note Note User name and Enter the user name and password Password Windows authentication is not supported Set the SQL Server s security set tings to enable connection with SQL Server authentication Select Oracle Database
85. y the applicable OS Network card Computers without a LAN port require an Ethernet network card sold sepa rately OS Microsoft Windows 2000 Professional Microsoft Windows XP Home Edition Microsoft Windows XP Professional Application platform Microsoft NET Framework version 1 1 execution environ ment Communications platform FinsGateway version 2003 Overview Section 1 1 Item Description Other software requirements SPU Console sold separately required to input SPU Unit settings Registration of applicable SPU Units SPU Units can be registered by specifying the IP address and name of the Unit same for the SPU Console Copy function Copies files from the Memory Card in a registered SPU Unit to a specified folder on acomputer hard disk The function is enabled only when two or more is set in the Number of files Field from the SPU Console Settable number of 256 max copies Copy start conditions Start Button or automatically on computer startup Copy timing Files will be saved to the computer hard disk over the net work automatically when copying is enabled data collec tion has stopped or files have been transferred Storage location Any specified folder Saved file name File names can be created automatically using one or any combination of the following objects Any text string the name of the copy the name of the source SPU Unit the time or date month day year the file was copied con sec

ws02-edmc1-v2 user`s manual

Contents

Download Pdf Manuals

Related Search

Related Contents