Problem
Errors can occur when importing timesheets due to data issues. The most common data issues are:
Incorrect date format
Below are details on how to check if an error is due to one of these data issues and how to fix it.
Incorrect Date Format
All dates included in the timesheet import file must be in the format dd/mm/yyyy. If a date is not in this format, the following error will occur when clicking Queue Batch.
Common causes for the date format to be incorrect are:
The date has an extra digit, ie 13/12/20019 instead of 13/12/2019
Date cells have the wrong date format selected
Solution
Check all dates in the import file to ensure:
There are no extra digits
They are in the format dd/mm/yyyy
If all dates look correct but the error is still occurring, the wrong date format may have been selected for all or just one date cell. In Excel, there are 2 short date types with the format dd/mm/yyyy, these are:
14/03/2012
*14/03/2012
The format with the asterisk needs to be selected for an Excel file to import correctly.
To ensure all date cells have the correct format:
Open the import file in Excel
Select a date column so it’s highlighted
Right Click on column > select Format Cells
Select Date
Select *14/03/2012
Click OK
Repeat for all date columns
Save the file then re-import into FastTrack360
Blank Active Cells
When saving an Excel file, a blank active cell is saved if there is formatting in the cell. This generally happens if data has been deleted from a cell using Delete on a keyboard rather than using Excel’s Delete or Clear options. A blank active cell can cause an error when importing into FastTrack360 as it’s expected an active cell has data.
If a timesheet import file includes a blank active cell, one of the following errors may occur:
Solution
To check if there are any blank active cells in the import file:
Open the Excel file
Press Ctrl + End to locate the last active cell
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
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.
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.
Related articles
Filter by label
There are no items with the selected labels at this time.