Feasibility Rationale Description (FRD) Template
Contents
1. O 2 Figure o 1 Ne User Management Dag 3 Figure 4 The Add new user button on the User Management 3 Figure 5 The Add new user page The password requirements and password strength indicators help guide you to Selectile DASSW OVC 4 Figure 6 The User Management page with Remove button highlighted eese nnns 4 Figure 7 A message box prevents accidentally deleting a user 4 Figure 8 The User Management page with Change Password button highlighted esses b Fipureg 9c SCI rt peau ts ovest oe doc EI b Figure 10 Garden Management page with pagination highlighted cesses 6 Figure 11 Clicking the header of any column will sort the table by that column eese 6 Figure 12 Filter the contents of the table with the search feature eese essen nnns 7 Figure 13 A message is shown if no matches were found for the provided search criteria ecce 7 Figure 14 The Add new garden row at the bottom of the Garden Management page essere 8 Figure 15 The Edit Row button on the Garden Management page eene eene nennen essen nnns 8 Figure 16 The save changes and cancel changes buttons after starting to edit a garden record 8 Figure 17 The2. The Logout button UM IOC2 S12b_T13_V2 0 docx 2 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 3 Manage Users 1 Login to the system as an Administrator 2 Navigate to the User Management tab Add new database manager admin Administrator eee Database Manager gardener Database Manager test Database Manager user mac Database Manager p Figure 3 The User Management page 2 1 4 Add New User 1 Click Add new database manager Garden Management Generate Report User Management admin Administrator gardener Database Manager test manager Database Manager Qe cm Figure 4 The Add new user button on the User Management page 2 Add User Name and Password a Password requirements minimum of 8 characters and must contain at least one special character 3 Select User Type from the dropdown box UM IOC2 S12b_T13_V2 0 docx 3 Version Date 4 15 2012 User Manual UM Template Version 2 0 Create new user Password rules minimum 8 characters Confirm Password must contain at least one special character User Type Database Manager Create User Cancel Figure 5 The Add new user page The password requirements and password strength indicators help guide you to selecting a strong password 4 Click Create User to add the user to the system 2 1 5 Delete User 1 Click Remove next to the user account you wish to delete User Management Ad
3. and Run Package Indicate whether to save the 5515 package Iw Aun immediately Save 5515 Package f SOL Server File system Package protection level Encrypt sensitive data with user key Password Retype password Help EN Neo s gt PW E 12 Click Finish UM IOC2 5126 T13 V2 0 docx 22 Version Date 4 15 2012 User Manual UM Template Version 2 0 E SOL Server Import and Export Wizard El Complete the Wizard 2 V erfy the choices made inthe wizard and click Finish Click Finish to perform the following actions Source Location VIMN BOKITIEATSHLU Source Provider SLNCLITU Destination Location C LT serssteam s Desktop4CG arden INFO Data 201203 xls Destination Provider Microsoft Jet OLEDE 4 0 Copy rows from dbo BARDEM INFO to GS amp ADEN_ INFO The new target table will be created The package will nat be saved The package will be run immediately Provider mapping c Pragram Files x86 Micrasott SQL ServerslU0 D T S MappinaF iles SMS SlT oett ML Help lt Back gt Finish Cancel 2 13 If the successful window shows up the data are successfully exported into excel file UM IOC2 S12b_T13_V2 0 docx 33 Version Date 4 15 2012 User Manual UM Template Version 2 0 BB SOL Server Import and Export Wizard ET The execution was successtul 11 Total Error Succes 10 Success 1 Warning Details Act
4. i3 Q Garden Name Street Address City Community State ZIP Lat pr Figure 12 Filter the contents of the table with the search feature gardens were found Figure 13 A message is shown if no matches were found for the provided search criteria 3 Click the Clear Search button to once again view all available garden information UM IOC2 S12b_T13_V2 0 docx 7 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 10 Add New Garden Record Scroll to the bottom of the table on the Garden Management page Enter all relevant information in the bottom row of textboxes a The following fields are required for adding a new garden Garden Name Street Address City Community State Zip Lat and Long 3 Click the blue floppy disk icon save button to add the new garden to the database a Error conditions 4 Click the red X icon cancel button to clear all fields in the insert row gt me d FA Columbia Park 4045 190th Street Torrance CA 90504 33 86323 Community Garden 111 Dus Address City CPU EE 4 12345078 Figure 14 The Add new garden row at the bottom of the Garden Management page 2 1 11 Update an existing Garden Record 1 Click the pencil icon edit button next to the garden record you want to update mm mm e san Figure 15 The Edit Row button the Garden Management page 2 Make your desired changes 3 Cl
5. 9 Click Next UM IOC2 S12b_T13_V2 0 docx 18 Version Date 4 15 2012 User Manual UM Template Version 2 0 A SOL Server Import and Export Wizard Review Data Type Mapping E 4 Select table to review how its data types map to those in the destination Also select how the wizard handles conversion sues T able Snurce V CBARDEN INFO Destination _1 dba B amp RDEM INFO gt Data type mapping c Source Column Source Destination Co Destination Ty Convert On Error i GARDEN ID Double 34HDEM ID int Use Global JX _ LonaT ext GARDEN_NA varchar Use Global d LATITUDE Double LATITUDE d LONGITUDE Double LONGITUDE AN STREET AD LongT ext STREET AD varchar Use Global AN LITY LongT ext LITY varchar Use Global AN STATE Varlhar STATE char Use 4 H view conversion details double click the row that cantains the column source type to be converted mmm Next gt Em gt Pme E Error global Truncation global Help 10 Click Next UM IOC2 S12b_T13_V2 0 docx 19 Version Date 4 15 2012 User Manual UM Template Version 2 0 m SOL Server Import and Export Wizard OR gt lt and Run Package Indicate whether to save the 5515 package Iw Aun immediately Save 5515 Package f SOL Server File system Package protecti
6. Authentication C Use SUL Server Authentication User name Password Database ComrmunityG ardens Refresh mm Neo ER P E 5 Data destination chooses Microsoft Excel and browse data file path gt Click Next UM IOC2 5126 T13 V2 0 docx 25 Version Date 4 15 2012 User Manual UM Template Version 2 0 SQL Server Import and Export Wizard x Choose a Destination Specify where to copy data to Destination Excel connection settings Excel file path Esu sers team 3D esktoprCG arden INFO Data 201209 ls Browse Excel version Microsoft Excel 97 2003 vw First row has column names EN Neo ENT PW E 6 Click Next UM IOC2 5126 T13 V2 0 docx 26 Version Date 4 15 2012 User Manual UM Template Version 2 0 BB SOL Server Import and Export Wizard opecity I able Copy or Query Specify whether to copy one more tables and views orto copy the results of query from the data source Copy data from one or more tables or view s Use this option to copy all the data from the existing tables or views in the source database C Write query to specify the data to transfer Use this option to write an SOL query to manipulate to restrict the source data for the copy operation Help lt Back Neo Emeh gt Cancel 2 7 Select source dbo GARDEN INFOJ and click Edit Mappings UM IOC2
7. Transaction Logs Generate Scripts Extract Data tier Application Register as Data tier Application Server Objects Import Data Management B SQL Server Agent Copy Database Manage Database Encryption 3 Import and Export Wizard window shows up and click Next UM IOC2 S12b_T13_V2 0 docx 23 Version Date 4 15 2012 User Manual UM Template Version 2 0 BB SOL Server Import and Export Wizard OF x Welcome to SQL Server Import and Export Wizard This wizard helps you to create simple packages that import and export data between many popular data formats including databases spreadsheets and text The wizard can also create the destination database and the tables into which the data ts inserted To move copy databases and ther objects from one server Instance to another cancel this wizard and use the Copy Database Wizard instead The Copy Database Wizard 15 available in SOL Server Management Studia Do not show this starting page again Help Peet Neo ERST E 4 Choose source SQL Server and database CommunityGardens gt Click Next UM IOC2 S12b_T13_V2 0 docx 24 Version Date 4 15 2012 User Manual UM Template Version 2 0 SQL Server Import and Export Wizard __ Choose Data Source Select the source from which to copy data Data source Server N 5OKIJIZJSHO Authentication Use Windows
8. permanently delete record button on the Garden Management 9 Figure 18 There is a confirmation dialog before a garden record is permanently deleted ccce 9 Figure 19 Ihe Generate Report 10 Figure 20 Customize the column order in the excel report by selecting individual fields to report on and changing their display order with the Up Down buttons nneneee sees sess esse nennen 11 Figure 21 The Open Save dialog FireFox once the Generate Report button has been clicked 11 UM IOC2 S12b TI13 V2 0 docx 1V Version Date 4 15 2012 User Manual UM Template Version 2 0 1 Introduction 1 1 System Overview The Community Garden Inventory and Locator website has been designed for use by the LANLT and related organizations to facilitate access and updating of Los Angeles Country garden information The system serves to replace the current Community Garden Inventory Worksheet with a centralized database accessible via the internet which is maintainable directly by LACGC LANLT UCCE and LACC staff The system supports insertion updating searching and sorting of information in the database as well as the ability to export customized reports Finally a public facing front end provides access to search through basic garden information find gardens based on location and export PDF reports This user manual is intended for use by various LANLT or
9. shows up and click Next Version 2 0 UM IOC2 S12b_T13_V2 0 docx Version Date 4 15 2012 User Manual UM Template Version 2 0 BB SOL Server Import and Export Wizard OF x Welcome to SQL Server Import and Export Wizard This wizard helps you to create simple packages that import and export data between many popular data formats including databases spreadsheets and text The wizard can also create the destination database and the tables into which the data ts inserted To move copy databases and ther objects from one server Instance to another cancel this wizard and use the Copy Database Wizard instead The Copy Database Wizard 15 available in SOL Server Management Studia Do not show this starting page again Help Peet Neo ERST E 4 Data source choose Microsoft Excel and browse data file path gt Click Next UM IOC2 S12b_T13_V2 0 docx 13 Version Date 4 15 2012 User Manual UM Template Version 2 0 SOL Server Import and Export Wizard OF x Choose a Data Source Select the source fram which to copy data Data source 2 Microsoft Excel Excel connection settings Excel file path C Users team 3 Desktop CGarden_INFO_Data_201203 xls Excel version Microsoft Excel 97 2003 vw First row has column names Help lt Back M ext gt Emish gt gt Cancel E 5 Choose destination SQL Server and database CommunityGardens
10. 5126 T13 V2 0 docx 27 Version Date 4 15 2012 User Manual UM Template Version 2 0 Bm SOL Server Import and Export Wizard Select Source Tables and Views E Choose one or more tables and views to T JA 4 i Tables and views Source Destination 1 dbo aspnet_Applications 4 dbo aspnet_Membership 4 dba aspnet Roles 4 dbo aspnet_Schemaersions 4 dbo aspnet_U ers 4 dbo aspnet_LeerslnRoles a dbo GARDEN_EXTRA_COLUMN dba BARDEM EXTRA COLUMN DATA 1 dba B amp RDEM EXTRA iv 955 GARDEN_INFO GARDEN INFO 1 dba sesdiagrams dbo USER_INFO dbo vi aspnet Applications dbo vw aspnet MembershipLI sers dba vw aspnet dba vw aspnet LI sers m dba vw aspnet LUserslnAoles Edit Mappings Preview Help Back Neo Emish Cancel 22 8 If destination excel is a new file please make sure to ignore TimeStamp and then click gt click Next UM IOC2 S12b_T13_V2 0 docx 28 Version Date 4 15 2012 User Manual UM Template Version 2 0 Column Mappings Sel SOU 965 BARDEM IMFL Destination GEARDEN INFO Create destination table Edit SUL C Delete rows in destination table Drop and re create destination table C Append rows to the destination table Mappings Source Destination Type Mullable Siz
11. H STATE amp 5 LonaTest NOTES NOTES LongT ext Timestamp Ignore Source column 10 Click Next UM IOC2 S12b_T13_V2 0 docx I34RDEN ID int NULL Cancel 2 30 Version Date 4 15 2012 User Manual UM Template Version 2 0 i SOL Server Import and Export Wizard i EHI Heview Data Mapping m Select a table to review how its data map to those in the destination Also select how the wizard handles conversion sues T able Source rn dba GARDEN INFO 4 Data type mapping Destination GARDEN INFO a Na I Source Column Source Type Destination Destination Ty Convert On Error g GARARDEN_ID int I34HDEM ID Long GARDEM varchar GARDEM MA LongTest Use Global d LATITUDE LATITUDE Double LONGITUDE LONGITUDE Double P STREET 0 varchar STREET AD LongT ext Use Global p CITY COMM varchar CITY COMM LangTest Use Global AN STATE char STATE V arC har Use 4 To view conversion details double click the row that contains the column source type to be converted Error global Truncation global Help 11 Click Next E Neo ER Poss 2 UM IOC2 5126 V2 0 docx 3 Version Date 4 15 2012 User Manual UM Template Version 2 0 m SOL Server Import and Export Wizard OR gt lt
12. Software User s Manual UM The Log Angeles Community Garden Inventory and Locator Team 13 Ardalan Youseti Project Manager Cole Cecil Integrated Independent Verification amp Validation Jeff Tonkovich Implementer Shi Xuan Zeng Gary Tester 04 15 2012 User Manual UM Template Version 2 0 Table of Contents TABLE 5 ll FABLE OF TABLE e CR 1 TABLE OP FIGURES ed IV l eine e c O en 1 1 1 rp a 1 1 2 VS Ce 1 25 Operational Procedures pud Degree Ite e a 2 3 Importing Excel Data Into tie alan anco quete dira a a a ead iod I 12 4 Exporting Data to Excel fromthe Database Do RV t E eec iater he xe euge a 23 5 Troubles 34 5 1 HONS icto ee eat Iia Medus Dh Me oM imu asians Dos uM MU DUM Ios 34 212 Codes duisi po RE tss Seana os RUDI QUSS nsa 35 UM 2 5126 T13 V2 0 docx li Version Date 4 15 2012 User Manual UM Template Version 2 0 Table of Tables No table of figures entries found UM IOC2 5126 T13 V2 0 docx lii Version Date 4 15 2012 User Manual UM Template Version 2 0 Table of Figures Figure 1 The login screen Check the Remember me next time box to have the system remember your User z DITION T
13. al 11 Success Status SUCCESS SUCCESS SUCCESS Success SUCCESS SUCCESS SUCCESS SUCCESS SUCCESS SUCCESS SUCCESS Error Warning Message rows transferred Stop Close 2 13 And you done importing data UM IOC2 S12b_T13_V2 0 docx 22 Version Date 4 15 2012 User Manual UM Template Version 2 0 4 Exporting Data to Excel from the Database 1 Rightclick on the database CommunityGardens 2 Move to Tasks gt choose Export data Microsoft SQL Server Management Studio File Edit View Project Debug Tools Window Community Help d New Query Ly 25 i fa Lh 9 led S Object Explorer AX Properties Connect 39 43 m Y wIN 5QKDI7J8HO SQL Server 10 50 2500 WIN 5QKDJI7J8F Databases 4 System Databases Database Snapshots uj Community G Database Tables E Syste Script Database as Ga dbo C c C amp 9 dbo amp 9 dbo 9 dbo C dbo New Database New Query Detach Policies Take Offline Facets Bring Online Start PowerShell Shrink H E E E EH E EH Reports Back Up Views Delete Mirror Synony Program Service B Storage Security ReportServer ReportServerTempDB Security Refresh Launch Database Mirroring Monitor Properties Ship
14. ce Destination dv GARDEN INFO dbo GARDEN_INFO 1 GARDEN_INFOY Help lt Back M ext gt Emish gt gt Cancel E 8 Select Delete rows in destination table and Enable identity insert gt Click OK gt Next UM IOC2 S12b_T13_V2 0 docx 17 Version Date 4 15 2012 User Manual UM Template Version 2 0 Bm Column Mappings Ir x BARDEN INFU Source Destination dba BGARD EN INFU Create destination table Delete rows in destination table Append rows to the destination table 5nurce GARDEN ID nes n em LATITUDE LONGITUDE STREET ADD LITY STATE LOCATION THOMAS GUIDE Source column Destination GARDEN ID 34H DEN LATITUDE LONGITUDE STREET ADD LITT COMMI STATE ZIP LOCATION THOMAS _ GUIDE Type int varchar float float varchar varchar char varchar varchar varchar Edit SWL Drop and re create destination table Enable identity insert Mullable 1 om fimo o Jm m m JN I34RHDEM ID Double 15 Size Precision Scale gt 100 150 50 10 1000 20 El OK Cancel A X Note 1 Please notice that the source data have to follow each column s rule of data type and size il The website and email fields should contain only one address If more than one address were imported the function of generating PDF would be failed
15. d new database manager oe oo pem admin Administrator eee Database Manager E gardener Database Manager test Database Manager xx Figure 6 The User Management page with Remove button highlighted 2 Click in the confirmation box to permanently delete the user account Are you sure you wantto delete this row Figure 7 A message box prevents accidentally deleting a user UM IOC2 SI2b T13 V2 0 docx 4 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 6 Change User s Password 1 Click Change Password next to the user account you wish to update Add new database manager admin Administrator Password eee Database Manag eom Password gardener Database Manager Figure 8 The User Management page with Change Password button highlighted 2 Enter in the desired new password in both text boxes Change the Password of user_mac Change Password Figure 9 The Change Password screen 3 Click Change Password to permanently change the password OR click Cancel to exit this action UM IOC2 S12b_T13_V2 0 docx 5 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 7 View Garden Information 1 Click on the Garden Management tab 2 Navigate through the table by clicking the pagination links in the top bottom left corners of the table SA gt Oakland Community Oakland Avenue EK Garden and E Maple S
16. e Precision Scale a FURTHER INF FURTHERINF LongTest STATUS STATUS LongT est POLITICAL POLITICAL_RE LongT ext FR SUP DIST PR SUP DIST Short FR SUP DIST PH SUP DIST LongT est FR CITY MAY CITY M amp Y LongT ext FR CITY CITY LongTest STATE 45 PH STATE amp 5 LongText NOTES NOTES LangT ext TimeStamp TimeStamp V arBinary B lt 1 gt TimeStamp timestamp MULL OF Cancel 2 9 If the destination excel file already exists please select Delete rows in destination table and then click OK gt click Next Source calumrn UM IOC2 S12b_T13_V2 0 docx 20 Version Date 4 15 2012 User Manual UM Template Version 2 0 B Column Mappings E gt lt dba G amp RD EM TMFE GARDEN INFDE Source Destination Edit SWL Drop and re create destination table Create destination table Delete rows in destination table Append rows to the destination table Mappings Source Destination Type Mullable Size Precision Scale gt FURTHER IMF FURTHER_LINF LongT ext STATUS STATUS LongT ext PULITICALLAE POLITICALLAE LongT est FR SUP DIST PR SUP DIST Double 15 FR SUP DIST PH SUP BIST LongTest FH LITY MAY CITY LongTest FR LITY COU CITY COU LongTest FH STATE A5 P
17. equested page See the Notes section for more information on user access levels Invalid Format The information entered into the field does not conform to the correct format for that field Generally this means you entered characters into a field expecting numbers Max length is X This field has a length restriction in place on it The information currently entered in the field is greater than the maximum allowed Reduce the number of characters in the field to proceed Notes Administrator A system user who has access to the User Management portion of the website The Administrator is the only user capable managing other users of the system including the ability to add new users remove existing users and update existing user information password etc Database Manager A system user who has access to all system capabilities except User Management The Database Manager is the typical user who has access to add update and remove information from the Community Garden Database Database Viewer A system user who has read only access to the data in the Community Gardens Database and who can generate reports Like the Database Manager the Database Viewer cannot manage other users LACC Los Angeles Conservation Corp LACGC Los Angeles Community Gardening Council LANLT Los Angeles Neighborhood Land Trust UCCE University of California Cooperative Extension UM IOC2 5126 T13 V2 0 docx 35 Version Date 4 15 2012
18. file Open with Microsoft Office Excel default 7 Save File Do this automatically for files like this from now on Cancel English Figure 21 The Open Save dialog FireFox once the Generate Report button has been clicked UM IOC2 S12b_T13_V2 0 docx 11 Version Date 4 15 2012 User Manual UM Template 3 Importing Excel Data into the Database 1 Rightclick on the database CommunityGardens 2 Move to Tasks gt choose Import data La Microsoft SQL Server Management Studio File Edit Debug Tools Window Community Help zd New Query t irl Ds E Object Explorer Conect 9 49 m Y BS Lg Databases Lj System Databases Database Snapshots CommunityGal ReportServer ReportServer Lj Security Server Objects Ca Replication Management SQL Server Agent New Database New Query Script Database as Detach Policies b Take Offline Facets Bring Online Start PowerShell Shrink Reports Back Up Restore Rename Delete Mirror Refresh Launch Database Mirroring Monitor Ship Transaction Logs Properties Generate Scripts Extract Data tier Application Register as Data tier Application Export Data Copy Database Manage Database Encryption 3 Import and Export Wizard window
19. gt Click Next UM IOC2 5126 T13 V2 0 docx 14 Version Date 4 15 2012 User Manual UM Template Version 2 0 SOL Server Import and Export Wizard OF XI Choose a Destination Specify where to copy data ta estinatian Server name wiN 5G Authentication Use Windows Authentication C Use SUL Server Authentication User name Password Database ardens Refresh Mew m eh Neo gt PE 2 6 Click Next UM IOC2 5126 T13 V2 0 docx 15 Version Date 4 15 2012 User Manual UM Template Version 2 0 BB SOL Server Import and Export Wizard opecity I able Copy or Query Specify whether to copy one more tables and views orto copy the results of query from the data source Copy data from one or more tables or view s Use this option to copy all the data from the existing tables or views in the source database C Write query to specify the data to transfer Use this option to write an SOL query to manipulate to restrict the source data for the copy operation Help lt Back Neo Emeh gt Cancel 2 7 Select GARDEN_INFO and click Edit Mappings UM IOC2 5126 T13 V2 0 docx 16 Version Date 4 15 2012 User Manual UM Template Version 2 0 SQL Server Import and Export Wizard 0 Select Source Tables and Views Choose one more tables and views to Tables and views 9 Sour
20. ick the blue floppy disk icon save button to commit your changes to the database 4 Click the red X icon cancel button to cancel editing the garden record eee Garden Name Altadena Community 9113330 Lincoln Avenue Figure 16 The save changes and cancel changes buttons after starting to edit a garden record UM IOC2 S12b_T13_V2 0 docx 8 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 12 Delete Garden Record 1 Click the trash can icon delete button next to the garden record you want to delete Altadena Community 3330 N Lincoln 91001 34 20234 Garden Avenue Figure 17 The permanently delete record button on the Garden Management page 2 Click in the confirmation box to permanently delete this garden record you sure you want to delete this row Figure 18 There is a confirmation dialog before a garden record is permanently deleted UM IOC2 S12b_T13_V2 0 docx 9 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 13 Export Garden Information 1 Click on the Generate Report tab 2 Move fields you want to include in the report to the Selected Fields column left column a Selecting one or more fields in either list box and then using the single arrow buttons lt gt results in moving just the selected fields between the two list boxes b To move ALL fields between the two list boxes use the double arrow b
21. ion Status Message Initializing Data Flow T ask Success Initializing Connections SUCCESS Setting SAL Command SUCCESS G Seting Source Connection SUCCESE G Setting Destination Connection SUCCESE Validating Success for Execute Success Pre execute Success Executing Warning Messages i Copying to GARDEN INFO SUCCESS rows transferred Post execute Success Shop Hepor 22 14 And you done 5 Troubleshooting 5 1 Frequently Asked questions Q Why does the blue icon save button not work sometimes This can be caused by a number of issues but is generally related to validation errors If the save button seems unresponsive scroll across all fields and look for error messages Many fields have very specific format requirements character limits etc If no fields show any error messages and the problem persists you may be trying to add a new garden record that has the same Garden Name as an existing garden The database will not accept more than one garden to have the same Garden Name UM IOC2 S12b_T13_V2 0 docx 34 Version Date 4 15 2012 User Manual UM Template Version 2 0 5 2 5 2 1 Error Codes and Messages Red Asterisk This is a required field and must be filled in with appropriate data before proceeding with any save or edit operation You must login as an administrator to view this page You do not have sufficient privileges to view the r
22. on level Encrypt sensitive data with user key Password Retype password Help EN Neo s gt PW E 11 Click Finish UM IOC2 5126 T13 V2 0 docx 20 Version Date 4 15 2012 User Manual UM Template Version 2 0 BB SQL Server Import and Export Wizard x E Complete the Wizard Verify the choices made in the wizard and click Finish J k Click Finish to perform the following actions Source Location sers steam s Desktop CG ander INFO Data 201203 Is Source Provider MicrosoftJet OLEDE 4 Destination Location wVIM BEKIEIEATSHU Destination Provider SELMNCLITU Copy rows from GARDEN INFO to dba BSRDEM INFO Any existing rows in the target table will be deleted The package will not be saved The package will be run immediately Help lt Back Het gt Finish Cancel E 12 If the successful window shows up the data are successfully imported into database UM IOC2 S12b_T13_V2 0 docx 21 Version Date 4 15 2012 User Manual UM Template E SQL Server Import and Export Wizard The execution was successful Version 2 0 Success Details oo o0 o Action lritializing Data Flow T ask Initializing Connections Setting SUL Command Setting Source Connection Setting Destination Connection Validating Prepare for Execute Fre execute Executing Copying to dba BSRDEMN INFO Post execute 11 Tot
23. related organizational staff This manual has been tailored for use by LANLT and related organization s staff and thus will not cover usage of the public facing component This manual covers the use of all included system functionality as well as a Trouble Shooting section 1 2 System Requirements Since the Community Garden Inventory and Locator system is a website there are essentially no software or hardware requirements to access the system other than an internet connection and a web browser This section outlines which operating systems and browsers were tested with and are known to work Some level of future and backwards compatibility is assumed but has not been rigorously tested 1 2 2 Software Requirements e Supported Operating Systems o Windows Vista 7 o Apple OSX 10 7 e Supported Browsers Internet Explorer 9 0 o Firefox 8 0 o Google Chrome 15 0 o Apple Safari 5 1 UM 2 5126 V2 0 docx 1 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 Operational Procedures 2 1 1 Login to the System 1 Navigate to http www finalUrl com Admin 2 Enter username password and click Log In User Name 7 Remember me next time Figure 1 The login screen Check the Remember me next time box to have the system remember your User Name the next time you visit the site 2 1 2 Logout of the System 1 Click the Logout button in the top right corner of any page Figure 2
24. treet Pasadena CA 91607 34 15386 d Ocean View Farms 2200 5 Centinela 90805 34 0159 Avenue _ Orcutt Ranch J Horticultural Center 23600 Roscoe PA D Penne gt _ Rancho Sombra del Boulevard Roble Figure 10 Garden Management page with pagination highlighted 21 8 Sort Garden Information 1 Click on any column header to sort the table by that column 2 Click the column a second time to sort the table by that column in reverse order 12345678 TERME ENEMY Bougainvillea E 103rd Street amp db Community Garden Grape Street Los Angeles ee THEM 0 S Sepulveda Garden 16633 Magnolia San Fernando Valley CA 90004 34 16796 Center Boulevard Norman Harriton 2037 N Sanborn Ton mee CA 90005 34 10675 Ds Community Garden Avenue z Rosewood Gardens 4160 1 2 Rosewood Los Angeles CA 90007 34 08047 Avenue Garden 6400 Chase Street North Hills CA 90012 34 22463 Figure 11 Clicking the header of any column will sort the table by that column UM IOC2 S12b_T13_V2 0 docx 6 Version Date 4 15 2012 User Manual UM Template Version 2 0 2 1 9 Search Garden Information 1 Enter the search term s into the text box next to the Search button 2 Click the Search button or hit the Enter key a Limitations amp workarounds Garden Management Generate Report User Management Clear Search 1 it A Altadena Community 3330 N Lincoln Altadena CA 91001 34 202344 E Garden Avenue
25. uttons lt lt gt gt Garden Manageme 4 Generate Report 7 User Management Selected Fields Available Fields Garden Name Latitude Longitude Street Address City Community State ZIP Location Thomas Guide Website Garden Contact Phone Contact Email Last Update amp of Gardeners Low Income Med Income High Income Seniors Generate Report Figure 19 The Generate Report page UM IOC2 S12b_T13_V2 0 docx 10 Version Date 4 15 2012 User Manual UM Template Version 2 0 3 Change the order the columns will appear in the report with the up down buttons 4 Click Generate Report to generate the report Fee Pays Lot Size Available Fields Selected Fields Garden Name Latitude Ta Street Address High Income City Community State ZIP Thomas Guide Website Garden Contact Phone Contact Email of Plots of Gardeners Last Update Plot Size Low Income gt gt Med Income lt lt Generate Figure 20 Customize the column order the excel report by selecting individual fields to report on and changing their display order with the Up Down buttons 5 downloadable excel document will be generated and available to open save Garden Name Latitude Opening GardenList xlsx You have chosen to open which is a Microsoft Office Excel Worksheet from http longbeach usc edu 30680 What should Firefox do with this
Download Pdf Manuals
Related Search