Reporting Reduced from Hours to Minutes!
One spreadsheet compared sales trends daily; another weekly; another compared this year to last year. SRI designed and implemented a Microsoft Access application that pulls data directly from the data collection system using ODBC, and generates the sales reports automatically. A task that once took hours now literally takes minutes to perform.
Programming Makes Processes Talk to Each Other
The best package they could find was called WorldTax and ran on Unix and Windows server platforms. However, most of the legacy systems that needed to interface with this package were running on an AS/400. WorldTax provided a programming interface called UTL (Universal Tax Link) but this interface was only offered as a Windows-based DLL.
SRI designed and programmed a Visual Basic WinSock server running on the client's Windows server to make calls to the WorldTax DLL. We also designed and programmed a socket client utilizing the Unix-style API provided by the AS/400 operating system. The AS/400 based socket client was then called by the various AS/400 based legacy applications that needed taxes computed. The socket client connects to the Winsock server, which then calls the WorldTax DLL which returns tax information that is passed back to the AS/400 socket client via the Windows socket server. Pretty cool stuff... AS/400 programs actually calling a process running on a Windows server and doing so at a rate of 20 per second.
SRI discovered a free service called XE which emails you daily with currency conversion factors. We worked with the client's System Administrator to get a special mailbox set up to receive this email. We then utilized Visual Basic and the Outlook API to automatically open this mail box each morning, look for the email, open and parse the email and then update the AS/400-based conversion factor table automatically using ODBC. This saved the client about 30 minutes each day and eliminated errors that sometimes occurred when the clerk would inadvertently key in the wrong conversion factor.
Be Wary of
Mary told them that data could not be converted from Q&A to Access. Mary also told them that Access could not automatically move from one form to another. Mary was obviously misinformed about the capabilities of Microsoft Access! SRI took over from Mary, converted the client's data from Q&A to Access, and accomplished every single thing that Mary said could not be done.
Data to Work for You!
Is Bar Code the Answer?
A large distributor of software needed bar code printing integrated into their existing inventory receiving procedures. They also wanted bar code readers used during order staging to verify that the correct items were pulled. SRI did it ! How did we do it? Our usual way - drawing upon the skills and experience we have acquired in helping hundreds of clients design and install custom solutions.
Four Hour Batch Job Reduced to One Hour
A distributor of sporting goods had a batch job that ran every night on their IBM System/36 minicomputer. This job created a snapshot of the inventory at all of their stores. The snapshot was then downloaded into the retail POS system. After their programmers did everything they thought possible to speed up this batch processing, the job still took four hours to complete.
Software Resources cut the processing time to only one hour, using the same number of records in all of he files involved. How? By using the much maligned and little understood concept of matching records, sequential processing and large buffers. Now this nightly batch job runs in one quarter of the time!
Network Printing Problems Solved
A large local programming firm was having problems with printing on their Novell network. Their staff of experts called us to assist in troubleshooting the problem. Guess what? SRI fixed it!
The problem was occurring because of incompatible versions of their printer
drivers. Our networking experts know the popular hardware and the software
products....and their bugs. Why waste your network administrator's time looking
for the answers to issues we have already encountered? We'll assist you in your
troubleshooting, share our prior experience and provide additional training for
your company's personnel.
An optometrist who sells thousands of pairs of eyeglasses each month was looking to automate his patients' records and billing system. The process of shopping for a new system was quite daunting, so he hired Software Resources to assist him in the process!
Our experienced staff can separate truth from fiction. We prepared a Request for Proposal, then selected the bids that provided for our client's growth and long-term staying power. SRI outlined the pros and cons of these remaining proposals and assisted our customer in making the best decision for their business.
A local software distributor
implemented EDI interfaces into their order entry process and recognized a 50%
increase in productivity efficiencies. By using an EDI package recommended and
SRI, and our customized programming to feed the existing order entry system,
this company was able to accept a tremendous increase in orders without adding
Send mail to
questions or comments about this web site.