Savage Corns Utils and Apps

If you ever have any questions or need any help with any apps on this page send an email to: Help@SavageCorns.com

If you would like to make a donation to help further development, just click the PayPal button below. Donations are completely voluntary, and there is no charge for full use of any of my programs offered here. If you don't have a PayPal account, you can use a credit card through PayPal. Thank you for any and all support!

ScerpDB v0.30 - Herp tracking database application.
- Currently in beta testing, but free to download and use.
Full Download (includes JRE). Use for first time install if you don't already have JRE 6 installed on your computer.
Lite/update download (no JRE). Use this if you already have the program installed and just want the latest updates, or you already have JRE 1.6 installed.

I have confirmed this will work on Linux (Ubuntu, at least). It should also work on MAC, but I do not have any access to a MAC to test or verify. The installer is Windows based, so you will have to set things up manually for Linux and MAC. You may also use this method to manually install on Windows machines, if you wish:
1) Download and install Java 6 Runtime Engine.
a) On my Ubuntu linux machine, I used apt-get to install java 6 jre: sudo apt-get install sun-java6-jre
2) Download hsql database engine and save to "$JAVA_HOME$/lib/ext" folder.
a) On my Ubuntu linux machine, the JAVA_HOME location is: /usr/lib/jvm/java-6-sun/jre
3) Download ScerpDB jar file and save to desired program location.
4) Download ScerpDB icon file and save to desired program location.
5) Start ScerpDB with the following java command (cd to the above created program folder):
- "java -jar scerpdb.jar"
Linux launcher creation
1. Create a new text file in program folder (or anywhere you choose), named "scerpdb.sh"
2. Add the following lines and then save sh file:
#!bin/bash
cd %created program folder location%
java -jar scerpdb.jar
3. Create launcher (in Ubuntu, right-click on desktop) for newly created "scerpdb.sh" file

Fixes/Updates - v0.30

1) Added 'enter' key handling. When filling out data entry forms, you can now submit by pressing the 'enter' key, rather than having to actually click the button. You still can click the button, but sometimes it's just easier to hit 'enter'. Sorry this basic GUI addition took so long to get around to.

Fixes/Updates - v0.29

1) Fixed a bug that affected moving tubs. Added a fix to correct any existing mis-sized tub issues affected by this bug.

Fixes/Updates - v0.28

1) Fixed a bug with gene/morph changes to existing animals. This was preventing changes from the Member Info tab to be saved, so if anyone has been trying to modify existing animal genes and couldn't, this should be working again now. Also, the Morph (Trade Name) field on the Member Info tab has been changed to a display only label, as the value of this field is auto generated based on the animal's gene selections and defined morphs (under Edit... Manage Morhps).

Fixes/Updates - v0.27

1) Added a future feeder order calculator/estimator. Basically, it will take into account the current feed schedules and items that you have set (or use last successful feed type if item has not been set), and calculate how many of each item you would need to order to have a supply for X days. Current on-hand inventory is factored in, so you only see what you need to add. To access, under the Reports menu, click on Future Order Report.

2) You can now specify a default feed item (item must exist in Feeder Inventory) for each animal. This will be used for all feeder/feeding related fields and reports if specified. If you do not set this, then the previous action of using the last successful feed item will still be used. This new field has been added on the animal info panel, next to the feed interval field.

3) Cleaned up some of the report display fields and windows to make things look a little better.

Fixes/Updates - v0.26

1) Fixed an issue with Feed/Clean/Measure Rack actions showing multiple listings for an animal in a multi-slot sized tub.

2) Program will now remember last window size, so next time you open the program, the window size will be set to what it was when last closed.

Fixes/Updates - v0.25

1) Fixed an issue with reports showing multiple listings for an animal in a multi-slot sized tub.

Fixes/Updates - v0.24

1) Made some minor fixes for Linux operation, as well as added internal update ability for Linux. The auto update would only work on Windows installations before.

Fixes/Updates - v0.23

1) Moved the rack operations from the File menu to a new, separate Rack menu. Just to clean up the menus a bit.

2) Added Sales tracking and reporting. When you update member info with a sale price and date, a sale record will be created in the sales tracking db table. You can also add, edit and delete sale records straight from the Tools...Sales Tracker menu item. There is a report window that can be accessed from the Reports menu. It works similarly to the Expense tracking/reporting.

3) Fixed a bug when trying to add a new expense record. The date field had a glitch that was corrected. If you've been having problems adding new expense records, you should be able to now.

Fixes/Updates - v0.22

1) Added ability to feed/clean/measure entire racks at one time. Either right-click in open area of rack frame window or go through the File menu. Individual rack members can be excluded using the check boxes next to each. The date will be the same for all rack members, but individual details can be set for each.

2) The 'Mate' field in activity record updating/create window will now show the name as well as ID to make selection of correct mate easier. If you are more familiar with names than IDs in your collection, this is a good thing.

3) The update available popup announcement window should now show what fixes/enhancements are included in the update. Basically, the same bullet points placed here you will be able to read before agreeing to the update through the program.

