| # | Header | Description | Req. | Size | Notes |
| 1 | Name | LoginID of your user(s) | Y | 28 | Is case sensitive. Space is a valid character. This is the primary field for user import, and it must be in all new user imports and user modification imports. |
| 2 | Authorization | Role/Authority within Timesheet | Y | n/a | Values must match exactly the name of the Role/Authority within Timesheet that you want to assign. You can assign multiple values for a single user (row) by merely separating with commas, and then surround the field with double-quotes, like this: "User, Reporter" . |
| 3 | Number of Input Records | Number of blank rows on a time entry screen | Y | 2 | Numeric. Must be a number between 1 and 20 inclusive. 3 or 5 are most common choices. |
| 4 | Full Name | Normal name of the user | Y | 60 | Timesheet is expecting you to put the name in "Last, First" format. If there are double-quotes around the name they will be stripped off in the import. |
| 5 | Default Comment | Comment to appear by default on the time record for this user | N | 28 | If field is not included, or some users' fields are left blank, the Global Default value will be applied. The Global Default value for this field is set in Admin>>Global Preferences>>General Options. |
| 6 | Time Entry GUI in Use | Name of time entry screen for the user | Y | 60 | Value in this field must exactly match the name of a Time Entry Screen that is in existence in the application. If the “Time Entry GUI in Use” does not exist, the user will be assigned the default screen. Blank or invalid values in this field will often result in an error message and the user's record not being imported. |
| 7 | Expense Entry GUI in Use | Name of expense entry screen for the user | Y | 60 | Value in this field must exactly match the name of a Expense Entry Screen that is in existence in the application. If the “Expense Entry GUI in Use” does not exist, the user will be assigned the default screen. Blank or invalid values in this field will often result in an error message and the user's record not being imported. |
| 8 | Mileage Entry GUI in Use | Name of mileage entry screen for the user | Y | 60 | Value in this field must exactly match the name of a Mileage Entry Screen that is in existence in the application. If the “Mileage Entry GUI in Use” does not exist, the user will be assigned the default screen. Blank or invalid values in this field will often result in an error message and the user's record not being imported. |
| 9 | Phone Number | Phone number for user | N | 28 | |
| 10 | Employee Type | Type of employee | N | 28 | Field is optional. Employee Type is an Extra User Field that is a drop-down menu. The value specified for each user must match the value of one of the choices in the drop-down menu exactly . You can modify that list of choices by logging in to your installation of Timesheet as an Administrator and going to Admin>> Application Settings>> Extra Fields Administration. If you include the field in your import file, you may leave the value blank for some or all users. All blank values will be set to no value (null). |
| 11 | Email Address | Email address for user | N | 28 | Field is required for any person who should receive email notifications. If you include the field in your import file, you may leave the value blank for some or all users. All blank values will be set to no value (null). |
| 12 | User Bill Rate | Base billable rate for a user | N | 28 | Numeric without a character to indicate currency (like a $ or £). Cannot contain commas, but can contain a decimal point and two numbers to the right of the decimal. If you are using the Rate Manager Module then this field must be populated. |
| 13 | User Bill Rate Type | User Bill rate type for user from drop-down select list in Timesheet | N | 28 | User Bill Rate Type is an Extra User Field that is a drop-down menu. The value specified for each record must match the value of one of the choices in the drop-down menu exactly . If you are using the Rate Manager Module then this field must be "Hourly". |
| 14 | User Pay Rate | Base pay rate for the user | N | 28 | Numeric without a character to indicate currency (like a $ or £). Cannot contain commas, but can contain a decimal point and two numbers to the right of the decimal. If you are using the Rate Manager Module then this field must be populated. |
| 15 | User Pay Rate Type | User Pay rate type from drop-down select list in Timesheet | N | 28 | User Pay Rate Type is an Extra User Field that is a drop-down menu. The value specified for each record must match the value of one of the choices in the drop-down menu exactly . If you are using the Rate Manager Module then this field must be "Hourly". |
| 16 | Employee Number | Employee ID or unique number for user | N | 28 | If you include the field in your import file, you may leave the value blank for some or all users. All blank values will be set to no value (null). |
| 17 | Title | Title or job description for user | N | 28 | If you include the field in your import file, you may leave the value blank for some or all users. All blank values will be set to no value (null). |
| 18 | Department | Department to which the user belongs | N | 28 | If you include the field in your import file, you may leave the value blank for some or all users. All blank values will be set to no value (null). |
| 19 | Manager Name | Manager for the user | N | 28 | If you include the field in your import file, you may leave the value blank for some or all users. All blank values will be set to no value (null). |
| Any Extra Fields that you add to your users can be imported in this file. Just add a column for each field that you want to import. The Header must exactly match the name you gave the field. The field size was determined when you created the field. You can create new fields by going to Admin>> Application Settings>> Extra Fields Administration>> Extra User Fields. You should add those columns right here in the sequence, between Groups and TimeApprovalName. If you are not including either of those two fields, then just keep the custom fields inbetween whatever your last column is before Groups and whatever your first column is after TimeApprovalName. If you have no columns after these, then the custom fields will be the last (right-hand-most) columns in your import file. | |||||