Import Data: Difference between revisions

From eStream Software
Line 108: Line 108:
:05. There is no extra spacing at the Begin & End of data (eg Tes1,Test2 not Tes1  , Tes2 ,)<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 />
: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 />
:07. Must 1 Transaction type 1 file (i.e. Overtime 1 file & Leave 1 file)
:08. '''UnitAsTime''' format should be in ''hh:mm''
:08. The output can be export out in Day or Time but not both in same time
:09. Must 1 Transaction type 1 file (i.e. Overtime 1 file & Leave 1 file)
:09. Make sure only export out relevant data (eg if OT = 0 or No leave taken don't export out)
: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)





Revision as of 08:50, 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
26/6/2010,A001,DR01,04:00
28/6/2010,A001,DR02,09:38
26/6/2010,A002,DR02,06:18
29/6/2010,A002,DR03,03:22
26/6/2010,A003,DR03,04:55

Example 2 - OT

"Date","Employee","Code","Unit"
07/01/2015,"001","DR10",1
07/01/2015,"002","DR10",1
17/01/2015,"002","DR05",1
07/01/2015,"003","DR10",1
07/01/2015,"004","DR05",2
07/01/2015,"005","DR05",2

Table Fields Properties
Field Name Field Type Field Size Remarks
Date Date 0 In dd/mm/yyyy or dd-mm-yyyy format
Employee String 30 Employee Code/ID
Code String 20 Overtime Code
Unit FMTBcd 8 Time in rate eg 3 hr 15 min = 3.25 (3 + 15/60)
UnitAsTime Time 0 In HH:MM format

Leave

Example 1 - Leave

TransDate,Employee,LeaveCode,UnitAsTime
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 2 - 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

Employee

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"

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)


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

1. Output Can be in Tab, Semicolon or Comma.
2. Field can be added by just look in the field chooser in Pending Payroll.

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


  • Need assistance? May email to support@sql.com.my

See also