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!
Can I generate CSV reports from the Command Line with Aloha
- Thread starter tteller
- Start date
RadAlohaQE
Vendor
I am not sure if Aloha can generate the CSV format from a command line but I will check it out and see what I can come up with.
- Thread starter
- #3
- Thread starter
- #4
I believe you have to use crystal reports module to do that. If you look at the last line under the reports drop down, you will see Crystal Reports. This is were you can add your custom reoport. When you click on a date there is a button called export (not export settings) and this is where you can export it. I do not think there is a way to have this happen automatically, because you would have to have a pretty good size script to fire the export command, and then more than likely you would have to increment that script daily to apply to the next dated sub.
Bo
Kentucky phone support-
"Mash the Kentrol key and hit scape."
Bo
Kentucky phone support-
"Mash the Kentrol key and hit scape."
- Thread starter
- #6
Well, looking at the DBF files.. since they are flat files, I think I may be able to extract directly out of the datafiles for a weekly summary. when I launch rpt.exe, the report engine fires up, then disappears. I would bet there are parameters you can feed the rpt.exe program. I can incr. the date, that is easy using scripts, or even a simple application I can whip up in a few mins. I just need to know what the syntax is.
Tim
Tim
RadAlohaQE
Vendor
RPT.EXE uses the following syntax and parameters:
1./IBERDIR declares the location of the Aloha application software folder. This does not need to be declared if the variable already resides in the system environment.
2./DATE specifies the DOB to report. It is based on the dated folder's label. Winhook uses the %1 variable to specify the date. The %1 parameter is standard syntax for referring to command-line variables from within a batch file. Refer to document ID 5998 for more information on the %1 parameter.
3./Rz to specifies the report to print. Replace z with a parameter listed later in this document.
4.In versions 5.2x and higher, use /LOAD "y" to specify a setting file for the Labor Report, Sales Report, and Product Mix Report, where y if the report settings file name.
5. In versions 5.2x and higher, use /Xz in place of /Rz to export the report to a file rather than print the report. Replace z with a parameter listed later in this document. The report is exported using the format and location information already existing in the report's export settings. The export will not function properly unless you have previously saved these settings in Aloha Manager, which creates an .EXP file for this report.
Report Parameters
Parameter and Function
A=Labor Report. In versions 5.0x and lower, use /NUM n to declare the Labor Report number (1-3).
AD=Daily Cashout Summary
B=Employee Break Report
C=Sales Report
CW=Weekly Sales Report
D=ADP Payroll Export File
DD=Delivery Driver Report
DP=Delivery Production Report
E=Entertainer Income Report
F=ReMacs Menu Item Sales Export File
G=Gift Certificate Tracking Report
H=Hourly Sales and Labor Report
HW=Weekly Hourly Sales and Labor Report
I=Menu Item Forecast Report
J=Tip Income Report
K=Comparative Server Sales Report
L=Scheduled Vs Actual Labor Report. You cannot fully automate this report from a command line.
M=Edited Punches Report
N=Surcharge Report
O=Overtime Warning Report
OD=Open Drawer Report
P=Product Mix Report
PQ=Weekly Quick Count Report
PW=Weekly Product Mix Report
Q=Employee Performance Measures Report
R=RealWorld Payroll Export File
S=Landry's Sales Report
T=Top Item Movement Report
TS=Team Service Tip Split Report
U=Edit Deposits Report
V=Void Report
W=Server Sales Report (There is not a way to select the employees to list in this report from a command line, so printing this report from a command line produces a blank report.)
Y=Payment Detail Report
Z=Sales By Revenue Center Report
1=Coconut Code Payroll Export File
11=Overtime Forecast Report
2=Coconut Code Sales Mix Export File
3=Coconut Code Daily Sales Export File
4=Back-of-House User Security
5=Back-of-House Security Levels
6=Detailed Access Levels
7=Front-of-House Cash Owed Report
8=Speed of Service Report
9=Tiered Tax Report
An example
The following command line exports a Sales (Cash) Report for 1/7/2000 in versions 5.2x and higher using the 'default' settings:
%IBERDIR%\BIN\RPT.EXE /DATE 20000107 /XC /LOAD "DEFAULT.SLS.SET"
sorry for the late reply, but it was not working on the export side but has been fixed.
1./IBERDIR declares the location of the Aloha application software folder. This does not need to be declared if the variable already resides in the system environment.
2./DATE specifies the DOB to report. It is based on the dated folder's label. Winhook uses the %1 variable to specify the date. The %1 parameter is standard syntax for referring to command-line variables from within a batch file. Refer to document ID 5998 for more information on the %1 parameter.
3./Rz to specifies the report to print. Replace z with a parameter listed later in this document.
4.In versions 5.2x and higher, use /LOAD "y" to specify a setting file for the Labor Report, Sales Report, and Product Mix Report, where y if the report settings file name.
5. In versions 5.2x and higher, use /Xz in place of /Rz to export the report to a file rather than print the report. Replace z with a parameter listed later in this document. The report is exported using the format and location information already existing in the report's export settings. The export will not function properly unless you have previously saved these settings in Aloha Manager, which creates an .EXP file for this report.
Report Parameters
Parameter and Function
A=Labor Report. In versions 5.0x and lower, use /NUM n to declare the Labor Report number (1-3).
AD=Daily Cashout Summary
B=Employee Break Report
C=Sales Report
CW=Weekly Sales Report
D=ADP Payroll Export File
DD=Delivery Driver Report
DP=Delivery Production Report
E=Entertainer Income Report
F=ReMacs Menu Item Sales Export File
G=Gift Certificate Tracking Report
H=Hourly Sales and Labor Report
HW=Weekly Hourly Sales and Labor Report
I=Menu Item Forecast Report
J=Tip Income Report
K=Comparative Server Sales Report
L=Scheduled Vs Actual Labor Report. You cannot fully automate this report from a command line.
M=Edited Punches Report
N=Surcharge Report
O=Overtime Warning Report
OD=Open Drawer Report
P=Product Mix Report
PQ=Weekly Quick Count Report
PW=Weekly Product Mix Report
Q=Employee Performance Measures Report
R=RealWorld Payroll Export File
S=Landry's Sales Report
T=Top Item Movement Report
TS=Team Service Tip Split Report
U=Edit Deposits Report
V=Void Report
W=Server Sales Report (There is not a way to select the employees to list in this report from a command line, so printing this report from a command line produces a blank report.)
Y=Payment Detail Report
Z=Sales By Revenue Center Report
1=Coconut Code Payroll Export File
11=Overtime Forecast Report
2=Coconut Code Sales Mix Export File
3=Coconut Code Daily Sales Export File
4=Back-of-House User Security
5=Back-of-House Security Levels
6=Detailed Access Levels
7=Front-of-House Cash Owed Report
8=Speed of Service Report
9=Tiered Tax Report
An example
The following command line exports a Sales (Cash) Report for 1/7/2000 in versions 5.2x and higher using the 'default' settings:
%IBERDIR%\BIN\RPT.EXE /DATE 20000107 /XC /LOAD "DEFAULT.SLS.SET"
sorry for the late reply, but it was not working on the export side but has been fixed.
- Status
Similar threads
- Locked
- Question