Home | Contact Us | Buy
Time and Attendance made easy  
Automatically Importing Clockings and other Data

Required Level : Standard
Required Version : 3.21 or later

TNA supports the automatic collection of data from other hardware devices, via a text file.  TNA is able to monitor directories for files, and as soon as a file is placed in the directory then it is automatically imported.  This feature can also be used to automatically import employees, rosters, job, etc.

Related Articles
    TNA Generic Import Format
  Configuration - part 1
  1. In the Configuration module, go to the Setup menu and select the Features option.

  2. Select the Hardware settings option.

  3. Select the Using Text-Import from hardware option.

Enable text import feature

  Configuration - part 2

  1. In the Configuration module, go to the Setup menu, to the Clocks option and select Clocks.

  2. Select the Controller This PC (Controller having the Controller Code of 0) which is the computer on which the TNA system is running.

  3. Click on Add Device.

  4. Select the General settings option.

  5. In the Clock Code field put a simple name for this entry.  Something as trivial as Disk will do nicely.  (If you have multiple devices make sure each has a unique name.)

  6. Enter any Description you like.

  7. Select Text Import Generic from the Make & Model list.

  8. Click on the Connection settings option.

  9. Enter the name of the file to watch for in the File field. Include the full path name. For example
       c:\incoming\clock.txt

    Note that Wild Cards are acceptable in the name (in version 3.24 or later). For example
       c:\incoming\*.csv

    File Path

  10. Select the Format that matches the format of your incoming text file.

  11. Select Ok to save this option.


  How it works

The Communications module monitors the directory(s) set in the Connection File box.  If a file arrives in the directory, then it is automatically imported.

After importing the file is automatically renamed, by adding the time and date of the import to the file name and the file is moved into a subdirectory called Done.  (If the directory does not exist it will be created for you.)

The communications module only checks the directory every minute or so, so a file may be in the directory for about a minute before it is imported.

If you are importing more than one type of file, you would need to create a new device for each type unless you use the generic import format and a wild card in the file name e.g. if you are importing clockings from another hardware device and you want to import daily shift rosters you need to create one device to import clockings and another to import rosters.

 

 

   Terms of Use      Disclaimer 

2007 CapeSoft Software (Pty) Ltd. All rights reserved.
This site is optimized for IE 6+, Firefox 1.0+, and resolution 1024*768 pix