Help with Micros E7

[tspree]

I have 3rd party software which changes item prices in Micros 3700 in real time. We're using a SIM interface to get the prices to update in real time.

We need to do the same thing with the Micros E7 but we are not as familiar with how the E7 functions.

I don't believe we can use the SIM interface.

Do you know how we can change prices in real time in the E7? Can the 3rd party software simply update the price table in the E7 database directly? Or will that not change prices in real time?

Any help is appreciated.

Thank you

 

[DrZogg]

You have to write a DLL. E7 is close to real time in updating anyway

 

[tspree]

Hi drZogg,

I'm having trouble figuring this out. Which dll is it and how do I make sense of it?

Thank you so much for the help.

 

[DrZogg]

Hi,
E7 interfaces reside in:

C:\Program Files\MICROS\e7\Bin\

There are always 2 files : a DLL and a config file. We will use the SVC interface as an example. All the interfaces start with the string TIF

TIFSVC.dll
TIFSVC.cfg

The DLL you need to write to access your program.
The CFG created the input fields in the E7 tabs to capture the settings you need for your DLL.

I considered writing one for Respak but E7 runs in such a way that each till is a separate 'location', which logically is far removed from the Respak view of the business. I shifted them up to RES4 for the Respak features.

Cheers

 

[tspree]

Hi,

Thank you again for all of this information. It is quite helpful.
Reading the file is proving to be difficult. I can't locate the following data.

1) Item name or Item #
2) Item Price
3) Quantity Sold for that item

Do you have any idea where these are located within the file?

I appreciate all of your help and I'm happy to compensate you.

Thanks,

Todd

 

[DrZogg]

The databases are different and I doubt your software will work. 3700 is sybase, E7 is SQLite. SQLite is an embedded C DB platform.
The SQLite DLLs are in MICROS\e7\Bin and tools etc are available from

http://www.sqlite.org/

.

In 32 bit C:\Program Files\MICROS\e7\db
In WinCE CF\MICROS\e7\db

The DB tables are BIN files, the index is the same name with KEY extension. eg MenuItemDefs.bin, MenuItemDefs.key

There is a company out there that actually wrote a KDS interface for E7. They would have a very good understanding of the inner workings of E7. I cant find them on google, maybe someone else has heard of them.

 

[tspree]

Ah I see, thanks for the info. I'll give it a shot and see if I can make any progress.

 

[tspree]

After some preliminary investigation I found that these files are encrypted.. makes sense, of course. With SQLite, I'm assuming there's an inherent decrypt function but a DB password is needed..?

Do you have any idea how I can get around this?

Thank you

 

[DrZogg]

i dont think they are encrypted. I think its about loading the file as an xml struct and converting the data into datatype values. Open the items table. You can read all the items names and the other parts are illegible between each name.
Havent gone down this path.

 

[tspree]

Hi DrZogg. I have another question for you, I hope you don't mind.

We can't figure out how to open the bin files. I'm using an SQL Lite database reader, but it's claiming that the bin files are not proper SQL Lite databases.

Is there a different program that I should use?

Thanks,

Todd

 

[tspree]

We spent all night trying to read the bin files in a hex editor. We can't make any sense of them. Is there a different approach we should be trying?

Thanks

 

[DrZogg]

Dont know. Its definitely SQLite, the DLL is in the bin. My guess would be that the DLL is rewritten & customised by Micros for their own functionality. A fair guess given that in 3700 the CRPE32.dll (crystal reports DLL) is also rewritten by them to include their own error capturing etc.
Check out its calls in a dependancy checker or something.