HomeRoast Digest


Topic: (was +2 Bourbons) now Database (14 msgs / 536 lines)
1) From: Robert Gulley
Mike
Thanks for sharing that link - and DJ - Wow! What a database! I had 
made my own, but NOTHING this good! Also hope Stephen can share his 
friend's excel project with us when the time comes - love to see 
talented people at work!
Robert RG
At 12:53 PM 11/17/2007, you wrote:
<Snip>
"I have measured out my life with coffee spoons."  ~T.S. Eliot  

2) From: David Morgenlender
I'll second Mike's recommendation!  It's been absolutely terrific for all=
 the
things Mike has mentioned.  Now I want to play around with it to learn =
about
entering detailed roast information (profiles, etc.), so I can use it to =
track
that too.  I've only been roasting for a little over a year (& have still
managed to grow a ridiculous stash, in need of computerized tracking!) =
... and
DJ's made significant improvements in that time.
Dave
On Sat, 17 Nov 2007 15:27:44 -0500, you wrote:
<Snip>
recommended.
<Snip>
 have
<Snip>
more.
<Snip>
this
<Snip>
 been
<Snip>
rolling
<Snip>http://sweetmarias.com/maillistinfo.html#personalsettings<Snip>
==========================
==========================
=====
Dave Morgenlender
e-mail: dmorgen
==========================
==========================
=====

3) From: Stephen Carey
--=====================_197755031==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
If my friend, who willing drinks the coffee I give him every two 
weeks, can do it, and it is a massive project with what I want it to 
do - which is why my logs are so big, I take copious notes, 
especially sensory things, plus all of the other elements.
So, if it can be done, it will be there for the taking.  Access may 
be the only way, but this guy is willing to try, I don't have Access 
and just can't buy it for the only program I will use it for - well, 
I might end of doing that if he fails.  But this would be about 
inventory, keeping track from when you roast one bean from a 
particular log, the amount of the green beans goes down 
automatically, plus keeping track of gift roasts, to whom, clients or 
vendor or friends, and all sorts of silly things I use.
It will be there for the taking if it works.  He is working on the 
architecture now, which cost another roast, but worth it.
Have a great night,
Stephen
At 03:27 PM 11/17/2007, you wrote:
<Snip>
--=====================_197755031==.ALT
Content-Type: text/html; charset="us-ascii"
If my friend, who willing drinks the coffee I give him every
two weeks, can do it, and it is a massive project with what I want it to
do - which is why my logs are so big, I take copious notes, especially
sensory things, plus all of the other elements.
So, if it can be done, it will be there for the taking.  Access may
be the only way, but this guy is willing to try, I don't have Access and
just can't buy it for the only program I will use it for - well, I might
end of doing that if he fails.  But this would be about inventory,
keeping track from when you roast one bean from a particular log, the
amount of the green beans goes down automatically, plus keeping track of
gift roasts, to whom, clients or vendor or friends, and all sorts of
silly things I use.
It will be there for the taking if it works.  He is working on the
architecture now, which cost another roast, but worth it.
Have a great night,
Stephen
At 03:27 PM 11/17/2007, you wrote:
Mike
Thanks for sharing that link - and DJ - Wow! What a database! I had made
my own, but NOTHING this good! Also hope Stephen can share his friend's
excel project with us when the time comes - love to see talented people
at work!
Robert RG
At 12:53 PM 11/17/2007, you wrote:
Michael,
DJ Garcia's Access-based roasting/inventory database is highly
recommended.
I would be lost without it -- with it, I know exactly how many greens I
have
on hand, how I've roasted a particular bean before, which crop year
a
particular bean comes from, when I ordered them from SMs, and lots
more.
He updates it pretty regularly, and is active on the list, too.  If
this
were not available, I would have designed one myself, and it would have
been
far less functional.  So thanks, DJ!
Here's the link:
http://improbablystructuredlayers.net/CoffeeRoastingDB/CRDBHome.htm-AdkMike

