Others: Difference between revisions

Latest revision as of 06:23, 23 December 2015

File | Import Data...

Introduction

This function is to import Text file from Any Attendance System to SQL Payroll.
For example text file may refer to Import_Data#Guideline_.26_Example

Type Information/Data Import

Pending Overtime
Pending Deduction
Leave Application
Pending Wages
Pending Unpaid Leave

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

Notes

Different Attendance Software had different availability of Data Import

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

Steps

Below example is import Pending Overtime & is applicable for other Attendance System

1. Click File | Import Data | <Select the Time Attendance> (eg ELID, SynGlobal Time Attendance, etc)

2. Click the 3 Dot Button to Open

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).

Field	Properties
Delete Button	To delete the selected record(s).

3. Click Next

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.

5. Click Ok

@@ Line 8: / Line 8: @@
 # Pending Deduction
 # Leave Application
+# Pending Wages
+# Pending Unpaid Leave
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
+::::{|
+|-
+| [[File:Template.Tips-01.jpg|60px]]|| '''Notes'''
+:Different Attendance Software had different availability of Data Import
+|}
+:::----------------------------------------------------------------------------------------------------------------------------------------------------
 ==Steps==
-Below example is using ELID & is applicable for other Attendance System<br />
+Below example is import ''Pending Overtime'' & is applicable for other Attendance System<br />
-#Click File | Import Data | ELID
+:1. Click File | Import Data | <Select the Time Attendance> (eg ELID, SynGlobal Time Attendance, etc)
-::[[File:File.Import.Elid.Fig01.jpg]]
+[[File:File.Import.Elid.Fig01.jpg|center]]
 :2. Click the 3 Dot Button to Open
-::[[File:File.Import.Elid.Fig02A.jpg]]
+[[File:File.Import.Elid.Fig02A.jpg|center]]
-::{| class="wikitable"
+{| class="wikitable" style="margin: 1em auto 1em auto;"
 |-
 ! Field !! Properties
@@ Line 30: / Line 40: @@
 | Manage Setting Button || For Delete the saved Setting created/saved on last import from Database (See below picture).
 |}
-::[[File:File.Import.Elid.Fig02B.jpg]]
+[[File:File.Import.Elid.Fig02B.jpg|center]]
-::{| class="wikitable"
+{| class="wikitable" style="margin: 1em auto 1em auto;"
 |-
 ! Field !! Properties
@@ Line 38: / Line 48: @@
 |}
 :3. Click Next<br>
-::[[File:File.Import.Elid.Fig03.jpg]]
+[[File:File.Import.Elid.Fig03.jpg|center]]
-::[[File:File.Import.Elid.Fig04.jpg]]
+[[File:File.Import.Elid.Fig04.jpg|center]]
-::{| class="wikitable"
+{| class="wikitable" style="margin: 1em auto 1em auto;"
 |-
 ! Fields !! Properties
@@ Line 57: / Line 67: @@
 :4. Click Finish button after finish select & Map all the fields.<br>
-::[[File:File.Import.Elid.Fig05.jpg]]
+[[File:File.Import.Elid.Fig05.jpg|center]]
 :5. Click Ok<br>
-::[[File:File.Import.Elid.Fig06.jpg]]
+[[File:File.Import.Elid.Fig06.jpg|center]]
 ==See also==
-# [[Import_Data]]
+* [[Import_Data]]