(English) 6159932120 EN-03.
Contents
1. 01 2012 3 32 1 3 Protection of the software Only the module CVI Net Collector is protected by a registration code A As long as the code is not entered the software works in evaluation mode The module CVI Net Viewer can be installed and used without any limitation as it is not protected 1 3 1 Evaluation version In evaluation mode CVI Net Collector can be run only for 90 days After these 90 evaluation days if you want to carry on using the software you must ask for your registration code To do so you can use a standard registration form which is available as you launch the software or through the menu Services Registration code e Copy the registration form fill it in and send it to CP by email tightening support cp com or by fax 33 0 240 802 077 e Each time the software is run a message that indicates the number of remaining days before the evaluation is displayed When the period has elapsed a warning message Is displayed You are not allowed to run this software Gi An evaluation version corresponds to the option Kit for 10 tightening controllers 1 3 2 Registered version Once the CVI Net Collector software has been registered the code you enter allows to determine the number of stations that can be connected Depending on the option you have chosen the number of stations that you can declare see Station list is as follows e Kit for 1 tightening controlle2. e Login USERDB_ Login e Password USERDB_Pwd wt 1 T D L TR This login password is hard coded in CVI Net TER Saso Gi Viewer and Collector to access to user privilege D database Lu We must also create an ODBC link on user privilege Legend database 3 Microsoft Access driver The name for this ODBC link must be CV Users 4 Finish button e Select Driver do Microsoft Access mdb 3 and lt click Finish 4 button 01 2012 21 32 CVI Net Microsoft Access Set Data Souce Name CVI_Users Descriptions E CSF r Database S Database Help yo Create Repair Compact a e i Advanced Cancel System Database None C Database Options gt Legend 5 Data Source Name field 6 Select button e Write CVI Users in Data Source Name field 5 and click on Select 6 button Nect Database TD cceemeeseenanees Da abase Name Directories Cancel LS ch L Georges Renault Hel Ea Database AE T Read Only Exclusive c geonges renault database List Files of Type Drives Access Databases m E c Network Legend 7 Users mdb database 8 OK button e Select the Users mdb 7 database copied before and click on OK button 8 e Close different form by OK button DZ
3. ES DE JA 27 32 D LL ES DE JA CVI Net 5 4 Table points of curve CURVE POINT BLOB CRVPT_CurvelD Curve identifier foreign key INTEGER CRVPT_BlobFormat Format code for Blob field SMALLINT CRVPT_Points Blob containing points data BLOB A Data for each point in CRVPT_ Points filed for the type 1 CRVPT_BlobFormat Index for point index 1 for first point L OOOO poe eo C S IR 1 Gi 0x0001 Start of prevailing torque Ox0002 Motor stop Ox0004 Angle threshold 5 5 Table of current indexes results and curves MAX_ID MAXID_TableName Name of table VARCHAR 50 MAXID_CurrentMaxld Current ID value INTEGER 5 6 Table of the possible code kinds for the results RESULT TYPE RSLT_ResultTypelD Result type ID INTEGER RSLT_ResultTypeLabel Result type label VARCHAR 100 A This table is fully completed during installation with script 5 7 Table of the possible code kinds for the monitoring MONITORING_TYPE MNTG_MonitoringTypelD Monitoring type ID INTEGER MNTG_MonitoringTypeLabel Monitoring type label VARCHAR 100 A This table is fully completed during installation with script 28 32 01 2012 CVI Net 5 8 Table of the error codes ERROR_CODE Fes Descrpon L ERRCD_ErrorLabel Error label VARCHAR 100 A This table is fully completed during installation with script 5 9 Geographical filter table 5 9 1 WORKSHOP table WKSId Inte
4. 0 62 09 06 2010 15 14 05 Reading 1 Mean 0 63 Range 0 07 Legend Legend 38 Range curve display 32 Navigation bar 33 Print button e Use Standard deviation button 37 to display the Standard deviation screen e Use the navigation bar 32 to move the scale e Use Print button 33 to print the graphic ag Control chart Standa d deviation Mean Standard deviation Torque Control chart e Click on Control chart button 30 to display the following graphic pm Statistiques Report about mean Report about mean Torque 4 Sample max Sample mean Y Sample min Max Tol 0 00 Mean 1 91 Min Tol 0 00 0906710 16 12 33 0906710 16 14 40 0906710 15 17 38 09406710 16 07 21 0906710 16 09 02 0906710 16 10 30 0906710 16 12 07 0906710 16 15 07 2109 10 10 56 13 2109 10 11 18 49 2109 10 11 43 49 01710710 14 11 31 25711710 10 44 01 25 1110 10 46 43 a a p a a a F 0906710 16 13 36 D T E 2 1 Standard deviation 0 03 Legend 39 Standard deviation curve display 09 06 10 15 07 00 FF 09406710 15 12 33 0906710 15 14 40 m 0906710 16 17 38 0906710 16 07 21 09406710 16 09 02 0906710 16 10 30 0906710 16 12 07 0906710 16 13 36 O9 06 10 16 15 07 2109 10 11 43 49 Reading 1 0 61 0 amp Print S E 20 Legend 34 Navigation bar 35 Print button 36 Range button 37 Standard deviatio
5. Coef for FLOAT values op Labels must not be empty E User log Internal log debug Enable Max size of file 1000000 bytes File Log_Collector_txt Nb of lines in a block to delye Location C Program Files x86 CY Bl 50 Database backul Enabled Older than 30 Run every Day 7 merger exe C Program Files x86 CVI Net CY Net Collector Bi Lasttime 14 12 2011 11438454 IP address 192 168 6 20 Legend Shared database parameters Local database parameters Check alias button User log Internal log debug Date format Updating period for connections display Send computer date and time to stations Send period 0 Coet for FLOAT values parameter 1 Database backup _OON OOP WN This screen displays and allows to modify the following parameters 2 4 1 Alias of the database Corresponds to the chain of characters which was defined when installing the ODBC driver and his alias in the utilitary BDE Administrator Gi By default Alias CVI Net Check Alias button 2 allows to check if the alias entered is valid and if the connection to the base is possible 2 4 2 Date format Selection of the display capture format for dates Available formats e DD MM YYYY by default e MM DDIYYYY e YYYY MM DD 2 4 3 Updating period for connections display e From 1 up to 999 seconds 60 seconds by default 01 2012 5 32 2 4 4 Station Synchronisation Opt
6. Connect user with login privilege Connect database with type of database access mode alias or pathname for local file Disconnect database Add authorization for with IP address of controller that has been added Remove authorization for with IP address of controller that has been removed e Events stored in Internal Logs Contains information useful to analyze behavior of CVI Net for debug only 3 5 1 How to use it 2 tabs are available User log 4 Internal log 5 e Only administrators can modify parameters in these tabs members and Guests can only view Log parameters e To enable Log check Enable and fill in Location field with a valid directory e ILIS also possible to change max size of file or the number of lines to delete each time max size is achieved 3 6 User account gt Menu Services Manage your login It is preferable to set up a user account to protect the data from handling errors only if created in the CVI Net Collector A The CVI Net Viewer user account is accessible See 2 7 page 6 To skip the login window on program launch e Right click the program shortcut e Click the Properties option e Click the Shortcut tab e Inthe Target window add the text usrpsw user_name password to the end of the command line The User Account menu is used to display information concerning the active user Gi The user account pass
7. Kere Team_1 20 12 2010 00 00 00 LU Selected workshops 20 12 2010 anhalt CVI II Workshop_2 End Workshop_2 Line_L2 gt Line_L2 M111 1 20 1 2 2010 23 59 59 M 111 2 Part number Regular expression Interval sanf End T oo t Day of week qA AII a1 lt G Search Display team report p py Legend Site window Edit sites button Selected teams window Team window Edit teams button Display team report button SQL code window display button Date and time search Day of the week search 0 Part number search 1 Search button A a OON OOP WN Advanced filters screen allows to fuse several types of filters e Search results using date amp time 8 e Search using Teams Drag amp Drop one or more teams 4 into Selected teams 3 Teams are an easy way to define interval time to search results A Team can have up to 6 breaks in that case results returned by a Team search are the ones between Start and End but excluding those done during the break s See To create manage teams page 14 e Search using day of the week 9 MS Access database Day of week criteria is not available with In that case all check boxes are disabled 6 Search using Area selection Drag amp Drop line s or workshop s into selection list 3 6 Search using Part number 10 Interval search part number between Start and End Regular expr
8. The value entered in Station name field must match exactly a controller name If the value doesn t match any station name any result won t be displayed The results displayed on this screen can be printed by clicking on the Print button from the toolbar 01 2012 CVI Net 3 CVI NET VIEWER MODULE 3 3 Selecting a language 34 Initiating the program gt Menu Services Language of the software l l You can change the language used for the menus and e Click on the menu Start from the Windows task bar dialog boxes by selecting it in the list e Move the arrow or your mouse up to Programs To do this go to the menu Services then Language of e Select CVI Net in the program list the software e Click on CVI Net Viewer to start 6 languages are currently available e English 3 2 Main screen s breach e German GE CVI Wet Viewer Spanish aa e Chinese Fie Results Curves Services EJ Results display Fall List of curves ViewerTD Admin e Japanese Select your language and validate 3 4 General Parameters gt Menu Services General parameters M5 Access 4lias_ CVI Net Shared database Legend Genera parameters 1 CVI Net Viewer menu 2 Result display button 3 List of curves button Database f Shared database Alias Alas DL Net q Type ms Access Coet for FLOAT values h T Check alias Internal log debug Men
9. a 2 D Slo gl SI XI al S 5 o G al lO ol g D O p v 3 s o olol a a l 9 D 2 O G D S 23 21 o 91S e 9 lt 5 6 1 G Q D 3 6 9 5 9 o S l G D o 8 ba The SPI_ResultID field is a foreign key and it rf A corresponds to the STA_ResultID field of the STATION table a lt 01 2012 25 32 CVI Net 1 Gi Type of results see also the RESULT_TYPE table 1 Search sequence 2 RunDown speed 3 Default phase 4 Prevailing torque phase 20 Torque controlled tightening 21 Torque controlled tightening angle 22 Torque controlled tightening angle tension 23 Torque controlled tightening angle final torque 24 Angle controlled final speed phase 25 Angle controlled final speed phase tension 26 Tension controlled tightening torque angle 27 Yield point controlled tightening 28 Tension controlled tightening yield point 29 Clamping tightening 30 Angle controlled final speed phase final torque 40 Torque controlled loosening 41 Torque controlled loosening angle 42 Angle controlled run reverse torque 2 Gi Monitoring types see also the MONITORING _ TYPE table 0 None 1 Current monitoring 1 A 2 Tension 3 Toque Monitoring 1 4 Torque amp Angle Monitoring 1 Monitoring 2 3 Error codes see also the ERROR_CODE table 0x0001 Reject for grouped spindle 0x0002 Down start cycle 0x0004 Maximum time reached 0x0008 Torque or maxi
10. advanced filters search s Tightening aus 4 A B A 2 Legend 8 Statistics button Once having launched a search and got at least 1 result click on Statistics button 8 in toolbar 7 Stahstics Measure choice Standard Torque C Angle enomo Number of readings Minimum tolerance Maximum tolerance Minimum filter Maximum fitter Expected Cam Expected Cpk Sampling ST Legend 25 General tab 26 Values tab 27 Statistic tab 6159932120 03 e Click on Values tab 26 to check list of results that will be taken into account ea Statistics G n ralit s values Stat stics Torque 0 62 09 06 2010 15 07 00 0 62 09 06 2010 15 08 16 0 61 09 06 2010 15 08 45 0 61 09 06 2010 15 11 44 0 68 09 06 2010 15 12 10 0 62 09 06 2010 15 12 33 0 59 09 06 2010 15 13 00 0 59 09 06 2010 15 13 41 0 62 0906 2010 15 14 05 0 92 09 06 2010 15 14 23 0 80 09 06 2010 15 14 40 0 75 0906 2010 15 15 00 0 66 0906 2010 15 15 20 0 66 0906 2010 15 15 37 0 68 0906 2010 15 15 56 0 62 09 06 2010 15 17 38 45 54 09 06 2010 15 35 44 0 75 09 06 2010 15 36 33 0 61 09 06 2010 15 36 57 0 80 09 06 2010 15 37 28 0 69 09 06 2010 16 07 21 0 62 09 06 2010 16 07 53 0 66 09 06 2010 16 08 11 on oon E LOLA A Legend 28 list of results e Click on Statistics tab 27 to display main statistical results Statistics Results Number of measurements selected 80 Number of sampl
11. at the end of the edition the number of OK results the number of NOK results and the total number of results e 2 data entry fields allow adding 2 lines of comments when editing the assembly report e The option Export to the text file allows to save a report as soon as you get display on screen consequently you do not have to click on the toolbar button Select the location of the record of the report B DZ Li N LLI DE JA 01 2012 174132 DZ LL ES DE JA 6159932120 03 3 10 Launching an SQL query gt Menu Results Launching an SQL query In order to allow a user who knows the SQL language to make personalised queries a screen is available in CVI Net Viewer SQL Query select from curve Number of results 54 Print Legend 1 SQL code input area 2 Start button to execute SQL query 3 Result display area 4 Print button 5 Erase button This screen shows e Anentry field 1 for the SQL code to execute e A button to Execute SQL query 2 for sending the entered code to the database management system DBMS e Adisplay area for the results of the SQL query 3 e A Print button 4 to print the result of the query CEN 18 32 CVI Net 3 11 Setup of the display of the curves gt Menu Curves Setup This screen allows selecting the data to be displayed in the list of curves The available data on display are EF Station name
12. 5 Events amp LOgS nannnonnnnnnnnnnnnnnnnnnnnnennnnennnni 6 2 5 1 How to use IL sese 6 2 6 Collect data 6 2 Privilege management eee ee eee ee D 2 8 User account eee eee T 2D SAMO SE epn a i T 2 10 Display Setup eee 8 2 11 Display in real time of the results 8 3 CVI NET VIEWER MODULE 9 3 1 Initiating the program see eee ee e eee 9 3 2 Main Screen eee 9 3 3 Selecting a language eee ee ee e 9 3 4 General Parameters ccccccceeeeeeeeeseeeees 9 3 4 1 Alias of the database 10 3 4 2 Date format sese eee ee 10 3 4 3 Switch between local and shared database 10 3 5 Events amp LOS 10 3 5 1 How to use IL ese 10 SAd ell 10 3 7 Setup of the display of the results 11 3 8 Display of the resus eee 11 3 8 1 Navigation Dar eee ee 12 3 8 2 Advanced filter sse 12 3 8 3 Export to Access database e 14 38 4 e 15 3 9 Assembly report see ee eee 17 3 10 Launching an SQL Query eee 18 3 11 Setup of the display of the curves 18 2 32 3 12 List of curves se 19 3 12 1 Navigation Dar sese 19 3 12 2 Curves CISDIOY rascdismtcasncsucanetetadiminasdecadeadsnedaus 20 3 13 Auto archive Option see e 20 3 13 1 Example T 20 3 13 2 Example of trace written by autoArchive ODIOM aeren na E E E 21 3 14 Install database for User Privileges 21 3 14 1 S
13. Manage your login See 2 8 page 7 Registration code See 1 3 2 page 3 The main screen of CVI Net Collector displays the list of stations to listen to 1 controller number IP address as well as the status of the connection with every station The updating of the display of the connections depends on the frequency which has been entered in the general parameters An Update button 3 does however allow you to update the display on request To visualise the processing of the results and curves there are 2 diodes 6 7 on the main screen The symbol 4 opposite is on the main screen It shows if the module CVI Net Collector is waiting for results and curves or if it doesn t process the results curves sent by the CVI in this case the symbol is crossed See also the paragraph See 2 6 page 6 A To choose the stations to monitor See 2 9 page 7 2 3 Selecting a Language gt Menu Services Language of the software You can change the language used for the menus and dialog boxes by selecting it in the list To do this go to the menu Services then Language of the software 6 languages are currently available e English e French e German e Spanish e Chinese e Japanese Select your language and validate 01 2012 CVI Net 2 4 General parameters gt Menu Services General parameters a Shared database Alias CVINet_MySQL Type MySQL z Te MS ACCESS
14. Station C Spindle number Sp C Spindle comment EF Report AF Station comment C Spindle serial number 7 Bolt number Fst C Cycle number Cy O Tongue threshold Threshold O Cure type Tppe Number of points O ISAGRAF field Legend 1 Elements to display 2 Checkbox For each element 1 there is a checkbox 2 to check in order to select unselect for display 01 2012 CVI Net 3 12 List of curves The data can be sorted by clicking on the headers of the columns gt Menu Curves List of curves This screen displays the list of curves stored in the database Before displaying the curve it is possible choosing the kind of curve in the pulldown menu 3 located over the filter area The different kinds available are e Torque versus time e Torque and angle versus time e Torque versus angle e Torque angle and final torque versus time e Torque angle and current versus time In the tool bar the Export to the text file button 6 opens a dialog box which allows you to enter the name and the path of a file for receiving the list of the curves as text In the tool bar the Print button 4 opens a dialog box N zR 777 3 to choose the printer before starting printing End sovt1 2010 23 59 59 iter on report E 3 12 1 Navigation bar pees Legend Legend 1 ae 1 First page button 2 Filters 2 Previous page button 3 Curve type 3 Next page button 4 Print b
15. The following window is displayed Add a workshop Rename Delete Add a line Rename Delete Legend List of sites List of workshops List of lines List of stations Search in database button Available tightening units window This screen allows to create rename workshops and lines 13 32 To add a Workshop to a Site Right click the Site 13 Click the command Add a workshop To add a line to a workshop Right click the workshop 14 Click the command Add a line To delete a station from a line Right click the station to be deleted 16 Click the command Delete To add a station to a line Selecta station from the list 18 Drag Drop the station to the required line To allocate stations to lines Click on Search in database button 17 to refresh the list of available stations This list will give non assigned stations Drag amp drop station to assign to a line ES FR DE JA DE JA CVI Net To create manage teams e Click the Edit button 5 e The following window is displayed Team ON elete Legend 19 List of teams 20 Editing area 21 Delete button e To add a new Team fill in Name for the new team Time interval Start amp End Optional start and end for breaks up to 6 breaks e To Modify an existing Team Select the cell to change Modify current value Click on O
16. as an accessible and open format to store in a database acknowledged by the market The main functions of this software are divided into modules as follows CVI Net Collector e Collecting of results and of curves in real time through the Ethernet network in order to keep records e Storage in a SQL type database with a documented format e Checking of connections to the tightening controllers and display of alarms when necessary e Display in real time of the collected results CVI Net Viewer e Display of the results per Station Spindle Date VIN number Minimum and maximum torque Minimum and maximum angle Spindle report all OK NOK Minimum and maximum final torque e Display of the curves 1 2 Conditions of use The CVI Net Collector and Viewer software work under Windows NT 2000 XP Vista 7 These software cannot be installed under Windows 95 98 as these environments do not include the necessary elements to insure communication between modules e Personal computer and tightening controllers connected through the Ethernet network e The SQL compliant on line database is available from the personal computers on which the CVI Net Collector and CVI Net Viewer modules have been installed e CVI Net Collector a single instance application at a time e CVI Net Viewer several instances of the application can be launched at the same time either on one or on several personal computers
17. ending time can only be entered when the starting date and the ending date are equivalent Alphanumeric data which can be filtered The Search button 11 launches a query in the database to update the list of results depending on the filters The data can be sorted by clicking on the headers of the columns It is possible to select one or several results Clic Ctrl to launch the display of the curves associated clicking on the button 5 in the tool bar Before the display of the curve it is possible to choose the kind of curve in the pulldown menu 3 The different kinds available are e Torque versus time e Torque and angle versus time e Torque versus angle e Torque angle and final torque versus time e Torque angle and current versus time In the tool bar the Export to the text file button 6 opens a dialog box which allows you to enter the name and the path of a file for receiving the list of the results as text In the tool bar the Print button 4 opens a dialog box to choose the printer before starting printing 3 8 1 Navigation bar ogee Legend 1 First page button 2 Previous page button 3 Next page button 4 Last page button The navigation bar lets you display the results page by page Gi 1 page 100 results 12 32 3 8 2 Advanced filter The advanced filter lets you monitor productivity by work session e Selected teams Start
18. new tightening will not be saved Time synchronisation e The time of each controller can slightly vary with time e This is why it might be advisable synchronising the hour of all the controllers e However this functionality can also be fulfilled by the CVIPC2000 software This software programs data and collects results Another PLC could do the same multi CVI A The sending of curves is not available for the e As curves share the same storage space as tightening results if the sending options of the curves are checked time of disconnection before saturation of storage memory shall decrease considerably e Curves are send in standard format composed of 500 points maximum 01 2012 23 32 4 1 Visualisation of CVI Net function Key F1 on previous screen allows the operator to access a maintenance screen on which certain data can be displayed in real time updated filling rate of storage memory of results connection of CVI locking on of CVI x LL ES DE JA CVI Net 5 STRUCTURE OF THE DATABASE Tightening results e Station data table Spindle data table Curves e Curve data table Curve point table 5 1 Station data table STATION STA_ResultID Result identifier Self incremental 1 2 STA_CycleNumber Cycle number 1 to 250 STA_TorqueUnit Torque unit Nm 0 FtLb 1 InLb 2 Kgm 3 Kgcm 4 STA_CycleComment VARCHAR 40 A Field STA _ResultID is the primary key
19. EF Final angle Angle Mas angle tolerance Amas C Target angle Target 4 F Angular threshold Threshold O Angle trend Min torque rate tolerance Amin C Final torque rate T rate May torque rate tolerance Amas P Target torque rate D UI DK Legend 1 Elements to display 2 Checkbox For each element there is a checkbox 2 to check in order to select unselect for display 8 32 2 11 Display in real time of the results gt Menu Results Display in real time p Tighte ine results in real time amp FW Date Station Torque Angle SpRP_ Filters all C Only OK Station name Only NOK Legend Results Print button Exit button Filters Station name Filter Erase button ona h WN This screen allows visualising results 1 step by step as they are received by CVI Net Collector The new results are shown on top of the list in the following way the most recent results are visualised first however you have the possibility of consulting older results by checking the list All the data to be displayed for a line of results is determined by the display setup screen Filters available 4 for the spindle reports e All e OK only e NOK only Filter on station name 5 e If Station name is empty then results for ALL controllers will be displayed e If Station name is not empty then only results produced by the controller will be displayed
20. Industrial CVI Net CVI Net Collector CVI Net Viewer Release 2 0 User s Manual Original instructions COPYRIGHT 2012 DESOUTTER HP2 7BW UK All rights reserved Any unauthorized use or copying of the contents or part thereof is prohibited This applies in particular to trademarks model denominations part numbers N and drawings Use only authorized parts Any damage or malfunction caused by the use of Lu unauthorised parts is not covered by Warranty or Product Liability UU a Partno 6159932120 03 Date 01 2012 lt Page 1 32 www desouttertools com D LL ES DE JA CVI Net TABLE OF CONTENTS 1 GENERAL INSTRUCTIONG 3 1 1 INtrOGUCTION 0 ccc cec cece eeeeeceeeeeeeeeeeeeeeeeeees 3 1 2 Conditions Of USS sese 3 1 3 Protection of the software c ccseceeeees 3 1 3 1 Evaluation Version eee eee 3 1 3 2 Registered version see 3 2 CVI NET COLLECTOR MODULE 4 2 1 Initiating the program see eee ee eee e 4 2 2 Main Screen ee ee 4 2 3 Selecting a LANQUAGE cccceeeceeeeeeeeeees 4 2 4 General parameters eee e 5 2 4 1 Alias of the database e 9 2 4 2 Date Tomat sese eee 5 2 4 3 Updating period for connections display 5 2 4 4 Station Synchronisation ese ee ee e 5 2 4 5 Switch between local and shared database 5 2 4 6 Database backup ccccecceecseeeeeeeeeeeeeeees 5 2
21. Internal log 5 e Only administrators can modify parameters in these tabs members and Guests can only view Log parameters e To enable Log check Enable and fill in Location field with a valid directory e ILIS also possible to change max size of file or the number of lines to delete each time max size is achieved 2 6 Collect data gt Menu Services Collect data R Pal Legend 1 Network monitoring enabled 2 Network monitoring disabled The menu 2 allows to stop the option of monitoring the network In this case the results and curves transmited by the CVI are not processed the connection symbol is crossed 2 If you click again on this menu you reactivate the monitoring of the network The symbol of connection is then as it was at the beginning 1 6 32 2 Privilege management gt Menu Services Manage privileges It is preferable to implement access privilege management to protect the data from handling errors CY Net Viewer Legend 1 User privilege area 2 Add button 3 Modify button 4 Delete button The privilege management menu has an Add button 2 used to add a user to the list 1 e Click the Add button 2 to open the following window Add an user Login Hame Privilege Password Confirm password Application OF Cancel Legend 1 Add an user Login e User name A A prompt for this user name will appear every time the software
22. K button e To delete an existing Team Select team name cell Press DEL key on keyboard Click on OK button to confirm To display a team report e Click the Display team report button 6 e The following window is displayed Shift report 30 11 2010 30 11 2010 23 59 59 aytime Monday Tuesday Wednesday Thursday Friday Saturday Sunday Legend 22 Print button e Click the Print button 22 to print the report Stat End Start break Break endi Start break Break en d2 Start break quip_1 08 00 12 00 Equip uip_2 12 00 07 59 3 8 3 Export to Access database This function allows to store in an Access file all results that have been selected Then this Access file will be used as local database see Switch in database Tightening eae O 9 Ar al Legend 7 Export to MSAccess file button After having launched a request containing at least one result click on Access button 7 in the toolbar Export to Save in archives gt amp ex Fay Legend 23 Name for the MSAccess file 24 Save button e Enter folder and name for the MSAccess file 23 mdb e Click on Save button 24 to export MSAccess file e The file is now ready to be read as local database 14 32 01 2012 3 8 4 Statistics This function allows to calculate statistics The maximum number of results that can be taken into account up to 100 000 Function Statistics is not available from
23. LL ES DE JA 22 32 01 2012 CVI Net 4 PROGRAMMING THE TIGHTENING CONTROLLER FOR CVI NET CVI includes a new programming screen dedicated to communicate with CVI Net provided that the CVI is equipped with an Ethernet card That screen is available through gt Parameters Peripherals Network Data Collector This screen allows to program the following options Sending results e Yes No Sending curves OK e Yes No not available for multi CVI Sending curves NOK e Yes No not available for multi CVI Alarm threshold XXX e This variable allows to specify the filling rate of the memory which launches the updating of a variable which is available through ISAGRAF e This threshold is programmed as e As soon as the filling rate of the FIFO goes over this threshold an alarm can be operated through a specific ISAGRAF application e This alarm warns the operator that the data collection is not working properly any longer The operator has time enough to take action but does not always have to stop production Locking on when FIFO is full Yes No e Allows to specify the action to take when the storage memory of results is full When locking on yes then launching a new cycle is blocked Ready of the controller becomes 0 and controls Start Cycle Tightening are rejected An error message is displayed on the control screen When locking on no you can launch a cycle but the
24. abase It s possible to choose between 2 ways to address data Shared database 1 access on network using DBMS Oracle SQL Server MySQL Local database 2 MS Access file on local hard disk e When Shared database 1 is checked we must give alias name for database ODBC source name and the type of the database MS Access Oracle SQL Server or MySQL e When Local database 2 is checked we must give full pathname for the MS Access file This file can be done by using Export to MS Access from shared data e Check alias button 3 is available for both modes It is used to check that the link to the database works changed in case of Oracle database or data exported from Oracle database In fact this is a way to avoid loss of decimal part for float values 0 Coef for FLOAT values 7 should only be e Each value is multiplied by coef before storage into Oracle e Each value is divided by coef after having been read and before to be displayed or printed For example coefficient 1000 will guarantee that we keep 3 decimals for float values 10 32 3 5 Events amp Logs e CVI Net gives 2 levels of event Log User log Internal log for Debug e 4Log files are available Spy_Collector txt amp Spy_Viewer txt for Internal Logs Log Collector txt amp Log Viewer txt for User Logs e Events stored in User Logs Start application Close application
25. e __ Angle Torque Angle M114 1 1 09 06 2010 15 07 00 1 0Nm 3620 5 View 3D E M1111 1 0906 2010 15 08 16 O8Nm 361 3 ho E M1144 01 NG062010 15 08 45 10Nm 26127 Legend Curve display window Print button Curve slide buttons Cursor control buttons Displayed curves information area Cursor on WN The screen displaying the curves has a Print button 2 which launches printing of what is displayed on screen e The displayed curves information area 5 lets you view the current values according to the position of the cursor 6 e To move the cursor 6 use the buttons 4 e To adjust the time axis of a curve Select a curve 5 Use the slide buttons 3 to adjust the scale 20 32 3 13 Auto archive option CVI Net Viewer provides a new command line e autoArchive firstDate nbOfDays archive fullpathname This option is used to easily archive a set of results This option takes 3 parameters e firstDate Beginning of interval beginning time 00 00 00 gt nb of days between current date and first day to consider See 3 13 1 e nbOfDays Number of days for the time interval to archive ending time 23 59 59 See 3 13 1 e fullpathname Directory to store the archive file This directory must exists and the parameter must have quotes in case of blank in the fullpathname The filename for archive is built with first date and last date depending
26. es Tolerance interval Lowest value Values lt min tol Mean Instant stand dev Dispersion Cam w tw G KZ I w 3 D LQ an O o o Highest value Values gt max tol Global stand deviation 20 7 Graph cal display a Con rol chart ND Hictogram Legend 29 Graphical display button 30 Control chart button 31 Histogram button From that screen it s possible to access to following D graphs LL Scatter chart graphical display 29 Control chart 30 H Histogram distribution 31 LLI D lt 4 01 2012 15 32 6159932120 03 Graphical display e Use Range button 36 to display the Range e Click on Graphical display button 29 to display the SCreen following graphic G8 ag Control chart Range Statistiques Graphical display Graphical display Torque Mean Range Torque Mean Max 3 87 Mean 1 91 Inf 0 06 Range Max 10 59 Mean 3 40 Inf 0 00 2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 E Print Close 0906710 15 07 00 0906710 16 12 33 0906710 16 14 40 0906710 15 17 38 0906710 16 07 21 0906710 16 09 02 0906710 16 10 30 0906710 16 12 07 0906710 16 13 36 0906710 16 15 07 2109710 10 56 13 2109 10 11 18 49 2109 10 11 43 49 01710710 14 11 31 25711710 10 44 01 25711710 10 46 43 Reading 9
27. ession search part number using special characters and Once conditions have been set search is launched by clicking on Search button 11 01 2012 CVI Net Results are displayed on Basic search screen 12 Tightening results DateTime Staton Torque Angle Sp RP 01 10 2010 10 54 47 MULTIn 0 05 369 0 OK 01 10 2010 10 55 37 MULTIn 0 07 369 0 OK 01 10 2010 10 55 40 MULTIn 0 07 369 0 OK Torque Angle f t v Station name Spindle comment Number of results 3 Curve type Fitters Start 20001 2010 00 00 00 End zon 2 2010 23 59 59 Filter on report All C Only OK C Only NOK Search ISAGRAF field Spindle number Cycle number Part number Legend 12 Basic search screen Then we can print export or launch statistics on this set of results LU Shift Report e Click the Display team report button 6 In case of search using advanced filters Basic filters are not taken into account Shift report 20 01 2010 20 12 2010 23 59 59 Daytime Monday Tuesday Wednesday Thursday Friday Saturday Sunday Workshop Workshop Z Print Close e Available information Start and end Date amp time search time interval Daytime selected days for this search For each selected team number of OK results number of NOK results ratio for NOK results 01 2012 To manage site workshops lines Zone editor Click the Edit button 2
28. esults M1111 001 307 M1111 0 00 364 6 CV 0 343 0 0 NOK LCT H 0 532 0 0 NOK Number of results 82 Curve type Torque Angle 17 v Filters Start 300 201 0 00 00 00 Station name End fon 1 2010 23 59 59 Spindle comment Filter on report l G AN ISAGRAF field Spindle number C Only OK Cycle number C Only NOK Cart number Legend Results Filters Curve type Print button Display curves button Export to text file button Export to MSAccess file button Statistics button Close button 10 Navigation bar 11 Search button 12 Advanced filters button 13 Curve information available 14 Tightening NOK information OAOAN OAR WN The columns shown here depend on the setup selected on the previous screen e The pictogram 13 indicates that a curve is Gi available for the result e The pictogram 14 indicates a tightening NOK report To select results we have a filter selection area 2 with the following data entry fields e Beginning date and time e Ending date and time e Filter on the spindle report All only OK Only NOK e Station name List of the station names available by clicking on the button e Spindle comment e ISAGRAF field e Part number VIN number Itis possible to enter data using the keyboard or a bar code scanner DE ES FR JA DZ LL ES DE JA CVI Net using the joker The starting
29. ion Send computer date and time to stations box to check 8 if this option is checked the date and time of the personal computer are sent to stations You can enter the sending period in the data entry field Send period 9 in minutes 1 to 999 By default e Synchronisation is not selected e Updating period 60 minutes If this option is checked make sure the equivalent option in CVIPC2000 is not checked too 2 4 5 Switch between local and shared database It is possible to choose between 2 ways to address data Shared database 1 access on network using DBMS Oracle SQL Server MySQL Local database 2 MS Access file on local hard disk e When Shared database 1 is checked we must give alias name for database ODBC source name and the type of the database MS Access Oracle SQL Server or MySQL e When Local database 2 is checked we must give full pathname for the MS Access file This file can be done by using Export to MS Access from shared data e Check alias button 3 is available for both modes It is used to check that the link to the database works changed in case of Oracle database or data Coef for FLOAT values 10 should only be exported from Oracle database In fact this is a way to avoid loss of decimal part for float values e Each value is multiplied by coef before storage into Oracle e Each value is divided by coef after havi
30. is launched 01 2012 CVI Net To skip the login window on program launch 2 9 Station list Gi e Right click the program shortcut gt Menu Station Station list e Click the Properties option This screen displays the list of the IP addresses of e Click the Shortcut tab the stations to monitor those who are allowed to e Inthe Target window add the text communicate usrpsw user_name password to the end of the command line 4 Station list Software not registered Name NO address e User name 192 168 5170 Privilege e Lets you choose the types of privilege to be assigned Jj to the user Administrator Member Guest Password e Lets you enter a password for the user account Legend A prompt will appear for this password every 1 List of IP addresses of machines to be monitored A time the software is launched 2 New address input area 3 Add button 4 Delete button Password confirmation e The password must be entered a second time to It is possible to add a station to monitor through entering guard against typing errors the controller IP address 2 and then clicking on the button Add 3 Application Then there is a control to check that the number of e Software for which the user account is accessible stations to monitor is not higher than the number allowed CVI Net Collector by the chosen option 1 10 25 50 or 200 stations CVI Net Viewer depending on the option and that the contr
31. mum spindle current reached 0x0010 Cycle non finished 0x0020 Default of synchronisaton between controllers 0x0040 External stop detected 0x0080 Internal stop D LL ES DE JA 26 32 01 2012 CVI Net 5 3 Curve data table CURVE CRV_ResultNumber CRV_StationNumber CRV_SpindleNumber CRV_CycleNumber CRV_TorqueUnit CRV_TorqueAccuracy CRV_Datetime CRV_TorqueThreshold CRV_PointDuration CRV_VIN CRV_StationName CRV_StationComment CRV_SpindleComment CRV_SpindleSerialNumber CRV_BoltNumber CRV_Isagraf CRV_CurveType CRV_PointCount Cycle number 1 to 250 SMALLINT Global report OK NOK Sena e ae NUMERIC Count of points in the curve SMALLINT Date and time of registration of the curve TIMESTAMP A Field CRV _CurvelD is the primary key of table CURVE relation A curve is linked to a result by this composed STA_ResultNumber lt gt CRV_ResultNumber STA_StationName lt gt CRV_StationName SPI SpindleNumber lt gt CRV_SpindleNumber STA_DateTime lt gt CRV_DateTime This relation can be written in SQL language SELECT CRV_CurvelD FROM CURVE STATION SPINDLE WHERE STA_ResultID ResultID AND SPI SpindleNumber SpindleNumber AND SPI ResultID STA_ResultID AND CRV_SpindleNumber SPI_ SpindleNumber AND CRV_StationName STA_StationName AND CRV_ResultNumber STA_ResultNumber AND CRV DateTime STA Date Time 01 2012 D LL
32. n button aa Li H e Use the navigation bar 34 to move the scale e Use Print button 35 to print the graphic DE JA 16 32 01 2012 CVI Net Histogram 3 9 Assembly report e Click on Histogram button 31 to display the gt Menu Results Assembly report following graphic 2 Statistiques Histogram Distribution histogram Torque S Histogram E Gauss curve Mi Mean Mean 3s S Tolerances JA Torque HH P ISAGRAF field oo Part number JA Search Srint cl _8 m ee Automatic printing JV Print number of results Export to text file Close Legend 40 Tolerance button Laaend 41 Print button ege 42 Tolerance line Uall aad This screen is similar to the result display screen See 3 8 page 11 but with a few differences e the filter area has two data entry fields for Part number VIN number e Use Print button 41 to print the graphic e Use the Tolerance button 40 to display the Tolerance line 42 tis possible to enter data using the keyboard or using a bar code scanner e The filter area does not include Apply button and the search for the tightening results is launched as soon as the VIN number is entered e The option Automatic printing allows to start printing a report as soon as you get display on screen consequently you do not have to click on the toolbar button e The option Print the number of results allows adding
33. ng been read and before to be displayed or printed For example coefficient 1000 will guarantee that we keep 3 decimals for float values 2 4 6 Database backup e Enable this option to delete the tightening results and curves from the current database and store them into an Access backup database Older than the tightening results and curves older than xx days will be stored into an Access database Run every Day the backup will be executed every xx day merger exe this is the directory where CVINet merger is installed DZ Li ES DE JA D LL ES DE JA CVI Net 2 5 Events amp Logs e CVI Net gives 2 levels of event Log User log Internal log for Debug e 4Log files are available Spy_Collector txt amp Spy_Viewer txt for Internal Logs Log Collector txt amp Log Viewer xt for User Logs e Events stored in User Logs Start application Close application Connect user with login privilege Connect database with type of database access mode alias or pathname for local file Disconnect database Add authorization for with IP address of controller that has been added Remove authorization for with IP address of controller that has been removed e Events stored in Internal Logs Contains information useful to analyze behavior of CVI Net for debug only 2 9 1 How to use it 2 tabs are available User log 4
34. of the STATION table D LL ES DE JA 24 32 01 2012 ovine O pa 5 2 Spindle data table SPINDLE SPI_SpindleSerialNumber Spindle serial number VARCHAR E por perspinie H VARCHAR SPI_TorqueRateMinTolerance NUMERIC SPI_ TorqueRateMaxTolerance NUMERIC 9 NUMERICA NUMERICO NUMERICE _ l O1 lt x w w co co w w xw w w w N ee o W w d SNr Nr Nr N WO W SS O DN DI Di NDI NI NI ND GQ O DN ANI DI ANI Di DI DN AD AI ANI DAD AD ADI DN AI DANI AI DA AI NI G On nN O 3 Y V V V V I I I d V V V V I I I I V V V I I I I I V V V I I 3 V V gt ls ls l ln SS les e gt C YS len ln l al la ln len le L WD len len on SI SI Sl SI Salg SIS 5 SISI SISI SISI SI S EI Sl sal SI 91 SI o s RI 2 3 a o s 5 z 3 2 5 3 21 21 BNI Sl 2 2 SIRI 91 al 7 Sl o a a a 5 2 21 o e S 5 Si Sl a SI Sl Gl Sl OII 2 SI o SI elel o s Sl 3 alll ce ec SI S al Sl Z 2 SI lolol 2 c o o Gl 4 o 4 a o 0 o o o of QO A cl Sl s al El l 3 2 v O d D sl Z D Sl SI 5 3 3 3 9 9 3 p ele el 5 3 4 3 2 5 5 S S 5 Z 2 5 Z 2 S 9 s z 9 agiala o Oo al 35 el C gt gt 6 Al al 2 El 2 o I Si all alb slal Fjo Sic N 4 5 S el tT 2 o D 2 o 91 S lt l 2 oj 4 slo el S Mm 3 Gl 3 al als
35. oller IP address is not already on the list 2 8 User account In case of a mistake a message informs the user that this adding is not possible otherwise the list is updated with the new entry As you exit this screen the main window is updated depending on the addings and cancelations which have Gi The user account password can be modified via been made this menu gt Menu Services Manage your login The User Account menu is used to display information concerning the active user x TE ES DE JA 01 2012 F732 D LL ES DE JA CVI Net 2 10 Display setup gt Menu Results Setup This screen allows you to select the data which must be displayed for a follow up in real time The available data on display are Display setup Elements to display Torque rate trend F Min prevailing torque T Mas prevailing torque amp Spindle report Sp AF Cycle number Cy T Cycle comment D Station comment C Spindle serial number C Bolt number Fst Error code C ServoDrive ero Min current D Mas current T Final current Current F Current trend T Monitoring type E Monitoring trend 1 Monitoring trend 2 P ISAGRAF field Date Time C Part number EF Station name Station C Spindle number Sp Spindle comment C Min torque tolerance T min EF Final torque T orgue May torque tolerance Tmas 7 Target torque T arget T Torque trend DO Min angle tolerance Amin
36. on date format used by CVI Net Viewer 3 13 1 Example 1 e If current date is 27th january 2008 e f beginning of archive 8th january 2008 gt firstDate 27 8 19 e f end of archive 20th january 2008 gt nbOfDays 20 8 1 13 Finally command line would be e C Desoutter CVI Net CVI_Net_ Viewer exe usrpsw myLogin myPassword autoArchive 19 13 C Desoutter CVI Net Archives Once this command line has been performed following file is created e C Desoutter CVI Net Archives 2008 01 08 2008 01 20 mdb Gi autoArchive option would trace events if User log is enabled 01 2012 CVI Net 3 13 2 Example of trace written by 3 14 1 Specific case User privilege database autoArchive option on MS Access file We provide a ready to use MS Access file available 2008 11 28 15 05 00 after Viewer or Collector has been installed e File Viewer or Collector directory Schema Users 2008 11 28 15 05 00 Start application mdb 2008 11 28 15 05 00 Connect user sbu Admin This file should be copied into a folder that is readable by 2008 11 28 15 05 00 Connect database Type Oracle every users Mode Shared Alias cvi oracle XE Finally CVl_Users ODBC link must be create on each 2008 11 28 15 05 00 Application started with option PC autoArchive 3251 13 D Appli Prj CVI_ Net archives Example test export auto Control Panel Administrative Tools Data Sources 2008 11 28 15 05 00 E
37. pecific case User privilege database on MS PCC CSS UIC assisen E a 21 4 PROGRAMMING THE TIGHTENING CONTROLLER FOR CVI NET 23 4 1 Visualisation of CVI Net function 23 5 STRUCTURE OF THE DATABASE 24 5 1 Station data table STATION 24 5 2 Spindle data table SPINDLE 00 0 25 5 3 Curve data table CURVE eee 27 5 4 Table points of curve CURVE POINT BLOB acha hk rera 28 5 5 Table of current indexes results and curves MAX_ID 06 28 5 6 Table of the possible code kinds for the results RESULT TYRE 28 5 7 Table of the possible code kinds for the monitoring MONITORING TYPE 28 5 8 Table of the error codes ERROR en 29 5 9 Geographical filter apie eee 29 5 9 1 WORKSHOP able sse 29 5 9 2 LINE table sees 29 5 9 3 TJ STATION LINE table eee 29 5 10 Temporal filter able 29 5 10 1 SHIFT table eee 29 5 10 2 BREAK table see 29 5 11 Table of the list of stations STATION NAME 29 5 12 Adding index on this database 30 5 13 Creation scripts e eee 30 01 2012 CVI Net 1 GENERAL INSTRUCTIONS 1 1 Introduction This manual explains how the software which composes CVI Net e CVI Net Collector e CVI Net Viewer The aim of this product is giving the client flexible means for collecting results through the Ethernet network as well
38. r e Kit for 10 tightening controllers e Kit for 25 tightening controllers e Kit for 50 tightening controllers e Kit for 200 tightening controllers D TE ES DE JA DZ LL ES DE JA CVI Net 2 CVI NET COLLECTOR MODULE 2 1 Initiating the program e Click on menu Start in the Windows task bar e Move the arrow of your mouse on Programs e Select CVI Net in the program s list e Click on CVI Net Collector to start e You can access the menus buttons directly A from the keyboard without using the mouse by using the Alt key and the keyboard shortcut underlined letter of the menu or button e The Tab key allows you to scroll forward through the menus windows e Pressing simultaneously the Shift Tab keys allows you to scroll backward 2 2 Main screen IP address 192 168 6 21 192 168 6 23 S i 7 3 eE Legend List of stations to listen to Menu Update button Status waiting for results and curves Close button Curves indicator Result indicator Version information Database version OAON OAR WN 4 32 Menus 2 available on the main screen Station list See 2 9 page 7 Configuration See 2 10 page 8 Display in real time See 2 11 page 8 Language of the software Results Services General parameters See 2 4 page 5 Collect the data See 2 6 page 6 Manage privileges See 2 7 page 6
39. rnal WORKSHOP ID INTEGER WKS Label WORKSHOP name VARCHAR 50 5 9 2 LINE table ep Descrpon IER Wks LEU U 9 9 3 TJ STATION LINE table VARCHARISO ID of the line owning the STATION INTEGER 5 10 Temporal filter table 5 10 1 SHIFT table SH e INTEGER 5 10 2 BREAK table nL BR_End BREAK end time TIMESTAMP SHId ID of SHIFT containing the BREAK INTEGER 5 11 Table of the list of stations STATION NAME Fes C L STANAME_Name STATION name VARCHAR 12 01 2012 291 32 ES DE JA D LL ES DE JA CVI Net 5 12 Adding index on this database To improve query performances in CVI Net Viewer we recommend to add following index STATION table CREATE INDEX STA_STATIONNAME_IDX ON STATION STA_StationName CREATE INDEX STA_DATE_RSLTNB_NAME_IDX ON STATION STA_DateTime STA_ResultNumber STA StationName SPINDLE table CREATE INDEX SPI_SPINDLE_ID_IDX ON SPINDLE SPI_ResultID SPl_SpindleNumber 5 13 Creation scripts The basic creation scripts can be found on the CDRom supplied by Desoutter 30 32 01 2012 More Than Productivity www desouttertools com Copyright 2011
40. us available on the main screen Coef for FLOAT values 1 User log May size of file f ooooo0 bytes Mb of lines in a block to delete Results Setup See 3 7 page 11 Display of the results See 3 8 page 11 Assembly report See Assembly report See 3 9 page 17 9 Assembly report See 3 9 page 17 17 Launch a SQL query See 3 10 page 18 Curves Setup See 3 11 page 18 Curves list See 3 12 page 19 Services Language of the software Legend Shared database parameters Local database parameters Check alias button Date format User log Internal log debug Coef for FLOAT values parameter General parameters See 3 4 page 9 Manage your login See 3 6 page 10 NO oh WD D LL ES DE JA 01 2012 9 32 DZ LL ES DE JA CVI Net This screen displays and allows to modify the following parameters 3 4 1 Alias of the database Corresponds to the chain of characters which was defined when installing the ODBC driver and his alias in the utilitary BDE Administrator By default Alias CVI Net Check Alias button 2 allows to check if the alias entered is valid and if the connection to the base is possible 3 4 2 Date format Selection of the display capture format for dates Available formats e DD MM IYYYY e MM DDIYYYY e YYYY MM DD Gi By default DD MM YYYY 3 4 3 Switch between local and shared dat
41. utton 4 Last page button gt Display cues une The navigation bar lets you display the curves page by page 6 Export to text file button ee yOu ISIS u page by page 7 Close button 8 Navigation bar 1 page 100 curves 9 Search button The displayed column corresponds to checked data on the setup screen To select results we have a filter selection area 2 with the following data entry fields e Beginning date and time e Ending date and time e Global report All Only OK Only NOK e Station name List of the station names available by clicking on the button e Spindle comment e ISAGRAF field e Part number VIN number Itis possible to enter data using the keyboard or a bar code scanner x LL alphanumeric data which can be filtered using the joker the starting ending time can only be entered when the starting date and the ending date are equivalent ES DE The Search button 9 launches a query in the database to update the list of curves depending on the filters JA 01 2012 19 32 D LL ES DE JA CVI Net 3 12 2 Curves display To display the curves you must select the curve s to be displayed multiple selection is available click on Ctrl button Display the curves in the toolbar 0 000 41 000 2000 3000 4000 5000 6000 7 000 8000 9000 10000 11 000 12 000 13 000 14 000 15 000 Time Time 5 617 s Torqu
42. word can be modified via this menu 01 2012 CVI Net 3 Setup of the display of the results gt Menu Results Setup This screen allows to choose the data to display for the tightening results The available data on display are Display setup Elements to display Torque rate trend Min prevailing torque Mae prevailing torque amp Spindle report Sp AF C Cycle number Cy C Cycle comment Station comment C Spindle serial number C Bolt number Fst L Ero code SeroDrive eror Min current T Mas current T Final current Curent F Current trend T Monitoring type O Monitoring trend 1 Monitoring trend 2 P ISAGRAF field Date Time C Part number EF Station name Station C Spindle number Sp Spindle comment D Min torque tolerance T min EF Final torque T orgue O May torque tolerance Tmas 7 Target torque T arget T F Torque trend Min angle tolerance Amin EF Final angle Angle 7 Max angle tolerance Amar 7 Target angle Target 4 F Angular threshold Threshold DO Angle trend O Min torque rate tolerance Amin C Final torque rate T rate Max torque rate tolerance Amas O Target torque rate lt im OF Cancel Legend 1 Elements to display 2 Checkbox For each element there is a checkbox 2 to check in order to select unselect for display 01 2012 11 32 3 8 Display of the results gt Menu Results Display of the results Tightening r
43. xport successfully done to Access ODBC file D Appli Prj CVL Net archives test export auto 2000 01 04 2000 01 16 mdb 2008 11 28 15 05 00 Disconnect database 2008 11 28 15 05 00 Close application System Data Sources Name Driver autoArchive option will close application after having processed whatever the result of the exportation Succeeded or failed 3 14 Install database for User Privileges To be able to manage user privileges we must install a dedicated MS ACCESS database installed with CVI NET on this machine including MT services n ODBC System data source stores information about how to connect to Gi This MS ACCESS database is automatically the indicated data provider A System data source is visible to all users Script to create user privilege database CREATE TABLE USERS Legend 1 System DNS tab USER_Login varchar 50 2 Add button USER_Application int USER_Name varchar 50 USER_Privilege int e Click on System DSN tab 1 e Click on Add button 2 USER_Password varchar 32 Wreale Nei Dete Source USER_Creation timestamp USER_LastPwdChange timestamp Select a driver for which you want to set up a data S 7 JE da Microsoft pata arquivos texto iat cs 4 Driver do Microzoftficcess nd ALTER TABLE USERS ADD PRIMARY KEY USER Login USER_ Application Following user must be authorized to read records into the database
Download Pdf Manuals
Related Search