99,000 lines in the stock table

Make comments, ask questions, or just complain about the software on this site. Or comment on any educational software.
Please note that by clicking on links that may appear in these posts that you may be leaving the Dale Harris Educational Software website and that the content of those sites is the sole resposibility of the authors of those sites.

Moderators:daleadmin, Dale Harris, Alan, Andrew

cpb14
Forum Regular
Posts:56
Joined:Fri Oct 22, 2010 10:44 pm
Re: 99,000 lines in the stock table

Post by cpb14 » Sun Apr 24, 2011 1:11 pm

Dale

I tried what you did and it worked

i deleted path then entered it and now it works so that should be good.

How is Aprint 6 coming any news from Jon? Once thats ready i think 7.05 is GO

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Sun Apr 24, 2011 1:56 pm

CB,

That's good news. I have just finished upgrading the 3 user's guides (.PDF, .TXT, and HTML) for the 26,000 feature and the website pages that mention the line limit in the stock table. I will not upload them until I release the program but they are already to go.

How was the speed on your network test, particularly the speed on reports?

APRINT6 has been a major topic / project on chat for the last several days, you should drop in. You can even help out.

You can check our progress on the chat log at http://www.cs.nmsu.edu/~msimmons/dhpos-2011-04

Dale

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Sun Apr 24, 2011 3:25 pm

I loaded the new 26000g version of the program in my old "live" POS folder and when I tried to access my old files it worked fine.

Did anyone else try that?

Dale

cpb14
Forum Regular
Posts:56
Joined:Fri Oct 22, 2010 10:44 pm

Re: 99,000 lines in the stock table

Post by cpb14 » Sun Apr 24, 2011 5:20 pm

i did and it worked fine

User avatar
brucef2112
Forum Regular
Posts:336
Joined:Mon Mar 06, 2006 11:19 pm
Location:Broward County, Floriduhh
Contact:

Re: 99,000 lines in the stock table

Post by brucef2112 » Sun Apr 24, 2011 5:54 pm

Dale, I was testing 26Kg POS today. Entering various transactions and what not. When I went to close the register it crashed with a out of stack space error. I got to the screen where you push #2 to confirm closing and it immediately dumped to this screen.

Code: Select all

│         CASH SALE:     2419278    15 │     TOTAL PAYOUTS:           0     0 │
│        CHECK SALE:      248753     8 │   TOTAL DISCOUNTS:           0     0 │
│       CREDIT SALE:      248055     9 │  TOTAL REDUCTIONS:      -65644    22 │
│        DEBIT SALE:      424403    14 │     TOTAL COUPONS:         -15    15 │
│    GIFT CARD SALE:      262914     9 │       TOTAL VOIDS:      -30585     1 │
│              SALE:           0     0 │  TOTAL GIFT CARDS:     1999800     2 │
│       CASH RETURN:           0     0 ├──────────────────────────────────────┤
│      CHECK RETURN:           0     0 │           SALES TRANSACTION:      55 │
│     CREDIT RETURN:           0     0 │          RETURN TRANSACTION:       0 │
│      DEBIT RETURN ╔════════════════════════════════════╗ ANSACTION:       1 │
│  GIFT CARD RETURN ║                                    ║ ██SACTION:       1 │
│            RETURN ║   !!!! CLOSING OUT REGISTER !!!!   ║ ██SACTION:       2 │
│         NET SALES ║                                    ║ ██N TOTAL:      59 │
Out of stack space in line 7 of module POS3     at address 23BF:4C64──────────┤
│       GROSS SALES: ████████████████████████████████████████                 │
Hit any key to return to system0       │                                      │
│         CASH BACK:           0       │                                      │
│      SUB REG CASH:     2441975       │                                      │
│  CASH DROPS/PULLS:         100     1 │ 1. Do nothing - Return to register.  │
│       + CASH FUND:         100       │ 2. Close register/Print/Erase/Exit.  │
│       CASH IN REG:     2442175       │ 3. Exit program. No print. No erase. │
│     CHECKS IN REG:      263612       │ 4. Display tax details.              │
│     CREDIT IN REG:      263156       │                                      │
│      DEBIT IN REG:      439290       │                                      │
│            IN REG:           0       │                                      │

