Need to print/pdf barcode number & MI number and description from RES3700

[JonnyB82]

Hi,

Could anyone tell me a way that I can print/pdf export the BARCODE NUMBER, LINKED MENU ITEM NUMBER, LINKED MENU ITEM DESCRIPTION from the Micros 3700 database?

We are trying to configure the Concept Spa System and it would really save a lot of time if we didn't have to scan every single product (1000's!).

Many Thanks
Jon

 

[pmegan]

Try this. I don't have any barcodes so it's untested, but should give you what you're looking for in a csv file.
Change the path (in blue) to the export file you want to create.
The "barcode" field is the actual barcode, "barcode_num" is the Micros barcode number so you may not need it.

unload
    select 
        b.obj_num [barcode_num]
        ,b.barcode [barcode]
        ,m.obj_num [mi_num]
        ,m.name_1 [mi_name]
    from 
        micros.barcode_def [b]
        join micros.mi_def [m]
            on b.mi_seq = [m].mi_seq
to [blue]'D:\\micros\\barcode.csv'[/blue] quotes off

 

[JonnyB82]

PMEGAN, you are a star, thank you very muchworked perfectly, that is sure going to save some time!