Attachment 104340 Details for Bug 24163 – Bug 24163: Add the new CSV profile to other installer files

[patch] Bug 24163: Add the new CSV profile to other installer files

Bug-24163-Add-the-new-CSV-profile-to-other-install.patch (text/plain), 5.31 KB, created by Katrin Fischer on 2020-05-05 06:40:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2020-05-05 06:40:25 UTC

Size: 5.31 KB

patch

obsolete

>From 7dc46c39dc50e9e6f8fba5e634c3ee17214b5428 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>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...
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> installer/data/mysql/de-DE/optional/csv_profiles.sql   | 12 +++++++++++-
> installer/data/mysql/fr-CA/facultatif/csv_profiles.sql | 12 +++++++++++-
> installer/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.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24163: 97120 | 97121 | 97122 | 97123 | 98691 | 98692 | 102185 | 102186 | 102257 | 102258 | 103585 | 103586 | 104192 | 104193 | 104194 | 104252 | 104337 | 104338 | 104339 | 104340 | 104341