Aloha Grind Formats 1

[kpizz]

I have a question about Aloha and grinds.

I am trying to build a parser that grabs data form an aloha grind file and i was wondering if the data would be located in the same format for all aloha systems?

 

[coorsman]

No.

Cheers,
Coorsman

 

[kpizz]

Yikes... I wonder how the data structure changes over versions and if someone has the database schema's for multiple versions.

Do you know how many versions of Aloha there? Lastly, so i get this correct, are your telling me that each version of Aloha places the same information in different places? ie. transaction time stamps, amount, server, payment etc.

Thanks

K

p.s. thanks for the tip on squirrel.

 

[coorsman]

Ther versions that are widely used are
5.2
5.3
6.0
6.1
6.2
6.4
6.5
6.7

There are about 150 DBF files associated with Aloha and each version any of these files can change. If you are only reading a few of the grind dbf files the chances are it might not change but if you are associating them with EMP or other system DBF files thay do change.

I haven't seen 7.0 file structure yet but I think it's all SQL for reporting.



Cheers,
Coorsman