Software User`s Manual (UM)
Contents
1. message is shown if no matches were found for the provided search 222 0 00 000 55550552000 8 Figure 14 The Add new garden row at the bottom of the Garden Management 9 Figure 15 The Edit Row button on the Garden Management page sees eene eene nnns 9 Figure 16 The save changes and cancel changes buttons after starting to edit a garden 9 Figure 17 The permanently delete record button on the Garden Management page sees 10 Figure 18 There is a confirmation dialog before a garden record is permanently deleted eese 10 Figure 19 Ihe Generate Report e tei 11 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 eene eene en eee EEA AAA rrr nn esses esee nn nnn nnn nnns 12 Figure 21 The Open Save dialog FireFox once the Generate Report button has been clicked 12 UM IOC3 5126 V3 1 docx 1 Version Date 5 4 2012 User Manual UM Version 3 1 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 information2. Version Date 5 4 2012 User Manual UM Version 3 1 2 1 66 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 Enterin 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 IOC3 5126 V3 1 docx 6 Version Date 5 4 2012 User Manual UM Version 3 1 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 e Oakland Community Oakland Avenue EK Garden and E Maple Street Pasadena CA 91607 34 15386 d Ocean Farms 2200 5 Centinela ss vista CA 90805 34 0159 Avenue _ Orcutt Ranch E J Horticultural Center 23600 Roscoe PA D Penne 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 re
3. 31 Version Date 5 4 2012 User Manual UM Version 3 1 Bm SOL Server Import and Export Wizard Of x Review Data Mapping Select a table to review how its data types map to those in the destination Also select TW how the wizard handles conversion Issues T able Source dbo GARDEN_INFO 4 Data type mapping Destination GARDEN INFO m Source Column Source Destination Destination Ty Convert On Error gt VE I3a4HDEM ID int I34HDEM ID Long GARDEN_NA varchar GARDEN LongText Use Global LATITLIDE float LATITUDE Double d LONGITUDE float LONGITUDE Double STREET AC varchar STREET AD Long ext Use Global P LITY COMM varchar LITY COMM LonaTest Use Global AN STATE char STATE V arL har Use x 4 H To view conversion details double click the row that contains the column source type to converted Fai Error global On Truncation global Help 11 Click Next Hm Neo EIER Pond 5126 V3 1 docx 22 Version Date 5 4 2012 User Manual UM Version 3 1 BB SQL Server Import and Export Wizard Ex prr e Sawe 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 password
4. 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 IOC3 5126 V3 1 docx 11 Version Date 5 4 2012 User Manual UM Version 3 1 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 Report 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 5 downloadable excel document will be generated and available to open save Opening GardenListxlsx You have chosen to open fil GardenList xlsx which is a Microsoft Office Excel Worksheet from http longbeach usc edu 30680 What should Firefox do with this file Open with Microsoft Office Excel default Save File Do this auto matically for files like this from now on Cancel English Figure 21 The Open Save dialog FireFox o
5. Help mmm Neo END P 12 Click Finish UM IOC3 5126 V3 1 docx 33 Version Date 5 4 2012 User Manual UM Version 3 1 El SOL Server Import and Export Wizard E Complete the Wizard x 3 the choices made in the wizard and click Finish Click Finish to perform the following actions Source Location WIN BEKIEJEATSHE Source Provider SELNELITU Destination Location CALI serssteaml 3 lo arden INFO Data 2071 2053 els Destination Provider Microsoft Jet OLEDE 4 0 Copy rows from dba GSRDEMN INFO ta G amp ACEN 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 Servers1U0 D TS5 MappinaF iles SM SSglTaletd ML Help lt Back gt Finish Cancel 13 If the successful window shows up the data are successfully exported into excel file UM IOC3 5126 V3 1 docx 34 Version Date 5 4 2012 User Manual UM Version 3 1 BB SQL Server Import and Export Wizard 0 The execution was successful 11 Total Error SUCCESS Success 1 Warming Details Acton Status Message Initializing Data Flow Task SUCCESS Initializing Connections Success 692 Seting SAL Command Success 82 Seting Source Connection Success 92 Setting Destination Connection Success 52 Validating Success 52 Prepare for Execut
6. SQL Server Import and Export Wizard x E Complete the Wizard Verify the choices made in the wizard and click Finish k Click Finish to perform the following actions Source Location CALI 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 IOC3 5126 V3 1 docx 22 Version Date 5 4 2012 User Manual UM E SQL Server Import and Export Wizard The execution was successful Version 3 1 2 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 Executing Copying to dba BSRDEMN INFO Post execute 11 Total 11 Success Status SUCCESS SUCCESS SUCCESS Success SUCCESS SUCCESS SUCCESS SUCCESS SUCCESS SUCCESS SUCCESS Error Warning Message rows transferred Stop Repot Close 2 13 And you are done im
7. 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 fles 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 available in SOL Server Management Studia Do not show this starting page again Help Neo ERST 4 Data source choose Microsoft Excel and browse data file path gt Click Next UM IOC3 5126 V3 1 docx 14 Version Date 5 4 2012 User Manual UM Version 3 1 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 First row has column names Help lt Back gt gt gt Cancel E 5 Choose destination SQL Server and database CommunityGardens gt Click Next UM IOC3 5126 V3 1 docx 15 Version Date 5 4 2012 User Manual UM Version 3 1 SOL Server Import and Export Wizard Choose a Destination Specify where ta copy data
8. gt Click Next UM IOC3 5126 V3 1 docx 26 Version Date 5 4 2012 User Manual UM Version 3 1 A SQL Server Import and Export Wizard Ey Choose a Destination Specify where to copy data to Destination Microsoft Excel Excel connection settings Excel file path Eu sersteaml3 D esktepsCBlarden Data 201203 Iz Browse Excel version Microsoft Excel 87 2003 v First row has column names Help Hm Neo ENT P 6 Click Next UM IOC3 5126 V3 1 docx 27 Version Date 5 4 2012 User Manual UM Version 3 1 BB SOL Server Import and Export Wizard I able Copy or Query Specify whether ta copy one more tables and views or ta copy the results of query from the data source Copy data from one or more tables or views Use this option to copy all the data fram the existing tables or views in the source database C Write a query to specify the data to transfer Use this option to write an SQL query to manipulate to restrict the source data for the copy operation Help lt Back Neo gt gt Cancel 2 7 Select source dbo GARDEN INFOJ and click Edit Mappings UM IOC3 5126 V3 1 docx 28 Version Date 5 4 2012 User Manual UM Version 3 1 A SQL Server Import and Export Wizard _ OI Select Source Tables and Views 1 Choose one or mare tables and views to c
9. in MS Excel 2011 on my Apple computer A You can safely ignore this error message The xlsx file can still be opened read edited and saved with no repercussions 5 2 Error Codes and Messages 1 Red Asterisk This is a required field and must be filled in with appropriate data before proceeding with any save or edit operation 2 You must login as an administrator to view this page You do not have sufficient privileges to view the requested page See the Notes section for more information on user access levels 3 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 4 Maxlength 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 5 2 1 Notes 1 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 2 Database Manager system user who has access to all system capabilities except User Management The Database Manager 15 the typical user who has access to add update and remove information from the Community Garden Database 3 D
10. new user button Garden Management Generate Report User Management admin Administrator gardener Database Manager test manager Database Manager 29 Figure 4 The Add new user button on the User Management page 2 Enter in a User Name and Password a Password requirements minimum of 8 characters and must contain at least one special character 3 Select a User Type from the dropdown box UM IOC3 5126 V3 1 docx 4 Version Date 5 4 2012 User Manual UM Version 3 1 Create new user CO OE 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 Add 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 IOC3 SI2b V3 I docx 5
11. to Destination Server name wIN 50 KIJI ZJSHO Authentication Use Windows Authentication C Use SUL Server Authentication User name Password Database Community ardens Refresh Mew Help lt Back Nec l Cancel 2 6 Click Next UM IOC3 5126 V3 1 docx 16 Version Date 5 4 2012 User Manual UM Version 3 1 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 a 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 gt Cancel 2 7 Select GARDEN_INFO and click Edit Mappings UM IOC3 5126 V3 1 docx 17 Version Date 5 4 2012 User Manual UM Version 3 1 Bm SOL Server Import and Export Wizard Select Source Tables and Views Choose one or more tables and views to copy Tables and views 9 Source Destination Gi GARDEN INFO dbo GSROEN_ INFO 27 GARDEN IMFO Help lt Back gt Fintsh gt gt Cancel E 8 Select Delete rows in destination table and Enable iden
12. 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 If any of the required fields are empty any field contains the wrong type of data or has too much data in it the save button will not work and error messages will appear below the field with offending data b See Sections 5 1 and 5 2 for additional information about error conditions 4 Click the red X icon cancel button to clear all fields in the insert row me d F Columbia Pak 4045 190th Street Torrance CA 90504 33 86323 Community Garden n Dum Address C uui Community en Name 4 n 12345678 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 i Fade Lincoln Altadena CA 91001 34 20234 Figure 15 The Edit Row button on the Garden Management page 2 Make your desired changes 3 Click 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 Garden Nam
13. SUP 5 LongText CITY MAY LongT ext PR CITY LonaTest STATE A5 PH STATE amp 5 LongText NOTES NOTES LongT ext TimeStamp TimeStam V arBinary B lgnore TimeStamp timestamp NULL Source ealumn Cancel 9 If the destination excel file already exists please select Delete rows in destination table and then click OK gt click Next UM IOC3 5126 V3 1 docx 30 Version Date 5 4 2012 User Manual UM Version 3 1 E Column Mappings 10 gt lt dba B amp RDEMN INFE BARDEM IMFLE Source Destination Edit SUL 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 IMF LenaTest STATUS STATUS LongT ext POLITICAL P LITICAL LengTest SUP DIST PH SUP DIST Double 15 SUP DIST PH SUP BIST LongTest LITY MAY CITY M amp Y LongT ext FR LITY COU PH CITY CDU LongT ext FR STATE 45 STATE 5 LongTes NOTES NOTES LangT ext TimeStamp zignare Source column 10 Click Next IOC3 SI2b TI3 V3 l docx I34RDEN ID int NOT NULL Cancel
14. 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 05 04 2012 User Manual UM Version 3 1 Table of Contents TABLE OF CONTENGS ert ll FABLE TABLES e c E 1 TABLE OF FIGURES IV l e 1 1 1 BASQUE rp PN 1 1 2 OVS Fe eben 1 25 Operational Procedures net es cud Dog rte ttd e em NU P De EE 3 3 Importing Excel Data into he ata ase anco quete Pop dO UE toon ade up Un E ead ied I ted 13 4 Exporting Data to Excel fromthe Database Io RV t E oec E 24 5 Tro blesHOOCUTB orae ect deed usd eon eau 35 5 1 Asked Ios 35 212 bHOrCodeosaneVIe SSABGS RUDI QUSS nba 36 UM IOC3 5126 T13 V3 1 docx li Version Date 5 4 2012 User Manual UM Version 3 1 Table of Tables No
15. 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 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 1 Hardware Requirements 1 2 1 1 Server Requirements e Processor Intel R XEON E3220 processor e Memory 2 00 GB e 80 GB mo Bandwidth e Dedicated IP address 1 2 2 Software Requirements 1 2 2 1 Server Softwa
16. ap to those in the destination Also select how the wizard handles conversion sues r j IAE T i T able Snurce 1 CBARDEN INFO Destination _1 dbo G4SRDEN_ INFO gt Data type mapping Source Column Source Type 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 float d LONGITUDE Double LONGITUDE float AN STREET AD LongT ext STREET varchar Use Global AN LITY LongT ext LITY varchar Use Global AN STATE Varlhar STATE char Use 4 H To view conversion details double click the row that cantains the column source type to be converted mmm Next gt Em gt l Pme E On Error global On Truncation global Help 10 Click Next UM_IOC3_S12b_T13_V3 1 docx 20 Version Date 5 4 2012 User Manual UM Version 3 1 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 protection level Encrypt sensitive data with user key Password Retype password Help EN Neo s PW 11 Click Finish UM IOC3 5126 V3 1 docx 21 Version Date 5 4 2012 User Manual UM Version 3 1 BB
17. atabase 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 4 Los Angeles Conservation Corp 5 LACGC Los Angeles Community Gardening Council 6 LANLT Los Angeles Neighborhood Land Trust 7 University of California Cooperative Extension UM IOC3 5126 V3 1 docx 36 Version Date 5 4 2012
18. base Encryption 3 Import and Export Wizard window shows up and click Next UM IOC3 5126 V3 1 docx 24 Version Date 5 4 2012 User Manual UM Version 3 1 BB SOL Server Import and Export Wizard 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 fles 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 available in SOL Server Management Studia Do not show this starting page again Help Neo ERST 4 Choose source SQL Server and database CommunityGardens gt Click Next UM IOC3 5126 V3 1 docx 25 Version Date 5 4 2012 User Manual UM Version 3 1 BB SOL Server Import and Export Wizard E ren Choose a Data Source Select the source from which to copy data Data source Server name wi H 50KIJIZJSHO Authentication Use Windows Authentication C Use SUL Server Authentication User name Password Database ommunitu3 ardens Refresh mm Neo 5 Data destination chooses Microsoft Excel and browse data path
19. e 2 ey Garden Name Altadena Community 3 3330 N Lincoln Avenue Figure 16 The save changes and cancel changes buttons after starting to edit a garden record UM IOC3 5126 V3 1 docx 9 Version Date 5 4 2012 User Manual UM Version 3 1 2 1 12 Delete Garden Record 1 Click the trash can icon delete button next to the garden record you want to delete ii Altadena Community 3330 N Lincoln 91001 34 20234 Garden Avenue Figure 17 The permanently delete record button on the Garden Management page 2 Click OK in the confirmation box to permanently delete this garden record Are you sure you want to delete this row Figure 18 There is a confirmation dialog before a garden record is permanently deleted UM IOC3 5126 V3 1 docx 10 Version Date 5 4 2012 User Manual UM Version 3 1 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 right column a Selecting one or more fields in either list box and then using the single arrow buttons 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 buttons lt lt gt gt Garden Manageme 4 Generate Report User Management Selected Fields Available Fields Garden Name Latitude Longitude Street Address City
20. e Success 52 Pre execute Success Executing Warning Messages i Copying to GSRDEN_INFO SUCCESS rows transferred 52 Postexecute Success Stop Repot 14 And you are done 5 Troubleshooting 5 1 Frequently Asked questions Q Why does the blue icon save button not work sometimes A 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_IOC3_S12b_T13_V3 1 docx 35 Version Date 5 4 2012 User Manual UM Version 3 1 Q Why can t I seem to search for values in fields like ZIP or Lat The search functionality is not implemented on numeric only fields such as ZIP and LAT However these fields can still be sorted on to make it easier to find a particular value Q When on the home page why does street view look weird A Due to a bug in the Google maps API only Google Chrome correctly renders the maps without a distorted street view If the issue is severe consider using Google Chrome as your browser Q Why am I getting an error when opening the xlsx report file
21. nce the Generate Report button has been clicked UM IOC3 5126 V3 1 docx 12 Version Date 5 4 2012 User Manual UM Version 3 1 3 Importing Excel Data into the Database 1 Rightclick on the database CommunityGardens 2 Move to Tasks gt choose Import data E Microsoft SQL Server Management Studio File Edit Debug Tools Window Community Help zd New Query Liy c tty Pa Ds E Object Explorer Conect 39 32 7 BS 2 Databases d System Databases Ca Database Snapshots Community ReportServer ReportServer Lj Security Ca Server Objects Replication O Management 3 SQL Server Agent New Database Mew Query Script Database as Policies Detach 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 shows up and click Next UM IOC3 5126 V3 1 docx 13 Version Date 5 4 2012 User Manual UM Version 3 1 BB SOL Server Import and Export Wizard X Welcome to SQL
22. opy wf mme i A Tables and views Source Destination 21 dbo aspnet_Applications 21 dba aspnet Membership 21 dba aspnet Roles 1 dba aspnet Schemaversions 1 dba aspnet Users 1 dba aspnet LiserslnRales 1 dba B amp RDEM EXTRA COLUMN 11 dba G amp RDEN EXTRA CULLIMNM DATA 1 dba B amp RDEM EXTRA Iw dbo GARDEN_INFO GARDEN_INFO Ej dbo sysdiagrams 21 dbo USER INFO Eg dbo vw_aspnet_Applications dba Membershipllsers dba vw aspnet Holes dbo vw aspnet Lasers dba ww aspnet LserslnPiales E dit Mappings Preview Help lt Back Neo 2 Cancel 22 8 If destination excel is a new file please make sure to ignore TimeStamp and then click gt click Next UM_IOC3_S12b_T13_V3 1 docx 29 Version Date 5 4 2012 User Manual UM Version 3 1 EI Column Mappings E 5 nurce dbo BARDEM IMFL Destination GSRDEN INFO Create destination table Edit SUL C Delete rows in destination table Drop and re create destination table Append rows to the destination table Mappings Source Destination Type Mullable Size Precision Scale gt FURTHER IMF FURTHER_LINF LonaT ext STATUS STATUS LongT ext POLITICAL POLITICALLRE LongT ext FR SUP DIST PR OSUPLDIST Short SUP DIST PH
23. porting data IOC3 SI2b TI3 V3 l docx 23 Version Date 5 4 2012 User Manual UM Version 3 1 4 Exporting Data to Excel from the Database 1 Right click on the database CommunityGardens 2 Move Tasks gt choose Export data Microsoft SQL Server Management Studio File Edit View Project Debug Tools Window Community Help EL New Query D c i fe D Oe ied e Object Explorer 2 Properties Connecty 39 32 m E WIN S5QKIJI7J8HO SQL Server 10 50 2500 WIN 5QKIJI7J8F E Databases d System Databases Database Snapshots Database New Database Tables New Query E Syste Script Database as Ga dbo SE C c dbo Detach C pus Cj dbo 4 Policies Take Offline C Facets Bring Online C dbo E dbo Start PowerShell Shrink C dbo Reports Back Up Rename Restore Delete Mirror Launch Database Mirroring Monitor Refresh Ship Transaction Logs Properties Generate Scripts Extract Data tier Application ReportServer ReportServerTempDB Security EE E E S un 2 iA D Register as Data tier Application Server Objects Import Data ibit CI Management Copy Database 3 SQL Server Agent Manage Data
24. re Requirements e Server Software Requirements o Windows Server 2008 o IIS 7 0 o ASP NET 4 0 5 SQL 2008 R2 UM IOC3 5126 V3 1 docx 1 Version Date 5 4 2012 User Manual UM 1 2 2 2 Website Software Requirements e Website Supported Operating Systems O O Windows Vista 7 Apple OSX 10 7 Supported Browsers Internet Explorer 9 0 Firefox 8 0 Google Chrome 15 0 Apple Safari 5 1 IOC3 SI2b TI3 V3 l docx 2 Version 3 1 Version Date 5 4 2012 User Manual UM Version 3 1 2 Operational Procedures 2 1 1 Login to the System 1 Navigate to http www finalUrl com Admin 2 Enter username password and click 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 The Logout button UM IOC3 5126 V3 1 docx 3 Version Date 5 4 2012 User Manual UM Version 3 1 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
25. table of figures entries found UM IOC3 5126 T13 V3 1 docx lii Version Date 5 4 2012 User Manual UM Version 3 1 Table of Figures Figure 1 The login screen Check the Remember me next time box to have the system remember your User LUE RAY T2 DTRRIKNTRM ITA ze 3 Fee 2 ACL NCTE OUO 3 Figure o The User Management age sco ot PEE eee aa eus 4 Figure 4 The Add new user button on the User Management 4 Figure 5 The Add new user page The password requirements and password strength indicators help guide you to Selectile DASSW OVC xU dd MI TUE 5 Figure 6 The User Management page with Remove button highlighted eese nnns 5 Figure 7 A message box prevents accidentally deleting a user 5 Figure 8 The User Management page with Change Password button highlighted eese 6 Fipureg 9c ThexhungeJ asswotd SCI xn ne 6 Figure 10 Garden Management page with pagination highlighted cesses eene nnns 7 Figure 11 Clicking the header of any column will sort the table by that column eese Figure 12 Filter the contents of the table with the search feature 8 Figure 13
26. tity insert gt Click OK gt Next UM IOC3 5126 V3 1 docx 18 Version Date 5 4 2012 User Manual UM Version 3 1 E Column Mappings rf x TARDEN INF Source Destination dbo GSRDEN_INFO Greate destination table Delete rows in destination table Append rows ta the destination table Mappings Source 3 4RHDEM Ken M LATITUDE LONGITUDE STREET ADD LITY COMMM STATE ZIP LOCATION THOMAS GUIDE Source column Destination GARDEN ID I34HDEM LATITUDE LONGITUDE STREET ADD STATE ZIP LOCATION THOMAS _ GUIDE Type int varchar float float varchar varchar char varchar varchar varchar Edit SL Drop and re create destination table Enable identity insert Mullable n n OOOO I34HDEM ID Double 15 Size Precision Scale 100 150 1000 20 El Cancel 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 9 Click Next IOC3 SI2b TI3 V3 l docx 19 Version Date 5 4 2012 User Manual UM Version 3 1 A SOL Server Import and Export Wizard Review Data Type Mapping ae az Select a table to review how its data types m
27. verse order 12345678 TERME ENEMY Bougainvillea E 103rd Street amp db Community Garden Grape Street Los Angeles ee THEM 0 Sepulveda Garden 16633 Magnolia San Fernando Valley CA 90004 34 16796 Center Boulevard ib Norman Harriton 2037 N Sanborn Ton mee CA 90005 34 10675 Ds Community Garden Avenue z 0 Rosewood Gardens 4160 1 2 Rosewood Los Angeles CA 90007 34 08047 Avenue ib 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 IOC3 5126 V3 1 docx 7 Version Date 5 4 2012 User Manual UM Version 3 1 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 Altadena Community 3330 N Lincoln Altadena CA 91001 34 202344 E Garden Avenue 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 IOC3 5126 V3 1 docx 8 Version Date 5 4 2012 User Manual UM Version 3 1 2 1
Download Pdf Manuals
Related Search