These are chat archives for CORE-POS/IS4C

4th
Aug 2016
Andy Theuninck
@gohanman
Aug 04 2016 00:02
IME EAN-13 and UPC-E covers most of it in grocery, but some bozo might put code39 or code128 on their product. I honestly don't know if the GS1~ prefix behavior works. The "switch" to non-UPC coupon came and went years ago but I've never actually coupons that only have a GS1 barcode in real life
*seen
Asa
@asapdx
Aug 04 2016 00:03
oh, GS1 is for produce
its designed to be on labels on apples & oranges, where the label is less than a tenth of a cent in cost and smaller than a dime in size
We have a few greengrocers who use it
Andy Theuninck
@gohanman
Aug 04 2016 00:04
Among other things. It has [in theory] a massively expanded coupon format that can enough start and expiration dates and complex requirements to purchase sets of several items that aren't enforced in UPC-A or EAN-13
Asa
@asapdx
Aug 04 2016 00:04
they'll scan the GS1 barcode and then set the bag of produce on the scale
ooo, interesting. Never played with it much, jsut remember enabling it
sooo, that gatorade bottle seems to scan perfectly now with this same scale that was scanning only its last 6 digits. I'm just gonna blame this on the settings I changed from default & move on.
scanned it 30 times so far
Andy Theuninck
@gohanman
Aug 04 2016 00:09
Sweet. NCR support or at least active testing is awesome for the bigger picture
Asa
@asapdx
Aug 04 2016 00:13
Mhmm
Next onto Honeywell MS2320 and them Motorola MP6200's
*then
I've run into a few bugs in the dev branch BTW, should I make an issue on github or post it here?
Andy Theuninck
@gohanman
Aug 04 2016 00:15
Issues are better to make sure they don't get missed
Asa
@asapdx
Aug 04 2016 00:15
mk
Andy Theuninck
@gohanman
Aug 04 2016 00:17
Backports of fixes to release branches only happen if they're trivial to understand; complicated will get pushed to [my] production for testing before the next release
Asa
@asapdx
Aug 04 2016 00:18
Yeah
This is all on 2.3-dev
Andy Theuninck
@gohanman
Aug 04 2016 00:20
Gotcha. Master is generally within a couple hours of what I'm running on the backend; lane deployment is more measured
danry25
@danry25
Aug 04 2016 01:35
In Fannie on 2.3-dev, I can't add items, keep getting "Error saving. Try Again?"
I can import items from CSV and duplicate & edit items
danry25
@danry25
Aug 04 2016 02:45
Got the TLP 2824 Plus working and properly aligned to print labels. Now just to figure out labels in Fannie...
Hmm, got the label, but its a touch messed up, and the label printer won't print something so large. Need to figure out how to limit it to the 2" x 1" media format of these shelf tags
Asa
@asapdx
Aug 04 2016 07:40
Hey, are there codes like TL for Discount Invoice & Discount Item (both by percentage)? Also looking for codes for Hold & Print and Recall Hold
LO - logoff seems not to work
Andy Theuninck
@gohanman
Aug 04 2016 12:15
Discount item is <percent>DI<upc>. Discounting the whole transaction is <percent>DA; alternately you could create pseudo members in opdata.custdata with associated discounts. That might make it easier to track why a discount was applied. Suspend and resume transaction are both accessed via MG. Sign out is SO.
Andy Theuninck
@gohanman
Aug 04 2016 12:22
I'd expect a logged SQL error if saving a new item doesn't work. Since edit/import/duplicate work I'd think there's a complaint about some column at a higher MySQL strictness setting (and should be addressed in PHP rather than dialing down strictness)
Andy Theuninck
@gohanman
Aug 04 2016 12:29
Does the label printer present to the OS as more-or-less a normal printer and just expect a document with 2x1 pages? That could be done with a custom tag layout. All the existing one are for printing on sheets of 8.5x11 label stock.
danry25
@danry25
Aug 04 2016 19:40
Yeah, it presents as a normal printer, although I think its a bit of a PITA to have to print a PDF. Wish it could spit out a label when you hit say a quick label button in the Item Maintenance section
Andy Theuninck
@gohanman
Aug 04 2016 19:41
So label printer would be attached to the server or available over the network?
danry25
@danry25
Aug 04 2016 19:41
I got it to print a partially cutoff label by adjusting the media size it was printing to in Firefox. The margins on the top and left of the page prevent about half of it from getting on the label
The TLP2824P supports USB, some variants support ethernet
I have one that supports ethernet
All of them have USB support
Andy Theuninck
@gohanman
Aug 04 2016 19:48
I'm sure it can be done, but it's a very different workflow from what everyone's currently doing. I imagine the server would have to use a different tag layout so the document size (and format) are correct, and then for the quick print idea it'd have to submit the job directly to the printer. I've never done that with a more "advanced" printer. You can mostly just write text directly to receipt printers
danry25
@danry25
Aug 04 2016 19:55
yeah
direct integration like that is something Asa or Finn will handle
danry25
@danry25
Aug 04 2016 20:14
Hmm, so I'm getting this in the error logs when trying & failing to add items in Fannie
/var/www/IS4C/fannie/logs/debug_fannie.log
Aug 4 10:11:14 office-server fannie[647]: (debug) Undefined variable: vendorID Line 964, /var/www/IS4C/fannie/item/modules/BaseItemModule.php
Andy Theuninck
@gohanman
Aug 04 2016 20:18
Hm. That would imply the loop that adds/updates products records is getting skipped. Does the form to enter an item contain any hidden <input> tags named store_id[]?
danry25
@danry25
Aug 04 2016 20:23
Let me check
The only one I see on/fannie/item/ItemEditorPage.php?searchupc=0000530950435 is <input type="hidden" id="upc" name="upc" value="0000530950435" />
Andy Theuninck
@gohanman
Aug 04 2016 20:29
I think there's an issue if there isn't at least one Store in the database. Fixed thusly (CORE-POS/IS4C@ff07056) or you could just create a store (Install page => Stores tab)
danry25
@danry25
Aug 04 2016 20:30
Ah, let me go create a store then
danry25
@danry25
Aug 04 2016 20:36
Are there any docs on what to fill in? Most of it I can pull from /pos/is4c-nf/install, but for Web Services URL, DB Host (I assume an IP goes here) and Delete Entry I'm not sure what to set
Should the former two be the server's IP and the last one be unchecked?
Gave that a go, getting copious error logs and Fannie isn't loading
EditorPage.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "192.168.1.111"
2016/08/04 10:37:51 [error] 564#0: *292 FastCGI sent in stderr: "PHP message: PHP Parse error: syntax error, unexpected '=>' (T_DOUBLEARROW), expecting ')' in /var/www/IS4C/fannie/config.php on line 82" while reading response header from upstream, client: 192.168.1.136, server: , request: "GET /fannie/install/InstallStoresPage.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "192.168.1.111"
Andy Theuninck
@gohanman
Aug 04 2016 20:39
Almost all of it doesn't matter unless you have multiple stores (and even then some of it is old cruft from different approaches to managing multiple stores).
Well that's spiffy. What's line 82 of config.php?
danry25
@danry25
Aug 04 2016 20:42
$FANNIE_STORE_NETS = array(=>array('',),);
Andy Theuninck
@gohanman
Aug 04 2016 20:42
OK, so there's a bug in saving store network ranges. Deleting that line from config.php is the short term fix
danry25
@danry25
Aug 04 2016 20:42
kk
Seems to have fixed it
Ok, onto this other bug I'm running into in Fannie
*** /var/www/IS4C/fannie/logs/debug_fannie.log ***
Aug 4 10:45:08 office-server fannie[647]: (debug) Failed Query on /fannie/modules/plugins2.0/QuickLookups/QuickLookupsEditor.php
SELECT FROM QuickLookups WHERE 1=1 ORDER BY `lookupSet`,`sequence`
Parameters: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM QuickLookups WHERE 1=1 ORDER BY `lookupSet`,`sequence`' at line 1

