2.07 ***Import Format - Example - RG-00364***

Example 1 - OT

Date,Employee,Code,WorkUnitAsTime

26/6/2010,A001,DR01,04:00

28/6/2010,A001,DR01,09:38

26/6/2010,A002,DR02,06:18

29/6/2010,A002,DR02,03:22

26/6/2010,A003,DR03,04:55

Example 2 - OT

"Date","Employee","OT","Unit"

07/01/08,"001","DR10",1

07/01/08,"002","DR10",1

07/01/08,"003","DR10",1

07/01/08,"004","DR05",2

07/01/08,"005","DR05",2

Example 3 - Employee

"Code";"Name";"DOB";"Gender";"Salary"

"0018";"Shiro Emiya";"14/06/1980";"M";"1200"

"0019";"Nanoha Takamachi";"01/10/1995";"F";"2000"

"0020";"Belldandy";"01/09/1977";"F";"2500"

NOTE :

1. The target db must had Valid

- Employee Code

- OT Code

2. Ouput Can be in Tab, Semicolon or Comma

3. File extention must be in csv (e.g. OT.csv)

4. Field can be added by just look in the field chooser.

5. The data in "Net Figure" (eg. OT WorkUnitAsTime := Logout Time - Login Time)

6. There is no display format for Amount/Qty (eg 1600.12 not 1,600.12)

7. There is no extra spacing at the Begin & End of data (eg Tes1,Test2 not Tes1 , Tes2 ,)