Subtle T&A problem

This brief document outlines a subtle issue with the renaming of Windows files with a suffix that is auto-hidden by Windows by default.

In this particular instance, the client is experiencing issues with running the T&A import process - the particular problem being that nothing is picked up by the data import.

Overview - timeclock export input data

The first item to check for T&A upload is the input data and file. Reviewing the details of the configuration as shown in the next data element (below), we'll check the input data.
The following image (in DOS format), shows the input file as "acs_tna.csv.csv", you'll notice from the configuration in the next data element (below) indicates a file named "acs_tna.csv"

dos data

Therefore, the issue appears to be a simple one of correctly renaming the input file to "acs_tna.csv" (remove the extraneous .csv suffix).

Please refer to the last note in this article on how / why Windows behaves as it does, and how to correctly set the file-name. And, t
T o re-iterate the confusion, the following image may lead you to believe that the file name is named correctly, however this is due to your personal settings which hide the 'suffix'. We leave this for your own edification via google.

windows dir


Powerforce T&A configuration to match

The below configuration represents the layout of the timeclock data above, with each field being described as 'positional' within the single line.

T&A configuration

 


Timeclock data - data content

As we've commenced to show in the 1st image above, you'll notice that we're opening the file using notepad, to review the data content.

Note from the file date, that the date of the writing of this helpdesk ticket is 17th June. And, we'll need to review the input data prior to uploading. The first few lines relate to time clocking data relating to 23/05/2014, which is some 4 weeks prior to the period that this document is being written within.

t&a data input

fast-forward to the end of the file, confirms : t&a import data

The last part of the file is clearly of the time period representative of the date of this documents creation.

Therefore, we would advise that you clean up the file to represent the time clocking data relating to the period that you wish to load data for.


Show or hide file name extensions


A file name extension is a set of characters added to the end of a file name that determine which program should open it.

For more information, see File names and file name extensions: frequently asked questions.

Windows hides file name extensions, but you can choose to make them visible.

To show or hide file name extensions

  1. Open Folder Options by clicking the Start button Picture of the Start button, clicking Control Panel, clicking Appearance and Personalization, and then clicking Folder Options.

  2. Click the View tab, and then, under Advanced settings, do one of the following:

    • To show file name extensions, clear the Hide extensions for known file types check box, and then click OK.

    • To hide file name extensions, select the Hide extensions for known file types check box, and then click OK.

Click on the following link :External link to showing file extensions for further details on showing actual file extensions.