4) From: Robert Gulley
Stephen -
Sounds like a great trade - bartering in the truest sense of the 
word! How can you put a price on great coffee and great programming!
Robert RG
At 04:22 PM 11/17/2007, you wrote:
<Snip>

5) From: David Morgenlender
Stephen,
I'm not sure whether you need to buy Access to run DJ's database =
application, or
whether it comes with an Access runtime.  I've got Access, so it was =
never an
issue for me.
Dave
On Sat, 17 Nov 2007 16:22:51 -0500, you wrote:
<Snip>
recommended.
<Snip>
I have
<Snip>
more.
<Snip>
this
<Snip>
have been
<Snip>
rolling
<Snip>http://sweetmarias.com/maillistinfo.html#personalsettings<Snip>
==========================
==========================
=====
Dave Morgenlender
e-mail: dmorgen
==========================
==========================
=====

6) From: DJ Garcia
The word "database" on the title woke me up, otherwise I'd miss it as I
don't do one Bourbon, let alone two ...
Thank you for the nice comments! I have a couple of enhancements coming
(profile reports (as opposed to the session ones) the main one) and the
usual bug fixes as I find them (nobody ever complains - OTOH I've had nice
feedback from a couple of you). Comments and suggestions are always welcome,
though I don't want to get involved in tracking costs, and hardware control
which is too involved for a spare time hobby :-).
I also realize there's really not enough documentation on all the features,
so again the struggle with time takes its toll. If you have specific
"how-to" questions e-mail me and I will respond. I'll also incorporate it
into the documentation as I answer. I've been thinking about a tips page,
and your questions would feed that.
Unfortunately my photography has been taking up most of my recent free time,
aided by the great coffee instigated and nurtured by this list. The Panama
Esmeralda Gesha has been making me smile a lot especially after a few days
rest. The database is my way of saying Thanks to you all. But do let me know
if there's anything misbehaving or annoying, and if you have a pet peeve or
wish.
DJ
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Robert Gulley
Sent: Saturday, November 17, 2007 6:33 PM
To: homeroast
Subject: RE: (was +2 Bourbons) now Database
Stephen -
Sounds like a great trade - bartering in the truest sense of the word! How
can you put a price on great coffee and great programming!
Robert RG
At 04:22 PM 11/17/2007, you wrote:
	If my friend, who willing drinks the coffee I give him every two
weeks, can do it, and it is a massive project with what I want it to do -
which is why my logs are so big, I take copious notes, especially sensory
things, plus all of the other elements.
	
	So, if it can be done, it will be there for the taking.  Access may
be the only way, but this guy is willing to try, I don't have Access and
just can't buy it for the only program I will use it for - well, I might end
of doing that if he fails.  But this would be about inventory, keeping track
from when you roast one bean from a particular log, the amount of the green
beans goes down automatically, plus keeping track of gift roasts, to whom,
clients or vendor or friends, and all sorts of silly things I use.
	
	It will be there for the taking if it works.  He is working on the
architecture now, which cost another roast, but worth it.
	
	Have a great night,
	
	Stephen
	
	At 03:27 PM 11/17/2007, you wrote:
	
		Mike
		Thanks for sharing that link - and DJ - Wow! What a
database! I had made my own, but NOTHING this good! Also hope Stephen can
share his friend's excel project with us when the time comes - love to see
talented people at work!
		Robert RG
		
		At 12:53 PM 11/17/2007, you wrote:
		
			Michael,
			
			DJ Garcia's Access-based roasting/inventory database
is highly recommended.
			I would be lost without it -- with it, I know
exactly how many greens I have
			on hand, how I've roasted a particular bean before,
which crop year a
			particular bean comes from, when I ordered them from
SMs, and lots more.
			
			He updates it pretty regularly, and is active on the
list, too.  If this
			were not available, I would have designed one
myself, and it would have been
			far less functional.  So thanks, DJ!
			
			Here's the link:
			http://improbablystructuredlayers.net/CoffeeRoastingDB/CRDBHome.htm
			
			-AdkMike

