Head Start Family Information System
The official HSFIS web site by , the producer of HSFIS. On the Web at www.Cleverex.com

How To's         Page: 1
3/29/2010 10:54:47 AM - Rollover Health information gets rolled over? (Id: 616 )

Yes during Rollover Health information gets rolled over.

6/29/2009 12:43:10 PM - Another HSFIS user... doing back up. Stopped. (Id: 593 )

ISSUE: When attempting to run the Databast Backup from the System Browser the follow error occurs: 'Another HSFIS user may be doing data backup now. Stopped' RESOLUTION: Look inside ..\HSFISx\Tables\ for file BACKLOG.DBF If BACKLOG.DBF is not located in the Tables folder copy from another location the BACKLOG.DBF file and paste inside Tables folder then rerun HSFIS > Database Backup

3/6/2009 9:31:21 AM - BLOB version file is too old (Id: 578 )

PROBLEM: User receives message "BLOB version file is too old".

SOLUTION: Locate the HSFIS_DataDoctor_Utility.exe on the shared network drive S:\HSFIS\Utility. Run this on the user's database with all users logged out of HSFIS.

Launch the .exe file and click "Find Bad Tables". Notify the user that they will lose all comments data that have entered with the associated tables. Click Fix.

After locating the damaged tables, it will make a copy of the corresponding .MDX and .DBT files from the Dbf_Stru folder so the table can be opened. Once the tables are opened, it will copy the records of the .DBF file to a temporary table. Then it will create a new table by copying the .DBF, .MDX and .DBT files from the Dbf_Stru folder. Finally it will copy the records from the temporary table to the newly created empty table.

“Fix Sesn’s Bad Tables” is to designed to fix tables in a single session OR C:\Hsfis6\Tables\Sesn000X

“Fix..\Tables bad tables” is to designed to fix tables in all sessions OR C:\Hsfis6\Tables

Fix ASDT Table will correct duplicate instances of CONTACT_ID in the ASDT.DBF TABLE by:

1. Sorting duplicates by Family_ID + MEMBER_ID +CONTACT_ID + ASDT_DATE.

2. Locate earliest ASDT_DATE record. Do not edit this record.

3. Move duplicate CONTACT_ID records to next available CONTACT_ID record.

1/27/2009 3:31:22 PM - failed finding KEY_FIELD in index in table error (Id: 574 )

ERROR: failed finding key_field in index in (ANY TABLE). SOLUTION: The index is missing the KEY_FIELD and needs to be modified. Find the corresponding table in the Dbf_Stru folder. Open the table. Go to Table > Info Structure. Highlight KEY_FIELD in the right window and click Detail Info. Write down the all the Expression Index information and Subset Condition Filter Expression information. You will need to locate the proper Session in which the KEY_FIELD is missing. Once you locate the correct table, open it and go to Table > Restructure. Click Define > Then click Expression Index. Type in the proper Expression Index information and Subset Condition Filter Expression information exactly as it was displayed in the Dbf_Stru file. Click Ok. Save the index as KEY_FIELD. Pack and Save the table. Run the data doctor.

12/11/2008 3:09:57 PM - dynazip upzip error creating output file (Id: 570 )

PROBLEM: When recovering a database HSFIS yields the error "Dynazip Unzip Error" "Error Creating Output File". The name of the zip file is incorrect. Should be AABack1.zip or AABack(any number).zip. File structure of backup is incorrect. SOLUTION: Unzip the file in My Computer to examine the file structure of the zip file. File structure must be Hsfis6 > Tables where the root folder is Hsfis6. The zip file must be named AABack1.zip or AABack(any number).zip.


©2006 Cleverex Systems, Inc. All rights reserved.