From 46705031503918ecb11a91cd4e4d363439196501 Mon Sep 17 00:00:00 2001
From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Date: Tue, 4 Feb 2020 20:56:30 -0300
Subject: [PATCH] Bug 24584: Rewrite optional/csv_profiles to YAML

YAML version of optional csv_profiles.

To test:
1) Do a clean install with optional data,
   dump table export_format, reserve.

2) Apply this patch and it's dependencies

3) Do a clean install, dump again and compare
   No major differences expected

4) Try translation
  a) Go to misc/translator
  b) create files for a new language
     ./translate create xx-YY
  c) Check new file po/xx-YY-instaler.po
     Verify strings from this file.
  d) Install new language
     ./translate install xx-YY
  e) Try clean install with new files

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 .../data/mysql/en/optional/csv_profiles.sql   |  2 --
 .../data/mysql/en/optional/csv_profiles.txt   |  3 --
 .../data/mysql/en/optional/csv_profiles.yml   | 36 +++++++++++++++++++
 3 files changed, 36 insertions(+), 5 deletions(-)
 delete mode 100644 installer/data/mysql/en/optional/csv_profiles.sql
 delete mode 100644 installer/data/mysql/en/optional/csv_profiles.txt
 create mode 100644 installer/data/mysql/en/optional/csv_profiles.yml

diff --git a/installer/data/mysql/en/optional/csv_profiles.sql b/installer/data/mysql/en/optional/csv_profiles.sql
deleted file mode 100644
index 86c2394d76..0000000000
--- a/installer/data/mysql/en/optional/csv_profiles.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) 
-VALUES ( "issues to claim", "default CSV export for serial issue claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ",", "sql", "late_issues" );
diff --git a/installer/data/mysql/en/optional/csv_profiles.txt b/installer/data/mysql/en/optional/csv_profiles.txt
deleted file mode 100644
index 9dcff5d0ed..0000000000
--- a/installer/data/mysql/en/optional/csv_profiles.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-CSV profiles
-
-Default CSV export profiles; including one for exporting serial claims.
diff --git a/installer/data/mysql/en/optional/csv_profiles.yml b/installer/data/mysql/en/optional/csv_profiles.yml
new file mode 100644
index 0000000000..5245c18bc3
--- /dev/null
+++ b/installer/data/mysql/en/optional/csv_profiles.yml
@@ -0,0 +1,36 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+#  Koha is free software; you can redistribute it and/or modify it under the
+#  terms of the GNU General Public License as published by the Free Software
+#  Foundation; either version 2 of the License, or (at your option) any later
+#  version.
+#
+#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
+#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
+#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
+#
+#  You should have received a copy of the GNU General Public License along
+#  with Koha; if not, write to the Free Software Foundation, Inc.,
+#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+#
+
+description:
+  - "CSV profiles"
+  - ""
+  - "Default CSV export profiles; including one for exporting serial claims."
+
+tables:
+  - export_format:
+      translatable: [ profile, description ]
+      multiline: []
+      rows:
+        - profile: "issues to claim"
+          description: "default CSV export for serial issue claims"
+          content: "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate"
+          csv_separator: ","
+          type: sql
+          used_for: late_issues
-- 
2.20.1