Export Crystal Reports to CSV - Aloha

[JRNYC]

I need to get my item list in a CSV format and I know that the easiest way to get a full item list is via the Crystal Reports menu. But the export button doesn't seem to work and the only options look like VIEW and PRINT.

Is there any way to get these files in CSV or even text format? I tried converting the PDF to text and that was obviously a formatting disaster.

-Jon R.

 

[ClayTaco]

Grab the itm.dbf from the %iberdir%/DATA folder. DBF Commander will allow you to export as csv, and I'm sure other programs do as well.

 

[JRNYC]

Fantastic. I have no issue getting the data directly from the database files. Cut out the middle man

On a complete side note, is there a reference that exists anywhere about what each DBF file contains in the Aloha system?

Thank you!

 

[ClayTaco]

Yup, I added this to the links a while ago:

http://www.abacuspos.com/dbf_file_structure.html

It's a good quick reference. If you really want to start playing with the dbf's on your own I've attached a reference guide for the gnd*.dbf s.

 

[JRNYC]

I feel like a dolt for not noticing the links button. Thank you! This is incredible info.

 

[ClayTaco]

No problemo! I know that it can be hard to find information on Aloha so I try and share as much as I can.