The Honeywell QR reader will be our USB serial device to connect.

Recently I’m working on a project where i need to connect two Honeywell QR readers. The model to connect is the YJHF600 through the usb serial communication with a Raspberry Pi. For this i need to get the QR code scanned using golang as code language.

I will do a reader test of the QR code with the python language because the fastest to code and to prototype with this language

How the usb communication for Honeyweel readers works?

Like most barcode readers, QR readers often emulate a keyboard and transmit the scanned information as if had been typed. In other words, our device to which we connect the readers usually see them as if they were a qwerty keyboard.

Some readers can be configurated as usb serial communication. This is the case if the Honeywell YJHF600 QR reader. For this reader all we have to do is scan the configuration code provided in the Honeywell reader manual with the QR readers and they will be automatically configured to generate this serial usb communication.

Testing the usb serial commutication between our Raspberry Pi and our Honewell Qr reader

Since we have configured and connected our serial usb device on the Raspberry Pi, we execute the command

Just as Node.JS has NPM or Ruby has Bundler, in PHP we have PHP Composer. It is a package manager that makes it easier for us to manage the depedencies of the libraries we work with our PHP Projects.

Installing PHP Composer

If you are a windows user, just download the installer always from their official site: https://getcomposer.org/Composer-Setup.exe

I personally work with Debian Linux, but the steps i am going to show you work similarly in Ubuntu and other Debian child distributions.

We download the PHP Composer

curl -sS https://getcomposer.org/installer -o composer-setup.php

We execute your installation

sudo php composer-setup.php --install-dir=/usr/local/bin --filename=composer

Executing the above will throw us the following over the command line.

The objective is to have our own time tracker for our tasks totality free using Google Sheets and Apps Script, to do it we will use a little script with Google Apps Script that will help us to execute this functionality. The functionality is basic but it could help us to build something more powerful if we like coding, at the end of the post you can find the link to the google sheet to clone the sheet.

These are the columns that our excel sheet will have on Google Sheet

• Status (On hold, Start, Pause, Continue, Finished)
• Task (Title)
• Start date
• Closed date
• Tracked Time (hours : minutes)