Opticon OPN2001 – Flow of bar code reader data output

Firmware, Software and SDK is available on the Opticon website

Barcodes.txt file is created automatically with OPN2001 x64 tool

The format could be personalized with list of fields, best option is as follow:

BarCode Number, Time of Scan, Date of Scan
321530, 21:05:25, 2012-07-11
123456, 21:06:26, 2012-07-11
123456, 21:10:48, 2012-07-11
321530, 21:11:49, 2012-07-11

Need to associate a mission with a UID like YYYYmmDDnnn that should result:

Mission ID, Person ID, Time of Scan, Date of Scan
20120711001, 321530, 21:05:25, 2012-07-11
20120711001, 123456, 21:06:26, 2012-07-11
20120711001, 123456, 21:10:48, 2012-07-11
20120711001, 321530, 21:11:49, 2012-07-11

Procedure should be:

  1. Generate Mission ID code once confirmed, with format like YYYYmmDDnnn
  2. Print the bar code to take note of people available
  3. Once mission start, read first mission ID as marker
  4. Scan all people ID code at start
  5. Once mission end, read first mission ID as marker
  6. Scan all people ID code at end
  7. Connect to USB cable at headquarter
  8. Run the Opticon utility to download the data and create CSV file in PC
  9. Create a custom PowerShell script to modify the RAW data from this format

    BarCode Number, Time of Scan, Date of Scan
    20120711001, 21:00:00, 2012-07-11
    321530, 21:01:01, 2012-07-11
    123456, 21:02:02, 2012-07-11
    20120711001, 22:00:00, 2012-07-11
    123456, 22:01:01, 2012-07-11
    321530, 22:02:02, 2012-07-11

    After the table modification, it should result as follow:

    Mission ID, Person ID, Time of Scan, Date of Scan
    20120711001, 321530, 21:05:25, 2012-07-11
    20120711001, 123456, 21:06:26, 2012-07-11
    20120711001, 123456, 21:10:48, 2012-07-11
    20120711001, 321530, 21:11:49, 2012-07-11

  10. Then import CSV file into SharePoint automatically

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s