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                                                     </li>
 167                             <li class="sql_specific">
 168                               <label for="new_profile_sql_content" class="required">Profile SQL fields: </label>
 169                               <textarea cols="50" rows="2" name="profile_sql_content" id="new_profile_sql_content"></textarea>
 170                               <p>You have to define which fields you want to export, separated by pipes.</p>
 171                               <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>
 172                               <p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p>
 173                             </li>
 174                                                     </ol>
 175                                                 </fieldset>
 176                                                 <fieldset class="action"><input type="hidden" name="action" value="create" />
 177                                                 <input type="submit" value="Submit" /></fieldset>
 178                                             </form>
 179                                             <br style="clear:both;" />
 180 </div>
 181                                         [% IF ( existing_profiles ) %]
 182 <div id="csvedit">
 183                                         <h3>Modify or delete a CSV export profile</h3>
 184
 185                         <form action="/cgi-bin/koha/tools/csv-profiles.pl" class="validated" method="post">
 186                                                 <fieldset class="rows">
 187                             <ol>
 188                             <li><label for="modify_profile_name" class="required">Profile name: </label>
 189                                 <select id="modify_profile_name" name="profile_name" required="required" class="required" onchange="reloadPage(this)">
 190                                                         <option value="0">-- Choose One --</option>
 191                                                         [% FOREACH existing_profile IN existing_profiles %]
 192                                                         [% IF ( existing_profile.export_format_id == selected_profile_id ) %]
 193                                                         <option value="[% existing_profile.export_format_id %]" selected="selected">[% existing_profile.profile %]</option>
 194                                                         [% ELSE %]
 195                                                         <option value="[% existing_profile.export_format_id %]">[% existing_profile.profile %]</option>
 196                                                         [% END %]
 197                                                         [% END %]
 198                             </select>
 199                             <span class="required">Required</span>
 200                             </li>
 201
 202                             <li>
 203                               <label for="modify_profile_type" class="required">Profile type: </label>
 204                               <select id="modify_profile_type" name="profile_type" class="required" required="required">
 205                                 <option value="marc">MARC</option>
 206                                 [% IF selected_profile_type == "sql" %]
 207                                   <option value="sql" selected="selected">SQL</option>
 208                                 [% ELSE %]
 209                                   <option value="sql">SQL</option>
 210                                 [% END %]
 211                               </select>
 212                                 <span class="required">Required</span>
 213                             </li>
 214
 215
 216                                                     <li><label for="modify_profile_description">Profile description: </label>
 217                                                     <textarea cols="50" rows="2" name="profile_description" id="modify_profile_description">[% selected_profile_description %]</textarea></li>
 218
 219                                                     <li><label for="csv_separator">CSV separator: </label>
 220                                                     <select name="csv_separator" id="csv_separator">
 221                                                                 <option value=":">Colon (:)</option>
 222                                                                 [% IF ( selected_csv_separator == ',' ) %]
 223                                                                 <option value="," selected="selected">Comma (,)</option>
 224                                                                 [% ELSE %]
 225                                                                 <option value=",">Comma (,)</option>
 226                                                                 [% END %]
 227                                                                 [% IF ( selected_csv_separator == '|' ) %]
 228                                                                 <option value="|" selected="selected">Pipe (|)</option>
 229                                                                 [% ELSE %]
 230                                                                 <option value="|">Pipe (|)</option>
 231                                                                 [% END %]
 232                                                                 [% IF ( selected_csv_separator == ';' ) %]
 233                                                                 <option value=";" selected="selected">Semi-colon (;)</option>
 234                                                                 [% ELSE %]
 235                                                                 <option value=";">Semi-colon (;)</option>
 236                                                                 [% END %]
 237                                                                 [% IF ( selected_csv_separator == '#' ) %]
 238                                                                 <option value="#" selected="selected">Sharp (#)</option>
 239                                                                 [% ELSE %]
 240                                                                 <option value="#">Sharp (#)</option>
 241                                                                 [% END %]
 242                                                                 [% IF ( selected_csv_separator == ' ' ) %]
 243                                                                 <option value=" " selected="selected">Space ( )</option>
 244                                                                 [% ELSE %]
 245                                                                 <option value=" ">Space ( )</option>
 246                                                                 [% END %]
 247                                                                 [% IF ( selected_csv_separator == '\t' ) %]
 248                                                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 249                                                                 [% ELSE %]
 250                                                                 <option value="\t">Tabulation (\t)</option>
 251                                                                 [% END %]
 252                                                         [% IF ( selected_csv_separator == '\n' ) %]
 253                                                                 <option value="\n" selected="selected">New line (\n)</option>
 254                                                                 [% ELSE %]
 255                                                                 <option value="\n">New line (\n)</option>
 256                                                                 [% END %]
 257                             </select></li>
 258
 259                             <li class="marc_specific"><label for="field_separator">Field separator: </label>
 260                                                     <select name="field_separator" id="field_separator">
 261                                 <option value=":">Colon (:)</option>
 262
 263                                 [% IF ( selected_field_separator == ',' ) %]
 264                                 <option value="," selected="selected">Comma (,)</option>
 265                                 [% ELSE %]
 266                                 <option value=",">Comma (,)</option>
 267                                                                 [% END %]
 268
 269                                 [% IF ( selected_field_separator == '|' ) %]
 270                                 <option value="|" selected="selected">Pipe (|)</option>
 271                                 [% ELSE %]
 272                                 <option value="|">Pipe (|)</option>
 273                                 [% END %]
 274
 275                                 [% IF ( selected_field_separator == ';' ) %]
 276                                 <option value=";" selected="selected">Semi-colon (;)</option>
 277                                 [% ELSE %]
 278                                 <option value=";">Semi-colon (;)</option>
 279                                 [% END %]
 280
 281                                 [% IF ( selected_field_separator == '#' ) %]
 282                                 <option value="#" selected="selected">Sharp (#)</option>
 283                                 [% ELSE %]
 284                                 <option value="#">Sharp (#)</option>
 285                                 [% END %]
 286
 287                                 [% IF ( selected_field_separator == ' ' ) %]
 288                                 <option value=" " selected="selected">Space ( )</option>
 289                                 [% ELSE %]
 290                                 <option value=" ">Space ( )</option>
 291                                 [% END %]
 292
 293                                 [% IF ( selected_field_separator == '\t' ) %]
 294                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 295                                 [% ELSE %]
 296                                 <option value="\t">Tabulation (\t)</option>
 297                                 [% END %]
 298                                                         [% IF ( selected_field_separator == '\n' ) %]
 299                                                                 <option value="\n" selected="selected">New line (\n)</option>
 300                                                                 [% ELSE %]
 301                                                                 <option value="\n">New line (\n)</option>
 302                                                                 [% END %]
 303                                                     </select></li>
 304
 305
 306                             <li class="marc_specific"><label for="subfield_separator">Subfield separator: </label>
 307                                                     <select name="subfield_separator" id="subfield_separator">
 308                                 <option value=":">Colon (:)</option>
 309
 310                                 [% IF ( selected_subfield_separator == ',' ) %]
 311                                 <option value="," selected="selected">Comma (,)</option>
 312                                 [% ELSE %]
 313                                 <option value=",">Comma (,)</option>
 314                                 [% END %]
 315
 316                                 [% IF ( selected_subfield_separator == '|' ) %]
 317                                 <option value="|" selected="selected">Pipe (|)</option>
 318                                 [% ELSE %]
 319                                 <option value="|">Pipe (|)</option>
 320                                 [% END %]
 321
 322                                                                 [% IF ( selected_subfield_separator == ';' ) %]
 323                                 <option value=";" selected="selected">Semi-colon (;)</option>
 324                                 [% ELSE %]
 325                                 <option value=";">Semi-colon (;)</option>
 326                                 [% END %]
 327
 328                                                                 [% IF ( selected_subfield_separator == '#' ) %]
 329                                 <option value="#" selected="selected">Sharp (#)</option>
 330                                 [% ELSE %]
 331                                 <option value="#">Sharp (#)</option>
 332                                 [% END %]
 333
 334                                                                 [% IF ( selected_subfield_separator == ' ' ) %]
 335                                 <option value=" " selected="selected">Space ( )</option>
 336                                 [% ELSE %]
 337                                 <option value=" ">Space ( )</option>
 338                                 [% END %]
 339
 340                                                                 [% IF ( selected_subfield_separator == '\t' ) %]
 341                                 <option value="\t" selected="selected">Tabulation (\t)</option>
 342                                 [% ELSE %]
 343                                 <option value="\t">Tabulation (\t)</option>
 344                                 [% END %]
 345                                                         [% IF ( selected_subfield_separator == '\n' ) %]
 346                                                                 <option value="\n" selected="selected">New line (\n)</option>
 347                                                                 [% ELSE %]
 348                                                                 <option value="\n">New line (\n)</option>
 349                                 [% END %]
 350
 351                                                     </select></li>
 352
 353                             <li class="marc_specific"><label for="encoding">Encoding: </label>
 354                                                     <select name="encoding" id="encoding">
 355                                                         [% FOREACH encoding IN encodings %]
 356                                 [% IF ( selected_encoding == encoding.encoding ) %]
 357                                                             <option selected="selected">[% encoding.encoding %]</option>
 358                                                             [% ELSE %]
 359                                                             <option>[% encoding.encoding %]</option>
 360                                                             [% END %]
 361                                                         [% END %]
 362                                                     </select></li>
 363
 364                             <li class="marc_specific">
 365                                 <label for="modify_profile_marc_content" class="required">Profile MARC fields: </label>
 366                                 <textarea cols="50" rows="2" name="profile_marc_content" id="modify_profile_marc_content" class="required" required="required">[% selected_profile_content %]</textarea>
 367                                 <span class="required">Required</span>
 368                             </li>
 369
 370                             <li class="sql_specific">
 371                               <label for="modify_profile_sql_content" class="required">Profile SQL fields: </label>
 372                               <textarea cols="50" rows="2" name="profile_sql_content" id="modify_profile_sql_content">[% selected_profile_content %]</textarea>
 373                             </li>
 374
 375                                                    <li class="radio"> <label for="delete">Delete selected profile ?</label>
 376                                                     <input type="checkbox" name="delete" id="delete" /></li>
 377                                                     </ol>
 378
 379                                                 </fieldset>
 380
 381                                                 <fieldset class="action"><input type="hidden" name="modify_profile_id" value="[% selected_profile_id %]" />
 382                                                 <input type="hidden" name="action" value="edit" />
 383                                                 <input type="submit" value="Submit" /> <a href="/cgi-bin/koha/tools/csv-profiles.pl" class="cancel">Cancel</a></fieldset>
 384                                             </form>
 385 </div>
 386                                         [% END %]
 387
 388                                 </div>
 389                         </div>
 390                         </div>
 391                     <div class="yui-b noprint">
 392         [% INCLUDE 'tools-menu.inc' %]
 393     </div>
 394         </div>
 395         [% INCLUDE 'intranet-bottom.inc' %]