I’ve not been very active with this site during the last week. There’s lots of stuff going on at work, some of which I will discuss here. As some of you know, I setup an order verification system a couple months ago. I’ve been doing a whole lot more work on that lately. I had to be to our warehouse in Ankeny at 7:00AM on Saturday.
Anyway, we’ve purchased a couple more scanning systems. I’ve almost got two stations in production now. I still have to program a few features into the second flatbed scanner, but that’s no problem. Probably will do that some time today.
I’ll probably start setting up the third and final scanning station sometime today. I’ve also setup a database server in the office in Ankeny. It’s running Slackware 10.1, kernel 2.4.30, and MySQL 4.1.12. It serves all the order data for the verification stations.
That database server is located almost a 1/4 mile away from the actual scanning stations. I setup a wireless network in the cooler/warehouse last week also. I purchased a few Linksys WUSB54G wireless cards for the scanning PC’s. I absolutely love those cards, I even picked one up for myself at home.
Having the database server in place makes my life so much easier. Previously, I’d have to e-mail the order verification data to our warehouse manager nightly and depend on him to upload it. He wouldn’t always upload it and I’d end up getting in trouble. I setup a nice web frontend to the database server. Once our browsers are pointed to the database server, we just select the file that contains the orders from our desktop and upload them to the db server right through a web browser. I don’t have to worry about other people doing their jobs anymore.
Previously, the database was running on the actual verification system. I wanted to have a central place for all the data since we decided to add a couple more scanning stations. I didn’t want one of the verification systems hosting all the data and having the warehouse guys worry about which PC’s they have on. The way it is now, the only machine they have to worry about turning on is the one they choose to verify orders with.
We also re-designed the scanning “table”. It’s much better now. Before there wasn’t much room for them to set their pre-picked food. Now there’s plenty of room. We also purchased LCD monitors for all the stations. They look really slick now. I’ll probably take a couple pictures later on in the week.
So, that’s been the story of my life for the last week. I don’t expect I’ll have to work as much this week as I’ve got most of the hard work done now.
Yesterday, Ashley and I went to Hickory Grove. It’s a little local lake. We just sat out there for about an hour or so. It was really nice out but way too damn windy. Supposed to get up to 90 degrees today. First time it’s been this warm since August of last year.