Knowledgebase
TimeTrack support > TimeTrack support > Knowledgebase

Search help:


Leave-Import

Solution
  1. Please make an excel file as per the attached format (Leave_Opening_Import.xls).
  2. Save it as an CSV file
  3. Open the menu Utilities -->  Emp Excel Import.
  4. Click New Option.
  5. A new window will open.
  6. Select the CSV file by clicking on the Arrow button and do Read Files
  7. Confirm that the shown information is correct.
  8. 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_Import.zip
Leave_Opening_Import.xls Leave_Opening_Import.xls
Leave_Opening_Import.csv 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): Article rated 4.6/5.0 (10)

 
« Go back