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>
  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>
  94                             </li>
  95
  96                             <li>
  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>
 101                               </select>
 102                               <span class="required">Required</span>
 103                             </li>
 104
 105                                                     <li><label for="profile_description">Profile description: </label>
 106                                                     <textarea cols="50" rows="2" name="profile_description" id="profile_description"></textarea></li>
 107
 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>
 118                                                     </select>
 119                             </li>
 120
 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>
 131                                                     </select>
 132                             </li>
 133
 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>
 144                                                     </select>
 145                             </li>
 146
 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>
 152                                                                 [% ELSE %]
 153                                                                         <option>[% encoding.encoding %]</option>
 154                                                                 [% END %]
 155                                                         [% END %]
 156                                                     </select></li>
 157
 158
 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>
 167                                                     </li>
 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>
 174                             </li>
 175                                                     </ol>
 176                                                 </fieldset>
 177                                                 <fieldset class="action"><input type="hidden" name="action" value="create" />
 178                                                 <input type="submit" value="Submit" /></fieldset>
 179                                             </form>
 180                                             <br style="clear:both;" />
 181 </div>
 182                                         [% IF ( existing_profiles ) %]
 183 <div id="csvedit">
 184                                         <h3>Modify or delete a CSV export profile</h3>
 185
 186                         <form action="/cgi-bin/koha/tools/csv-profiles.pl" class="validated" method="post">
 187                                                 <fieldset class="rows">
 188                             <ol>
 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>
 195                                                         [% ELSE %]
 196                                                         <option value="[% existing_profile.export_format_id %]">[% existing_profile.profile %]</option>
 197                                                         [% END %]
 198                                                         [% END %]
 199                             </select>
 200                             <span class="required">Required</span>
 201                             </li>
 202
 203                             <li>
 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>
 209                                 [% ELSE %]
 210                                   <option value="sql">SQL</option>
 211                                 [% END %]
 212                               </select>
 213                                 <span class="required">Required</span>
 214                             </li>
 215
 216
 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>
 219
 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>
 225                                                                 [% ELSE %]
 226                                                                 <option value=",">Comma (,)</option>
 227                                                                 [% END %]
 228                                                                 [% IF ( selected_csv_separator == '|' ) %]
 229                                                                 <option value="|" selected="selected">Pipe (|)</option>
 230                                                                 [% ELSE %]
 231                                                                 <option value="|">Pipe (|)</option>
 232                                                                 [% END %]
 233                                                                 [% IF ( selected_csv_separator == ';' ) %]
 234                                                                 <option value=";" selected="selected">Semi-colon (;)</option>
 235                                                                 [% ELSE %]
 236                                                                 <option value=";">Semi-colon (;)</option>
 237                                                                 [% END %]
 238                                                                 [% IF ( selected_csv_separator == '#' ) %]
 239                                                                 <option value="#" selected="selected">Sharp (#)</option>
 240                                                                 [% ELSE %]
 241                                                                 <option value="#">Sharp (#)</option>
 242                                                                 [% END %]
 243                                                                 [% IF ( selected_csv_separator == ' ' ) %]
 244                                                                 <option value=" " selected="selected">Space ( )</option>
 245                                                                 [% ELSE %]
 246                                                                 <option value=" ">Space ( )</option>
 247                                                                 [% END %]
 248                                                                 [% IF ( selected_csv_separator == '\t' ) %]
 249                                                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 250                                                                 [% ELSE %]
 251                                                                 <option value="\t">Tabulation (\t)</option>
 252                                                                 [% END %]
 253                                                         [% IF ( selected_csv_separator == '\n' ) %]
 254                                                                 <option value="\n" selected="selected">New line (\n)</option>
 255                                                                 [% ELSE %]
 256                                                                 <option value="\n">New line (\n)</option>
 257                                                                 [% END %]
 258                             </select></li>
 259
 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>
 263
 264                                 [% IF ( selected_field_separator == ',' ) %]
 265                                 <option value="," selected="selected">Comma (,)</option>
 266                                 [% ELSE %]
 267                                 <option value=",">Comma (,)</option>
 268                                                                 [% END %]
 269
 270                                 [% IF ( selected_field_separator == '|' ) %]
 271                                 <option value="|" selected="selected">Pipe (|)</option>
 272                                 [% ELSE %]
 273                                 <option value="|">Pipe (|)</option>
 274                                 [% END %]
 275
 276                                 [% IF ( selected_field_separator == ';' ) %]
 277                                 <option value=";" selected="selected">Semi-colon (;)</option>
 278                                 [% ELSE %]
 279                                 <option value=";">Semi-colon (;)</option>
 280                                 [% END %]
 281
 282                                 [% IF ( selected_field_separator == '#' ) %]
 283                                 <option value="#" selected="selected">Sharp (#)</option>
 284                                 [% ELSE %]
 285                                 <option value="#">Sharp (#)</option>
 286                                 [% END %]
 287
 288                                 [% IF ( selected_field_separator == ' ' ) %]
 289                                 <option value=" " selected="selected">Space ( )</option>
 290                                 [% ELSE %]
 291                                 <option value=" ">Space ( )</option>
 292                                 [% END %]
 293
 294                                 [% IF ( selected_field_separator == '\t' ) %]
 295                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 296                                 [% ELSE %]
 297                                 <option value="\t">Tabulation (\t)</option>
 298                                 [% END %]
 299                                                         [% IF ( selected_field_separator == '\n' ) %]
 300                                                                 <option value="\n" selected="selected">New line (\n)</option>
 301                                                                 [% ELSE %]
 302                                                                 <option value="\n">New line (\n)</option>
 303                                                                 [% END %]
 304                                                     </select></li>
 305
 306
 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>
 310
 311                                 [% IF ( selected_subfield_separator == ',' ) %]
 312                                 <option value="," selected="selected">Comma (,)</option>
 313                                 [% ELSE %]
 314                                 <option value=",">Comma (,)</option>
 315                                 [% END %]
 316
 317                                 [% IF ( selected_subfield_separator == '|' ) %]
 318                                 <option value="|" selected="selected">Pipe (|)</option>
 319                                 [% ELSE %]
 320                                 <option value="|">Pipe (|)</option>
 321                                 [% END %]
 322
 323                                                                 [% IF ( selected_subfield_separator == ';' ) %]
 324                                 <option value=";" selected="selected">Semi-colon (;)</option>
 325                                 [% ELSE %]
 326                                 <option value=";">Semi-colon (;)</option>
 327                                 [% END %]
 328
 329                                                                 [% IF ( selected_subfield_separator == '#' ) %]
 330                                 <option value="#" selected="selected">Sharp (#)</option>
 331                                 [% ELSE %]
 332                                 <option value="#">Sharp (#)</option>
 333                                 [% END %]
 334
 335                                                                 [% IF ( selected_subfield_separator == ' ' ) %]
 336                                 <option value=" " selected="selected">Space ( )</option>
 337                                 [% ELSE %]
 338                                 <option value=" ">Space ( )</option>
 339                                 [% END %]
 340
 341                                                                 [% IF ( selected_subfield_separator == '\t' ) %]
 342                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 343                                 [% ELSE %]
 344                                 <option value="\t">Tabulation (\t)</option>
 345                                 [% END %]
 346                                                         [% IF ( selected_subfield_separator == '\n' ) %]
 347                                                                 <option value="\n" selected="selected">New line (\n)</option>
 348                                                                 [% ELSE %]
 349                                                                 <option value="\n">New line (\n)</option>
 350                                 [% END %]
 351
 352                                                     </select></li>
 353
 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>
 359                                                             [% ELSE %]
 360                                                             <option>[% encoding.encoding %]</option>
 361                                                             [% END %]
 362                                                         [% END %]
 363                                                     </select></li>
 364
 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>
 369                             </li>
 370
 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>
 374                             </li>
 375
 376                                                    <li class="radio"> <label for="delete">Delete selected profile ?</label>
 377                                                     <input type="checkbox" name="delete" id="delete" /></li>
 378                                                     </ol>
 379
 380                                                 </fieldset>
 381
 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>
 385                                             </form>
 386 </div>
 387                                         [% END %]
 388
 389                                 </div>
 390                         </div>
 391                         </div>
 392                     <div class="yui-b noprint">
 393         [% INCLUDE 'tools-menu.inc' %]
 394     </div>
 395         </div>
 396         [% INCLUDE 'intranet-bottom.inc' %]