DQ Inspector is a Data Capture App, built for iPhone, iPad and iPad Mini devices. It is the first of its kind and revolutionizes the Product Inspection process performed in conjunction with the GS1 Data Quality Framework (DQF).
This automated data capture application eliminates many manual steps involved in recording physical attributes associated with the inspection of consumer-packaged goods. Using wireless devices that connect directly to the mobile app via Bluetooth, users carry out physical inspections, recording weights and dimensions without hand-keying data. However, it is also possible to use the app without Bluetooth devices using manual entry.
Data Quality is a top priority for organizations in the supply chain and getting it right first time delivers cost benefits throughout the entire process.
Studies have been conducted by various GS1 Member organisations worldwide that have revealed in quite some detail what the impact of bad product data has on the supply chain. The main impacts identified were around:
Some of these studies can be accessed below:
The GS1 Data Quality Framework (DQF) positions product inspection as a vital component of a Data Quality Management System (DQMS). The purpose of which is to help enhance data accuracy by applying a standardized methodology for the physical inspection and comparison of product data.
The inspection process is a means to verify objectively and reliably the quality of information supplied by an organization, whether that is a manufacturer or retailer.
DQ Inspector reduces the opportunity to generate data quality errors by automating the capture of physical attributes and compiling comparative inspection results that can be used for data quality reporting. Output from DQ Inspector can be loaded into LANSA DQ Reporter (available later in 2013) or simply imported into MS Excel.
DQ Inspector captures all of the necessary product attributes as defined in the DQF.
DQ Inspector is a native iOS application that operates in both a networked and offline environment. The App has an embedded file management and communications system that allows the user to import product inspection sets in a variety of formats, including Microsoft Excel, from either a server or when sent as email attachments. The user can perform an inspection against that data and return the results file via the same route.
This data can be consumed by a Product Information Management (PIM) system or Business Intelligence (BI) tool to initiate workflow activities and generate GS1 Compliant Data Quality reports following the principals defined in the GS1 Data Quality Framework.
Sticking to LANSA's core principals – Advanced Software Made Simple – the App has been designed to be as intuitive as possible. It can be used in conjunction with the GS1 Data Quality Framework or according to your organization's internal procedures for carrying our product data quality audits. Both approaches however rely upon the unique key - GTIN (Global Trade Item Number).
The steps involved are as follows:
|Column Heading||Description||Field Type||Mandatory|
|BATCH||A value to uniquely identify the sample set||Alpha||y|
|GTIN||Global Trade Item Number||Numeric||y|
|GLN||Global Location Number||Numeric||n|
|GPC||Global Product Category||Numeric||n|
|LOCATION||Where is the product located physically e.g. Bin number||Alpha||n|
|PACKAGE||Package type (e.g. bag, jar, case, etc)||Alpha||y|
|HEIGHT||Height of product||Numeric with 2 decimal places||y|
|WIDTH||Width of product||Numeric with 2 decimal places||y|
|DEPTH||Depth of product||Numeric with 2 decimal places||y|
|LINEARUOM||Dimensions Unit of Measure (e.g. mm, cm, etc)||Alpha||y|
|WEIGHT||Weight of product||Numeric with 2 decimal places||y|
|WEIGHTUOM||Weight Unit of Measure||Alpha||y|
|NETCONTENT||The net content of pack (weight without packaging)||Numeric with 2 decimal places||n|
|NETCONTENTUOM||Net content Unit of Measure||Alpha||n|
|QTYITEM||Total quantity of next lower level trade item||Integer||n|
|QTYITEMLAYER||Quantity of trade items per pallet layer||Integer||n|
|QTYITEMPALLET||Quantity of layers per pallet||Integer||n|
|QTYINNERPACK||Quantity of Next level trade item within inner pack||Integer||n|
A key feature of DQ Inspector is the ability to setup server connections.
Using email to import and export sample sets, images, videos, etc. could become unwieldy. A server connection would allow the more efficient transport of data in a more secure environment, capable of handling larger volumes of data. The key benefits of using the server functionality are:
The server functionality requires a software component to be installed on the destination server(s). This software is not free of charge. For further information Contact Us
As well as being able to use the application manually, using wireless devices that connect directly to the mobile app via Bluetooth is the recommended option. Automatic data capture removes the 'human element' and the risk of introducing new errors.
DQ Inspector Supports:
Mobile devices like the iPhone and iPad are configured to support Bluetooth HID (Human Interface Device) peripherals. These typically take the form of keyboards, mice, headsets and scanning devices. When these types of devices are acquired a user would typically follow the pairing instructions provided with the device.
There are also a number of other devices on the market that support Bluetooth but not referred to as Human Interface Devices. These peripherals are usually industrial equipment. These devices use a protocol called Bluetooth SPP (Serial Port Profile). Apple iOS devices (like iPhone and iPad) do not support this protocol, so caution is advised when acquiring peripherals to use with DQ Inspector.
Non-human interface devices (like weighing scales and calipers for example) often come with an RS232 Interface. RS232 is a serial port. These devices can be used with DQ Inspector by Bluetooth-enabling the device via the RS232 port. There are products available on the market that plug-in to the RS232 port that allows the port to receive serial input via a Bluetooth transmission, however the protocol used is Bluetooth SPP. In this situation an additional adapter is then required to convert Bluetooth SPP to Bluetooth HID. Contact LANSA for further information about this technology.
There are many Bluetooth HID compliant scanners on the market and LANSA DQ Inspector will support these devices out-of-the-box. Simply follow the pairing instructions provided by the vendor before using DQ Inspector.
DQ Inspector barcode scanning has been tested using the Sockets Mobile CHS 7xi.
LANSA has been unable to source Bluetooth HID compliant scales because these peripherals are not typically referred to as Human Interface Devices. Support for wireless weighing equipment must therefore demand that the device contains an RS232 port. DQ Inspector weight recording has been tested using KERN PCB scales by Bluetooth enabling the RS232 port and using an SPP to HID adapter.
Due to the nature of the SPP to HID conversion, it maybe necessary for LANSA to build individual support for other devices. DQ Inspector comes pre-configured to support KERN PCB scales. LANSA can provide support and assistance in this matter.
LANSA has also been unable to source Bluetooth HID compliant calipers because these devices are not referred to as Human Interface Devices. Support for wireless dimensions capture must therefore demand that the device also contains an RS232 port. DQ Inspector dimensions capture has been tested using Sylvac Digital Calipers by Bluetooth enabling the RS232 port and using an SPP to HID adapter.
Due to the nature of the SPP to HID conversion, it maybe necessary for LANSA to build individual support for other devices. DQ Inspector comes pre-configured to support Sylvac Digital Calipers. LANSA can provide support and assistance in this matter.
LANSA has tested DQ Inspector using hardware acquired from a company called Serial IO. The product used is called BlueSnap SPP-KEY Bridge.
DQ Inspector has been designed and developed to fully support GS1 and GDSN standards. A key component of which is the validation of inspected items against GS1 DQF measurement tolerances associated to packaging types. DQ Inspector comes pre-configured to support the most up-to-date tolerance specification set by GS1. When each inspection is complete a copy of this tolerance file is created to accompany the finished inspection file. The file is called 'packaging.csv' and it looks like this: Click here to show/hide the example file format
The user can submit a customized version of this file to audit against a different set of tolerances if required. Click here to download the default packaging/tolerances file
For example, if your organization is not using GS1 packaging codes or the source file does not contain GS1 standard packaging codes then you must create a 'packaging.csv' file representing the correct codes. Without these tolerances an audit can not be conducted properly.
For organizations who are not fully GS1 / GDSN compliant, DQ Inspector uses the following attributes:
|BXI||Box with inner container|