ZephyrSoft Toolbox

I began this project because tape and CD ministry in church needs a powerful and reliable tool to organize the whole thing.

It is Java frontend which connects to a MySQL database server. The sermons are organized in a table which can be edited from the frontend.
Then there are abonnements for specific "categories" of sermons which can be set up (examples for categories: SERV-M = morning service, SERV-E = evening service, BS = bible study). The categories in which the sermons are organized can be chosen completely freely, they only have to match the settings for the abonnements (or the other way around). The abonnements generate automatically orders for all new sermons of the category they are set up for.
Of course, orders can be typed in manually, too. There are two different order interfaces: one for managing new orders (the ordering desk part) and one for actually making the copies (the back room part). The back room people mark every order as ready when the are finished with it. The two interfaces synchronize the data with the actual status of the orders (the database content) every 30 seconds, so the desk people know which tapes and CDs are ready.

License: GPL