4-H Home

Software Support Home

4HPlus! Upgrade Information Page

This page highlights changes that have been made to 4HPlus! with the release of each version upgrade.

4HPlus! upgrade 09-280 and 09-295A and 09-300
NOTE: Data updates between each of these upgrades are interchangeable. Any of of these upgrades can be applied without doing the previous ones.

Released to Minnesota users most recently on 10/30/2009

1. SEVERAL minor, but critical fixes in managing and processing 4h4me data.

4HPlus! upgrade 09-273

Released to Minnesota users 10/5/2009

1. SEVERAL Table update and record maintenance fixes.

2. Further implementation of the Communication screen, allowing for cell phone (texting) operations, multiple e-mail addresses, etc. The Communications Data is now included on the Member and Leader Enrollment Reports.

3. Further implementation of the Web Forms tool, to include Member Information form and web form printing utilities.

4. Moved the web related menu items from under "Archive" to it's own menu screen [Web (4h4me.com) Interactions].

5. A new button has been added so that Clubs can be deleted even if there are Inactive members in it.

6. A new button has been added under Utilities to reset/issue passwords just for members/leaders who do not have one already.

4HPlus! upgrade 08-287

Released to Minnesota users 09/16/2008

1. Required upgrade to properly process the ES-237 - accounting for new Racial options Other and Undetermined.

2. Further implementation of the Web Forms tool

4HPlus! upgrade 08-190

Limited release to Minnesota users 07/09/2008

1. Introduced the Forms tool.

2. History Cards now include Achievements.

3. Fixed some bugs it the e-mail component (added scroll bars to the message box, widened the box, fixed how line breaks are handled, will send e-mail if there are two e-mails in the [Email] field etc.)

4. Fixed a bug affecting Years in Project when adding projects to a whole club.

4HPlus! upgrade 08-112

Released to Minnesota users 04/25/2008

1. Implemented the new data tracking feature between 4HPlus! and 4h4me.com.

2. Fixed a bug that kept the Newsletter [Process] button from enabling if newsletter e-mails were sent first

3. Fixed a bug that "offset" the data in the Optional fields when doing an SQL Report or Mail Merge output

4. Fixed some of the screen navigation issues on the Members and Leaders Registration pages

4HPlus! upgrade 08-056

Released to Minnesota users 02/26/2008

1. Fixed the bug where the Current Year field does not update if the registration data was changed and then projects/club data was changed.

2. SQL Mail Merge and the SQL Label file output now give the user an opportunity to specify where the file is saved and what the file will be named.

3. The ES-237 Data Verification routine will now accept the new Race codes (Undetermined and More Than....) when determining if a Member/Leader has valid Race data.

4. The [SQL] [Request] [Labels]...... [Output] to [File] and the Newsletter Utility output to file now includes a header row

5. Leader's Web Password and ID now shows up in the SQL

6. Achievements have been added to the club reports. This is found at [Goto] [Members/Leaders] [Units].... select a club and then click on [Print Unit/Club Report].

7. A new report has been added that will count and list - BY CLUB - the number of members per address. This report will assist in task like putting together "Family" packets and can be found by clicking on [Goto] [Members] [Units] and clicking on [Club Member / Address Counts].

8. When entering new members, any quotes or double quotes entered into the first or last name fields will be stripped (these cause huge problems with various export functions)

9. A report/menu item has been added (in the Member and Leaders sections) that will list the next 50 available Member and Leader ID's. Running this report prior to entering a batch of new members will indicate what ID's those new Members and Leaders will be assigned.

10. Added a field for County when generating SQL Mail Merge, Club Data Export and Group Data Exports at the State level.

11. Added "County" as a preliminary SQL selection option

12. Fixed a bug that following the entry of a New Member, would send the user back to the "New Member" screen even if the List Members option was chosen.

13. Restored the automatic parenthesis in the SQL selection process for fields that can be multi-selected.

14. Added a "Search Completed" label to the progress bar when processing Member or Leader registrations.

