koha-tmpl/intranet-tmpl/prog/en/modules/tools/csv-profiles.tt

   1 [% INCLUDE 'doc-head-open.inc' %]<title>Koha &rsaquo; Tools &rsaquo; CSV export profiles</title>[% INCLUDE 'doc-head-close.inc' %]
   2 <script type="text/javascript">
   3 //<![CDATA[
   4 function reloadPage(p) {
   5         var id = p.value;
   6         if (id != 0) { document.location = "/cgi-bin/koha/tools/csv-profiles.pl?id=" + id; }
   7 }
   8      $(document).ready(function() {
   9         $('#csvexporttabs').tabs();
  10
  11         $("#profile_type").find("option:first").attr("selected", "selected");
  12         $("#csvnew").find("li.marc_specific").show();
  13         $("#csvnew").find("li.sql_specific").hide();
  14
  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");
  21             } else {
  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");
  26             }
  27         });
  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");
  34             } else {
  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");
  39             }
  40         });
  41         $("#profile_type").change();
  42         $("#modify_profile_type").change();
  43      });
  44 //]]>
  45 </script>
  46 </head>
  47
  48 <body id="tools_csv-profiles" class="tools">
  49         [% INCLUDE 'header.inc' %]
  50         [% INCLUDE 'cat-search.inc' %]
  51
  52         <div id="breadcrumbs">
  53                 <a href="/cgi-bin/koha/mainpage.pl">Home</a>
  54                 &rsaquo; <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a>
  55                 &rsaquo; CSV export profiles
  56         </div>
  57
  58         <div id="doc3" class="yui-t2">
  59                 <div id="bd">
  60                         <div id="yui-main">
  61                                 <div class="yui-b">
  62                                     [% IF ( success || error ) %]
  63                                             [% IF ( success ) %]
  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 %]
  67                         [% ELSE %]
  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 %]
  71                                             [% END %]
  72                                     [% END %]
  73 <div id="csvexporttabs" class="toptabs">
  74 <ul>
  75     <li><a href="#csvnew">New profile</a></li>
  76         [% IF ( existing_profiles ) %]
  77         [% IF ( selected_profile_id ) %]
  78     <li class="ui-tabs-active">
  79         [% ELSE %]
  80         <li>
  81          [% END %]
  82     <a href="#csvedit">Edit existing profile</a></li> [% END %]
  83 </ul>
  84         <div id="csvnew">
  85                                         <h3>New CSV export profile</h3>
  86
  87                         <form action="/cgi-bin/koha/tools/csv-profiles.pl" class="validated" method="post">
  88                                                 <fieldset class="rows">
  89                           <ol>
  90                             <li><label for="profile_name" class="required">Profile name: </label>
  91                             <input type="text" id="profile_name" name="profile_name" required="required" /></li>
  92
  93                             <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>
  98                               </select>
  99                             </li>
 100
 101                                                     <li><label for="profile_description">Profile description: </label>
 102                                                     <textarea cols="50" rows="2" name="profile_description" id="profile_description"></textarea></li>
 103
 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>
 114                                                     </select>
 115                             </li>
 116
 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>
 127                                                     </select>
 128                             </li>
 129
 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>
 140                                                     </select>
 141                             </li>
 142
 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>
 148                                                                 [% ELSE %]
 149                                                                         <option>[% encoding.encoding %]</option>
 150                                                                 [% END %]
 151                                                         [% END %]
 152                                                     </select></li>
 153
 154
 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>
 160                                                     </li>
 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>
 167                             </li>
 168                                                     </ol>
 169                                                 </fieldset>
 170                                                 <fieldset class="action"><input type="hidden" name="action" value="create" />
 171                                                 <input type="submit" value="Submit" /></fieldset>
 172                                             </form>
 173                                             <br style="clear:both;" />
 174 </div>
 175                                         [% IF ( existing_profiles ) %]
 176 <div id="csvedit">
 177                                         <h3>Modify or delete a CSV export profile</h3>
 178
 179                         <form action="/cgi-bin/koha/tools/csv-profiles.pl" class="validated" method="post">
 180                                                 <fieldset class="rows">
 181                             <ol>
 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>
 188                                                         [% ELSE %]
 189                                                         <option value="[% existing_profile.export_format_id %]">[% existing_profile.profile %]</option>
 190                                                         [% END %]
 191                                                         [% END %]
 192                                                     </select></li>
 193
 194                             <li>
 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>
 200                                 [% ELSE %]
 201                                   <option value="sql">SQL</option>
 202                                 [% END %]
 203                               </select>
 204                             </li>
 205
 206
 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>
 209
 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>
 215                                                                 [% ELSE %]
 216                                                                 <option value=",">Comma (,)</option>
 217                                                                 [% END %]
 218                                                                 [% IF ( selected_csv_separator == '|' ) %]
 219                                                                 <option value="|" selected="selected">Pipe (|)</option>
 220                                                                 [% ELSE %]
 221                                                                 <option value="|">Pipe (|)</option>
 222                                                                 [% END %]
 223                                                                 [% IF ( selected_csv_separator == ';' ) %]
 224                                                                 <option value=";" selected="selected">Semi-colon (;)</option>
 225                                                                 [% ELSE %]
 226                                                                 <option value=";">Semi-colon (;)</option>
 227                                                                 [% END %]
 228                                                                 [% IF ( selected_csv_separator == '#' ) %]
 229                                                                 <option value="#" selected="selected">Sharp (#)</option>
 230                                                                 [% ELSE %]
 231                                                                 <option value="#">Sharp (#)</option>
 232                                                                 [% END %]
 233                                                                 [% IF ( selected_csv_separator == ' ' ) %]
 234                                                                 <option value=" " selected="selected">Space ( )</option>
 235                                                                 [% ELSE %]
 236                                                                 <option value=" ">Space ( )</option>
 237                                                                 [% END %]
 238                                                                 [% IF ( selected_csv_separator == '\t' ) %]
 239                                                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 240                                                                 [% ELSE %]
 241                                                                 <option value="\t">Tabulation (\t)</option>
 242                                                                 [% END %]
 243                                                         [% IF ( selected_csv_separator == '\n' ) %]
 244                                                                 <option value="\n" selected="selected">New line (\n)</option>
 245                                                                 [% ELSE %]
 246                                                                 <option value="\n">New line (\n)</option>
 247                                                                 [% END %]
 248                             </select></li>
 249
 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>
 253
 254                                 [% IF ( selected_field_separator == ',' ) %]
 255                                 <option value="," selected="selected">Comma (,)</option>
 256                                 [% ELSE %]
 257                                 <option value=",">Comma (,)</option>
 258                                                                 [% END %]
 259
 260                                 [% IF ( selected_field_separator == '|' ) %]
 261                                 <option value="|" selected="selected">Pipe (|)</option>
 262                                 [% ELSE %]
 263                                 <option value="|">Pipe (|)</option>
 264                                 [% END %]
 265
 266                                 [% IF ( selected_field_separator == ';' ) %]
 267                                 <option value=";" selected="selected">Semi-colon (;)</option>
 268                                 [% ELSE %]
 269                                 <option value=";">Semi-colon (;)</option>
 270                                 [% END %]
 271
 272                                 [% IF ( selected_field_separator == '#' ) %]
 273                                 <option value="#" selected="selected">Sharp (#)</option>
 274                                 [% ELSE %]
 275                                 <option value="#">Sharp (#)</option>
 276                                 [% END %]
 277
 278                                 [% IF ( selected_field_separator == ' ' ) %]
 279                                 <option value=" " selected="selected">Space ( )</option>
 280                                 [% ELSE %]
 281                                 <option value=" ">Space ( )</option>
 282                                 [% END %]
 283
 284                                 [% IF ( selected_field_separator == '\t' ) %]
 285                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 286                                 [% ELSE %]
 287                                 <option value="\t">Tabulation (\t)</option>
 288                                 [% END %]
 289                                                         [% IF ( selected_field_separator == '\n' ) %]
 290                                                                 <option value="\n" selected="selected">New line (\n)</option>
 291                                                                 [% ELSE %]
 292                                                                 <option value="\n">New line (\n)</option>
 293                                                                 [% END %]
 294                                                     </select></li>
 295
 296
 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>
 300
 301                                 [% IF ( selected_subfield_separator == ',' ) %]
 302                                 <option value="," selected="selected">Comma (,)</option>
 303                                 [% ELSE %]
 304                                 <option value=",">Comma (,)</option>
 305                                 [% END %]
 306
 307                                 [% IF ( selected_subfield_separator == '|' ) %]
 308                                 <option value="|" selected="selected">Pipe (|)</option>
 309                                 [% ELSE %]
 310                                 <option value="|">Pipe (|)</option>
 311                                 [% END %]
 312
 313                                                                 [% IF ( selected_subfield_separator == ';' ) %]
 314                                 <option value=";" selected="selected">Semi-colon (;)</option>
 315                                 [% ELSE %]
 316                                 <option value=";">Semi-colon (;)</option>
 317                                 [% END %]
 318
 319                                                                 [% IF ( selected_subfield_separator == '#' ) %]
 320                                 <option value="#" selected="selected">Sharp (#)</option>
 321                                 [% ELSE %]
 322                                 <option value="#">Sharp (#)</option>
 323                                 [% END %]
 324
 325                                                                 [% IF ( selected_subfield_separator == ' ' ) %]
 326                                 <option value=" " selected="selected">Space ( )</option>
 327                                 [% ELSE %]
 328                                 <option value=" ">Space ( )</option>
 329                                 [% END %]
 330
 331                                                                 [% IF ( selected_subfield_separator == '\t' ) %]
 332                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 333                                 [% ELSE %]
 334                                 <option value="\t">Tabulation (\t)</option>
 335                                 [% END %]
 336                                                         [% IF ( selected_subfield_separator == '\n' ) %]
 337                                                                 <option value="\n" selected="selected">New line (\n)</option>
 338                                                                 [% ELSE %]
 339                                                                 <option value="\n">New line (\n)</option>
 340                                 [% END %]
 341
 342                                                     </select></li>
 343
 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>
 349                                                             [% ELSE %]
 350                                                             <option>[% encoding.encoding %]</option>
 351                                                             [% END %]
 352                                                         [% END %]
 353                                                     </select></li>
 354
 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>
 357
 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>
 361                             </li>
 362
 363                                                    <li class="radio"> <label for="delete">Delete selected profile ?</label>
 364                                                     <input type="checkbox" name="delete" id="delete" /></li>
 365                                                     </ol>
 366
 367                                                 </fieldset>
 368
 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>
 372                                             </form>
 373 </div>
 374                                         [% END %]
 375
 376                                 </div>
 377                         </div>
 378                         </div>
 379                     <div class="yui-b noprint">
 380         [% INCLUDE 'tools-menu.inc' %]
 381     </div>
 382         </div>
 383         [% INCLUDE 'intranet-bottom.inc' %]