Here are the steps on importing timesheet and expense data from an input file into Costpoint.

1. Create the comma-separated (.csv) files in the format defined by the input file layout. 
   All file names must be defined as <TABLENAME.CSV>. For example: SUBC_TS_HDR.CSV and SUBC_TS_LN.CSV upload the Timesheet Detail tab of the Manage Subcontractor Detail screen.

   Note: If your import files were created as .csv files out of SQL and have an encode type of UTF-8-BOM, you must change the input file encode type to UTF-8 so that Costpoint will recognize the file contents and proceed with the validation and import processes.
2. Go to the Import Subcontractor Detail screen and upload the subcontractor charge information from the input file(s). If errors are encountered, Costpoint displays the following message: "Errors were found in the input file(s) during validation. Refer to the error report to resolve these errors and run the import process again." Print and review the error report. If there are no errors, proceed to step 5.
   Note: You may upload both timesheet and expense data in the same import or choose to import only one. For each type, both header and line files must always be included in the import. Otherwise, you will encounter an error message.
3. Print and review the error report. Make corrections to the .csv file(s) and upload it again.
4. Repeat steps 2 and 3 until the upload process completes without errors.
5. Print the Import Subcontractor Detail Report and review the data to be imported.

   If you need to make modifications, repeat steps 3 and 4.

6. Print the final Import Subcontractor Detail Report and retain it for your records.
7. Click Actions to import the data into the database.