Home

Meter Site Manager 2 Version 1.4.0.0

Contents

1. Mark SitelD Locator SPH 4w WYE ZCDIL N aw DELTA EER O WIRE Y Rev 1 10 Page 35 of 68 2 Inthe tree view click the desired date Tests E 3W DELTA TEC Revised 6 29 2010 2 12 PM Revised 7 7 2009 9 00 AM H 7 8 2009 9 42 AM CT Test 7 7 2009 9 15 AM CT Test 7 7 2009 9 10 AM gt CT Test 7 7 2009 9 05 AM Demand Test 7 7 2009 12 00 PM E Customer Load Test 7 7 2009 10 11 AM H Customer Load Test 7 7 2009 9 29 AM H 7 6 2009 4 54 PM 7 6 2009 2 45 PM G 7 6 2009 2 30 PM 7 6 2009 2 18 PM 3 Click the desired test to be deleted Tests 3W DELTA TEC Revised 6 29 2010 2 12 PM 5 Revised 7 7 2009 9 00 AM a 7 8 2009 9 42 AM ei 7 7 2009 9 08 AM gl Test 22242009 9 15 AM CT Test 7 7 2009 9 10 AM CT Test 772009 9 05 AM 4 Right click Delete Tests a 3W DELTA TEC Revised 6 29 2010 212 PM Revised 7 7 2009 9 00 AM a 7 8 2008 9 42 AM 5 7 7 2009 9 08 AM MES CT Test 7 7 2009 9 1 imiia CT Test 77 2009 9 11 DE ee CT Test 7 7 2009 9 05 AM 5 Confirm by clicking Yes Delete Data Are vou sure you what to delete the data For CT Test 7 7 2009 9 15 AM Rev 1 10 Page 36 of 68 9 Database Tables The user has the ability to create edit or delete metering components AMR CT PT Meter in the database They also have the ability to enable or disable the comp
2. Select Type Select File Extension Select Database Table File s AMR Table Select All vol Ed AMR Manufacturer Table Bep Basic Test Data Table E Export 9 csv Calibration Verification File Tabli IEA CT Table CT Burden Class Table F CT Manufacturer Table CT PT Accuracy Class Table CT Test Detail Table CT Test Master Table 7 Database Version Table E Data Trend File Table Cancel Rev 1 10 Page 47 of 68 5 Click OK to close any error messages that display The message notes to the user what action is taken in the import process The user can go back and edit the file to correct any errors to fully complete the import Invalid CT Table Value A data value from data row 104 in the CTTable csv file was invalid Cannot set column Model The value violates the MaxLength limit of this column Data row 104 from the CTTable csy file was not inserted into the CT table in the database 6 Once the import process is complete click OK to finish Database File Import Complete Data table file s from the UP CAUsersimullins TEC USA Documents MetersiteManager Databasela bleFiles directory have been successfully imported into the database Rev 1 10 Page 48 of 68 12 Preferences Preferences File Locations Customizations Database Backup Directory UAMSM Test Paths Data you download from an analyzer will be stored in folders inside the Database Backup Direct
3. Next 13 Click Close to complete installation 2 2 Windows 7 32 bit Microsoft Mobile Device Center 6 1 Before installing Meter Site Manager Microsoft Mobile Device Center 6 1 must be installed first Open the Win7 32bit folder if MetersiteManagerlnstaller msi 1 Double click the drvupdate x86 exe file 2 After installation the driver will claim to not install correctly Once the PowerMaster is first connected the driver will then install completely Microsoft SQL Server Compact 3 5 After installation of Microsoft Mobile Device Center 6 1 Microsoft SQL Server Compact 3 5 must be installed Open the Win7 32bit folder Mame Date mic EH drvupdate x86 exe 7 22 20 f 55CERuntime ENU 86 msj 5 15 20 i MeterSiteManagerlnstaller rmsi 10 25 21 Rev 1 10 Page 12 of 68 Double click the SSCERuntime ENU x86 msi file Click Next to begin installation Accept the terms and agreement Click Next Click Install Click Finish to complete installation D I Meter Site Manager Application After installation of Microsoft Mobile Device Center 6 1 and Microsoft SQL Server Compact 3 5 Meter Site Manager can now be installed Name Date me j dryupdate x86 exe 1 22 20 E ssCERuntime ENU x86 msi 5 15 201 ier MetersiteManagerinstaller mei 10 25 21 Double click the MeterSiteManagerlnstaller msi file Click Next to continue Select Ever
4. SitelD TestDate Customer Address State Zip 3PH 4w WYE 100 5 CT 7 27 2009 2 30 PM i 0 3PH 4W WYE S 5 CT _ 7 8 2009 10 07 AM 0 3PH AW WYE ZCOIL 7 30 2009 10 34 PM o JW DELTA 7 8 2003 9 41 AM AccountNumber 4 w DELTA AHI S007F05 7 14 2009 2 33 PM 7 13 2009 4 17 PM 4 DELTA SO10F08 lt Tests Summary PrimaryVoltage BillingMultiplier ps Cada o RAP ELS ESE JCE a E q E oo TEET ETT a 3W DELTA m Jab Print Revised 7 7 2009 9 00 AM 7 8 2009 9 42 AM E CT Test 7 7 2009 9 15 AM CT Test 7 7 2009 9 10 AM ET Test 7 7 2009 9 05 AM Demand Test 7 7 2009 12 00 PM q Customer Load Test 7 7 2009 10 11 AM Customer Load Test 7 7 2009 9 29 AM a 7 6 2009 4 54 PM 7 6 2009 2 45 PM 4 7 6 2009 2 30 PM 2 7 6 2009 2 18 PM Site ID 3WDELTA Customer Test Date Tuesday July 07 2009 12 00 46 PM UTC 05 00 Service 3 Phase 3 Wire Delta 2V 2C TR Meter Information Manufacturer General Electric Model KV Catalog No 745X500001 Serial No TREE VIEW Meter Test Data Pulses Actual 222 Pulses Expected 221 9359 Measurement Time 1306 337 Summary of Last Test Account No Tech 1 BILL Tech 2 FRED Sys ID 7335 140002 Accuracy Class 0 5 Meter Form 454 Meter Number Kt 1 2 Mode Wh Wh Meter 266 400 Wh Actual 266 383 CT_C_SN Reg 100 006 Eek 8 X Mie Basic Test Data _ Phase Voltage V Phasel Phas
5. EE CT Editor Showing Enabled CT New Cat 7882470622 7882478604 7882478G07 7882478610 7882478613 7882478616 7882478619 7088247823 7882478605 7882478608 7882478611 7882478614 7882478617 7882478620 7882478624 7882478606 7882478609 7882478612 7882478615 70882478618 7882478621 708248708 pal BOE NN NN BU ER N EDE EDE ME DE EER ET gt Yes Yes Yes Yes Yes Y Y Ye Ye Ye Ye Ye asi Accuracy Class 0 15 Nameplate Ratio Rating Factor 4 Enabled Rev 1 10 Page 37 of 68 Edit To edit an item in the database click Edit at the top menu Change selections as desired and press Save to complete EE CT Editor Showing Enabled CT a kam EYE EE EMM EE EE EE DE EE A 7 7882478G22 7882478610 7882478613 7882478616 7882478619 7882478623 7882478605 7882478614 7882478617 7882478620 7882478624 7882478606 7882478609 ad 7882478621 7882487608 7009407000 de Enal Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes L Mas Q l gt 3 nufacturer FME Model CBT H Catalog 7882478622 Burden Class 9 2 v Rating Factor 4 v Enabled Enable Disable To prevent hundreds of items that will unnecessarily display in the PowerMaster database the user can disable components It is recommended that items not normally used should be disabled To do this select the item in
6. iS SSCERuntime ENU x86 msi Double click the SSCERuntime ENU x64 msi file Click Next to begin installation Accept the terms and agreement Click Next Click Install Click Finish to complete installation GE EN Meter Site Manager Application After installation of Microsoft Mobile Device Center 6 1 and Microsoft SQL Server Compact 3 5 Meter Site Manager can now be installed a cu rt mM Name d ho 5 drvupdate amdb64 exe 5 MeterSiteManagerlnstaller msi in 16 SSCERuntime ENU x64 msi 15 SSCERuntime ENU x86 msi In UJ p o fo r H H in 1 Double click the MeterSiteManagerinstaller msi file Rev 1 10 Page 14 of 68 oY 7 9 92 Click Next to continue Select Everyone Click Next Click Next Click Close to complete installation 2 4 Updating all Operating Systems Before updating Meter Site Manager 2 the previous version must be uninstalled first Do the following 1 Click Start Control Panel 2 At the Control Panel click Add or Remove Programs 3 Find Meter Site Manager 2 in the list and click Remove 4 After uninstalling the previous version of Meter Site Manager 2 open the MeterSiteManager2 folder Double click MeterSiteManagerlnstaller msi Ignore all other files ey setup mai ja SSC ERuntime ENL x06 msi Install as normal see Meter Site Manager Applicati
7. lt CO O SiteDescription CustomField20 nvarchar Stedessipion owr _ vener Stedessipion ELO mania Stedessipion Geweer mata SiteDescription CustomField26 nvarchar 30 30 lt lt lt lt SiteDescription nvarchar 30 EN EE IA EN il om A EN il Year D Y EN il NN NN JN Y SiteDescription CustomField33 nvarchar lt lt lt lt CO O SiteDescription CustomField34 nvarchar SiteDescription CustomField35 _ SiteDescription CustomField36 nvarchar 30 Y SiteDescription CustomField37 nvarchar 80 Y Rev 1 10 Page 63 of 68 30 30 lt lt lt lt Soson osor NN INN Y Stedesaipion ELO macia Soson EL mata EN ear IN Y ENE NL N N do SiteDescription CustomField43 nvarchar lt lt lt SiteDescription CustomField44 nvarchar gt Soson owr ear 90 y Soson owore ear el Y Soson owr ear E Y Soson owore ear o Y Seon E O E SiteDescription CustomField50 nvarchar CO O lt lt lt lt SiteDescription CustomField51 nvarchar EN ear E y Seon ELO ear of E EL ear 0 y Seon owas mata el A ENE NL N SiteDescription CustomField57 nvarchar CO O lt lt lt lt SiteDescription CustomField58 nvarchar Stedesaipion ELO mata E A ENE NN NN IN resp 12 at N Tessons ame varia ef Tse premoren Koy o O TestSetup TestRevs smallint CO O Z Z lt lt TestSetup Demandlinterval smallint
8. AE EERS S rara atas aaa 16 4 Upload Data From the PowerMaster to the PC 19 4 1 Upload Data From a USB Flash Drive issie ees ee es A ee eu ie 22 5 Download Data from the PC to the PowerMaster Creating a Route 25 5 1 Erase Data from the PowerMaster aeee 28 6 Merging Backup Databases into the Master Database 29 6 1 Merging a Single Backup Database ccccocccconncoccnnoconcconcnononncnnnnnnncnnonnnnonnnnnonanonnnnonannss 29 6 2 Merging Multiple Backup Databases with the Batch Merge ProcessS 31 7 Generaling RE DOM Sc edo GE 32 8 Deleting Test Data from the Master or Backup Database 34 9 Database Maple EE 37 9 1 Editor Create a SIE NSS ee be N LS DALA RR 39 9 2 Edit or Create a Test SELUP ers ERENS A lid 40 9 3 Edit or Create a Phantom Load Setup oococccocnnccncnnccnanononannnonannnonanononancnnonnnnnnnnenonnncanonos 41 10 Import Export an ODBC Database eee 43 10 1 EXPOR Microsoft ACCESS EE daa nad 43 10 2 Import rom MITOSO ACCESS sn nsec N De Nana ADELA ER ei a EE AS 44 10 3 Export to Microsoft SQL Server 2005 ee EE SER Ee AR E ee Ee ee ee ee ee ee ee ee ee 44 10 4 Import from Microsoft SOL Server 2005 EER EENS iaa 45 11 EXxporvimport XT Or CSV FIleS ESE ED EE EE DS Ge Ge Ge ee ee 46 A EXPO IS DE OF CSV INES Hi aid 46 11227 4IMPOIT IXL OF JE SV TES na Sade dean I EI O AAA A I L CA A AT
9. Click OK to continue Enter Sal Server Information Server Name sql navigator User Name cmullins Password pmxuser Trusted Connection Cancel Rev 1 10 Page 45 of 68 11 Export Import txt or csv Files The Meter Site Manager 2 software allows the user to export the database tables to a flat file txt or csv It also allows flat files to be imported granted they are formatted exactly as the exported files For an overview of the database columns go to Appendix 1 11 1 Export to txt or csv files 1 Open the desired sdf database in Meter Site Manager 2 By default the Master database is open Any backup databases can be opened via File Open Backup Database Click Tools Import Export Database Table Files Select the file output directory in the drop down box or click Change to browse to another directory 4 Select Export Select the desired extension txt or csv Then select the desired table s to be exported If all tables are to be exported click Select All Click OK to continue Import Export Databse Table File s DD NN gt gt gt gt Import Export Database Table File s Directory C Users mullins TEC USA Documents MeterSite Manager Database TableFiles Change Select Type Select File Extension Select Database Table File s Meter Test Interval Detail Table Select All Hel kapart w a F Meter Test Master Table F Ph
10. Manual Load Box Control B utilities E calibration Verification Recall Data save Database Snapshot Backup You have entered Communications Mode for transferring data DB install a System Upgrade set System Time BEdit Test Session Notes user Preferences with your computer Press ENTER or SPACE when you have finished transferring data 3 Use the USB cable to connect to the PC USB To Host 4 Wait for the sync icon in the system tray to turn green Windows XP Rev 1 10 Page 25 of 68 5 At the Master Database king icon select the desired site s you wish to download into the PowerMaster Mete Site Manager M Code TestingWsmDatabase sel Fle Edt Communication Tools Window Help an ie n g m Master Database Site List Mark SitelD TestD ate Customar EF DELTA 7 8 2009 9 41 AM E aw DELTA AHI S007F05 7 14 2009 2 33 PM E AW DELTA SOIOFOB 7 13 2009 4 17 PM m wsos 7410 2009 4 53 PM DO 4w TSOOBFOEA 741342009 10 29 AM 6 After selection click Communication Create Route and Send to PowerMaster Analyzer Ed Meter Site Manager M Code Testing MsmDatabase sdf Fie Edt Communication Tools Window Help 7 Verify the route is correct The user can also select to download historical test data for each site 3 6 12 or 24 months in the past If no historical test data is needed select 0 Months Whe
11. PM 7 10 2009 312 PM 1 9 20105 58AM S002F03 SRV 3PH 4w DELTA ZV 2C 7 10 2009 10 43 AM 7 10 2009 8 36 AM 1 8 2010 11 27 PM SO06F05 SRV 3PH 4W WYE 100 5 CT 7 23 2009 10 17 AM 7 23 2009 9 24 AM 12 25 2009 3 40 AM SOODFOS SFV 3PH AW WYE 5 5 CT 7 8 200910 07 AM 16 30 2009 7 55 AM 12 25 2009 3 57 AM SOOOFO9 SRV 3PH 4W WYE ZCOIL 7 20 2009 10 17 AM 7 20 2009 10 08 AM 1 6 2010 6 26 AM _ S009F06 SRV lt 0 0 0 0 BEWARE THE LADY WI v gt Tests 1PH 3W 3S 2PC a Revised 7 14 2009 1 09 PM TREE VIEW WARNING Data trends are not transferred at the same time as the database If you have data trend saved to USB or SD card memory devices do not wipe them out after transferring the database or you will lose data Rev 1 10 Page 20 of 68 8 After download is complete press ENTER or SPACE on the PowerMaster to reboot or simply power off by pressing ON if complete You have entered Communications Mode for transferring data with your computer Press ENTER or SPACE when you have finished transferring data Rev 1 10 Page 21 of 68 4 1 Upload Data From a USB Flash Drive NOTE This feature applies to PowerMaster units with a Main Application of 1 0 0 14 or higher 1 When at the Main Menu on the PowerMaster press 3 to enter the Utilities Menu 47 Main Menu Select Site BInstrument Transformer Testing O Utilities Recall Data 2 Inthe Utilities Men
12. TestSetup HasCT Test TestSetup HasPT Test TestSetup HasPhantomLoadT est lt MT li lt MaxCTBurden real Rev 1 10 Page 64 of 68 lt TestSetup TestSetup TestSetup UserFieldNames UserFieldNames UserFieldNames UserFieldNames UserField6Name DoCustomerLoadwithDemand dit o NS SyncDemandToRealTime UserFieldNames UserField1 Name UserFieldNames UserField2Name UserField3Name UserField4Name UserField5Name UserFieldNames UserField7Name UserFieldNames UserField8Name UserFieldNames UserField9Name UserFieldNames UserFieldNames UserFieldNames ereto UserFieldNames UserFieldNames UserFieldNames Merino UserFieldNames UserFieldNames UserFieldNames estao UserFieldNames UserFieldNames UserFieldNames UserFieldNames UserField34Name UserFieldNames UserField35Name Rev 1 10 UserField10Name UserField11Name UserField12Name UserField1 7Name UserField18Name UserField19Name UserField24Name UserField25Name UserField26Name UserField31Name UserField32Name UserField33Name nvarchar nvarchar gt pactar Y marca e Y pactar e Y N 32 32 lt lt lt lt nvarchar N nvarchar nvarchar nvarchar 32 32 nvarchar N nvarchar nvarchar nvarchar 32 32 nvarchar nvarchar 32 nvarchar 3 2 2 nvarchar N nvarchar nvarchar nvarchar 32 32 Page 65 of 68 ereas urone er 2 A Bereans uer
13. Was V ESC AA Y Esteio WE Y aseresi ala VR ma ESC OB BasicTestData VTHD C real BasicTestData ITHD A real Esteio ME Y ESC O ea BasicTestData VASys real BasicTestData VARSys real Rev 1 10 Page 54 of 68 lt lt lt lt lt lt Z Z Z Z Berea wigs _ ON ESC UE veer ER BascTesDaa Vindo mam ON meteo E O valer ON BascTesDaa pao _ vacher ER EE AN N EE Key eon N GalbraonVercatonFie Baan E ON albaionvrteaionie TosMade maia N albaionverteatoie FieNane uam N gt Z Z Z 1 CT Key bigint N Manufacturer nvarchar Model nvarchar 1 er E verter o N CT pores mania ER CT CT CT Z Z BurdenClass real E o w Z Z Enabled CT LastModified datetime E NN LN EEN GEN warner _ N NN NN LN A y NN NN LN ae y NN ENE tar CTManufacturer Zip nvarchar 10 E E G A NN NN LN A y gt erie wees feet E v CTPTAccuracyClass AccuracyClass nvarchar CTPTAccuracyClass HighEnd real CTPTAccuracyClass HighEndAccuracy real fo CTPTAccuracyClass LowEndAccuracy real TN Rev 1 10 Page 55 of 68 lt lt N lt lt lt Z Z Z Grese forro um TT omeo pn o a N N Grese LN N N EN 7 NN N CTTesiDetail PhaseShift real CTTestMaster CTTestMaster_Key bigint CTTestMaster MasterTestRecord_Key bigint Teaser Dmeme gt LN N GC 2 LO E N A LO LN WEN ELI INN LL NN LN WEN 1 WEL INN NN
14. are many backup datab ale 2 ases that need to be merged To begin click Tools Batch Merge Process Window Help Preferences lt atch Merge Process Compact Master Database The user is prompted to verify if they want to continue If ok click Yes Batch Merge All Backup Data 9 IF you click the Yes button we will attempt to merge all the backup databases we can find in e UAMSM Test Paths and its subdirectories into the Master database This operation should be safe Data that already exists in the Master database will not be duplicated Are you sure you want to do this id Meter Site Manager C Documents and Settings mullins Wy DocumentsiMeterSiteManagerWatabaselMsmDatabase sdf EER aJ File Edit Communication Tools Window Help Rev 1 10 T X Master Database Site List C in el ity tate ip rimaryVoltage BillingMultiplier 4w DELTA SO10F08 4w Y SOOSFOS 4w Y SOO8F054 7 13 2009 10 29 AM AWD 24 2C 2PC 7 10 2009 2 45 PM 4WDEL 24 2C 3PC 7 10 2009 11 27 AM CTASN CTBSN CTCSN MA 4wY ZCOIL 10 8 2009 10 28 AM lt Tests E 4w Y S008F05 Revised 7 10 2009 4 42 PM E 7 13 2009 10 21 AM 7 10 2009 4 46 PM a 2 10 2009 4 40 PM 7 10 2009 4 23 PM Page 31 of 68 7 Generating Reports fa Meter Site Manager C Documents and Settings mullins My Documents WeterSiteManager Database MsmDatabase sdf os Ele Edt Communication Tools Window Help Master Database Site List
15. report If the CT test performed was Burden Only the report would incorrectly display as Burden Ratio Fixed a bug in Summary of Last Test report If only CT tests were present the Phantom Load test results would not display Added function to import Microsoft Access and SQL Server 2005 databases Added database tables UserFieldNames and UtsFieldNames to store information read from the PowerMaster xml file concerning the user fields Added the MasterTestRecord user fields to Summary of Last Test report Added the ability of the user fields to only display when modified Added all available Phantom Load test results to Summary of Last Test report Added the control of copying and pasting the directory path in the Backup Database Directory in Preferences Added more exception handling for errors not caught Changed the TestDate field in the database site list to display the latest test date for the most recent revision Changed the database merge between a Master and Backup to update any existing row from one database to another Removed the Test Setup Editor item from the Tools menu Updates database from 1 11 to 1 12 Known Issues 1 2 8 Does not have a user interface in the database tables to edit custom field names Need ability for multiple users to view the database while simultaneously being edited by another user In the Site Editor the label headers for Meter CT and PT are not aligned Cannot
16. the Access database can be found in the directory that was created Double click the mdb file to open with Microsoft Access Documents library Odbr Name Date modified Type 2 OdbcDatabase mdb 11 15 2010 3 48 PM Microsoft Office A Rev 1 10 Page 43 of 68 10 2 Import from Microsoft Access lf an Access database mdb is formatted correctly for the sdf database Meter Site Manager 2 can import this file Each import will update the change s to the database 1 Open the desired sdf database in Meter Site Manager 2 By default the Master database is open Any backup databases can be opened via File Open Backup Database Click Tools Import Export an ODBC database Click Import for Select Type and Microsoft Access for Select Database Type 4 Select the database directory in the drop down box or click Change to browse to another directory 5 Click OK 10 3 Export to Microsoft SQL Server 2005 1 Open the desired sdf database in Meter Site Manager 2 By default the Master database is open Any backup databases can be opened via File Open Backup Database 2 Click Tools Export data to an ODBC database Select the database output directory in the drop down box or click Change to browse to another directory Select SQL Server 2005 as the database type Click OK lf an ODBC database does not exist select Create an ODBC database If an ODBC database was created previo
17. the database table and click Disable at the top menu To disable multiple entries hold Ctrl and right click all components Then click Disable Rev 1 10 Page 38 of 68 9 1 Edit or Create a Site To edit a site first select a site in the Master Database list highlighted below Then click Edit Edit Site All fields can be edited except Site ID Once complete click Save Ea Site Editor Page 1 Page 2 Page 3 Paged Pages _ Site ID au DELTA Billing Mult 40 Service 3 Phase 3 Wire Delta 2W 2C TR SO05FOS Test Setup Default 1 Pri Volts Jo Customer TEC Next Test 2010 Dec 29 Account 123 456 789 City Knoxville Address 1 10737 Lexington Dr State Pro TN y Zip 37932 Address 2 Country USA Phone 665 966 5856 Substation Basel Locator 35 910226 84 144124 Mir Mdl Catt Frm Ty Kt Acc General Elec EY 745 500001 454 TR 1 SN 321ABC456 Comm ID 2659665856 Meter No xx78s dea IP Addr 167 152 254 60 Entering a Meter CT PT or AMR Click inside the selection box Once selected a button will appear at the bottom of the tray ex Meter Editor If the metering component cannot be found in the drop down box click the button to enter the database
18. the master database The user can also send a blank database down to the PowerMaster to erase the existing one Added an icon to the master database king and backup database pawn to better differentiate the two Added check boxes next to the sites in the master database for selection to be downloaded into the PowerMaster Added the ability to create edit and delete sites in the master database This also includes the Test Editor and Phantom Load Setup Fixed the ability to open the application twice Added message prompt when the master database is being viewed by another user The following are changes which were included in Release 0 0 6 0 1 4 Rev 1 Created the function and interface for the master database Users can now create a master database to store all information in one place Added a merge and batch merge feature to allow users to easily merge all backup databases into the master database Added support tables for the metering components AMR meter CT PT The user can now create edit and delete metering components within Meter Site Manager rather than the PowerMaster exclusively After creating the master database it will open as a default action at bootup 10 Page 7 of 68 5 Added a selection of how many database backups the user can select Selections are 10 5 3 or 1 The user is prompted when the backups exceed the current selection 6 Removed Percent Registration from the si
19. 00 File Folder Date Modified Today August 06 2009 1 58 PM gt gt gt File Edit View Favorites Tools Help Q Back 5 P Search E Folders Ez 65300 000001 File Folder 7300 100033 File Folder lt AEEA T A 7302 110010 File Folder 7302 110013 File Folder MSM Test Paths 7302 110014 File Folder ES My Documents S My Computer N My Network Places Details 7302 110010 File Folder Rev 1 10 Page 23 of 68 7302 110013 7 Drag or copy and paste the database from the USB Flash drive into the PowerMaster ta Tools Help File Edit vie Favorites OIE Q Back 5 P Search E Folders Fel Address ia E PowerMaster Backup 7302 110013 b Go Name Type Date Modified Y 108 2009 08 06 13 58 00N File Folder 8 6 2009 1 58 PM AR File and Folder Tasks Other Places 3 PowerMaster Backup S My Documents i My Computer WJ My Network Places Details 2009 08 06 13 58 00 File Folder Tr PowerMaster File Edit Help Database Path directory for the correct PowerMaster serial number Viev Favorites Tools Q Back 5 P a Search E Folders Ez Address D U MSM Test Paths PowerMaster Name 5300 000001 7300 100033 7302 110010 File and Folder Tasks ES MSM Test Paths ES My Documents 1 My Computer N My Network Places Details 7302 110010 File Folder Size Type File Folder File Folder File Folder File Folder File Folder 7 31 2
20. 009 2 7 30 2009 2 7 16 2009 3 8 3 2009 2 3 Date Modified Today August 06 2009 1 58 PM 8 In Meter Site Manager 2 click File Open to browse and view the database files P Select Database Folder Start Search from Directory U MSM Test Paths Subdirectory Tree gt Associated Files Data Files Database E Powerkdaster Hl 5300 000001 H 7300 100033 H 7302 110010 J 7302 110013 2009 07 16 15 38 08 58 2009 08 06 13 58 00 H 7302 110014 Cancel Open Rev 1 10 Page 24 of 68 5 Download Data from the PC to the PowerMaster Creating a Route When the user desires to create a list of sites to test in the field the database must be downloaded into the PowerMaster This process will allow the user to select sites that are currently in the Master Database via check boxes for download This process will also synchronize the Master Database to the PowerMaster which may include newly created metering components CT PT Meter AMR test setups Phantom Load Setups new sites and even historical test data 1 Open Meter Site Manager by double clicking Meter Site Manager 2 icon on the desktop 2 When at the Main Menu on the PowerMaster select Utilities then Connect to Meter Site Manager for Main Applications 1 0 0 15 and below simply remain at the Main Menu Main Menu Selected Site NONE P Configurati ion Selected Site TEST WCM instrument Transformer Testing
21. 8 Windows CE BSP 2 2 1 0 1003120r higher PC Hardware Memory Min 64 MB of RAM Hard Disk Min 210 MB of available hard disk space Display Super VGA 1024 x 768 or higher resolution monitor with 256 colors Peripherals Mouse or compatible pointing device amp keyboard PC Software Operating System Windows XP or Windows 7 Microsoft ActiveSync 4 5 for Windows XP users Microsoft Mobile Device Center 6 1 for Windows 7 users Microsoft SQL Server Compact 3 5 Microsoft NET Framework 3 5 SP1 Rev 1 10 Page 9 of 68 2 Installation 2 1 Windows XP Microsoft ActiveSync 4 5 Windows XP SP2 only Before installing Meter Site Manager Microsoft ActiveSync 4 5 must be installed first Open the WinXP folder Name fElMetersiteManager Installer msi setup msi gt E SSE Runtine ENU x86 mei 1 Double click the setup msi file Click Run to start installation 2 Click Next 3 Accept the terms and agreement Click Next 4 Enter your name and organization optional Click Next 5 Click Next 6 Click Install 7 Click Finish to complete installation Microsoft SQL Server Compact 3 5 After installation of Microsoft ActiveSync 4 5 Microsoft SQL Server Compact 3 5 must be installed Open the WinXP folder Mame E MetersiteManagerInstaller msi A setup msi P 55CERuntime ENU x86 msi Double click the SSCERuntime ENU x86 msi file Click Ne
22. A ces 47 12 rele EE o E 49 O S A EE EE EE aie PRN N EE 51 14 Appendix 1 Database Columns V1 12 oocccccccccccnccccncccnncocnccononcnnnnnnos 53 Rev 1 10 Page 3 of 68 Contacting Powermetrix Technical Support For technical support please contact the factory at 865 218 5838 877 966 5851 toll free and ask for Powermetrix Technical Support You may alternatively email Powermetrix at helo powermetrix com The support staff will answer questions about the operation and care of your equipment assist you in troubleshooting a problem and help you overcome common application difficulties whenever possible If it becomes necessary for your equipment to be returned to us for any reason you will be issued an RMA number during the technical support contact Updates Updates will be available at the PowerMaster Support website at no charge Contact technical support for a username and password Please note that all previous versions of Meter Site Manager 2 must be uninstalled before updating Refer to Section 2 4 for further instructions Feedback Powermetrix depends on information from our customers to continue the attributes of quality dependability and simplicity associated with our products We invite you to contact our Technical Support office Rev 1 10 Page 4 of 68 Release Notes Meter Site Manager 2 Release Date 6 30 11 What s New 1 E a EE 11 12 13 Fixed a bug in Summary of Last Test
23. Frm Tyl Kt Acc Meter None SN Comm ID Meter No d ER IP Addr 3 Inthe bottom tray click Test Editor P Integrated Site Test Setup Test Setup CL CT B amp R Meter Tests Test Mode Test Time 9 Seconds Test Reys 2 Phantom Load Setup Transformer Testing Mode Max Burden Mode Edit Setup New Setup Delete Setup Rev 1 10 Page 40 of 68 4 Inthe Integrated Site Test Setup create a new test setup P Integrated Site Test Setup Test Setup CL CT B amp R Meter Tests Customer Load Test Mode Wh v O Do Demand Test Test Time O Seconds Test Revs 2 O Phantom Load Phantom Load Setup Transformer Testing Mode Burden Ratio v Max Burden 0 5 Mode CT Test O PT Test Cancel Edit Setup click Edit Setup to make changes or New Setup to P Integrated Site Test Setup Test Setup JACM AENEASE Meter Tests Customer Load Test Mode Wh v L Do Demand Test Test Time 0 Seconds Test Revs 2 O Phantom Load Phantom Load Setup Transformer Testing Mode Burden Ratio v Mode CT Test O PT Test Max Burden 0 5 Cancel New Setup 5 After changes are made click Save to complete The setup will now be available in the Test Setup drop down box in Site Editor 9 3 Edit or Create a Phantom Load Setup The Phantom Load Setups PLS are pre programmed test procedures to test a meter under known condition
24. LN WEN IN O LL OO N Gemser lemme em EEN ANN LN EN N ENE GAN 000 WEN WEI EN AGE NN N E bane E NN LN Li GN WEN JE Harmonic Harmonic Key bigint Ham E N Ham werwe E N LN NN N N 0 Z Z Z Z Z Z Z Z Z Z 1 Z MasterTestRecord bigint _ Lr ILZE NN LN E MasterTestHecod a me a wN MasterTestHecod __ TechNamez E e N Mesteres Comment vara WE cn o mee 2 A E LI Yara E N MasterTestRecord CalibrationDate datetime ILZE NN O N LLE fort Rev 1 10 Page 56 of 68 INN l Z Z Z Marreco pezes fin 7 N NN NG Y metso USE mam e y EN NN A MasterTestRecord UTS22 nvarchar Master TestRecord UTS23 nvarchar DT NN se e e Y NN Y NN s Y MasterTestRecord UTS43 nvarchar MasterTestRecord UTS51 nvarchar r NN NN Y NN NN ON Masetesftacod We ON MasterTestRecord UTS71 nvarchar MasterTestRecord UTS72 nvarchar A in LO nader 2 N Nestes UTS nader N a LO nader N MasterTestRecord nvarchar MasterTestRecord nvarchar 32 a LO nader N an LO E a WEE G el N a WS uam MasterTestRecord UTS113 nvarchar MasterTestRecord UTS121 nvarchar MasterTestRecord UTS122 ON Rev 1 10 Page 57 of 68 lt lt lt de N 32 32 lt lt lt lt de N 32 32 Z Z lt lt N 32 32 Z Z Z Z N Z Z Z Z N 32 32 Z Z Z Z merse WIRE Tel N Masetesftacod jus ON metso WS ON
25. Rev 1 10 POWERMETRIX Meter Site Manager 2 Version 1 4 0 0 Product Manual Revision 1 10 Page 1 of 68 Copyright Notice Copyright by TEC 2011 All rights reserved No part of this document may be reproduced transmitted transcribed stored in a retrieval system or translated into any language in any form by any means without the express written permission of TEC Disclaimer This documentation is provided for information purposes TEC makes no warranty of any kind with regard to this material including but not limited to the implied warranties of merchantability and fitness for a particular purpose TEC shall not be liable for errors omissions or inconsistencies which may be contained herein or for incidental or consequential damages in connection with the furnishing performance or use of the material Information in this document is subject to change without notice and does not represent a commitment on the part of TEC Rev 1 10 Page 2 of 68 Table of Contents Contacting POW ENING UX miss drets Ea ince 4 Release NOTES RE EE 5 1 System RedguirementS iss se Ee EE RE ER Ee RE Ee EE ee Ee ee EE ee EE ee ee ee ee ee ee 9 2 Ela OM EE e REG IE 10 2 1 ale le SP EE EE RR AN id 10 2 2 Windows 7 92 DII ER ER EE Aa 12 2 3 Wiidows 7 O4 DIL ssa piada RS Ee DE E 13 2 4 Updating all Operating Systems ee ee Ee ee EE ee EE ee Ee ee ee EE Ee ee ee EE Ee ee ee EE 15 o Oreating a Masier Database iS EE EE OS
26. VARhr or VAhr the displayed data would default to the saved energy test mode The data now displays the energy mode active during the test Fixed a bug in the Demand Test report The total interval data for Wh h VARh h and VAh h are now averaged Fixed a bug in the Demand Test report When intervals would exceed the first page the data would not display It now displays the information correctly on the second page and up to the third if meter trend data is present Fixed a bug in the Phantom Load Test Sequence Summary report When data would exceed the first page the data would not display It now displays the information correctly on the second page and beyond Increased the visible width in the Customer Load Meter Test Report for Meter and Actual When changing the master database it now automatically refreshes the screen Updates database from 1 10 to 1 11 The following are changes which were included in Release 1 1 0 1 F D a Rev 1 Added ability to import and export a formatted csv or txt file into database table s Added ability to delete test data Added a user interface in Site Editor to enter the new 60 custom fields Added a feature when the application closes the database now compresses automatically saving storage space on both the PC and the analyzer When data is deleted from the database this will greatly reduce database size Added manual feature Tools Compact Master Database to allow optimal compression
27. ait Transfer complete 5 After download is complete press ENTER or SPACE on the PowerMaster to reboot or simply power off by pressing ON if complete You have entered Communications Mode for transferring data with your computer Press ENTER or SPACE when you have finished transferring data Rev 1 10 Page 28 of 68 6 Merging Backup Databases into the Master Database Using Meter Site Manager 2 version 1 05 and below only backup databases were created at the time of upload In versions1 06 and above the user now has the ability to store a single master database for all records After the master database is created each upload from the PowerMaster will automatically be merged into the master database The following describes the two methods on how to merge all of the backup databases into a single master database 6 1 Merging a Single Backup Database 1 Click File Open Backup Database j Meter Site Manager 5 1PMX Databases1200 fie gt window Show Master Database Ctrl M Change Master Database Directory Mew Site Delete Data 2 Browse the default directory located in Preferences To browse elsewhere click Change Expand the directory until a time date stamp appears in bold Click Open to open the backup database P Select Database Folder Start Search from Directory C Documents and S ettingstrullinstMy DocumentstMeterSiteM anager Subdirectory Tree Po
28. al must grant you full administrative rights After the first download is complete your IT professional can reduce your rights back to normal Rev 1 10 Page 51 of 68 If merge a backup database into the Master database more than once will it create duplicate data No During the merge process the application goes through each database entry and looks at data changes If data changes exist it writes to the database Otherwise the process ignores the existing entry and moves to the next one until complete What s the difference between uploading and downloading When you want to send data to the PC from the PowerMaster we consider this to be uploading When you want to send data to the PowerMaster from the PC we consider this to be downloading When creating a route what is the option Include Disabled Support Table Records CT PT etc When a route is created in the PowerMaster the Master Database is also synchronized to the PowerMaster database The metering components that are disabled will also be downloaded as well By default Meter Site Manager 2 only downloads metering components that are enabled to prevent unnecessary memory allocation Refer to Section 8 for further details on Enable Disable What does the function Compact Database do When deleting data the size of the database remains the same Fortunately when Meter Site Manager 2 is closed it automatica
29. and services Streamlined installation experience for client pplicabons s uQ Do TT T NET Frameworl k Documentation Improvements in the area of data platform such as the ADO NET Entity Framework ADO NET Data Services and support for SQL Server 2008 s Windows SDK new features Visual Studio and NET Framework Product Feedback Center Download and install the NET Framework 3 5 SP1 Bootstrapper now Install it now s 5 Previous Versions ET mework 3 5 Service ck 1 Related es NET Frameworl k 3 NET Frameworl k 2 ET Frame k 3 5 Sen ack 1 Ful kage ET Framework 1 Whi New he NET Framework Versi Studio 2008 Servi k 1 and NET m k3 5 k ET Framework 3 5 SP1 Readm ET Framework 3 5 B Site Feedback Micr osoft 2009 Microsol ft Corporation All rights reserved Terms of Use Trademarks Privacy Statement 9 Internet e After downloading close all other applications Double click the dotnetfx35setup exe Accept the terms and agreement Click Install Installation will begin This will take several minutes S LA After installation is complete press Exit to finish Rev 1 10 Page 11 of 68 8 Click Restart Now to reboot the computer 9 After boot up double click the MeterSiteManagerlnstaller msi file hame 5 MeterSiteManagerInstaller msi a setup msi je S5CERuntime ENU x86 msi ah 10 Click Next to continue 11 Select Everyone Click Next 12 Click
30. antom Load Setup Table Export Law T Phantom Load Test Table E PT Table 7 PT Burden Class Table I PT Manufacturer Table IT PT Test Detail Table E PT Test Master Table F Ste Description Table 7 Test Setup Table E Waveform Table lt Cancel __ 5 Click OK to complete Database File Export Complete Database tables from the database have been successfully exported as P tt files to the Ca Usersimullins TEC USA Documents MeterSiteManageriDatabaseTa bleFiles directory 6 After export the file s can be found in the directory that was created Double click the file to open in Notepad txt or Microsoft Excel csv to review Documents library DatabaseTableFiles Name Date modified AMRTable bd 8 26 201 CTTable txt 8 26 201 B 26 201 l MeterTable bd PT Table txt SiteDescriptionTable txt 11 16 2010 1 36 PM Text Documen Rev 1 10 Page 46 of 68 11 2 Import txt or csv files WARNING Verifying all database keys that correspond to multiple tables is critical when importing txt or csv files into the Meter Site Manager 2 database Not doing so will cause database corruption that is beyond repair Powermetrix will not be held responsible for any lost or corrupted data when importing It is highly recommended that a database backup is made before importing any files Generating and formatting an import file 1 Follow Section 11 1 to export a desired
31. ate window to indicate what is taking place Transferring the PowerMasterDatabase sdf file will take several minutes EE Communications Log Attempting to Connect to Analyzer Connected to analyzer serial number 5300 000001 Backing up analyzer data to U MSM Test Paths PoverMaster 5300 0000011 2009 07 31 14 58 31 Backup Found 7 files to receive Receiving PowerMasterConfig xml Please Wait Receiving PowerMasterDatabase sdf Please Wait Receiving 2009 07 20 11 27 13 waveform Please Wait Receiving 2009 07 20 13 57 16 harmonic Please Wait Receiving 2009 07 21 09 06 05 waveform Please Wait Receiving 2009 07 21 12 07 30 waveform Please ic Receiving 2009 07 21 12 07 40 harmonic Please Wait Backup complete Once the database has transferred Meter Site Manager 2 will try to open it and automatically merge it into the master database You will see a Site List at the top off the screen and a Tree View of the data in the database in a panel at the left jZ Meter Site Manager S PMX Databases 2009 07 24 15 06 54 MET 1 File Communication Tools Window Help ee X Last merge 10 7 2009 to database at SAPMX Databases S T E LI ST Backup Database Site List TestDate Customer PrimaryVoltage BillingMultiplier Enabled LastModified NextTest ServiceTypeFileMame Kt MeterNetworkAddress Instructions 1PH aw 35 2PC 7 10 2009 3 32 PM D 0 7714 2009 1 09PM 1 9 2010 6 23AM S002F034 SRV 1PH 3w 35 7 10 2009 3 21
32. base see Merging Backup Databases into the Master Database P Meter Site Manager U Code TestingiMsmDatabase sdf OB aJ File Edit Communication Tools Window Help x Master Database Site List Rev 1 10 Page 18 of 68 4 Upload Data From the PowerMaster to the PC 1 Open Meter Site Manager by double clicking Meter Site Manager 2 icon on the desktop 2 When at the Main Menu on the PowerMaster select Utilities then Connect to Meter Site Manager for Main Applications 1 0 0 15 and below simply remain at the Main Menu P Main Menu 1 Select Site BJInstrument Transformer Testing O Utilities Recall Data Configuration Selected Site TEST WC Manual Load Box Control Calibration Verification save Database Snapshot Backup B install a System Upgrade set System Time dit Test Session Notes user Preferences You have entered Communications Mode for transferring data with your computer Press ENTER or SPACE when you have finished transferring data 3 Use the USB cable to connect to the PC USB To Host 4 Wait for the sync icon in the system tray to turn green You may see a window asking If you want for set up a parinership Say NO amp fae 4 2 39 PM 5 In Meter Site Manager 2 click on Communication then on Load Data from PowerMaster Analyzer Rev 1 10 Page 19 of 68 6 Messages will appear in a separ
33. d KERER Lag Delivered Power Factor FulLoad Power Factor V Ful Load Power Factor Full Load Power Factor 7 Full Load Power Factor Lag w Delivered CS CS FR EG EG IS AE AE MERE T ole AO am sl tw mm E Lag w Delivered Lag Delivered o Lag Y Delivered v Ls Lag Delivered REEREEEREEEE T T gt v w v vi Lag w Delivered e v w v Lag Delivered Delivered vw Lag w Delivered vw v v Lag w Delivered vi Lag KIRE 2 2 gt 2 2 2 2 2 A A 1 1 1 1 1 1 v v v v EI EAE d Lag vi Delivered Edit PLS New PLS lt 7 After changes are made click Save Setup to complete The setup will now be available in the Phantom Load Setup drop down box in Site Editor Rev 1 10 Page 42 of 68 10 Import Export an ODBC Database The database for Meter Site Manager 2 MsmDatabase sdf is a compact SQL Server database that is designed for mobile devices This type of database does not have open connectivity and does not allow the use of typical tools accessible to most database administrators To combat this Meter Site Manager 2 allows the user to import export to an ODBC database via Microsoft Access or SQL Server 2005 This can help the database administer export pertinent information into a corporate database wit
34. e Current I Phasel Vi Phasel Pr __V THD __1 THD Vab 117 516 _ 0000 ta 259778 30228 30228 osea 187 053 Web 118 818 299498 le 2 53356 272069 _ 332 572 0 888 Dm 0000 ooo m com co co com om om vss mese iss 256 0 876 Power Data Vector Diagram 77 1N1G Wah la 139 204 ARA ARA lt A 1 Inthe tree view at the left expand the list by clicking on the 2 Generate the report by double clicking on the name of the test 3 Click the Print icon on the report header to print Report Header Summary ME back Zoom In Out In Out re Page Up Down Up Down Multiple page views Print report Tab s Rev 1 10 Page 32 of 68 Summary Reports 1 Summary of Last Test This report includes the customer load meter test CT test at 0 burden and the phantom load meter test This report will display the LAST test acquired according to the time date stamp 771720039 1251 PM E o LT Test 4 1 2009 1 06 PM Customer Load Test 7 1 2009 Phantom Load Test Sequence 2 Phantom Load Test Sequence Summary This report gives the user a summary of all phantom load meter tests that were performed in the test sequence up to 16 tests 7 6 2009 2 45 PM Phantom Load Test Sequence _ a FL 7 6 2009 2 42 PM PF 7 6 2009 2 43 PM a LL 7 6 2009 2 45 PM 3 Site Report This report gives the user information about
35. eldNames UtsField93Name nvarchar N UtsFieldNames UtsField101Name nvarchar UtsFieldNames UtsField102Name Y UtsFieldNames UtsField103Name nvarchar 32 Y UtsFieldNames UtsField111Name pnvarchar 321 Y 32 32 lt lt lt UtsFieldNames UtsField112Name UtsFieldNames UtsField113Name UtsFieldNames UtsField121Name nvarchar 32 UtsFieldNames UtsField122Name nvarchar 32 32 lt UtsFieldNames UtsField123Name Y UtsFieldNames UtsField131Name pnvarchar Ba VY UtsFieldNames UtsField132Name nvarchar Ba VY lt lt UtsFieldNames UtsField133Name UtsFieldNames UtsField141Name UtsFieldNames UtsField142Name nvarchar 32 UtsFieldNames UtsField143Name nvarchar 3 2 Usean useen ar O e y Usean useen ar e UsFeNames usoen r e UtsFieldNames UtsField163Name nvarchar lt lt lt lt UtsFieldNames UtsField171Name nvarchar UtsFieldNames UtsField172Name Y UtsFieldNames UtsField173Name nvarchar 82 Y UtsFieldNames UtsField181Name nvarchar 321 VY Rev 1 10 Page 67 of 68 N 32 32 lt lt lt UtsFieldNames UtsField182Name UtsFieldNames UtsField183Name UtsFieldNames UtsField191Name UtsFieldNames UtsField192Name UtsFieldNames UtsField193Name UtsFieldNames UtsField201Name z UtsFieldNames UtsField202Name nvarchar wasem L um N Nao eo o N veto Ee ONNIE LN N wasem Dime mem N Rev 1 10 Page 68 of 68
36. etwork directory If needed click Make New Folder to create a separate folder for the network directory Click Ok when complete Browse For Folder HEI Select Master Database Directory e My Computer E J 31 2 Floppy tA s Local Disk C EH lt CD RW Drive D Se prxdoc on Engineering Network Attached Stc E Powermetri on Engineering Network Attache F ACT Batch Files F ActMaster EN Administration ks ES Make Mew Folder Rev 1 10 Page 17 of 68 4 After selection of the directory press Ok Select Master Database Directory Master Database Directory U Code Testing we Select the directory that wil contain the Master database The directory must not be a subdirectory of U AMSM Test Paths IF the directory already contains a master database file we will attempt to use it Otherwise you will be asked if vou want to create a new empty Master database 5 Click Create to complete the process FE Find or Create Master Database We could not open a Master Database in U Code Testing How would vou like to proceed 9 Create an empty Master database in the directory mentioned above O Browse to a different Master database directory Continue without using any Master database After the master database is created Meter Site Manager will display the blank database If the user has any backup databases that need to be merged into the master data
37. gan datetime AL AL LN N AL LN N _ FL AL LL NN EN __ FL AL AL feet LL LL AN N int Pranoto Name aber e Proton oeme uno N PhantomLoadSetup LastModified datetime Ll Z Z Z Z Z MeterTestMaster ExternalPulseCount li Z Z Z PhantomLoadSetup PhantomLoadSetup_Key bigint PrantontoadTos Press Nare E N Prorioadtos taba mam ER Praonioadtos Voge Neler RR PhantomLoadTest CurrentPF real Z Z Z PhantomLoadTest LeadLag nvarchar 4 Panama uses mata PrantontoadTes Time qui N Prariotoadres ron er 3 N PhantomLoadTest PhantomLoadSetup Key bigint PhantomLoadTest EnergyDeliveredOrReceived nvarchar 3 OM PhantomLoadTest ComplexTestFile PT Key EN NEE EEN PA oa Rev 1 10 Page 60 of 68 Z Z Z Z lt Z Z TO q L ON pr K mata o v Pas O ee y n PT PT PT a A Z NameplateRatio real Bedos _ O E PT we ON e E tar O LO vacher el N E EG A PTManufacturer City nvarchar 5 A vaca ek Y tenses Gainey tar Br AC O EA rende Were G seer Y PTTestDetail bigint Preset aar E Proe Pr le O A Pres e rat GL O PT TestMaster Master TestRecord Key bigint 1 q l WT PT TestMaster DateTime datetime Preses mae quim N Preses PinayProbesy manta BW Press Prasa o jon N super E quanta el N SiteDescription SiteRevNum smallint Z Z Z Z Z 1 SiteDescription SiteDescription Key bigint SiteDescription PercentReg
38. h minimal customization and programming Any master MsmDatabase sdf or backup PowerMasterDatabase sdf database can be exported or imported into Import Export Odbc Database Select ODBC Database File Directory Users mulling TEC US A Documents MeterSiteManager Database Odbc Select Type Select Database Type Import a Microsoft Access o Export y SQL Server 2005 10 1 Export to Microsoft Access 1 Open the desired sdf database in Meter Site Manager 2 By default the Master database is open Any backup databases can be opened via File Open Backup Database Click Tools Import Export an ODBC database Select the database output directory in the drop down box or click Change to browse to another directory select Microsoft Access as the database type Click OK lf an ODBC database does not exist select Create an ODBC database If an ODBC database was created previously and you wish the data to be merged click Browse to a different ODBC database directory and locate the existing database P Find or Create ODBC Database We could not open an ODBC Database in C Users mullins _TEC USA Documents MeterSite Manager Database Odbc How would you like to proceed Create an ODBC database in the directory mentioned above and fill it with data from the Master database Browse to a different ODBC database directory C Cancel 7 After export
39. he PowerMaster Since data cannot be deleted in the PowerMaster Meter Site Manager 2 gives the user the ability to delete all existing sites and test data in the PowerMaster database This process simply replaces the existing database with a blank database This process will also synchronize the Master Database to the PowerMaster which may include newly created metering components CT PT Meter AMR test setups and Phantom Load Setups 1 Follow steps 1 4 in Section 5 Click Communication Erase all Sites and Tests in PowerMaster Analyzer Ed Meter Site Manager M Code Testing MsmDatabase sadf Edit Communication Tools Window Help Load Data From PowerMaster Analyzer Master Datab Ek E Create Route and Send To PomerMaster Analyzer Mark SitelD lt Erase all Sites and Tests in PowerMaster Analyzer Fern Click Yes to confirm Wipe Out PowerMaster Database 2 Are vou sure vou want to replace the PomerMaster Analyzer s database with a new one which does not contain any sites 4 Messages will appear in a separate window to indicate what is taking place Transferring the PowerMasterDatabase sdf file will take several minutes r EE Communications Log Attempting to Connect to Analyzer serial number 5300 000001 r s Old Database Erasing PowerMasterDatabase sdf erring Database to the PowerMaster Found 1 files to send to the analyzer Sending PowerMasterDatabase sdf Please W
40. ist Master Database Site List Mark oitelD C 3PH 4w WYE ZCOIL lw DELTA 95 910226 84 144124 C VAWIBEY po Locator Rev 1 10 Page 34 of 68 2 Inthe tree view click the desired date Tests a 3W DELTA TEC Revised 6 29 2010 2 12 PM B Revised 7 7 2009 9 00 AM H 7 8 2009 9 42 AM CT Test 7 7 2009 9 15 AM CT Test 7 7 2009 9 10 AM CT Test 7 7 2009 9 05 AM H Demand Test 7 7 2009 12 00 PM H Customer Load Test 7 7 2009 10 11 AM H Customer Load Test 7 7 2009 9 29 AM 716 2009 4 54 PM 7 6 2009 2 45 PM 7 6 2009 2 30 PM 716 2009 2 18 PM Fi L E E 3 Right click Delete Tests a 3W DELTA TEC Revised 6 29 2010 2 12 PM Revised 7 7 2009 9 00 AM 77872009 9 42 AM CT Test 7 4_Peete y CT Test 7 7 2009 9 10 AM bo CT Test 7 7 2009 9 05 AM Demand Test 7 7 2009 12 00 PM amp Customer Load Test 7 7 2009 10 11 AM H Customer Load Test 7 7 2009 9 29 AM H 716 2009 4 54 PM 7 6 2009 2 45 PM 7 6 2009 2 30 PM 7 6 2009 2 18 PM 4 Confirm by clicking Yes Delete Data Deleting a Single Test Note that some data are dependent on others For example the Basic Test Data is dependent on the Customer Load Test When attempting to delete the Basic Test Data first the user will be warned that the Customer Load Test must be deleted first 1 Select the site in the database list Master Database Site List
41. istration real fo Rev 1 10 Page 61 of 68 lt lt lt lt Seen NL EE o maer __ Y E eta 80 9 Seen mae juntar sr sege Y Seen We maer A _ Y SiteDescription Zip nvarchar 10 Y O n ns T rather A _ Y Sesta E O A Eie EE AL N N Ed E O Y CT A SN nvarchar 16 MS O manter Br Seoewer GER gt raha AL SA Sewe Re PR Y EE AS O Ed EE POR L a Y SiteDescription PT A SN SiteDescription PT B SN nvarchar 1 J y Soson pres e e Y EN A Y Soson ee mam A Y ENE Rey quim A Soson am quam ef Fees gt gt gt SiteDescription Enabled lt lt lt WT lt lt JIMI SiteDescription LastModified datetime EN ea NN N y Soson oam N y Soson Nes ee Y Soson E veer 2 Y SiteDescription CustomField1 nvarchar 30 0 lt lt lt lt L lt SiteDescription CustomField2 nvarchar 3 at EL NN O fare SieDecpion Seer maia Er EK O O Ed Rev 1 10 Page 62 of 68 lt lt lt lt EN NN ENE AN Y EN INN maia E N Soon Telephone maear 80 N EN er SiteDescription CustomField5 nvarchar lt Zi Z CO O SiteDescription CustomField6 nvarchar DT Soson Geweer maia A Soson owore mata E Y EN mata IN Y SiteDescription CustomField12 nvarchar 30 30 lt lt lt lt CO O SiteDescription CustomField13 nvarchar EN ear EN NEL AN NN A Soson owr arer IN Y SiteDescription CustomField19 nvarchar 30 30 lt lt lt
42. lly compresses the database to accommodate any data deletion If the user wants to do an optimal compression the user can manually compress the database by clicking Tools Compact Database to save another 5 approximately in size How do I synchronize my changes from my Master database to the PowerMaster How do know what version of software I m using Click Help About Rev 1 10 Page 52 of 68 14 Appendix 1 Database Columns v1 12 va amine Tape natn nate Type Length wo p T E LN A N m em Y LINNE NN LN WEN IN N LIN NN LN ae EEN LIN NN LN WEN y LINNE NN ad _ 2 AMRManufacturer Zip nvarchar 10 R Y LINNE NN vacar Y LINNE NN LN A LINNE NN EN EN EE Manasse wese E Y BasicTestData BasicTestData_Key bigint HL lt lt N lt lt lt lt lt BasicTestData MasterTestRecord_Key bigint EA NN EE Key at N BascTesDaa RecobaeTino E N ESC Rea et O aseTesibaa VOmgranA _ valer Y aseTestOaa Voss veer af EA ONNIE A var a Beset oee O a BascTesDaa oe mam Y Esteio WA qui dr BasicTestData VRMS C real BasicTestData VRMS N real Rev 1 10 Page 53 of 68 MIT lt lt esta RB Y ESC Sa ESC US _ _ ESC Ui A at BasicTestData VPhase C real lt lt lt Basic TestData IPhase A real Berea Phase Ba aseestbaa Phase Y esta PER ee ESC E O Y BasicTestData Watis A real lt lt lt lt BasicTestData Watts B real Berea
43. metso se mam ON MasterTestRecord UTS151 nvarchar MasterTestRecord UTS152 nvarchar metso UNS ON Mestresa WISE mam ON Masetestacod WISE mam ON MasterTestRecord UTS172 nvarchar MasterTestRecord UTS173 nvarchar Ds Masetesftacod WISE ON Masetesfacod WISE ON Masetesftacod UTS ON MasterTestRecord UTS193 nvarchar MasterTestRecord UTS201 nvarchar O E a ee ei ee itr aar N Meter Model nvarchar 16 Cs sal N Z Z Z N 32 32 Z Z Z Z N 32 32 E A IZ Z N 32 32 Z Z Z Zi Z Z Meter CatalogNumber nvarchar w fpe pm v L Z Meter MeterForm nvarchar Meter Voltage real Meter Frequency real Z Rev 1 10 Page 58 of 68 Z Z w E E IE Wee Y w IN Y eer 8 Y E m lt lt lt MeterAccuracyClass AccuracyClass real MeterCurrentClass CurrentClass smallint 2 E arate E asin Meiran er meer see VAN Di NN NN _ N VAN tr MeterManufacturer City nvarchar 5 Veeranna O O _ Y Veeranna foar nader JN Y Measure Laoag tine eene wase E y MeterTestintervalDetail bigint Pod ease ee fim o N iene Wee were A Do esse ea N Do E N Do E N eres JU ui 5 mesmas UM ui 5 LU E N Rev 1 10 Page 59 of 68 TH q l UL WI 1 Z A preneo p 7 E l mam ie N Meeres wese e N NN AE e N MeterTestMaster MeterTestMaster_Key bigint Z Z Z MeterTestMaster TimeTestBe
44. n ready click Replace Analyzer s Data with this New Route Create Route Sites in Route illingMultiplier LastModified NextT est 8 4 2009 3 01 PM 2 3 2010 7414 2009 1 09 PM 1 9 2010 7410 2009 3 12 PM 1 9 2010 TestDate Primaryoltage 0 1PH 3w 35 2PC 7 10 2009 3 32 PM 0 1PH 3w 35 7 10 2009 3 21 PM 0 3w DELTA 7 8 2009 9 41 AM 0 4w DELTA A HI SOOZFOS 7714 2009 2 33 PM 0 4w DELTA SOTOFOS 7 13 2009 4 17 PM 0 4w Y SOO8FO5 7 10 2009 4 53 PM 0 ololojo o lololm 7 10 2009 4 42 PM 1 3 2010 C Include Disabled Support Table Records CT PT etc Limit Old Test Data To 3 Months v Replace Analyzer s Data with this New Route Rev 1 10 Page 26 of 68 8 Messages will appear in a separate window to indicate what is taking place Transferring the PowerMasterDatabase sdf file will take several minutes EE Communications Log Attempting to Connect to Analyzer Connected to analyzer serial number 5300 000001 Erasing PowerMaster s Old Database Found 1 files to erase Erasing PowerMasterDatabase sdf Sending PoverMasterDatabase sdf Please Wait Transfer complete 9 After download is complete press ENTER or SPACE on the PowerMaster to reboot or simply power off by pressing ON if complete You have entered Communications Mode for transferring data with your computer Press ENTER or SPACE when you have finished transferring data Rev 1 10 Page 27 of 68 5 1 Erase Data from t
45. o r el UserrieldNames uero ar 2 y UserrieldNames uero macia 2 y UserFieldNames UserFieldNames UserFieldNames ereenn reame oree mar e EEN is NN N EEN ii NN NN 2 UserFieldNames UserFieldNames UserFieldNames erenn U a Varas marta SE EEN UseretsaNare N EEN ii NN Ll E UserFieldNames UserFieldNames UserFieldNames Fi NN eases Varas marta e EEN is NN a Usames Username mamar a UtsFieldNames UtsFieldNames UtsFieldNames Usames stare O anes ree marr UFen ueram mar UsFeNames Uere mar UtsFieldNames UtsFieldNames UtsFieldNames UtsFieldNames UtsField51Name rash UtsFieldNames UtsField52Name Rev 1 10 UserField41 Name UserField42Name UserField43Name UserField48Name UserField49Name UserField50Name UserField56Name UserField5S7Name UserField58Name UtsField13Name UtsField21Name UtsField22Name UtsField41Name UtsField42Name UtsField43Name lt lt lt lt nvarchar N nvarchar nvarchar nvarchar N nvarchar nvarchar nvarchar N nvarchar nvarchar nvarchar N nvarchar nvarchar nvarchar N nvarchar nvarchar Page 66 of 68 lt UtsFieldNames UtsField53Name nvarchar 82 Y UtsFieldNames UtsField61Name nvarchar Sa Y UtsFieldNames UtsField62Name nvarchar 32 0 lt lt UtsFieldNames UtsField72Name nvarchar 32 UtsFieldNames UtsField73Name nvarchar 32 UtsFi
46. of the database after data is deleted Added the ability to multi disable enable components in the database table editors via Ctrl right click 10 Page 6 of 68 10 11 12 13 14 15 16 17 Fixed a bug when viewing the harmonics report for service types S003F02 and SO09F06 Fixed a bug for Test Date The bug caused the test date to disappear when a revision was made Fixed a bug in the Integrated Site Test editor The bug would not allow the user to select other demand intervals Fixed a bug in the Meter Editor The bug saved 5 minute intervals by default Fixed a bug when viewing the Meter Trend report for service type S009F06 Fixed the resolution for Pulses Expected on meter test reports Increased the visible field width of Primary Voltage in the Site Editor Made 60Hz the default when creating editing a meter in Meter Editor Added 347V entry when creating editing a meter in Meter Editor Changed copyright date to 2010 FUNCTION CHANGE The user will now be required to double click the test data to run reports as opposed to single click The following are changes which were included in Release 1 0 0 1 1 Upgraded the database to support the new database for PowerMaster version software 1 0 0 23 The following are changes which were included in Release 0 0 7 0 1 Added database synchronization feature The user can now download a route into the PowerMaster using sites in
47. ols Preferences How do open a database When you open Meter Site Manager click File Click Open Backup Database or Open Recent Backup Database How do view a report select a site in the site database in the top window In the tree view to the left double click on the test results underneath the time date stamp The report is automatically generated this may take several seconds How do print a report After the report is generated from above click on the Print icon in the report header Can print to PDF Yes if you have a pdf creator installed There are many free pdf creators found on the web Powermetrix recommends PDF Creater can t communicate with the PowerMaster What s wrong 1 Verify the PowerMaster is powered on 2 Verify the PowerMaster is in Connect Mode Utilities Connect to Meter Site Manager for Main Application V1 0 0 16 or higher 3 Disconnect the USB cable from the PowerMaster and re connect This will re establish communications between the PowerMaster and ActiveSync 4 Verify no other devices are connected and using ActiveSync at this time How do view the harmonic details The details are located on another tab In the report header click the tab Harmonic Details don t have full administrative rights on my computer Can still use this software Yes Install and run the application as normal Before your first download your IT profession
48. on under Section 2 for further instructions Rev 1 10 Page 15 of 68 3 Creating a Master Database At bootup the user is prompted to create a master database to store all data uploaded from the PowerMaster The user has the option to store the master database on a hard drive or a network drive It is recommended that the user creates ONE master database on the hard drive OR network drive not both The user can always change the master database directory path at any time File Change Master Database Directory Below are the steps involved in creating the master database Storing the Master Database on a Hard Drive C 1 At the user prompt select Create an empty Master database in the directory mentioned above to create the master database on the user s hard drive Click Create ES Find or Create Master Database Wie could not open a Master Database in C Documents and Settings mullinst My DocumentsiMeterSiteManagerDatabase How would you like to proceed TA Create an empty Master database in the directory mentioned above Browse to a different Master database directory Continue without using any Master database 2 After the master database is created the main screen in Meter Site Manager will display noting the blank database If the user has any backup databases that need to be merged into the master database see Merging Backup Databases Into the Master Database ta Meter Si
49. onent It is recommended to disable components that the user does not use To access the database tables click Edit fa Meter Site Manager M Code Tesi Fie Edt communication Took 1 Edit Site 2 AMP Table 3 CT Table 4 PT Table 5 Meter Table Viewing the Table The user can scroll through the table to view all the items in the database If an item is grayed out for New Edit Delete and Disable the item is currently being used in a site The user can also click on the column header ex Model and sort the entire table If the user wants to view all enabled and disabled items simply click Show All at the top menu FE CT Editor Showing Enabled CT Show all New Edit Delete Disable Enabled Manufacturer Model 7862478622 B CBT 7882478607 7882478610 7882478613 7882478616 7882478619 7882478623 7882478605 7882478608 7882478611 7882478614 7882478617 7882478620 7882478624 7882478606 7882478609 7882478612 7882478615 7882478618 7882478621 7882487608 7882487609 7882487610 7882477601 798247 7G04 Ba a ada data A ao a aa a DD UT NO INDO DO UTI IN EE OT NO NO NO NU N MEE RR NN E TH eua aa 7882A77G07 7882477G10 7882477613 7882477616 7882477619 7882477602 7882477605 Ba a ata EL EE AE EE EE EE EE EE EE SE EE AE EE EE EE EE EE EE PPA New To create a new item in the database click New at the top menu Enter selections as desired and press Save to complete
50. ory Changing this directory will affect all future downloads Number of Database Backups to Keep for Each Analyzer 10 v To prevent filling up your disk with old database backups we will only keep the latest few transfers for each analyzer As you download new databases from your analyzers old backups will be erased Merged data will still remain in the Master database Lowering this limit may cause data to be erased the next time you transfer from each analyzer Accessed by clicking Tools Preferences Database Backup Directory This directory is where the PowerMaster will download all acquired data to be stored To change the directory path click Change Browse to the desired directory path including network paths and click OK to accept Click OK once more at the bottom of the Preferences screen to save the directory path The new directory path is applied to the next download from the PowerMaster Number of Database Backups to Keep for Each Analyzer Meter Site Manager 2 will create a backup of the PowerMaster database each time it is uploaded To prevent from unnecessary disk space to be taken up the user has the option of selecting how many database backups they desire to store The user can select from 10 default 5 3 or 1 When the user exceeds the selected database backups the following dialog will display Delete Old Backup Data Sele Warning Preparing to Delete Old Backup Datal Preference setting
51. s These setups are also used in Integrated Site Test for the PowerMaster Please note that ANSI 5 0 AMP FL LL PF and ANSI 2 5 AMP FL LL PF setups cannot be edited or deleted 1 Follow steps 1 4 in Section 8 2 Edit or Create a Test Setup 2 In Integrated Site Test Setup select Phantom Load Setup Phantom Load must be checked P Integrated Site Test Setup Test Setup CL CT B amp R Meter Tests Customer Load Test Mode Wh v O Do Demand Test Test Time O Seconds Phantom Load Test Reys 2 Phantom Load Setup sende API MA E mu E t Transformer Testing CT Test Mode Burden Ratio E Max Burden 0 5 Mode O PT Test Cancel Rev 1 10 Page 41 of 68 6 Click Edit PLS to make changes or New PLS to create a new test setup Phantom Load Setup EE Phantom Load Setup Setup Name CAL CHECK 120V ALL PHASES Setup Name Test Phase Label Mode Voltage Curent PF Lead Lag Flow Pulses Time Sec Rotation Ham Test Phase Label Mode Voltage Curent PF Lead Lag Flow Pulses Time Sec Rotation Harm v Full Load Wh 20 100 Lag w Delivered lo Wh v Power Factor wh EEES Lag w Delivered 45 v Full Load f Power Factor 7 FulLoad Power Factor v Full Load EEES slae Lag Delivered Tefejelejefoejo Wh Wh Wh Wh Wh Wh Wh Wh Wh Wh Wh Wh Lag w Delivere
52. s indicate to keep at most 1 backupls for each analyzer Because of this we will delete 4 old backups How do vou want to proceed Keep the Old Backups for Now Delete the Old Backups C Always delete automatically Do nat show this warming again Rev 1 10 Page 49 of 68 The user has the option to keep the backups until prompted at the next upload Keep the Old Backups for Now or to delete the backups immediately Delete the Old Backups Before a choice is made the user also has the option to select to automatically delete the backups according to the Preferences Always delete automatically Do not show this warning again Customizations Preferences Your Company Logo Graphic SASALES MATERIALILogoiMSMLogo2 jpg Meter lt Manager Accessed by clicking Tools Preferences Customizations Your Company Logo Graphic Meter Site Manager 2 offers a feature that allows the user to add a company logo to all reports To select a company logo click Change Browse to the desired image bmp or jpg and click OPEN to accept A preview of the image will display Click OK at the bottom of the Preferences screen to save the image Close Meter Site Manager 2 and reopen to make the changes effective Rev 1 10 Page 50 of 68 13 FAQ s Where are the backup databases located The default directory is C Documents and Settings My Documents MeterSiteManager This path can be changed by using To
53. table csv file recommended to review the formatting structure Once the formatting structure is reviewed open Microsoft Excel In the first row the user may enter headers for each column of data Otherwise the first row is always ignored when importing Model CatalogNumber AccuracyClass Bi KOR 11 20800322 0 3 KOR 11 20600330 0 3 In the following rows enter all necessary information Review Appendix 1 for column field characteristics data type max length nullable etc Once all information is entered click File Save As Enter the filename EXACTLY the same as the formatted table name in step 1 ex CTTABLE csv Save the file as a CSV Comma delimited csv extension Click Save Importing a formatted file 1 Open the desired sdf database in Meter Site Manager 2 By default the Master database is open Any backup databases can be opened via File Open Backup Database Click Tools Import Export Database Table Files Select the formatted file s directory in the drop down box or click Change to browse to another directory Select Import Select the desired extension txt or csv Then select the desired table s to be imported If all tables are to be imported click Select All Click OK to continue Import Export Databse Table File s Import Export Database Table File s Directory C Users mullins TEC USA Documents MeterSiteManager DatabaseTableFiles X Change
54. table see Section 8 New Click New to create a new component After the additions are made click Save to complete Close the window The user can now select the new component in the Site Editor s drop down box Deleting a Site Deleting a site can be done when there is no test data associated with it If there is any test data the user cannot delete the site from the database Create a New Site To create a new site click File New Site After the additions are made click Save to complete Rev 1 10 Page 39 of 68 9 2 Edit or Create a Test Setup Test Setups are used in Integrated Site Test for the PowerMaster They are step by step procedures that guide the user through the testing process This process eliminates mistakes and simplifies the entire testing procedure Please note that Default 1 and Default 2 setups cannot be edited or deleted 1 Click Edit Edit Site l Meter Site Manager M Code Tes 1 Edit Site 2 AMR Table 3 CT Table 4 PT Table 5 Meter Table 2 Inthe Site Editor select Test Setup Em Site Editor Page 1 Page 2 Page 3 Site ID El Billing Mult o Service 3 Phase 4 Wire DELTA C Hi 2V 3C TR SO10FOB Test Setup EFES ET Pri Volts o Customer Next Test 2010 Jan 12 Account City Address 1 State Pro y Zip Address 2 Country E Phone Substation Locator Custom 1 Custom 2 Meise Mi Md Catf
55. te Manager C Documents and Settings mullins My DocumentsiMeterSiteManagerWatabaselMsmbDatabase s df oJ File Edit Communication Tools Window Hel x N Tests Rev 1 10 Page 16 of 68 Storing the Master Database on a Network Drive 1 At the user prompt select Browse to a different Master database directory to create the master database on the user s network drive Click Browse EE Find or Create Master Database Sele We could not open 4 Master Database in C Documents and SettingsimullinsiMy Documents MeterSiteM anager D atabase How would you like to proceed O Create an empty Master database in the directory mentioned above lt 73 Browse to a different Master database directory Continue without using any Master database Browse 2 Click Change to browse and set the master database directory Please note that the Master Database cannot be stored in a subdirectory of the Database Backup Directory found in Preferences Select Master Database Directory Master Database Directory C Documents and settings mullinssku DocumentsM eters tteM anager Database Select the directory that wil contain the Master database The directory must not be a subdirectory of U AMSM Test Paths IF the directory already contains a master database file we will attempt to use it Otherwise you will be asked if vou want to create a new empty Master database 3 Browse the n
56. te view until a fix in the PowerMaster application is added The registration never displayed The following are changes which were included in Release 0 0 5 0 1 Added support for Guatemala regional Windows settings 2 Added support for reduced administrative rights data must be downloaded first with full administrative rights then the user can be reduced down afterward 3 Added two breaks at the bottom of the communication log to better display Backup complete 4 Improved the communication process so the user does not have to close the application before downloading again after a fail occurs The following are changes which were included in Release 0 0 3 0 Added the ability to display revisions or changes to the database Fixed the parallelogram title from Meter Accuracy to Accuracy Parallelogram Fixed minor issues with display pairs on non Blondel service types F D N Organized the test results to the appropriate Site ID This allows the user to click on the Site ID to display the associated test data In version 0 0 2 0 all the test data for all Site ID s were together The following are changes which were included in Release 0 0 2 0 1 Fixed issue with incorrectly displaying energy data instead of power data when Basic Test Data is saved 2 Added a window to display to the user when a report is generating Rev 1 10 Page 8 of 68 1 System Requirements PowerMaster Main Application 1 0 0 2
57. the site exclusively This includes customer name address account number etc It also includes the information about the associated Meter CTs PTs and AMR Any custom fields entered in the Site Editor will display here as well Tests oa i Revised 2 5 2011 12 04 PM Revised 2 5 2011 11 44 AM Revised 1 27 2011 3 58 PM 1 27 2011 4 08 PM Revised 12 10 2010 10 18 AM QAP 11 NA ALA Rev 1 10 Page 33 of 68 8 Deleting Test Data from the Master or Backup Database Deleting data in the database refers to removing undesirable data collected in the field by the PowerMaster The user can delete a single test a group of tests within a session or the entire site with any associated tests Deleting an Entire Site and Test Data 1 Select the site in the database list Master Database Site List Mark oitelD O 3PH dw WYE ZCOIL 3 E W DELTA 35 910226 5 84 1441 24 AWIBEY Locator C rms 2 Click File Delete Data E Meter eile Manager PMA Databases 700 File El Communication Tools Window l Show Master Database Ctrl a 8 AE v r re Open Backup Database CO E Change Master Database Directory he ckup Database fi Hew Site Delete Data You have selected site SW DELTA TEC 2 bre vou sure vou want to delete this site and all of it s data Deleting a Group of Test Data by Test Session 1 Selectthe site in the database l
58. u press 4 Save Database Snapshot Backup Configuration Selected Site TEST vie Manual Load Box Control E calibration Verification Save Database Snapshot Backup B install a System Upgrade set System Time BEdit Test Session Notes user Preferences 3 Insert a USB Flash drive into one of the PowerMaster s USB Peripherals For further instructions refer to the PowerMaster User Manual Save a Database Backup ry Card or USB flash drive with plenty of free rage device has sufficient free space to store si f the PowerMaster data files it will appear in the list below Select it and press CONTINUE The information will be copied to a subdirectory on the storage device WARNING Do move the memory storage device while the backup procedure is in ess or while the device s write activi light if any flashes Doing so will interrupt the backup and may corrupt data Insert memory storage device and press SCAN when ready Rev 1 10 Page 22 of 68 5 Viewing the directory in the USB Flash drive double click the PowerMaster Backup folder Under the serial number view the time date stamp of the database 7302 110013 I ia x File Edit Vem Favortes Tools Help oa Name gt Type Date Modified File and Folder Tasks 2009 08 06 13 58 00 File Folder 8 6 2009 1 58 PM Other Places E PowerMaster Backup 5 My Documents My Computer WJ My Network Places Details 2009 08 06 13 58
59. usly and you wish the data to be merged click Browse to a different ODBC database directory and locate the existing database ra Find or Create ODBC Database We could not open an ODBC Database in C Users mullins _ TEC USA Documents MeterSite Manager Database Odbc How would you like to proceed Create an ODBC database in the directory mentioned above and fill it with data from the Master database Browse to a different ODBC database directory C Cancel 7 When prompted enter the server name username and password If no username and password is required select Trusted Connection Click OK to continue Enter Sal Server Information Server Name sql navigator User Name cmullins Password pmxuser El Trusted Connection Cancel Rev 1 10 Page 44 of 68 10 4 Import from Microsoft SQL Server 2005 1 Open the desired sdf database in Meter Site Manager 2 By default the Master database is open Any backup databases can be opened via File Open Backup Database Click Tools Import Export an ODBC database Click Import for Select Type and SQL Server 2005 for Select Database Type Select the database directory in the drop down box or click Change to browse to another directory Click OK When prompted enter the server name username and password If no username and password is required select Trusted Connection
60. view data trends Sites that are marked in the database list will lose the denotation when columns are sorted No search function Some service types incorrectly calculate Neutral when averaging Sys PF in the Basic Test Data report Element tests in the Phantom Load test results always display ABC Rev 1 10 Page 5 of 68 The following are changes which were included in Release 1 2 0 0 1 2 N ol 11 12 18 14 15 16 17 Added ability to import export a formatted csv or txt file into database table s Added ability to export the database into an ODBC database Access or a SQL Server 2005 database Added Site Report for details about the site meter CT etc Double click the SitelD under Tests to generate the report Added fields in Meter table to allow specifications for IEC meters Added 57 7V and 220V to Phantom Load Setup for Voltage Added ability to support 64 bit operating systems Added changes to the database to allow 10 characters for the Load Box labels LoadTypeCodes Added a shortcut to the Site Editor under Edit Fixed a bug in PT Editor Nameplate Ratio now allows decimals Fixed a bug in the editors When the user closed the window as opposed to Cancel any changes made were automatically saved regardless if it was intended Fixed a bug in Test Setup When the user made an override in the test setup changing energy test mode Whr
61. werMaster 7302 110003 2009 05 29 12 47 05 2009 05 29 12 20 31 2009 05 27 12 09 02 2009 05 27 11 26 06 2009 05 27 11 00 15 2009 05 27 10 24 05 2009 05 26 08 20 43 2009 05 26 08 15 48 2009 05 21 10 46 34 2009 05 15 14 44 02 Rev 1 10 Page 29 of 68 3 Once opened note the database has not been merged into the master database P Meter Site Manager C Documents and Settings mullins My Docum ot File Communication Tools Window Help is data may not have been merged into the master database Backup Database Site List SitelD TestDate Customer Account umber CT TEST SOS TGP DD 4 To merge this database click Tools Merge Into Master Database PMX Databases 009 07 31 13 43 33 Help Preferences Batch Merge Process Merge Into Master Database Compact Master Database d Meter Site Manager C Documents and Settings F Ble communication Hep Customer 5 27 2009 1 99 Pha 6 To view the master database with the reflected changes click File Show Master Database nager S PMX Databases 700 Communication Teels Window Recent Backup O ABET Wala 0ase Mew Site Delete Data Rev 1 10 Page 30 of 68 6 2 Merging Multiple Backup Databases with the Batch Merge Process This process will merge all backup databases in the default Database Backup Directory see Preferences This easy to use process is highly recommended if there
62. xt to begin installation Accept the terms and agreement Click Next Click Install Click Finish to complete installation 1 2 3 4 Rev 1 10 Page 10 of 68 Meter Site Manager Application After installation of Microsoft ActiveSync 4 5 and Microsoft SQL Server Compact 3 5 Meter Site Manager can now be installed if setup msi PH sscERuntime ENU x86 msi 1 Double click the MeterSiteManagerinstaller msi file 2 If NET Framework 3 5 is not installed the user is prompted to visit a download site Click Yes If the user has NET Framework 3 5 installed skip to step 10 i Meter Site Manager 2 This setup requires the MET Framework version 3 5 Please install the MET Framework and run this setup again The WET Framework can be obtained from the web Would vou like to da this now 2 Download NET Frai lt http msdn microsoft com en us netframeworkjaa569263 aspx 1911 Pl anal ve Forward Download NET Framework 3 5 SP1 and More on MSDN ic gt 5 em lt Page Tools NET Framework 4 Beta 1 NET Framework 3 5 Service Pack 1 ED Ret VARE G Learn about NET Framework 4 Beta 1 The NET Framework 3 5 Service Pack 1 SP1 delivers Performance increases between 20 45 for WPF based applications without having to change any cod e any code E 3 M Reso WCF improvements that give developers more control over the way they access data
63. yone Click Next Click Next Click Close to complete installation ae 2h gt 2 3 Windows 7 64 bit Microsoft Mobile Device Center 6 1 Before installing Meter Site Manager Microsoft Mobile Device Center 6 1 must be installed first Open the Win7 64bit folder Name eal drvu pdate amdb4 exe jar MeterSiteManagerlnstaller msi 15 SSCERuntime ENU x64 msi 16 SSCERuntime ENU x86 msi 1 Double click the drvupdate amd64 exe file 2 After installation the driver will claim to not install correctly Once the PowerMaster is first connected the driver will then install completely Rev 1 10 Page 13 of 68 Microsoft SQL Server Compact 3 5 After installation of Microsoft Mobile Device Center 6 1 Microsoft SQL Server Compact 3 5 32 bit must be installed Open the Win7_64bit folder Name E drvupdate amdb64 exe i MeterSiteManagerlnstaller msi 16 SSCERuntime ENU x64 msi j SSCERuntime ENU x86 msi Double click the SSCERuntime ENU x86 msi file Click Next to begin installation Accept the terms and agreement Click Next Click Install Click Finish to complete installation gt PIN After installation of Microsoft SQL Server Compact 3 5 32 bit Microsoft SQL Server Compact 3 5 64 bit must be installed Open the Win7 64bit folder Mame Date E drvupdate amdb64 exe i MetersiteManagerinstaller mei f 55CERuntime ENU s64 mei

Download Pdf Manuals

Related Search

Related Contents

Notice CAB035 MY SPACE V4 - Maison-et  Descargar PDF  Feasibility Study for the Manufacturing of a Shock Absorber Using  直接ファイルを開く  nanoo manual jp    MODE D`EMPLOI USER MANUAL  Alcatel-Lucent OmniSwitch Family Network 6600 User's Manual  (LG17010) Instructions  

Copyright © All rights reserved. Failed to retrieve file