Aloha Database

[rventi25]

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]

use this program and copy/paste into excel

AlohaRoss

http://www.needaholahelp.com

3rd Party support

 

[rventi25]

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

 

[AlohaRoss]

rename to .dbf

AlohaRoss

http://www.needaholahelp.com

3rd Party support

 

[bufftrek]

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?

 

[MenulinkMan]

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.

 

[bufftrek]

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.