| HCS | Syllabus | Calendar | Term Project | References | Labs |

Lab #4 - Creating an Internet Bookmark Database Using FM Pro to organize a set of web site addresses Due February 2, 2005

OBJECTIVE: Use FileMaker Pro to organize a set of 30 Internet web sites that compliment the HCS 150 "Introduction to Horticulture" distance education course. The course outline is based on the Ohio Master Gardener Training Manual. See: hcs.osu.edu/mg/manual/ Each of you will select ONE of the 13 main topics of the course. This will be done in class on 1/26. Your Web Quest is to identify topic-appropriatte website that can be used to enhance and expand the content being presented in to training manual outline. Feel free to select from: web pages, tutorials, online publications, videos, and/or FAQ sites. However, do not select from only one source. You need to mix up your selections from University, Commercial, Government, and Individual sources of information. You may utilize any strategy that you choose to identify you web links. For example, PlantFacts, Google, or other search engines. INSTRUCTIONS:

 

STEP 1.	Download a copy of the Hotlinks file that matches your version of FileMaker Pro and uncompress the Zipped file. Version 5 or 5.5 - Hotlinks.fp5.zip Version 7 - Hotlinks.fp7.zip Start FileMaker Pro and open your uncompressed file.
STEP 2.	This template has more fields than we need. Therefore, we need to delete some of the field names and rename others. However, it has a lot of neat stuff ready to go. Click on the button marked View As List. This is a new type of layout. It will display all of your hotlinks on one page, which is great for printing. Switch back to View as Form.
STEP 3.	Click on File, Define Fields. DELETE the following fields: Created by, Date Created, Date Modified, Director, Executive Producer, Film Maker, Format, Info, Letter Box, Minutes, Producer, and Rating. RENAME Appraisal to Address. (Click once on Appraisal, backspace over the name but don't delete the A, type in the remaining letters of Address (ddress), and then click Save. You have to click Save and not Create. By doing this, the field names will change on each of the layouts and you'll have less layout work to do. Repeate these steps and rename: Cast to Concepts, Sound to Source, and Publisher to Parent Site. Keep Category, Title, and Video ID. Your finished list of variables includes: Address, Category, Concepts, Parent Site, Source, Title, and Video ID. Click Done.
STEP 4.	Switch to Layout mode. Click once in the white box containing the various options for the field, Category. Then click on the right mouse button to get options. Choose Field Format. Click once on Category List and then on Define Value Lists... Category List should be highlighted. Click on Edit. Delete all of the current entries in the Category List and replace with the following 11 items: Botany, Soils and Fertilizers, Entomology and Pest Management, Plant Pathology, Plant Propagation, Houseplants, Lawns, Herbaceous Ornamentals, Woody Ornamentals, Vegetables, Herbs, and Fruit . Click OK. Before exiting this area, go ahead and delete the Rating List, Format List, Letter Box List, and Liking List. Click once on Sound List, Click on Edit, and change its values to: University, Commercial, Government, and Individual. Click OK, Done, OK.
STEP 5.	Now you need to rearrange your layout to be more compatible with our project. See Step 8 below for the finished look. You also need to switch the format of the Address field from a Pop-up menu to a Standard style, and change the text at the bottom of the page to "Enter data for hotlinks"
STEP 6.	There is a little work to do on the List View layout. Staying in Layout mode, switch layouts by clicking on the layout indicator just above the rolodex. Choose List View. Move the Video ID field and its label a little to the right. Now you need to add the Parent Site field to this layout. Click on the field tool (located under the button tool on the left side of the screen) and hold down on the mouse button while you drag it over to the space between the Category and Video ID fields. Select Parent Site from the list of available fields and put a check in the box next to Create field label. Click OK. Position the Parent Site label above the field, resize the Parent Site field to fit the space and fill it with a white fill to match the other fields. Add a top and left border line around this field to match the rest. Edit the text at the bottom of the layout to say, "Click to see more information for a hotlink."
STEP 7. Now we want to add a feature that will automatically link your database record to your browser and allow you to jump to any site. Switch to the Form View Layout. Double click on the text that says "Your Own Button" at the top of the layout. Change it to say, "Preview". Position the text field over the center of the empty button on the next to Find Record. See the final layout presented below. Next we need to create a script for connecting to a browser. Click on Scripts, ScriptMaker in the main menu. Type Open URL for the new script name. Click Create. Click Clear All to remove the default settings. Choose Open URL from the list of menu options of the left hand side. It is located under Miscellaneous at the bottom of the list. Click on Move to transfer it to the right hand side of the window. Check the option, Perform without dialog. Click on Specify. Click next to Field Value. Double click on Address. Click OK, OK, Done.
STEP 8. Now, we need to associate Preview with the script just created. In Layout Mode, click once on the Previw text box. Choose Format, Button from the main menu. Click once on Perform Script. Choose Open URL from the list next to Specify. Click OK. Highlight and Copy this button to the List View Layout and delete the unused, "Your own button" text box. That way, you can link to your browser from both layouts. That's all. Now you need to start filling your database.
STEP 9.	For each web site that you want to use: type the name of the page into the Title field highlight and copy the URL address from the browser location window into the Address field put a check next to the appropriate value in the Category field type the name of the parent web site into the Parent Site field type the appropriate key concepts into the Concepts field. Press the TAB key between entries so as to preserve the ordering of the Key Concepts. This type of field is called a Repeating Field. put a check next to the appropriate value in the Source field
STEP 10. Print your first record using the Form View layout. Print all of your records using the List View layout. Transfer your finished file with the approved list of links to my FTP server using the special handout.

| HCS | Syllabus | Calendar | Term Project | References | Labs |

Copyright © The Ohio State University All rights reserved.