Skip to main content

Importing Absence Allowances from CSV

Efficiently manage absence allowances with the CSV importer. Ensure absence categories are set up, then use CSV templates to for updates.

Productive's CSV importer allows you to efficiently manage absence allowances.
​
Whether you're updating allowances for multiple users or managing their absence schedules, CSV import is a convenient solution.

Importing Absence Allowances

Before you begin importing absence allowances, it's important to ensure that all your absence categories are configured in Productive; otherwise, you won't be able to add allowances to your teams via CSV.

To import absence allowances for the team, go to Settings > Data import and select Download .csv templates.

Download the Absence allowances CSV template.

The file you download will contain the following columns:

Person

The user's full name (as used in the app).

Email

The user's email.

Time Off Category

The name of the absence category.

Start Date

The start date for the validity of the allocation.

Expiration Date

The last day the allocation is valid.

Allocated (Days)

The number of days allocated for the user.

Allocated (Hours)

The number of hours allocated for the user.

Description

Description of the absence allocation.

Uploading the Template and Fixing Errors

After completing the template, upload it:


1. Drag and drop the filled template into the upload box or manually upload it.

2. Productive will automatically check for errors. Any identified errors will be marked with a warning symbol (⚠️), which you can hover over to pinpoint specific problem areas.

3. You can edit data directly within the import pop-up to fix errors without saving and re-uploading the CSV file.

After making edits, select "Check for errors" to ensure a smooth import process.

Completing the Import

Once all errors have been resolved, proceed with the import by clicking "Proceed to import" and then "Import" on the subsequent screen.

After successful upload, review and tweak the imported data under the individual user's Absence tab in their profile.

Useful Tips​

  • Ensure that the date format in the CSV file is YYYY-MM-DD (or YYYY-M-D) to avoid parsing errors during the import.

  • Do not delete or remove any columns from the CSV file template. If certain fields are not applicable, such as a description or allowance in hours, simply leave those columns empty without deleting them. Maintaining the integrity of the template structure ensures smooth data import processes!

  • Take advantage of the inline editing feature to fix any errors in the imported file efficiently.

Use Case: Refreshing Yearly Allowances Using the CSV Import

As the end of the year approaches and you prepare for the upcoming year, updating allowances for the next year becomes essential. With CSV imports, you can easily refresh and update your yearly allowances.

Here's a simple process to streamline this task:

1) Generate Absence Allowances Report

Go to Reports, select From scratch, and choose the Absence allowances data source.

Select the period you need (for example, Start date = This year) and add the fields the upload needs: person, email, absence category, start date, expiration date, allowance (in days or hours), and description.

Download the report in CSV format.

2) Update the Absence Allowances CSV File

Open the downloaded report and check that its columns match the CSV template: person, email, time off category, start date, expiration date, allowance (in days or hours), and description. Matching columns save you manual adjustments.

Copy the data from the report into the CSV template.

3) Adjust Dates

Change the start and expiration dates in the CSV file to the upcoming year.

4) Import Updated Absence Allowances

Go to Settings > Data import and upload the updated CSV file. Productive updates the allowances for the next year.

Did this answer your question?