Attachment #100358 for bug #24584

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




/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

LOCK TABLES `creator_layouts` WRITE;
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">
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
    <data_source image_name="none" image_source="patronimages" />
  </images>
  <text>&lt;firstname&gt; &lt;surname&gt;</text>
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
  <text>Branch: &lt;branchcode&gt;</text>
  <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" />
  <text>Expires: August 31, 2010</text>
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
</opt>
','Patroncards');
UNLOCK TABLES;


LOCK TABLES `creator_templates` WRITE;
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');
UNLOCK TABLES;

LOCK TABLES `printers_profile` WRITE;
INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
( 1,'Library Laser',   1,'Bypass', -2,9,3,0,'POINT','Labels'),
(13,'Library Laser',   7,'Tray 1',  0,0,0,0,'POINT','Labels'),
(14,'Library Laser',  12,'Tray 2',  0,0,0,0,'POINT','Labels'),
(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
(22,'Library Laser',   0,'Tray 3',  0,0,0,0,'POINT','Labels');
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

Line 1 Link Here

(-)a/installer/data/mysql/en/optional/sample_creator_data.txt (-1 lines)
1	Sample label and patron card data




---
#
#  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:
  - "Sample label and patron card data"

tables:
  - creator_layouts:
      translatable: [ layout_name, layout_xml ]
      multiline: [ layout_xml ]
      rows:
        - layout_id: 17
          barcode_type: CODE39
          start_label: 1
          printing_type: BIBBAR
          layout_name: "Label Test"
          guidebox: 0
          font: TR
          font_size: 3
          units: POINT
          callnum_split: 0
          text_justify: L
          format_string: "title, author, isbn, issn, itemtype, barcode, itemcallnumber"
          layout_xml:
            - "<opt></opt>"
          creator: "Labels"

        - layout_id: 18
          barcode_type: CODE39
          start_label: 1
          printing_type: BAR
          layout_name: "DEFAULT"
          guidebox: 0
          font: TR
          font_size: 3
          units: POINT
          callnum_split: 0
          text_justify: L
          format_string: "title, author, isbn, issn, itemtype, barcode, itemcallnumber"
          layout_xml:
            - "<opt></opt>"
          creator: "Labels"

        - layout_id: 19
          barcode_type: CODE39
          start_label: 1
          printing_type: BAR
          layout_name: "DEFAULT"
          guidebox: 0
          font: TR
          font_size: 3
          units: POINT
          callnum_split: 0
          text_justify: L
          format_string: "title, author, isbn, issn, itemtype, barcode, itemcallnumber"
          layout_xml:
            - "<opt></opt>"
          creator: "Labels"

        - layout_id: 20
          barcode_type: CODE39
          start_label: 1
          printing_type: BAR
          layout_name: "Test Layout"
          guidebox: 0
          font: TR
          font_size: 10
          units: POINT
          callnum_split: 0
          text_justify: L
          format_string: "barcode"
          layout_xml:
            - "<opt page_side=\"F\" units=\"POINT\">"
            - "  <images name=\"image_1\" Dx=\"72\" Ox=\"0\" Oy=\"0\" Sx=\"0\" Sy=\"0\" Tx=\"4.5\" Ty=\"63\">"
            - "    <data_source image_name=\"none\" image_source=\"patronimages\" />"
            - "  </images>"
            - "  <text>&lt;firstname&gt; &lt;surname&gt;</text>"
            - "  <text enable=\"1\" font=\"TR\" font_size=\"10\" llx=\"100\" lly=\"100\" text_alignment=\"L\" />"
            - "  <text>Branch: &lt;branchcode&gt;</text>"
            - "  <text enable=\"1\" font=\"TR\" font_size=\"10\" llx=\"100\" lly=\"75\" text_alignment=\"L\" />"
            - "  <text>Expires: August 31, 2010</text>"
            - "  <text font=\"TR\" font_size=\"6\" llx=\"115\" lly=\"65\" text_alignment=\"L\" />"
            - "</opt>"
          creator: "Patroncards"

  - creator_templates:
      translatable: [ template_desc ]
      multiline: [ ]
      rows:
        - template_id: 1
          profile_id: 1
          template_code: "Avery 5160 | 1 x 2-5/8"
          template_desc: "3 columns, 10 rows of labels"
          page_width: 8.5
          page_height: 11
          label_width: 2.63
          label_height: 1
          top_text_margin: 0.139
          left_text_margin: 0
          top_margin: 0.35
          left_margin: 0.23
          cols: 3
          rows: 10
          col_gap: 0.13
          row_gap: 0
          units: "INCH"
          creator: "Labels"

        - template_id: 7
          profile_id: 13
          template_code: "Demco WS14942260"
          template_desc: "1\" X 1.5\" Spine Label | Setup for up to four lines of text"
          page_width: 8.5
          page_height: 11
          label_width: 1.5
          label_height: 1
          top_text_margin: 0.236
          left_text_margin: 0
          top_margin: 0.5
          left_margin: 0.25
          cols: 5
          rows: 10
          col_gap: 0.0625
          row_gap: 0
          units: "INCH"
          creator: "Labels"

        - template_id: 12
          profile_id: 14
          template_code: "Demco WS14942260"
          template_desc: "1\" X 1.5\" Spine Label | Setup for five lines of text"
          page_width: 8.5
          page_height: 11
          label_width: 1.5
          label_height: 1
          top_text_margin: 0.139
          left_text_margin: 0
          top_margin: 0.53
          left_margin: 0.3
          cols: 5
          rows: 10
          col_gap: 0.0625
          row_gap: 0
          units: "INCH"
          creator: "Labels"

        - template_id: 22
          profile_id: 0
          template_code: "DEFAULT TEMPLATE 01"
          template_desc: "Default description"
          page_width: 0
          page_height: 5
          label_width: 0
          label_height: 0
          top_text_margin: 0
          left_text_margin: 0
          top_margin: 0
          left_margin: 0
          cols: 0
          rows: 0
          col_gap: 0
          row_gap: 0
          units: "POINT"
          creator: "Labels"

        - template_id: 23
          profile_id: 16
          template_code: "HB-PC0001"
          template_desc: "A template for home brewed patron card forms"
          page_width: 8.5
          page_height: 11
          label_width: 3.1875
          label_height: 1.9375
          top_text_margin: 0
          left_text_margin: 0
          top_margin: 0.6875
          left_margin: 0.875
          cols: 2
          rows: 4
          col_gap: 0.4375
          row_gap: 0.1875
          units: "INCH"
          creator: "Patroncards"

  - printers_profile:
      translatable: [ printer_name ]
      multiline: [ ]
      rows:
        - profile_id: 1
          printer_name: "Library Laser"
          template_id: 1
          paper_bin: "Bypass"
          offset_horz: -2
          offset_vert: 9
          creep_horz: 3
          creep_vert: 0
          units: "POINT"
          creator: "Labels"

        - profile_id: 13
          printer_name: "Library Laser"
          template_id: 7
          paper_bin: "Tray 1"
          offset_horz: 0
          offset_vert: 0
          creep_horz: 0
          creep_vert: 0
          units: "POINT"
          creator: "Labels"

        - profile_id: 14
          printer_name: "Library Laser"
          template_id: 12
          paper_bin: "Tray 2"
          offset_horz: 0
          offset_vert: 0
          creep_horz: 0
          creep_vert: 0
          units: "POINT"
          creator: "Labels"

        - profile_id: 16
          printer_name: "Test Printer 01"
          template_id: 23
          paper_bin: "Test Bin"
          offset_horz: 0
          offset_vert: 0
          creep_horz: 0
          creep_vert: 0
          units: "POINT"
          creator: "Patroncards"

        - profile_id: 22
          printer_name: "Library Laser"
          template_id: 0
          paper_bin: "Tray 3"
          offset_horz: 0
          offset_vert: 0
          creep_horz: 0
          creep_vert: 0
          units: "POINT"
          creator: "Labels"

Return to bug 24584

Lines 1-34 Link Here

(-)a/installer/data/mysql/en/optional/sample_creator_data.sql (-34 lines)
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><firstname> <surname></text>
10	<text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
11	<text>Branch: <branchcode></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 /;

Line 0 Link Here

(-)a/installer/data/mysql/en/optional/sample_creator_data.yml (-1 / +259 lines)
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><firstname> <surname></text>"
95	- " <text enable=\"1\" font=\"TR\" font_size=\"10\" llx=\"100\" lly=\"100\" text_alignment=\"L\" />"
96	- " <text>Branch: <branchcode></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"