Aloha, Merging dated folders, 4 into 1 @sheerdyn

[eburks]

Someone posted that they had to make 4 Aloha terminals fileservers (someone probably unplugged the switch

sheerdyn replied:

If you made each terminal master server, you will need to recover them prior to opening business so that you do not lose any data for that day of business. Each terminal will run it's own end of day and you will need to merge those sales data together from each terminal to make one dated sub.

I'm always interested in learning. After those terminals ran end of day and created their own dated folders, how would you merge the sales data from 4 dated folders into 1 dated folder.

 

[sheerdyn]

merging, splitting, and repairing trans.log works but does not always guarantee 100% accurate numbers in your reports whether it be sales or labor. to merge the sales ie 4 to 1 i usually rename the trans.log to trans1.log, trans2.log, etc and place them in one of the dated subs. Go to command prompt and path to the dated sub directory.

type:

copy /b trans1.log+trans2.log+trans3.log+trans4.log trans.log

this should copy the trans.log in binary format and saves it to the new file "trans.log

regrind the dated sub directory and your reports should update.

 

[AlohaRoss]

That is brilliant!!!

AlohaRoss

http://www.needalohahelp.com

 

[eburks]

That's what I thought. Is a trans log a linear file so that as time goes on the transactions are further down into the file. If so I guess you should be able to split in a hex editor when you find the correct ticket number and merge the ending with an empty log if you have a log with multiple days in it. As far as I am aware there is no date info in the trans log, date info is taken from aloha.ini only.... right?

 

[sheerdyn]

it is in the trans.log when using appropriate software to read a trans.log, it outputs it to a text file which shows date, time, check number, etc. An example is below.


1 Term: 1 Type: NEW LOG 02:00:44 AM Fri Oct 25, 2013 [ 0] ( 27)
Version: 6.4.19.1463 Gen #: 12 (QuickService) (Release Version)

2 Term: 1 Type: CLEAR ORDER LOCK 02:09:04 AM Fri Oct 25, 2013 [ 40] ( 4)

3 Term: 1 Type: TERMINAL UP 02:09:08 AM Fri Oct 25, 2013 [ 57] ( 54)
Term: 1 Gen #: 12 Version: 6.4.19.146

4 Term: 2 Type: TERMINAL UP 02:09:13 AM Fri Oct 25, 2013 [ 124] ( 54)
Term: 2 Gen #: 12 Version: 6.4.19.146

5 Term: 2 Type: LOG IN 09:51:00 AM Fri Oct 25, 2013 [ 191] ( 22)
Employee 802 Term: 2

6 Term: 2 Type: CLOCK IN 09:51:00 AM Fri Oct 25, 2013 [ 226] ( 76)
Employee 802: Shift 0: IN: 9:51 OUT: 0:00 RATE: 0.00 JOB: 9

7 Term: 2 Type: OPEN TABLE 09:51:00 AM Fri Oct 25, 2013 [ 315] ( 53)
Employee 802 TDef: 0 Id: 2097153 Size: 1 Type:0 Name:

8 Term: 2 Type: ADD CHECK 09:51:00 AM Fri Oct 25, 2013 [ 381] ( 35)
Employee 802 Table: 2097153 Check: 2097153 Number:0 Queue:1

9 Term: 2 Type: NO SALE 09:53:39 AM Fri Oct 25, 2013 [ 429] ( 28)
Manager 802 Employee 802 Drawer:2 Reason:1

10 Term: 2 Type: LOG OUT 10:10:30 AM Fri Oct 25, 2013 [ 470] ( 18)
Employee 802 Term: 2

11 Term: 2 Type: LOG IN 10:10:34 AM Fri Oct 25, 2013 [ 501] ( 22)
Employee 802 Term: 2

12 Term: 2 Type: ASSIGN DRAWER 10:10:37 AM Fri Oct 25, 2013 [ 536] ( 22)
Manager 802 Employee 802 Drawer: 2

13 Term: 2 Type: BEGIN ORDER 10:10:38 AM Fri Oct 25, 2013 [ 571] ( 28)
Employee:802 Queue:1 Table:2097153 Check:2097153

14 Term: 1 Type: ORDER NUMBER 10:10:39 AM Fri Oct 25, 2013 [ 612] ( 14)
Queue:1 Table: 2097153 Preceeding: 0 Number:100

15 Term: 2 Type: ITEM INFO 3 10:10:45 AM Fri Oct 25, 2013 [ 639] ( 90)
1 of 1, containing 1 items for next DELETE ITEMS txn (Aux 0)
Entry Type Menu Mode Prt Vid Trm Seat Tax Tax2 Splt Price Data Lvl MC
2097173 | 0 | 21 | 80 | 15 | 0 | 2 | 0 | 1 | 0 | 0 | 5.99 | 5120 | 0 | 0

16 Term: 2 Type: DELETE ITEMS 10:10:45 AM Fri Oct 25, 2013 [ 742] ( 33)
Manager 802 Employee 802 Table: 2097153 Check: 2097153 Reason: 0

17 Term: 2 Type: ORDER MODE 10:11:03 AM Fri Oct 25, 2013 [ 788] ( 20)
Employee: 802 Queue: 1 Order: 2097153 Mode: 2 Reason: 0

18 Term: 2 Type: ITEM INFO 3 10:11:03 AM Fri Oct 25, 2013 [ 821] (505)
1 of 1, containing 6 items for next ORDER ITEMS txn (Aux 0)
Entry Type Menu Mode Prt Vid Trm Seat Tax Tax2 Splt Price Data Lvl MC
2097202 | 0 | 21 | 2 | 15 | 0 | 2 | 0 | 1 | 0 | 0 | 5.99 | 5120 | 0 | 0
0 | 34 | 0 | 5120 | 1 | 15 | 1 | 0 | 0 | 14030454 | 2 | -0.00 | 3 | 0 | 1
0 | 66 | 16777216 | 3 | 256 | 1 | 21 | 0 | 15 | 658511861 | 1 | 0.00 | 570433536 | 20 | 0
14030454 | 0 | 0 | 570433536 | 512 | 256 | 0 | 0 | 1 | -2061584303 | 18 | 0.00 | 1711276032 | 0 | 15
658507755 | 0 | 0 | 1962934272 | 2595840 | 512 | 33554432 | 0 | 256 | 171965194 | 0 | 0.00 | 0 | 32 | 1
1030792151 |118 | 16777473 | 0 | 802 | 315904 | 0 | 0 | 512 | 0 | 0 | 0.00 | 54806 | 0 | 0

19 Term: 2 Type: ORDER ITEMS 10:11:03 AM Fri Oct 25, 2013 [ 1339] ( 49)
Employee 802 Table: 2097153 Check: 2097153 Mode:2 Printed:1

20 Term: 2 Type: UNKNOWN 461 10:11:03 AM Fri Oct 25, 2013 [ 1401] (381)

21 Term: 2 Type: UNKNOWN 462 10:11:03 AM Fri Oct 25, 2013 [ 1795] ( 10)

22 Term: 2 Type: UNKNOWN 461 10:11:09 AM Fri Oct 25, 2013 [ 1818] (342)

23 Term: 2 Type: UNKNOWN 462 10:11:09 AM Fri Oct 25, 2013 [ 2173] ( 10)

24 Term: 2 Type: APPLY PAYMENT 10:11:09 AM Fri Oct 25, 2013 [ 2196] (328)
Employee 802 Table: 2097153 Check: 2097153 Payment: 2097153
Type: 9 Amt: 24.70 Tip: 0.00 CashBack: 0.00 'Ident':'' Exp: Auth:

25 Term: 1 Type: UNKNOWN 461 10:11:12 AM Fri Oct 25, 2013 [ 2537] (319)

26 Term: 1 Type: UNKNOWN 462 10:11:12 AM Fri Oct 25, 2013 [ 2869] ( 10)

27 Term: 1 Type: AUTH 10:11:12 AM Fri Oct 25, 2013 [ 2892] (538)
Employee 802 Table: 2097153 Check: 2097153 Payment: 2097153 GiftCard: 0
Mgr: 0 Code:2 Auth:051113 Reason:APPROVED Type:11
User:0 File number:10000 Ref:317 Trans:
AuthAmt: 24.70 AuthAmtFC: 0.00 CashBack: 0.00 Balance: 0.00

28 Term: 2 Type: PRINT CHECK 10:11:11 AM Fri Oct 25, 2013 [ 3443] ( 28)
Employee 802 Table: 2097153 Check: 2097153

29 Term: 2 Type: OPEN TABLE 10:11:11 AM Fri Oct 25, 2013 [ 3484] ( 53)
Employee 802 TDef: 0 Id: 2097154 Size: 1 Type:0 Name:

30 Term: 2 Type: ADD CHECK 10:11:11 AM Fri Oct 25, 2013 [ 3550] ( 35)
Employee 802 Table: 2097154 Check: 2097154 Number:0 Queue:1

31 Term: 2 Type: CLOSE CHECK 10:11:11 AM Fri Oct 25, 2013 [ 3598] ( 55)
Employee 802 Table: 2097153 Check: 2097153

32 Term: 2 Type: CLOSE TABLE 10:11:11 AM Fri Oct 25, 2013 [ 3666] ( 24)
Employee 802 Table: 2097153 Guests:1 Period:1 Training:0

33 Term: 1 Type: LOG IN 10:20:59 AM Fri Oct 25, 2013 [ 3703] ( 22)
Employee 4444 Term: 1

34 Term: 1 Type: CLOCK IN 10:21:00 AM Fri Oct 25, 2013 [ 3738] ( 76)
Employee 4444: Shift 0: IN: 10:21 OUT: 0:00 RATE: 0.00 JOB: 17

35 Term: 1 Type: OPEN TABLE 10:21:00 AM Fri Oct 25, 2013 [ 3827] ( 53)
Employee 4444 TDef: 0 Id: 1048577 Size: 1 Type:0 Name:

36 Term: 1 Type: ADD CHECK 10:21:00 AM Fri Oct 25, 2013 [ 3893] ( 35)
Employee 4444 Table: 1048577 Check: 1048577 Number:0 Queue:1

37 Term: 2 Type: BEGIN ORDER 10:35:19 AM Fri Oct 25, 2013 [ 3941] ( 28)
Employee:802 Queue:1 Table:2097154 Check:2097154

38 Term: 1 Type: ORDER NUMBER 10:35:20 AM Fri Oct 25, 2013 [ 3982] ( 14)
Queue:1 Table: 2097154 Preceeding: 2097153 Number:101