{"id":6685,"date":"2021-01-23T13:04:53","date_gmt":"2021-01-23T13:04:53","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6685"},"modified":"2021-01-23T13:04:59","modified_gmt":"2021-01-23T13:04:59","slug":"wifi-scanner-for-barcodes","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6685","title":{"rendered":"Wifi Scanner for Barcodes"},"content":{"rendered":"\n<p>I was watching the vid below on  AHK and barcode scanners, he tells a story, about 7.20 min in about someone who uses barcodes to record feeding times and cage numbers to speed up record keeping. <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"AutoHotkey How To Use a Barcode Scanner \/ Card Reader With AHK\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/CPjzpYz7dT0?list=PLfHPAKSz_DJrOaWN9klH-Xm6FIfSoeZbi\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>I thought that would be an interesting project for learning about recording data on plants, thinking about OraPharm (My daughter&#8217;s company) and plant monitoring. I could make a bit of a project on monitoring my plants  at home and keeping records on them. <\/p>\n\n\n\n<p>I&#8217;m also interested in using a hand-held scanner and inputting data to PC and what programmes to use to set it up.<\/p>\n\n\n\n<p>There are a few steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Scanner setup with an (Enter\/Return) or Tab after reading, so setting up hand scanner<\/li><li>Connecting Scanner, Bluetooth USB dongle to Mobile phone or PC <\/li><li>What programme to use to record inventory data and how to manage. <\/li><li>Creating Barcodes to use &amp; Scan <\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">1 &amp; 2 Hand scanner<\/h3>\n\n\n\n<p>I looked on TradeMe and decided to buy:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"820\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--1024x820.jpg\" alt=\"\" class=\"wp-image-6686 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--1024x820.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--300x240.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--768x615.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--50x40.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--62x50.jpg 62w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--100x80.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--125x100.jpg 125w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--799x640.jpg 799w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--640x513.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--959x768.jpg 959w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert-.jpg 1331w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/820;\" \/><\/figure>\n\n\n\n<p>This scanner has a vid about itself: <\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Barcode Scanner 1D 2D QR Compatible with Bluetooth &amp; 2.4GHz WiFi &amp; USB Connection &amp; Vibration Alert\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/iHjxfExSiSY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Specs:<\/p>\n\n\n\n<p><em>Tera Wireless 2D QR Barcode Scanner with Stand, 3 in 1 Compatible with Bluetooth &amp; 2.4GHz Wireless &amp; Wired Connection, Connect Smart Phone Tablet PC USB Image Bar Code Reader with Vibration Alert<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><em>Tera Magic Diamond Aiming System &amp; Vibration Alert- Lightning speed read rate coupled with a large depth of field means no more frustrating delays trying to get your scanner at just the right angle or distance. In addition to the buzzer and LED light, when a scan is successful, you receive a tactile signal in the form of a mild vibration. Buzzer can be set to mute to allow for a quiet operation.<\/em><\/li><li><em>Versatile 3-in-1 Transmission- Can work via 2.4Ghz wireless + USB 2.0 wired. It is compatible with Bluetooth as well. Supports Windows and Mac OS; works with QuickBooks, Word, Excel, Novell; and almost all common software. Can be widely used in supermarkets, shopping malls, cosmetic stores, retail industry, postal industry, logistics, banks and medical institutions.<\/em><\/li><li><em>Large 2000mAh Battery, 60 Days Standby- Large 2000mAh built-in battery, standby time can be over 60 days. Continuous scanning time can be up to 16.5-19.5 hours when fully charged. Worry free after one charge.<\/em><\/li><li><em>Shockproof Silicone Design- The bright orange silicone protective cover can avoid scratches and friction while falling from your desk or the shelf. Using the bright orange color will also increase the visual of the barcode scanner when you don\u2019t use or leave it anywhere.<\/em><\/li><li><em>Supported Digital and Printed 1D 2D Code- Symbologies: 1D: Codabar, Code 11, Code93, MSI, Code 128, UCC\/EAN-128, Code 39, EAN-8, EAN-13, UPC-A, ISBN, Industrial 25, Interleaved 25, Standard25, Matrix 2D: QR, DataMatrix, PDF417, Aztec, Hanxin, Micro PDF417. It can read barcode displayed on computer monitor.<\/em><\/li><\/ul>\n\n\n\n<p><em>Specification: Ram: 16MB CPU: ARM Cortex 32 Bit Indicators: Vibration, LED Light, Buzzer Battery capacity: 2000mAh<\/em><\/p>\n\n\n\n<p><em>Package includes: 1 x Tera barcode scanner 1D\/2D 1 x Receiver 1 x USB cable 1 x Stand 1 x User manual<\/em><\/p>\n\n\n\n<p>I have ordered it and am waiting to receive it. It cost $103.99 NZ inc delivery. <\/p>\n\n\n\n<p>The reason I chose this one was of the following list, others had micro USB receivers that would only be good for mobile phones and may not have read DataMatrix or QR codes.  There were 1D scanners but I wanted a more versatile one that was good for testing:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>i<em>t\u00a0is\u00a0wireless,<\/em> and wired &amp; <em>Can work with Bluetooth (so can be paired with a phone)<\/em>&#8211; So good connectability to multiple devices<\/li><li><em>reads\u00a0barcodes,\u00a0QR\u00a0codes\u00a0&amp;\u00a0DataMatrix.<\/em> So flexible in use<\/li><li><em>Charges by cable &amp; data download by cable too<\/em><\/li><li><em>Can work connected or store up to 5000 scans (hence the 16MB RAM)<\/em>. So works to input directly if PC in range, or can store\/download later.<\/li><\/ul>\n\n\n\n<p>I&#8217;ll say more in another article when I receive it and test it. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Data Matrix codes<\/strong><\/h4>\n\n\n\n<p>I hadn&#8217;t heard about DataMatrix (DM) but are standard for small computer components &amp; US Military require them to be used.  The difference between DM and QR is that QR is usually a URL link and it then triggers you to go to that location. <\/p>\n\n\n\n<p>I thought this was a good video on its encoding:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to Decode a DataMatrix by Hand\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/w0xVd2xXySo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>The <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/en.wikipedia.org\/wiki\/Data_Matrix\" target=\"_blank\">Wiki page on DataMatrix <\/a><\/strong> looks interesting too. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. What programmes to use with it<\/h3>\n\n\n\n<p>This is interesting, there is a free Inventory one I want to try called <a rel=\"noreferrer noopener\" href=\"https:\/\/simple-inventory-manager.en.softonic.com\/\" target=\"_blank\"><strong>Simple Inventory Manager <\/strong><\/a>, here is a vid on it:<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Smart Inventory Manager: NADAMOO Wireless Barcode Reader\" width=\"678\" height=\"381\" data-src=\"https:\/\/www.youtube.com\/embed\/3ps4hFjzHhs?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>There are also quite a lot of discussions on using Excel to manage data too, and people demoing it in Notepad too. So I&#8217;m keen to try this out. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Date\/Time. <\/h4>\n\n\n\n<p>This is an interesting thing, getting CURRENT date\/Time to add to a barcode. I did see a cool <strong><a href=\"http:\/\/www.barcodeart.com\/artwork\/clocks\/barcode\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">example of this which runs with JavaScript<\/a><\/strong>: <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"839\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-839x1024.jpg\" alt=\"\" class=\"wp-image-6687 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-839x1024.jpg 839w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-246x300.jpg 246w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-768x938.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-50x61.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-41x50.jpg 41w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-100x122.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-82x100.jpg 82w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-524x640.jpg 524w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-640x782.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-629x768.jpg 629w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox-884x1080.jpg 884w, https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-12_17_41-Barcode-Clock-by-Scott-Blake-\u2014-Mozilla-Firefox.jpg 891w\" data-sizes=\"(max-width: 839px) 100vw, 839px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 839px; --smush-placeholder-aspect-ratio: 839\/1024;\" \/><\/figure>\n\n\n\n<p>And you can <strong><a rel=\"noreferrer noopener\" href=\"http:\/\/www.barcodeart.com\/artwork\/clocks\/barcode\/Barcode_Clock.zip\" target=\"_blank\">download the code.<\/a> <\/strong>I found it hard to scan as it changed every second, but I think you could alter the code so it only showed HH:mm and I&#8217;m going to explore the code to see if you can also modify it to show date as well. Rather a cool clock though. It works on joining individual images together. <\/p>\n\n\n\n<p>You would need this on a screen somewhere so you could scan current\/date time with a scanner. <\/p>\n\n\n\n<p>Some scanners have a built in function for current date time , but they are more expensive scanners that you&#8217;d use. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Excel &amp; Google Sheets <\/h4>\n\n\n\n<p>I&#8217;m interested in creating and organizing an inventory and a watering regime, so updating data on a regular basis, using scans&#8217; barcodes may be an efficient way of doing this &amp; spreadsheets are a great way to manage them too. <\/p>\n\n\n\n<p>If you can&#8217;t put current date\/time in to barcode then you can always update a cell to =NOW() when a new row is created  in an excel sheet (or Google Sheet). <\/p>\n\n\n\n<p><strong>Databases<\/strong><\/p>\n\n\n\n<p>You can only store so much data in a spreadsheet, you do want to push this information into a Database (as these handle vast amounts of data) and are great for querying. <\/p>\n\n\n\n<p>If you use Excel then you are using it locally, whereas Google Sheets would be online, but you need wifi enabled and accessible to be able to use it. <\/p>\n\n\n\n<p>So this is what I want to explore:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>If you can gather lots and lots of data quickly , scanning <\/li><li>how do you gather it? spreadsheets? Good for ordering<\/li><li>Vast amounts of archival data to a database to store &amp; retrieve- to the cloud?  or on a server? Firebase (noSQL) or MySQL (SQL)<\/li><li>Generally data ordered, so want an SQL DB to use. <\/li><li>SQL upload via Excel\/CSV ? <\/li><li>monthly tabs from Excel so that older tabs can be deleted?<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Creating Barcodes<\/h3>\n\n\n\n<p>I have the label maker (I&#8217;d better go find it and dig it out, can&#8217;t find that either at present, in Waikato, so I&#8217;ll have to wait for that to return on Waitangi Weekend (Feb 6th)) and there is a tool for creating the barcodes, which is the programme. <\/p>\n\n\n\n<p>Also you can use <strong><a rel=\"noreferrer noopener\" href=\"https:\/\/www.dafont.com\/theme.php?cat=711\" target=\"_blank\">Barcode Fonts<\/a><\/strong> in Excel &amp; Google Sheets has some inbuilt ones I think, so you can create rows to check you have the right information. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">End comment<\/h3>\n\n\n\n<p>Just talking with Zoe on the phone and they have their own recording system for this, so I&#8217;ll need to explore for my own interest. Shame Label maker is not available, will need to practice with PC info. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was watching the vid below on AHK and barcode scanners, he tells a story, about 7.20 min in about someone who uses barcodes to record feeding times and cage numbers to speed up record keeping. I thought that would be an interesting project for learning about recording data on plants, thinking about OraPharm (My [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6686,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[204,14,32],"tags":[],"class_list":["post-6685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-automation","category-barcoding-building-information","category-power-bi"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--600x400.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2021\/01\/2021-01-24-11_40_45-Barcode-Scanner-with-Bluetooth-2.4GHz-WiFi-USB-Connection-Vibration-Alert--600x600.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6685"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6685\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/6686"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}