Micros 3700 info / file request.

[LethargicCoder]

Hi all,

I have a client that will be using a Micros 3700 system with server, 3 terminals, printers.

We are writing a java application that we would like to interface with the POS.

I am hoping that someone could help me out with documentation, sample java code or anything else that could assist with using Micros' Web services and/or direct DB connection to the POS DB.

We are wanting to perform full check processing (open, modify, payment, closing, querying) and also export/management of menus and configuration/mappings.

If you could provide links to where I could find this information I would greatly appreciate it.

 

[pmegan]

The 3700 uses an ODBC connection called 'micros' so that may be the way to go. There are schema and domain data type reports in the \micros\res\pos\reports folder.

If you're looking to run transactions from another application you'll have to learn Micros SIM scripting. There are a couple of help files but no real documentation so it's a hit-or-miss learning process. Most of the front of house operations are compiled into the applications so datbase access alone won't really be enough to get you going.

It's not much but i hope it helps.

 

[LethargicCoder]

Thanks pmegan.

Part of my problem is that I am remote to my client and we don't have the micros equipment setup yet and I don't have any of the software that was provided. So I don't have access to any documentation that would be loaded on the machines during install.

For 3rd party application interface, there is a COM API and a web service. We intend to use the webservice that we some API information on but is unclear in places. Also there is sample C++ and VB code, and WSDL files for java stubs. The developer working with this is unable to generate the stubs (this is where the code for the stubs or sample code would help) as well as additional documentation.

 

[Shift4SMS]

I don't know what type of interface you are attempting to write, but you are going to be handcuffed if it does not fall within some predefined functionality of Micros. SIM allow for some basic interface functionality but the 3700 SIM is not up snuff compared to it's predecessors (8700 & 9700) -- maybe 60-80% of it's prior functionality so this may hinder your ability.

While the 3700 uses an ODBC database, we found that Micros caches much of the data in the server so unless you shutdown the Micros server, the data in the ODBC database won't be accurate. If you have a non-24 hour merchant and your process can run during some end-of-day cycle, then you may be able to jury-rig something; otherwise, this may be a dead end route to you.

Maybe if you describe a 1000 foot view of what you need, we might be able to offer better advice...

Steve Sommers
Shift4 Corporation --

http://www.shift4.com

Creators of $$$ ON THE NET(tm) payment processing services

 

[LethargicCoder]

The interface is a wrapper for the COM API / webservice that Micros updated in September.

We are developing an application that will identify a customer and their order. We intend to enter this order into the POS from our application along with information to identify the customer. Staff will then fill the order from the check in the POS and close. Our system would then followup by querying checks that it had opened. When a closed one is found, it would update the users information using what is on the closed check (whether it was modified or not within the POS). We are also wanting to do credit card transactions throught the POS.

DB access will most likely be done during closed hours over night. It is mainly to keep an updated menu on the web and not for transactions of any kind. Micros has stated that this should be a straight ODBC (I assume a JDBC is ok) to the DB.

I am unfamiliar with SIM and this may be a more appropriate way of providing this functionality. Any information on this scripting language, how it works, or how I might call it from java would be interesting as well.

Thanks for your responses

 

[Shift4SMS]

You may want to contact Micros directly with this question as I've heard that they have developed, or are developing some sort of API for third party vendors that "supposedly" does what you are asking -- third party order entry/tracking. I know Micros would frown on you doing anything directly into their database via ODBC or any driver.

Good luck!

Steve Sommers
Shift4 Corporation --

http://www.shift4.com

Creators of $$$ ON THE NET(tm) payment processing services