UNHCE Information Technology & Distance Education Blog: YOUTH Blue Ribbon Archives

MarTech is offering a session for county staff training on YOUTH Blue Ribbon software. They are calling it "Queries." It will be: Wednesday, June 28, 2006 2:00 pm Central Time.

It is on-line and requires a high-speed connection. It can be projected using PicTel, or any projection system.

For further info, please contact Judy at MarTech at: judym@martechsys.com - Phone: 715-845-2794

This SQL will delete Social Security numbers from the member records in 4-H YOUTH software.

Update “Youth2a.db”
Set SocSec = Null

This can be copied and pasted into Help|Troubleshooting|SQL .
Go File|Execute and social security numbers are gone.
 

MarTech has shared a SQL which will allow you to create a mailing list of kids from the activity file.

Click here for further information:

This SQL will create a mailing list of kids from the activity file. It is pulling members enrolled in a Creative Arts activity by the ES-237 code. You can modify this by selecting a different code in the line:

And Activity.ES237 <= "BCD"

This works in the State Database when not all counties are using a unified Activity Code file.

Select Distinct Youth.firstname, Youth.lastname, Youth.address, Youth.city, Youth.state, Youth.zip
From "Youth2a.db" Youth
Inner Join "Youth2h.db" YouthAct
On (Youth.MemberID = YouthAct.MemberID)
Inner Join "Youth2g.db" Activity
On (YouthAct.ActivityID = Activity.ActivityID)
Where Activity.ES237 >= "B"
And Activity.ES237 <= "BCD"
And Youth.Age >= "12"
And Youth.Category = "M"
And Youth.Status = 'R'
Order by Youth.Lastname, Youth.firstname

For further information on this SQL or the use of Blue Ribbon Software, contact MarTech.

Here is a SQL (mini-program you can write) for use with the Blue Ribbon software. It will allow you to cull the database for records of leaders with a certain # of years of service. In this example, we are looking for people with 20 or more years. For that reason, I put in the value of >19. You can adjust it according to your needs.

This one is written to be used with the state database. If you are using it with a county database, then you can skip the "countyID" field in the first line.

Select CountyID, Lastname, Firstname, City,Year4H, Category, Status
From Youth2a.db
Where ((Category = "R") or (Category = "P") or (Category = "G") or
(Category = "A"))
And ((Status = "N") or (Status = "R"))
And Year4H > "19"
Order by CountyID, LastName, Firstname

Note that SQLs can be adjusted, listing field names & values.

For further assistance with this process, please contact MarTech.

MarTech made an oversight when rewriting the software for this year. They added a drop-down selection box for the optional school code, but didn't give you a convenient way to add new school codes.

To add school codes to the School Master Code list, you need to first make that an option in the menu system. Page 2-14 in the User's Manual walks through the steps in customizing the menus, which can be used as a reference.

Here are the step-by-step instructions from MarTech for adding the School Code file to the File Menu:

1. On the opening screen in Youth Enrollment, two menu bars appear at the top of the screen. At the far right end of each bar is a small drop down arrow. On the second bar (the one with the colored icons), right click on the drop-down arrow.
2. A menu will appear. Select 'Customize'.
3.The Customize box will appear in the center of the screen. Select the 'Commands' tab.
4. On the next screen a 'Categories' and a 'Command' box will appear.
5. In the 'Categories' box, click on Files. The School Code file is a file option.
6. On the right side of the screen, under 'Commands' , scroll to the end of the list. You will see 'School Codes'.
7. Left click on 'School Codes' to grab it. Hold the mouse key down and drag the menu option to the upper-left corner of the main screen. As you hover over the word 'File', the File Menu will drop down.
8. I usually hang on to the 'School Code' option and move down the file list, dropping it at the bottom of the list.
9. The School Codes option is now on the File Menu. The file can be opened like any other master file. The question has come up as to what to do with leaders. I have suggested creating a school code as 'None' and using it for leaders. Counties have been very happy with this.
Please pass this information on to your counties. They may have the edit the School Code list as they are doing new enrollments for 2006.

We have added a new section to our ITDE help area which contains a wealth of information on the YOUTH software. Sections include FAQs, Fixes, Hints and tips, ES-237 information, and Upgrade information. You can access this new support area at: http://www.ceinfo.unh.edu/cragin/common/documents/BRHntTip.pdf

In an effort to improve support and manage our resources wisely, we are contracting with MarTech, the maker of the Blue Ribbon Youth software, to provide technical support to the end-users of the Youth software in the counties. Information on MarTech support will be made available to Blue Ribbon users once the support contract is formally in place.