ERP Labz Import Employee Timesheet

ERP Labz Import Employee Timesheet is a powerful Odoo module that allows you to import employee timesheet entries from CSV or Excel files into Odoo. This module simplifies the process of bulk importing timesheet data, making it easy to manage employee work hours and project tracking.

Key Features

• CSV Import: Import timesheets from CSV files with customizable delimiters
• Excel Import: Import timesheets from Excel (XLSX) files
• Flexible Field Mapping: Supports multiple field name variations
• Employee Management: Automatically links timesheets to employees
• Project & Task Support: Link timesheets to projects and tasks
• Date Format Flexibility: Supports multiple date formats (YYYY-MM-DD, DD/MM/YYYY, etc.)
• Error Handling: Detailed error logging for failed imports
• Import Logs: Track all import operations with success/failure statistics
• Header Detection: Automatic detection of header row in files
• Multiple Encoding Support: Supports UTF-8, Latin-1, and Windows-1252 encodings
• User-Friendly Interface: Easy-to-use wizard for importing timesheets

Supported Fields

The module supports importing the following timesheet fields:

Field Name	Alternative Names	Required	Description
Employee	Employee Name, employee_name, user, User, user_name, User Name	Yes	Employee name or user name
Project	Project Name, project_name, project	No	Project name to link timesheet to
Task	Task Name, task_name, task	No	Task name to link timesheet to
Date	Timesheet Date, date, timesheet_date	Yes	Date of the timesheet entry
Hours	Unit Amount, unit_amount, Time, time, Duration, duration	Yes	Number of hours worked
Description	Name, name, Comment, comment, Note, note	No	Description of work performed

Date Formats Supported

• YYYY-MM-DD (e.g., 2024-01-15)
• DD/MM/YYYY (e.g., 15/01/2024)
• MM/DD/YYYY (e.g., 01/15/2024)
• DD-MM-YYYY (e.g., 15-01-2024)
• YYYY/MM/DD (e.g., 2024/01/15)
• DD.MM.YYYY (e.g., 15.01.2024)

How to Use

1. Install the module from Apps menu
2. Go to Timesheets → Import Timesheet
3. Click Import Timesheet button
4. In the wizard:
   • Upload your CSV or Excel file
   • Select the file type (CSV or Excel)
   • Check "First row is header" if your file has headers
   • For CSV files, specify the delimiter (comma, semicolon, tab, etc.)
5. Click Import button
6. Review the import results and check the import log for any errors

File Format Example

CSV Format:

Employee,Project,Task,Date,Hours,Description
John Doe,Website Development,Frontend Development,2024-01-15,8.0,Worked on user interface
Jane Smith,Website Development,Backend Development,2024-01-15,7.5,API development
John Doe,Website Development,Testing,2024-01-16,6.0,Unit testing
        

Excel Format:

Excel files should follow the same structure with the first row containing column headers.

Import Options

• First row is header: Check this if your file's first row contains column names.
• CSV Delimiter: Specify the delimiter used in your CSV file (comma, semicolon, tab, space).

Import Logs

All import operations are logged with detailed information including:

• Total number of records processed
• Number of successful imports
• Number of failed imports
• Detailed error messages for failed records
• Import date and user information

You can view import logs at Timesheets → Import Logs

Technical Details

• Module Name: erpl_import_emp_timesheet
• Dependencies: base, hr_timesheet, project
• License: LGPL-3
• Category: Human Resources/Timesheet

Requirements

For Excel file support, you need to install the xlrd library:

pip install xlrd

Support

For support, feature requests, or bug reports, please visit our website:
Website: https://www.erplabz.com

Author Information

Author: ERP Labz
Company: ERP Labz
Maintainer: ERP Labz
Website: https://www.erplabz.com