Fixes/Updates - v0.21

1) Fixed a bug that was preventing a new installation from starting up.

Fixes/Updates - v0.20

1) Just some minor fixes/tweaks. No new features or enhancements.

Fixes/Updates - v0.19

1) Should've caught this one awhile ago, but better late than never. Mate dropdown lists in pairing/copulation/clutch records are now editable. This will allow specifying a mate that is not in your collection (i.e.: breeding loans) or simply clearing the field if you like to record blank/slug clutches from females not bred in a particular season. The list of available mates in your collection is still there, just now you have a little more flexibility in what value you want to record in the Mate field.

Fixes/Updates - v0.18

1) Just a quick typo/bonehead mistake that I caught in the last update. Nothing functional, so shouldn't cause any problems.

Fixes/Updates - v0.17

1) Added fields to member info tables for recording sire and dam (parentage). Double-click in the sire or dam fields to open a selection popup of available animals in collection, or just type in whatever you want.

2) Added the ability to define registry website URLs as well as a registry number field for each animal. If applicable, when filling in the registry number field and having defined a URL prefix, clicking the Registry Number button on the member info panel will open your default browser to the animals registry page. I have only tested this with American Cornsnake Registry (ACR) site, so it's more or less a use at your own discretion feature. You can manage the registry site URL definitions from the Edit menu. Basically, the URL you define will be prepended to the registry number in the member info and your default browser will be opened to that page. I don't know if there are any registries out there that this could be used with besides the ACR, but if so, have fun.

3) Found a bug with some date field entry issues. Dates were not being saved correctly, so would not show up after being saved. This has been fixed and date fields should be working correctly now.

Fixes/Updates - v0.16

1) Expense Tracking makes it's major league debut. You can now add/track expenses and do some reporting with the records. The Expense Tracker can be found under the Tools menu. You can also directly go to expense reports from the Reports menu, and manage expense categories from the Edit menu. All can also be done from the Expense Tracker tool.

2) A few minor, "behind-the-scenes" tweaks and fixes.

Fixes/Updates - v0.15

1) Dates can now be entered manually, rather than being forced to use popup calendar.

2) Added ability to modify rack size (rows and columns).

3) Added ability to set and change tub sizes within the rack layouts.

Fixes/Updates - v0.14

1) Added ability to set low feeder inventory limits, with alert checking on startup.

2) Added an option to skip all alert checks on startup. This will prevent any of the alert popup windows from opening during program launch.

3) Updated and cleaned up all the EDIT menu options to simplify and improve ease of use.

4) You can now setup custom schedules by species, or across full collection. You can still add schedules to individual animals as well. Also added central schedule manager under the EDIT menu.

5) If you choose to update via the program update check, a backup will be made and saved to your current backup folder before the update is applied. This auto backup will not happen during this update, but for all future updates.

6) Various other minor bugs and tweaks.

Fixes/Updates - v0.13

1) An apostrophe character in a data field would cause a SQL error, which could have caused existing records to be inadvertently modified. This has been corrected and apostrophies should now be processed correctly.

2) Moved all Program Options to single location, under Edit menu.

3) Added option to disable feeder inventory checks when entering feed records.

4) Added ability to setup custom schedules, with an alert report for each animal. Plan to expand on this feature to allow single schedule to apply to all animals, but as of this version, it must be individually assigned. I needed to get item #1 fixed asap, so have not had time to finish the custom scheduling, but decided to include what I had for now.

Fixes/Updates - v0.12

1) Removed Primary Key designation for GENES & MORPHS tables, which could have prevented the addition of genes and morphs.

2) Fixed Locality field in animal details. Should now save entries.

3) Added version check. Default will check for updates when program starts, but can be turned off in File menu. You can also run a manual update check under the Help menu.

4) Updated some file selection buttons to open straight to a file browser, skipping an unnecessary popup frame.

5) Added feeder pick fields to feed due/date reports. Last feed item and quantity now show up to make it quicker and easier to see what food you need to prepare.

Fixes/Updates - v0.11

1) Java Runtime Engine portion of installer fixed

2) The uninstaller was set to completely remove the program folder, which will result in deletion of any existing data when uninstalling the program. I made a change to only remove the program files, so data can still be saved if needed. If you've already installed the original version, installing the updated lite version should update the uninstaller so it will not completely remove the entire program folder if run.

3) Modifying an existing activity record was creating a new record instead of saving the changes to the existing record

