Line 50: | Line 50: | ||
| align="center" |'''Remarks''' | | align="center" |'''Remarks''' | ||
|- | |- | ||
| Date || Date || 0 || || In dd/ | | Date || Date || 0 || || In dd/mm/yyyy or dd-mm-yyyy format | ||
|- | |- | ||
| Employee || String || | | Employee || String || 30 || Example || Employee Code/ID | ||
|- | |- | ||
| Code || String || | | Code || String || 20 || Example || Overtime Code | ||
|- | |- | ||
| Unit || FMTBcd|| 8 || Example || Example | | Unit || FMTBcd|| 8 || Example || Example |
Revision as of 08:32, 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 |
Example 2 - OT |
---|
"Date","Employee","Code","Unit" |
Table Fields Properties | ||||
---|---|---|---|---|
Field Name | Field Type | Field Size | Default Value | Remarks |
Date | Date | 0 | In dd/mm/yyyy or dd-mm-yyyy format | |
Employee | String | 30 | Example | Employee Code/ID |
Code | String | 20 | Example | Overtime Code |
Unit | FMTBcd | 8 | Example | Example |
UnitAsTime | Time | Example | Example | Example |
Leave
Example 1 - Leave |
---|
TransDate,Employee,LeaveCode,UnitAsTime |
Example 2 - Leave |
---|
TransDate,Employee,LeaveCode,Unit |
Employee
Employee |
---|
"Code";"Name";"DOB";"Gender";"Salary" |
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)
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- ----------------------------------------------------------------------------------------------------------------------------------------------------
- Need assistance? May email to support@sql.com.my
See also
- Others Customisation