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!

Aloha Polling software alternative?

Status
Not open for further replies.

alexander00pr

IS-IT--Management
Aug 24, 2007
59
PR
In our restaurant we are implementing a new time atendace / payroll system that will use Aloha POS as a clock. I am using rsync linux tool for remote polling of the data stored in the dated sub with success. However the IT Staff of the company that is installing the payroll software arent very confident of rsync and are requesting a 2nd method of transfering the files. I dont want to pay enterprise for that. So I want to know if there is another solutions for remote polling of data into a central location?
 
That would depend on the format you need the data to be in. You can create a csv export file from Aloha or you can mine the data from the dbf grind files. Aloha also has the ability to create export files that are formatted specifically for a few payroll programs such as paychecks and ADP.
 
The format is in .dbf files. I cloned the dated folder using 3 main things.

Netdrive: to map a remote ftp folder as a local windows drive letter.
Synology NAS: Network attached storage for backup hosted in Headquarters.
Viceversa: Software that would clone an replicated the dated subdir from point A to point B. Ex. C:\AlohaTs\20080615 to X:\Folder\20080615. X: is the remote ftp server mapped as a windows drive letter.

In Viceversa I put a flag that would exclude the bin\bmp\data\CRW\EDC.. folders and whatever file extension as .exe, .ini i want so the backup would run very quickly typically 5 seconds. I also put a flag that the backup would run as soon as the source folder has changed

Is pretty easy an is saving me monthley fees for similar services
 
You could use an end of day (winhook)batch file
to move your dated folders to another folder
or disk.From there you could have another scheduled event
move data.You could even have winhook kick off a separate
batch file to manipulate data.
The %1 varialble is filled in with date and is only valid within end of day batch file.
pkzip could be replaced with another program.
Failure to complete eod batch file may result in
eod not completing so you may want to
include error checking if eod batch file is complicated.
I beleive you can automate the reporting so that it can
be exported to a file format at eod and moved along
with the dated data.


rem *** Define Backup/Xfer drive and folder ***
SET ABACKUP=D:\ALOHAZIP
SET AFTP=X:\ALOHAFTP
rem --------------- Data Archiving ------------------
rem *** Archive dated subdirs to archive drive ***
REM ***REGULAR BACKUP FOLDER***
PKZIP %ABACKUP%\%1.ZIP %IBERDIR%\%1\*.*
REM ***DATA XFER FOLDER*****
PKZIP %AFTP%\%1.ZIP %IBERDIR%\%1\*.*


hope this helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top