4) Modifying a record with an empty date value was throwing an exception

	1)	Added a future feeder order calculator/estimator. Basically, it will take into account the current feed schedules and items that you have set (or use last successful feed type if item has not been set), and calculate how many of each item you would need to order to have a supply for X days. Current on-hand inventory is factored in, so you only see what you need to add. To access, under the Reports menu, click on Future Order Report.
	2)	You can now specify a default feed item (item must exist in Feeder Inventory) for each animal. This will be used for all feeder/feeding related fields and reports if specified. If you do not set this, then the previous action of using the last successful feed item will still be used. This new field has been added on the animal info panel, next to the feed interval field.
	3)	Cleaned up some of the report display fields and windows to make things look a little better.

	1)	Fixed an issue with Feed/Clean/Measure Rack actions showing multiple listings for an animal in a multi-slot sized tub.
	2)	Program will now remember last window size, so next time you open the program, the window size will be set to what it was when last closed.

	1)	Moved the rack operations from the File menu to a new, separate Rack menu. Just to clean up the menus a bit.
	2)	Added Sales tracking and reporting. When you update member info with a sale price and date, a sale record will be created in the sales tracking db table. You can also add, edit and delete sale records straight from the Tools...Sales Tracker menu item. There is a report window that can be accessed from the Reports menu. It works similarly to the Expense tracking/reporting.
	3)	Fixed a bug when trying to add a new expense record. The date field had a glitch that was corrected. If you've been having problems adding new expense records, you should be able to now.

	1)	Added ability to feed/clean/measure entire racks at one time. Either right-click in open area of rack frame window or go through the File menu. Individual rack members can be excluded using the check boxes next to each. The date will be the same for all rack members, but individual details can be set for each.
	2)	The 'Mate' field in activity record updating/create window will now show the name as well as ID to make selection of correct mate easier. If you are more familiar with names than IDs in your collection, this is a good thing.
	3)	The update available popup announcement window should now show what fixes/enhancements are included in the update. Basically, the same bullet points placed here you will be able to read before agreeing to the update through the program.

	1)	Added fields to member info tables for recording sire and dam (parentage). Double-click in the sire or dam fields to open a selection popup of available animals in collection, or just type in whatever you want.
	2)	Added the ability to define registry website URLs as well as a registry number field for each animal. If applicable, when filling in the registry number field and having defined a URL prefix, clicking the Registry Number button on the member info panel will open your default browser to the animals registry page. I have only tested this with American Cornsnake Registry (ACR) site, so it's more or less a use at your own discretion feature. You can manage the registry site URL definitions from the Edit menu. Basically, the URL you define will be prepended to the registry number in the member info and your default browser will be opened to that page. I don't know if there are any registries out there that this could be used with besides the ACR, but if so, have fun.
	3)	Found a bug with some date field entry issues. Dates were not being saved correctly, so would not show up after being saved. This has been fixed and date fields should be working correctly now.

	1)	Expense Tracking makes it's major league debut. You can now add/track expenses and do some reporting with the records. The Expense Tracker can be found under the Tools menu. You can also directly go to expense reports from the Reports menu, and manage expense categories from the Edit menu. All can also be done from the Expense Tracker tool.
	2)	A few minor, "behind-the-scenes" tweaks and fixes.

	1)	Dates can now be entered manually, rather than being forced to use popup calendar.
	2)	Added ability to modify rack size (rows and columns).
	3)	Added ability to set and change tub sizes within the rack layouts.

	1)	Added ability to set low feeder inventory limits, with alert checking on startup.
	2)	Added an option to skip all alert checks on startup. This will prevent any of the alert popup windows from opening during program launch.
	3)	Updated and cleaned up all the EDIT menu options to simplify and improve ease of use.
	4)	You can now setup custom schedules by species, or across full collection. You can still add schedules to individual animals as well. Also added central schedule manager under the EDIT menu.
	5)	If you choose to update via the program update check, a backup will be made and saved to your current backup folder before the update is applied. This auto backup will not happen during this update, but for all future updates.
	6)	Various other minor bugs and tweaks.

	1)	An apostrophe character in a data field would cause a SQL error, which could have caused existing records to be inadvertently modified. This has been corrected and apostrophies should now be processed correctly.
	2)	Moved all Program Options to single location, under Edit menu.
	3)	Added option to disable feeder inventory checks when entering feed records.
	4)	Added ability to setup custom schedules, with an alert report for each animal. Plan to expand on this feature to allow single schedule to apply to all animals, but as of this version, it must be individually assigned. I needed to get item #1 fixed asap, so have not had time to finish the custom scheduling, but decided to include what I had for now.

	1)	Removed Primary Key designation for GENES & MORPHS tables, which could have prevented the addition of genes and morphs.
	2)	Fixed Locality field in animal details. Should now save entries.
	3)	Added version check. Default will check for updates when program starts, but can be turned off in File menu. You can also run a manual update check under the Help menu.
	4)	Updated some file selection buttons to open straight to a file browser, skipping an unnecessary popup frame.
	5)	Added feeder pick fields to feed due/date reports. Last feed item and quantity now show up to make it quicker and easier to see what food you need to prepare.

	1)	Java Runtime Engine portion of installer fixed
	2)	The uninstaller was set to completely remove the program folder, which will result in deletion of any existing data when uninstalling the program. I made a change to only remove the program files, so data can still be saved if needed. If you've already installed the original version, installing the updated lite version should update the uninstaller so it will not completely remove the entire program folder if run.
	3)	Modifying an existing activity record was creating a new record instead of saving the changes to the existing record
	4)	Modifying a record with an empty date value was throwing an exception