Tools to assist in receiving of inventory from the LDB Store 100 to Infospec's Profitek backend. This branch, api, is intended to work with existing CS3000 infra as detailed below but also with new Zebra Mobile Computers or Symbol MC40s.
After cloning reposity, edit .env and fill in secrets. Followed by running docker-compose -f ldb-compose.yaml up -d --build. The system can be accessed either by an SMB mounted directory or from $IP:5500/bc.
The mounted volume in ldb-compose.yaml should be a SMB directory network accessible unless it is accessible from the computer docker is running on.
If running SMB: the user and/or group of each docker app must have read/write permissions in directory.
PLEASE NOTE That this project is unlikely to receive any further updates.
This image takes the output file from a Motorola CS3000 barcode scanner and formats them into a (mostly) human readable count of all barcodes scanned per shipment.
To make this work with other devices, a barcodes.csv file must be created with the headerless format: %d/%m/%Y, %h:%M:%S, $barcodeType (unused), $barcode per line, an example file would be:
$ cat barcodes.csv
32/13/1966, 13:50:53, 3, C1625575
32/13/1966, 13:50:53, 3, C1625579
32/13/1966, 13:50:54, 3, C1625581
32/13/1966, 13:50:55, 3, C1625582
32/13/1966, 13:50:55, 3, C1625576
32/13/1966, 14:01:46, 3, C1625569
32/13/1966, 14:01:48, 0F, 5918923820
32/13/1966, 14:01:49, 0B, 87614498136
32/13/1966, 14:01:49, 6, 2156843648
32/13/1966, 14:01:50, 6, 64864789
[...]
For future reference the unused field of $barcodeType is in reference to the hexadecimal values (just pretend the 0x is prepended to everything in column 3) of Appendix Table B-1 on the Zebra CS3000/3070 manual. While this information isn't particularly useful in the process of receiving inventory, it is kind of interesting that the majority of barcodes on a particular pallet are Interleaved 2 or 5.
This container processes LDB Store 100 order submission reports. It accepts files matching the regex XOMWOSRPDF_[0-9]+_[0-9]+\.[Xx][Ll][Ss], such as XOMWOSRPDF_1_182719182.xls. The goal of this container is primarily to extract the UPC codes to cross-reference against the output of ldbprocessor-bc and the input of ldbprocessor-ar.
Order Submission Reports are, contrary to the PDF in the file name, html files with a .xls extension. Thanks Oracle BI Publisher.
This container processes LDB Store 100 Accounts Receivable (AR) invoices. It accepts files matching the regex XXARNEWINVOICE_[0-9]+_[0-9]+\.[Xx][Ll][Ss] such as XXARNEWINVOICE_29_1878218921.xls and outputs a headerless csv file matching the format $(date +%Y-%h-%d)-for-PO-import.txt to be imported into the Profitek backoffice. There is as of 2020-05-25 no ability to cross reference files.
AR Invoices are shipped as .xls formatted files.
PureCSS is used with respect to the Pure CSS BSD license