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-selected">
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" method="post">
88 <fieldset class="rows">
90 <li><label for="profile_name" class="required">Profile name: </label>
91 <input type="text" id="profile_name" name="profile_name" required="required" /></li>
94 <label for="profile_type" class="required">Profile type: </label>
95 <select id="profile_type" name="profile_type">
96 <option value="marc" selected="selected">MARC</option>
97 <option value="sql">SQL</option>
101 <li><label for="profile_description">Profile description: </label>
102 <textarea cols="50" rows="2" name="profile_description" id="profile_description"></textarea></li>
104 <li><label for="new_csv_separator">CSV separator: </label>
105 <select name="csv_separator" id="new_csv_separator">
106 <option value=":">Colon (:)</option>
107 <option value="," selected="selected">Comma (,)</option>
108 <option value="|">Pipe (|)</option>
109 <option value=";">Semi-colon (;)</option>
110 <option value="#">Sharp (#)</option>
111 <option value=" ">Space ( )</option>
112 <option value="\t">Tabulation (\t)</option>
113 <option value="\n">New line (\n)</option>
117 <li class="marc_specific"><label for="new_field_separator">Field separator: </label>
118 <select name="field_separator" id="new_field_separator">
119 <option value=":">Colon (:)</option>
120 <option value=",">Comma (,)</option>
121 <option value="|">Pipe (|)</option>
122 <option value=";">Semi-colon (;)</option>
123 <option value="#" selected="selected">Sharp (#)</option>
124 <option value=" ">Space ( )</option>
125 <option value="\t">Tabulation (\t)</option>
126 <option value="\n">New line (\n)</option>
130 <li class="marc_specific"><label for="new_subfield_separator">Subfield separator: </label>
131 <select name="subfield_separator" id="new_subfield_separator">
132 <option value=":">Colon (:)</option>
133 <option value=",">Comma (,)</option>
134 <option value="|" selected="selected">Pipe (|)</option>
135 <option value=";">Semi-colon (;)</option>
136 <option value="#">Sharp (#)</option>
137 <option value=" ">Space ( )</option>
138 <option value="\t">Tabulation (\t)</option>
139 <option value="\n">New line (\n)</option>
143 <li class="marc_specific"><label for="new_encoding">Encoding: </label>
144 <select name="encoding" id="new_encoding">
145 [% FOREACH encoding IN encodings %]
146 [% IF ( encoding.encoding == 'utf8' ) %]
147 <option selected="selected">[% encoding.encoding %]</option>
149 <option>[% encoding.encoding %]</option>
155 <li class="marc_specific"><label for="new_profile_marc_content" class="required">Profile MARC fields: </label>
156 <textarea cols="50" rows="2" name="profile_marc_content" id="new_profile_marc_content"></textarea>
157 <p>You have to define which fields or subfields you want to export, separated by pipes.</p>
158 <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>
159 <p>Example: Personal name=200|Entry element=210$a|300|009</p>
161 <li class="sql_specific">
162 <label for="new_profile_sql_content" class="required">Profile SQL fields: </label>
163 <textarea cols="50" rows="2" name="profile_sql_content" id="new_profile_sql_content"></textarea>
164 <p>You have to define which fields you want to export, separated by pipes.</p>
165 <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>
166 <p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p>
170 <fieldset class="action"><input type="hidden" name="action" value="create" />
171 <input type="submit" value="Submit" /></fieldset>
173 <br style="clear:both;" />
175 [% IF ( existing_profiles ) %]
177 <h3>Modify or delete a CSV export profile</h3>
179 <form action="/cgi-bin/koha/tools/csv-profiles.pl" method="post">
180 <fieldset class="rows">
182 <li><label for="modify_profile_name" class="required">Profile name: </label>
183 <select id="modify_profile_name" name="profile_name" onchange="javascript:reloadPage(this)">
184 <option value="0">-- Choose One --</option>
185 [% FOREACH existing_profile IN existing_profiles %]
186 [% IF ( existing_profile.export_format_id == selected_profile_id ) %]
187 <option value="[% existing_profile.export_format_id %]" selected="selected">[% existing_profile.profile %]</option>
189 <option value="[% existing_profile.export_format_id %]">[% existing_profile.profile %]</option>
195 <label for="modify_profile_type" class="required">Profile type: </label>
196 <select id="modify_profile_type" name="profile_type">
197 <option value="marc">MARC</option>
198 [% IF selected_profile_type == "sql" %]
199 <option value="sql" selected="selected">SQL</option>
201 <option value="sql">SQL</option>
207 <li><label for="modify_profile_description">Profile description: </label>
208 <textarea cols="50" rows="2" name="profile_description" id="modify_profile_description">[% selected_profile_description %]</textarea></li>
210 <li><label for="csv_separator">CSV separator: </label>
211 <select name="csv_separator" id="csv_separator">
212 <option value=":">Colon (:)</option>
213 [% IF ( selected_csv_separator == ',' ) %]
214 <option value="," selected="selected">Comma (,)</option>
216 <option value=",">Comma (,)</option>
218 [% IF ( selected_csv_separator == '|' ) %]
219 <option value="|" selected="selected">Pipe (|)</option>
221 <option value="|">Pipe (|)</option>
223 [% IF ( selected_csv_separator == ';' ) %]
224 <option value=";" selected="selected">Semi-colon (;)</option>
226 <option value=";">Semi-colon (;)</option>
228 [% IF ( selected_csv_separator == '#' ) %]
229 <option value="#" selected="selected">Sharp (#)</option>
231 <option value="#">Sharp (#)</option>
233 [% IF ( selected_csv_separator == ' ' ) %]
234 <option value=" " selected="selected">Space ( )</option>
236 <option value=" ">Space ( )</option>
238 [% IF ( selected_csv_separator == '\t' ) %]
239 <option value="\t" selected="selected">Tabulation (\t)</option>
241 <option value="\t">Tabulation (\t)</option>
243 [% IF ( selected_csv_separator == '\n' ) %]
244 <option value="\n" selected="selected">New line (\n)</option>
246 <option value="\n">New line (\n)</option>
250 <li class="marc_specific"><label for="field_separator">Field separator: </label>
251 <select name="field_separator" id="field_separator">
252 <option value=":">Colon (:)</option>
254 [% IF ( selected_field_separator == ',' ) %]
255 <option value="," selected="selected">Comma (,)</option>
257 <option value=",">Comma (,)</option>
260 [% IF ( selected_field_separator == '|' ) %]
261 <option value="|" selected="selected">Pipe (|)</option>
263 <option value="|">Pipe (|)</option>
266 [% IF ( selected_field_separator == ';' ) %]
267 <option value=";" selected="selected">Semi-colon (;)</option>
269 <option value=";">Semi-colon (;)</option>
272 [% IF ( selected_field_separator == '#' ) %]
273 <option value="#" selected="selected">Sharp (#)</option>
275 <option value="#">Sharp (#)</option>
278 [% IF ( selected_field_separator == ' ' ) %]
279 <option value=" " selected="selected">Space ( )</option>
281 <option value=" ">Space ( )</option>
284 [% IF ( selected_field_separator == '\t' ) %]
285 <option value="\t" selected="selected">Tabulation (\t)</option>
287 <option value="\t">Tabulation (\t)</option>
289 [% IF ( selected_field_separator == '\n' ) %]
290 <option value="\n" selected="selected">New line (\n)</option>
292 <option value="\n">New line (\n)</option>
297 <li class="marc_specific"><label for="subfield_separator">Subfield separator: </label>
298 <select name="subfield_separator" id="subfield_separator">
299 <option value=":">Colon (:)</option>
301 [% IF ( selected_subfield_separator == ',' ) %]
302 <option value="," selected="selected">Comma (,)</option>
304 <option value=",">Comma (,)</option>
307 [% IF ( selected_subfield_separator == '|' ) %]
308 <option value="|" selected="selected">Pipe (|)</option>
310 <option value="|">Pipe (|)</option>
313 [% IF ( selected_subfield_separator == ';' ) %]
314 <option value=";" selected="selected">Semi-colon (;)</option>
316 <option value=";">Semi-colon (;)</option>
319 [% IF ( selected_subfield_separator == '#' ) %]
320 <option value="#" selected="selected">Sharp (#)</option>
322 <option value="#">Sharp (#)</option>
325 [% IF ( selected_subfield_separator == ' ' ) %]
326 <option value=" " selected="selected">Space ( )</option>
328 <option value=" ">Space ( )</option>
331 [% IF ( selected_subfield_separator == '\t' ) %]
332 <option value="\t" selected="selected">Tabulation (\t)</option>
334 <option value="\t">Tabulation (\t)</option>
336 [% IF ( selected_subfield_separator == '\n' ) %]
337 <option value="\n" selected="selected">New line (\n)</option>
339 <option value="\n">New line (\n)</option>
344 <li class="marc_specific"><label for="encoding">Encoding: </label>
345 <select name="encoding" id="encoding">
346 [% FOREACH encoding IN encodings %]
347 [% IF ( selected_encoding == encoding.encoding ) %]
348 <option selected="selected">[% encoding.encoding %]</option>
350 <option>[% encoding.encoding %]</option>
355 <li class="marc_specific"><label for="modify_profile_marc_content" class="required">Profile MARC fields: </label>
356 <textarea cols="50" rows="2" name="profile_marc_content" id="modify_profile_marc_content">[% selected_profile_content %]</textarea></li>
358 <li class="sql_specific">
359 <label for="modify_profile_sql_content" class="required">Profile SQL fields: </label>
360 <textarea cols="50" rows="2" name="profile_sql_content" id="modify_profile_sql_content">[% selected_profile_content %]</textarea>
363 <li class="radio"> <label for="delete">Delete selected profile ?</label>
364 <input type="checkbox" name="delete" id="delete" /></li>
369 <fieldset class="action"><input type="hidden" name="modify_profile_id" value="[% selected_profile_id %]" />
370 <input type="hidden" name="action" value="edit" />
371 <input type="submit" value="Submit" /> <a href="/cgi-bin/koha/tools/csv-profiles.pl" class="cancel">Cancel</a></fieldset>
379 <div class="yui-b noprint">
380 [% INCLUDE 'tools-menu.inc' %]
383 [% INCLUDE 'intranet-bottom.inc' %]