Reading infor from Micros 3700 (Sybase)

[BZ1917]

I need extract a simple PMIX report in xls or csv format. One a day, just item,quantity,price. Unfortunately 4.11 provides pdf file which cant be read by any system, except humans. I need it csv/xls format for further processing.
Does anyone have C,Java or any other way to connect to Sybase and get this info?
Thanks, for your answers. Micros 5 provides pdf file that could be easily converted to xls. The older 4.xx creates printable, but not processable file.

Any help would be appreciated.

 

[CathalMF]

Micros connects to the Sybase database using an odbc datasource connection.

you can view this configuration via the data source configurator in windows.

32bit server: C:\Windows\System32\odbcad32.exe
64bit server: C:\Windows\SysWOW64\odbcad32.exe

You can use whatever programming language you want to connect to an ODBC data source. You will just need to know a username and password to connect to your database.

Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/