Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Errors can occur when importing timesheets due to data issues. The most common data issues are:

  • Incorrect date format

  • Blank active cells

Below are details on how to check if an error is due to one of these data issues and how to fix it.

...

  • Open the Excel file

  • Press Ctrl + End to locate the last active cellcell 

...

...

If the highlighted cell is blank, you will need to clear the blank active cells. To do this:

  • Highlight all blank Row(s)/Column(s) between the last Row/Column with data and the last active cell

  • Right Click and select Delete

  • Save the file

  • Redo Ctrl + End to make sure the highlighted cell has data

    Image RemovedImage Added
  • Re-import the file into FastTrack

If there are no blank active cells and you are still getting an error, check for incorrect date formats

Info

 If you continue to get an error lodge a request via our Service Desk portal and provide the import file and a screenshot of the error.

...