User Manual VB
Contents
1. Username mdi RAKA Password Retype Password pss Name Marco Surname Dijk Cell Number 083 394 8627 Office Number 012 440 6064 Postal Address 278 Mears Street Muckleneuk sind 0002 AssignUserRole 2 M Figure 5 System Users 5 Read Only View Users will the lowest clearance level will only be able to view the database without being able to make any changes to current records deleting records or adding new records For the prototype s demonstration purposes it was only necessary to complete some of the read only menus Ze Read Main Menu TEE AB Main Menu ance Read Only View Hydraulic Results Hydraulic Perform View Pipeline View Data Nodes System 78 university or setora Industrial amp Systems Engineering Department B 4 Ted TUNI zm TA ERELOGRLE en n arg Bron Tega Fir Cece 6 Hydraulic Main Menu The Hydraulic Performance Information System allows users the following options e Maintain Pipeline Owners Add change or delete pipeline owners Owners can also be assigned to pipelines e Maintain Pipeline Systems Add change or delete pipeline systems e Maintain Pipeline Sections Add change or delete pipeline sections on a pipeline system e Maintain Pip2. F Type Control Valve Ivi X Co EERE Secondary Loss Y Co 1021564545 Upgrade Date 2008 10 14 2021545455 lil N w Additional Details Leaking Photos Drawings Type Ivi X Co Y Co Z Col b Secondary Loss Figure 17 Pipeline Component History dd 78 versi oF prevor Industrial amp Systems Engineering Department B 13 a Recommendations e he adding of a new pipeline component and viewing of current pipeline component should be in a tab structure but due to limitations of MS Access this was not possible the list box feature becomes inactive e The display of a pipeline component s history should be done automatically without first having to enter it in the textbox This was a design limitation regarding MS Access e t would be desirable to first have a list of pipeline systems and by selecting a system the pipeline sections are then displayed This will avoid a long list of all pipeline sections being displayed when one just want to look at specific sections of a pipeline system and its accompanying components 11 Pump Stations The pump station main menu figure 18 allows the user to add new pump station view current pump stations and assign pump stations to pipeline systems Close Figure 18 Pump Station Main Menu 11 1 New Pump Station The new pump station screen figure 19 makes use of the current date feature and drop down boxes to make it user friendly Attachment
3. amp Systems Engineering Department B 11 VER EE Ee Components main E X Components Menu New Components View Components Close Figure 14 Pipeline Components Main Menu 10 1 New Pipeline Components The new pipeline components screen figure 15 allows the user to enter a new pipeline section component Drop down boxes as well as the current date function date makes the process of entering a new component user friendly Ea New Pipeline Component 2 UEM New Pipeline Component Pipeline Section m Component Type ivl Secondary Loss e 1 X Coordinate o e Photos Y Coordinate I Z Coordinate Fe ed Installation Date Drawings Additional Details Figure 15 New Pipeline Component ai 78 university or setora Industrial amp Systems Engineering Department B 12 we usum n ung gar Turks 10 2 View Pipeline Section Components The pipeline section components screen figure 16 displays the current pipeline sections Selecting a pipeline section from the list displays the components on that section of pipe Entering the component ID in the textbox will display the components history details figure 17 Es Pipeline Components Pipeline Sections Pipeline Components pipeline section ID WM2002 WM2002 Enter Pipeline Component Display Component History New Component Figure 16 View Pipeline Components cs Pipeline Component History ax
4. Section Mergers New Pipeline Sections ORG044 ORG045 SMBOOS New Section SMB005 Merger Date 2008 10 08 Pipeline Sections Merged SMBOO1 SMBOO2 SMBO003 Close Figure 39 Pipeline Section Mergers 18 Reports The reports main menu figure 40 allows the user to select which type of report they would like to display namely Data Node Maintenance Hydraulic Results Pipeline Owners Split Pipeline Sections and Merged Pipeline Sections Es Hydraulic Reports T ees Data Node Split Pipeline Maintenance Sections Hydraulic Results En Pipeline Owners Figure 40 Reports Main Menu ES a un vers r or prerosia Industrial amp Systems Engineering Department B 28 So e s ERD a Leon 18 1 Data Node Maintenance Report The data maintenance report figure 41 displays all the upcoming data nodes that require service The date and description of the service is given It displays on which pipeline section the node lies id Data Node maintenance Report Tm E A MET Mp du ae ModelD Pipeline Section Maintenance Date Maintenance Type Additional Notes 2 SMB002 2010 02 09 Instrument replacement 3 GRTOO3 2009 12 12 Battery replacement 1 GRTOO3 2008 12 12 Battery replacement 1 GRTOO3 2008 10 29 Battery replacement Old Battery used Fa Tu ON ON d RM ad On AE ET MR ad va EE ve ef MOT ELE en cR mn Er E as ee EE al Figure 41 Upcoming Data Node Maintenan
5. 1 Introduction The following user manual explains how the hydraulic performance information system operates Even though this is just a prototype the fundamental functioning is conveyed to the user and limitations and constraints for the different sections are mentioned 2 Database Access The database has been encrypted with a password to protect it from unauthorized personnel entering the system This is the first level of security whereby authorized users will login via a password screen figure 1 The password has been set as hydraulic for the prototype Password Required Enter database password a i ci EREE ee Figure 1 First Level Security The user is then requested to activate the content of the database as Microsoft deactivated this for security purposes figure 2 T Security Warning Certain content in the database has been disabled Options Microsoft Office Security Options 263 Security Alert VBA Macro Access has disabled potentaly harmful content in thes database Tf you trust the contents of fis database and would ikr to enable it for this session only did Enable ths content Warning It is not possible to determine that this content came from a trustworthy source Vou should leave this content disabled unless the content provides critical functionality and you trust its source More informaton Fie Pain C tsWwarsitristudes Year 4 Gemester TWP 420 Database Y C02 7 accdb O Help prot
6. 6 Wallmannsthal1 Wallmannsthal2 Wallmannsthal3 Pipeline Section Status 13001 213004 Enter the Pipeline Section 13001 Figure 12 View Pipeline Sections E 78 uiiversity or eeeroria Industrial amp Systems Engineering Department B 10 vor EE Mura RAT rna acusa Es Pipeline Section History EIER Shape Liner X Coordinate 1021547744 Size m Y Coordinate 2021212212 1212158254 Material Steel Z Coordinate 3031464133 031234421 lt oj 3 Lue oak rm Lm CT E cO Upgrade Date 2008 10 14 Start Point End Point Shape Round Ir Start Point End Point Liner Bitumen Rm X Coordinate N Size m Y Coordinate Material Steel ZCoordinate Upgrade Date Shape Round m Start Point End Point Figure 13 Pipeline Section History Recommendations e he adding of a new pipeline section and viewing of current pipeline sections should be in a tab structure but due to limitations of MS Access this was not possible the list box feature becomes inactive e The display of a pipeline section s history should be done automatically without first having to enter it in the textbox This was a design limitation regarding MS Access 10 Pipeline Components The pipeline components main menu figure 14 allows the user to add new components to a pipeline section or view the components on a specific pipeline section 3M 78 uuiveesiiy or retori Industrial
7. Hydraulic Performance DE v 1 User Manual Version 1 0 eh a Hydra Table of Contents hs MATROGUCGHON RE E EE OIE B 1 2 Database Access ee ER EE EE ER ER RE Re RE ER Re Re RR ee ee B 1 3 USER LOG c ea ae B 2 A PROMISE RATION zes ea B 2 4 1 Maintain System Users se esse ee Ee ER EER Ee ER Ee ER ee ee ee ee ee ee B 3 5 Read Only VIEW se ee ee EE RE EE ER ER ER Re EE Re nne B 4 6 Hydraulic Main Menu eie esse ee es se ee ee ee ee ee ee ee ee ee ee B 5 7 Pipeline Owners EE EE EE ER EE EER ER EE ER EE ER ER EE Re ee ee ee ee B 6 8 PIDEIINE SYSIEMS esses es RE EE SR ER ER N RE Ge RE B 7 9 Pipelini CCION ss es EERS een B 8 9 1 New Pipeline Sections ccc ccc cece cece e eee ER RE Re ER ee Re Ee ee B 9 9 2 View Pipeline Sections c ee EE ER EE RR ER EE Re ER RR ee ee ee ee ee B 10 10 Pipeline Components Ee EE EE EE ER EE ER ee ee ee B 1 1 10 1 New Pipeline Components esses B 12 10 2 View Pipeline Components cccececeeeeeeeaeeneeeaeenaeeaees B 13 TI AP UMB SIAUONS ses SES DE EE OE DE ED DEI B 14 Hi NEW PUMDS ONS EE EE GR ie EE GE B 14 11 2 View Pump SIatiONS eu osse ke bert opu EE EG EE GED DE mex Ex cens B 15 11 9 ASSI PUMP StaONS susse een B 16 12 Reservoirs EE ER RE EE EE RR ER EE ER Re eee nnns B 16 Ted NEW IRCGCIVOWS ige RE De ran B 17 12 2 View IOSOEIVOIES sogni ae ae nee Ee er tu Ge ee
8. ader Surname Hillerman iran MN Cell Number 0834533025 Province Kwazulu Natal sv Nearest Town Winterburg Notes Save Changes Add Crew Figure 30 IS Maintenance Crew Details IT VAN PRETORIA university or ereton Industrial amp Systems Engineering Department B 22 ae RR ring Mr Es Maintenance Crew X ka IS Maintenance Crew ee EE IS Maintenance Crew Details Crew Assignment Currently Assigned Pipelines Monitoring Status Assignment Date 2008 12 12 Active 2008 10 14 Record 4 dof1 gt hM ps KI Save Changes Delete Assignment Figure 31 IS Maintenance Crew Assignment 15 Hydraulic Results The hydraulic results screen figure 32 displays a list of pipeline sections and by selecting a section the hydraulic results are displayed These records include the pipe roughness values as well as accompanying graphs and reports Hydraulic Results Se W Hydraulic Resu Hydraulic Results DE Pipeline Section C16004 Pipeline System GaanRT54 Pipeline Section 2000 12 20 2 2008 10 08 2 2008 10 14 6 Figure 33 Hydraulic Results ww ot ereto Industrial amp Systems Engineering Department B 23 THI TA PRETOR usw n Lacing Bron CIRpxquok Fir Dheri Recommendations e A list of pipeline systems must first be displayed By selecting a specific system all the sections must be displayed The section can then be
9. ce Report 18 2 Hydraulic Results Report The input screen figure 42 allows the user to input the pipeline section for which the hydraulic report must be displayed Enter Parameter Value Please Enter The Pipeline Section Figure 42 Enter Pipeline Section Screen The hydraulic report figure 43 displays the pipe roughness calculated by five different methods and the accompanying graphs for a specific pipeline section Industrial amp Systems Engineering Department B 29 Hydraulic Results Repor bts Result Date C WEs 2000 12 20 2008 10 08 2008 10 14 raulic Results K P Ks 2 2 787 Barrs Ks H W C Value Pipeline Section GRTOO3 Mn n Value 2 35 2 Page 1 of 1 Figure 43 Hydraulic Results Report 18 3 Pipeline Owners Report Pressure Drop Flow Rate Graphs The pipeline owner report figure 44 displays all the pipeline owners and their essential contact details The project team uses these details to keep in contact with the owners Pipeline Owner Report neon m Email Owner Contact Number Fax Number Contact Person Owner Contact Number Fax Number Contact Person Umgeni Water 0333411111 0333411167 Mr Alan Kockott a kockott umgeni co za Rand Water 0861010221 0114525555 Mr Phillip Basson Postal Address Physical Address Email Postal Address Physical Address p basson randwater co za Figure 44 Pipeline Owners Rep
10. ect me from unknown content recommended Enahle ths content Quen the Trust Center Lx aa Figure 2 Enable Content af g university or setora Industrial amp Systems Engineering Department B 1 hend YUNIBESITHI TA PRETORIA 3 User Login The system user is then requested to login with a username and password figure 3 This security feature allows for three types of users to access the database namely Administrator Full Access and Read Only The login screen validated the user s password and displays an error message if the wrong password is entered cs User Login FAR Hydraulic e Performance DB v 1 Username pvlynch Iv Enter Password oe Microsoft Office Access e 1 Wrong Password Figure 3 User Login Screen and Validation Depending on the user clearance the login screen will then take the user to one of the three main menus namely Administration Main Menu figure 4 Read Only Main Menu figure 6 and the Hydraulic Main Menu figure 7 As a default setting if no password is entered the Read Only Main Menu appears Table 1 contains the usernames and passwords for login Table 1 Usernames and Passwords Password X Open J pvlynch Administrator Main Menu mvdik pipe Hydraulic Main Menu Read Only Main Menu 4 Administration This is the highest clearance level for a user which will allow them to perform administrati
11. ed on the right hand side of the screen Typical buttons such as add save and delete are present E 78 moves or ereton Industrial amp Systems Engineering Department B 6 Tena Lu l H A E t UE Es Pipeline Owner EET eline Owner Details Pipeline Owners m Organisation Umgeni Water Umgeni Water Sete anges Rand Water work number 033 341 1111 Bloem Water wner Magalies Vater Fax number 033 341 1167 email address jinfo umageni co za Delete Owner physical address postal address PO Box 9 Fietermaritzburg KwaZulu Natal 3200 contact person Mr Alan Kockott contact email a kockott umgeni co za Figure 8 Pipeline Owners 8 Pipeline Systems The pipeline system screen figure 9 displays a lit of current pipeline systems in the database Attachments of photos and drawing of the pipeline systems can be added Add save and delete buttons are present to simplify record maintenance There is a field called short name which is a three letter abbreviation of the pipeline system This short name is used to name pipeline sections There is a link to the GIS in order to see where the pipeline lies and the surrounding area this link is currently not active as the GIS must be installed on the computer The Operating Life field contains a formula which calculates the age of the pipeline based on the commission date a 78 Uviversivy or prevon Industrial amp Systems Engineering Depart
12. eline Components Add change or delete pipeline components on a pipeline section e Maintain Pump Stations Add change or delete pump stations on pipeline systems e Maintain Reservoirs Add change or delete reservoirs on a pipeline system e Maintain Data Nodes Add change or delete data nodes data loggers and instruments along the pipeline systems e Maintain Information System Maintenance Crews Add change or delete maintenance crews that will service the data loggers and data recorders on the various pipeline systems e Maintain Pipeline Splits View and add pipeline sections which break up into more sections e Maintain Pipeline Mergers View and add pipeline sections which merge into a pipeline section e View Hydraulic Results Access the output results of pipeline sections pipe roughness values and accompanying graphs and reports e Reports View and print reports regarding the information system 3i g sniveesiiy of preton Industrial amp Systems Engineering Department B 5 YUNIBESITHI YA PRETO Ex Full Main Menu ZEN Hydraulic Pipeline Section Reservoirs Merge _ Data Nodes Hydraulic Results Figure 7 Hydraulic Performance Main Menu 7 Pipeline Owners The pipeline owner screen figure 8 allows a user to enter pipeline owner details The screen displays a list of current pipeline owners and by selecting an owner the details are display
13. he merger as well as saving information about the new merged pipeline section Es New Pipeline Section Merger UTERE Please Enter New Pipeline Section First and COPY SECTION ID FOR MERGE ID MERGEID O OOS S Merger Date 2008 10 12 Pipeline Sections Merged Change Merged Change Data Nodes Change Components Sections STATUS to To Mew Section To New Section MERGED Change Component Change To Merged n Location Figure 38 New Pipeline Section Merger Due to the complex nature of merging pipeline sections and all the changes that have to be made the process could not be completed automatically by queries e g multi valued fields were used which cannot be used in queries The layout of the screen follows a logical sequence in order to make the changes Pipeline section mergers do not occur often so it is not such a great concern that the process takes time Recommendations e The screen must be redesigned to make it more user friendly and automated TEIT VAN PRETORIA ivy or eeeroria Industrial amp Systems Engineering Department B 27 Dee ETE mm mss Was EET 17 2 View Merged Pipeline Sections The merged pipeline section screen figure 39 displays a list of all the new pipeline sections that have been merged from existing sections By selecting a section the right hand side of the screen displays the details of which sections were merged to form the new section tg Pipeline
14. ineering Department B 19 VER EE 1 n Leng gar Eri 13 Data Nodes The data node main menu figure 26 allows the user to add new data nodes on a existing pipeline section as well as viewing current data nodes Es Data Node Main MEME Data Node Menu Mew Data Mode Modes Figure 26 Data Node Main Menu 13 1 New Data Node The new data node screen figure 27 makes use of drop down boxes and current date feature to make the data entering process user friendly Es New Data Node TR 3 New Data Node i Pipeline Section X Coordinate Y Coordinate Z Coordinate Installation Date 2008 10 14 Temperature Meter Flow Meter Water Quality Meter Presure Meter Maintenance Type Maintenance Date Number Of Channels Additional Notes Y E Figure 27 New Data Node 3 UNIVERSI UNIVERS TYUNIBESI usum n ung EIT VAN PRETORIA TY OF PRETORIA THI TA PRETORIA 1 Industrial amp Systems Engineering Department B 20 13 2 View Data Nodes The data node screen figure 28 displays a list of pipeline sections By selecting a section all the data nodes on the section are displayed The user can then enter a node ID in the text box to display the nodes history records of all the changes that the node has undergone figure 29 Es Data Nodes Data Nodes Select Pipeline Section ine System GaanRT154 e Section GRT003 Figure 28 View Data Nodes E3 Data Node History Q
15. k LA ERE 1o l LA
16. mani GSSTRR3 Waterloo Pump Station Pipeline System ZwartkopjesC13 ZwartkopjesC16 al Lesaka Booster Pump 1 Figure 21 Pump Station Assignment Recommendations e The GIS must be active on the final system and by clicking on the button must open the exact position of the pump station e A tab structure should be used to display the display the three screens mentioned above but due to MS Access limitations this was not possible list boxes became inactive 12 Reservoirs The reservoir main menu figure 22 allows the user to add new reservoirs view current reservoirs and assign reservoirs to pipeline systems ai 78 un versim or pretoria Industrial amp Systems Engineering Department B 16 EA niens acing Mr Es Reservior Main Reservoir Menu Assign Reservoirs Reservoirs Figure 22 Reservoir Main Menu 12 1 New Reservoirs The new reservoirs screen figure 23 makes use of the current date feature and drop down boxes to make it user friendly to complete the reservoir details Attachments of the reservoir s drawings and photos can be added Es New Reservoir x New Reservoir Date Reservoir Photos 7 Drawings Figure 23 New Reservoir IT VAN PRETORIA ai 78 university or ereton Industrial amp Systems Engineering Department B 17 WP Dre eee tede IT HI grad n Laer Mn DX i 12 2 View Reservoirs The reservoirs screen figure 24 allows the user to view a list of c
17. ment B 7 SLIDE a Leon Es Pipeline System EF Pipeline Systems Add new pipeline owners before entering new pipeline details Pipelines oweerlineB 7 Welbedacht Pipeline Short Name LEU Lesaka Pipeline Leuwkop Pipeline a Ndwedwe Bulk Water Pipeline Profile warlkopesC3 Commission Date 1989 04 01 ZwartkopjesC 13 vp ZwartkopjesC 16 Operating Life Y Wallmannsthalt Additional Notes Single Line Wallmannsthal2 Wallmannsthal3 Save Changes Add Pipeline bied Photos Delete Pipeline Gls x ma Pipeline Name Leuwkop Pipeline Pipeline Owner Bloem Water Figure 9 Pipeline Systems Recommendation e The GIS must be activated on the final system and by clicking on the button must open the exact position of the pipeline using the X Y and Z Coordinates 9 Pipeline Sections The pipeline section main menu figure 10 gives the user the following options new pipeline section and view existing pipeline sections cs Pipeline Section Main X New Pipeline Section View Pipeline Sections Figure 10 Pipeline Section Main Menu IT VAN PRETORIA AMAN SPATO Industrial amp Systems Engineering Department BA HI TA PRETORI Mura RAT rna Lacs 9 1 New Pipeline Section The new pipeline section screen figure 11 allows the user to enter a new pipeline section on an existing pipeline system This is needed as the entire pipeline will not necessarily be monitored or the pipeline
18. might have variations along its length which could to be monitored individually Es New Pipeline Section C New Pi Ei Suction Pipeline System EE section ID Status section Shape section Material Liner section Size mm Date 2008 10 14 Start Point End Point X Coordinate YCoordinate JLo Z Coordinate 0 0 0 0 0 0 Figure 11 New Pipeline Section The screen makes use of the current date as a default value for the monitoring date Drop down boxes are used to enter details making the system user friendly The section ID is entered using the short name of the pipeline and three numbers e g ORG and 004 This allows the user to see which pipeline system the section belongs to Recommendations e The final system must make use of the short name but must be an auto number feature 3x unversiny or ereroria Industrial amp Systems Engineering Department B 9 VER EE Lcsrsg 9 2 View Pipeline Sections The pipeline sections screen figure 12 lists the current pipeline systems By selecting a pipeline system all the pipeline sections are displayed The pipeline section can then be entered in the textbox below to view its history records Figure 13 Es Pipeline Sections _ x Pipeline Sections Pipelines Oranges1 GaanRT54 oweerlinaB Welbedacht Pipeline Lesaka Pipeline Leuwkop Pipeline Ndwedwe Bulk Water 5 ZwartkopjesC 3 ZwartkopjesC 13 ZWartkopjesC 1
19. oe be B 18 12 3 ASSIN RESEIOIS us een B 19 ESE icio EE EE OE EE N EN B 20 13 1 NEW Dale NOUS seen ees EE EE EE E T EE AE B 20 132 VIEW Data oo on aeg B 21 14 IS Maintenance Crew Ee EE Re EE Re ee ER ee ee ee ee B 22 3i university or eeeroeik Industrial amp Systems Engineering Department B i a FUN LES S ze LA PRE CUEN 15 Hydraulic Results 0 cece cece ee Ee ee ee ER ee ee ee ee ee ee B 23 16 Pipeline Section Split Lsseeeeeuueeuuees B 24 16 1 New Pipeline Section Split seseeeseeee Re Ee ee B 24 16 2 View Pipeline Section Split ee ee ee ee cece ER EE eee EE ee Re ee B 25 17 Pipeline Section Merger EE EE EE Ee ER EE Re ee ee ee B 26 17 1 New Pipeline Section Merger RE ER RR EE ER ee Ee ee B 27 17 2 View Pipeline Section Merger ie see se ee ee ER RE Re ER ee ee ee B 28 16 RODO O Se EE ana EE ee B 28 18 1 Data Node Maintenance Report ie ee ee ee ER ee kk ee Re ees B 29 18 2 Hydraulic Results Report sis es ese ee es ee ee ee ee ee ee ee ee eed B 29 18 3 Pipeline Owners Report ie se se ER EE RE ER ER ER EE ER ee Re ee ee ee B 30 18 4 Split Pipeline Sections Report ie ie ee cece eee ER Re Re en B 31 18 5 Merged Pipeline Sections Report cceeeeeeeee eee ek ee Re B 31 g sniveesiiy of ercros a Industrial amp Systems Engineering Department B ii YUNIBESITHI YA PRETORIA
20. onal duties for the information system The user also has full access to the information system via the hydraulic main menu button g uiiversity or eeeroria Industrial amp Systems Engineering Department B 2 TORIA nnd YUNIBESITHI TA PRETORIA e Admin Main Menu Z BI M Hydraulic Main Back Up Clear Menu Data Packages Figure 4 Administration Main Menu The Administration Main Menu allows the following actions e Maintain Users Add change and delete system users and their security capacity figure 5 e Hydraulic Main Menu Go to the actual system main menu figure 7 e Back Up Hydraulic Results Archive the hydraulic results in a separate database for back up purposes This is an append query e Back Up and Clear Data Packages Archive the hydraulic data in a separate database and delete the old data in the current database This consists of an append and delete query e View Hydraulic Data Allows the administrator to view the hydraulic data which rest of users will not be allowed to perform 4 1 Maintain System Users The user can add change and delete system users The user clearance is also set via the user role combo box The screen has a password validation rule that checks if the password is typed in correctly i e retype password feature EL 78 wuveesioreeerons Industrial amp Systems Engineering Department B 3 X unitur FREE User Details ee u System Users
21. ort 3 UNIVERSITEIT VAN PRETORIA UNIVERSITY OF PRETORIA end TYUNIBESI RETORIA THI TA P vg Munch Dew D ficit info umgeni co za PO Box 9 Pietermaritzburg KwaZulu Natal 3200 310 Burger Street Pietermaritzburg 3201 r water randwater co za PO Box 1127 Johannesburg 2000 522 Impala Road Glenvista 2058 Industrial amp Systems Engineering Department gt m B 30 18 4 Split Pipeline Sections Report The split pipeline sections report figure 45 displays all the new pipeline sections that have been split from existing pipeline sections Pipeline Section Split Report 239 Pipeline Section Spli New Pipeline Section Split Pipeline Section Split Date ORGO067 ORGO002 2008 10 08 ORGO66 ORGO02 2008 10 08 ORG999 ORGO006 1999 12 12 ORG098 ORGO006 1999 12 12 4 Page 1 of 1 Figure 45 Pipeline Section Splits Report 18 5 Merged Pipeline Sections Report The merged pipeline sections report figure 46 displays all the new pipeline sections that have originated from merged pipeline sections Pipeline Section Merger Report u i S ipeline Section New Pipeline Section Merged Pipeline Sections Merger Date ORG044 ORG002 ORG003 2008 12 12 ORG045 ORG004 ORG005 2008 10 08 SMB005 SMB001 SMB002 2008 10 08 SMB003 3 Page of Figure 46 Pipeline Section Mergers Report a versi or prevor Industrial amp Systems Engineering Department B 31 T LUN IBESIT u
22. rder to make the changes Pipeline section splits do not occur often so it is not such a great concern that the process takes time Recommendations e The screen must be redesigned to make it more user friendly and automated 16 2 View Pipeline Section Splits The pipeline section split screen figure 36 displays a list of all the pipeline sections that have been split By selecting a section the right hand side displays the new sections that have originated from the split a 78 un versim or pretoria Industrial amp Systems Engineering Department B 25 Voels vi PRES acing Mr Cs Pipeline Section Split TLL Pipeline Section Splits Split Pipeline Sections ORG001 Split Pipeline Section oxen Status ORGO007 SMBOO4 Ej New SplitSectionID SplitDate 1999 12 12 1999 12 12 Figure 36 Pipeline Section Splits 17 Pipeline Section Merger The pipeline section merger main menu figure 37 allows the user to add new pipeline section mergers as well as view merged pipeline sections Es Pipeline Merge Main EX Figure 37 Pipeline Section Mergers Main Menu IT VAN PRETORIA iv or ereton Industrial amp Systems Engineering Department B 26 ER 17 1 New Pipeline Section Merger The new pipeline section merger screen figure 38 allows the user to take existing pipeline sections and combine then into larger sections This allows the existing information to be kept about the sections before t
23. s of a pump station drawings and photos can be added to records university or ertion Industrial amp Systems Engineering Department B 14 Es New Pump Station iem gt New Pump Station Pump Station Name Date X Coordinate fl Y Coordinate ss Z Coordinate a Pump Station Type ls Drawings Photos Figure 19 New Pump Station 11 2 View Pump Stations The pump station screen figure 20 allows the user to view a list of current pump station By selecting a pump station details are displayed The screen has a link to the GIS in order to view the location of the pump station and the details of the surrounding area Pump Station Timeline Pump Stations Baviaanspoort GSSTRR3 Kaiatia 1 Lesaka Booster Pump 1 MyPump Ndewdew Umat Booster1 Pump Station Configuration Upgrade Date Photos Drawings Notes Two in Parallel 2008 10 14 m3 Wallman1 Waterloo Pump Station Delete Pump Station New Pump Station 78 viiversivy or pretoria Industrial amp Systems Engineering Department B 15 Ted TERI EES cut tA PRETORIA RAT or er Hir Ceres 11 3 Assign Pump Stations The pump station assignment screen figure 21 allows the user to assign pump stations to pipeline systems Es Pump Station Assignment a Pump Stations rem Pump Station Baviaanspoort Ndewdew Kaiatia 1 NP MyPump Assigned Pipeline Systems Wall
24. selected to display its timeline of hydraulic results 16 Pipeline Section Split The pipeline section split menu figure 34 allows the user to enter a new section split or view all the pipeline sections that hare currently split Es Pipeline Section Split Main EL 3 Display Pipeline Section Splits Close Figure 34 Pipeline Section Split Main Menu 16 1 New Pipeline Section Split The new pipeline section split screen figure 35 allows the user to take an existing pipeline section and sub divided it into smaller sections This allows the existing information to be kept about the section before the split as well as saving information about the new split pipeline sections moves of scros a Industrial amp Systems Engineering Department B 24 TOR Es New Pipeline Section Split num Please Enter New Pipeline Section First and COPY SECTION ID FOR SPLIT ID DEE Mew Pipeline Original Pipeline Section Split Date 2008 10 12 Change Split Sections Change Data Modes Change Components STATUS to SPLIT To Mew Sections To Mew Sections Change Component Figure 35 New Pipeline Section Split Due to the complex nature of splitting a pipeline section and all the changes that have to be made the process could not be completed automatically by queries as problems arise e g which new section does the data node and components lie on Thus the layout of the screen follows a logical sequence in o
25. uery mx Upgrade Date n c co co e 4A Maintenance Type X Co 0212454778 General eas Temperature Meter Yes xi Y Co 0125195642 FN i Maintenance Date Yes 2009 12 12 Z Co 5405645654 E Water Quality Meter No Additional Notes Pressure Meter 2 vi Data LoggerChannels 6 Iv Upgrade Date 2008 10 14 Maintenance Type X Co v i c7 i Temperature Meter E AA eei m P a Figure 29 Data Node History J UNIVERSI UNIVERS end TYUNIBESI usum n ung EIT VAN PRETORIA TY OF PRETORIA THI TA PRETORIA sa Industrial amp Systems Engineering Department B 21 Recommendations e The adding of a new data nodes and viewing of current nodes should be in a tab structure but due to limitations of MS Access this was not possible the list box feature becomes inactive e The display of a data node s history should be done automatically without first having to enter it in the textbox This was a design limitation regarding MS Access 14 Maintenance Crew The maintenance crew screen figure 30 and figure 31 allows the system user to enter maintenance crew details and assign the crews to pipeline systems via a tab structure Drop down boxes we used to make the data entering process user friendly ES Maintenance Crew 2e X Company BSS BSS Hillerman Rand Water Fourie Leader Name Gary De Wall Le
26. urrent reservoirs By selecting a specific reservoir details are displayed The screen has a link to the GIS in order to view the location of the reservoir and the details of the surrounding area View Reservoirs m hes 3 N _ Reservoir History RR Reserviors usak Reservoir Reservior Name Lusak Reservoil Magalies Mid tank Zwartkopjes 1 Zwartkopjes 2 Reservoir Description Upgrade Date Drawings Photos X Coo Tower Type 2008 10 14 E 0015 ra 2008 10 14 Delete Reservoir Figure 24 Reservoir History A 78 university or setora Industrial amp Systems Engineering Department B 18 ed TYUNIBESIT H TA EHE 1o RIA Dorm n Lancing DX Fir Cii 12 3 Assign Reservoirs The reservoir assignment screen figure 25 allows the user to assign reservoirs to pipeline systems zal Reservoir Assignment TEM Reservoir Ass Reserviors Lusak Reservoir TE Magalies 1 Reservior Name M d galies Mid tank Zwartkapjes 1 Zwartkopjes 2 Pipeline System Wallmannsthall Close Figure 25 Reservoir Assignment Recommendations e The GIS must be active on the final system and by clicking on the button must open the exact position of the pump station e A tab structure should be used to display the display the three screens mentioned above but due to MS Access limitations this was not possible List boxes became inactive 3M 78 university or eeevoria Industrial amp Systems Eng
Download Pdf Manuals
Related Search