(Created page with "''File | Import Data... '' ==Introduction== This function is to import Text file from Any Attendance System to SQL Payroll. <br /> For example may refer to Import_Data#Guide...") |
No edit summary |
||
| Line 2: | Line 2: | ||
==Introduction== | ==Introduction== | ||
This function is to import Text file from Any Attendance System to SQL Payroll. <br /> | This function is to import Text file from Any Attendance System to SQL Payroll. <br /> | ||
For example may refer to [[Import_Data#Guideline_.26_Example]] | For example text file may refer to [[Import_Data#Guideline_.26_Example]] | ||
==Type Information/Data Import== | ==Type Information/Data Import== | ||
| Line 10: | Line 10: | ||
==Steps== | ==Steps== | ||
Below example is using ELID & is applicable for other Attendance System<br /> | |||
#Click File | Import Data | ELID | #Click File | Import Data | ELID | ||
::[[File:File.Import.Elid.Fig01.jpg]] | ::[[File:File.Import.Elid.Fig01.jpg]] | ||
Revision as of 01:00, 26 August 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
Steps
Below example is using ELID & is applicable for other Attendance System
- Click File | Import Data | ELID
- 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
