Import a CSV file

Instructions

  1. Prepare your CSV file with the following format:
    "id";"idthemes";"number";"titlefr";"titleen";"author";"summary";"status";"date";"online";"datereport";"filekey"
  2. Make sure the PDF files are placed in the /import/etudes/ folder at the root of WordPress
  3. Files must contain the filekey in their name (e.g., SCORE-2012-01-synthfr-8q01apo9cm-1.pdf)
  4. Sélectionnez votre fichier CSV et cliquez sur "Importer"

Field mapping

  • number → Study No.
  • titlefr → Title (FR)
  • titleen → Title (EN)
  • author → Authors (taxonomy)
  • summary → Description
  • status + online → Visibility status
  • date → Completion date
  • filekey → Key to associate PDF files

Visibility rules

  • status = 1 → Draft in progress
  • status = 2 + online = 0 → Members
  • status = 2 + online = 1 → Public
Accepted format: CSV with semicolon (;) separator

Import keywords

Instructions

  1. Prepare your CSV file with the following format:
    N° étude;Intitulé;mots-clés 1;mots-clés 2;mots-clés 3;mots-clés 4;mots-clés 5;mots-clés 6;keyword 1;keyword 2;keyword 3;keyword 4;keyword 5;keyword 6
  2. The file must contain 14 columns separated by semicolons
  3. Studies will be found by their Study No.
  4. All FR and EN keywords will be concatenated and separated by commas

Example row

2012-01;Analyse du Cycle de Vie Conséquentielle;Conséquentiel - ACV-C;Note unique - Score unique;Décision;;;;Consequential - C-LCA;Single Score;Decision;;

Column mappings

  • Colonne 1 → Study No. (to find the study)
  • Colonne 2 → Title (information only)
  • Colonnes 3-8 → Keywords in French
  • Colonnes 9-14 → Keywords in English
Accepted format: CSV with semicolon separator (;) and 14 columns

Studies without keywords

3 study/studies without keywords found:

Study No. Title Actions
2025-04B ACV prospective - partie B : Elaboration de données ICV permettant la réalisation d’ACV prospectives Edit
WS 44 Derniers développements de GLAM Edit
WS 48 Prise en compte des pollutions microplastiques et nano plastiques (et autres nouveaux polluants) en ACV Edit