About Prizm export

In Messenger, the excel export is actually a .csv (Comma Separated Value) file.  It contains the Timesheet information between the selected dates and for the selected employees.

Here is an example of the Prizm Export.  Please note that the hours are in decimal format.  This means that 10 hours and 45 minutes will be 10.75

Figure 1

The columns are as follows:

1. The employee’s Payroll ID (as entered on Messenger)
2. The employee’s first name (as entered on Messenger)
3. The employee’s surname (as entered on Messenger)
4. Total of Timesheet Column 1 (in decimal)
5. Total of Timesheet Column 2 (in decimal)
6. Total of Timesheet Column 3 (in decimal)
7. Total of Timesheet Column 4 (in decimal)
8. Total of Timesheet Column 5 (in decimal)
9. Total of Timesheet Column 6 (in decimal)
10. Total of Timesheet Column 7 (in decimal)
11. Total of Timesheet Column 8 (in decimal)

The rows are as follows:

1. Header row containing column headings
2. Blank row
3. Listing of the employees on the timesheet
4. Blank row
5. The Total timesheet hours per column for all employees
6. Footer row with timesheet column names