CS Time/TNA Documents

username password

Clockings

    The Import option enables you to import clocking information from other access and time management systems into CS Time without the loss of information or having to manually input this information.

     

    CONTENT

    Import Clockings Formats

    CS Time supports a variety of import formats for importing clockings of which some are detailed below.

    CS Time Generic Format

    The CS Time Generic Import Format is a CSV (Comma Separated) format where each line represents a separate clocking or data record.

    The main advantage of CS Time Generic Format is that it can also be used to import other information other than clockings. The first field on each row identifies the type of record being imported. For example C is for clockings, L is for leave, R is for Rosterings and so on.

     

    ImportGenericClockings.jpg

     

    The format used is as follows:

    Field

    Name

    Max Length (Chars)

    Description

    1

    Record Type

    1

    C for clockings (import type identification).

    2

    Site

    4

    Optional. Usually left blank. If blank then the site code at the place of import is used.

    3

    Card Number

    10

    The Card Number for the employee. This is optional if the Employee Number is used.

    4

    Employee Number

    10

    If omitted then the employee assigned to the card gets the clocking. Either the Card Number, or Employee number (or both) must be used. If both are used then the Employee Number will override the Card Number, but the card number will be stored with the clocking.

    5

    Date

    10

    Requireddd/mm/yyyy

    6

    Time

    8

    Optional. hh:mm:ss or hh:mm - If empty then the clocking will apply from 0:00.

    7

    Direction

    1

    Either I for in or O for out. Required if the clocking is a payroll clocking but not required if it's just a change of classification.

    8

    Device

    8

    Optional. Usually a reference to the clock being used. In the case of an import you may want to use this field to identify imported clockings.

    9

    Authorised

    1

    Y if the clocking is valid, or N, or D, if it still requires further authorisation. If omitted then Y is assumed.

    10

    Company

    30

    Optional. Places the employee in a particular company, from the time/date entered above. You can use either the company number, or the company name (as set in the TNA Configuration module.)  If the company does not exist then it will be created on the fly in the TNA system.

    11

    Branch

    30

    Optional. Places the employee in a particular branch, from the time/date entered above. You can use either the branch number, or the branch name (as set in the TNA Configuration module.) If the branch does not exist then it will be created on the fly in the TNA system.

    12

    Department

    30

    Optional. Places the employee in a particular department, from the time/date entered above. You can use either the department number, or the department name (as set in the TNA Configuration module.)  If the department does not exist then it will be created on the fly in the TNA system.

    13

    Cost Centre

    30

    Optional. Places the employee in a particular cost centre, from the time/date entered above. You can use either the cost centre number, or the cost centre name (as set in the TNA Configuration module.) If the cost centre does not exist then it will be created on the fly in the TNA system.

    14

    Category

    30

    Optional. Places the employee in a particular category, from the time/date entered above. You can use either the category number, or the category name (as set in the TNA Configuration module.)  If the category does not exist then it will be created on the fly in the TNA system.

    15

    Scale

    30

    Optional. Places the employee in a particular scale, from the time/date entered above. You can use either the scale number, or the scale name (as set in the TNA Configuration module.)  If the scale does not exist then it will be created on the fly in the TNA system.

    16

    Type

    30

    Optional. Places the employee in a particular type, from the time/date entered above. You can use either the type number, or the type name (as set in the TNA Configuration module.)  If the type does not exist then it will be created on the fly in the TNA system.

    17

    Workgroup

    30

    Optional. Places the employee in a particular workgroup, from the time/date entered above. You can use either the workgroup number, or the workgroup name (as set in the TNA Configuration module.)  If the workgroup does not exist then it will be created on the fly in the TNA system.

    18

    Job

    30

    Optional. Places the employee in a particular job, from the time/date entered above. You can use either the job number, or the job name (as set in the TNA Configuration module.)  If the job does not exist then it will be created on the fly in the TNA system.

    19

    Customer

    10

    Optional. Use this only if you are creating a new Job, via field 18 (above). If the job already exists (and is assigned to a customer) then this field is ignored.

    20

    Quantity

    10

    Optional. The quantity of items completed.

    21

    Reference

    10

    Optional. Anything you want. Not used by the TNA system, but can be included on reports.

    22

    Comment

    250

    Optional. Anything you want. Not used by the TNA system, but can be included on reports.

    23

    Clocking Type 1 Optional. The type of clocking imported e.g. use A for TNA clockings. The clocking types are:
    A - TNA
    B - Access
    C - TNA, Access
    D - Job
    E – TNA, Job
    F – Job, Access
    G – TNA, Job, Access
    H – Info
    I – Info, TNA
    J – Info, Access
    K – TNA, Info, Access
    L – Info, Job
    M – TNA, Info, Job
    O – TNA, Info, Job, Access
     
    • All fields can be entered with trailing spaces clipped, or with trailing spaces included.
    • Commas are not allowed in any fields.
    • Duplicate clockings are not imported. A clocking is a duplicate if it has the same Site, Employee Number (or Card Number), Date, Time and Direction as an existing clocking. In other words only one In, Out and Job clocking is allowed at the same time.
    • If the first column is blank, i.e. if the line starts with a   , then the line is ignored. This allows for comment records in the file.

    Data.txt Format

    This option is used to import clocking information from ASCII text files with each line representing one clocking and can be up to 33 characters long. The fields are in “fixed positions”, in other words each field starts at a set character position and has a set maximum number of characters with a comma between each field. Below is an example of an ASCII text file (Data.txt) showing clocking information.

     

    ImportDataTXT.jpg

     

    The information in the text file is laid out as follows:

    Clocking Information

    Start Character

    Length

    Clock Number

    3

    2

    Site Number

    6

    2

    Card Number

    10

    4

    Date (yy/mm/dd)

    17

    8

    Time (hh:mm)

    26

    5

    Direction ( O or I )

    32

    1

     
    • The gap between the Site Number and the Card Number field is currently not used.
    • If the clocking already exists then the imported clocking record is ignored, i.e. same employee at same device at the same time and date and also in the same direction.

    Importing Clocking Information

    To import clocking information from an ASCII text file, proceed as follows:

    1. Select the Clockings option from the File / Import dropdown menu and the Import Clockings window will be displayed.


    Clocking Import - 1.png

     

    1. Use the From File select button and select the path and ASCII file from which the clocking information is to be imported.


    Clocking Import - 2.png
     

    1. Use the Format radial buttons and select the type of clocking file format that is to be imported. The types of clocking information formats that can be imported are:
      1. Generic Format– this is a CS TimeGeneric Import format.
      2. Eco-Data.txt– this is a general CS Time clocking information file format (Data.txt).
      3. Infotime.txt– this is an Infotime clock format.
      4. iPatrol.dat– this is a Guard Log system clocking information file format.
      5. iClock.dat– this is an Ideal Timelog Clock format.
      6. Max ER-2000PC – this is a Max product file format.
      7. Thousand Series DB format - this is a database from a CS TimeClock.
      8. ZK Clocks USB - this is a ZK Clock (Attlog) file format.
      9. BRS BioScan – this is a BioScan file format.
      10. Identix FingerScan - this is a Identix file format.
      11. Clockings.Tps– this is the standard file format used by CS Time to save clockings.
      12. Wage Easy - this is a Wage Easy format.
      13. Hectrix ACTA-agent - this is a Hectrix (ACTATEK) format.
      14. Connex Vs 1.0 - this is the Connex file format.
      15. Hanvon USB - this is a Hanvon file format.
    2. If you are importing a CS TimeClock database you have the option to Re-import all clockings, including those marked as "collected".
    3. Click on the Start button to start the clocking import operation. A progress window will be displayed while the system imports the clocking information.

     

    Permalink:  http://tinyurl.com/6rpqag2

    Page last modified 16:42, 21 Jan 2015 by cay-lynne CS Time/TNA Documents > Importing Data > Clockings

    Comments0

    You must login to post a comment.
    Attach file

    Files4

    Powered by MindTouch Core