Aloha Grindq 2

[Palapas]

Hello ,

I am a new member and have a question on aloha POS 5.3.17, I need to know how to run the grindq.exe manually. What I am trying to do is to execute grindq command line manually as if I was running a report on todays data from within BOH, but I need to run this not from inside BOH but from a command line so that I can automate this script and all the files get updated in the \Data folder every hour, this way I can pull data from today from this files with excel every hour with out me having to run BOH reports everytime I need to see a report. I beleive it goes something like this c:\alohaqs\bin\grindq /DATE Data , but If I am wrong please correct me .... Thankssss for all your help...

 

[AdamDR]

You are correct: c:\alohaqs\bin\grindq.exe /date data

Adam

 

[Palapas]

do you know what is the lates version of Aloha Quick Service ... I am on 5.3.17 and wanted to know if there is a newer one, ... is there anywhere I can gointo and check on new features on update

 

[AdamDR]

Right now the newest is 5.3.25.

5.3.17 is an excellent version. unless you run into a bug that is fixed in a newer version, I would stick with that one. Not only that but with ver. 17 you are compliant with CISP.

 

[Palapas]

what is CISP?? and is there a place to know the bugs that were fixed in this newer version? a website or something...

 

[AdamDR]

1st question:

http://www.tek-tips.com/viewthread.cfm?qid=1099666&page=1

2nd question:
No, you have to talk with a dealer that gets the update document.

 

[RadAlohaQE]

latest version that is released is 5.3.25 as Adam mentioned.

also on the grindq, you can also manually grind dated subs by using the same command in in place of data put the dated sub name.

If you have access to the Radiant Systems FTP site you can download the 53Update.zip file found in the download section for each release. This is a standard rtf file that contains all bug fixes and enhancements and it is cumulative, so even though 5.3.25 is the current release it will show all 5.3 releases fixes and enhancements.

 

[Palapas]

is there a way to get access to the radiant systems FTP site to download this latest 53update.zip so that I can update my software??

 

[tteller]

RadAlohaQE, I am trying to do something similar as Palapas. But what I want is the Weekly Summary generated on Sunday morning for the previous week. I am thinking there are much more syntax options. Where can I find a list of all the syntax options for grindq?

Thanks in advance,
Tim Teller

 

[RadAlohaQE]

here are the options/parameters for grindq.

BALANCE=Creates BALANCE.TXT in the target folder with detailed financial information to enable easier solutions to report balancing questions.

CLUBIMPORT=Defines the name and location of the Membership Interface import file.

DATA=Specifies the DATA folder inside the current IBERDIR. For most applications, this has the exact same effect as the DATE parameter. This does not enable a different IBERDIR, unless the IBERDIR variable is used in conjunction.

DATE=Defines the dated folder to use. Use DATA as the date for the current day’s data. For most applications, this parameter is equivalent to the DATA parameter.

DEBUG=Generates extra debugging information in the Debout files.
DEBUGCONVERTLOG=Generates additional debug information in the debout files when converting a TRANS.LOG (transaction log), and it is used with the CONVERTTRANSLOG function. Has the same effect as the DEBUGCONVERTTRANSLOG variable.

DEBUGMERGETRANSLOGS=Generates additional debugging information in the debout files when merging transaction logs.

DEBUGSQLBUILD=Generates additional SQL debugging information in the debout files. This variable is considered true regardless of the assigned value. If this variable is not desired, completely remove it.

FORCECONVERTLOG=Forces Grind to upgrade a transaction log in the DATA folder to the current version of the Aloha application software.

HOUSE=Specifies a date range when rebuilding the House Account file. This (re)posts transactions for the specified date range and will double-post transactions if they already exist.

IBERDIR=IBERDIR defines the to the Aloha application software root folder name and location. This is only required for BOH applications. FOH application resolve the IBERDIR variable dynamically.

INTERVAL=Sets the time interval (in seconds) between recurrent grinds when used with RDB’s.

MERGETRANSLOGS=Merges the two transaction logs.

NODELETELOG=In versions 5.230 and higher, Grind deletes any intermediate versions of the transaction log when it upgrades the transaction log. If you enable this, Grind does not delete the intermediate versions of the log.

NOMUTEX=NOMUTEX enables multiple copies of the application to be active simultaneously. Should only be used in environments where two concepts are using the same file server. NOMUTEX stands for No-Mutual-Exclusivity.

NOWINDOW=Do not show the Grind window.

PAYCHEX=Creates the PAYCHEX export file for the previous pay period.

REGRIND=Forces re-Grind in SQLMODE.

ROBUST=Enables fault tolerance capabilities.

SQLMODE=SQLMODE instructs the Aloha application software to use an RDB database.

sTOREDIR=Sets the Store folder in SQLMODE.

STORENUM=Defines Store number. Used with SQLMODE.

TIMING=Generates extra debugging information in the debout files for Grind timing.

USESLEEPING=Grind waits for a signal from CTLSVR.EXE to activate instead of activating on timer basis. Used only with SQLMODE.

What you would want to do in order to get the Weekly Summary, I am presuming Sales report, is to run rpt.exe from a command line using parameters for it. This is usually done with Winhook but you could also setup a Windows scheduler event to run this.

 

[tteller]

Thanks RadAlohaQE. That's great, I called my local POS company that supports my Aloha system, and they said that grindqs doesn't have any switches.

Yes, I want to get a weekly summary in CSV format automatically generated. I can script the syntax for the dates, but I just need the syntax to do it. Is it possible to use rpt.exe to generate a CSV?

Thanks in advance,
Tim Teller