How to import a certification repository

Introduction

This guide explains how to import a new certification repository into your DoYouBuzz Showcase application.

Prepare Your Import File

Two import formats are available:

  • A CSV file
  • A ZIP file containing:
    • The CSV file
    • Certification images/logos

☝️ If your resume template includes logos for certifications, we recommend using a .zip file import.

CSV File Structure

The CSV file must contain column headers, and columns should be separated by commas. An example .csv file is available for download from the import page of your application.

Column Name Required Format Description
id yes text Unique identifier for the category or certification. If it's a new repository, these IDs will be converted to another format by the application, but relationships will be maintained.
name yes text Name of the category or certification.
type yes category | model category : the row corresponds to a category. model : the row corresponds to a certification.
category_id no text Category in which the certification is classified (applicable only if the row describes a certification).
logo_path no text Name of the file used for the logo (works only if you're using a .zip; URL format does not work).
name_en_US no text Name of the English translation (1).
has_mandatory_end_date no 0 | 1 Indicates whether the certification end date must be filled in by the consultant when entering their resume.

About Translations

If you've activated your resumes in other languages, additional translation options for certifications will be available.

You can translate the names of categories and certifications into all languages activated in your resumes. The column name will be name_[locale] . Example: name_es_ES .

ZIP File Structure

If you want to import logos as well, create a zip file containing:

  • The CSV file, with the logo_path field filled in for certifications with logos.
  • Images, with a maximum size of 300x300 pixels.

Ensure the zip file does not contain directories: all data (the .csv file and images) should be at the root level in the file.

How to create a zip with files at the root level

Import Procedure

  1. Access the management page of your certification repository.
  2. Click the "Import" button.
  3. Select your file:
    • Either the CSV file alone.
    • Or the ZIP file containing the CSV and images.
  4. Confirm the import.

Import Behavior

During the import:

  • If an ID is provided and matches an existing certification: the certification will be updated (same for categories).
  • If no ID is provided or if the ID doesn't match: a new certification will be created (same for categories).

If you want to update your repository, first export your current repository using the "Export" button to obtain the correct IDs.

After the Import

Once the import is complete:

  • Verify that all your certifications appear correctly.
  • You can reorganize the order of categories and certifications if necessary.
  • In case of updates, changes will be automatically synchronized with existing resumes

Last updated on January 7, 2025