LANSA Data Sync Direct

GDSN and Product Information Management Software for GS1 Compliance

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.


Introducing DQ Inspector



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.

The Impact of Bad Product Data

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 Need for Product Inspection

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.

Reducing Errors

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 captures all the necessary product attributes as defined in the Data Quality Framework.

Native iOS Application

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.

Data Quality Inpsector is a native iOS app

How does the App work?

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:

  1. Download the App from the Apple App Store
  2. Decide how you wish to create a sample set of products to inspect/audit
  3. Create an extract of source data relating to this sample and save as a .csv file (Comma Separated Values). DQ Inspector will expect the .csv file to be formatted as follows: Click here to show/hide the example file format

    Column HeadingDescriptionField TypeMandatory
    BATCHA value to uniquely identify the sample setAlphay
    GTINGlobal Trade Item NumberNumericy
    DESCProduct DescriptionAlphay
    GLN Global Location NumberNumericn
    GPCGlobal Product CategoryNumericn
    GPCDESCGPC DesciptionAlphan
    LOCATIONWhere is the product located physically e.g. Bin numberAlphan
    PACKAGEPackage type (e.g. bag, jar, case, etc)Alphay
    HEIGHTHeight of productNumeric with 2 decimal placesy
    WIDTHWidth of productNumeric with 2 decimal placesy
    DEPTHDepth of productNumeric with 2 decimal placesy
    LINEARUOMDimensions Unit of Measure (e.g. mm, cm, etc)Alphay
    WEIGHTWeight of productNumeric with 2 decimal placesy
    WEIGHTUOMWeight Unit of MeasureAlphay
    NETCONTENTThe net content of pack (weight without packaging)Numeric with 2 decimal placesn
    NETCONTENTUOMNet content Unit of MeasureAlphan
    QTYITEMTotal quantity of next lower level trade itemIntegern
    QTYITEMLAYERQuantity of trade items per pallet layerIntegern
    QTYITEMPALLETQuantity of layers per palletIntegern
    QTYINNERPACKQuantity of Next level trade item within inner packIntegern
  4. eMail the .csv file to an email account that is accessible on the device
  5. Open the file using DQ Inspector
  6. Begin inspecting items and recording values using the inspection work list as a guide (figure 2)
  7. When all products have been inspected the data file can be emailed (along with any other accompanying images, etc.)
  8. The new file is then ready for onward processing - Load into a Business Intelligence Tool, PIM, Excel or LANSA DQ Reporter (Coming soon) to produce DQF Data Quality KPI reports

What does DQ Inspector do?

Key Features

  • Validates attributes against GS1 and GDSN Standards
    • GDSN attribute support
    • GTIN validation
  • Compliant with the principals defined in the GS1 Data Quality Framework (Product Inspection Procedure)
  • Support for the GS1 DQF Master Data Quality KPI's
    • Overall item accuracy
    • Generic attribute accuracy
    • Dimensions and weight accuracy
    • Hierarchy accuracy
  • Built-in GS1 tolerances database for all GS1/GDSN flexible and non-flexible packaging configurations
    • Ability to import customizable tolerances file
  • Support for the inspection of consumer and non-consumer trade items (figures 2, 3 & 4)
  • Annotate item inspection with support for:
    • Text files
    • Video and audio recording
    • Images – including tags for image orientation (Front of Pack, Back of Pack, etc.)
  • Library folder for storing user-defined documents and procedures (figure 1)
  • Built-in file and folder management:
    • Import/export files via email or server
    • Server support for Windows, IBM i (AS/400, iSeries, System i) or Linux
    • Create, rename, delete, etc.
    • Server synchronization
  • Support for Bluetooth devices (HID and SPP**)
    • Barcode scanners
    • Weighing scales
    • Digital calipers
  • Built-in 1D/2D barcode scanner using on-board device camera
  • Tooltips and Help
    • Long-press for help text on all attributes
    • Information icon available on all screens for additional assistance
      • How to measure items (determining front of pack, etc.)
      • Procedures
      • Defining inspection sets
  • Support for English, German, French, Spanish and Japanese

App Screens

 
  • Figure 1 - Library Screen
    Figure 1 – Library
  • Figure 2 - Inspection Worklist
    Figure 2 – Inspection Worklist
  • Figure 3 - Consumer Item
    Figure 3 – Consumer Item
  • Figure 4 - Non-consumer
    Figure 4 – Non-Consumer
  • Figure 5 - Annotation
    Figure 5 – Annotation
  • Figure 6 - File Management
    Figure 6 – File Management

Using DQ Inspector Server Communications

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:

  • Security
  • File Management / Storage
  • Workflow
  • Business Process Integration

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

  • Data Quality Inspector Server Setup
    DQ Inspector Server Setup

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:

Bluetooth Support

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.

Bluetooth Enabling RS232 Devices

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.

Wireless Scanning

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.

Sockets Mobile CHS 7xi

Wireless Weight Recording

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.



KERN Scales Technic - PCB 1000-1

Wireless Dimensions Capture

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.



Sylvac Digital Calipers IP65 Water Resistant

Bluetooth SPP to HID Adapters

LANSA has tested DQ Inspector using hardware acquired from a company called Serial IO. The product used is called BlueSnap SPP-KEY Bridge.

Serialio 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

PACKAGEDESCCONSUMERUNITFLEXIBLEHEIGHTTOLWIDTHTOLDEPTHTOLWEIGHTTOLHGW
AEAerosolNN4.00%4.00%4.00%4.00%N
AEAerosolNY4.00%4.00%4.00%4.00%N
AEAerosolYN7.00MM7.00MM7.00MM4.00%N
AEAerosolYY7.00MM7.00MM7.00MM4.00%N
BAGBagNN4.00%4.00%4.00%4.00%N
BAGBagNY4.00%4.00%4.00%4.00%N
BAGBagYN20.00MM20.00MM20.00MM4.00%N
BAGBagYY20.00MM20.00MM20.00MM4.00%N
BBLBarrelNN4.00%4.00%4.00%4.00%N
BBLBarrelNY4.00%4.00%4.00%4.00%N
BBLBarrelYN7.00MM7.00MM7.00MM4.00%N
BBLBarrelYY7.00MM7.00MM7.00MM4.00%N
BSKBasketNN4.00%4.00%4.00%4.00%N
BSKBasketNY4.00%4.00%4.00%4.00%N
BSKBasketYN7.00MM7.00MM7.00MM4.00%N
BSKBasketYY7.00MM7.00MM7.00MM4.00%N
BINBinNN4.00%4.00%4.00%4.00%N
BINBinNY4.00%4.00%4.00%4.00%N
BINBinYN7.00MM7.00MM7.00MM4.00%N

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.

GS1 / GDSN Attribute Support

For organizations who are not fully GS1 / GDSN compliant, DQ Inspector uses the following attributes:

Packaging Type

PACKAGEDescription
AAAPallet Returnable
AEAerosol
BAGBag
BBLBarrel
BINBin
BMEBlister Pack
BOTBottle
BOXBox
BSKBasket
BXIBox with inner container
BXTBucket
CAGCage
CANCan
CASCase
CCSCan Case
CGCard
CHSChest
CNTContainer
CRTCrate

Unit of Measure

UOMDescription
CTCarton
CMCentimeter
EAEach (Lowest Consumer Selling Unit)
FTFeet
GRGram
INInches
KGKilogram
MMMillimeter
MRMeter
LBPound
  
26Actual Ton
URApplication (UR)
Z51Application (Z51)
ASAssortment
BGBag
BABale
BIBar
BRBarrel