How to Bulk Import (Projects, Tasks, Assignments)

Nov 20, 2024

Overview:

HRStop provides powerful bulk import capabilities that simplify large-scale data entry. Whether onboarding new teams, launching multiple projects, or managing department shifts, importing via CSV saves time and ensures accuracy.


Scenarios Supported:

You can bulk import the following:

Use CaseImport Location
ProjectsTimesheet > Manage Project > Import Projects
Project TasksTimesheet > Project Task > Import Tasks
Project AssignmentsTimesheet > Assign Project > Import Assignments

Common Steps for All Imports:

1. Click the Relevant “Import” Option

  • Navigate to the specific section (e.g., Assign Project).
  • Click Import (usually at the top-right corner).

2. Download the Sample CSV File

  • Click “Download Sample File” to ensure correct column headers and formats.

3. Fill In the CSV File

Each type of import has slightly different fields:


A. Importing Projects

FieldDescription
Project NameUnique project name.
Project CodeInternal reference.
Start Date / End DateIn YYYY-MM-DD format.
StatusActive / Closed
Billable / Non-billable Resource CountNumbers only.
ClientMust match existing client name.
ModulesTimesheet / Expense or both.

B. Importing Project Tasks

FieldDescription
Task NameName of the task (e.g., Testing, UI Design).
DescriptionDetails about the task.
ProjectThe name of the project this task belongs to.
Department
Department responsible for this task.

C. Importing Project Assignments

FieldDescription
Employee Email/IDMust match employee profile in HRStop.
Project NameExact name of the assigned project.
BillableYes / No

4. Upload the File

  • Use the Choose File button.
  • Upload the CSV to HRStop.

5. Review the Upload

  • The system will show a preview of valid and invalid rows.
  • Fix any issues (like typos or mismatches) and re-upload if needed.

6. Click “Import”

  • Once validated, click Import to apply all data entries to the system.

Best Practices:

  • Double-check spellings and casing (e.g., “ClientABC” vs “clientabc”).
  • Save a copy of all uploaded files for audit.
  • Use a master Excel sheet to consolidate before breaking into multiple CSVs for each import type.