7) From: DJ Garcia
Unfortunately you do need Access. I've looked into ways of removing the
dependency but as expected they're all more work and $ than is worth for me,
as this is the only place I'd use it.
DJ

8) From: Rick Copple
DJ Garcia wrote:
<Snip>
I too was curious at looking at this, but don't have Access 2000, even 
though on XP. It isn't something that comes standard with MS Office 
basic version. You have to shell out the bucks for it.
Anyway, not knowing how complex that database of yours is, and knowing 
macro/Visual Basic translation would be the biggest issue, how easy 
would it be to translate that into Open Office's database? I think OO 
would import the basic format, but like I say, if you have a lot of 
programming in there, that would be the issue since the language isn't 
the same.
But, at least Open Office's version is free and easily getable by 
anyone, I think even Mac users.
-- 
Rick Copple

9) From: peter
Wow, another great data base in the works. I am envious of he expertise 
it takes to put all of that together.
Would you know if it is also possible to keep track of who you give 
coffee to and when, and if they make 'donations' toward purchases? who 
gives what and when, and then have all that added in individual columns? 
Is this making sense?
Thanks in advance,
PeterZ
Stephen Carey wrote:
<Snip>

10) From: Rich
Open Office is a Java based application and will run on Windows, MAC, 
and Linux as long as Java is installed.  Visual Basic is the real 
stumbling block.
Rick Copple wrote:
<Snip>

11) From: Rich
You can do what you ask in either a spreadsheet or a database.  It will 
work better in a database format though.  If you want to try it go forth 
and download Open Office, it is priced at $0.00 so cost is not a 
problem.  The commands for the spreadsheet and the database mirror the 
windows products.  I do not know what you use to generate the nice front 
end on the database but basically the front end is a pretty face for 
inputting data and the output is forms and or reports.  There is a large 
pile of help and knowledge bases for Open Office so it really should not 
be difficult.
peter wrote:
<Snip>

12) From: DJ Garcia
Rick, Open Office was the first thing I looked at, but it's a complete
rewrite, and a lot more work even if I was starting from scratch. Even a
conversion to plain Visual Basic would be a big rewrite. MS Access does a
lot of stuff for you in the Forms and frankly, although I'm a software
developer / architect by profession and done everything from Cobol & RPG
(yeah, I ain't no spring chicken :-) through C, C++ and Java, I have to hand
it to the Access people.
Many developers sneer at MS Access, but it would take me a lot more work to
do what I did in a straight programming environment that needs to integrate
an external database. If you look at the DB design, I've done a lot of
convoluted stuff to get exactly what I wanted, especially in the Timing
Panel. If you use some creativity and imagination you can get Access to
pretty much jump through hoops with relatively little work using Visual
Basic.
If I was going to be selling it would be a different matter, but this is
basically part of my coffee hobby, hence minimal work rules :-).
DJ

13) From: Robert Gulley
DJ
I for one can't believe such a great database is available, free, 
considering the obvious complexity of the program and the options you 
have given us. The database is a real testament to your skills 
-  equaled only by your generosity in sharing it with us! Obviously 
this program represents many, many hours of programming, but hobbies 
we love do cause us to make those kinds of sacrifices!
with great appreciation,
Robert RG
At 10:48 PM 11/18/2007, you wrote:
<Snip>
"I have measured out my life with coffee spoons."  ~T.S. Eliot  

14) From: Rick Copple
DJ Garcia wrote:
<Snip>
I guessed as much. I'm sure the Visual Basic macros would be the big 
time consuming thing to redo. I can understand your situation, and think 
it is great you have provided that database. But, unfortunately, I don't 
have the money to get Access 2000 so I can't look at what you've got.
I have used Access in the past, and you're right, it is a good, easy 
database to work with.
But I might eventually start my own database in OO. We'll see. But I 
have so much writing projects that I have little time for working on 
that kind of stuff, it seems. I'll have to go revisit your page, but did 
you have a "features" list somewhere there? I'm curious what all the 
database can do even if I can't open it up and look at it, for my own 
ideas eventually.
Thanks for all your work!
-- 
Rick Copple


HomeRoast Digest