interfacing with USB barcode scanner NOT as keyboard

[Ben Butler]

Hi Mark,

Something to consider, do you want to store your BLOB in the db or store
the scan on disc outside the DB and store a path / filename in the DB along
with the rest of the record.  It depends on how many scans and how big each
one is as to where they might be best stored. A scan pdf / png from disc
can be served by a web server to clients which would off load this job amd
storage requirements from putting them in a DB.  For example you could
store them in AWS S3 object storage or even a local object server on
premises such as Minio. Digital Ocean data storage prices and OVH /
hetzener pricing is worth looking into.  AWS can also be set to archive S3
into Glacier to further reduce costs.

I see several stages.

Scan capture
Integration with Omnis App
Scan storage
Retreiving and redisplay of scan.

A lot of options and possible approaches are avaiable to you here.

Kind regards

Ben


On Wed, 17 Jun 2020, 19:28 Marc De Roover, <omnis1 at arcict.com> wrote:

> Ben,
>
> That could be an idea but I prefer the “direct” way. I makes the
> situation less error prone imho.
>
>
> Marc
>
>
>
> On 14 Jun 2020, at 23:24, Ben Butler wrote:
>
> > Hi Marc,
> >
> > What about scanning and saving image / meta info to file system and
> > then
> > having an Omnis timer that reads the files within the save directory
> > and
> > pulling them into Omnis / save in DB?  Presumably you will be using
> > some
> > client ware that came with the scanner / does the clientware have an
> > Api
> > you can use to drive the scanner?
> >
> > Kind regards
> >
> > Ben
> >
> > On Sun, 14 Jun 2020, 22:08 Marc De Roover, <omnis1 at arcict.com> wrote:
> >
> >> Dear All,
> >>
> >> Since I this topic seems to be raising some questions and second
> >> thought, let me add some of the “why”
> >>
> >> Advantages of getting data straight from a USB device:
> >>
> >> - the app still can receive the data when being in the background, no
> >> user-interface is needed
> >> - the user can use another app in the front
> >> - USB data can be used to trigger application behaviour ( ex: USB
> >> “foot-switch” )
> >> - most barcode readers can supply valuable information which allows
> >> to
> >> differentiate the read barcode ( ex: not only the data but also:
> >> which
> >> reader; type of barcode; checksum; different pre & trailing info per
> >> barcode type; . . . ) data which is not or very difficult to handle
> >> when
> >> receiving it as keyboard emulated input
> >> - the application can also differentiate the origin of the “data”
> >> (
> >> reader(s) vs keyboard )
> >>
> >> So for us plenty reasons to look into the possibility to get the data
> >> straight for a USB device ( probably easier said then done :-( )
> >>
> >> Just to simplify our wishes; we can live with a Mac only solution
> >> :->)
> >>
> >>
> >> Love the creative Postgres solution ;-)
> >>
> >>
> >> Marc
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> On 12 Jun 2020, at 19:13, Marc De Roover wrote:
> >>
> >>> Hello,
> >>>
> >>> Anybody any experience reading data from a connected USB barcode
> >>> scanner which is NOT acting as a keyboard ?
> >>>
> >>> We need it for MacOS.
> >>>
> >>> Thanks in advance,
> >>>
> >>>
> >>>
> >>> Marc
> >>> _____________________________________________________________
> >>> Manage your list subscriptions at http://lists.omnis-dev.com
> >>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> >> _____________________________________________________________
> >> Manage your list subscriptions at http://lists.omnis-dev.com
> >> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> >>
> > _____________________________________________________________
> > Manage your list subscriptions at http://lists.omnis-dev.com
> > Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>