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                 $("#csvnew li.sql_specific").hide();
  19             } else {
  20                 $("#csvnew li.marc_specific").hide();
  21                 $("#csvnew li.sql_specific").show();
  22             }
  23         });
  24         $("#modify_profile_type").change(function(){
  25             if ( $(this).find("option:selected").val() == "marc" ) {
  26                 $("#csvedit li.marc_specific").show();
  27                 $("#csvedit li.sql_specific").hide();
  28             } else {
  29                 $("#csvedit li.marc_specific").hide();
  30                 $("#csvedit li.sql_specific").show();
  31             }
  32         });
  33         $("#modify_profile_type").change();
  34      });
  35 //]]>
  36 </script>
  37 </head>
  38
  39 <body id="tools_csv-profiles" class="tools">
  40         [% INCLUDE 'header.inc' %]
  41         [% INCLUDE 'cat-search.inc' %]
  42
  43         <div id="breadcrumbs">
  44                 <a href="/cgi-bin/koha/mainpage.pl">Home</a>
  45                 &rsaquo; <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a>
  46                 &rsaquo; CSV export profiles
  47         </div>
  48
  49         <div id="doc3" class="yui-t2">
  50                 <div id="bd">
  51                         <div id="yui-main">
  52                                 <div class="yui-b">
  53                                     [% IF ( success || error ) %]
  54                                             [% IF ( success ) %]
  55         [% IF ( action == 'create' ) %]<div class="dialog message">The new CSV profile "[% profile_name %]" has been successfully created.</div>[% END %]
  56         [% IF ( action == 'edit' ) %]<div class="dialog message">The CSV profile has been successfully modified.</div>[% END %]
  57         [% IF ( action == 'delete' ) %]<div class="dialog message">The CSV profile has been successfully deleted.</div>[% END %]
  58                         [% ELSE %]
  59         [% IF ( action == 'create' ) %]<div class="dialog alert">The new CSV profile "[% profile_name %]" has not been created.</div>[% END %]
  60         [% IF ( action == 'edit' ) %]<div class="dialog alert">The CSV profile has not been modified.</div>[% END %]
  61         [% IF ( action == 'delete' ) %]<div class="dialog alert">The CSV profile has not been deleted.</div>[% END %]
  62                                             [% END %]
  63                                     [% END %]
  64 <div id="csvexporttabs" class="toptabs">
  65 <ul>
  66     <li><a href="#csvnew">New profile</a></li>
  67         [% IF ( existing_profiles ) %]
  68         [% IF ( selected_profile_id ) %]
  69         <li class="ui-tabs-selected">
  70         [% ELSE %]
  71         <li>
  72          [% END %]
  73     <a href="#csvedit">Edit existing profile</a></li> [% END %]
  74 </ul>
  75         <div id="csvnew">
  76                                         <h3>New CSV export profile</h3>
  77
  78                                              <form action="/cgi-bin/koha/tools/csv-profiles.pl" method="post">
  79                                                 <fieldset class="rows">
  80                           <ol>
  81                             <li><label for="profile_name" class="required">Profile name: </label>
  82                                                     <input type="text" id="profile_name" name="profile_name" /></li>
  83
  84                             <li>
  85                               <label for="profile_type" class="required">Profile type: </label>
  86                               <select id="profile_type" name="profile_type">
  87                                 <option value="marc" selected="selected">MARC</option>
  88                                 <option value="sql">SQL</option>
  89                               </select>
  90                             </li>
  91
  92                                                     <li><label for="profile_description">Profile description: </label>
  93                                                     <textarea cols="50" rows="2" name="profile_description" id="profile_description"></textarea></li>
  94
  95                                                     <li><label for="new_csv_separator">CSV separator: </label>
  96                                                     <select name="csv_separator" id="new_csv_separator">
  97                                                         <option value=":">Colon (:)</option>
  98                                                         <option value="," selected="selected">Comma (,)</option>
  99                                                         <option value="|">Pipe (|)</option>
 100                                                         <option value=";">Semi-colon (;)</option>
 101                                                         <option value="#">Sharp (#)</option>
 102                                                         <option value=" ">Space ( )</option>
 103                                                         <option value="\t">Tabulation (\t)</option>
 104                                                         <option value="\n">New line (\n)</option>
 105                                                     </select>
 106                             </li>
 107
 108                             <li class="marc_specific"><label for="new_field_separator">Field separator: </label>
 109                                                     <select name="field_separator" id="new_field_separator">
 110                                                         <option value=":">Colon (:)</option>
 111                                                         <option value=",">Comma (,)</option>
 112                                                         <option value="|">Pipe (|)</option>
 113                                                         <option value=";">Semi-colon (;)</option>
 114                                                         <option value="#" selected="selected">Sharp (#)</option>
 115                                                         <option value=" ">Space ( )</option>
 116                                                         <option value="\t">Tabulation (\t)</option>
 117                                                         <option value="\n">New line (\n)</option>
 118                                                     </select>
 119                             </li>
 120
 121                                                     <li class="marc_specific"><label for="new_subfield_separator">Subfield separator: </label>
 122                                                     <select name="subfield_separator" id="new_subfield_separator">
 123                                                         <option value=":">Colon (:)</option>
 124                                                         <option value=",">Comma (,)</option>
 125                                                         <option value="|" selected="selected">Pipe (|)</option>
 126                                                         <option value=";">Semi-colon (;)</option>
 127                                                         <option value="#">Sharp (#)</option>
 128                                                         <option value=" ">Space ( )</option>
 129                                                         <option value="\t">Tabulation (\t)</option>
 130                                                         <option value="\n">New line (\n)</option>
 131                                                     </select>
 132                             </li>
 133
 134                                                     <li class="marc_specific"><label for="new_encoding">Encoding: </label>
 135                                                     <select name="encoding" id="new_encoding">
 136                                                         [% FOREACH encoding IN encodings %]
 137                                 [% IF ( encoding.encoding == 'utf8' ) %]
 138                                                                         <option selected="selected">[% encoding.encoding %]</option>
 139                                                                 [% ELSE %]
 140                                                                         <option>[% encoding.encoding %]</option>
 141                                                                 [% END %]
 142                                                         [% END %]
 143                                                     </select></li>
 144
 145
 146                             <li class="marc_specific"><label for="new_profile_marc_content">Profile MARC fields: </label>
 147                                                     <textarea cols="50" rows="2" name="profile_marc_content" id="new_profile_marc_content"></textarea>
 148                                                     <p>You have to define which fields or subfields you want to export, separated by pipes.</p>
 149                             <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>
 150                                                     <p>Example: Personal name=200|Entry element=210$a|300|009</p>
 151                                                     </li>
 152                             <li class="sql_specific">
 153                               <label for="new_profile_sql_content">Profile SQL fields: </label>
 154                               <textarea cols="50" rows="2" name="profile_sql_content" id="new_profile_sql_content"></textarea>
 155                               <p>You have to define which fields you want to export, separated by pipes.</p>
 156                               <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>
 157                               <p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p>
 158                             </li>
 159                                                     </ol>
 160                                                 </fieldset>
 161                                                 <fieldset class="action"><input type="hidden" name="action" value="create" />
 162                                                 <input type="submit" value="Submit" /></fieldset>
 163                                             </form>
 164                                             <br style="clear:both;" />
 165 </div>
 166                                         [% IF ( existing_profiles ) %]
 167 <div id="csvedit">
 168                                         <h3>Modify or delete a CSV export profile</h3>
 169
 170                                             <form action="/cgi-bin/koha/tools/csv-profiles.pl" method="post">
 171                                                 <fieldset class="rows">
 172                             <ol>
 173                             <li><label for="modify_profile_name">Profile name: </label>
 174                                                     <select id="modify_profile_name" name="profile_name" onchange="javascript:reloadPage(this)">
 175                                                         <option value="0">-- Choose One --</option>
 176                                                         [% FOREACH existing_profile IN existing_profiles %]
 177                                                         [% IF ( existing_profile.export_format_id == selected_profile_id ) %]
 178                                                         <option value="[% existing_profile.export_format_id %]" selected="selected">[% existing_profile.profile %]</option>
 179                                                         [% ELSE %]
 180                                                         <option value="[% existing_profile.export_format_id %]">[% existing_profile.profile %]</option>
 181                                                         [% END %]
 182                                                         [% END %]
 183                                                     </select></li>
 184
 185                             <li>
 186                               <label for="modify_profile_type">Profile type: </label>
 187                               <select id="modify_profile_type" name="profile_type">
 188                                 <option value="marc">MARC</option>
 189                                 [% IF selected_profile_type == "sql" %]
 190                                   <option value="sql" selected="selected">SQL</option>
 191                                 [% ELSE %]
 192                                   <option value="sql">SQL</option>
 193                                 [% END %]
 194                               </select>
 195                             </li>
 196
 197
 198                                                     <li><label for="modify_profile_description">Profile description: </label>
 199                                                     <textarea cols="50" rows="2" name="profile_description" id="modify_profile_description">[% selected_profile_description %]</textarea></li>
 200
 201                                                     <li><label for="csv_separator">CSV separator: </label>
 202                                                     <select name="csv_separator" id="csv_separator">
 203                                                                 <option value=":">Colon (:)</option>
 204                                                                 [% IF ( selected_csv_separator == ',' ) %]
 205                                                                 <option value="," selected="selected">Comma (,)</option>
 206                                                                 [% ELSE %]
 207                                                                 <option value=",">Comma (,)</option>
 208                                                                 [% END %]
 209                                                                 [% IF ( selected_csv_separator == '|' ) %]
 210                                                                 <option value="|" selected="selected">Pipe (|)</option>
 211                                                                 [% ELSE %]
 212                                                                 <option value="|">Pipe (|)</option>
 213                                                                 [% END %]
 214                                                                 [% IF ( selected_csv_separator == ';' ) %]
 215                                                                 <option value=";" selected="selected">Semi-colon (;)</option>
 216                                                                 [% ELSE %]
 217                                                                 <option value=";">Semi-colon (;)</option>
 218                                                                 [% END %]
 219                                                                 [% IF ( selected_csv_separator == '#' ) %]
 220                                                                 <option value="#" selected="selected">Sharp (#)</option>
 221                                                                 [% ELSE %]
 222                                                                 <option value="#">Sharp (#)</option>
 223                                                                 [% END %]
 224                                                                 [% IF ( selected_csv_separator == ' ' ) %]
 225                                                                 <option value=" " selected="selected">Space ( )</option>
 226                                                                 [% ELSE %]
 227                                                                 <option value=" ">Space ( )</option>
 228                                                                 [% END %]
 229                                                                 [% IF ( selected_csv_separator == '\t' ) %]
 230                                                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 231                                                                 [% ELSE %]
 232                                                                 <option value="\t">Tabulation (\t)</option>
 233                                                                 [% END %]
 234                                                         [% IF ( selected_csv_separator == '\n' ) %]
 235                                                                 <option value="\n" selected="selected">New line (\n)</option>
 236                                                                 [% ELSE %]
 237                                                                 <option value="\n">New line (\n)</option>
 238                                                                 [% END %]
 239                             </select></li>
 240
 241                                                     <li class="marc_specific"><label for="field_separator">Field separator: </label>
 242                                                     <select name="field_separator" id="field_separator">
 243                                 <option value=":">Colon (:)</option>
 244
 245                                 [% IF ( selected_field_separator == ',' ) %]
 246                                 <option value="," selected="selected">Comma (,)</option>
 247                                 [% ELSE %]
 248                                 <option value=",">Comma (,)</option>
 249                                                                 [% END %]
 250
 251                                 [% IF ( selected_field_separator == '|' ) %]
 252                                 <option value="|" selected="selected">Pipe (|)</option>
 253                                 [% ELSE %]
 254                                 <option value="|">Pipe (|)</option>
 255                                 [% END %]
 256
 257                                 [% IF ( selected_field_separator == ';' ) %]
 258                                 <option value=";" selected="selected">Semi-colon (;)</option>
 259                                 [% ELSE %]
 260                                 <option value=";">Semi-colon (;)</option>
 261                                 [% END %]
 262
 263                                 [% IF ( selected_field_separator == '#' ) %]
 264                                 <option value="#" selected="selected">Sharp (#)</option>
 265                                 [% ELSE %]
 266                                 <option value="#">Sharp (#)</option>
 267                                 [% END %]
 268
 269                                 [% IF ( selected_field_separator == ' ' ) %]
 270                                 <option value=" " selected="selected">Space ( )</option>
 271                                 [% ELSE %]
 272                                 <option value=" ">Space ( )</option>
 273                                 [% END %]
 274
 275                                 [% IF ( selected_field_separator == '\t' ) %]
 276                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 277                                 [% ELSE %]
 278                                 <option value="\t">Tabulation (\t)</option>
 279                                 [% END %]
 280                                                         [% IF ( selected_field_separator == '\n' ) %]
 281                                                                 <option value="\n" selected="selected">New line (\n)</option>
 282                                                                 [% ELSE %]
 283                                                                 <option value="\n">New line (\n)</option>
 284                                                                 [% END %]
 285                                                     </select></li>
 286
 287
 288                                                     <li class="marc_specific"><label for="subfield_separator">Subfield separator: </label>
 289                                                     <select name="subfield_separator" id="subfield_separator">
 290                                 <option value=":">Colon (:)</option>
 291
 292                                 [% IF ( selected_subfield_separator == ',' ) %]
 293                                 <option value="," selected="selected">Comma (,)</option>
 294                                 [% ELSE %]
 295                                 <option value=",">Comma (,)</option>
 296                                 [% END %]
 297
 298                                 [% IF ( selected_subfield_separator == '|' ) %]
 299                                 <option value="|" selected="selected">Pipe (|)</option>
 300                                 [% ELSE %]
 301                                 <option value="|">Pipe (|)</option>
 302                                 [% END %]
 303
 304                                                                 [% IF ( selected_subfield_separator == ';' ) %]
 305                                 <option value=";" selected="selected">Semi-colon (;)</option>
 306                                 [% ELSE %]
 307                                 <option value=";">Semi-colon (;)</option>
 308                                 [% END %]
 309
 310                                                                 [% IF ( selected_subfield_separator == '#' ) %]
 311                                 <option value="#" selected="selected">Sharp (#)</option>
 312                                 [% ELSE %]
 313                                 <option value="#">Sharp (#)</option>
 314                                 [% END %]
 315
 316                                                                 [% IF ( selected_subfield_separator == ' ' ) %]
 317                                 <option value=" " selected="selected">Space ( )</option>
 318                                 [% ELSE %]
 319                                 <option value=" ">Space ( )</option>
 320                                 [% END %]
 321
 322                                                                 [% IF ( selected_subfield_separator == '\t' ) %]
 323                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 324                                 [% ELSE %]
 325                                 <option value="\t">Tabulation (\t)</option>
 326                                 [% END %]
 327                                                         [% IF ( selected_subfield_separator == '\n' ) %]
 328                                                                 <option value="\n" selected="selected">New line (\n)</option>
 329                                                                 [% ELSE %]
 330                                                                 <option value="\n">New line (\n)</option>
 331                                 [% END %]
 332
 333                                                     </select></li>
 334
 335                                                     <li class="marc_specific"><label for="encoding">Encoding: </label>
 336                                                     <select name="encoding" id="encoding">
 337                                                         [% FOREACH encoding IN encodings %]
 338                                 [% IF ( selected_encoding == encoding.encoding ) %]
 339                                                             <option selected="selected">[% encoding.encoding %]</option>
 340                                                             [% ELSE %]
 341                                                             <option>[% encoding.encoding %]</option>
 342                                                             [% END %]
 343                                                         [% END %]
 344                                                     </select></li>
 345
 346                             <li class="marc_specific"><label for="modify_profile_marc_content">Profile MARC fields: </label>
 347                                                     <textarea cols="50" rows="2" name="profile_marc_content" id="modify_profile_marc_content">[% selected_profile_content %]</textarea></li>
 348
 349                             <li class="sql_specific">
 350                               <label for="modify_profile_sql_content">Profile SQL fields: </label>
 351                               <textarea cols="50" rows="2" name="profile_sql_content" id="modify_profile_sql_content">[% selected_profile_content %]</textarea>
 352                             </li>
 353
 354                                                    <li class="radio"> <label for="delete">Delete selected profile ?</label>
 355                                                     <input type="checkbox" name="delete" id="delete" /></li>
 356                                                     </ol>
 357
 358                                                 </fieldset>
 359
 360                                                 <fieldset class="action"><input type="hidden" name="modify_profile_id" value="[% selected_profile_id %]" />
 361                                                 <input type="hidden" name="action" value="edit" />
 362                                                 <input type="submit" value="Submit" /> <a href="/cgi-bin/koha/tools/csv-profiles.pl" class="cancel">Cancel</a></fieldset>
 363                                             </form>
 364 </div>
 365                                         [% END %]
 366
 367                                 </div>
 368                         </div>
 369                         </div>
 370                     <div class="yui-b noprint">
 371         [% INCLUDE 'tools-menu.inc' %]
 372     </div>
 373         </div>
 374         [% INCLUDE 'intranet-bottom.inc' %]