Home

ACPS Training Manual - Automated Inventory Support System

1. to save report and move to the next step of creating command of type Stored Procedure or SQL see Figure 5 6 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Report Details Step 3 Stored Procedure Details ECE usp_GetAssetltemDisposal usp_GetAssetltemDisposalCount usp_GetAssetltemHistory usp_GetAssetltems usp_GetAssetitemsByBarCode usp_GetAssetltemsByGLCode usp_GetAssetltemsByPONum usp_GetAssetltemStatusHistory usp_GetAssetValuations z Nar e __ Type 7 S BarCode 1 ogg E a 9 FieldName AnsiString Bldq LookUp O i RowCoun Int32 Bldq LookUp x E ha l SQL Exec usp_GetAssetData Filter FieldName RowCount a Successfully Tested the SP Total Record Count Returned 1 Figure 5 6 Create New Report Step 3 Create Stored Procedure Command Step 7 If command type stored procedure is selected then in the next step of the screen user will get the options to edit the details like a Various stored procedures for selection Parameters SQL Box under the section head Step 3 Stored Procedure Details b The parameter information grid is refreshed based on the selected stored procedures parameters c The user has an option to select the parameter from the dropdown values or enter a default value under the parameters grid d The user can test the Stored Procedure command against the data
2. Copyright Last Inventoried Status Condition Room Custodian Student Building Location Description Title Acquisition Method Funding Source Funding Agency Program Assigned Purchaser Floor Life Span ISBN Department PO Rack Bin PO Date Purchase Price Current Value Group Controlled Quantity Total Value IT Asset GL Code Sub Category Function Notes and Comments in the Asset information Tab Step 5 Enter values in the Dynamic Asset Fields Step 6 Click on save button which is at the bottom of the Asset Item Information window to add the Mass Asset Item to MBN Inventory Asset Fields The Asset Fields screen provides the users the ability to search Asset Field Items in the MBN application see Figure 2 4 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Asset Fields Search i i Search Total Records 1 Asset Fields Details Pr 33 9 Yes O Ne moss 11 04 2010 07 14 16PM__ Figure 2 4 Asset Field Search Screen User can search Asset Fields for information Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click Asset Fields from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 In the Asset Fields search page user can either enter name of the Field and select the
3. Step 1 Report Details amS Asset Item by Building and Roc Asset Item by Building and Room Assign Roles Users to Report a ene Report Properties Z leader Fc i E DE k E a TAR Command Details Type Stored Procedure SQI Clear gt Figure 5 4 Edit Screen of Reports Delete Reports Only Administrator User can delete the Report Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Reports from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Reports list is displayed with the options to Run Admin Edit Edit and delete report Step 5 Click on trash icon option to delete the report Create Reports The Create Report screen will provide the users the ability to Create Edit Report settings user has to enter the details like Report Name Description Grid Group Option for Private Reports Assign Roles Users to Report Report properties like Header Format Header Parameters Footer and Command details like Stored Procedure or SQL Type see Figure 5 5 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Step 1 Report Details Generic v Assign Roles Users to Report Command Details SC Y Type Stored Procedure 2 SQL 22 Figur
4. Cregte NeW REDO cerci E uti noersusnoer ids ededowantn saul nhectueunesaeeettoiieaanens 38 Figure 5 6 Create New Report Step 3 Create Stored Procedure Command sss esse sees eee eee eee 39 Figure 5 7 Create New Report Step 4 Create Stored Procedure Command s Report Columns sss sss sss eee eee eee ee 40 Figure 5 8 Create New Report Step 2 Create SQL Details sees eee eee 41 Figure 5 9 Paral Meter LIS a T NE TTS 42 5 This page contains confidential information PITech ULC MBN INVENTORY USER MANUAL JANUARY 10 2011 Roure 1 om SIS eade Paane o eee an toe ee eT ce ne Ce nee eee cent ere 43 Heures K 1 BG deg elene 44 Figure 5 12 Adding Updating ee TT 45 Fiure K View CONMECUION SUING aeee EE 45 Figure 5 14 Adding updating Connection String cccccccccccsssecccccccccecseeccceceesseueeeeeceeceseseueueusceeessseeeuuueeeesesseuuueeeeeeeeeseeees 46 6 This page contains confidential information PITech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 HOME PAGE The Automated Inventory Support System Home Page for all users and user groups will be the default menu page NAVIGATION MENU MENU BAR The navigation menu provides the user the ability to navigate thru the MBN Inventory Web Application The navigation menu is divided into five different modules By hovering over the module names the user is presented with a list of options to select These modules work as a whole from user administratio
5. Edit the details like Connection type SQL check or uncheck the Trusted Check box Server name Database name user id User Password and then click on save button to save the changed settings see figure 5 14 Create New Connection String Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen 45 This page contains confidential information Pltech LLE MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 3 Click Connection strings from the drop down list under the Reporting option from the menu bar at the top of the screen A list of available connection strings are shown if available See figure 5 14 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Assetltem Custodian Maintenance Reporting Logout Connection String Details Figure 5 14 Adding updating Connection String Step 4 Click on New link in the section heading Connection String Details New see figure 5 13 Step 5 Enter new connection string details like Connection type SQL check or uncheck the Trusted Check box Server name Database name user id User Password and then click on save button to save the new connection settings 46 This page contains confidential information Pitech LLC
6. User Administration option from the menu bar at the top of the screen Data Access Layer Performance Log Details Information H CR H x 7E lt EL OE nt Sec UserLogin 11 08 2010 01 01 00AM 0 203 18 This page contains confidential information Pltech LLE MBN INVENTORY USER MANUAL JANUARY 10 2011 Figure 1 13 View Data Access Layer DAL Performance Logs Step 4 Click on Ca magnifying glass symbol to view the logs of the intended function Once it is clicked the logs are displayed below the list of DAL Functions Create Role The Administrator user group can create Role where a user can be assigned to the roles based on their user roles See Figure 1 14 MIDDLE EAST Figure 1 14 Create Roles Screen Step 1 Administrator logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click on Create Role from the drop down list under the User Administration option from the menu bar at the top of the screen Step 4 Provide the New Role Name and click on Add button to add a new role to the existing application roles Step 5 Also Administrator can see the present Application Roles Role Exists Role used and Trash button Step 6 Administrator can also delete the Application Role if required by clicking the trash icon of the Role wish to delete 19 This page contains con
7. of the ordering grid h The user can test the SQL command against the database by clicking on the Test Command button A corresponding success or error message will be displayed on the screen indicating the validity of the SQL command i The user can save the command details by clicking on Save button This button click automatically tests the command validity 41 This page contains confidential information PiTech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 PARAMETERS The Parameters screen will provide the users the ability to search the parameters created like parameter name screen type table name lookup field and return field see Figure 5 9 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset ltem Custodian Maintenance Reporting Logout Parameters Search Parameter Details Projectid Status 3 BarCode E 3529 3 Room E Condition ndition s aPONumber S asiar Start Date Enty OO OOOO Tepe 2 ind apar pr OOOO o O 7 Category ategory r i 3 hStatus E sISBN sISBN 2 UserId Userld E GLCode EI hStudentid sAcquisitionMethod sBidq E sTitle sCreateUser sMfar LookUp Figure 5 9 Parameter List Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click
8. 9 13 2010 7 45 17 AM Ea Generic Report Books By School admin 10 21 2010 11 02 39 AM Generic Report Books by Status amp Category Admin Reports User 8 16 2010 2 37 03 AM EI Books In Storage Admin Reports User 9 13 2010 5 48 54 AM 7 g ig 20102 37 59AM o P7 9 13 2010 6 30 07 AM 4 8 16 2010 3 30 52 AM ISBN amp Building ISBN Search Admin Reports User Items By Condition Admin Reports User Admin Reports User Admin Reports User HOR COU CO ai f Generic Report Generic Report Generic Report Generic Report Generic Report Generic Report Items by ISBN Admin Reports User 9 13 2010 4 48 55 AM P Generic Report User Log Admin Reports User 8 17 2010 12 04 04 PM P Liz z Figure 5 1 Reports List Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Reports from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Reports list is displayed with the options to Run Admin Edit Edit and delete report a Run option is shown with magnifying glass symbol This run option is used to run the specific report to execute A Report User or Administrator user Group can use this option b Admin Edit option 7 is shown with pen symbol This Admin Edit option is used to Edit the Repo
9. Columns View Report Columns Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Columns from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 The user needs to select the report type under the section heading Report Details to display the Column Details and then the column details are displayed in the table format under the section heading Column Details 2 New Edit Report Columns Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Columns from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 The user needs to select the report type under the section heading Report Details to display the Column Details and then the report details are displayed in the table format under the section heading Column Details New Step 5 Click on the link of column type in the Name column of the section heading Column Details New of the columns wishes to edit Step 6 Edit the column details like name check or uncheck the option sortable Field Sort Expression Number Width Format Type like bound field or checkbox field or date field or Hyperlink field or image fiel
10. Fea O e E E E E E EE E 7 E THI 7 T ese TT TTT 8 PT TTS ANC Sette erect ocean te E AA A E A E E ocean E A ecatercestentee 8 PROTON aT 8 SCREEN TIE 8 BREADCRUMB Sorcier a ecu nia cuneasavetindnnesduncsaurstudeani duacanvosindwantienstavsatnceatdeuneodsandrunesnneniavaRedeqntiuucsdaiaenimantabiorsiardtacneseiuecsimadanryentenes 8 ONE FEADING ga cerca crvareporacoens E E E E ngs vasiue vere coonascureaseve Soonpecaunceseeeeonsyerinees 8 PA IAN a E nae nese ccna T E ld oases opted E cane E estan sed ecco E E E nace acces eee T E E 9 SORTING DATA e E E TE E E E E E T A erunvaineees 9 DRILLING DOWN ONDA T Acarer near E E E E A EE E E A E N 9 PACE ZE e T E E T E E A T 10 LOG GIN a E E E E E E 10 U ade 11 Rare E Or OOU e E cecense aneciasueieuemieseasueietasenseaneoeee ads 11 REPO OOU e E E evi wate enue ote E E E EE E vent E E N 12 POA EEO a E EEE E 12 SPENN Or OFOD TT 13 Bee oere E A E E E A E E pietmenedsnc eres 13 USER ADMINISTRATION MODULE aaaea ahar Haa EERE EEA 15 BRE OP e E E 15 aae SOI PEO NC aee E E 16 Paneo Pe WON a E E E ee eRe ene ener 16 DEE e CIN tes chines E E E E E AE E E E E AE E IA EEE E T 17 Unlock U EFA an E E E A E E A A oars 17 OW O INe 6 acid ra E R T E ne ee eee 17 2 This page contains confidential information PITech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Howto Reset User S PASS WOO TT 17 Dyes haa ose U ere PrO ee ee ee ne tae RE ee ee ee ce eee eee ee 18 KIR r STs nee TTT 18 View the DAL sts Te O
11. Field Type like String or Big Integer or Integer or Small Integer or Tiny Integer or Small Money or Money or Numeric or Decimal or Float or Real or Boolean or Date Time or Small Date Time or Foreign Key and then click Search button to display the search results User can also just click on Search button without selecting Field Name or Field Type to display the entire search results New Asset Item Fields The New Asset Item Field screen provides the users the ability to Add Asset Item Fields in the MBN application dynamically see Figure 2 5 23 This page contains confidential information PilTech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Figure 2 5 New Asset Item Field Screen Adding New Asset Item Fields Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click Asset Fields from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 Click New link in the Asset Fields Details New section heading and a new screen is display with the section headings Asset Item Fields New Table Field Information and Foreign Key Constraint Field Information Step 5 User can check the static fields defined along with data types of asset
12. MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 4 The Administrator or MBN user must enter the current password in the Password field Step 5 The Administrator or MBN user may enter a new password in the Password field Step 6 Re enter the same password in the Confirm New Password field Step 7 Click the Change Password button on the bottom right hand side of the screen User Search The Administrator Group is able to search the MBN application for specific users using the User Search screen This screen displays user information See Figure 1 11 User Administration Assetltem Custodian Maintenance Reporting Logout User Search Information Update z L ee e Zils Us 4 l IsOr i te Loc H S Ea aM a e kbuoni 46 mmoss mmoss probar com No 11 5 2010 5 48 30 AM Admin 22 Figure 1 11 User Search Step 1 Administrator or MBN user logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click User Search from the drop down list under the User Administration option from the menu bar at the top of the screen The Administrator Group may perform the following functions 1 Unlock user account Check whether user is online or offline Check user last logged in information Reset the user password Delete the user profile Edit user profile like user role S ea Unlock User Accoun
13. MIDDLE EAST BROADCASTING NETWORKS INC User Administration Assetltem Custodian Maintenance Reporting Logout Update User Update the Role of the User Update User Information Figure 1 9 Update User Step 1 Administrator logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click Update User from the drop down list under the User Administration option from the menu bar at the top of the screen Step 4 The Administrator may enter new information for the following fields E mail Role User Last Name User First Name Employee Department Office Phone Step 5 Click the Update button on the bottom right hand side of the screen Change Password The Administrator Group and all MBN Inventory users are able to change passwords using the Change Password screen see Figure 1 10 User Administration Asset Item Custodian Maintenance Reporting Logout Change Password Change Password Cancel Figure 1 10 Change Password Screen Step 1 Administrator or MBN user logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click Change Password from the drop down list under the User Administration option from the menu bar at the top of the screen 16 This page contains confidential information Pitech LLC
14. Text Books 0 00 0 00 0 00 0 00 0 00 0 00 0 00 1 11 04 2010 12 09 04 AM Thin Client 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 Computer 12 09 04 AM Figure 2 8 Item Depreciation Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click Item Depreciation from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 User will get a table for list of category and depreciation rate for seven periods time User needs to provide the rate for the required depreciation period time and then click on save button to update the MBN Inventory 26 This page contains confidential information Pitecdh ULC MBN INVENTORY USER MANUAL JANUARY 10 2011 Transfer The Transfer Screen provides the users the ability to transfer Asset items between students and teachers see Figure 2 9 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Transfer Asset Items Figure 2 9 Item Transfer Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click Transfer from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 Click the down arrow to select the Bar Code of t
15. ant n 0 003 Figure 2 7 Mass Item Disposal Item Depreciation The Item Depreciation Screen provides the users the ability to provide the Asset Depreciation rates for the categories for seven depreciation periods time in the MBN application see Figure 2 8 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Asset Depre eciation Information alae Rate 5t 5th Dep 7 l 5th Dep e NS o 10 Fo PT 10 10 10 To o 20 o 00 Books 0 20 0 10 0 10 0 10 0 10 0 00 1 Communications 0 11 0 10 0 10 0 10 0 10 0 00 1 s Desktop Computer 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 Leer Equipment 0 10 0 10 0 30 0 35 0 20 0 00 0 00 1 11 04 2010 12 09 04 AM Furniture 0 14 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 12 09 04 A Group Controlled 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 12 09 04 IT Department 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 12 09 04 AM Network Hardware 9 10 0 10 0 10 0 10 0 10 0 00 0 00 1 137042010 Office Equipment 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 12 09 04 AM PC Peripheral 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 i i 12 09 04 Portable Computer 9 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 12 09 04 A Printer 0 10 0 10 0 10 0 10 0 10 0 00 0 00 1 11 04 2010 12 09 04 AM
16. blank and click on search button to list the entire list of students and teacher custodians Click on Search button Step 5 User receives the screen with list of custodian information in table format with many fields However user can see the details of the particular custodian by clicking the name of custodian in the name column Step 6 Click clear button to go back to custodian search New Custodian The New Custodian screen provides the users the ability to create a new custodian see Figure 3 2 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Custodian Information Figure 3 2 New Custodian Screen Step 1 User logs into MBN Inventory Step 2 Hover over the Custodian option from the menu bar at the top of the screen Step 3 Click New custodian from the drop down list under the Custodians option from the menu bar at the top of the screen Step 4 User will get several options to enter the details of the New Custodian like Title Last Name First Name Department Department Head Building Room Phone Email Type ID Number and Save and Clear Buttons 29 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 5 Enter all the relevant information of new custodian and click on Save button to update the MBN Inventory Step 6 Click c
17. item table like Key Type Field Name Type Length Precision Scale Nullable Constraint Default and Index before creating a dynamic field in the section heading Asset Item Fields Step 6 User has to enter New Field information in the section heading New Table Field Information with required information like Field Type String Big Integer Integer Small Integer Tiny Integer Small Money Money Numeric Decimal Float Real Boolean Date Time Small Date Time and Foreign Key Field Name Length Decimal Places Nullable Default Values and click Save button to save new field into the MBN Inventory database Step 7 If user wants to define a foreign key constraint to the new asset item field then user has to select Foreign Key from Field Type in the section heading New Table Field Information and provide the necessary information like Field Name amp Nullable option and select the Foreign Key Table Code and Description in the section heading Foreign Key Constraint Field Information Once required information is provided the SQL query is automatically generated in the SQL box and click on Save button to save the new asset item field information to the MBN inventory database OR click clear button to clear the fields Item Disposal Module The Item Disposal Screen p
18. menu bar at the top of the screen Step 4 Enter the new User Id in the User Id field e g User name is John Doe the User Id is jdoe first initial of the First Name and Last Name without spaces or Provide User ID in the User Id field Step 5 Enter the password in the Password field Step 6 Re enter the same password in the Confirm Password field Step 7 Enter the users e mail address in the E mail field Step 8 Assign the user s Role by clicking on one of roles listed in the Role field Add Asset Adding of Assets Admin Administrator Access Reports View and Run of Reports User Default User e aa ae a 15 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 5 Supervisor Supervisor user has access to many modules Step 9 Enter the user s Last Name in the Last Name field Step 10 Enter the user s First Name in the First Name field Step 11 Enter the user s Employee number in the Employee field Step 12 Enter the user s Department name in the Department field Step 13 Enter the user s office phone number in the Office Phone field Step 14 Click the Create User button on the bottom right hand side of the screen Update User Profile The Administrator Group is able to update user profiles using the Update User screen See Figure 1 9
19. o Create Modify Update User o User Search Reset Change Passwords o Delete User Accounts o DAL Performance logs o Create Roles e Asset Items Module o View Assets o Add New Asset Items o Mass Assets 11 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 o Asset Fields Item Disposal Item Depreciation Transfer Scan Asset Items e Custodians Module o View Custodians o Create New Custodian o Students List Import e Maintenance Module o View Categories o View Sub Categories o View Statuses o View GL Codes o View Vendor Types o View Address Types o View Contact Types o Cat SubCat Mapping o Import Format o Add View Field Mappings o Add View Vendors e Reports Module O O O o View amp Run Reports o Create Reports o Export Reports Data o Create Edit Admin Reports o Create Command o Parameters o Columns o Connection Strings Reports Group The Reports group has limited access to the different modules in the MBN application The Reports user has the ability to e User Administration Module o Change Password e Reports Module o View amp Run Reports o Create Report e Export Reports Data Add Asset Group The Add Asset Group has limited access to the different modules in the MBN application The Add Asset group has the ability to e User Administration Module o Change Password e Asset Items Module o Add New Asset Items 12 This page contains confidential information
20. the Asset Item option from the menu bar at the top of the screen 21 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 4 By default the user will be in Asset Item information tab User may enter all the necessary information to fill the text boxes like Bar Code Old Tag Category Manufacturer Publisher Model Author Serial Copyright Last Inventoried Status Condition Room Custodian Student Building Location Description Title Acquisition Method Funding Source Funding Agency Program Assigned Purchaser Floor Life Span ISBN Department PO Rack Bin PO Date Purchase Price Current Value Group Controlled Quantity Total Value IT Asset GL Code Sub Category Function Notes and Comments in the Asset information Tab Step 5 Enter values in the Dynamic Asset Fields Step 6 Click on save button which is at the bottom of the Asset Item Information window to add the New Asset Item to MBN Inventory Step 7 After saving the New Asset Item Information click on Pictures tab to add the pictures of the New Asset Item OR click on Asset Item Status Change History to view the New Asset Item status change history OR click on Asset Item Change History to view the Asset item change history Mass Assets The Mass Asset screen provides the users the ability to Add Update Mass Asset Items to the MBN application see Figure 2 3 The user h
21. Event Trigger Function call Connection String and SQL command and then click Save button to save the changed parameters see Figure 5 9 42 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 New Parameter The New Parameter screen will provide the users the ability to Create the parameters and the user has to enter the details like Parameter Name Description Screen Type Length Description Field Code Field List Box Rows List Box Width Selection Mode Control ID Required Checkbox Data Type Value Data Type Repeat columns Error description Validation Expression Note Service Path Service Method Table Name Lookup Field Return Field Invalid Message Event Trigger Function call Connection String and SQL command see Figure 5 10 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Parameter Details DatesFromTo v z T zis shines C ns yy lja Figure 5 10 Edit Create Parameter Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Parameters from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Click New link in the section heading Parameter Details New Step 5 Enter all the required detail
22. Figure 5 8 Create New Report Step 2 Create SQL Details Step 9 If command type SQL is selected then in the next step of screen user will get the options to edit the SQL details like see Figure 5 8 a User can select a table from the list of available table s options The list of columns is refreshed based on the selected table in the Columns list the Field dropdown control of the Filtering and Ordering grids b The user can select the columns option like All Unique and Top c If All option is selected all the columns in the list of columns is selected d If Top option is selected a text box to enter the number of records is displayed e The user can select the columns for the report from the displayed list of columns f The user can select various columns to filter the data on using the 1 column Field of the Filtering grid then the operand needs to be selected from the 2 column of the filtering grid The user then selects the parameter or a default value from the dropdown list in the 3 column Default Parameter of the filtering grid The 3 column can also be left blank in which case the system auto generates a lookup parameter based on the field selected in the 1 column of the filtering grid g The user then has the option to sort the data by selecting the field from the 1 column Field of the Ordering grid then the order sequence of ascending or descending is selected from the 2 column order
23. MBN INVENTORY USER MANUAL JANUARY 10 2011 MIDDLE EAST BROADCASTING NETWORKS INC AUTOMATED INVENTORY SUPPORT SYSTEM MBN User Manual Version 1 0 MBN s mission is to provide objective accurate and relevant news and information to the people of the Middle East about the region the world and the United States MBN supports democratic values by expanding the spectrum of ideas opinions and perspectives available in the region s media Asset Management Katie Buoni P R 0 BAR SRL II Middle East Broadcasting Networks Inc 7600 Boston Blvd A Division of Springfield VA 22153 Bondurant Enterprises Inc 703 852 3861 0 9300 Annapolis Rd Ste 203 703 852 9022 F Lanham MD 20706 3140 PIDELD Professional Integration Technologies LLC Washington DC 20008 4710 Copyright 2010 Professional Integration Technologies LLC All rights reserved This document is provided for the intended recipient s informational purposes only and shall not be duplicated otherwise used or disclosed to a third party in whole or in part without the express written consent of Professional Integration Technologies LLC 1 This page contains confidential information PiTech ULC MBN INVENTORY USER MANUAL JANUARY 10 2011 Table of Contents FPOMEPAGE geese vecasancancrocisvaiaus soacconayssequrees vee E sswysdiceesycecsseis arises socea E E T 7 NAVIGATION MENU MENU BAR T 7 MODULE oer E E E A T E E E E E toneenvarseniedeooeed 7 UEA
24. Parameters from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Select any of the available listed string by clicking down arrow beside the available options like Name Screen type Table Name Lookup Field or Return Field and then click Search button to display the search results of parameters OR just click on the search button to list the entire list of parameters Edit Parameter Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Parameters from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Select any of the available listed string by clicking down arrow beside the available options like Name Screen type Table Name Lookup Field or Return Field and then click Search button to display the search results of parameters OR just click on the search button to list the entire list of parameters Step 5 Click on the parameter name which has hyperlink to edit the available options like Parameter Name Description Screen Type Length Description Field Code Field List Box Rows List Box Width Selection Mode Control ID Required Checkbox Data Type Value Data Type Repeat columns Error description Validation Expression Note Service Path Service Method Table Name Lookup Field Return Field Invalid Message
25. Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 e Add Mass Asset Items Supervisor Group This Supervisor User Group has access to all user groups like Reports Group Add Assets Group and Users Group e User Administration Module o Change Passwords o DAL Performance logs e Asset Items Module View Assets Add New Asset Items Add Update Mass Assets Asset Fields Item Disposal Item Depreciation Transfer Scan Asset Items e Custodians Module o View Custodians o Create New Custodian o Students List Import e Maintenance Module o View Categories o View Sub Categories o View Statuses o View GL Codes o View Vendor Types o View Address Types o View Contact Types o Cat SubCat Mapping o Add View Import Format o Add Update Field Mappings o Add View Vendors e Reports Module View amp Run Reports Export Reports Data Create Reports Create Edit Admin Reports Create Command Parameters Columns O gt 4 a 2 O O O O O Q G Users Group The Users Group has limited access to the different modules in the MBN application The Users group has the ability to e User Administration Module o Change Password e Asset Items Module o View Assets o Add New Asset Items 13 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL 14 o Add Mass Asset Items o Item Disposal o Item Depreciation o Transfer o Imports o Scan Asset Items Custodians o View Custodians o Add New Custodians o St
26. S escenes tarp ests stance nate ew crema ec ea eaowioeect vacin deserts quucne ca ota tect adeweosdatmaeceneaeaess 18 CS ROE rater asters A E va aeese ac E E E es eorseaes 19 POSSE TEM MODULE T 20 VS TTT 20 PSS U PCI SCAN Cll TTT 20 NEWA SETIO are er A eee 21 Aadne IW SSO dan tee Sage seis Se ccs E ee gn sec econ E 21 Ma ASS TT 22 PSS EE ING TT 23 Newa cetto m TG 23 KOD pO AU OCS e E decomu never canundecouece ane diaetdesiensesansereedeeene 24 Viewing of Asset Item eee eT 25 Adame TET T 25 Updating Mass Asset Item Disposal sss s sees seene nenen 25 PES PD SSC iO TTT 26 1 ALA TT 27 Ke NS SS HE LE 27 CUSTODIAN MOGUC ete asec cere ce ts ste dp eee se capt atc peter te E eee aaa tuck non E needa net pee eA ORs 29 NON CUS UO CI a LT 29 NOW CUOI eee crac E E E E teeter E E E E E cpen cana E ER 29 students NONE sersa enee EE E E EE E EE 30 MAINTENANCE MOQUE orrian E E EE E E EE 31 View Categories SubCategories Statuses GL Codes Vendor Types Address Types Contact Types sees eee 31 PTV CTs OU e E E E sumaneea eos acesneeeneee eestacyaaeauaoey 31 Search File IMpOrt FOr MAlo caren TS S 32 PENPO FONA a E E T 33 PEEM PINE aa E E E E A A sages aoaeearune 33 ET 8 a LF 6 ene E E ee ere ee ee ne eee eee eee meee ene 34 REPORTING Tee T 35 VOW TRE DOI Stauicoasieswnced teen news dnuwulced Gebaupee tee estcd E dia aest corsaddeans ac tensead ectn ranean reas atanees eee 35 BE OES ares es E sosniv cw capris nn ev bow veep wesee nt eae panne set E one
27. Strings screen will provide the users the ability to View Edit and Create connection string and the user has to enter the details like Connection type SQL check or uncheck the Trusted Check box Server name Database name user id User Password View Connection Strings Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Connection strings from the drop down list under the Reporting option from the menu bar at the top of the screen A list of available connection strings are shown depending upon the source selected in the section heading Source Details see figure 5 13 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset lten Custodian Maintenance Reporting Logout Source Details EEZ Middle East Broadcasting Networks Connection String Details i Figure 5 13 View Connection Strings Edit Connection Strings Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Connection strings from the drop down list under the Reporting option from the menu bar at the top of the screen A list of available connection strings are shown see figure 5 13 Step 4 Select the source under the section head Source Details and then click the connection string user intend to edit
28. User logs into MBN Inventory Step 2 Hover over the Maintenance option from the menu bar at the top of the screen Step 3 Click on Import Format under Maintenance Import Format Screen will be displayed Step 4 Click on New click in the section Heading Import Format Details Step 5 In the Next screen see figure 4 4 provide File Format Name Step 6 Select the Category Name user wish to create new import format from drop down list Step 7 Select the table Name to load the column field names into the Available Fields list box from drop down list Step 8 Add or Remove the fields from Available Fields List box to Selected Fields List box using Left and Right arrows Step 9 Sort the fields in the Selected Fields list box to the required order using Up and Down arrows Step 10 Click Save button to save the info to database or click on Clear button to clear the fields and redo the work Field Mappings This module provides the option to view delete create and map the fields to various tables See Figure 4 5 Step 1 User logs into MBN Inventory Step 2 Hover over the Maintenance option from the menu bar at the top of the screen Step 3 Click on Field Mappings under Maintenance Field Mappings Screen will be displayed Step 4 The Screen will display the field mappings for Source Destination SQL comm
29. Userid sBidg sRoom h Status hCusto ianId sBarCode sDepartment sMfgr sModeiNo sSeriasiNo sISBN dLastInventored mPurchasePrice dPODate sPONumber hCatege 11 04 2010 12 09 04 AM s Typeln Userid Bidg sRoom sBarCode sDescription sMfgr sModelNo sSenaiNo sCondition dLastinventoned 04 2010 nv 05 04 AM a da eS a 12 09 04 AM 1 04 2010 nv 09 04 AM 11 04 2010 12 09 04 AM 11 04 2010 12 09 04 AM 11 04 2010 12 09 04 AM 11 04 2010 12 09 04 AM Figure 4 3 Search File Import Formats Screen Step 1 User logs into MBN Inventory Step 2 Hover over the Maintenance option from the menu bar at the top of the screen Step 3 Click on Import Format under Maintenance Import Format Screen will be displayed Step 4 Type File format Name or Select Category or select Type of file then click on Search Button to display the search results see figure 4 3 Step 5 To view the details of the file click on the file name under the column head Name 32 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 6 To delete the File Import Format click on the trash icon user which to delete the file and click confirm on next screen whether you are sure to delete the file Yes or No File Import Formats MIDDLE EAST BROADCASTING NETWORKS INC File Import Format Figure 4 4 File Import Format Screen Step 1
30. amic Asset Fields Step 6 Click on search button in the middle of the screen below search options to display the search results New Asset Item The New Asset screen provides the users the ability to Add New Asset Items to the MBN application see Figure 2 2 The user has many options to enter the New Asset item information like Bar Code Old Tag Category Manufacturer Publisher Model Author Serial Copyright Last Inventoried Status Condition Room Custodian Student Building Location Description Title Acquisition Method Funding Source Funding Agency Program Assigned Purchaser Floor Life Span ISBN Department PO Rack Bin PO Date Purchase Price Current Value Group Controlled Quantity Total Value IT Asset GL Code Sub Category Function Notes and Comments User Administration Asset Item Custodian Maintenance Reporting Asset Item Information Pictures Asset Item Status Change History Asset Item Change History Asset Item Information manna Ane i i g Aage N d Comments A Tr Dynamic Fields No Dynamic Fields Exists Modified User Modified DateTime Figure 2 2 Adding New Asset Info Screen Adding New Asset Item User can add the New Asset item information Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click New Asset from the drop down list under
31. and and option to delete field mapping Step 5 User can Create edit the field mappings as per requirement and click on Save button to save the field mapping Step 6 If the users wish to delete the existing field mappings check the check box of the field mapping user wish to delete and click on Save button to save the new settings 33 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Field Mappings oe S Er ree gt Jes mo ion SOL Reta 3th 5 dU SS ea C s User S Rae OG Date Modified TT Select From tbl_Data nolock 11 03 2010 10 52 23 AM Table bL Dars Code id _ Description sFileName Table th _AssetDisposal v Field hFileId S vr Table tbl_AssetItems v Table ww_Custodian Select From vw_Custodian nolock a 11 03 2010 10 52 23 AM Field hCustodianId Code id m Where hType lt gt STNT Description Name v Table tbl_AssetItems Table tbl_Codes Select From tbl_Codes nolock Where Field hCategory L Code Type sCategory Category Description lt Des c nip tion T 10 52 23 AM Figure 4 5 Field Mappings Cat SubCat Mapping This module provides the option to add subcategories for various categories See Figure 4 6 User Administratio
32. as many options to enter the Mass Asset item information like Bar Code Prefix Bar Code Range To Old Tag Category Manufacturer Publisher Model Author Serial Copyright Last Inventoried Status Condition Room Custodian Student Building Location Description Title Acquisition Method Funding Source Funding Agency Program Assigned Purchaser Floor Life Soan ISBN Department PO Rack Bin PO Date Purchase Price Current Value Group Controlled Quantity Total Value IT Asset GL Code Sub Category Function Notes and Comments MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Asset Item Information Comments a Modified User Modified DateTime Save Clear Figure 2 3 Adding Mass Asset Info Screen User can add the Mass Asset item information Step 1 User logs into MBN Inventory Step 2 Hover over the Mass Item option from the menu bar at the top of the screen 22 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 3 Click Mass Asset from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 In the Asset Information section User may enter all the necessary information to fill the information like Bar Code Prefix Bar Code Range To Old Tag Category Manufacturer Publisher Model Author Serial
33. base by clicking on the Test Command button A corresponding success or error message will be displayed on the screen indicating the validity of the command e The user can save the command details by clicking on Save button This button click automatically tests the command validity 39 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 f The user can click gt gt button to go to next step of creating columns see Figure 5 7 User Administration Asset Item Custodian Maintenance Reporting Logout Report Details command Exec usp_GetAssetItemsByBarCode BarCodes j g 7 RN O OOO O OOOO O O Step 4 Select Columns olumns Bre sbarcode sdescription smfgr smodelno sserialno dlastinventoried scondition sponumber Figure 5 7 Create New Report Step 4 Create Stored Procedure Command s Report Columns Step 8 For creating the columns of the stored procedure type command report the user has the option to select column details like a User can select the various columns for the report from the available list of columns under the section head Step 4 Select Columns b The user can save the column details by clicking on Save button see Figure 5 7 40 This page contains confidential information Pliech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Frere E T RIN aT Hena ataa rz S
34. ch grid or table the page size is adjustable as a system configured parameter The user can view 20 records on the screen If there are more than 20 records the user will see paging feature described in paging module in section paging See Figure 1 4 LOGGING IN To login into the MBN Inventory Web Application make sure you have a valid username and password Once you have a valid username and password do the following See Figure 1 7 Step 1 Open Internet Explorer Step 2 In the Address bar type in the MBN Inventory management web address http www mbninventory com Step 3 Click the Go icon or press enter key on the keyboard or click h i icon to load the application Step 4 On the home page enter your username and password 10 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 MIDOLE EAST BROADCASTING NETWORKS INC User ID Powered by PITech LLC 2005 2010 All Rights Reserved Figure 1 7 User Login Page GROUPS Users are assigned to different user groups based on their functionality in the application There are five defined user groups e Administrator Group e Reports Group e Add Asset Group e Supervisor Group e User Group Default User Administrator Group The Administrator group has full access to all the modules in the MBN application The Administrator has the ability to e User Administration Module
35. d Cell Header Field Cell Footer Field Horizontal align like center or char or justify or left or not set or right and then click on save button to save the changed column details see figure 5 12 Create New Columns Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Columns from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Click on the link New in the section heading Column Details New of the columns wishes to edit 44 This page contains confidential information Pltech LLE MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 5 Enter the column details like name check or uncheck the option sortable Field Sort Expression Number Width Format Type like bound field or checkbox field or date field or Hyperlink field or image field Cell Header Field Cell Footer Field Horizontal align like center or char or justify or left or not set or right and then click on save button to save the new column details see figure 5 12 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Column Details Figure 5 12 Adding Updating Columns CONNECTIONSTRINGS The Connection
36. e 5 5 Create New Report 38 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Reports from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Click on New link in the section heading Reports List New user has to enter the details like a Report Name Description and Grip Group under the section head Report Details b Check the Private check box if the user wants to share the report with other users and groups Once the check box is checked the Roles Users list box updated with list of other users user can select name of other users by holding control Ctrl key on keyboard multiple selection of Roles Users to share the report Else do not check the Private check box in case user does not want share the report c Assign roles like Add Asset Admin Reports Supervisor and user to the reports under the section heading Assign Roles Users to Report d Header Format Header Parameters and Footer under the section heading Report Properties e Select command type under the section heading Command Details Step 5 Click on save button to save the report settings see Figure 5 5 Step 6 Click on the button gt gt
37. erformance LOgS sees eee 19 STUTI 1 E Create Roles 0 serecniensin rinane EA E EE aa 19 Foure 2 VS ASSElS creci E E rads cov manees waanoretienuiusuecariresnmacness 20 Figure 2 2 Adding New Asset Info Screen css sssss sse sese ees sese 21 Figure 2 3 Adding Mass Asset Info Screen sss sss sse ss sees sese nenen 22 Figure 2 4 Asset Field Search Screen ccs s sese sees ennenen nenen 23 Figure 2 5 New Asset Item Field Keel 24 STT aoe D a e 25 Figure 2 7 Mass kem ae 26 FSU 2 kem Dene cI e aaa E E EN 26 Peer TA TA a E E ea demise once enews deceenes 27 Feure 2 10 Scan a den 27 Feure ei O Custodians LISU seerne oe en ee ree ee EEEE eee 29 Figure 3 2 New Custodian SCl OCI eccccscescc diet tacencceasadeuundecssnaconeiieetteseasanteessuwedecsnseesct uti tsleeonseessadaearaedseaaeoned eobseveosanabesauenderen 29 FUE a adent ese e 30 Figure 4 1 View Categories Subcategories Status File Types GL Codes Vendor Type Contact Type Address Type 31 Figure 4 2 Import Format Screen VIEW esse ee eee ee eee eee eee 32 Figure 4 3 Search File Import Seve 32 Feure 4 4 File T sied Fonna SC NCC Ni EE E noneatansetanoacanesasecs 33 Feur a STV ere TTT 34 Figure 4 6 Category Subcategory Mappings sese ee eee eee ee eee eee 34 Pae AA ROOFS ES TTT 35 Foie ee 45H a 016 RE U he ene ee nn E nee een ee er ee eee 36 Fieure R eTii Edit Screemol REDONIS eee nena a E eon ee ee eee 37 PICUKE 54 Edit Screen OF sela esasen EE a ai 38 Figure 5 5
38. es Vendor Types Address Types Contact Types The View Categories screen will provide the users the ability to View and create Description like category types for Address Type Category Contact Type Country Custodian File Types GL Codes State Status Sub Category and Vendor Type see Figure 4 1 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Codes eee catego AV T 0 ser col Communion SC CLO ae Category pc Desktop Computer RRR 12 08 02 AM Category EQPT Equipment fl t 11 04 2010 12 09 02 AM Category FURN Furniture m li 11 04 2010 12 09 02 AM Ran cc Group Controlled D SN Ee oe Categor OEQRT office Equipment Catagory e pereme T Category Pc Portable Computer S F t ERRER Case lear peer OO H a Category TB Taxt Books m li 11 04 2010 12 09 02 AM i aoc a Sect Tasta aze id A TU B T T T IT sd V U H Figure 4 1 View Categories Subcategories Status File Types GL Codes Vendor Type Contact Type Address Type Step 1 User logs into MBN Inventory Step 2 Hover over the Maintenance option from the menu bar at the top of the screen Step 3 Click View Categories or View Sub Categories or View Statuses or View GL Codes or View Vendor Types or View Address Types or View Contact Types fr
39. et Item option from the menu bar at the top of the screen Step 3 Click Item Disposal from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 User will get a New Report button below section heading Click on the New Report button to add the item disposal information Step 5 A drop down list for Bar Code will appear click on down arrow to select the bar code from the existing list of bar code numbers or directly type the bar code number and click on add button Step 6 Next screen will show the Asset Item information which is under Asset Item Disposal Details Step 7 Click on w symbol beside close button to open Property Disposal Form in MS word application where the user has to proceed with the procedure related to Property disposal by taking the approval of necessary department heads like Manager Head Facilities etc for maintaining the record Step 8 Click on Update button to update the Asset item to the list of Item Disposal or close to cancel the operation Updating Mass Asset Item Disposal User can dispose of multiple Asset items by performing following steps Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click View Assets from the drop down list under the Asset Item option from the menu bar at the t
40. fidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 ASSET ITEM MODULE This module provides the ability to View Assets Adding New Asset Items Mass Assets Asset Fields Item Disposal Item Depreciation Transfer and Scan Asset Items View Assets The View Assets screen provides the users the ability to search for Asset Items of the MBN application see Figure 2 1 The user has many options to search the Asset items by providing various keywords under different available options like Bar Code Description Title Category Sub Category Manufacturer Publisher Model Author Serial Last Inventoried Status Condition Room Custodian Student PO PO Date Purchase Price Acquisition Method Funding Source Funding Agency Program Assigned Purchaser Floor Department GL Codes and ISBN User Administration Assetltem Custodian Maintenance Reporting Logout Asset Item Search Dynamic Fields ee 1 B R EA 7 asse e soe L oan e E dae satie Figure 2 1 View Assets The user can search the MBN database for required Asset Item information by various ways Either by selecting a value from the drop down list by clicking on the down arrow image or directly entering the text in the text box of the selected field The user can then click on search button in the screen and it will display a list of Asset items User can also search the information without entering any informati
41. he Asset item from the list of Drop down box or directly type the barcode and click on add button Step 5 The Transfer Asset item information is displayed in table format click the radio button beside student if you wish to transfer the item to student if you wish to transfer to teacher then click on the teacher radio button and select the person that these asset items are going to be transferred Step 6 To view the Transfer Asset item information user can click on the barcode link drill down under the asset tag column to view the detailed information of the Transfer Asset Item Step 7 Click on Update button to complete the transfer Scan Asset Items The Scan Asset Items screen provides the users the ability to upload the scanned Asset items file see Figure 2 10 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Scanned Asset Items Comma Ka Figure 2 10 Scan Asset Items Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click Scan Asset Items from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 Click on Browse button select the student file and click on ok Step 5 Select file Upload Format and Select the Text Delimiter options if the uploading file has the Comma p
42. ill be sent to his email address on file Deleting a User s Profile Step 1 Click on the Delete icon 3 on the far right hand side of the User profile to delete Step 2 Click the OK button on the pop up window DAL Performance Log The Administrator Group has the ability to work on DAL Data Access Layer Performance Logs Summary and Reports information See Figure 1 12 User Administration Assetitem Custodian Maintenance Reporting Logout an emaor F arzao E 24 a 200 S 7 tar Pano A 7 eas foso 7 9 951 jo os4j0 015 l 2 9 067 fp o739 015 a HA 9 059 0 078 0 052 9 915 RER Z EES ee d Figure 1 12 Data Access Layer DAL Performance Log Summary Step 1 Administrator logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click DAL Performance Log from the drop down list under the User Administration option from the menu bar at the top of the screen View the DAL Performance Log The Administrator user group can view the DAL performance log of the function user wish to intend to view the logs See Figure 1 13 Step 1 Administrator logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click DAL Performance Log from the drop down list under the
43. ing the respective icons on the report see figure 5 2 User can also view the run report history MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Asset Item by Building and Room Report Clear lt q ft le js ption l de l e So T stinve s f an spon oe sto 1 meee E a 4 Katie s Office ii1i1 IP Phone Cisco 7960 _XX11XX22XX33 11 5 2010 12 00 00 AMGood Employee Comission Communications aa en r PI p a aE f ee T D rn N lrn T Dk a a Enter Log Parameters n Log Comments ha Report Run History Ke ny Ses SS Cor N E CER U aa f G SI ORE BO q oer VOMMEnEtE _ o Paramerer ES 10 25 2010 707115 AM 0 bIdgQ FRANCIS HAMMOND 1 room OZ 2 O 10 25 2010 4 57 15 AM bldg GEORGE WASHINGTON 2 room 10 25 2010 3 58 59 AM bldg BLOW PIERCE rocm Figure 5 2 Run Report Results Admin Edit Only Administrator Users can Admin Edit the Report Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Reports from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Reports list is displayed with the options to Run Admin Edit Edit and delete report Click on Admin Edit pen symbol option to edit the details like a Report Name Description T
44. inistration Asset Item Custodian Maintenance Reporting Logout lee AAAS Bie Seati File Import Formats Import Format Details Figure 4 2 Import Format Screen view Step 1 User logs into MBN Inventory Step 2 Hover over the Maintenance option from the menu bar at the top of the screen Step 3 Click on Import Format under Maintenance Import Format Screen will be displayed see figure 4 2 Search File Import Formats MIDDLE EAST BROADCASTING NETWORKS INC User Administration Assetitem Custodian Maintenance Reporting Logout Search File Import Formats Import Format Details ied Mod rag Userld sBarCode sDescription Taa hStatus sRoom sBidg I aiea hCustodianl4 aPODate a 12 39 48 AM tol_Assetltems Typeln Userid sMfgr sDescription sRoom sOldTag hCategory hStatus hCustodianid sFicor sRack Hardware 12 09 04 AM ac Typeln Userid sBidg sRoom sBarCods sDescription sM for sModeiNo sSenaiNo dLastinventoried hStatus sFundingSource sFundingAgency Text Books Se Userid sBidg sRoom sBarCode sDescription sMfgr sModelNo sSeriaiNo ISBN dLastinventoned sFundingSource sFundingAgency 1 C Customer Default Audic Visual S CE R T G a P 12 05 04 AM NEV E peman items Typein Userld sBidg sRoom sBarCode sDescription sMfgr sModelNo sSeralNo dLastinventored hStatus sFundingSource sFundingAgency R S 12 09 04 AM iter Qudic Visus Sca tdi Asset 5 Typeln
45. ipe Semi column and Tab Step 6 Click the checkbox if the uploading file has the header in the First row 27 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 7 Click on Add File button to add the students list to MBN Inventory 28 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 CUSTODIAN Module This module provides the ability to View Custodians create New Custodians and import Students information file View Custodians The Custodians Screen provides the users the ability to view the list of custodians see Figure 3 1 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Custodian Search Total Records 2 _ Type EL ae a ee ee a 18 FICS HRE eee ea _ Emplovee Comission employee Hatrs Student Mr 1123465 Student Student m CONE Figure 3 1 Custodians List Step 1 User logs into MBN Inventory Step 2 Hover over the Custodian option from the menu bar at the top of the screen Step 3 Click View Custodians from the drop down list under the Custodians option from the menu bar at the top of the screen Step 4 User will have the options to search the custodians either by their Last Name First Name or by Type Teacher or student Else user can leave all the fields
46. lear button to clear all the fields which are entered Students Import The Students Import screen will provide the users the ability to import the list of students into the MBN Inventory see Figure 3 3 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Students File Customer_Default eS G Figure 3 3 Students Import Step 1 User logs into MBN Inventory Step 2 Hover over the Custodian option from the menu bar at the top of the screen Step 3 Click Students Import from the drop down list under the Custodian option from the menu bar at the top of the screen Step 4 Click on Browse button select the student file and click on ok Step 5 Select file Upload Format and Select the Text Delimiter options if the uploading file has the Comma pipe Semi column and Tab Step 6 Click the checkbox if the uploading file has the header in the First row Step 7 Click on Add File button to add the students list to MBN Inventory 30 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 MAINTENANCE Module This module provides the ability to View Categories View Sub Categories View Statuses View GL Codes View Vendor Types View Address Types View Contact Types Import Format Field Mappings and Vendors View Categories SubCategories Statuses GL Cod
47. llowing sections will provide additional information on how to use these features N E f L PS E 5 ss X S d N X NAD D A V CD Ee A T 4 esl A D A Breadcrumb See Figure 1 2 gives users a way to track their location within the MBN Web Application the user will see a breadcrumb on every screen The breadcrumb will change based on the screen user has navigated User Administration Assetltem Custodian Maintenance Reporting Logout TTS T SAT Er oe f 7 gt iT Ai sets pet et rete rs te gt Asset Item Search Figure 1 2 Breadcrumb x TN A G D N t N j L SECTION HEA Section Headings divide the information on the screen The section headings will assist the user to determine what information is currently being viewed A Section heading is displayed as a red bar See Figure 1 3 8 This page contains confidential information Pittech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 User Administration Asset Item Custodian Maintenance Reporting Logout sian Up for New Account Assign a Role to the User es n Supervisor User Last Name First Name Employee Department Office Phone Figure 1 3 Section Headings PAGING After the user conducts a search or view information that spans to additional pages the user can page through the results By clicking on the page number See Figure 1 4 the user can view
48. n Adding Assets Viewing Assets Disposal Custodian Maintenance and Reports The MBN Inventory consists of five modules see Figure 1 1 The modules are used to navigate thru the application from creating a user account to the asset entry asset viewing custodian maintenance and asset reports MIDOLE EAST l S BROADCASTING l NETWORKS INC Jser Administration Assetltem Custodian Maintenance Reporting Figure 1 1 Five Modules in the Menu Bar User Administration e Create User e Update User e Change Password e User Search e DAL Performance Log e Create Role Asset Item e View Assets e New Asset e Mass Assets e Asset Fields e Item Disposal e Item Depreciation e Transfer e Scan Asset Items 7 This page contains confidential information PiTech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Custodian e View Custodians e New Custodian e Students Import Maintenance e View Categories Subcategories Statuses GL Codes Vendor Types Address Types Contact Types e Cat SubCat Mapping e Import Format e Field Mappings e Vendors Reporting e Reports e Parameters e Columns e Connection Strings SCREEN LAYOUT The MBN Inventory Web Application has several user friendly features to assist the user in navigating and selecting information within the system These features are called as breadcrumbs paging section headings sorting drilling down as well as search results page sizing The fo
49. n Assetltem Custodian Maintenance Reporting Logout Category Figure 4 6 Category Subcategory Mappings 34 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 REPORTING Module The Reporting module is used for creating and running various reports by users of MBN Inventory This module provides the ability to a View Edit and Create Reports b View Edit and Create Parameters c View Edit and Create Report columns d View Edit and Create New Connection Strings View Reports The Report List screen will provide the users the ability to Run Admin Edit Edit and delete reports list However only the Admin Group Users will have the access for Admin Edit Edit and Delete options see Figure 5 1 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Reports List x Es ben KALA Je Sx s ee Generic Repor Generic Report 10 25 2010 4 16 14 AM 10 25 2010 4 08 35 AM 8 16 2010 6 28 57 AM Sen EFR ER E sae ey Asset Item by Building and Room Admin Reports User Assets by GLCode Admin Reports User Assets by PO Status Asset Tag Date Admin Reports User Acquisition K K 1 HO LA p eE O28 08 Generic Report Book by Title Admin Reports User 9 13 2010 8 02 23 AM IEIZ Generic Report Books by Location Admin Reports User
50. om the drop down list under the Maintenance option from the menu bar at the top of the screen Step 4 The information related to Category or Sub Category or Statuses or GL Codes or Vendor Types or Address Types or Contact Types is displayed in table format according to the option selected and user can delete the existing Category or add a new Category Step 5 If the user wants to delete one of the Category or Sub Category or Statuses or GL Codes or Vendor Types or Address Types or Contact Types type click on check box to check the option beside the category or Statuses or GL Codes or Vendor Types or Address Types or Contact Types type user wish to delete and click on Save button at the bottom of the table Step 6 To create a new Category or Sub Category or Statuses or GL Codes or Vendor Types or Address Types or Contact Types enter new information in the blank fields of Type and Description and click on Save button at the bottom of the table Import Format This module provides the option to view delete and create Import Format using fields of various tables See Figure 4 2 31 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 MIDDLE EAST BROADCASTING NETWORKS INC User Adm
51. on in the available search option boxes and by clicking search button the system will display the entire list of Asset items The user also has the ability to select the individual asset items for Mass Update or Mass Disposal Asset Item search User can search the Asset item information with the following steps Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click View Assets from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 Click on down arrow beside the box of Bar Code or Description Title or Category or Sub Category or Manufacturer Publisher or Model Author or Serial or Last Inventoried or Status or Condition or Room or Custodian or Student or PO or PO Date or Purchase Price or Acquisition Method or Funding Source or Funding Agency or Program Assigned or Purchaser or Floor or Department or GL Codes or 20 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 ISBN to select the text from the existing list or directly type the text in the drop down box and select the date where ever there is an option to select the date from the pop up calendar Step 5 Enter values in the Dyn
52. op of the screen Step 4 Click on down arrow beside the box of Bar Code or Description Title or Category or Sub Category or Manufacturer Publisher or Model Author or Serial or Last Inventoried or Status or Condition or Room or Custodian or Student or PO or PO Date or Purchase Price or Acquisition Method or Funding 25 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Source or Funding Agency or Program Assigned or Purchaser or Floor or Department or GL Codes or ISBN to select the text from the existing list or directly type the text in the drop down box and select the date where ever there is an option to select the date from the pop up calendar Step 5 Enter values in the Dynamic Asset Fields Step 6 Click on search button in the middle of the screen below search options to display the search results Step 7 Click on the checkbox next to each of the asset items that needs to be selected for mass disposal Step 8 Click on the Mass Disposal button Step 9 the system redirects to the Mass Item Disposal screen see Figure 2 7 User Administration Asset Item Custodian Maintenance Reporting Logout Add Asset Item Disposal 200004 iy Asset Item Details csset Taa 200449 zoss LAMINATING MACHINE S mas ooog a
53. rovides the users the ability to Track and add the Items Disposal in the MBN application see Figure 2 6 24 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset litem Custodian Maintenance Reporting Logout Asset Item Disposal List Figure 2 6 Item Disposal Viewing of Asset Item Disposal User can view the Asset item disposal information by performing following steps Step 1 User logs into MBN Inventory Step 2 Hover over the Asset Item option from the menu bar at the top of the screen Step 3 Click Item Disposal from the drop down list under the Asset Item option from the menu bar at the top of the screen Step 4 User will get a link under the head ID and number of items disposal under count Click on the link to view the item disposal information in detail Step 5 Item disposable information is shown in table format with the headings Asset Tag Description Status Model Number Serial Number Date Acquired and Book Value Every item disposal will have a link drill down under the head Asset tag click the link to see the detailed information of the item in the item disposal list Adding Item Disposal User can add the Asset item disposal information by performing following steps Step 1 User logs into MBN Inventory Step 2 Hover over the Ass
54. rt Details SQL Details and create New SQL Details Report Properties assign Roles to Report and Edit amp add new columns Only Admin Group Users can perform this task c Edit option Zh is shown with pencil symbol This Edit option is used to edit the Report Details Assign Roles to Report Report properties and command details Only Admin Group Users can perform this task d Delete option I is shown with trash icon symbol This delete option is used to delete the report selected Only Admin Group Users can perform this task Run Reports A Report user or Administrator Users can run the Report Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Reports from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Reports list is displayed with the options to Run Admin Edit Edit and delete report 35 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 5 Click on run E magnifying glass icon option to execute the report Step 6 Enter search criteria like Building and Room and click Submit User can also enter the Log Parameters Step 7 Review the results grid for the information based on the search criteria E Step 8 Export the results to PDF amp Excel IS or HTML 8 by click
55. s ea ea ease 35 3 This page contains confidential information PITech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Admin Ed 98 Sola TTT 37 DY ue sela gee meen eee ote A E oS ee eC eC eR ee E ae eee eee 38 A TSS TTT 38 PARAMETER so sori acesirpe ceo os ccs g ve coin E E E T aientee cs 42 ECU eh US T 42 NOW FP IN aN Ce T 43 COLUNN gcse cca acaneqarnensnnsctea E E 44 Qie a oo O18 a8 OUNI eee 44 Se Ree deel T 44 FEEN COMNIE raises E EEE E O E E 44 CONNECTIONSTRING S sioireisssne T T T 45 VEW C ONNE CUON pT 45 Edt CONNECCION SNE erana e E E EEEE EEE 45 Create New Connection SUriNg cccscccseccseccseccseccseeceeceuscoseceuecescceuscesecesecesscesecesecsseceaeesaeetaeetseetaeetaeeteetseteeeseeeseetseees 45 4 This page contains confidential information PITech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Table of Figures Fig re 1 1 Five Modules in the Menu gt T 7 STATI e Bread imn essesi EE EE 8 Fure Lom SEC HON lt e T 9 Pewee LAR e E EE 9 STP eT Dita Mouch heade Soriana E E A 9 Figure 1 6 Drilling down Data on Barcode number Link sss sese sees eee eee eee eee 10 Feure Ser Logn TT 11 Fle Oe L reste NEW USEI eren E toned eneactnit natorandimetentennaeadions 15 STTS R Bee e U E E E E E EE A EEE 16 Figure 1 10 Change Password Ka 16 Powe R N RE er e e E E E E A A E 17 Figure 1 12 Data Access Layer DAL Performance Log Summary sese eee eee eee ee eee 18 Figure 1 13 View Data Access Layer DAL P
56. s enter the details like Parameter Name Description Screen Type Length Description Field Code Field List Box Rows List Box Width Selection Mode Control ID Required Checkbox Data Type Value Data Type Repeat columns Error description Validation Expression Note Service Path Service Method Table Name Lookup Field Return Field Invalid Message Event Trigger Function call Connection String and SQL command as shown in Figure 5 10 and click on save to create Parameter 43 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 COLUMNS The Columns screen will provide the users the ability to view the column details report wise and create new columns for the existing reports see Figure 5 11 MIDOLE EAST BROADCASTING NETWORKS INC User Administration Asset Item Custodian Maintenance Reporting Logout Report Details t Asset Item by Building and Room Column Details 2 BI HE sroom sroom ASC sbarcode ASC sbarcode sdescription BoundField smfgr S smodelno smodelno BoundField sserialno sserialno BoundField H dastinventoried B scondition scondition scondition ASC BoundField z j sponumber sponumber sponumber ASC BoundField 3 custodianname custodianname custodianname ASC BoundField 10 E category category category ASC BoundField 11 3 Figure 5 11 List of Report
57. t The Administrator users are able to determine if a particular user is currently online locked out of the application or verify their last logged info into the application Step 1 Administrator user logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click User Search from the drop down list under the Administration option from the menu bar at the top of the screen Click on Search button to display the user search information If the user account is locked click the a icon to unlock the account How to Change User s Role Step 1 Click on pencil icon 7 on the far right hand side of the user to change the role Step 2 Select the new role from the list box in the Update the Role of the User list for the user to change the role Step 3 Click the Update button on the Bottom Right hand side of the screen How to Reset User s Password Step 1 Click on the undo arrow wd on the far right hand side of the User to reset the password 17 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 Step 2 Click the OK button on the pop up window Step 3 Changed password will be displayed below section heading User Search Information with the message new password for the user xxxxx user name is yyyyy password an email also w
58. the additional information The page numbers will be displayed at the bottom of the results screen Figure 1 4 Paging Any column heading in a grid that has a hyperlink can be sorted See Figure 1 5 To sort by a particular column heading use the following instructions 1 Determine which column heading user would like to be sorted 2 Click once on the desired column title header to sort data User Administration Asset Item Custodian Maintenance Reporting Logout Reports List 3 N T Acce v SS Generic Report Asset Item by Building and Room Admin Reports User 9 13 2010 7 41 43 AM Figure 1 5 Sorting Data through headers Selected data in each grid can be drilled down if additional information is available for a particular field See Figure 1 6 A hyperlink on a particular field will signify additional data is available for that item 9 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 a Determine the field on which user want to drill down to view the information b Click on the particular hyperlink within the grid to view additional information d paana IES LZ Sea PG a CSc as T E HES N T OD ee amet Z ees T TiD Communications MBNHQ Katie s Office 2 P phone Cisco 7960 XX11XX22XX33 Figure 1 6 Drilling down Data on Barcode number Link PAGE SIZE By default there are 20 twenty records displayed on ea
59. udents Import Maintenance Module O Add View Import Format Reports Module O O O O View Report List Create Report View and Run Report Export Report This page contains confidential information JANUARY 10 201 1 PiTech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 USER ADMINISTRATION MODULE The User Administration module is used by the MBN administrator group This module provides the administrators the ability to create new user profiles update user profiles change passwords search amp view user profiles DAL Performance Logs and create Roles In addition the administrators are also able to assign departments working for and change user security access levels which control which screens they can view Create User The Create User screen provides the administrative users the ability to create new users for the MBN application see Figure 1 8 MIDDLE EAST BROADCASTING NETWORKS INC User Administration Asset lten Custodian Maintenance Reporting Logout Sign Up for New Account Assign a Role to the User AddAsset Admin Reports Supervisor User User Information Create User Figure 1 8 Create New User Step 1 Administrator logs into MBN Inventory Step 2 Hover over the User Administration option from the menu bar at the top of the screen Step 3 Click Create User from the drop down list under the User Administration option from the
60. uncheck the option sortable Field Sort Expression Number Width Format Type like bound field or checkbox field or date field or hyperlink field or image field Cell Header Field Cell Footer Field Horizontal align like center or char or justify or left or not set or right and save the new column details Delete columns if required by clicking the trash icon Return to main page Step 5 Click on save button to save the Admin Edit report settings see Figure 5 3 MIDOLE EAST a T cal sd af af al aff a a al cal a J j Figure 5 3 Admin Edit Screen of Reports Edit Reports Only Administrator User can edit the Report Step 1 User logs into MBN Inventory Step 2 Hover over the Reporting option from the menu bar at the top of the screen Step 3 Click Reports from the drop down list under the Reporting option from the menu bar at the top of the screen Step 4 Reports list is displayed with the options to Run Admin Edit Edit and delete report Click on Edit pencil symbol option to edit the details of the report This functionality is similar to the create report functionality see figure 5 4 37 This page contains confidential information PIiTech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 BROADCASTING NETWORKS INC User Administration Asset term Custodian Maintenance Reporting Logout
61. ype Sort Expression Grid Group and upload the file with Report URL are under the section head Report Details also user can check the option Save to DB and click Generate Report URL button b Header Format Header Parameters and Footer are under the section heading Report Properties a Assign roles like Add Asset Admin Reports Supervisor and user to the reports are under the section heading Assign Roles Users to Report with the option to check Private Report Check the Private check box if the user wants to share the report with other users and groups Once the check box is checked the Roles Users list box updated with list of other users user can select name of other users by holding control Ctrl key on keyboard multiple selection of Roles Users to share the report Else do not check the Private check box in case user does not want share the report 36 This page contains confidential information Pitech LLC MBN INVENTORY USER MANUAL JANUARY 10 2011 c SQLcommand under the section heading SQL Details click on the SQL command link to edit the command edit the details test the command and save the command or delete the command Delete SQL details if required by clicking the trash icon d Edit the column details under the section heading Columns New by clicking the column name OR click on New link in this section heading to create new columns like name check or

ACPS Training Manual - Automated Inventory Support System

Contents

Download Pdf Manuals

Related Search

Related Contents