Project

General

Profile

Actions

Feature #2606

closed

Handling unnecessary white spaces in CSV imports

Added by Enric Rodellas 4 months ago. Updated 4 months ago.

Status:
Closed
Priority:
Normal
Category:
Data import/export
Target version:
Start date:
2025-08-28
Estimated time:

Description

Update
It turned out to be a white-space problem with imports. We used this opportunity to handle these cases automatically (removing the unneeded white-spaces) to make imports less error prone.

Original text
I'm very sorry Bernhard. I have to import 600 biblio items from zotero and I have prepared a very basic CSV and only I get 'Error at import' and I'm not able to find where the fault is (openatlas version 8.13 > ... Import Bibliography). Very grateful for your help.

id,name,description,type_ids
RieraMelisA-2015,"RieraMelisA-2015 Mercat i regulació: inspecció","Antoni Riera i Melis, /Mercat i regulació: inspecció, controls de qualitat i defensa dels consumidors als mercats medievals ibèrics/, in El Mercat de Balaguer: una cruïlla, ed. by Flocel Sabaté, Ajuntament de Balaguer (Balaguer, 2015), pp. 63-79",2
RieraMelisA-1980,"RieraMelisA-1980 La Lezda de Colliure bajo la administración mallorquina","Antoni Riera i Melis, /La Lezda de Colliure bajo la administración mallorquina. I: La reforma de aranceles de finales del siglo XIII (1299?)/, Acta historica et archaeologica mediaevalia, no. 1 (1980), pp. 91-126",3
RieraMelisA-2021,"RieraMelisA-2021 Alimentación, Sociedad, Cultura y Política", "Antoni Riera i Melis, Alimentación, Sociedad, Cultura y Política En El Occidente Medieval, Primera edición (Ediciones Trea, 2021)",4

where type_ids in my DB (from initdb) are:
  • 2 >> Inbook
  • 3 >> Article
  • 4 >> Book

Files

BIBLIOGRAPHY-imports.csv (884 Bytes) BIBLIOGRAPHY-imports.csv Biblio file that I m trying to import Enric Rodellas, 2025-08-28 20:25
Actions

Also available in: Atom PDF