Aug 4 10:45:11 office-server fannie[647]: (debug) Failed Query on /fannie/modules/plugins2.0/QuickLookups/QuickLookupsEditor.php
INSERT INTO QuickLookups ) VALUES )
Parameters: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') VALUES )' at line 1
danry25
@danry25
Aug 04 2016 20:48
Basically I can't create buttons in quick lookups
Andy Theuninck
@gohanman
Aug 04 2016 20:48
Sounds like the QuickLookups table doesn't exist. If you go to Install => Updates is there anything for QuickLookupsModel?
danry25
@danry25
Aug 04 2016 20:49
QuickLookupsModel has updates available. Details
I assume I should hit that?
SpecialOrdersModel has updates available. Details
PurchaseOrderItemsModel has updates available. Details
I assume all 3?
Andy Theuninck
@gohanman
Aug 04 2016 20:49
Yeah. Details shows the SQL statements it wants to run. Click Here runs them for that model
danry25
@danry25
Aug 04 2016 20:51
Huh, now I get HTTP 400 - Bad Request after pressing Add Entry, but if I refresh the new entry is there.
Only happens on the first time too
Andy Theuninck
@gohanman
Aug 04 2016 20:51
Must be a hiccup that only happens when the table is empty
danry25
@danry25
Aug 04 2016 20:52
yeah
Should I open a bug?
Andy Theuninck
@gohanman
Aug 04 2016 20:52
Sure. Helps keep track of stuff
danry25
@danry25
Aug 04 2016 20:53
kk
Should I do that for the other bug?
Andy Theuninck
@gohanman
Aug 04 2016 20:53
I fixed that one already CORE-POS/IS4C@e776984
danry25
@danry25
Aug 04 2016 20:54
Oh yeah
danry25
@danry25
Aug 04 2016 21:07
So, how'd I change the media size and margins for the Shelf Tag generator?
Andy Theuninck
@gohanman
Aug 04 2016 21:08
You'd have to write a new layout
danry25
@danry25
Aug 04 2016 21:08
I was aimlessly wandering thru https://github.com/CORE-POS/IS4C/tree/master/fannie/admin/labels late last night
Are there defined layout files I should be looking at for reference?
Actually, I think that should probably say "extending FpdfWithBarcode"...
danry25
@danry25
Aug 04 2016 21:09
ah, thanks @gohanman!
danry25
@danry25
Aug 04 2016 22:14
Is there a code to change the grand total of an invoice?
Eg enter the grand total amount?
like $42.23
Andy Theuninck
@gohanman
Aug 04 2016 22:31
I don't follow. The total is the sum of activity on the transaction
Asa
@asapdx
Aug 04 2016 22:34
Yeah, its like Discount Invoice but instead of a percentage it is setting the grand total to a certain dollar amount
Andy Theuninck
@gohanman
Aug 04 2016 22:35
I guess you could add a positive or negative open ring to reach the desired total, but there's no way around adding an item. The math has to work.
Asa
@asapdx
Aug 04 2016 22:36
Yeah, I could just get rid of this key
Andy Theuninck
@gohanman
Aug 04 2016 22:39
It could be done with a dedicated command that looks at the current total and does the math for the cashier to reach the desired total. Round up essentially does that (https://github.com/CORE-POS/IS4C/blob/master/pos/is4c-nf/parser/parse/DonationKey.php); your new command would just need to accept an amount too
Asa
@asapdx
Aug 04 2016 22:40
Mk
Hmm, so I've got the 7878 consistently scanning now, and I see PASS TO POS: 815887010468, but sometimes it doesn't show up in Lane, about 30% of the time. If I scan immediately after it doesn't show up, it works fine. The barcode is always the same at 815887010468 according to the logs tho
And I see PASS TO POS: 815887010468 when it doesn't show up in Lane
Andy Theuninck
@gohanman
Aug 04 2016 22:44
Could there be more than one browser (or window or tab) pointed at the lane instance? Scans & weights will only go to one browser. With more than one trying to read from ss-output the results become random
Asa
@asapdx
Aug 04 2016 22:45
Possibly
I don't see any extra copies open here
But let me check
Andy Theuninck
@gohanman
Aug 04 2016 22:46
If that's the case though the missing scans should show up after refreshing the window. All the browsers would be backed by the same transaction table
Asa
@asapdx
Aug 04 2016 22:46
Mk
Andy Theuninck
@gohanman
Aug 04 2016 22:47
Or actually now that I think about it that would only be if the other window(s) are logged in. If they're signed out or locked they might just eat scans