View | Details | Raw Unified | Return to bug 24584
Collapse All | Expand All

(-)a/installer/data/mysql/en/optional/sample_creator_data.sql (-34 lines)
Lines 1-34 Link Here
1
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3
4
LOCK TABLES `creator_layouts` WRITE;
5
INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
6
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
7
    <data_source image_name="none" image_source="patronimages" />
8
  </images>
9
  <text>&lt;firstname&gt; &lt;surname&gt;</text>
10
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
11
  <text>Branch: &lt;branchcode&gt;</text>
12
  <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" />
13
  <text>Expires: August 31, 2010</text>
14
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
15
</opt>
16
','Patroncards');
17
UNLOCK TABLES;
18
19
20
LOCK TABLES `creator_templates` WRITE;
21
INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards');
22
UNLOCK TABLES;
23
24
LOCK TABLES `printers_profile` WRITE;
25
INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
26
( 1,'Library Laser',   1,'Bypass', -2,9,3,0,'POINT','Labels'),
27
(13,'Library Laser',   7,'Tray 1',  0,0,0,0,'POINT','Labels'),
28
(14,'Library Laser',  12,'Tray 2',  0,0,0,0,'POINT','Labels'),
29
(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
30
(22,'Library Laser',   0,'Tray 3',  0,0,0,0,'POINT','Labels');
31
UNLOCK TABLES;
32
33
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
34
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
(-)a/installer/data/mysql/en/optional/sample_creator_data.txt (-1 lines)
Line 1 Link Here
1
Sample label and patron card data
(-)a/installer/data/mysql/en/optional/sample_creator_data.yml (-1 / +259 lines)
Line 0 Link Here
0
- 
1
---
2
#
3
#  Copyright 2020 Koha Development Team
4
#
5
#  This file is part of Koha.
6
#
7
#  Koha is free software; you can redistribute it and/or modify it under the
8
#  terms of the GNU General Public License as published by the Free Software
9
#  Foundation; either version 2 of the License, or (at your option) any later
10
#  version.
11
#
12
#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
#
16
#  You should have received a copy of the GNU General Public License along
17
#  with Koha; if not, write to the Free Software Foundation, Inc.,
18
#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
#
20
21
description:
22
  - "Sample label and patron card data"
23
24
tables:
25
  - creator_layouts:
26
      translatable: [ layout_name, layout_xml ]
27
      multiline: [ layout_xml ]
28
      rows:
29
        - layout_id: 17
30
          barcode_type: CODE39
31
          start_label: 1
32
          printing_type: BIBBAR
33
          layout_name: "Label Test"
34
          guidebox: 0
35
          font: TR
36
          font_size: 3
37
          units: POINT
38
          callnum_split: 0
39
          text_justify: L
40
          format_string: "title, author, isbn, issn, itemtype, barcode, itemcallnumber"
41
          layout_xml:
42
            - "<opt></opt>"
43
          creator: "Labels"
44
45
        - layout_id: 18
46
          barcode_type: CODE39
47
          start_label: 1
48
          printing_type: BAR
49
          layout_name: "DEFAULT"
50
          guidebox: 0
51
          font: TR
52
          font_size: 3
53
          units: POINT
54
          callnum_split: 0
55
          text_justify: L
56
          format_string: "title, author, isbn, issn, itemtype, barcode, itemcallnumber"
57
          layout_xml:
58
            - "<opt></opt>"
59
          creator: "Labels"
60
61
        - layout_id: 19
62
          barcode_type: CODE39
63
          start_label: 1
64
          printing_type: BAR
65
          layout_name: "DEFAULT"
66
          guidebox: 0
67
          font: TR
68
          font_size: 3
69
          units: POINT
70
          callnum_split: 0
71
          text_justify: L
72
          format_string: "title, author, isbn, issn, itemtype, barcode, itemcallnumber"
73
          layout_xml:
74
            - "<opt></opt>"
75
          creator: "Labels"
76
77
        - layout_id: 20
78
          barcode_type: CODE39
79
          start_label: 1
80
          printing_type: BAR
81
          layout_name: "Test Layout"
82
          guidebox: 0
83
          font: TR
84
          font_size: 10
85
          units: POINT
86
          callnum_split: 0
87
          text_justify: L
88
          format_string: "barcode"
89
          layout_xml:
90
            - "<opt page_side=\"F\" units=\"POINT\">"
91
            - "  <images name=\"image_1\" Dx=\"72\" Ox=\"0\" Oy=\"0\" Sx=\"0\" Sy=\"0\" Tx=\"4.5\" Ty=\"63\">"
92
            - "    <data_source image_name=\"none\" image_source=\"patronimages\" />"
93
            - "  </images>"
94
            - "  <text>&lt;firstname&gt; &lt;surname&gt;</text>"
95
            - "  <text enable=\"1\" font=\"TR\" font_size=\"10\" llx=\"100\" lly=\"100\" text_alignment=\"L\" />"
96
            - "  <text>Branch: &lt;branchcode&gt;</text>"
97
            - "  <text enable=\"1\" font=\"TR\" font_size=\"10\" llx=\"100\" lly=\"75\" text_alignment=\"L\" />"
98
            - "  <text>Expires: August 31, 2010</text>"
99
            - "  <text font=\"TR\" font_size=\"6\" llx=\"115\" lly=\"65\" text_alignment=\"L\" />"
100
            - "</opt>"
101
          creator: "Patroncards"
102
103
  - creator_templates:
104
      translatable: [ template_desc ]
105
      multiline: [ ]
106
      rows:
107
        - template_id: 1
108
          profile_id: 1
109
          template_code: "Avery 5160 | 1 x 2-5/8"
110
          template_desc: "3 columns, 10 rows of labels"
111
          page_width: 8.5
112
          page_height: 11
113
          label_width: 2.63
114
          label_height: 1
115
          top_text_margin: 0.139
116
          left_text_margin: 0
117
          top_margin: 0.35
118
          left_margin: 0.23
119
          cols: 3
120
          rows: 10
121
          col_gap: 0.13
122
          row_gap: 0
123
          units: "INCH"
124
          creator: "Labels"
125
126
        - template_id: 7
127
          profile_id: 13
128
          template_code: "Demco WS14942260"
129
          template_desc: "1\" X 1.5\" Spine Label | Setup for up to four lines of text"
130
          page_width: 8.5
131
          page_height: 11
132
          label_width: 1.5
133
          label_height: 1
134
          top_text_margin: 0.236
135
          left_text_margin: 0
136
          top_margin: 0.5
137
          left_margin: 0.25
138
          cols: 5
139
          rows: 10
140
          col_gap: 0.0625
141
          row_gap: 0
142
          units: "INCH"
143
          creator: "Labels"
144
145
        - template_id: 12
146
          profile_id: 14
147
          template_code: "Demco WS14942260"
148
          template_desc: "1\" X 1.5\" Spine Label | Setup for five lines of text"
149
          page_width: 8.5
150
          page_height: 11
151
          label_width: 1.5
152
          label_height: 1
153
          top_text_margin: 0.139
154
          left_text_margin: 0
155
          top_margin: 0.53
156
          left_margin: 0.3
157
          cols: 5
158
          rows: 10
159
          col_gap: 0.0625
160
          row_gap: 0
161
          units: "INCH"
162
          creator: "Labels"
163
164
        - template_id: 22
165
          profile_id: 0
166
          template_code: "DEFAULT TEMPLATE 01"
167
          template_desc: "Default description"
168
          page_width: 0
169
          page_height: 5
170
          label_width: 0
171
          label_height: 0
172
          top_text_margin: 0
173
          left_text_margin: 0
174
          top_margin: 0
175
          left_margin: 0
176
          cols: 0
177
          rows: 0
178
          col_gap: 0
179
          row_gap: 0
180
          units: "POINT"
181
          creator: "Labels"
182
183
        - template_id: 23
184
          profile_id: 16
185
          template_code: "HB-PC0001"
186
          template_desc: "A template for home brewed patron card forms"
187
          page_width: 8.5
188
          page_height: 11
189
          label_width: 3.1875
190
          label_height: 1.9375
191
          top_text_margin: 0
192
          left_text_margin: 0
193
          top_margin: 0.6875
194
          left_margin: 0.875
195
          cols: 2
196
          rows: 4
197
          col_gap: 0.4375
198
          row_gap: 0.1875
199
          units: "INCH"
200
          creator: "Patroncards"
201
202
  - printers_profile:
203
      translatable: [ printer_name ]
204
      multiline: [ ]
205
      rows:
206
        - profile_id: 1
207
          printer_name: "Library Laser"
208
          template_id: 1
209
          paper_bin: "Bypass"
210
          offset_horz: -2
211
          offset_vert: 9
212
          creep_horz: 3
213
          creep_vert: 0
214
          units: "POINT"
215
          creator: "Labels"
216
217
        - profile_id: 13
218
          printer_name: "Library Laser"
219
          template_id: 7
220
          paper_bin: "Tray 1"
221
          offset_horz: 0
222
          offset_vert: 0
223
          creep_horz: 0
224
          creep_vert: 0
225
          units: "POINT"
226
          creator: "Labels"
227
228
        - profile_id: 14
229
          printer_name: "Library Laser"
230
          template_id: 12
231
          paper_bin: "Tray 2"
232
          offset_horz: 0
233
          offset_vert: 0
234
          creep_horz: 0
235
          creep_vert: 0
236
          units: "POINT"
237
          creator: "Labels"
238
239
        - profile_id: 16
240
          printer_name: "Test Printer 01"
241
          template_id: 23
242
          paper_bin: "Test Bin"
243
          offset_horz: 0
244
          offset_vert: 0
245
          creep_horz: 0
246
          creep_vert: 0
247
          units: "POINT"
248
          creator: "Patroncards"
249
250
        - profile_id: 22
251
          printer_name: "Library Laser"
252
          template_id: 0
253
          paper_bin: "Tray 3"
254
          offset_horz: 0
255
          offset_vert: 0
256
          creep_horz: 0
257
          creep_vert: 0
258
          units: "POINT"
259
          creator: "Labels"

Return to bug 24584