A few projects from our files. Each one shows the problem, what we built and what it changed for the client. These write-ups date from 2008, so the product versions reflect that era.
Elmwood Reclaimed Timber: barcode inventory and yard-wide wireless
The client
Established in 1999, Elmwood Reclaimed Timber is an industry leader in milling old timber into flooring, cabinet lumber, beams and other new products: an environmentally friendly alternative to farmed lumber with a richer, more distinctive look.
The situation
Elmwood wanted automatic data collection (ADC) software to improve inventory tracking and purchasing, using barcodes and its existing ERP system.
The technical picture
Like any outdoor lumberyard, Elmwood needs solid wireless coverage to keep inventory accurate. Labels had to be large enough for consistent scanning and tough enough to stand up to the weather, and the software had to work with the existing ERP.
What we did
We chose Maximum Data’s InTouch labeling system, which works directly with Elmwood’s ERP. Tight Solutions refined the user experience and installed wireless equipment so that every work area and lumber storage area has reliable coverage. New inventory is scanned on arrival, finished stock can be looked up from a handheld, and order picking is handled automatically.
The result
Inventory is accurate and searchable by bin number. Inventory data syncs automatically to the sales CRM, so salespeople know what is on hand. Wood is categorized at intake so it can be stored with like materials.
Products and services
- Windows Server 2003, SQL Server 2000 and Great Plains
- Intermec CK30 scanners
- Maximum Data Systems InTouch
- Off-the-shelf D-Link wireless LAN equipment
- IT business consulting
- User experience engineering
Partners
Maximum Data Systems provided the software, Intermec the scanners and Dell the server equipment.
Californos: point of sale, email and a secure network
The client
Californos is a family-owned, French-style bistro with a unique atmosphere and menu. Established in 1988, it has a large space for events and parties.
The situation
The legacy point-of-sale system was becoming too expensive to keep running and left no room for expansion or integration with other systems. Californos is a heavy email marketer, and its POP email was hosted by a third party, which limited access to information and control over this channel.
The technical picture
The original POS system used serial cabling and a text-only interface, with reports printed on a dot-matrix printer. Replacement stations came from a refurbisher at four times the original cost, and problems were hard to diagnose because of the system’s age.
What we did
We built a POS system on standard PC equipment and networking, with access to internal systems such as SharePoint and Exchange web access. Because the equipment is off the shelf, it scales easily. Small Business Server as the back end lets Group Policy govern security on every station, giving a solid, secure platform for front-of-house business and protecting sensitive information. Customer Wi-Fi is kept on a separate network.
The result
Californos now has full control over its main communications channel, and email is accessible from anywhere. The whole system can be supported remotely with standard software. The POS system covers the entire space. Staff can see internal calendars and information on SharePoint while internet access stays restricted. Reports appear on screen and print to any laser printer on the network.
Products and services
- Windows Small Business Server 2003 and Windows XP Professional
- Dell point-of-sale hardware
- Group Policy to secure the POS stations
- Verifone PC Charge
- IT business consulting
- POS design and staff training
Partners
PC America provided the POS software (Restaurant Pro Express). Dell provided the computers, barcode scanners and receipt printers. Verifone provided the credit card processing software.
Triangle Sales: an online order status system
The client
Established in 1947, Triangle Sales serves heating, ventilation and air conditioning (HVAC) contractors with the finest equipment in the industry.
The situation
Customers placed orders through Triangle staff, who recorded each order in a custom program. To schedule their jobs, customers needed to know when equipment would be delivered and when each part of an order would be filled. Status reports went out by email, and customers also called in to check on their orders.
The technical picture
Triangle had a website that could be extended to tie into the existing order database, which had an Access back end that almost any web server can read. All data had to stay in a format Triangle’s own staff could control.
What we did
We developed an ASP.NET interface, using session variables to keep it secure and working across browsers. The data stayed in the existing database format, so the current in-house program needed minimal changes, and all user security lives in a table in that same database.
The result
Customers now have on-demand access to the same order information as Triangle’s staff. An extension looks up tracking details directly from the freight carriers, giving customers a richer experience and control over their own information.
Products and services
- Windows Server 2003
- Visual Web Developer 2008
- .NET 2.0
- Custom programming
What clients say
Great results. Tight Solutions sees the job through.
Bruce Knapp, Alpha and Omega, 2008