| # | Header | Description | Req. | Size | Notes |
| 1 | ProjectName | Recognizable Name of the | Y | 60 | Must be unique. Must be first field. |
| 2 | Description | Full Description of the | Y | 252 | Brevity is the soul of wit. |
| 3 | Parent | Defines this 's place within the hierarchy | Y | 60 | The parent must be imported prior to the children, so sort your parent s to the top of your import file. |
| 4 | Estimate | Estimated total hours for the | N | 8 | Numeric, whole number. Cannot contain commas. |
| 5 | Percent Done | Percentage of completion for the | N | 3 | Must be a whole number between 1 and 100 inclusive. |
| 6 | Owner | A user who has modify rights to the | N | 28 | Must be a valid loginID of someone who has authority within Timesheet to create projects. If blank then it will populate with the loginID of the person running the import. |
| 7 | Loggable | Is this loggable or reportable only? | N | 1 | Must be a zero to indicate Reportable Only. Blank or any other value will be Loggable and Reportable. |
| 8 | AutoAdd | Is this automatically added to new s? | N | 1 | Must be a captial Y for AutoAdd. Capital N or blank or any other value is not AutoAdd. |
| 9 | State | State of | N | 28 | State is an Extra 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 . 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>> Extra Fields. |
| 10 | Priority | Priority of | N | 28 | Priority is an Extra 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 . 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>> Extra Fields. |
| 11 | Budget | Budget of | 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. |
| 12 | Project Bill Rate | Project Bill Rate of | 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 and Rates, then this field must be populated. |
| 13 | Project Bill Rate Type | Hourly, monthly, annual, etc. | N | 28 | Project Bill Rate Type is an Extra 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 and Rates, then this field must be "Hourly". |
| 14 | Project Pay Rate | Project Pay Rate of | 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 and Rates, then this field must be populated. |
| 15 | Project Pay Rate Type | Hourly, monthly, annual, etc. | N | 28 | Project Bill Rate Type is an Extra 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 and Rates, then this field must be "Hourly". |
| Any Extra Fields that you add to your s 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 Fields. You should add those columns right here in the sequence, between Project Pay Rate Type and Visibility. If you are not including either of those two fields, then just keep the custom fields inbetween whatever your last column is before Project Pay Rate Type and whatever your first column is after Visibility. If you have no columns after these, then the custom fields will be the last (right-hand-most) columns in your import file. | |||||