Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aloha Database

Status
Not open for further replies.

rventi25

IS-IT--Management
Jul 14, 2009
10
US
Hello I am looking for a way to export my menu DB from Aloha and open it up in excel.
I tryed to do it and it gave the file ext ZBAK???
Anyone know how to do this?
 
AlohaRoss I must be doing something wrong. I have tried to use that enginering program link but it wont open the zbak file. Any help on this would be great

Thanks
 
If I wanted to collate information from a week's worth of GNDITEM.dbf files while also pulling the item name from the ITM.dbf files, is there an easy way to do this other than exporting each day into Excel?
 
No, not an easy way unless you are proficient in R and or Python and know how to merge that data. If you are trying to do this for inventory reasons, its worth investing in a service or software to do that.

You can open a .dbf file in excel, but you cannot save to that file type. I routinely save an excel copy of my itm.dbf to use as a lookup file. Use DBFNavigator if you want to open, edit, and save to .dbf.
 
With that being said, can the reports available be used to collect a span of days be altered in any fashion to acheive what I am looking for? Just wondering if there is a possibility of having a crystal report already available out there somewhere.
I essentially am trying to create unique item names if the item rang is a modifier (essentially combine the parent and child names) in the form of a product mix spanning 7 days.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top