Out of stack space in line 7 of module POS3 at address 23BF:4C64
Hit any key to return to system

I did have auto reports configured but it never got there. Infact when I restarted and looked back via the Void screen for the closing transaction. It didn't get any further than having the top header info about the close transaction. The rest of it was blank.

Code: Select all

CLOSE         TRANSACTION # 855           04-09-2011    20:26













I went back to close again and all the numbers were still there. I did the close and it seemed to close 'normal'.
I can't tell you much more than this. If I see something I'll follow up later...

later,
Later,
Bruce

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
Benjamin Franklin - Historical Review of Pennsylvania, 1759

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Sun Apr 24, 2011 8:12 pm

Bruce,

How many times could you make this happen?

Dale

User avatar
brucef2112
Forum Regular
Posts:336
Joined:Mon Mar 06, 2006 11:19 pm
Location:Broward County, Floriduhh
Contact:

Re: 99,000 lines in the stock table

Post by brucef2112 » Mon Apr 25, 2011 1:42 am

I open and closed it a couple of times after the crash without incident. Had to do the family dinner thing so I couldn't test more. I'll hit it again in the morning and see if I can reproduce the problem.
thanks dale,
Later,
Bruce

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
Benjamin Franklin - Historical Review of Pennsylvania, 1759

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Mon Apr 25, 2011 5:47 pm

Bruce,

In version 7.04i26 I have added a feature that when ever you choose option "7. Close register" the program will clear the stack and then go to the "Close" screen. This should prevent any occurance of the problem from happening again. However this will cause about a 1 second delay from the time you choose the close screen until it actually appears.

In this download on the POS.EXE and POSCONFG.EXE program files have been renumbered to 7.04i26 the others have not changed and are still G.

Here is the link (New file, below)
This should be release version so test the heck out of it. I am looking for this Wednesday to release this thing.

Dale

User avatar
brucef2112
Forum Regular
Posts:336
Joined:Mon Mar 06, 2006 11:19 pm
Location:Broward County, Floriduhh
Contact:

Re: Gift Card Issues.

Post by brucef2112 » Mon Apr 25, 2011 11:34 pm

Hey Dale, I beat up on the POS but could not duplicate the Close Register crash. So it could have been anything not related directly to the POS. But I guess POS users around the world can live with loss of 1 second of their day in the name of data safety! I'm going to keep hitting it (the g version) a few more time to see if it will 'talk'.

Any ways found some stuff related to Gift Cards. Some things may be by design others may have turned up a bug. I'll just make some observations.
1. When a Gift Card is sold its ID is printed on the receipt in the description area. Similar to any item sold.
When using the 5. Void to view the transaction on screen the Card ID does not show in the description. Why? If I sold 3 cards how do I know which one it is?

2. For transactions paid by Gift Cards (or Checks) it looks like one of the lines is missing a CRLF at the end of the Change Due line, when viewing the saved journal or printed receipts. The result is the same if set up for 40 or 80 wide.
Sample 40 wide: 'Check #: xx' is on the Change Due line. As is the 'REMAINING                    VALUE' for pay by Gift Card.

Code: Select all


      
---------------------------------------
TRAN     ASSOCIATE                 TIME
1020                              10:09
13-2-----------------------------------
  STOCK NUMBER DESCRIPTION        PRICE
         14664 THIS IS ITEM #14664     
 T6    2    at     3666ea.         7332
          5284 THIS IS ITEM #5284      
 T5    1    at     5284ea.         5284
---------------------------------------
       3    
              SUB TOTAL           12616
     TAX5  at  1.625%              86
     TAX6  at 10.000%             733
              TOTAL TAX             819
                  TOTAL           13435
---------------------------------------
         CHECK TENDERED           13435
             CHANGE DUE               0 Check #: 33 
    ID #: 1234SDF
   Phone: 1231234444    

               04-10-2011



      
