Gathering Material-Use Data is Automatic With SQL Server® Link Built Into Conair Blenders
November 25, 2014
Conair is harnessing the power of Microsoft® SQL Server®, the same relational database management system widely used in general business applications, to help plastics processors track how much resin, regrind, color and additives they are using.
Conair gravimetric blender products – including TrueBlend batch blenders, TrueWeigh continuous blenders and TrueWeigh extrusion controls –have always had extensive data-gathering capabilities. Now, however, there is an easy, automatic way to store it in a central database and generate company-wide reports on:
- Shift Inventory Report (each ingredient consumed by shift)
- Total inventory Report (each ingredient consumed)
- Recipe Report (total amount of material usage for ingredients consumed by recipe)
- Resin Report (total amount of material usage for each resin name)
- Job/Order Report (total amount of material usage by order name)
- Product Line Report (total amount of material usage by named product line)
- Alarm log report (list of historical alarms)
- Batch Log Report (Log of every batch made, batch blenders only)
“Material-use reporting software has been available with Conair blenders for years,” says Alan Landers, Blending Product Manager, “but it has been limited to generating reports on what a given blender is doing over a specific period of time. In the new SQL-Server-based system, however, all data generated by all blenders goes into the same database. A well-written query can mine that data for information that help you run your plant more efficiently and more profitably.”
The Conair blender reporting capabilities can also be used with SAP Sybase® SQL Anywhere®.
HOW IT WORKS
Each TrueBlend SB2 touch-panel control (Version 1.08.0 and newer) has the ability to communicate directly with a computer hard drive using SQL Server software and a standard Ethernet TCP network. When the control is first connected with the new database in the SQL Server, it will automatically create all of the data tables and data relationships required. Then, as the blender operates, it will periodically add data to the tables in the database. How often the data is written to the server is programmable depending on user requirements. Once set up, the system operates automatically, continually adding to the data base.
To make use of the data, users can implement Microsoft SQL Server Reporting Services and write a “query” that generates the desired report. A query might look for information on something as general as how much polyethylene has been used plant-wide in the past 3 months. Or, a query could seek very specific data such as how much colorant was processed in Molding Cell #5 during second shift last Monday. Companies with experienced SQL users may choose to write their own queries, or Conair provides standard query templates in system documentation, which then can be installed into SQL Server Reporting Services.
Processors who want to take advantage of the SQL Server reporting capabilities built into their Conair blenders receive a pass code to unlock the data-export port on each blender. An Installation Guide leads the user through the installation of SQL Server software if it is not already installed within the organization. As noted, this system is commonly used for finance, inventory control and other applications in many companies. If it does not already exist, however, Microsoft SQL Server Express software is a free download. A Conair User’s Manual explains step-by-step how data tables are created and how to use a standard Internet browser to use pre-installed report templates.
“There are lots of ways to get material usage data,” acknowledges Landers, “but they tend to be manual, time-consuming and not always accurate. Since every gram of material going through a blender is weighed and recorded, the blender is a great source of usage data. Now, using an existing business software solution like SQL Server, plastics processor can gather valuable data and put it into a universal format automatically, it becomes much easier to make good use of the information.”
About the Conair Group
The Conair Group (www.conairgroup.com) is a leading global supplier of auxiliary equipment for plastics processors, including resin drying systems, blenders, feeders and material-conveying systems, temperature-control equipment and granulators. Extrusion solutions include line-control systems, film and sheet scrap-reclaim systems and downstream equipment for pipe and profile extrusion. Over 450 individual products solve problems, save energy, cut waste and are easy to use. Conair is also an international company, with long-standing operations in Europe, Asia and Latin America. The industry’s most complete product line, top-flight engineering and unbeatable service, all combine to give processors the confidence they need to succeed in today’s competitive global marketplace.