| Line 61: | Line 61: | ||
::- Employee Code | ::- Employee Code | ||
::- OT Code | ::- OT Code | ||
2. | ::- Leave Code | ||
2. Output Can be in Tab, Semicolon or Comma<br /> | |||
3. File extention must be in csv (e.g. OT.csv)<br /> | 3. File extention must be in csv (e.g. OT.csv)<br /> | ||
4. Field can be added by just look in the field chooser.<br /> | 4. Field can be added by just look in the field chooser.<br /> | ||
| Line 68: | Line 69: | ||
7. There is no extra spacing at the Begin & End of data (eg Tes1,Test2 not Tes1 , Tes2 ,)<br /> | 7. There is no extra spacing at the Begin & End of data (eg Tes1,Test2 not Tes1 , Tes2 ,)<br /> | ||
8. If Data had spacing make sure use " " (eg "Nanoha Takamachi","Dept 1") | 8. If Data had spacing make sure use " " (eg "Nanoha Takamachi","Dept 1") | ||
9. Date format should be in ''dd/mm/yyyy'' or ''dd-mm-yyyy'' | |||
|} | |} | ||
:::---------------------------------------------------------------------------------------------------------------------------------------------------- | :::---------------------------------------------------------------------------------------------------------------------------------------------------- | ||
==See also== | ==See also== | ||
* Others [[Customisation]] | * Others [[Customisation]] | ||
Revision as of 09:23, 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
- ----------------------------------------------------------------------------------------------------------------------------------------------------
Notes 1. The target db must had Valid
- - Employee Code
- - OT Code
- - Leave Code
2. Output 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 ,)
8. If Data had spacing make sure use " " (eg "Nanoha Takamachi","Dept 1") 9. Date format should be in dd/mm/yyyy or dd-mm-yyyy
- ----------------------------------------------------------------------------------------------------------------------------------------------------
See also
- Others Customisation