---------------------------------------
TRAN     ASSOCIATE                 TIME
1021                              10:09
13-3-----------------------------------
  STOCK NUMBER DESCRIPTION        PRICE
         14664 THIS IS ITEM #14664     
 T6    2    at     3666ea.         7332
          5284 THIS IS ITEM #5284      
 T5    1    at     5284ea.         5284
---------------------------------------
       3    
              SUB TOTAL           12616
     TAX5  at  1.625%              86
     TAX6  at 10.000%             733
              TOTAL TAX             819
                  TOTAL           13435
---------------------------------------
     GIFT CARD TENDERED           13435
             CHANGE DUE               0REMAINING                      VALUE
  1234XXXXXXXXXXXXXXXX      9859565
               04-10-2011

Here's it in 80 wide: Gift card sample shown. But results are also the same for pay by Check.

Code: Select all

      
-------------------------------------------------------------------------------
                    TRAN     ASSOCIATE                 TIME
                    1015                              10:02
12-3---------------------------------------------------------------------------
  STOCK NUMBER DESCRIPTION          TAX RATE   PIECES  UNIT PRICE         PRICE
         14664 THIS IS ITEM #14664      TAX6   2    at     3666ea.         7332
          5284 THIS IS ITEM #5284       TAX5   1    at     5284ea.         5284
-------------------------------------------------------------------------------
                                               3    
                                                      SUB TOTAL           12616
                                             TAX5  at  1.625%              86
                                             TAX6  at 10.000%             733
                                                      TOTAL TAX             819
                                                          TOTAL           13435
-------------------------------------------------------------------------------
                                             GIFT CARD TENDERED           13435
                                                     CHANGE DUE               0REMAINING                      VALUE
  1234XXXXXXXXXXXXXXXX      9873000
                                   04-10-2011

3. Similar to the above is with the User Defined pay. The date is wrapped back up to the end of the CHANGE line.

Code: Select all

     
---------------------------------------
TRAN     ASSOCIATE                 TIME
1034                              12:00
15-2-----------------------------------
  STOCK NUMBER DESCRIPTION        PRICE
         14664 THIS IS ITEM #14664     
 T6    2    at     3666ea.         7332
          5284 THIS IS ITEM #5284      
 T5    1    at     5284ea.         5284
---------------------------------------
       3    
              SUB TOTAL           12616
     TAX5  at  1.625%              86
     TAX6  at 10.000%             733
              TOTAL TAX             819
                  TOTAL           13435
---------------------------------------
  USER DEFINED TENDERED           13435
             CHANGE DUE               0               04-10-2011


Also related to the User Defined Payment. As you can see below, In the 5. Void screen the user defined payment description visible as the payment method.
(as defined in the payment options of posconfg)

Code: Select all

│
│  Sub Total:         12616
│        Tax:           819
│      Total:         13435
│ MyPowerCrd:         13435       <<====== On Void Screen it shows 'MyPowerCrd'
│  Total Pay:         13435

However on the printed receipts and in the journal it shows as USER DEFINED TENDERED. And not the 'MyPowerCrd' as setup in the posconfg.

4. I also notice that on the printed receipts you are masking the Gift Card ID from the right. Wouldn't it be better if it was masked from the left like the CC industry does by only showing the last 4 number, instead of the first four? Short of getting custom data cards with a specific ID number format, when generic data cards are purchased, aren't they typically just serial numbered. is 1234500001,1234500002, 1234500003, etc? If so then the masking from the right will show 1234XXXXXXXXXXXXXXXX on all sales receipts with a GC as payment. I won't be able to see a different ID on a receipt unless it is my 1 millionth GC owner.

