(→Steps) |
(→Steps) |
||
| Line 23: | Line 23: | ||
:1. Click File | Import Data | <Select the Time Attendance> (eg ELID, SynGlobal Time Attendance, etc) | :1. Click File | Import Data | <Select the Time Attendance> (eg ELID, SynGlobal Time Attendance, etc) | ||
[[File:File.Import.Elid.Fig01.jpg|Center]] | |||
:2. Click the 3 Dot Button to Open | :2. Click the 3 Dot Button to Open | ||
[[File:File.Import.Elid.Fig02A.jpg|Center]] | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |- | ||
! Field !! Properties | ! Field !! Properties | ||
| Line 40: | Line 40: | ||
| Manage Setting Button || For Delete the saved Setting created/saved on last import from Database (See below picture). | | Manage Setting Button || For Delete the saved Setting created/saved on last import from Database (See below picture). | ||
|} | |} | ||
[[File:File.Import.Elid.Fig02B.jpg|Center]] | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |- | ||
! Field !! Properties | ! Field !! Properties | ||
| Line 48: | Line 48: | ||
|} | |} | ||
:3. Click Next<br> | :3. Click Next<br> | ||
[[File:File.Import.Elid.Fig03.jpg|Center]] | |||
[[File:File.Import.Elid.Fig04.jpg|Center]] | |||
{| class="wikitable" style="margin: 1em auto 1em auto;" | |||
|- | |- | ||
! Fields !! Properties | ! Fields !! Properties | ||
| Line 67: | Line 67: | ||
:4. Click Finish button after finish select & Map all the fields.<br> | :4. Click Finish button after finish select & Map all the fields.<br> | ||
[[File:File.Import.Elid.Fig05.jpg|Center]] | |||
:5. Click Ok<br> | :5. Click Ok<br> | ||
[[File:File.Import.Elid.Fig06.jpg|Center]] | |||
==See also== | ==See also== | ||
* [[Import_Data]] | * [[Import_Data]] | ||
Revision as of 06:21, 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
