Import Data: Difference between revisions

Revision as of 07:19, 12 January 2016

Introduction

This function is to import Information/Data from other Software Data
Below is the list Data that we can Import from

Modules Require

For all import except UBS Payroll & AutoCount Payroll

Data Import

Guideline & Example

01. This guide is all import except UBS Payroll & AutoCount Payroll

02. Just copy below example & paste to notepad & save it as CSV

Overtime

Example 1 - OT
Date,Employee,Code,UnitAsTime 26/6/2010,A001,DR01,04:00 28/6/2010,A001,DR02,09:38 26/6/2010,A002,DR02,06:18 29/6/2010,A002,DR03,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 17/01/08,"002","DR05",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"

Example 4 - Leave

TransDate,Employee,LeaveCode,UnitAsTime

08/11/2015,001,UL,08:00

19/11/2015,003,UL,09:20

15/11/2015,005,UL,08:00

01/11/2015,001,AL,08:00

03/11/2015,003,AL,08:00

08/11/2015,005,MC,08:00

Example 5 - Leave

TransDate,Employee,LeaveCode,Unit

08/11/2015,001,UL,1

19/11/2015,003,UL,1.17

15/11/2015,005,UL,1

01/11/2015,001,AL,1

03/11/2015,003,AL,1

08/11/2015,005,MC,1

Things To Consider

01. The target database must had Valid

- Employee Code

- OT Code

- Leave Code

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

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

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

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

06. If Data had spacing make sure use " " (eg "Nanoha Takamachi","Dept 1")

07. Date format should be in dd/mm/yyyy or dd-mm-yyyy

08. UnitAsTime format should be in hh:mm

09. Must 1 Transaction type 1 file (i.e. Overtime 1 file & Leave 1 file)

10. The output can be export out in Day or Time but not both in same time

11. Make sure only export out relevant data (eg if OT = 0 or No leave taken don't export out)

----------------------------------------------------------------------------------------------------------------------------------------------------

Notes

1. Output Can be in Tab, Semicolon or Comma.
2. Field can be added by just look in the field chooser in Pending Payroll.