Introduction
This function is to import Information/Data from other Software Data
Below is the list Data that we can Import from
Special Import
Standard Import
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
ExpandTable Fields Properties |
---|
Leave
ExpandTable Fields Properties |
---|
Employee
ExpandEmployee |
---|
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. Must 1 Transaction type 1 file (i.e. Overtime 1 file & Leave 1 file)
- 08. The output can be export out in Day or Time but not both in same time
- 09. Make sure only export out relevant data (eg if OT = 0 or No leave taken don't export out)
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- Need assistance? May email to support@sql.com.my
See also
- Others Customisation