99,000 lines in the stock table
Moderators:daleadmin, Dale Harris, Alan, Andrew
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
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
Re: 99,000 lines in the stock table
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
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
Re: 99,000 lines in the stock table
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
Did anyone else try that?
Dale
Re: 99,000 lines in the stock table
i did and it worked fine
- 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
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.
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.
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,
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
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
Re: 99,000 lines in the stock table
Bruce,
How many times could you make this happen?
Dale
How many times could you make this happen?
Dale
- 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
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,
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
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
Re: 99,000 lines in the stock table
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
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
- brucef2112
- Forum Regular
- Posts:336
- Joined:Mon Mar 06, 2006 11:19 pm
- Location:Broward County, Floriduhh
- Contact:
Re: Gift Card Issues.
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.
Here's it in 80 wide: Gift card sample shown. But results are also the same for pay by Check.
3. Similar to the above is with the User Defined pay. The date is wrapped back up to the end of the CHANGE line.
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)
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 USELESS TRIVIA TIME!!! Super bonus point for the Gift Card ID of card #6 and how it was created within the POS! 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'.
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
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
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
(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
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
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
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
- 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
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,
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
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
Re: 99,000 lines in the stock table
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
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
Re: 99,000 lines in the stock table
Version 7.05 has been released and can be downloaded from the usual place http://keyhut.com/pos3.htm
Dale
Dale
- 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
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.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,
"...In Switzerland they had brotherly love - they had 500 years of democracy and peace, and what did that produce? The cuckoo clock."
Re: 99,000 lines in the stock table
AussieAussie,
Are you using Version 7.05 or one of the test versions?
Dale
Are you using Version 7.05 or one of the test versions?
Dale
- 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
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."
Who is online
Users browsing this forum: No registered users and 167 guests