This is a workaround for fixing the database in Ponemah v6.30 to permit longer time spans between Glucose MultiCal points to be acceptable.

There are two options to fix the database.

1. Manually open the SQL Database and modify fields as called out in procedure below.
2. Run the attached batch file created by the DSI Software Development team.
1. The batch attachment can be used as a workaround for the issue where the user is unable to modify the MultiCalGroupRange setting.
2. Copy the contents of the .zip file into the C:\Ponemah\Utils\ directory.
3. Double-click on MulticalFix.bat.
4. This will allow the user to modify the setting; however, the user will have to modify both the Glucose.MultiCalGroupRange and the incorrectly spelled Glucose.MultiCalGoupRange. 

Manual SQL Database Update:

1. Navigate to the C:\Ponemah\Utils\SQLBrowser folder.
2. Double-click SQLiteBrowser.exe.
3. In the SQL browser, select File | Open Database.
4. Select C:\Ponemah\P3Plus_630.sql3
5. Select the Browse Data tab
   
   
   
   
6. Use the Table drop down to select the Settings table.
   
   
   
   
7. Scroll down to the Glucose.MultiCalGoupRange (in Hours) – Yes, there is a typo here, that is the problem.  Highlight and copy the text in this field.
   
   
   
   
8. Change the VarValue field to the number of hours desired for use (e.g. 3 hours)
   
   
   
   
9. Select the New Record button.
   
   
   
   
10. A New Record will be added at the bottom. Paste the heading that was copied.
11. Add the letter ‘r’ to correctly spell the word ‘group’.
1. The VarType field MUST be 4.
2. The VarValue field can be whatever value is desired for use in hours (e.g. 3 hours)
   
   
12. Select the Write Changes button.
    
    
    
    
13. Select File | Exit to close the database editor and restart Ponemah.