Difference between revisions of "ITrack/Barcodes"

From ISoft Wiki
Jump to navigationJump to search
(→‎Barcode contents: Turning into a table)
(28 intermediate revisions by 5 users not shown)
Line 1: Line 1:
Several elements of ITrack and ITrack software utilize barcodes.  All ITrack products should utilize a similar barcoding scheme.
Several elements of ITrack and ITrack software utilize barcodes.  All ITrack products should utilize a similar barcoding scheme.
== Encoding ==
All bar codes are done via standard [http://en.wikipedia.org/wiki/Code_39 3-of-9].


== Preamble and postamble ==
== Preamble and postamble ==
Line 9: Line 12:
The document screens will take whatever value is between those characters and do a lookup by [[ITrack/Pro/Part Number|partnum]] (the value encoded in barcodes on ITrack Pro tags), and if no values are found by partnum, by UPC (the value encoded into the barcodes printed on most products).
The document screens will take whatever value is between those characters and do a lookup by [[ITrack/Pro/Part Number|partnum]] (the value encoded in barcodes on ITrack Pro tags), and if no values are found by partnum, by UPC (the value encoded into the barcodes printed on most products).


=== Workclock and LX ===
=== Workclock ===
Both the workclock system and LX expect the barcode scanner to provide a preamble and postamble of ':$:'.
The workclock system expects the barcode scanner to provide a preamble and postamble of ':$:'.
 
=== LXW ===
LXW defaults to preamble '~' [126] and postamble '\r' or 'enter' [13], but can be changed via Settings: 'ITrack LX'-'Preamble Character Codes' and 'Postamble Character Codes'
 
http://www.k68.org/wp-content/uploads/2010/11/Key_Codes.htm
 
http://www.west-wind.com/WestwindWebToolkit/samples/Ajax/html5andCss3/keycodechecker.aspx


== Barcode contents ==
== Barcode Formatting ==
Depending on the context, the barcode will encode different types of values.
Depending on the context, the barcode will encode different types of values.


=== Notes on Formatting ===
* The '*' character is never passed on to the client application.
** The '*' character is specific to 5of9 barcodes and should only be include when generating barcodes using the 5of9 barcode font.
** If you use a third party barcode generator or if you are artificially sending scans to a app via javascript, '''DO NOT''' include the '*' character.
***Actually, we should change this page to get rid of '*' on all the barcode formats, then change this note to "ADD * to beginning and end of a 5of9 barcode if you are generating it using 5of9 font".
* Square brackets indicate where actual ids etc  should be placed. 
** They are NOT included in the final barcode.
==== An example to ilistrate using lxw as an example: ==== 
*Given a sales order from store 1 with id 5318008.
*And a format from this wiki as *S[storeid]-[salesorderid]*
;using 5of9 font to print a barcode: 
: *S1-5318008*
;generating a barcode using 3rd party tool or simulating a scan:
: S1-5318008
=== LXW ===
{| class="wikitable"
! scope="col" width="250px" | Objects
! ! scope="col" width="300px" | Barcode Contents
! ! ! scope="col" | Notes
|-
| Inventory
| *[inventoryid]*
| inventoryid must be less than 12 characters
|-
| UPC
| *[raw_UPC]*
| raw_UPC must be numeric only, exactly 12 characters
|-
| Serialized Inventory
| *[inventoryid]-[inventoryserialid]* or *D[inventoryserialid]*
| the D form is only for database version 307 or above
|-
| Location
| *%[locationid]*
|
|-
| Sales Order
| *S[storeid]-[salesorderid]*
|
|-
| Purchase Order
| *P[storeid]-[purchaseorderid]*
|
|-
| Transfer Order
| *T[transferorderid]*
|
|-
| Work Order Job
| *J[jobid]*
|
|-
| ITrack User
| *U[userid]*
|
|-
| OEM Number
| *[any non-empty sequence]*
| Catchall for anything that didn't match
|}
* Encoded location names are currently accepted as alternate location barcode formatting even though it is not standard.
==== Caveats ====
Technically, non-conforming barcode scans that contain letters and numbers are treated as locations as a work-around for an existing setup. However, this behavior is NOT supported in the long-term and will be deprecated and removed without notice. Don't rely on it!
=== Pro Desktop, ITrack Chromium, & LX Pro ===
{| class="wikitable"
! scope="col" width="250px" | Objects
! ! scope="col" width="300px" | Barcode Contents
|-
| Inventory
| *[partnum]*
|-
| Vehicle
| *$[stocknum]*
|-
| Location
| *%[locationname]*
|}
=== Presage ===
{| class="wikitable"
{| class="wikitable"
! Object
! Object
Line 20: Line 116:
! Notes
! Notes
|-
|-
| Inventory
| Sample
| '''[inventoryid]''' OR '''[UPC code]'''
| *S[sampleid]*
| If the number is less than 10 digits, it is assumed to be the primary key of an inventory record (inventoryid in Enterprise, partnum in Pro). Numbers with greater than 10 digits are assumed to be UPC codes.
| Used in barcodes where the users will not be changing the sample's tag number
|-
| Work order
| *W[workorderid]*
|
|-
| Copy Work order
| *<nowiki>WC[Y|N]</nowiki>[workorderid]*
| Copy/Clone a workorder. Specify whether to clone data or not with a Y or N.
|-
| Physical sample (bag)
| *T[tagnumber]*
| Identifies a sample to be submitted to multiple analyses. Is not globally unique, must be paired with a Work Order.
|-
|-
| Location
| Location
| '''%[locationid]''' OR '''[full location name]'''
| *L[locationid]*
| Ideally, location barcodes should be the locationid, prefaced by a % sign.  In some cases, sadly, they may be an unqualified string.
| Identifies a specific location. This represents a specific place at only one plant, and does not care about the location name.
|-
|-
| ITrack user
| Analysis
| '''U[userid]'''
| *A[analysisid]*
| Identifies a specific analysis.
|-
|-
| Work Order Job
| Location+Analysis
| '''J[job id]'''
| *LA[locationid]-[analysisid]*
| Adds a sample to the current workorder with selected analysis and location, then opens the sample for editing.
|-
| Product+Analysis
| *PA[productid]-[analysisid]*
| Adds a sample to the current workorder with selected analysis and product, then opens the sample for editing.
|-
|-
| Sales Order
| Location+Product+Analysis
| '''S[salesorderid]'''
| *LPA[locationid]-[productid]-[analysisid]*
| Adds a sample to the current workorder with selected analysis, location, and product, then opens the sample for editing.
|}
 
=== Work Clock ===
{| class="wikitable"
! scope="col" width="250px" | Actions
! scope="col" width="300px" | Barcode Contents
|-
|-
| Purchase Order
| Clock the selected user into a selected job
| '''P[purchaseorderid]'''
| *+CLOCKIN*
|-
|-
| Serialized part
| Clock the selected user out of an active job
| '''[inventoryid]-[inventoryserialid]'''
| *+CLOCKOUT*
|}
|}


=== Other, context-sensitive ===
== Weaknesses ==
Prefaced with + - Signifies that the rest of the barcode contains a context-sensitive command, which will probably not have meaning outside of magical bar-code applications.
List of things to fix in the current scheme that will cause trouble down the road:
* CLOCKIN - Clocks the selected user into a selected job
* Inventory ID and InventoryID-SerialID are not prefixed, (potentially) overlapping with number-only string location names
* CLOCKOUT - Clocks the selected user out of an active job
* Inventory ID, InventoryID-SerialID, LocationID do not include storeid, requiring it to be guessed at and limiting its effectiveness if not outright causing bugs

Revision as of 12:44, 3 February 2021

Several elements of ITrack and ITrack software utilize barcodes. All ITrack products should utilize a similar barcoding scheme.

Encoding

All bar codes are done via standard 3-of-9.

Preamble and postamble

Virtually every barcode scanner can be programmed to simulate a keypress combination before entering the barcode contents (the preamble) and after (postamble).

ITrack Pro

ITrack Pro document screens (Sales, Quotes, Purchase Orders) expect a preamble of Ctrl+b and a postamble of \n.

The document screens will take whatever value is between those characters and do a lookup by partnum (the value encoded in barcodes on ITrack Pro tags), and if no values are found by partnum, by UPC (the value encoded into the barcodes printed on most products).

Workclock

The workclock system expects the barcode scanner to provide a preamble and postamble of ':$:'.

LXW

LXW defaults to preamble '~' [126] and postamble '\r' or 'enter' [13], but can be changed via Settings: 'ITrack LX'-'Preamble Character Codes' and 'Postamble Character Codes'

http://www.k68.org/wp-content/uploads/2010/11/Key_Codes.htm

http://www.west-wind.com/WestwindWebToolkit/samples/Ajax/html5andCss3/keycodechecker.aspx

Barcode Formatting

Depending on the context, the barcode will encode different types of values.


Notes on Formatting

  • The '*' character is never passed on to the client application.
    • The '*' character is specific to 5of9 barcodes and should only be include when generating barcodes using the 5of9 barcode font.
    • If you use a third party barcode generator or if you are artificially sending scans to a app via javascript, DO NOT include the '*' character.
      • Actually, we should change this page to get rid of '*' on all the barcode formats, then change this note to "ADD * to beginning and end of a 5of9 barcode if you are generating it using 5of9 font".
  • Square brackets indicate where actual ids etc should be placed.
    • They are NOT included in the final barcode.

An example to ilistrate using lxw as an example:

  • Given a sales order from store 1 with id 5318008.
  • And a format from this wiki as *S[storeid]-[salesorderid]*
using 5of9 font to print a barcode
*S1-5318008*
generating a barcode using 3rd party tool or simulating a scan
S1-5318008

LXW

Objects Barcode Contents Notes
Inventory *[inventoryid]* inventoryid must be less than 12 characters
UPC *[raw_UPC]* raw_UPC must be numeric only, exactly 12 characters
Serialized Inventory *[inventoryid]-[inventoryserialid]* or *D[inventoryserialid]* the D form is only for database version 307 or above
Location *%[locationid]*
Sales Order *S[storeid]-[salesorderid]*
Purchase Order *P[storeid]-[purchaseorderid]*
Transfer Order *T[transferorderid]*
Work Order Job *J[jobid]*
ITrack User *U[userid]*
OEM Number *[any non-empty sequence]* Catchall for anything that didn't match
  • Encoded location names are currently accepted as alternate location barcode formatting even though it is not standard.

Caveats

Technically, non-conforming barcode scans that contain letters and numbers are treated as locations as a work-around for an existing setup. However, this behavior is NOT supported in the long-term and will be deprecated and removed without notice. Don't rely on it!

Pro Desktop, ITrack Chromium, & LX Pro

Objects Barcode Contents
Inventory *[partnum]*
Vehicle *$[stocknum]*
Location *%[locationname]*

Presage

Object Barcode contents Notes
Sample *S[sampleid]* Used in barcodes where the users will not be changing the sample's tag number
Work order *W[workorderid]*
Copy Work order *WC[Y|N][workorderid]* Copy/Clone a workorder. Specify whether to clone data or not with a Y or N.
Physical sample (bag) *T[tagnumber]* Identifies a sample to be submitted to multiple analyses. Is not globally unique, must be paired with a Work Order.
Location *L[locationid]* Identifies a specific location. This represents a specific place at only one plant, and does not care about the location name.
Analysis *A[analysisid]* Identifies a specific analysis.
Location+Analysis *LA[locationid]-[analysisid]* Adds a sample to the current workorder with selected analysis and location, then opens the sample for editing.
Product+Analysis *PA[productid]-[analysisid]* Adds a sample to the current workorder with selected analysis and product, then opens the sample for editing.
Location+Product+Analysis *LPA[locationid]-[productid]-[analysisid]* Adds a sample to the current workorder with selected analysis, location, and product, then opens the sample for editing.

Work Clock

Actions Barcode Contents
Clock the selected user into a selected job *+CLOCKIN*
Clock the selected user out of an active job *+CLOCKOUT*

Weaknesses

List of things to fix in the current scheme that will cause trouble down the road:

  • Inventory ID and InventoryID-SerialID are not prefixed, (potentially) overlapping with number-only string location names
  • Inventory ID, InventoryID-SerialID, LocationID do not include storeid, requiring it to be guessed at and limiting its effectiveness if not outright causing bugs