Recruitee

On Javelo, it is possible to create training manually but also massively using an Excel file that will allow you to import all your training on the platform.

⚠️ This feature can only be used to create trainings and not to edit them. If you export formations for editing and then re-import them, it will create duplicates. The Javelo platform should only be used for any training changes.

Access to import training on the admin side

If you have an HR admin role, you need to go to the Development menu and then click the Trainings tab.

Then on the top right, click Import Trainings.

On this page, you will find an Excel sample file to complete as well as rules so that your import can be done at its best.

Here is a summary of the columns contained in the Excel file:

Owner: email or employee ID of the training requester (mandatory)

- Empty (will then be considered as New)
- new (new request)
- approved (approved by the manager)
- unapproved (rejected by the manager)
- hold_on (on hold)
- accepted (accepted by the HR team)
- declined (refused by the HR team)
- not_done (not completed)
- done (completed)

Priority can be empty or must be a value between 1 and 4

Mandatory can be empty or must have a value YES or NO

External_id can be empty or must be a string of characters or numbers

end_date must be in the format DD/MM/YYYY

- Owner: email or employee ID of the training requester (mandatory)
- Title: Title of the training (mandatory)
- Status:
  - Empty (will then be considered as New)
  - new (new request)
  - approved (approved by the manager)
  - unapproved (rejected by the manager)
  - hold_on (on hold)
  - accepted (accepted by the HR team)
  - declined (refused by the HR team)
  - not_done (not completed)
  - done (completed)
- Priority can be empty or must be a value between 1 and 4
- Mandatory can be empty or must have a value YES or NO
- External_id can be empty or must be a string of characters or numbers
- end_date must be in the format DD/MM/YYYY

To complete this file correctly, here is a reminder of rules:

Only the owner and title columns must be present

end_date and certifying are mandatory when the status is done

If a training request is in error, the import is canceled

- The file must not exceed 15Mb
- Only the owner and title columns must be present
- end_date and certifying are mandatory when the status is done
- If a training request is in error, the import is canceled

Once the file is verified and completed, you can drag it into the import insert or upload it from your computer and click Import Trainings.

Once the file is integrated, you will receive by email a report of the action:

<b>Case 1:</b> The import worked correctly and shows the number of trainings created on the platform

<b>Case 2</b>: The import failed. A file attached to the email will allow you to find all the changes to be made before starting again.