Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103

    Unanswered: How to access Cash register data to BD?

    Is it possible to access the data from cash register to BD?
    Last edited by mcmichael; 08-24-14 at 22:24.

  2. #2
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    one option would be do the communication throw files... but i should be complicated and unacurated

    another option could be do the communication throw dlls, create some dlls in c# that do the trick, but no one ever in this forum has used successfully the dlls.

    another options could be create a msql database and then brilliant can consult that database, and your cash machine can do it to... but... in that scenario maybe brilliant would be worthless.

    anyone?

    fer

  3. #3
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    What are you trying to do exactly?

    I've all manner of software running in factories that communicates with all kinds of devices.

    Regards
    James

  4. #4
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    Hi James,

    I want to create an inventory software which links the Cash register and BD?

    Thanks

    Ernie

  5. #5
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Two options come to mind.

    The easiest way would be to build your own cash register app in brilliant database that not only manages the inventory, but also process the sale with the customer. You can get USB Kickers that can open a cash drawer when the sale is complete. Basically, a USB Kicker comes with a simple program that places a virtual button “Open Drawer” on the screen. This button remains TopMost, so both brilliant database and the button can occupy the screen without interfering with each other.

    For your own custom onscreen keyboard you can't beat "Touch it".
    http://www.chessware.ch
    I use this on all my touch screen's in food factories. You can create specific buttons that do anything you need.

    Or...

    If you want to leave the cash register as is and just interface with it, a program like WinWedge will allow you to convert any activity over a RS232 (or any port) between the cash register and the PC running brilliant database.

    Serial and IP Data Collection Software for Any Program | TALtech

    In short, WinWedge will give you the ability to turn singles from the cash register into actual data you can process in brilliant database. This is actually very easy to do, but the problem is what do you do with the data you are receiving and how do you turn that into something that updates your inventory.

    Regards
    James

  6. #6
    Join Date
    Oct 2013
    Location
    Philippines
    Posts
    103
    Wow nice !!! Thanks for sharing your knowledge James.

    Thanks

    Ernie

  7. #7
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    Dear James:

    Again, full of sorprices!!!

    Can you link brilliantdatabase and winwege?... how do you do it, using a read file option or by dde?

    have you used? is it reliable?

    sound grate, this could open brilliant to a large amount of applications...

    have you connected brilliant to arduino?

    fer

  8. #8
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    i saw the page, ant it is kind of exprensive 229 usdlls

  9. #9
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Can you link brilliantdatabase and winwege?
    Link, as in brilliant database will still receive the signal from winwedge even if both are minimised and only brilliant database,?

    Yes, but I'm sorry to say that this is one function of brilliant database I cannot figure out. The manual is very poor on this subject and I've never been able to get it working. If anyone ever figures it out, I'd really love to see a working example so I can understand it myself.

    Do a search on the manual for SendMessage or WinAPI. This is a function that allows you to get brilliant database to target and listen to a specific application.

    how do you do it, using a read file option or by dde?
    I'm using dde and kind of have to worry a little about the fact that I can't get SendMessage / WinAPI to work. Brilliant Database must be the main focused app for it to work right. That being said, if we could figure out how to get the SendMessage/WinAPI working, it would solve all issues anyone could have with interfacing brilliant database with all manner of devices.

    have you used? is it reliable?
    Yes, so far 100% reliable. Only the odd message is missed due to brilliant database not being the main focused app and me not knowing how to get SendMessage/WinAPI working.

    have you connected brilliant to arduino?
    Nope, haven't had the pleasure of trying that yet.

    i saw the page, ant it is kind of exprensive 229 usdlls
    There are free alternatives that *might* do. For example 232key RS-232 Software | Freeware

    Regards
    James

  10. #10
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    PS... if anyone needs to create a physical button controllers to operate their databases, just let me know. I have developed my own software that was designed specifically to work with brilliant database and it's odd funky timing. It has a strange buffer that is delayed in order to ignores normal signals.

    For example, if you wanted to have a buttons on a control panel that sends different “CTRL + Any letter” you like in order to run entire scripts or any function necessary in brilliant database, brilliant database requires that the messages are received in a very certain way.

    For example, a CTRL+ M function would have to be received like this....

    CTRL – Key Pressed Down + 30ms delay
    M – Key Pressed down + 30ms delay
    CTRL – Key Released + 30ms delay
    M – Key Released + 30ms delay

    That's what my software does. It allows you to add as many buttons as you like to a control panel, and the software can then convert their incoming signal into brilliant database compatible function keystrokes (CRTL + any combination)

    Regards
    James.

  11. #11
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    james:

    let me see if i understood your software...

    you can place a button "out" of brilliant, let say in the desktop, but i can trigger brilliant scripts?? did i got it right?

    fer

  12. #12
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    Yes and no, I'm not referring to virtual buttons on a screen for my software. I'm taking about real buttons, foot pedals, light sensors, sliders, knobs, camera's, pressure sensors and so on.

    Any controller that works on Midi, my software can convert it into commands for brilliant database.

    I can even give you a link to a $50 dollar circuit board you can buy that my software will work with that will allow you to control brilliant database from any midi device imaginable.

    Regards
    James

  13. #13
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    sorry out of the topic...

    James:

    what is your background, and what is your professional job, i am curious, since it seams that probably you have more knowledge in brilliant that mikhail (littel joke)

    i am fer, from mexico, my background is in business management, i work for business that rice broilers and i am kind of the manager it guy.

    i am writing a brillinat database application to be used in the human resources area

    -- have you have any recent communication with mikhail ??

    -- we should do something to get in touch with him... any wild idea?

    best regards

    fer
    Last edited by ferslash; 08-27-14 at 00:28.

  14. #14
    Join Date
    Jul 2012
    Location
    Ireland
    Posts
    815
    Provided Answers: 17
    I'm self employed in IT and Multimedia. Here's links to my two websites.

    Irish Acts Studio » Irish Acts Multimedia Studio - We specialise in digital products and support for KORG users the world over, multimedia and custom software design.

    My Virtual World | Specialising in 360 Degree Virtual Tours and advanced multimedia experiences.

    have you have any recent communication with mikhail
    No, I've not attempted to contact him in a long time to be honest.

    we should do something to get in touch with him... any wild idea?
    Anything that helps Mikhail continue to develop brilliant database is a positive thing, but I'd like to know if Mikhail wants help and if he's motivated to push things forward at all.

    More customers = more income for him, but it's hard to see new customers going his way when there's no support and no sign of continued development.

    Regards
    James

  15. #15
    Join Date
    Jun 2012
    Posts
    163
    Provided Answers: 1
    james:

    woow, nice sites!

    impressive how you used brilliant to do the korg softwares

    do you develop in anything else out of brilliant?

    best regards

    fer

Posting Permissions

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