From cbdd298cc68ae4c1cf518239b14d8215dd41d34c Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Sat, 2 May 2020 15:46:13 +0200 Subject: [PATCH] Bug 24163: Add the new CSV profile to other installer files export_format is not populated for other languages apparently... --- installer/data/mysql/de-DE/optional/csv_profiles.sql | 12 +++++++++++- .../data/mysql/fr-CA/facultatif/csv_profiles.sql | 12 +++++++++++- .../data/mysql/it-IT/necessari/csv_profiles.sql | 12 +++++++++++- 3 files changed, 33 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/de-DE/optional/csv_profiles.sql b/installer/data/mysql/de-DE/optional/csv_profiles.sql index 477993bb20..496e96faeb 100644 --- a/installer/data/mysql/de-DE/optional/csv_profiles.sql +++ b/installer/data/mysql/de-DE/optional/csv_profiles.sql @@ -1,2 +1,12 @@ INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) -VALUES ( "Zeitschriftenreklamationen", "Standardprofil für den Export von Heftinformationen für Zeitschriftenreklamationen", "LIEFERANT=aqbooksellers.name|TITEL=subscription.title|HEFTNUMMER=serial.serialseq|VERSPÄTET SEIT=serial.planneddate", ",", "sql", "late_issues" ); +VALUES ( "Zeitschriftenreklamationen", "Standardprofil für den Export von Heftinformationen für Zeitschriftenreklamationen", "LIEFERANT=aqbooksellers.name|TITEL=subscription.title|HEFTNUMMER=serial.serialseq|VERSPÄTET SEIT=serial.planneddate", ",", "sql", "late_issues" ), +("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims +[% FOR order IN orders ~%] +[%~ SET biblio = order.biblio ~%] +"[% biblio.title %]"[% separator ~%] +"[% biblio.author %]"[% separator ~%] +"[% bibio.biblioitem.publicationyear %]"[% separator ~%] +"[% biblio.biblioitem.isbn %]"[% separator ~%] +"[% order.quantity%]"[% separator ~%] +"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]" +[% END %]', ",", "sql", "late_orders"); diff --git a/installer/data/mysql/fr-CA/facultatif/csv_profiles.sql b/installer/data/mysql/fr-CA/facultatif/csv_profiles.sql index dccd2b2c99..a984f136c4 100644 --- a/installer/data/mysql/fr-CA/facultatif/csv_profiles.sql +++ b/installer/data/mysql/fr-CA/facultatif/csv_profiles.sql @@ -1,2 +1,12 @@ INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) -VALUES ( "Réclamation de numéros", "Export CSV par défaut pour la réclamation de numéros de périodiques", "FOURNISSEUR=aqbooksellers.name|TITRE=subscription.title|NUMÉRO=serial.serialseq|EN RETARD DEPUIS=serial.planneddate", ",", "sql", "late_issues" ); +VALUES ( "Réclamation de numéros", "Export CSV par défaut pour la réclamation de numéros de périodiques", "FOURNISSEUR=aqbooksellers.name|TITRE=subscription.title|NUMÉRO=serial.serialseq|EN RETARD DEPUIS=serial.planneddate", ",", "sql", "late_issues" ), +("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims +[% FOR order IN orders ~%] +[%~ SET biblio = order.biblio ~%] +"[% biblio.title %]"[% separator ~%] +"[% biblio.author %]"[% separator ~%] +"[% bibio.biblioitem.publicationyear %]"[% separator ~%] +"[% biblio.biblioitem.isbn %]"[% separator ~%] +"[% order.quantity%]"[% separator ~%] +"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]" +[% END %]', ",", "sql", "late_orders"); diff --git a/installer/data/mysql/it-IT/necessari/csv_profiles.sql b/installer/data/mysql/it-IT/necessari/csv_profiles.sql index ccfe849975..6504049655 100644 --- a/installer/data/mysql/it-IT/necessari/csv_profiles.sql +++ b/installer/data/mysql/it-IT/necessari/csv_profiles.sql @@ -1,2 +1,12 @@ INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) -VALUES ( "issues to claim", "CSV export per fascicoli in ritardo", "FORNITORE=aqbooksellers.name|TITOLO=subscription.title|NUMERO FASC=serial.serialseq|IN RITARDO DAL=serial.planneddate", ",", "sql", "late_issues" ); +VALUES ( "issues to claim", "CSV export per fascicoli in ritardo", "FORNITORE=aqbooksellers.name|TITOLO=subscription.title|NUMERO FASC=serial.serialseq|IN RITARDO DAL=serial.planneddate", ",", "sql", "late_issues" ), +("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims +[% FOR order IN orders ~%] +[%~ SET biblio = order.biblio ~%] +"[% biblio.title %]"[% separator ~%] +"[% biblio.author %]"[% separator ~%] +"[% bibio.biblioitem.publicationyear %]"[% separator ~%] +"[% biblio.biblioitem.isbn %]"[% separator ~%] +"[% order.quantity%]"[% separator ~%] +"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]" +[% END %]', ",", "sql", "late_orders"); -- 2.20.1