Knowledgebase
TimeTrack support
>
TimeTrack support
>
Knowledgebase
Search help:
Loading knowledgebase suggestions...
Leave-Import
Solution
Please make an excel file as per the attached format (Leave_Opening_Import.xls).
Save it as an CSV file
Open the menu
Utilities --> Emp Excel Import
.
Click
New Option
.
A new window will open.
Select the CSV file by clicking on the
Arrow button
and do
Read Files
Confirm that the shown information is correct.
Press
Update Data
to update the database.
Note: You can use CONCATENATE in MS-Excel to merge 2 columns.
CONCATENATE(A1,"-",B1) - merges A1 & B1 columns and addes a hyphen (-) between them
KeyWords: Leave-Import, Import-Leave, Leave Import, Import Leave
Attachments:
Leave_Import.zip
Leave_Opening_Import.xls
Leave_Opening_Import.csv
Was this article helpful?
yes
/
no
Related articles
Payroll Import - User Table Import - Basic Import
Shift Import
Leave Year April to March
Employee Master Import
CSV file (in Standard Reports) Not opening in excel.
Article details
Article ID:
6
Category:
Import-Data
Date added:
06/08/2012 02:25:39
Views:
919
Rating (Votes):
(10)
«
Go back