It's always rewarding for us to see our products adopted by companies and individuals from nearly any possible area of expertise—and this story will tell you about Kromabatch Srl, an Italian manufacturer of color masterbatches. Their operations involve extensive and regular work with data as well as complex calculations; but the trouble is that their business specifics did not allow using the standard Bill of Materials from the very beginning. A bypass was found in a mixed system that included a commercial ERP, a MySQL database, and Microsoft Excel. However, the system wasn't without its fair share of obstacles.
All of these obstacles called for auxiliary solutions that would deliver the automation of database management and failsafe compatibility with Excel, but none of the tried tools seemed to fit the frame. Eventually, a research conducted by the company's CEO Claudio Maestrini led him to dbForge Studio for MySQL. It had an extensive set of database management tools, it was able to automate recurring operations from the command line, and it came at an attractive price. All in all, the Studio promised a lot, and the next question was whether it would live up to the promise.
It didn't take long until the Kromabatch team set up an automatic input/output procedure between Excel and MySQL using the command line. The human intervention was almost completely eliminated, which saved (and still saves) 5-10 hours of manual work every month. There was nothing that a well-scheduled .bat file couldn't tackle. Moreover, error-free data conversion eliminated the need for double-checks, and the system was finally kept up-to-date without any additional adjustments.
At the end of the day, Kromabatch capably improved their order confirmation process, manufacturing schedule, warehouse management, and cost determination. But the most important thing is the confidence that you've built a clockwork system that you can rely on—and we're happy that our product is part of it.
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.