Importing sales from other POS systems nightly.

[K_Mos]

Hey all, I want to create a nightly autosequence which can run an SQL query on another POS database we have, and pull that query into a tracking group in Micros 3700. Has anyone done something like this before? My biggest hurdle is the fact the other POS system uses a MS SQL Server database. I have created an ODBC connection to the other database already and can manually run sql queries no problem. Just need help pulling that data into the Micros DB tables and making a script for the autosequencer to perform.

Another option I thought about was using Transaction services to tender a sale for a total based on an SQL query. However I dont have any documentation on the Transaction Services API. We already have the licensing and use it for our Order to Table stuff though so its available as an option.

Basically I just want to be able to pull sales from another POS system we use into our Micros reports automatically. Needs to happen nightly.
If you have any other thoughts/better ways to go about this let me know!

 

[CathalMF]

Your biggest problem will be converting a check from one pos system to another.
You will need a big mapping table to know that 1005 Burger in Pos System 1 is 2034 Burger in Pos System 2.

This gets very complex with anything other than simple menu items if you start dealing with condiments and combo meals.

Why do you want to do this anyway?

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/