15. Added a feature to Factory Utility option #33 that will allow the user to command 4HPlus! to reprocess and upgrade.

16. Fixed a bug that would trap a user in the Archive>Backup screen if the e-mail operation failed.

17. The Archive>Send>Send Data utility will now recognize the "since date" method of generating the file.

18. Fixed a bug on the Support Data>Clubs screen that caused the club name to be inadvertently changed.

4HPlus! upgrade 07-353

Released to Minnesota users 12/21/2007

1. This version upgrade can replace the version 07-317 upgrade which was only available for a short time. (07-136 can be skipped).

2. A number of bug fixes are included (e-mail field space checking locked up 4HPlus!, the new race options will be recognized, the e-mail newsletter utility will work again).

3. The Factory Utility option 33 which checks data file consistency will now also check for consistency with the factory standard for each table.

4. The ES-237 Excel spreadsheet now contains labels and a few new utilities for managing this process (only available at the State level).

5. Fixed a bug in the Group Data section that reset the Units to 1 after selecting Projects (if a number other than 1 had originally been entered.

6. A progress bar was added to the Member and Leader registration screens to indicate the number of total records being examined.

7. An option was added that will allow you to get member project participation counts (male and female) by selecting the desired projects by choosing the desired USDA curriculum code.

4HPlus! upgrade 07-317

Released to Minnesota users 11/21/2007

1. A new utility will check all e-mail addresses for validity - located on the [Main] screen, in the menu bar at the top.

2. Label bar code option added.

3. The ability has been added to handle data from youth who are interested in becoming 4-H members and have submitted their enrollment info via 4h4me.com

4. An SQL bug was fixed that did not entirely clear out the previous request parameters if an E-mail SQL had been requested.

5. Any extra spaces between multiple e-mail addresses will be stripped out upon data entry (Note: if a space exists between e-mail addresses, only the first e-mail address gets stored after sending a message).

6. 2 new Race codes (More Than One and Undetermined) have been added in accordance with a change in the ES-237 report.

7. The beginning work has been done to add an event registration component to 4HPlus! - it is not yet functional.

8. The [Over Age Members] utility has been expanded to allow great flexibility in selecting and reporting.

9. County level Leader Screening has been made possible (but will not be used in MN).

10. The new Federal ES-237 Excel report can be run at the State level.

11. There is a new multi-member assignment system with which you can assign either clubs, projects, or achievements to as many member as you desire at once.

12. The create new year full data archive backup system has been changed so that the system will automatically repeat the file copy process in case errors are found.

4HPlus! upgrade 07-136

Released to Minnesota users 5/16/2007

1. The secure access method for 4h4me.com was implemented (mostly affecting menu items under [Goto] [Archive] [Web Data].

2. After sending an SQL Email, a button will appear that will allow the user to create the mailing labels for those Members or Leaders who met the selection criteria, but do not have an e-mail address. (Note that Member or Leaders who DO have an e-mail address, but were not selected to receive an e-mail will not get a label).

3. An option has been added to the SQL label section that will include labels (or label data) for parents of Members who met the selection criteria, but live at a different mailing address than the member.

4. When making an SQL Report Request, an option has been added to allow sorting by Date of Birth.

5. Also when making an SQL Report Request, an option has been added to sort in either Ascending or Descending order.

6. A new report has been added that lists all the registration data for a member or leader – one page per member/leader. This is found under [Goto] [Members/Leaders] [Reports/Utilities] [Member/Leader Enrollment Registration Report].

7. The Setup screen now provides options to choose the installation year and which data sets map to which years.

8. A couple of new backup "destinations" have been added, including "Flash/Jump Drive" option. The drive letter associated with these destinations is configurable by the user under [Utilities] [Parameters] - for example, to configure a drive letter for a Flash drive, the Parameter is called [Flash/Jump Drive drive letter....].

4HPlus! upgrade 07-012

Released to Minnesota users 1/16/2007

1. The Usage period is extended for 2007

2. The new club data related to Chartering is made functional, including a club data export and the ability to transfer the club data to the State level.

3. Newly entered Members get their "Allow Email Newsletter" (AEN) flag set to Zero, instead of Null

4. A Factory utility is added to set all Null AEN flags to Zero.

5. Errors on the Archive>Backup screen should no longer lock up the entire program.

6. The blank WXDD and WXDU tables are no longer included in the upgrade - meaning that existing Web related changes will not be wiped out by an upgrade.

4HPlus! upgrade 06-346

Released to Minnesota users 12/15/2006

1. The new SSL based (authenticated sending) email system in 4HPlus! was fullly implemented, which will allow e-mail to be sent from all Regional Centers and nearly all County Offices. Other e-mail related changes include:
   • Automatic removal of duplicate e-mail addresses within a batch of e-mails being sent.
   • The ability to enter more than one e-mail address per member or leader - simply enter the multiple addresses, seperated by a comma - limited only by the length of the e-mail field (amount of text that can be stored).
     
     
   • Email setup instructions/settings for MN users are as follows: 
     • Click on [4HPlus Email Setup] (this menu item is found on the [Main] screen)
     • In the upper left corner, under [Select Authentication] click on [Username/Password]
     • Confirm the message box that pops up - click [Yes]
       
       
     • Enter [587] in the [Port] field
     • Enter [smtp.umn.edu] in the [Mail Server] field
     • Enter [your x.500] in the [Username] field
     • Enter [your x.500 password] in the [Password] field
     • Enter nothing in the [HELO text] field (it will fill in automatically when you send an e-mail)
     • Enter [your e-mail address] in the [Sender Email Address] field
     • Enter nothing in the [Sender...] field (it does not yet work)
     • Enter [thomp037@umn.edu] in the [Up Hill Data Email Address] field
     • The rest of the settings on that screen should not need changing to work with the U of MN mail servers.
       
       
     • IMPORTANT - click on the [Save Entries / Changes Button] (upper right corner) before attempting to send e-mail AND any time you make a change on the upper part of this screen - including password changes.
       
       
     • To check the e-mail component, enter your own e-mail address (plus a Subject and Message) and click on [Send].
       
       
2. A new report (four different access methods) to list members and their projects in either ascending or descending order by number of projects the members are taking.
   
   
3. Changes and fixes were made in the Achievements data files area.
   
   
4. A new "complete data file set" backup utility was added - found on the [Archive] [Backup] screen, this utiltity will make a complete copy of the data files (very similar to the copy created during the "New Year" process).
   
   
5. Enhancements to the data upload capabilities for 4h4me.com (i.e. changes are now tracked and reported when data is updated on 4h4me.com).
   
   
6. Three new data file correction routines have been added for solving problems with disk failures.
   
   
7. The Data File Viewer will display (and allow access to) all three year's data tables.
   
   
8. Backup files now contain all of the year and data set information.
   
   
9. The Data Intitialization utility will now correctly remove data in the Local and State Fields.
   
   
10. Fixed a problem that kept the Leaders' "E-mail Newsletter" preference data from working correctly in the Leader SQL tool.
    
    
11. The club reporting and tracking screen has been started, but unfortunately it will not yet store or retrieve data.

4HPlus! upgrade 06-114

Released to Minnesota users April 26, 2006

This upgrade makes the following changes:

1. Extends the usage period for the new year

2. Fixes a problem with displaying achievements

3. Fixes the Allow Newsletters - checked/unchecked status in the data table - which also fixes the problem of SQL searching on the "allow newsletters" field for Leaders.

4. Adds two new Factory Utilities were added that assist in diagnosing table structure problems.

5. 4HPlus! will now properly handle Active Members/Leaders being made Inactive, such that they'll be properly deleted from the 4h4me.com database

6. When an Inactive Member is made Active, a web password will be issued (if none already exists). However, the "Set Active Status" utility still doesn't issue a web password

7. When creating a new member, 4HPlus! will go back and "recycle" available ID numbers

8. The "upgrade" routine for Table and Record changes will now offer, if necessary, a third option (in situations where the requested change cannot be completed) that will allow the user to skip the upgrade and continue on into 4HPlus!

4HPlus! upgrade 05-290

Released to Minnesota users October, 26, 2005

This upgrade makes the following changes:

1. Creates a new table for Achievements and changes how Achievement codes are assigned. Includes tools for converting existing Achievement enrollment to the new system.

2. Correctly assigns web passwords when creating a new member or leader

3. Adds a tool to re-set all user's web passwords

4. Fixed some bugs in the print web action area when processing web download files.

5. Fixed a "data string too long" error message received when creating a backup.

6. Code has been added to process the fact that a 4H4ME county staff access person can now create or delete a club on the web.

7. Adds the ability to send a backup file to more than one person

8. Adds a parameter to auto-size the screen resolution

4HPlus! upgrade 05-227

Released to Minnesota users September, 5, 2005

This upgrade makes the following changes:

1. Expands the number of "local fields" (to 10) and adds 10 new "state fields". (The state fields are not yet being used in MN)

2. Allows the State to send out Parameter changes, including the names of the State Fields (above item)

3. Adds the capability to indicate if a Member or Leader is willing to accept an e-mail instead of a hard copy newsletter. This is done via a check box at the top of each Member's and Leader's Registration screens. This only impacts newsletter e-mails and newsletter labels, as produced on the [Utilities] [Newsletter Labels] screen

4. Added an over-age member's report [Re-enrollment] screen

4HPlus! upgrade 04-302J

Released to Minnesota users February 25, 2005

This upgrade makes the following changes:

1. The usage period is extended until February, 2006

2. The ability to use wildcards ( * ) was added to the DOB (date of birth) field in the Members SQL system.
   • DOB = 09/**/** would give you every member born in September (day and year ignored)
   • DOB = **/10/** would give you every member born on the 10th of any month of any year. (In can not imagine why anyone would want this, but if I left it out, someone would :-)
   • DOB = **/**/85 would give you every member born in 1985 (month and day ignored)
   • You must always use four (4) wildcards in the DOB if you use them at all.
   • If you want all members born in a month in a certain year, do not use wildcards. Use the greater than and less than operators. For example, all members born in September of 1985 could be found by: DOB >= 09/01/85 AND DOB <= 09/31/85
   • Note: If you use wild cards in the Members DOB field during SQL requests, you can ONLY use the ( = ) Equal operator.
     
     
3. A new feature has been added to the SQL section that allows users to change a target value.
• The first step is to create the desired SQL request in the normal fashion (including generating the report)
• Then, the SQL request must be saved - click on [Queue] [Add]
• Type in a name for the SQL request, hit the [Tab] key on your keyboard and click on [Add Now], then [Return]
• Click on [Queue] [Display] and select the desired SQL request from the list, then click on [Process]
• Click on the selection "target" you wish to change, and enter the new value in the [New Target Value] box
• Click on [Replace], then [Process Now] and proceed with the new request
  
  
4. The Web Transfer files are now in the encrypted (ebd) format
   
   
5. When you start the 'Create New Year' process now, there is one more step that creates a full backup of the entire state folder and place it in a new folder, named for the oldest dataset in the folder.
   
   
6. Expands the size of 120 fields in the groups data file from 5 characters to 6 characters to accomodate very large group numbers
   
   
7. Address a handful of ES-237 report issues including fixing the potential for using Achievements for Groups and a handful of state level processing issues
   
   
8. A new menu item has been added: [Members] [Reports/Utilities] [Re-Calculate All Member Ages]. This will have the system re-calculate all member ages at one time (without forcing a re-calculate by changing the actual age Vs. 4H age parameter). This is more relevant for states that use "4-H Age" (MN uses Actual Age).
   
   
9. A bug was fixed for the ES237 bar gauge section 15.1/15.2. This was only a gauge display issue. The ES237 was correctly processing the data, but displaying the wrong count values in the gauge only, the report was fine.