5. Just a tip of my hat to you, Dale. I tried using "My Gift Card" to pay for added funds to "My Gift Cards", but the POS handles it gracefully. But maybe it should have barked and not let me do this.( ie use gift card #ABC as payment for adding value to gift card #ABC.) Just a thought, while we're here, I'd think it would be OK to use Gift Card(#AA) to pay for another Gift Card(#BB). This is OK Right?.

6. For Gift Cards IDs, I would suggest you enforce alpha numeric values and NO spaces allowed in the string. It allowed me to create a GC ID of "A B". Its a bad thing. Users could accidentally hit a space when selling a card as (GC# "123 abc"). Later, when used as payment the 'card' if typed in as "123abc" would show a balance of zero if not sold yet, OR worse if it was sold to someone else
and the "123 abc" owner was entered as "123abc" on a sales transaction they would be consistently using up the GC balance of the person that was sold the "123abc" card. Nobody would catch this rogue GC unless it showed up on a report......hmmmm.
26000.GFT

Code: Select all

 6.40 7                            12345678            íq– 1          12345QW             Ž  2          123456              ô3  3          ABC123               4          123 123             °  5          ÿ    ÿ              œc  6          ABC123XYZ           L  7          
USELESS TRIVIA TIME!!! Super bonus point for the Gift Card ID of card #6 and how it was created within the POS! 8) Not just for Dale. Everyone can play!!

7. From a management point of view. Shouldn't there be a Gift Card Report that shows all the Cards sold. The GC report should have an option like the stock reports. 1. Show All Cards        2. Single Card. Password enforced like other sensitive areas of the POS.
Just tossing this up; maybe an All GC report that shows the original date sold original value, # of transactions used on it, current balance, and date last used. If I have cards 1-100 how do I know if cards are missing in the series? Its like a Gift Card 'BlackBox'.
Last edited by brucef2112 on Tue Apr 26, 2011 5:26 pm, edited 1 time in total.
Later,
Bruce

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
Benjamin Franklin - Historical Review of Pennsylvania, 1759

User avatar
brucef2112
Forum Regular
Posts:336
Joined:Mon Mar 06, 2006 11:19 pm
Location:Broward County, Floriduhh
Contact:

Re: minor issue in Payment Method Configuration screen

Post by brucef2112 » Tue Apr 26, 2011 12:24 am

Dale when on the Payment Method screen if the User Defined name field has focus the [F1] key to Format Gift Cards doesn't work.
As it is you have to scroll up/down to move the cursor focus to one of the payment types for the [F1] key to work.

later,
Later,
Bruce

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety."
Benjamin Franklin - Historical Review of Pennsylvania, 1759

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Tue Apr 26, 2011 6:04 pm

Today's trials and tribulations,

I did fix the line feed after the CHANGE DUE line on printed receipts.

I changed the program to hide the last 4 characters of the gift card number instead of the first 4.

I fixed the program so (in the Pyment methods" feature of the POSCONFG.EXE PROGRAM) when the highlight bar is on the name of the "user defined" payment method you can now press [F1] to setup the gift cards.

You can use one gift card to add money to a different gift card. You can also use a gift card to add money to the same gift card. This is extremely pointless but it does no harm so I am leaving it as it is just because I can.

Since the gift card number can be someone's name, shoe size, DNA sequence, IQ, a bunch of random characters, or a really short poem, it may require spaces. So I am not changing this. Sometimes you have to trust in the intelligence of the people using the program. This, in turn, usually leads to random results than can be highly entertaining. I have to get my fun from somewhere.

Remember that the gift cards are actual money and their only slight security is that only the customer is supposed to know what the card ID is. If there were a feature to list all the IDs and the value still on each card I am sure that someone with dishonest intentions would sure want that information.

For today's magic trick I created a stock table with 26,000 14 digit stock numbers just to see if I could somehow make the program crash while using it. The results were 1 crash and 1 case of not printing the stock numbers correctly on a history report. Both of these problems have been fixed.

But at some point we have to say that we have done enough and just shove this thing out the door. This point will arrive tomorrow. So see what you can find before then.

Dale

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Tue Apr 26, 2011 7:22 pm

Version 7.05 has been released and can be downloaded from the usual place http://keyhut.com/pos3.htm

Dale

User avatar
AussieAussie
Forum Regular
Posts:34
Joined:Mon Apr 20, 2009 10:39 pm
Location:Victoria, Australia
Contact:

Re: 99,000 lines in the stock table

Post by AussieAussie » Sat Apr 30, 2011 5:23 am

brucef2112 wrote:Dale, I was testing 26Kg POS today. Entering various transactions and what not. When I went to close the register it crashed with a out of stack space error. I got to the screen where you push #2 to confirm closing and it immediately dumped to this screen.

Code: Select all

│         CASH SALE:     2419278    15 │     TOTAL PAYOUTS:           0     0 │
│        CHECK SALE:      248753     8 │   TOTAL DISCOUNTS:           0     0 │
│       CREDIT SALE:      248055     9 │  TOTAL REDUCTIONS:      -65644    22 │
│        DEBIT SALE:      424403    14 │     TOTAL COUPONS:         -15    15 │
│    GIFT CARD SALE:      262914     9 │       TOTAL VOIDS:      -30585     1 │
│              SALE:           0     0 │  TOTAL GIFT CARDS:     1999800     2 │
│       CASH RETURN:           0     0 ├──────────────────────────────────────┤
│      CHECK RETURN:           0     0 │           SALES TRANSACTION:      55 │
│     CREDIT RETURN:           0     0 │          RETURN TRANSACTION:       0 │
│      DEBIT RETURN ╔════════════════════════════════════╗ ANSACTION:       1 │
│  GIFT CARD RETURN ║                                    ║ ██SACTION:       1 │
│            RETURN ║   !!!! CLOSING OUT REGISTER !!!!   ║ ██SACTION:       2 │
│         NET SALES ║                                    ║ ██N TOTAL:      59 │
Out of stack space in line 7 of module POS3     at address 23BF:4C64──────────┤
│       GROSS SALES: ████████████████████████████████████████                 │
Hit any key to return to system0       │                                      │
│         CASH BACK:           0       │                                      │
│      SUB REG CASH:     2441975       │                                      │
│  CASH DROPS/PULLS:         100     1 │ 1. Do nothing - Return to register.  │
│       + CASH FUND:         100       │ 2. Close register/Print/Erase/Exit.  │
│       CASH IN REG:     2442175       │ 3. Exit program. No print. No erase. │
│     CHECKS IN REG:      263612       │ 4. Display tax details.              │
│     CREDIT IN REG:      263156       │                                      │
│      DEBIT IN REG:      439290       │                                      │
│            IN REG:           0       │                                      │

Out of stack space in line 7 of module POS3 at address 23BF:4C64
Hit any key to return to system

I did have auto reports configured but it never got there. Infact when I restarted and looked back via the Void screen for the closing transaction. It didn't get any further than having the top header info about the close transaction. The rest of it was blank.

Code: Select all

CLOSE         TRANSACTION # 855           04-09-2011    20:26













I went back to close again and all the numbers were still there. I did the close and it seemed to close 'normal'.
I can't tell you much more than this. If I see something I'll follow up later...

later,
Dale, I get the above every time if the printer is not connected or turned on. Used to get an error screen if that happened before.
"...In Switzerland they had brotherly love - they had 500 years of democracy and peace, and what did that produce? The cuckoo clock."

User avatar
daleadmin
Forum Owner
Posts:1279
Joined:Tue Dec 30, 2003 9:47 pm

Re: 99,000 lines in the stock table

Post by daleadmin » Sat Apr 30, 2011 7:25 pm

AussieAussie,

Are you using Version 7.05 or one of the test versions?

Dale

User avatar
AussieAussie
Forum Regular
Posts:34
Joined:Mon Apr 20, 2009 10:39 pm
Location:Victoria, Australia
Contact:

Re: 99,000 lines in the stock table

Post by AussieAussie » Sun May 15, 2011 9:58 pm

Sorry for the delay in replying. Yes using 7.05 on both a XPSP3 and a W98 system. same on both.
"...In Switzerland they had brotherly love - they had 500 years of democracy and peace, and what did that produce? The cuckoo clock."

Post Reply

Who is online

Users browsing this forum: No registered users and 31 guests