https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37321 Bug ID: 37321 Summary: CSV import framework breaks on fields with double quotes on its field/subfield name Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: System Administration Assignee: koha-bugs@lists.koha-community.org Reporter: pablo.bianchi@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Steps to reproduce the issue: 1. Create a framework with double quotes on its field/subfield name. For e.g.: $ grep 501 export_MON.csv # double quotes not escaped :S "501","NOTA DE "CON"","NOTA DE "CON"","1","0","0","","","","MON" "501","5","Institución que aplica el campo","Institución que aplica el campo","0","0","0","","5","","","","0","-6","MON","","","","9999","0" "501","6","Enlace","Enlace","0","0","0","","5","","","","0","-6","MON","","","","9999","0" "501","8","Enlace entre campo y número de secuencia","Enlace entre campo y número de secuencia","1","0","0","","5","","","","0","-6","MON","","","","9999","0" "501","a","Nota de "con"","Nota de "con"","0","0","0","","5","","","","0","0","MON","","","","9999","0" 2. Export it to a CSV (works fine with ODS) 3. Try to import it. Without showing any errors to the user, will import until field 500. Then, change the "con" to «con» (Spanish quotes, AKA guillemets), repeat the procedure. Will hopefully import successfully. On `plack-intranet-error.log` we get a warning (instead of an error) [WARN] Error _processRow_DB C4::ImportExportFramework::_processRow_DB(): DBI Exception: DBD::mysql::st execute failed: called with 12 bind variables when 14 are needed at /usr/share/koha/lib/C4/ImportExportFramework.pm line 1032 https://git.koha-community.org/Koha-community/Koha/src/tag/v24.05.01/C4/Impo... https://translate.koha-community.org/translate/koha/24-05/installer-MARC21/e... -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.