ELID: Difference between revisions

From eStream Software
No edit summary
No edit summary
Line 2: Line 2:
==Introduction==
==Introduction==
This function is to import Text file from ELID Attendance System to SQL Payroll
This function is to import Text file from ELID Attendance System to SQL Payroll
==Guideline & Example==
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"
:::----------------------------------------------------------------------------------------------------------------------------------------------------
::::{|
|-
| [[File:Template.Tips-01.jpg|60px]]|| '''Notes'''
1. The target db must had Valid
::- Employee Code
::- OT Code
2. Ouput Can be in Tab, Semicolon or Comma<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 />
5. The data in "Net Figure" (eg. OT WorkUnitAsTime := Logout Time - Login Time)<br />
6. There is no display format for Amount/Qty (eg 1600.12 not 1,600.12)<br />
7. There is no extra spacing at the Begin & End of data (eg Tes1,Test2 not Tes1  , Tes2 ,)<br />
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------


==Type Information/Data Import==  
==Type Information/Data Import==  

Revision as of 00:44, 26 August 2015

File | Import Data... | ELID

Introduction

This function is to import Text file from ELID Attendance System to SQL Payroll

Type Information/Data Import

  1. Pending Overtime
  2. Pending Deduction
  3. Leave Application

Steps

  1. Click File | Import Data | ELID
File.Import.Elid.Fig01.jpg
2. Click the 3 Dot Button to Open
File.Import.Elid.Fig02A.jpg
Field Properties
Data From Is the path for the CSV file to be import.
New Setting... Create New Setting for New Import.
Load Setting... Use the saved Setting created/saved on last import from Database.
Load From File... Use the saved Setting created/saved on last import from External XML File.
Manage Setting Button For Delete the saved Setting created/saved on last import from Database (See below picture).
File.Import.Elid.Fig02B.jpg
Field Properties
Delete Button To delete the selected record(s).
3. Click Next
File.Import.Elid.Fig03.jpg
File.Import.Elid.Fig04.jpg
Fields Properties
Description Setting Name.
Save button Save the current setting for future use.
From row From which row number in the CSV file start to import.
Separator Options Type of separator in the CSV file.
Fields Which Column To Map and Import.
4. Click Finish button after finish select & Map all the fields.
File.Import.Elid.Fig05.jpg
5. Click Ok
File.Import.Elid.Fig06.jpg
Retrieved from "https://wiki.sql.com.my/index.php?title=ELID&oldid=1172"
Last modified
This page was last edited on 26 August 2015, at 00:44.