About VIP Premium export

In Messenger, the VIP Premium Export is an .ASC (Ascii) file.  It contains the Timesheet information between the selected dates and for the selected employees.

Here is an example of the VIP Premium Export

Figure 1

The format is as follows:

Character Number	What it is	Example
1	D	D
2 until 4	Cost Code	011
5	Layout Code	1
6 until 14	Employee Number	101
15 until 23	Hours Worked (column 1)	000038
24 until 25	Minutes Worked (column 1)	04
26	Add or Subtract Hours	+
27 until 35	Hours Worked (column 2)	000038
36 until 37	Minutes Worked (column 2)	04
38	Add or Subtract Hours	+
39 until 46	Hours Worked (column 3)	000038
47 until 48	Minutes Worked (column 3)	04
49	Add or Subtract Hours	+
50 until 58	Hours Worked (column 4)	000038
59 until 60	Minutes Worked (column 4)	04
61	Add or Subtract Hours	+
62 until 70	Hours Worked (column 5)	000038
71 until 72	Minutes Worked (column 5)	04
73	Add or Subtract Hours	+
74 until 82	Hours Worked (column 6)	000038
83 until 84	Minutes Worked (column 6)	04
85	Add or Subtract Hours	+
86 until 99	Fill up with blanks, end with Z	Z