Exporting Menu Items to txt files

[9Coder]

Dear Folx,

Do you guys know how to exporting menu item on sybase for res 3700 like below result

Do you guys have any script that i can run for generating that result?


Thanks

 

[jimmymcp02]

this looks like a custom mi export.

you can try running the following script from sybase
select * from micros.v_R_sys_menuitem
once you find the data that you want to export in each column rewrite the sql to something like this

select menuitem_number, mi_seq, menuitem_name1, major_group_name from micros.v_R_sys_menuitem

if thats the data that you are looking for then to export you will need to write it like this

select menuitem_number, mi_seq, menuitem_name1, major_group_name from micros.v_R_sys_menuitem
output to c:\menu.txt
format ascii;

 

[jimmymcp02]

also if this data was generated from the computer that you are looking at there is a chance that the sql is somewhere
maybe under c:\micros\res\pos\scripts\