ICP DAS PMC Data Server Quick Start Guide
Contents
1. of Data Table and CT or phase of the power meter 1s as below Project System amp INewPraoiect FTP Configuration Table Edit Table Binding 9 4 1 Data Table Editing It is used to define which power data will be selected to import into the Database system and also the definition of the Database Column Mouse right click on the project name and select Table Edit then the Table Edit window will be shown as below Input the name of the Data Table in the Table Name field and select the data items which will be used in the Database import http www icpdas com 11 ICP DAS PMC Data Server Quick Start Guide operation After complete all setting clicking Add button to add the Data Table in the system User can modify the Data Table setting which already exists by clicking Modify button Clicking Delete button will delete the Data Table which user define before y NewProject Tablei Table2 Table Name Table2 v User defined Data Select All Other Info DateTime DateTime UID Ex PhaseType UID Ex PhaseType CT Phase kw LAAs KW kWh kWh Demand Demand moa i Tie User can customize the content of the Database column for the data table as requires For example both V and I columns are the default Database column of the Data Table They can be renamed as Demo V and Demo I as following so the data from the CT or phase of the power meter will be conver2. 1 Analog I O Digital I O Relay Output Temp amp Humidity tM series tET series Module Module Module PMC Data Server Features Connect to PMC concentrators through Ethernet interface to receive the power data logger files in CSV format that are sent by PMC concentrators Support Database import function to import the content of CSV file to the MS SQL MS Access or MySQL Database system Currently the PMC Data Server support ICP DAS PMC 5141 and PMC 5151 This document is intended to give a full range instruction of PMC Data Server For detailed operations and setting information of PMC 5141 or PMC 5151 please refer to the user manual of PMC 5141 or PMC 5151 http www icpdas com 2 ICP DAS PMC Data Server Quick Start Guide 2 Before Installation PMC Data Server can be installed on Windows XP Windows Vista Windows 7 and Windows 8 Before the installation of PMC Data Server please confirm the Micro soft NET Framework 3 5 has been installed on the target computer If the target computer does not install the framework package please visit the link as below to download the file directly from Microsoft and install it Download Microsoft Net Framework Version 3 5 http www microsoft com en us download details aspx displayvlane en id 21 http www icpdas com 3 ICP DAS PMC Data Server Quick Start Guide 3 Software Installation Please contact ICP DAS service to obtain the latest version of PMC Data Serve
3. ICP DAS PMC Data Server Quick Start Guide Version 2 1 4 ICP DAS CO LTD w BRASA FR 8 A ns ICP DAS PMC Data Server Quick Start Guide Warning ICP DAS Inc LTD assumes no liability for damages consequent to the use of this product ICP DAS Inc LTD reserves the right to change this manual at any time without notice The information furnished by ICP DAS Inc is believed to be accurate and reliable However no responsibility is assumed by ICP DAS Inc LTD for its use or for any infringements of patents or other rights of third parties resulting from its use Copyright and Trademark Information O Copyright 2015 by ICP DAS Inc LTD All rights reserved worldwide Trademark of Other Companies The names used for identification only maybe registered trademarks of their respective companies License The user can use modify and backup this software on a single machine The user may not reproduce transfer or distribute this software or any copy in whole or in part http www icpdas com ICP DAS PMC Data Server Quick Start Guide Table of Contents y COVES Wissirssouir rar 1 o o A EN 3 9 SolwarelistalalO aaa iii 4 4 wJserdntertace MIO Ei T uote uetus 6 5 System Operating Procedure oocccccocccccoccncconnnocononononononnnnononnnonenenononcnnss 7 Su MEE o A e o A 7 5 1 1 create NeW PO Obs is 7 oO L2 gt NY Proein d E od DEL Rd Ep 8 Bild Opentimpor PIOJGGL usaiceses ic vetu o
4. PMC will start to transfer power data files to the specified FTP server download folder The specified FTP server download folder will contain an Info subfolder and other subfolders for each power meters The following figure is an example that shows the power data folder structure of the FTP server download path after the PMC sending back the power data files http www icpdas com 10 ICP DAS PMC Data Server Quick Start Guide Share View t Computer Local Disk D FtpRoot Mame Jo 1016551ED150000E6_2 2133 2 Jo 016551ED150000E6_2 2134 1 Jo 1016551ED150000E6_3 3112 4 J4 016551ED150000E6 3 3114 5 Li Info J T1B83656415000041 2 2133 1 J T183656415000041 2 2134 2 J4 T1B3656415000041 2 3112 3 J4 T1B3656415000041 2 3114 4 2nd PMC returned data 1st PMC returned data If user want to stop the FTP function or change the FTP setting please mouse right click on the project name and select FTP Configuration then the configuration window will be shown Click the Stop button to stop the FTP functions or change the FTP parameter setting 5 4 Data lable Editing and Binding PMC Data Server takes the CT or phase of power meter as the basic unit After user complete the setting of CT or phase of the power meter as this section the PMC Data Server will extract the content of the power data files sent back by the PMC for Database conversion The detail description of the editing of the Data Table and the binding
5. completing all setting NewProject e Table Binding E E Tablei PM 2133_phaseA PM 2133_phaseb PM 2134 CT1 Y E PMC 5151 192 168 100 86 PM 2134 CT2 ol Table a A PM 2133 E Table3 Wl PM 2133 phaseA Wl PM 2133 phaseB Cl PM 2133 phaseC Os PM 2133 phaseTot e L1l PM 2134 PM 2134 CT1 v PM 2134 CT2 Olor PM 2134 CT3 Ll PM 2134 CT4 eC PM 3112 Ll PM 3112 CT1 PM 3112 CT2 el PM 3114 Cl PM 3114 CT1 Ll PM 3114 CT2 Clt PM 3114 CT3 TT we DAI 2444 PTA 5 5 Database Settings and Conversion The Database convert function supports 3 types of Database MS Access http www icpdas com 13 ICP DAS PMC Data Server Quick Start Guide MS SQL and MySQL The user could freely define the ways to connect to the Database In addition PMC Data Server also provides automatic Database conversion function to automatically convert the content of the power data files into the specific Database system regularly 5 5 1 Create Database Connection Setting The user interface of the Database connection setting is shown as follow Follow the steps below to set up 1t Database Connection Setting Database type Test Connection Save Setting 1 The Database convert function supports 3 types of Database Select the Database type the corresponding setting textboxes for the Database type will be shown for user to fill in 1i PMC Data Server provides connection testing function for MS SQL and M
6. ct for PMC Data Server Name NewProject Path C Users JustinLee Documents Browse Create project at C Users JustinLee Documents NewProject NewProject dproj http www icpdas com 7 ICP DAS PMC Data Server Quick Start Guide 5 1 2 Save Project On the Project function list click Save Project to save current project settings so that the user can use the same PMC Data Server project next time 5 1 3 X Open Import Project On the Project function list click Open Import Project and the Open window will be shown Browse through to select the desired project file dproj and click on Open PMC Data Server will import the project settings 5 1 4 Auto Execute Last Project If user check the Auto Execute Last Project when user reboot the computer The computer will automatically launch the PMC Data Server and import the last project setting If the user has set last project to perform auto Database conversion function PMC Data Server will also launch the Database auto conversion function for user to continue the original Database conversion operation Please see chapter 5 5 for more detailed about how to perform auto Database conversion Project System Project System New Project New Project Save Project Save Project Open Import Project Open Import Project Auto Execute Last Project Exit Auto Execute Last Project Exit In addition there will be a menu whe
7. diets pie aes edere eased 8 5 1 4 Auto Execute Last Project eere 8 0 2 System SEN id 9 5o PIPSSImersetlhjSiusieeaceoetie uin teitictane pete tte Potrai oot Gator en tas 9 5 4 Data Table Editing and Binding seeeeseessssses 11 5 4 1 Data Table Edd outsider 11 542 Data Table BINGING 32 etos m mtcr us tes het aoe 12 5 5 Database Settings and Conversion eeeeeeeeeessee 13 5 5 1 Create Database Connection Setting 14 5 5 2 Save Database Connection Setting 14 5 5 3 Modify and Delete Database Connection Setting 14 5 5 4 Database CONVerSION ccoocccccccnnccocnnonocnnonacnnonnnncnnnnnononenonnns 15 http www icpdas com ICP DAS PMC Data Server Quick Start Guide 1 Overview The PMC Data Server is a Database utility developed by ICP DAS It is designed for connections to the ICP DAS PMC concentrators to read the power data measured by the power meters and import the power data into the Database system for further statistics and analysis so that enables a complete power management solution The ICP DAS PMMS Power Monitoring and Management Solution consists of three parts ICP DAS PMC Data Server ICP DAS PMC concentrator and ICP DAS power meter The PMC is used for connections to ICP DAS PM 2133 PM 3133 PM 311x MTCP power meters to read power data of the devices
8. e Connection List DB Type DB Name Login Name Login IP or Path Port MS SOL TestDB Sa ii localhost 1433 MySQL TestDB 192 168 100 50 elete 5 5 4 Database Conversion There are 2 ways to perform the database conversion function as Auto Conversion and Manual Conversion Before user performs the database convert function please make sure 1f the Database connection setting to the database works properly Auto Conversion Enable this function will let PMC Data Server automatically transferred the power data files of PMC into the Database system based on the format setting of 5 4 Data Table Editing and Binding The process to perform Auto Conversion function 1s as follows In the Perform auto conversion tab select a database connection from the Database drop down list Select the start time for the operation and at least one Data table in the Table checkbox list After completing the setting click Start button to start database conversion function When this function is executed all operations on the user interface will be locked to prevent possible error and Start button will become Stop button If the user would like to perform any operation immediately the user can stop the convert function by clicking Stop button The operations on the user interface will go back to normal again http www icpdas com 15 ICP DAS PMC Data Server Quick Start Guide Perf
9. e database will be consistent as the setting in 5 4 1 Data Table Editing http www icpdas com 17
10. ght click on the project name and select FTP Configuration J The configuration window will be shown as below Project System y MewProaiect FTP Configuration Table Edit Table Binding http www icpdas com 9 ICP DAS PMC Data Server Quick Start Guide Irae P x Fh D TP 7 EUR rver v onriquratorn User Account Setting The FTP service will start automatically when the PMC Data Server is launched Path C FtpRoot Name ADMIN ack Password Port 21 By default the system will not launch FTP service automatically If the user would like to launch the service please first complete the following settings and click Apply button Check or uncheck if the FTP service will start automatically when the PMC Data Server is launched o Path Setup the download path for saving the received power data files that PMCs send to the PMC Data Server Name and Password Set up the username and the password for the built in FTP Server of the PMC Data Server Please make sure the FTP settings on the PMC Web page is also the same as the FTP account settings on the PMC Data Server so that the PMCs can successfully login and send back power data files to the PMC Data Server Port Setup the port for the built in FTP server of the PMC Data Server 1 After the FIP server setting is completed implement the network connection of the front end PMCs and the PMC Data Server click the Enable button the
11. lation Complete PMC Data Server has been successfully installed Click Close to exit Please use Windows Update to check for any critical updates to the WET Framework Zaricel Back After the installation is completed user will find PMC Data Server shortcut icon on the desktop and in the program menu Start gt All Programs gt ICPDAS gt PMC Data Server The icon is shown as P 1 A IIS PUE ed f ICPDAS dU PMC ESTE PME Data Server All Programs 4 Windows Messenger ge Uninstall PMC Data Server Lag OFF o Turn OFF Computer http www icpdas com 5 ICP DAS PMC Data Server Quick Start Guide 4 User Interface Introduction PMC Data Server main window contains the following areas 1 System Function Area It contains the menu bar for user to select the function ii Function Operation Area User can define the content of the data table and the related power meters which will be using to import the power data into the Database system User also can review the setting here 11 Database Operation Area It provides the parameter setting for both the Database connection and Database importing functions 1v System Message Area Display the system messages during the function execution Le Project System Y Test Connection Save Setting Connection List DB Type Login Name Login IP or Path Convert Database Perform auto conversion Perform man
12. measured by the power meters by RS 485 or Ethernet interface and save these power data to the PMC When PMC Data Server is connected to these PMC concentrators by Ethernet the PMC concentrators will automatically send the power data files at pre defined scheduled time to the PMC Data Server through the FTP protocol then PMC Data Server will receive these power data logger files and import the content of these files into the Database system for further operations By using PMC Data Server to build a power management system during the whole process of system development no programming is required by a few settings of the connection parameters for Database the user could quickly convert the power data of the devices into Database system The ICP DAS PMC Data Server PMC concentrator and Power Meters is an easy to use and easy to build solution for power management that makes more efficient energy usage http www icpdas com 1 ICP DAS PMC Data Server Quick Start Guide The system architecture of ICP DAS PMMS solution 1s as below P PMC 5151 ind 794 B IN XW Board CSV Date IB as PMC 5151 a HMI ViewPAC TouchPAD Y FTP PC Monitor ps PMC Data Server MicroSD E GTM 201 USB USB RS 485 Ethernet for Remote I O amp Power Meters Ethernet Power Meter RS 485 Power Meter Flash HMI Tools 2133 112 69 110 928 Y mo T 110 805 111 474 A Sipe GOETE E t S lr
13. n user right click on the project name with mouse Each function in the menu will describe in section 5 3 and 5 4 respectively Project System amp INewPrniect FTP Configuration Table Edit Table Binding http www icpdas com g ICP DAS PMC Data Server Quick Start Guide 5 2 System Setting The user can view the version number of the utility and determine what language to be used in the system After confirms the language setting user can get to next step for project setting Please Note 1 The system need to be restarted when user changes the language setting Please make sure the project setting and save it as requires before change the language setting 2 In PMC Data Server the default language of Database columns will be based on the system language setting of PMC Data Server That 1s if Chinese is selected as system language the default language of Database columns will be in Chinese and if English is selected as system language the default language of Database columns will be in English User can also see section 5 4 for more detailed about how to customizing the names of Database columns 5 3 FTP Server Settings PMCSs send stored power data files to the PMC Data Server regularly through the FTP server Therefore it 1s required for user to setup the built in FTP server of PMC Data Server for PMCs to send back the power data logger file to the PMC Data Server Following is the steps i Mouse ri
14. orm auto conversion Perform manual conversion Database Start date 2014118258 g Table Tablet Table2 Table3 Start After the power data is converted and saved in the database the database structure will be similar to that shown below El 1g demaDEB j Database Diagrams E 3 Tables Lj System Tables 23 dbo Tablei dbo Tablez E 23 dbo Tables o Manual Conversion In the Perform manual conversion tab select a database connection from the Database drop down list identify the start time and end time of the Database conversion operation and then click on Start button to perform the database conversion operation with the setting which user define manually Perform auto conversion Perform manual conversion Database ba Start date 20141148258 jv End date 201441194258 H Start The status of the manual conversion operation will be displayed on the message list under the user interface If MS Access is selected as the destination database the MS Access mdb file will be named as below DatabaseName ProjectName TableName_GenerationTime mdb Following is an example of MS Access file for reference demoDB demoProject Tablet 20141203164004 mdb Zo T OM U Database name Project name Table name Generation time http www icpdas com 16 ICP DAS PMC Data Server Quick Start Guide If MS SQL or MySQL is selected as the destination database all names of the tables in th
15. r installation file PMC Data Server_Setup msi Double click on the installation file to start the installation click Next to continue The installer will quide you through the steps required to install PMC Data Server on your computer WARNING This computer program is protected by copyright law and international treaties Unauthorized duplication or distribution of this program or any portion of it may result in severe civil or criminal penalties and will be prosecuted to the maximum extent possible under the law On Select Installation Folder window input path or browse through file dialog box to select the destination folder and then click Next to continue Select Installation Folder The installer will install PMC Data Server to the following folder To install in this folder click Next To install to a different folder enter it below or click Browse Folder CACPDASPMC Data Server Install PMC Data Server for yourself or for anyone who uses this computer Pr Everyone 8 Just me http www icpdas com 4 ICP DAS PMC Data Server Quick Start Guide Click Next to start the installation Confirm Installation The installer is ready to install PMC Data Server on your computer Click Nest to start the installation When the installation process is completed click Close to finish the installing process im PMC Data Server Instal
16. ted into the Database with this new customized Database column Table Name Table3 User defined Data Select All Other Info Date Time Time UID oxteTme un PhaseType PhaseType CT Pn kw kvar kw kvar 5 4 2 Data Table Binding After complete the setting of 5 4 1 Data Table Editing now user ttp www icpdas com 12 ICP DAS PMC Data Server Quick Start Guide have to setup the binding relation between the Data Table and its data source The CT or phase of the power meter Mouse right click on the project name and select Table Binding then a tree architecture list of the CT or phase of power meter of PMC will be shown as below User can check or uncheck the checkboxes which is in the front of each CT or phase to add or remove the CT or phase from the binding list of the Data Table Each CT or phase can be bound to multiple Data Tables The CT or phase binding list is the data source of the Data Table When PMC Data Server start the Database conversion operation the system will perform the power data files processing according to the definition of the CT or phase which is added into the binding list or not After complete the setting the Database conversion function will be performed and store data into the Database system regularly If the user would like to remove the specified CT or phase from the binding list just uncheck the checkboxes of the CT or phase Please remember to click Apply button after
17. ual conversion Database Start date Table 2014118214 Date Time http www icpdas com 6 ICP DAS PMC Data Server Quick Start Guide 5 System Operating Procedure PMC Data Server 1s connected to ICP DAS PMC concentrators via Ethernet interface The historical power data logger files generated by PMC concentrators will be automatically sent back to PMC Data Server via FTP protocol After the PMC Data Server receives the files the power data files will be processed and then the power data of the devices measured by power meters can be imported into the Database system The following section will introduce how to perform PMC Data Server functions 5 1 Project Setting This section describes how to create save and open import project in PMC Data Server When check Auto Execute Last Project the PMC Data Server will be launched and import last project setting automatically after the computer being rebooted Project System New Project Save Project Open Import Project Auto Execute Last Project Exit ou Create New Project On the Project function list click New Project and the New Project window will appear Enter the project Name in the text field the corresponding storage path will be displayed at the bottom area of the window After entering project name and project storage path click OK button to create a new project Project type E PMC Project A proje
18. ySQL Database For MS Access connection setting 1t doesn t require connection testing the user only needs to make sure 1f the storage path 1s available or not 5 5 2 Save Database Connection Setting After complete the settings of Database Connection Setting the user could test the connection by clicking Test Connection button before the normal operation User could also skip the test step and save the connection setting directly to the Connection List by clicking Save Setting button The Database connection settings list will be showed as below Connection List DB Type DB Name Login Name Login IP or Path Port MS SQL TestDB 5d TEE localhost 1433 MySQL TestDB roat eeree 102 168 100 50 3306 5 5 3 Modify and Delete Database Connection Setting Double click the database connection setting on the Connection List the PMC Data Server will bring out the saved setting and the setting information will be showed on the Database http www icpdas com 14 ICP DAS PMC Data Server Quick Start Guide Connection Setting automatically User can modify the setting to fit their requirements After the modification is completed click Save Setting button to save the settings back to the Connection List In addition user can also delete the previous saved database connection setting on the Connection List by mouse right clicking on the selected database connection setting and select Delet
Download Pdf Manuals
Related Search