Data Imports – A Packaging Firm

Industry: Transportation & Logistics
Solution: Data Imports
Technologies: VB.Net, SQL Server
Solution Type: Custom Database Application; Business Process Management; Database Services

APF logo
The company is a leading provider of packaging and unitizing with its value-added packaging solutions. Its comprehensive in-house research and engineering capabilities support and enhance its manufacturing, supply and installation arms. The Woodridge, Illinois, office of this international packaging firm is one of three regional offices in the U.S.

Challenge Challenge - Mountain without Flag

The company was faced with a tax rate import application that could not be used due to poor performance when importing large amounts of data. The impact of this issue on tax compliance needed to be addressed. The company hired alligatortek to streamline and correct their tax rate import operation.

Solution Solution - Mountain with Flag

The company is now able to use its tax rate import application successfully even when importing sizable data files. Large amounts of data are no longer making the regional office’s tax rate import application a problem area. Company staff members are now happier and more productive.
Data Import
Experts at alligatortek were able to resolve issues in the VB code and get the scaled-up functionality online. Following alligatortek’s recommendation, the company authorized alligatortek to design out the Access database step. This allowed alligatortek to enhance the VB.Net component of the import process to do the whole job. This approach reduced the average import time from several hours to only a few minutes.
When receiving tax rate files from third parties, the size of the import file is no longer a concern. The company now easily converts any file to the required format. alligatortek designed a quick, reliable path to the production environment. The VB application now pulls imports directly into the SQL Server database and reports any invalid or missing data for remedial attention. The reporting capability assures that the integrity of the production environment can be constantly maintained.

latest news


How to Use ADFS to Implement Single Sign-On for an ASP.NET MVC Application

Without using any complex code logic, I leveraged Microsoft’s Single Sign-On (SSO) on my existing ASP.NET MVC web application.


10 Ways to Save Money By Hosting On Microsoft Azure

Many companies move to the Cloud to lower costs and offload the management of their IT infrastructure. Once you create resources in the Cloud, there is still more work to do. By considering the list below, you can ensure you are getting the performance you need while keeping your monthly spend in check.


Is AI Making Me Lazy?

Over the course of the last month, I logged the different ways my family used AI-powered devices in my home. Does artificial intelligence mean I can't think for myself? Read what I think in my latest blog – Nate Pave.

Copyright © 2018 alligatortek. All rights reserved.