| Line 53: | Line 53: | ||
::03/11/2015,003,AL,1 | ::03/11/2015,003,AL,1 | ||
::08/11/2015,005,MC,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)<br /> | |||
:03. The data in "Net Figure" (eg. OT WorkUnitAsTime := Logout Time - Login Time)<br /> | |||
:04. There is no display format for Amount/Qty (eg 1600.12 not 1,600.12)<br /> | |||
:05. There is no extra spacing at the Begin & End of data (eg Tes1,Test2 not Tes1 , Tes2 ,)<br /> | |||
:06. If Data had spacing make sure use " " (eg "Nanoha Takamachi","Dept 1")<br /> | |||
:07. Date format should be in ''dd/mm/yyyy'' or ''dd-mm-yyyy''<br /> | |||
:::---------------------------------------------------------------------------------------------------------------------------------------------------- | :::---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
| Line 58: | Line 71: | ||
|- | |- | ||
| [[File:Template.Tips-01.jpg|60px]]|| '''Notes''' | | [[File:Template.Tips-01.jpg|60px]]|| '''Notes''' | ||
1 | 1. Output Can be in Tab, Semicolon or Comma<br /> | ||
2. Field can be added by just look in the field chooser.<br /> | |||
|} | |} | ||
:::---------------------------------------------------------------------------------------------------------------------------------------------------- | :::---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
Revision as of 09:29, 8 December 2015
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
- This guide is all import except UBS Payroll & AutoCount Payroll
- Just copy below example & paste to notepad & save it as CSV
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"
Example 4 - Leave
- TransDate,Employee,LeaveCode,LeaveDayAsTime
- 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
- ----------------------------------------------------------------------------------------------------------------------------------------------------
Notes 1. Output Can be in Tab, Semicolon or Comma
2. Field can be added by just look in the field chooser.
- ----------------------------------------------------------------------------------------------------------------------------------------------------
See also
- Others Customisation