the reality tunnel

Boxcar Books 6-Year Anniversary Dessert Party and Open House
Saturday, February 2nd 2008
7pm
at 310A S. Washington St.
Boxcar Books is turning 6 years old on February 2nd, and we’re
throwing an open-house and dessert party! For six years, Boxcar has
been proud to be one of many centers of community, culture, and
activism in Bloomington, and we owe our [...]

hey y’all! come help make prom decorations so we can make the
bluebird look sweeeet! this is the biggest fundraiser of the year for
both boxcar and pages, so we really need your help!

details-
- 4pm on sunday (we’ll go for hours, so show up whenever you can)
- sparky’s house/microcosm headquarters (north-west corner of 3rd & [...]

Mass inventory edit feature to Boxcar inventory.  This would allow user to change inventory details for multiple inventory entries all at once. Essentially this would allow you to change everything that you can in the inventory edit form.
Barcode-based inventory entry
Integrate POS and inventory
Make pages card catalog/inventory electronic

Uke of Philips also known as Uke of Spaces, is Dan Beckman from Impractical Cockpit and will play interesting, experimental-acoustic songs.

The top seller queries weren’t working properly so I re-wrote them.  The update implementation is contained in the ‘book top sellers’, ‘books sold in last 2 months’, ‘comic/zine top sellers’, and ‘comics/zines sold in last 2 months’ queries.

The Boxcar online inventory replication program wrapper batch file wasn’t working right because the SSH tunnel to the MySQL server kept dying. So, I modified the wrapper to test to make sure the server was up and then restart the service if it’s not before running the replication. The code looks like this:

mysql [...]

I updated the new_order form so that textbooks from MBS and Nebraska are automatically entered in as used:
Private Sub Form_BeforeInsert(Cancel As Integer)
Me.datestamp = Now()
If Me.distributor = “MBS Textbook Exchange” Or Me.distributor = “Nebraska Book Company” Then
Me.book_state = “Used”
Else
Me.book_state = “New”
End If
Me.status = “On Order”
If IsNull(Me.Order_date.Value) Then
Me.Order_date = Format(Now(), “DD-MMM-YYYY”)
End If
End Sub
I also created a query, [...]

Last week’s Boxcar planning meeting seemed to move too slow for me, which is largely my fault because I was facilitating.  It made me realize that its a bad idea to try to facilitate a discussion when one has a lot to try to think about or say about ideas.  I felt like I was [...]

Feature Request

Books from Nebraska Book Company and MBS should always show up as used when entered into the inventory. (Also, I need to create a query to fix the existing entries.)  The reason why this needs to be done is because currently, the inventory automatically enters all books from distributors as new, but with textbooks [...]

There is no excerpt because this is a protected post.