Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    EPOS Customer Display (Excel XP)

    Hey there folks,
    I am building an EPOS and it is going to need a customer display, i will obtain one from eBay most likely, my problem is that once i have the item, how will i get it to show the actual totals that i have, the EPOS system i have programmed is made through Excel, so is there any code within excel or some way of using shell extensions i could use?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: EPOS Customer Display (Excel XP)

    I am a little confused on what you need. What is an "EPOS" and what do you want Excel to do with it?

    Steve

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EPOS Customer Display (Excel XP)

    I suspect it is an Electronic Point of Sale, which sounds like it is going to need Excel controlling some hardware...

  4. #4
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EPOS Customer Display (Excel XP)

    I assumed people would know, my apologies, yes what i need is this:
    Assuming Subtotal, tender and change are in cells A1-A3 respectively, i need it to firstly send the signal to (probably the) serial port so that it can be read by the LCD display, the subtotal would read on the top line, then, send the signal for the tender and change to the top and bottom lines of the LCD display, when i press a button, this may require me to know the address of the serial port pins, but i am unsure, any help appreciated, an example of parralel port control is shown below.

    Program lpt1_output;

    Uses Dos;

    Var
    addr:word;
    data:byte;
    e:integer;

    Begin
    addr:=MemW[$0040:$0008];
    Val(ParamStr(1),data,e);
    Port[addr]:=data;
    End.

    (http://www.epanorama.net/circuits/pa...tml#circuithow)

    I also want to operate a simple 12v circuit that will open the cash drawer when i click the tender button, suggestions? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EPOS Customer Display (Excel XP)

    I use Excel for downloading data (from some equipment we manufacture) using serial comms. I searched high and low for some method, and eventually settled for WSC from MarshallSoft.
    For hardware switching, you could either using a plug-in card for the PC, or use the serial port to drive a piece of kit. Let me know if you want some pointers to the hardware side and I'll see what I can dig out.

  6. #6
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EPOS Customer Display (Excel XP)

    Hmm would be appreciated, the only thing i've got on that right now is a parallel port plugin device which can apparently operate a circuit, but i am unsure about the details as the instructions were in German and very vague from what i read...

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EPOS Customer Display (Excel XP)

    There seems to be plenty of choice out there for serial-port-controlled switches - for example this from Audon.
    If you want to search yourself, a Google for <code>
    switch relay output serial pc</code>
    brings up a fair number of hits.

    It may all come down to your budget. If you are going to try direct drive from a parallel or serial port pin, I'd be very careful about keeping what you are switching isolated from the pc.

  8. #8
    Star Lounger
    Join Date
    Sep 2004
    Location
    Wolverhampton, Staffordshire, England
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EPOS Customer Display (Excel XP)

    Thanks i will have a look-see

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •