• In case most of you have not noticed, I made changes to the donation amounts as well as the durations for all of the paid membership levels. Things are winding down here, and this seems to be the most prudent way to deal with the "end of life" period of this site.

    Contributor level members - $10 per 30 days
    Sponsors - Eliminated
    Benefactor level members - $25 per 30 days
    Endowment level members - $50 per 30 days

    Account Upgrades Page
  • Responding to email notices you receive.
    **************************************************
    In short, DON'T! Email notices are to ONLY alert you of a reply to your private message or your ad on this site. Replying to the email just wastes your time as it goes NOWHERE, and probably pisses off the person you thought you replied to when they think you just ignored them. So instead of complaining to me about your messages not being replied to from this site via email, please READ that email notice that plainly states what you need to do in order to reply to who you are trying to converse with.

Made My Own Tracking Database

AGoodwin

AGoodwin

Animal Enthusiast
Joined
Jan 17, 2012
Messages
493
Reaction score
20
Points
0
Age
39
Location
Wentworth, NH, USA
This past weekend I decided to make my own database using OOBase. I use and do love iHerp, but I really wanted to have inventory tracking. I looked at Degei but I really did not like it. Now granted it is still a work in progress, my database is now perfectly functional for what I need. I can track feedings, weight, and anything else I want. I can add food items to my inventory, and when I track a feeding, the inventory is automatically adjusted.

What I still need to work on...

I still need to make it so that the list of options for breeding automatically populates and adds new animals as they are added to the database. Right now I have to add to the list manually.

I would also like to make is to that when I track breeding for one animal, the tracking for the second animal involves automatically updates. Again, this currently has to be done manually.

With all that being said. I must say I am proud of myself. :D
 

Attachments

  • Animal Details Preview.jpg
    Animal Details Preview.jpg
    125 KB · Views: 115
  • Feeder Inventory Preview.jpg
    Feeder Inventory Preview.jpg
    98.8 KB · Views: 111
Thanks!

Like I said, it is still a work in progress so I am adding new features and tweaking things as I go, but all in all I am happy with how it is working. I find the tracking is much quicker than on iHerp, however only for individual tracking. I think another feature I am going to add is batch tracking. I think it should be fairly simple to implement. I guess I will see!
 
You are more than welcome to have a copy, but there are a few things to keep in mind.

1) Although the front end looks good and it is completely functional, what is going on behind the scenes is less than optimal. This was only my second DB and I basically just learn as I go so there are a few things that although working, I probably went about implementing the wrong way. (e.g. to get the inventory tracking to work, I have a separate query set up for every item and size combination because I could not figure out how to do it all in one query)

2) As mentioned in my original post, the names of the animals available in the list of breeding options has to be manually added.

There are probably more things I can't think of at the moment, but as I said, you are more than welcome to have a copy of what I have. PM your email and I will send it.
 
Back
Top