Using a CueCat for kitchen inventory.?

Using a CueCat for kitchen inventory.?

Hello, I’m trying to figure out a way to use a hacked CueCat (USB) to inventory my kitchen. More specifically my food on hand. Eventually I’d also like to be able to tie the food one hand to recipes so that I can generate a list of recipes that I can make with what I have on had. I’ve found several web sites that have software available for books, DVD/CD’s, and the like but there doesn’t seem to be anything for the kitchen unless you want to spend a few hundred dollars for a complete inventory system ready made. I’ve read that you can create an inventory keeper in something like MS Access, but sadly I don’t know anything about Access. Does anyone know of a database that someone has created for such an inventory? Any help would be greatly appreciated. Thanks for your time.
Anyone? Anyone at all!?

Tags: , , ,

Under Forum

1 Comment for Using a CueCat for kitchen inventory.?

  • 1. J J  |  December 9th, 2010 at 8:40 am

    Most folks I have seen opt to build their own backend..

    What you would do is have the input from the barcode scanner run though an API for the language of your choice.. this gives you an unique ID that you insert into your database (access for example).. your access table should hold an unique key id.. the barcode id.. and any extra info you mgiht want (like name, brand, etc).

    from there you would want a second table with the uniquie key id and a counter to track how many items of that you have..

    then you would need a recipe table that has its own unique key id, and all the key ids of the food items used to make that receipe..

    simple, right?

    oh, don’t forget the front end of it as well..

Leave a Comment for Using a CueCat for kitchen inventory.?

You must be logged in to post a comment.

Trackback this post  |  Subscribe to the comments via RSS Feed

Categories