1 [% INCLUDE 'doc-head-open.inc' %]<title>Koha › Tools › CSV export profiles</title>[% INCLUDE 'doc-head-close.inc' %]
2 <script type="text/javascript">
4 function reloadPage(p) {
6 if (id != 0) { document.location = "/cgi-bin/koha/tools/csv-profiles.pl?id=" + id; }
8 $(document).ready(function() {
9 $('#csvexporttabs').tabs();
11 $("#profile_type").find("option:first").attr("selected", "selected");
12 $("#csvnew").find("li.marc_specific").show();
13 $("#csvnew").find("li.sql_specific").hide();
15 $("#profile_type").change(function(){
16 if ( $(this).find("option:selected").val() == "marc" ) {
17 $("#csvnew li.marc_specific").show();
18 $("#new_profile_marc_content").attr("required", "required");
19 $("#csvnew li.sql_specific").hide();
20 $("#new_profile_sql_content").removeAttr("required");
22 $("#csvnew li.marc_specific").hide();
23 $("#new_profile_marc_content").removeAttr("required");
24 $("#csvnew li.sql_specific").show();
25 $("#new_profile_sql_content").attr("required", "required");
28 $("#modify_profile_type").change(function(){
29 if ( $(this).find("option:selected").val() == "marc" ) {
30 $("#csvedit li.marc_specific").show();
31 $("#modify_profile_marc_content").attr("required", "required");
32 $("#csvedit li.sql_specific").hide();
33 $("#modify_profile_sql_content").removeAttr("required");
35 $("#csvedit li.marc_specific").hide();
36 $("#modify_profile_marc_content").removeAttr("required");
37 $("#csvedit li.sql_specific").show();
38 $("#modify_profile_sql_content").attr("required", "required");
41 $("#profile_type").change();
42 $("#modify_profile_type").change();
48 <body id="tools_csv-profiles" class="tools">
49 [% INCLUDE 'header.inc' %]
50 [% INCLUDE 'cat-search.inc' %]
52 <div id="breadcrumbs">
53 <a href="/cgi-bin/koha/mainpage.pl">Home</a>
54 › <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a>
55 › CSV export profiles
58 <div id="doc3" class="yui-t2">
62 [% IF ( success || error ) %]
64 [% IF ( action == 'create' ) %]<div class="dialog message">The new CSV profile "[% profile_name %]" has been successfully created.</div>[% END %]
65 [% IF ( action == 'edit' ) %]<div class="dialog message">The CSV profile has been successfully modified.</div>[% END %]
66 [% IF ( action == 'delete' ) %]<div class="dialog message">The CSV profile has been successfully deleted.</div>[% END %]
68 [% IF ( action == 'create' ) %]<div class="dialog alert">The new CSV profile "[% profile_name %]" has not been created.</div>[% END %]
69 [% IF ( action == 'edit' ) %]<div class="dialog alert">The CSV profile has not been modified.</div>[% END %]
70 [% IF ( action == 'delete' ) %]<div class="dialog alert">The CSV profile has not been deleted.</div>[% END %]
73 <div id="csvexporttabs" class="toptabs">
75 <li><a href="#csvnew">New profile</a></li>
76 [% IF ( existing_profiles ) %]
77 [% IF ( selected_profile_id ) %]
78 <li class="ui-tabs-active">
82 <a href="#csvedit">Edit existing profile</a></li> [% END %]
85 <h3>New CSV export profile</h3>
87 <form action="/cgi-bin/koha/tools/csv-profiles.pl" class="validated" method="post">
88 <fieldset class="rows">
91 <label for="profile_name" class="required">Profile name: </label>
92 <input type="text" id="profile_name" name="profile_name" required="required" />
93 <span class="required">Required</span>
97 <label for="profile_type" class="required">Profile type: </label>
98 <select id="profile_type" name="profile_type">
99 <option value="marc" selected="selected">MARC</option>
100 <option value="sql">SQL</option>
102 <span class="required">Required</span>
105 <li><label for="profile_description">Profile description: </label>
106 <textarea cols="50" rows="2" name="profile_description" id="profile_description"></textarea></li>
108 <li><label for="new_csv_separator">CSV separator: </label>
109 <select name="csv_separator" id="new_csv_separator">
110 <option value=":">Colon (:)</option>
111 <option value="," selected="selected">Comma (,)</option>
112 <option value="|">Pipe (|)</option>
113 <option value=";">Semi-colon (;)</option>
114 <option value="#">Sharp (#)</option>
115 <option value=" ">Space ( )</option>
116 <option value="\t">Tabulation (\t)</option>
117 <option value="\n">New line (\n)</option>
121 <li class="marc_specific"><label for="new_field_separator">Field separator: </label>
122 <select name="field_separator" id="new_field_separator">
123 <option value=":">Colon (:)</option>
124 <option value=",">Comma (,)</option>
125 <option value="|">Pipe (|)</option>
126 <option value=";">Semi-colon (;)</option>
127 <option value="#" selected="selected">Sharp (#)</option>
128 <option value=" ">Space ( )</option>
129 <option value="\t">Tabulation (\t)</option>
130 <option value="\n">New line (\n)</option>
134 <li class="marc_specific"><label for="new_subfield_separator">Subfield separator: </label>
135 <select name="subfield_separator" id="new_subfield_separator">
136 <option value=":">Colon (:)</option>
137 <option value=",">Comma (,)</option>
138 <option value="|" selected="selected">Pipe (|)</option>
139 <option value=";">Semi-colon (;)</option>
140 <option value="#">Sharp (#)</option>
141 <option value=" ">Space ( )</option>
142 <option value="\t">Tabulation (\t)</option>
143 <option value="\n">New line (\n)</option>
147 <li class="marc_specific"><label for="new_encoding">Encoding: </label>
148 <select name="encoding" id="new_encoding">
149 [% FOREACH encoding IN encodings %]
150 [% IF ( encoding.encoding == 'utf8' ) %]
151 <option selected="selected">[% encoding.encoding %]</option>
153 <option>[% encoding.encoding %]</option>
159 <li class="marc_specific">
160 <label for="new_profile_marc_content" class="required">Profile MARC fields: </label>
161 <textarea cols="50" rows="2" name="profile_marc_content" id="new_profile_marc_content"></textarea>
162 <span class="required">Required</span>
163 <p>You have to define which fields or subfields you want to export, separated by pipes.</p>
164 <p>You can also use your own headers (instead of the ones from Koha) by prefixing the field number with an header, followed by the equal sign.</p>
165 <p>Example: Personal name=200|Entry element=210$a|300|009</p>
166 <p>You can use Template Toolkit tags too. See the help page for more information.</p>
168 <li class="sql_specific">
169 <label for="new_profile_sql_content" class="required">Profile SQL fields: </label>
170 <textarea cols="50" rows="2" name="profile_sql_content" id="new_profile_sql_content"></textarea>
171 <p>You have to define which fields you want to export, separated by pipes.</p>
172 <p>You can also use your own headers (instead of the ones from Koha) by prefixing the field name with an header, followed by the equal sign.</p>
173 <p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p>
177 <fieldset class="action"><input type="hidden" name="action" value="create" />
178 <input type="submit" value="Submit" /></fieldset>
180 <br style="clear:both;" />
182 [% IF ( existing_profiles ) %]
184 <h3>Modify or delete a CSV export profile</h3>
186 <form action="/cgi-bin/koha/tools/csv-profiles.pl" class="validated" method="post">
187 <fieldset class="rows">
189 <li><label for="modify_profile_name" class="required">Profile name: </label>
190 <select id="modify_profile_name" name="profile_name" required="required" class="required" onchange="reloadPage(this)">
191 <option value="0">-- Choose One --</option>
192 [% FOREACH existing_profile IN existing_profiles %]
193 [% IF ( existing_profile.export_format_id == selected_profile_id ) %]
194 <option value="[% existing_profile.export_format_id %]" selected="selected">[% existing_profile.profile %]</option>
196 <option value="[% existing_profile.export_format_id %]">[% existing_profile.profile %]</option>
200 <span class="required">Required</span>
204 <label for="modify_profile_type" class="required">Profile type: </label>
205 <select id="modify_profile_type" name="profile_type" class="required" required="required">
206 <option value="marc">MARC</option>
207 [% IF selected_profile_type == "sql" %]
208 <option value="sql" selected="selected">SQL</option>
210 <option value="sql">SQL</option>
213 <span class="required">Required</span>
217 <li><label for="modify_profile_description">Profile description: </label>
218 <textarea cols="50" rows="2" name="profile_description" id="modify_profile_description">[% selected_profile_description %]</textarea></li>
220 <li><label for="csv_separator">CSV separator: </label>
221 <select name="csv_separator" id="csv_separator">
222 <option value=":">Colon (:)</option>
223 [% IF ( selected_csv_separator == ',' ) %]
224 <option value="," selected="selected">Comma (,)</option>
226 <option value=",">Comma (,)</option>
228 [% IF ( selected_csv_separator == '|' ) %]
229 <option value="|" selected="selected">Pipe (|)</option>
231 <option value="|">Pipe (|)</option>
233 [% IF ( selected_csv_separator == ';' ) %]
234 <option value=";" selected="selected">Semi-colon (;)</option>
236 <option value=";">Semi-colon (;)</option>
238 [% IF ( selected_csv_separator == '#' ) %]
239 <option value="#" selected="selected">Sharp (#)</option>
241 <option value="#">Sharp (#)</option>
243 [% IF ( selected_csv_separator == ' ' ) %]
244 <option value=" " selected="selected">Space ( )</option>
246 <option value=" ">Space ( )</option>
248 [% IF ( selected_csv_separator == '\t' ) %]
249 <option value="\t" selected="selected">Tabulation (\t)</option>
251 <option value="\t">Tabulation (\t)</option>
253 [% IF ( selected_csv_separator == '\n' ) %]
254 <option value="\n" selected="selected">New line (\n)</option>
256 <option value="\n">New line (\n)</option>
260 <li class="marc_specific"><label for="field_separator">Field separator: </label>
261 <select name="field_separator" id="field_separator">
262 <option value=":">Colon (:)</option>
264 [% IF ( selected_field_separator == ',' ) %]
265 <option value="," selected="selected">Comma (,)</option>
267 <option value=",">Comma (,)</option>
270 [% IF ( selected_field_separator == '|' ) %]
271 <option value="|" selected="selected">Pipe (|)</option>
273 <option value="|">Pipe (|)</option>
276 [% IF ( selected_field_separator == ';' ) %]
277 <option value=";" selected="selected">Semi-colon (;)</option>
279 <option value=";">Semi-colon (;)</option>
282 [% IF ( selected_field_separator == '#' ) %]
283 <option value="#" selected="selected">Sharp (#)</option>
285 <option value="#">Sharp (#)</option>
288 [% IF ( selected_field_separator == ' ' ) %]
289 <option value=" " selected="selected">Space ( )</option>
291 <option value=" ">Space ( )</option>
294 [% IF ( selected_field_separator == '\t' ) %]
295 <option value="\t" selected="selected">Tabulation (\t)</option>
297 <option value="\t">Tabulation (\t)</option>
299 [% IF ( selected_field_separator == '\n' ) %]
300 <option value="\n" selected="selected">New line (\n)</option>
302 <option value="\n">New line (\n)</option>
307 <li class="marc_specific"><label for="subfield_separator">Subfield separator: </label>
308 <select name="subfield_separator" id="subfield_separator">
309 <option value=":">Colon (:)</option>
311 [% IF ( selected_subfield_separator == ',' ) %]
312 <option value="," selected="selected">Comma (,)</option>
314 <option value=",">Comma (,)</option>
317 [% IF ( selected_subfield_separator == '|' ) %]
318 <option value="|" selected="selected">Pipe (|)</option>
320 <option value="|">Pipe (|)</option>
323 [% IF ( selected_subfield_separator == ';' ) %]
324 <option value=";" selected="selected">Semi-colon (;)</option>
326 <option value=";">Semi-colon (;)</option>
329 [% IF ( selected_subfield_separator == '#' ) %]
330 <option value="#" selected="selected">Sharp (#)</option>
332 <option value="#">Sharp (#)</option>
335 [% IF ( selected_subfield_separator == ' ' ) %]
336 <option value=" " selected="selected">Space ( )</option>
338 <option value=" ">Space ( )</option>
341 [% IF ( selected_subfield_separator == '\t' ) %]
342 <option value="\t" selected="selected">Tabulation (\t)</option>
344 <option value="\t">Tabulation (\t)</option>
346 [% IF ( selected_subfield_separator == '\n' ) %]
347 <option value="\n" selected="selected">New line (\n)</option>
349 <option value="\n">New line (\n)</option>
354 <li class="marc_specific"><label for="encoding">Encoding: </label>
355 <select name="encoding" id="encoding">
356 [% FOREACH encoding IN encodings %]
357 [% IF ( selected_encoding == encoding.encoding ) %]
358 <option selected="selected">[% encoding.encoding %]</option>
360 <option>[% encoding.encoding %]</option>
365 <li class="marc_specific">
366 <label for="modify_profile_marc_content" class="required">Profile MARC fields: </label>
367 <textarea cols="50" rows="2" name="profile_marc_content" id="modify_profile_marc_content" class="required" required="required">[% selected_profile_content %]</textarea>
368 <span class="required">Required</span>
371 <li class="sql_specific">
372 <label for="modify_profile_sql_content" class="required">Profile SQL fields: </label>
373 <textarea cols="50" rows="2" name="profile_sql_content" id="modify_profile_sql_content">[% selected_profile_content %]</textarea>
376 <li class="radio"> <label for="delete">Delete selected profile ?</label>
377 <input type="checkbox" name="delete" id="delete" /></li>
382 <fieldset class="action"><input type="hidden" name="modify_profile_id" value="[% selected_profile_id %]" />
383 <input type="hidden" name="action" value="edit" />
384 <input type="submit" value="Submit" /> <a href="/cgi-bin/koha/tools/csv-profiles.pl" class="cancel">Cancel</a></fieldset>
392 <div class="yui-b noprint">
393 [% INCLUDE 'tools-menu.inc' %]
396 [% INCLUDE 'intranet-bottom.inc' %]