After a set of timesheet records have been exported as a database export (csv) file, the file can be imported into another application or database via the appropriate data loading utility (for example, via the Microsoft Access or Sage Accounting data import processes). The exported data is set in a fixed column format, outlined below.
Each line of the CSV export file data provides the information for a distinct timesheet entry, which is the intersection on a timesheet grid of the billing codes and the day of the week for an employee's Timesheet. A distinct timesheet entry exists for each entry of hours on a timesheet.
The timesheet to which a given timesheet entry belongs can be identified by the timesheet Id column included in the flat file output, with the employee related to that timesheet identified by their employee number. A specific timesheet entry can be identified by the timesheet Id, project, activity and task billing codes, billable status and the day Id. Billing rates are applied to each entry as defined by the rates registered for each user and project (as described for Invoice Reports).
The format of the CSV file data, with the first column on the left of a printed line listed as Column 1, is as follows:
|1||Employee Number||The employee number of the employee corresponding to the timesheet entry record.|
|2||Username||The username registered for the employee.|
|3||First Name||The first name of the employee.|
|4||Last Name||The last name of the employee.|
|5||Email Address||The email address of the employee.|
|6||Phone||The work phone number and extension (if any) of the employee.|
|7||Administrator flag||A boolean value indicating whether or not the employee is an administrative user. This value is represented by either of the words 'true' or 'false'.|
|8||Active flag||A boolean value indicating whether or not the employee is an active user. This value is represented by either of the words 'true' or 'false'.|
|9||Timesheet Id||The uniquely identifying timesheet Id assigned by Senomix to the timesheet record.|
|10||Week Ending Date||The week ending date corresponding to the timesheet. This date is presented in the form "DD-MM-YYYY HH:MM:SS", with the hours, minutes and seconds all set to 0.|
|11||Submitted Date||The submitted date corresponding to the timesheet. This date and time value is presented in the form "DD-MM-YYYY HH:MM:SS".|
|12||Project Code||The project code attribute of the project corresponding to the timesheet entry.|
|13||Project Name||The name of the project billing code corresponding to the timesheet entry.|
|14||Activity Code||The activity code attribute of the activity corresponding to the timesheet entry.|
|15||Activity Name||The name of the activity billing code corresponding to the timesheet entry.|
|16||Task Code||The task code attribute of the task corresponding to the timesheet entry.|
|17||Task Name||The name of the task billing code corresponding to the timesheet entry.|
|18||Billable Status||An integer value indicating whether the time entry is for a billable or non-billable item of work. The int values for that billable status are as follows:
0 Non-billable work
1 Billable work
|19||Day of the Week||An integer value indicating the day of the week which corresponds to the timesheet entry. Days of the week correspond with these numbers as follows:
|20||Hours||The hours entered for the timesheet entry.|
|21||Billing Rate||The hourly billing rate to be applied to the hours of the listed timesheet entry.|
|22||Timesheet Comment||The comment text which has been associated with the timesheet entry. Up to 5000 characters can be entered for a timesheet entry comment, with the number of characters stored for the comment indicated in the Comment Size attribute preceding this data. If there is no comment for a timesheet entry, this area will contain 5000 space characters.
As a timesheet comment is right-padded with space characters to bring it to a fixed length of 5000 characters, the comment itself can be extracted from this block of text by fetching a sub-string from position 504 to the length of text indicated in the Comment Size attribute.
Carriage returns within the comment are indicated by a "¶" character and can be replaced with the receiving database's character combination for carriage returns as desired.
|23||Entry Date||The Date for which the Timesheet Entry was recorded (this can also be determined from the Week Ending Date and Day of the Week attributes). This date value is presented in the form "DD-MM-YYYY".|