www.chriscoffee.com: quality & service, second to none

Roasting Profiles Database

Postby NebuK on Sun Jan 06, 2008 10:00 am

Hello World,

if anyone is interested, i developed a roasting profiles database. you can add beans, build blends and then capture (aka enter) profile data while roasting. its still alpha, or maybe pre-beta and not fully functional yet. but i'd really like some feedback on what could be missing and whether the input concepts are suited for roasting (e.g. you have to concentrate on the beans and only secondary enter the data...).

some ideas what could be cool additional features:
- "reroast profile", you get displayed the old profile (current temp, target temp) and have to enter only the new current temp and get plotted a "differences" graph
- cupping profiles for beans, blends and roasts instead of only description fields
- "tree sorting" of profiles, you have a top profile, can flap it open and see all the "reroasts" of this profile

The main problem currently is that i wasnt able to test this on windows yet. If anyone could try and see what windows packages one needs, that would be really nice! The dependencies are:
python, numeric python, qt (4.3), python-qt, qwt5-qt4, python-qwt5-qt4, sqlobject

the program is available via subversion on svn://ghostdub.de/roasterbase or websvn: http://websvn.ghostdub.de/listing...base&path=%2F&sc=0

thanks in advance for trying ;p
- Dario
NebuK
 
Posts: 32
Joined: Nov 25, 2007
Location: Germany

Postby jrfuda on Sun Jan 06, 2008 12:23 pm

I'm working on getting it working right now - never used python before (used java, perl, vbscript). My internet connection is REALLY slow, so it's taking me a while to get all the requisite packages downloaded... I'm still waiting for qt 4.3 to download, which at 70 MB is taking forever with my connection (10-15 kbps due to my location at the time).

So far, this is what I've installed for Windows XP. Install in the order listed!:

I'm still having a problem getting this one installed and working. Follow the directions on the link; it downloads a python installer script and is supposed to download the appropriate package for your OS, but I cannot find the package it downloads!

I'm anticipating that's all it will take. Give me 24 hours; I'll confirm and post feedback.

Thanks a ton for putting this together!
User avatar
jrfuda
 
Posts: 25
Joined: Dec 05, 2007
Location: San Antonio, TX (temporarily displaced from NC)

Postby NebuK on Sun Jan 06, 2008 1:40 pm

Wow, you're really putting effort into this! Thanks alot! i'll work a bit more on the code so it won't disappoint you once you get it running.

once i get xen with windows to run on my box again i can also try and build a windows package for it, but it will be a while until then. sorry!
NebuK
 
Posts: 32
Joined: Nov 25, 2007
Location: Germany

Postby NebuK on Sun Jan 06, 2008 7:26 pm

Okay, fixed the few obvious plot bugs, added the flags for 1st / 2nd crack i had forgotten, added editor for the graph data i captured, and added a export function for the graph.

now i'd be really interested in your comments, bugreports and ideas on the tool.

thanks in advance
- daroi
NebuK
 
Posts: 32
Joined: Nov 25, 2007
Location: Germany

Postby jrfuda on Mon Jan 07, 2008 1:58 am

Having trouble so far, getting this error:
    exec codeObject in __main__.__dict__
  File "C:\Python25\trunk\main.py", line 14, in <module>
    from Numeric import arange
ImportError: No module named Numeric

I'll boot into Ubuntu and try it from there, see if it works any better.
User avatar
jrfuda
 
Posts: 25
Joined: Dec 05, 2007
Location: San Antonio, TX (temporarily displaced from NC)

Postby jrfuda on Mon Jan 07, 2008 2:59 am

I fixed the previous error in Windows by copying:

numeric.py
numerictypes.py
fromnumeric.py
arrayprint.py
umath.pyd
multiarray.pyd

to the /trunk folder

Now I'm getting these errors:

    exec codeObject in __main__.__dict__
  File "C:\Python25\trunk\main.py", line 428, in <module>
    connection = connectionForURI('sqlite://'+db_filename)
  File "C:\Python25\lib\site-packages\sqlobject-0.9.2-py2.5.egg\sqlobject\dbconnection.py", line 1079, in connectionForURI
    conn = self.schemeBuilders[scheme]().connectionFromURI(uri)
  File "C:\Python25\lib\site-packages\sqlobject-0.9.2-py2.5.egg\sqlobject\sqlite\sqliteconnection.py", line 101, in connectionFromURI
    user, password, host, port, path, args = cls._parseURI(uri)
  File "C:\Python25\lib\site-packages\sqlobject-0.9.2-py2.5.egg\sqlobject\dbconnection.py", line 136, in _parseURI
    raise ValueError, "port must be integer, got '%s' instead" % port
ValueError: port must be integer, got '\Python25\trunk\data.db' instead


This is with the previous build. The newest one is asking for a module called "edit" that I cannot find.
User avatar
jrfuda
 
Posts: 25
Joined: Dec 05, 2007
Location: San Antonio, TX (temporarily displaced from NC)

Postby jrfuda on Mon Jan 07, 2008 3:20 am

I removed the previous version of sql lite and installed a different one from sourceforge

Now my error looks like this:
    exec codeObject in __main__.__dict__
  File "C:\Python25\trunk\main.py", line 428, in <module>
    connection = connectionForURI('sqlite://'+db_filename)
  File "C:\Python25\Lib\site-packages\sqlobject\dbconnection.py", line 658, in connectionForURI
    conn = self.schemeBuilders[scheme]().connectionFromURI(uri)
  File "C:\Python25\Lib\site-packages\sqlobject\sqlite\sqliteconnection.py", line 26, in connectionFromURI
    assert host is None, "SQLite can only be used locally (with a URI like sqlite:///file or sql:/file, not %r)" % uri
AssertionError: SQLite can only be used locally (with a URI like sqlite:///file or sql:/file, not 'sqlite://C:\\Python25\\trunk\\data.db')


Is there a way to remove the c:\\.. form the data.db reference so it will be in the right context?
User avatar
jrfuda
 
Posts: 25
Joined: Dec 05, 2007
Location: San Antonio, TX (temporarily displaced from NC)

Postby NebuK on Mon Jan 07, 2008 5:30 am

update the svn rep and try again. if it doesnt work you maybe want to look around line 620 in main.py and modify the url a bit more. it seems that sqlite needs sqlite://C|/foo/bar.

greetings
- dario
NebuK
 
Posts: 32
Joined: Nov 25, 2007
Location: Germany

Postby jrfuda on Mon Jan 07, 2008 5:55 am

Just a note - when I try to download via SVN, I'm prompted for a password (using Tortoise SVN for Windows). I've been getting it via the web and downloading the tarball. I'll get the latest and give it a try.
User avatar
jrfuda
 
Posts: 25
Joined: Dec 05, 2007
Location: San Antonio, TX (temporarily displaced from NC)

Postby NebuK on Mon Jan 07, 2008 6:12 am

Oh, sorry - seems like i forgot to enable anonymous readonly. sorry!
NebuK
 
Posts: 32
Joined: Nov 25, 2007
Location: Germany

Next

Return to Home Roasting