1 / 26

Database Design, and Information Storage and Retrieval

Database Design, and Information Storage and Retrieval. Lesson 4. Advanced features of WinISIS. Scope. Lesson 4 will explain:. How to use options in data entry work-sheet and data validation How to use global functions and advanced utilities

coy
Download Presentation

Database Design, and Information Storage and Retrieval

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design, and Information Storage and Retrieval Lesson 4. Advanced features of WinISIS UNESCO ICTLIP Module 4. Lesson 4

  2. Scope Lesson 4 will explain: How to use options in data entry work-sheet and data validation How to use global functions and advanced utilities How to modify system parameters and to create password files How to LINK files in other programs How to sort the records in your database UNESCO ICTLIP Module 4. Lesson 4

  3. Learning outcomes By the end of the lesson you will be able to: Use options during data entry Validate data in a field/record Use global editing functions and advanced utilities Change system parameters according to your needs and create password files Link files in other programs Sort your database UNESCO ICTLIP Module 4. Lesson 4

  4. When you click on the OPTIONS button in the data entry worksheet a menu appears Using options in data entry worksheet UNESCO ICTLIP Module 4. Lesson 4

  5. Using options in data entry worksheet • Open dictionary will open the dictionary and any term in the dictionary can be inserted into a field by double clicking on it • Create a copy allows you to create a copy of any existing record as a new record • Delete & Undelete records can be used to delete records temporarily and then to undelete UNESCO ICTLIP Module 4. Lesson 4

  6. Using options in data entry worksheet • Create default values helps to enter default values while entering data: This method can be used when entering a set of books having a field with a common value. This default value will be effective only for the current session of data entry. It will be automatically removed when the data entry session is closed. UNESCO ICTLIP Module 4. Lesson 4

  7. Data validation • Data validation can be used to minimize the data entry errors. • These validation rules are saved in a separate file called dbase.val (where dbase is the database name) • Each line of the data validation file has the following general format: tag: format UNESCO ICTLIP Module 4. Lesson 4

  8. Data validation A Sample data validation file is given below: • to test the length of the field: • If size v2 > 4 then ‘Field 2 is too long’ fi • To ensure that some fields cannot be skipped without entering data • if a(v4) then ‘this field cannot be empty’ fi UNESCO ICTLIP Module 4. Lesson 4

  9. Global editing functions • When you click on the UTILS a menu appears which includes the global editing functions and advanced database utilities UNESCO ICTLIP Module 4. Lesson 4

  10. Global editing functions • Global editing allows you to Add;Delete or replace data within a field. • This can be applied to a range of MFNs or to a search set. UNESCO ICTLIP Module 4. Lesson 4

  11. ; Isis for Windows - Configuration File 1=c:\winisis\prog\ 2=c:\winisis\menu\ 3=c:\winisis\msg\ 4=c:\winisis\work\ 5=c:\winisis\data\ ; Default language ; Activate Helpbar 121=1 141=c:\winisis\bg\ 142=10,1 980=1 130=1 122=64, 0, 0, 800, 600 System parameters • WinISIS uses many system parameters used in CDS/ISIS DOS version. • Parameters 0-5, 14 are the same as in DOS version • In addition to the parameters shown in the default SYSPAR.PAR file there are many new parameters in the Win version UNESCO ICTLIP Module 4. Lesson 4

  12. Some useful system parameters • 0=file redirection (used when creating password files) • 137=close database confirmation • 102=default menu (DF). Access can restricted using SH • 125=database access restriction. Default value 0 allows for open access, 1 allows for restricted access from a list • 130=automatic inverted file update • 105=automatic display of search results • 980=Tabular display of search results UNESCO ICTLIP Module 4. Lesson 4

  13. 1=D:\winisis\prog\ 2=D:\winisis\menu\ 3=D:\winisis\msg\ 4=D:\winisis\work\ 5=d:\winisis\data\ 14=1 102=SH 125=1 ; Big search toolbar 122=64, -4, -4, 803, 575 1001=d:\winisis\data\smnet.mst 1002=d:\winisis\data\lib.mst Creating password files • Personalised system parameter files (password files) can be created by using ‘0’ (zero) parameter in SYSPAR.PAR file. • A password file (cds.par) restricts the user to searching only two databases UNESCO ICTLIP Module 4. Lesson 4

  14. Linking files in other programs • Including link commands in a print format (*,pft) allows you to link files in other programs. • CMD command - Runs Windows and MSDOS programs. It is necessary to indicate the drive, directory, path where the program (usually the *.EXE file) is located. • link(('CLICK HERE FOR TEXT'),'CMD c:\\progr~1\\micros~1\\office\\winword',v101) (file and path names should be written the way they appear in DOS, eg. Program files as prog~1 UNESCO ICTLIP Module 4. Lesson 4

  15. Linking files in other programs • CMD command to display a picture file. • link(('CLICK HERE FOR PICTURE'),'CMD pbrush ',v200). • In this case path and the file name of the picture file should be entered in the field 200 UNESCO ICTLIP Module 4. Lesson 4

  16. Linking files in other programs • CMD command to call an audio or multimedia file • link(('CLICK TO PLAY MUSIC'),'CMD mplayer ',v100) • In this case path and the file name of the audio/video file should be entered in the field 100 UNESCO ICTLIP Module 4. Lesson 4

  17. Linking files in other programs • CMD command – alternate specifications • Assume that field 300 has subfields abc. Data is entered as follows:^aCLICK FOR PICTURE^bPBRUSH^cC:\WINISIS\BG\UNESCO.BMP • Format will be ^alink((v300^a),'CMD ',v300^b," ",v300^c) UNESCO ICTLIP Module 4. Lesson 4

  18. Linking files in other programs • OPENFILE Command calls a picture/ image/ text file automatically, that is without having to specify the path (drive and directory) of the application software • link(('CLIC K TO OPEN FILE'),'OPENFILE path to file to be opened and name of the file') • mpl,LINK(('CLICK TO OPENFILE'), 'OPENFILE C:\\mydocu~1\\unesco.doc') UNESCO ICTLIP Module 4. Lesson 4

  19. Linking files in other programs • mpl,link(('CLICK TO OPEN FILE'),'OPENFILE c:\\winisis\bg\\unesco.jpg') • mpl,link(('CLICK TO OPEN FILE'),'OPENFILE http://www.unesco.org) • mpl,link(('CLICK TO OPEN FILE'),'OPENFILE mail to:susan@unesco.org') UNESCO ICTLIP Module 4. Lesson 4

  20. Sorting information • WinISIS print settings allow you to sort information, • The last page of the print dialog box contains the sort parameters UNESCO ICTLIP Module 4. Lesson 4

  21. Sorting information • Sort parameters include the following: • N(umber) of headings: means the number of levels of headings • Stopword file: used when sort keys are generated from a field which is indexed using indexing technique ‘4’. This avoids words like ‘THE’, ‘OR’, ‘AND’ • Heading format: you cn provide your own format or leave it blank, so that the default will be used UNESCO ICTLIP Module 4. Lesson 4

  22. Sorting information • Sort parameters : • Sort key parameters: up to four sort keys may be specified. If more than one record has the same sort key (Author) then a second sort key can be used to sort them. If a record does not have the primary sort key it will not appear in the sorted list. UNESCO ICTLIP Module 4. Lesson 4

  23. Sorting information • Sort key parameters : for each sort key three sets of information have to be provided • Key length:This defines how many characters are to be taken from the specified field. • Heading processing indicator: You can select 0,1,2,or 3. Your choice should depend on what you intend to produce. For example, a catalog card would be 1, and an accession list would be 0 UNESCO ICTLIP Module 4. Lesson 4

  24. Sorting information • A Field selection table: This is similar to the FST lines in the database definition services. Here data are selected to act as sort keys. Eg. 1 0 (v10/) This selects sort key 1 , using the whole field from field 10 (repeatable field) UNESCO ICTLIP Module 4. Lesson 4

  25. Sorting information Completed sorting dialog box UNESCO ICTLIP Module 4. Lesson 4

  26. At this point you should be able to use advanced features in editing and use data validation to minimize errors in data entry and to get a sorted output. Once you finish defining the sort page in the print dialog box you can save the sorted data into a file or get a print out directly as discussed in Lesson 3. UNESCO ICTLIP Module 4. Lesson 4

More Related