SQL Data Export for PS/PSS USER MANUAL
Contents
1. 1 View by Instance View Component ok Apy 3 Configure Windows firewall this step is usually not necessary Create an exception for SQL Server 1 In Windows Firewall click on the exceptions tab and then click on Add program 2 In the Add program window click on Browse 3 Locate the MSSQL X MSSQL Binn saqlservr exe executable program in the folder where MS SQL Server is installed click Open then click OK 4 Repeat steps 1 to 3 for each instance of SQL Server 2005 that requires an exception Create an exception for SQL Server Browser 1 In Windows Firewall click on the exceptions tab and then click on Add program 2 In the Add program window click on Browse 15 CIRCUTOR SQL Data Export for PS PSS 3 Locate the 90 Shared sqlobrowser exe executable program in the folder where MS SQL Server is installed click Open then click OK 1 2 Uninstall SQL Server If for any reason it is necessary to uninstall the local SQL Server Express 2005 follow these steps 1 From the Windows control panel in Add and Remove Programs uninstall Microsoft Sql Server 2005 Select the option Remove components of the SQL Server 2005 instance and SQLEXPRESS Database engine OS Microsoft SQL Server 2005 Uninstall Component Selection Select SQL Server 2005 components to uninstall d da To uninstall exis2. 92 352 3 904 7 8 following script with new path where you have located the database for example D use master go sp attach db SQLDataExportSQL DYXSQLDataExportSQL mdf DAXSQLDataExportSQL log LDF go 4 13 Messages completed successfully 9 Refresh 10 Install SQL Data Export for PSS 26 CIRCUTOR SQL Data Export for PS PSS 3 2 Structure of the database The database 15 basically comprised of three types of tables Devices table A single table where we will store the information on the devices Variables table Single table where we will store the information on the different variables contained in the devices Values table There is a values table for each of the devices from which data are downloaded In addition a device may have more than one values table precisely it will have a values table for each variable type STD WATT SUC CLW the device has Devices table Table name lt IP gt lt PORT gt _Devices e g 127 0 0 1 80 Devices Fields 19 Single device identifier Main key field of the table name Name of the device description Brief description of the device class Device type download Y N type filed to indicate whether this device must be downloaded or not By using this field it will be possible for the client to temporarily disable the downloading of valu
3. fulfilled 3 Copies and adaptations The Software can only be copied or adapted for file purposes or where the copy or adaptation is essential for the authorised use of the Software All lintellectual property warnings from the original Software must be reproduced on all copies lor adaptations The Software cannot be copied on any public network wi a accept the terms af the license agreement not accept the terms of the license agreement stall Stel ET NEN NJ License terms After completing the installation preparation process a dialogue will appear where you will be asked for the application installation directory SQL Data Export for PS PSS SQL Data Export for PSS InstallShield Wizard EX Choose Destination Location Select folder where setup will install files Install SQL Data Export for PSS to C Program FilessCireutarsS E Data Export For PSS Change Installshield lt Back i Next gt Cancel Selection dialogue for the installation folder Here you may select the directory in which to install the application As you will see the installation program proposes a destination directory for the application which you can change by pressing the Nexf button If you press this button a dialogue box will appear where you may choose the new application installation directory CIRCUTOR SQL Data Export for PS PSS Choose Folder Please select the installation fold
4. list SQL Data Export for PSS Cvm mini 7OCF 1FEE C92C 4F30 36D6 B98 1 download Description Description E Activa E Activa Inicial E Activa Final Corriente III Corriente L1 Corriente L2 Corriente L3 Temperatura Temperatura min AIMX1 Temperatura m x AMN Corriente min ITI 1 Corriente min 11 2 Corriente min L2 AMN3 Corriente min L3 AMX Corriente m x III AMX1 Corriente m x L1 Corriente m x L2 Corriente m x L3 Corriente de neutro Corriente de neutro Corriente de neutro P Activa III Variable Configuration By default the first time a device is selected to download application will also add all its variables to download Important Note Click on OK to temporarily store the setup after the variables that will be downloaded have been configured on the Variable setup screen the setup can be cancelled or modified later on Return to the main screen by clicking on OK on each screen The setup will then be permanently saved until a new setup is configured The changes on this screen will not be saved if you return to the variable configuration screen of this device directly before returning to the main screen Note 1 The values already downloaded in the database will not be deleted never even though the device is moved to the no download list or the device is deleted from the engine Note 2 Only the devices and variables of the PSS engine to which
5. m CIRCUTOR SQL Data Export for PS PSS Version 2 3 5 USER MANUAL M98232701 03 13B CIRCUTOR SA CIRCUTOR SQL Data Export for PS PSS INDEX 1 SQL DATA EXPORT SOFTWARE 3 1 1 ENABLE REMOTE CONNECTIONS OF THE SQL SERVER 14 UNINSTALL SQL SERVBEUadd 16 2 INTRODUCTION TO SQL DATA EXPORT 17 2 1 QGRAPHICINTERFAGCE iii reri niri e ri c P a T 17 APPENDICES ce E E A E 24 3 1 CHANGE THE LOCATION OF THE DATABASE 24 3 2 STRUCTURE OF THE 22122 2 27 CIRCUTOR SQL Data Export for PS PSS 1 SQL Data Export software installation The minimum necessary requirements for SQL Data Export to work properly on your PC are Windows 2000 SP4 Windows 2003 Server SP1 Windows SP2 Windows Vista or Windows 7 PowerStudio PowerStudio Scada version 3 0 1 or higher When the SQL Data Export installation starts a dialogue window will appear to select the installation language SQL Data Export for PSS InstallShield Wizard Choose Setup Language Select the language for the installation from the choices below English United States stl Sil _ 3 _ Neb Coca Installation language After selection of the language when the button is presse
6. when a user changes the device name as the id field is unique and does not change once created e Fields The fields of the table will depend on the type of variables that they contain For example for an STD type the fields will be dateTime Date and time of the record in CUT Main key field of the table dateTimeLocal Date and time at local time of the PC where application is installed o idVariable1 Identifier of the first variable stored corresponding to the id field in the variables table o idVariableN A field will be created for each of the STD type variables that the device contains lt gt lt gt Devices lt gt lt gt Variables B id class description description download obsolete format lt P gt lt PORT gt _ lt idDevice gt lt type gt dateTime 28
7. Insert key on the keyboard New engine Preferences Engine address IP Port The communication engine requires authentication 19 CIRCUTOR SQL Data Export for PS PSS In this dialogue box we can add the fields for the new engine such as the IP address and port If the PSS engine has authentication activated the username and password fields must be filled in for a valid user in this engine If you press the Advanced button we can select from which devices the data will be downloaded to the database and the frequency at which these data will be downloaded SQL Data Export for PSS Search Start date for downloading o1 06 2013 Initially the list on the left we will have the devices for the PSS engine To program the download of all the variables of a device it must be selected and sent to the list of devices to download by double clicking with the mouse or by using the button To not download the variables of a device simply move it over to the list on the left More than one device can be selected with the mouse so it is sent together to a different list Assign a start date i e when the data will start to be downloaded This date can not be edited later on and will be common for all devices that use this search engine 20 CIRCUTOR SQL Data Export for PS PSS The variables downloaded for a specific device can be configured by selecting a device from the Download
8. L Server Express anyway Please note that to be able to see and use servers installed on the other machines in our network we must have previously configured these to accept remote connections Point 1 1 explains in detail how to enable remote connections in an SQL Server The format of the server names found will always be machine instance server during the installation no SQL Server is detected the wizard will allow you to install the free SQL Server Express 2005 version If we are installing SQL Data Export on a Windows Vista or Windows XP operating system it is possible that the SQL Server Express installation may malfunction as these come with certain internal modules that are not properly compiled If this occurs we will see the following message Microsoft SQL Server 2005 Setup SOL Server Setup Failed to compile the Managed Object Format MOF file c Program Files Microsoft ih SOL Server 90 Shared sqilmgmproviderxpsp2up mof proceed see Troubleshooting an Installation of SQL Server 2005 or How to View SQL Server 2005 Setup Log Files in SQL Server 2005 Setup Help documentation Cancel To fix this problem perform the following steps 1 Open the command line as Administrator Start Programs Accessories System console click the right mouse button and the select option Run as Administrator Write winmgmt verifyrepositor and press enter If it says that the repository is incohe
9. Users Program data Circutor SQL Data ExportV or in a similar path depending on the operating system A log of the actions and incidents detected by the application are saved in this file Moreover a descriptive message if the configuration has failed is displayed in the Message field Further down in the list of PSS engines added you can see the following columns IP Port address at which the PSS engine is located Next download next time data will be downloaded from this engine Start date Date when the data will start to be downloaded from the PSS search engine Message explanatory message on this engine for example that the next download time has not been defined Once the components of the main screen have been explained the first step will be to configure the application by adding the IP address and the port for the PSS engines so that the application can connect to these engines The following dialogue box will appear when you click Configure 18 m CIRCUTOR SQL Data Export for PS PSS SQL Data Export for PSS Engines PSS Start date From this dialogue box you can add modify and delete PSS engines To edit an engine you must select it and click on the Modify button or double click on the selected engine To delete an engine you must select it and click on the Delete button or press the Delete key on the keyboard The following dialogue box will appear when you click Add or press the
10. VirtualPC testpe Hp Onions Microsoft SQL lt Management Studio File Edit View Tools Window Community Help i amp ER 4 following script use master go sp detach db SQLDataExportSQL go 24 CIRCUTOR SQL Data Export for PS PSS Edt Debug Tools Window Community Help xeue gt v 27 My ean 2 X SQLQueryLsgl ocaDV Mestpc 53 _ L e use master m ss go 5 1 55 Leniah alL sp detach db SQLDataExportSQL El Databases ga System Databases 1 SQLDataExportSQL Command s completed successfully 5 Refresh File Edit View Debug Tools Window Community E New Query LS EZ ld 3 _ 29 232 s T 2 mEICTEETDESUR Databases Connect oe System Databases Disconnect j SQLDataExportSQL Register Security Server Objects New Query Activity Monitor Management Start Stop Pause Resume Restart Policies Facets Start PowerShell Reports 25 CIRCUTOR SQL Data Export for PS PSS 6 Move the files SQLDataExportSQL mdf and SQLDataExportSQL_log LDF to destination SOLDataExporkSOL mdf SOLOataExporksQL_log LOF SQL Server Database Primary SOL Server Database Transac
11. d presentation screen appears SQL Data Export for PS PSS Welcome to the InstallShield Wizard for SQL Data Export for PSS The InstallShield Wizard will install SOL Data Export for P855 an your camputer To continue click Hert installshield Cancel Welcome screen After pressing the button the license screen is accessed where we must accept its terms to continue CIRCUTOR SQL Data Export for PS PSS SQL Data Export for PSS InstallShield Wizard License Agreement Please read the following license agreement carefully LICENSE CONDITIONS FOR CIRCUTOR SOFTWARE These Licence Conditions govern the use of CIRCUTOR software accompanying products with the same 501 Data Export for PSS 1 Granting the licence CIRCUTOR 5 grants one user license for one copy of the Software The Use induded the use storage loading installation running and display of the Software Itis prohibited to modify the Software disable any of the control functions or change the Software license 2 Ownership CIRCUTOR 5 or its suppliers are the owners of the Software and also own the intellectual property rights This licensed does not grant any ownership nor possession of the Software nor does it constitute the sale of the rights for the Software CIRCUTOR 5 and its other suppliers may protect its rights in the event that the Licence Conditions are not
12. e to connect to the engine or the download dates have not been configured the application will not perform any download from this engine Important note You must go to the configuration dialogue box if new devices have been added which are linked to other devices e g a CVM96 linked to devices such as an R440 CIREOS or EDS so that the variables for the CVM96 can be added to the table for the R440 CIREOS or EDS and the values of the CVM96 variables can be downloaded If the upper left hand button of the application window is pressed the software will be minimised to the object dock 11 50 12 12 2012 This icon has 3 statuses all the engines are active the application is awaiting the date of the next download E engine is not communicating the application has not been able to connect to this engine but will download the active engines application downloading the application is downloading the data from a engine to the database If you double click with the left button on the icon you will return to the main screen for the graphic interface 23 CIRCUTOR SQL Data Export for PS PSS 3 Appendices 3 1 Change the location of the database Do the following steps to change the location of the database 1 Uninstall SQL Data Export for PSS 2 Sign in SQL Server Management Studio Microsoft 4 SQL server 2008 Server type m Server name ocal SQLEXPRESS ti Test
13. er Path Ic Program Files Cirqutor SOL Data E Directories al di Program Files di Common Files Mi Internet Explorer di Microsoft Games di Movie Maker Selection dialogue for the new installation folder Once the application destination directory has been entered you may pass to the next screen by pressing button Note that at any time you may exit the installation by pressing the Cancef button on the screens provide it If you choose this option a confirmation message as follows will appear Exit Setup A Are you sure you want cancel the setup Confirmation message for quitting the installation If you choose the installation will continue from the point where it was left off otherwise you will quit the installation without saving anything One of the main installation points is to establish the SQL Database Server where you want to create the said database We can use any server that is already defined in our machine or on one of the machines of the local network In the event that you do not have a local server installed or you do not wish to use any remote one on the local network the application allows you to install the free local server SQL Server Express 2005 m CIRCUTOR SQL Data Export for PS PSS Question o SQL Sever was no detected in your computer However accessible sql server instances were found in your domain Do you want to install SQ
14. es from a device without losing the data that has already been downloaded obsolete Y N type field will only be Y true when the device is removed from the PSS engine thus the data already downloaded will be retained for future use OO Variables table Table name lt P gt lt PORT gt _Variables e g 127 0 0 1 80 Variables Fields o idDevice Identifier of the device to which the variable belongs will correspond to the id field of the devices table Main key field of the table o id Identifier of the variable for example VI1 Main key field of the table o description Brief description of the variable o type Variable type Using this field one can differentiate which variables go in each of the different devices values tables o units Units in which the value of the variables are expressed o format Format of the variable integer double date Values table There is a values table for each of the variable types that a device contains e Table name lt IP gt lt PORT gt _ lt idDevice gt lt type gt e g 127 0 0 1 80 F91FBB31 8587 4253 AC9E 93D354112B57 STD 2f CIRCUTOR SQL Data Export for PS PSS For the table name the device id will be used corresponding to the id field of the device table and the variables type that the file contains corresponding to the type field of the variables table By using the device id field instead of the name treatment will be facilitated
15. hat the installation program may require a reboot for the changes to be effective In this case you will see a warning message and it is recommended not to SQL Data Export before having rebooted Note 2 Depending on the configuration of your computer it is possible that the installation will need to access the Internet to update certain files for example to update the NET Framework version It is recommended that you have an Internet connection enabled on your computer Note 3 If you have problems connecting to the server local SQLEXPRESS change the server name to machine SQLEXPRESS where machine is the name of your computer within the local area network In Windows 2000 operating systems it is possible that in the SQL server name only local appears in this case change the name to local SQLEXPRESS After having rebooted your computer SQL Data Export will be installed on your computer and you can run it from the Start menu 13 CIRCUTOR SQL Data Export for PS PSS 1 1 Enable remote connections of the SQL Server 1 To connect to a database server installed on a machine other than the one where we have installed the application you will need to configure SQL Server for it to accept the connection Perform the following steps Enable remote connections in the SQL Server instance to which you wish to connect from the remote machine Click on Start gt Programs Microsoft SQL Server 2005 gt Configura
16. ly amp Local and remote connections Using TCP IP 2 Using named pipes only Using both TCP IP and named pipes 14 m CIRCUTOR SQL Data Export for PS PSS 2 Activate the SQL Server browser service Click on Start gt Programs gt Microsoft SQL Server 2005 gt Configuration Tools gt SQL Server surface configuration n Surface configuration of SQL Server select the surface configuration option for services and connections Expand the option SQL Server Browser and select automatic start mode apply the changes and click on Start E Surface rea Configuration for Services and Connections localhost SQL Server 2005 Surface Area Configuration Help Protect Your SQL Server Enable only the services and connection types used by your applications Disabling unused services and connections helps protect your server by reducing the surface area For default settings see Help Select a component and then configure its services and connections 1 SQLEXPRESS This service retums named pipe and port information to client applications Enabling Ej Database Engine this service is recommended for Analysis Services Service Remote Connections Semice name SQLBrowser Service Display name 501 Server Browser Description Provides SQL Server connection information to client computers Startup type Automatic Service status Running Pme
17. o local SQLERSPRESS Browse Connect using Qi windows authentication SOL Server authentication using Login ID and password below Login ID Po Hame of database catalog 01 Browse Installshield lt Back Selection of SQL Server After all this process file copying will finally start which we will see from the progress bar 11 SQL Data Export for PS PSS 501 Data Export for PSS InstallShield Wizard Setup Status The InstallShield Wizard is installing SUL Data Export for PSS Installing CA ACincutorssQb Data Export for PSS BinE ditor SOLD ataE part exe PY InstallShield Installation progress bar As you can see the installation process can still be cancelled while the files are being copied although it is advised to wait until the installation has been completed and if necessary proceed to uninstall it 12 SQL Data Export for PS PSS SQL Data Export for PSS InstallShield Wizard InstallShield Wizard Complete The Installs hield Wizard has successtully installed SUL Data Export for PSS Click Finish to exit Ihe wizard Cancel Finally if everything has been completed correctly the installation process will finish returning the operating system to its idle state after which you may run SQL Data Export from the start menu Note 1 It is possible t
18. rent write net stop winmgmt and press enter Next run winmgmt salvagerepository 5 When it ends after 2 or 3 minutes we will be able to install SQL server Express without any problem CIRCUTOR SQL Data Export for PS PSS JE Microsoft SQL Server 2005 Express Edition Setup Feature Selection Select the program features you want installed Click an icon in the following list to change how a feature is installed Feature description Installs command line tools connectivity components programming models tools and development tools This feature requires 37 MB on your hard drive It has 2 of 2 subfeatures selected The subfeatures require 49 MB on your hard drive Installation path c Program Files Microsoft SOL Server To configure SQL Server Express properly we must select the Mixed mode option on the Authentication mode screen and set the password to SqIDE236 to start the session for user sa Microsoft SQL Server 2005 Express Edition Setup The authentication mode specifies the security used when connecting to SQL Server 7 Windows Authentication Mode Mixed Mode Windows Authentication and SQL Server Authentication Specify the sa logon password below Enter password Confirm password m CIRCUTOR SQL Data Export for PS PSS On the next Configuration options screen leave the Enable user instances checkbox selected 35 Mic
19. rosoft SQL Server 2005 Express Edition Setup Configuration Options Configure user and administrator accounts This option enables users without administrator permissions to run a separate instance of the SQL Server Express Database Engine Add user to the SQL Server Administrator role This option adds the user who is running the SQL Server Express installation program to the SOL Server System Administrator role By default users on Microsoft Windows Vista operating system not members of the SOL Server System Administrator role It is most important to set these values properly for the application to work correctly In the Windows Vista operating system it is recommended to select the Add user to the SQL Server Administrator function option Once the installation process of the SQL Server has been completed if any copy of the SQL Data Export application database is found we will be given the option of adding it to the SQL Server backup of an old SQL Data Export database has been found Do you P want to restore and keep it 10 CIRCUTOR SQL Data Export for PS PSS Next the selection screen for the SQL Server to be used will be displayed where we can obtain all the accessible servers with the Browse button 501 Data Export for PSS InstallShield Wizard Database Server Login Select database server and authentication method Database server that you installing t
20. the application is connected will be displayed in the lists 21 CIRCUTOR SQL Data Export for PS PSS SQL Data Export for PSS 3 x Message 2 Open log Status IP Next Download Start date Message 127 0 0 1 80 15 00 00 0570672013 01 06 2013 testPL B Stopped Update Download 2 Exit If there are engines in the list we can update their status or force the immediate download of a specific engine by selecting it and right clicking with the mouse 22 SQL Data Export for PSS EZ Oo x Message 5 Open log Status IP Part Next Download Start date Message 15 00 00 05 06 2017 3 01 06 2013 90 Stopped Update Download ao Update MA Download cr Configure cial Exit When the date of the next download arrives the application will perform the download and the download icon will be shown with its text until the download has been completed at which point the application will return to the pending status awaiting the next download and displaying the next date This is the case with each engine in the list Note The downloads will only be performed if the user in not in the setup screens In the event that any setup screen is displayed the application will not perform any downloads until you return to the main screen or exit the graphic interface 22 CIRCUTOR SQL Data Export for PS PSS Note 1 If the application has been unabl
21. ting components select components to remove and click Next Remove 501 Server 2005 instance components Select an instance SGLEXPRESS Database Engine Remove SQL Server 05 common components Workstation Components Report 2 From the Windows control panel in Add and Remove Programs uninstall Microsoft Sql Server Native Client 16 CIRCUTOR SQL Data Export for PS PSS 2 Introduction to SQL Data Export SQL Data Export is an automatic system for exporting the variables of the devices stored in PSS and facilitates e The downloading of variables for the devices added to PSS gt Select the device from which you would like to download the variables and the variables that will be downloaded gt The programming of downloads every so often The application includes two parts similar to PSS Graphic interface Allows the application to be configured by adding PSS engines along with their devices and download schedules Service Allows the variables for the configured devices to be downloaded from the graphic interface to the database Important note You must run the graphic interface as an administrator in the operating systems that need it like Windows Vista Windows 7 or higher to have the required privileges for proper operation 2 1 Graphic interface Once the presentation screen appears you can click with the left mouse button or wait a few seconds If the application detects that the hasp key
22. tion tools SQL Server surface configuration n Surface configuration of SQL Server select the surface configuration option for services and connections Expand the option Database Engine gt Remote connections and select local and remote connections and the TCP IP protocol and channelling by name Click on service click on Stop wait until it stops and the click on Start to restart the service d Surface Area Configuration for Services and Connections localhost SQL Server 2005 Surface Area Configuration e Help Protect Your SQL Server Enable only the services and connection types used by your applications Disabling unused services and connections helps protect your server by reducing the surface area For default settings see Help Select a component and then configure its services and connections SQLEXPRESS T Database Engine Service 2 Ji Remote Connections SQL Server Browser Service _ View by Instance View by Component By default SQL Server 2005 Express Evaluation and Developer editions allow local client connections only Enterprise Standard and Workgroup editions also listen for remote client connections over TCP IP Use the options below to change the protocols on which SQL Server listens for incoming client connections TCP IP is preferred over named pipes because it requires fewer ports to be opened across the firewall 21 Local connections on
23. with the SQL Data Export code is not connected the application will shut down Before closing the hasp key will be checked up to three times to obtain the option to connect the key If the key is connected the following screen will appear and the program will be ready for use SQL Data Export for PSS lt Open log Status IP Port Next Download Start date Message Update Download er Configure zt Main screen From this screen the following actions can be performed 17 mi CIRCUTOR SQL Data Export for PS PSS Update This button allows the statuses for each engine added to the list to be refreshed There are three statuses which are indicated by an icon active engine the application is waiting for the date of next download e engine not connected the application was unable to connect to the PSS engine because it is stopped or for some other reason e downloading application the application is downloading PSS engine data to the database Download This button forces the immediate downloading of all the active engines in the list Configure This button allows you to add edit and delete the PSS engines in the application Exit This button allows you to close the graphic interface without stopping the service Open log This button opens the log yyyyMM txt file which is located in C Documents and Settings All
Download Pdf Manuals
Related Search