Import Data: Difference between revisions

From eStream Software
Line 35: Line 35:
::"0019";"Nanoha Takamachi";"01/10/1995";"F";"2000"
::"0019";"Nanoha Takamachi";"01/10/1995";"F";"2000"
::"0020";"Belldandy";"01/09/1977";"F";"2500"
::"0020";"Belldandy";"01/09/1977";"F";"2500"
===Example 4 - Unpaid Leave===
TransDate,Employee,LeaveCode,LeaveDayAsTime
08/11/2015,001,UL,08:00
19/11/2015,003,UL,09:15
15/11/2015,005,UL,08:00


:::----------------------------------------------------------------------------------------------------------------------------------------------------
:::----------------------------------------------------------------------------------------------------------------------------------------------------

Revision as of 08:42, 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

  1. This guide is all import except UBS Payroll & AutoCount Payroll
  2. 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 - Unpaid Leave

TransDate,Employee,LeaveCode,LeaveDayAsTime 08/11/2015,001,UL,08:00 19/11/2015,003,UL,09:15 15/11/2015,005,UL,08:00

----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg Notes

1. The target db must had Valid

- Employee Code
- OT Code

2. Ouput 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 ,)

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