We need to access Aloha data from an external proigram; the Aloha installation is based on flat-files, no SQL Server.
I noticed that after the End Of Day you obtain a copy of the data into a folder named with the business date; most of the information is then available as DBF files; apparently these files contain a copy of the restaurant "settings" (menu items, price...) but nothing about what happened (transactions, sales, payments..)
I noticed that the EOD produces also a file (TRANS..) which should contains the transactions; the file is not a DBF and in a binary format probably undocumented.
How do I extract sales information from this file? Are transactions stored somewhere else?
thanks
I noticed that after the End Of Day you obtain a copy of the data into a folder named with the business date; most of the information is then available as DBF files; apparently these files contain a copy of the restaurant "settings" (menu items, price...) but nothing about what happened (transactions, sales, payments..)
I noticed that the EOD produces also a file (TRANS..) which should contains the transactions; the file is not a DBF and in a binary format probably undocumented.
How do I extract sales information from this file? Are transactions stored somewhere else?
thanks