microsnewbie1
MIS
I am a system admin who is trying to unload the menu Inventory Items from a Micros Restaurant enterprise solution system 4.0 into a csv or db file for upload into another system.
I have no Micros experience but upon viewing the micros.db file in notepad the header information shows Sybase Inc Copyright 2000 9.0.2.3586 so I tried to unload the micros.db into an Sqlanywhere db. I have the UID and PWD but not the encryption key, so the unload of the db is failing with incorrect or missing encryption key.
In a closed message thread "Micros POS - Connect to db" pmegan responded that the job def could be unloaded with :
CODE
unload
select * from MICROS.job_def
to 'D:\\micros\\Export\\job_def.csv'
quotes off -- I always use quotes off, but it's optional
I have access to the console of the Micros 4.0 pc as administrator, but I have no knowledge of how to unload the menu items or in which files they are located.
Is there a *micros res 4.0 unload the Menu items for dummies" anywhere ? Perhaps it is one command in one terminal screen ?
Any help would be greatly appreciated. I have been working on this for the past week with no success.
P.S. There is a Menu Item directory with Item_Summary_Sys.rpt and even an artikeleport.rpt HOWEVER they are dated 2008 ....nine years ago....perhaps those are the answer if they could somehow be updated ...
I have no Micros experience but upon viewing the micros.db file in notepad the header information shows Sybase Inc Copyright 2000 9.0.2.3586 so I tried to unload the micros.db into an Sqlanywhere db. I have the UID and PWD but not the encryption key, so the unload of the db is failing with incorrect or missing encryption key.
In a closed message thread "Micros POS - Connect to db" pmegan responded that the job def could be unloaded with :
CODE
unload
select * from MICROS.job_def
to 'D:\\micros\\Export\\job_def.csv'
quotes off -- I always use quotes off, but it's optional
I have access to the console of the Micros 4.0 pc as administrator, but I have no knowledge of how to unload the menu items or in which files they are located.
Is there a *micros res 4.0 unload the Menu items for dummies" anywhere ? Perhaps it is one command in one terminal screen ?
Any help would be greatly appreciated. I have been working on this for the past week with no success.
P.S. There is a Menu Item directory with Item_Summary_Sys.rpt and even an artikeleport.rpt HOWEVER they are dated 2008 ....nine years ago....perhaps those are the answer if they could somehow be updated ...