CS Time/TNA Documents

username password

Jobs

    This option is used to import job information from an ASCII text file.

     

    CONTENT

    Import Job Formats

    CS Time Generic Format

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

    The main advantage of CS Time Generic Format is that it can also be used to import other information other than jobs. 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 Rostering and so on.

     

    ImportJobs.jpg

     

    The format used is as follows:

    Field

    Name

    Max Length (Chars)

    Description

    1

    Record Type

    1

    J for Job (import type identification).

    2

    Job Code

    10

    Required. Usually a numeric code used to identify the job.

    3

    Description

    30

    Optional. The description of the job.

    4

    Open Date

    10

    Required.  The date on which the job starts. (dd/mm/yyyy)

    5

    Expected Finish Date

    10

    Optional. The date when the job is expected to finish. (dd/mm/yyyy)

    6

    Finished Date

    10

    Optional. The actual finished date. (dd/mm/yyyy)

    7

    Closed Date

    10

    Optional. The date on which the job is closed.
    (dd/mm/yyyy)

    8

    Status

    1

    Optional. 0 = open, 1 = finished, 2 = closed

    9 Expected Cost 11 Optional. The expected cost of the job. Maximum value of 99999999.99.
    10 Actual Cost 11 Optional. The actual cost of the job. Maximum value of 99999999.99.
    11 Unit 10 Optional. The expected number of units.
    12 Expected Quantity 11 Optional. The expected quantity. Maximum value of  9999999.999.
    13 Actual Quantity 11 Optional. The actual quantity. Maximum value of  9999999.999.
    14 Customer 10 Optional. The customer code.
    15 Order Numer 20 Optional. The order number.
    16 Comment 1024 Optional. Any comment related to the job.
    17 Job number 4 Required.  The code that will be used to identify the job on the clock.
     

    Importing Job Information

    To import jobs using the CS Time Import option, proceed as follows:

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


    Job Import - 1.png
     

    1. Use the From File select button and select the path and file from which the job 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.

     

    Permalink:  http://tinyurl.com/btwd2be

    Page last modified 15:16, 17 Mar 2014 by cay-lynne CS Time/TNA Documents > Importing Data > Jobs

    Comments0

    You must login to post a comment.
    Attach file

    Files2

    Powered by MindTouch Core