CS Time/TNA Documents

username password

Authorised Hours

    This option is used to import auhorised hours from an ASCII text file and is available from version 20.04.15.00 onwards.

    Hours are imported to the authorised hours columns and will be authorised from the hours available in the unauthorised columns

     

    CONTENT

    Import Formats

    Generic Format

    The Eco Time Generic Import Format is a CSV (Comma Separated) format where each line represents separate hierarchy information.

     

    The format used is as follows:

    Field

    Name

    Max Length (Chars)

    Description

    1

    Record Type

    1

    DAUTH for Daily Authorisation (import type identification).

    2

    Site

    4

    Optional. Usually left blank. If blank then the site defaults to 'Here'

    3

    Emp Number

    10  
    4 Date 10 Required.  dd/mm/yyyy
    5 Rate Code 2 Sets the speficic rate. If left blank it defaults to 1.
    6 Hours1 hh:mm Hours specified in this filed will be authorised towards category 1
    7 Hours2 hh:mm Hours specified in this filed will be authorised towards category 2
    8 Hours3 hh:mm Hours specified in this filed will be authorised towards category 3
    9 Hours4 hh:mm Hours specified in this filed will be authorised towards category 4
    10 Hours5 hh:mm Hours specified in this filed will be authorised towards category 5
    11 Hours6 hh:mm Hours specified in this filed will be authorised towards category 6
    12 Hours7 hh:mm Hours specified in this filed will be authorised towards category 7
    13 Hours8 hh:mm Hours specified in this filed will be authorised towards category 8
    14 Hours9 hh:mm Hours specified in this filed will be authorised towards category 9
    15 Hours10 hh:mm Hours specified in this filed will be authorised towards category 10
    16 Hours11 hh:mm Hours specified in this filed will be authorised towards category 11
    17 Hours12 hh:mm Hours specified in this filed will be authorised towards category 12
    18 Hours13 hh:mm Hours specified in this filed will be authorised towards category 13
    19 Hours14 hh:mm Hours specified in this filed will be authorised towards category 14
    20 Hours15 hh:mm Hours specified in this filed will be authorised towards category 15
    21 Hours16 hh:mm Hours specified in this filed will be authorised towards category 16
    22 Hours17 hh:mm Hours specified in this filed will be authorised towards category 17
    23 Hours18 hh:mm Hours specified in this filed will be authorised towards category 18
    24 Hours19 hh:mm Hours specified in this filed will be authorised towards category 19
    25 Hours20 hh:mm Hours specified in this filed will be authorised towards category 20
    26 Hours21 hh:mm Hours specified in this filed will be authorised towards category 21
    27 Hours22 hh:mm Hours specified in this filed will be authorised towards category 22
    28 Hours23 hh:mm Hours specified in this filed will be authorised towards category 23
    29 Hours24 hh:mm Hours specified in this filed will be authorised towards category 24
    30 Hours25 hh:mm Hours specified in this filed will be authorised towards category 25
    31 Comment 1024 Optional. Enter a comment regarding the authorised record being imported.
     
     

      

    Importing Authorised Hours Information

    Edit section

    To import hierarchy information, proceed as follows:

    1. Select the Clockings Tab
    2. Now select the Bulk Import icon and the Import Clockings window will be displayed.


    BulkImport Image
     

    1. Use the From File select button and select the path and file from which the hierarchy information is to be imported.
    2. Select Generic Format.
    3. Click on the Start button to start the import operation. A progress window will be displayed while the system imports the information.
    Page last modified 15:08, 20 Apr 2020 by Admin CS Time/TNA Documents > Importing Data > Authorised Hours

    Comments0

    You must login to post a comment.
    Attach file

    Files1

    FileSizeDateAttached by 
     BulkImport.png
    No description
    20.47 kB11:58, 20 Apr 2020cay-lynneActions
    Powered by MindTouch Core