|
Lines 101-106
function reloadPage(p) {
Link Here
|
| 101 |
[% END %] |
101 |
[% END %] |
| 102 |
[% END %] |
102 |
[% END %] |
| 103 |
|
103 |
|
|
|
104 |
[% BLOCK type_description %] |
| 105 |
[% IF type_code == 'marc' %] MARC for export records |
| 106 |
[% ELSIF type_code == 'late_issues' %] SQL for late serial issues claims |
| 107 |
[% ELSIF type_code == 'export_basket' %] SQL for basket export in acquisition |
| 108 |
[% ELSE %] Uknown type |
| 109 |
[% END %] |
| 110 |
[% END %] |
| 111 |
|
| 104 |
[% IF op == 'add_form' %] |
112 |
[% IF op == 'add_form' %] |
| 105 |
[% IF csv_profile %] |
113 |
[% IF csv_profile %] |
| 106 |
<h1>Modify a CSV profile</h1> |
114 |
<h1>Modify a CSV profile</h1> |
|
Lines 124-135
function reloadPage(p) {
Link Here
|
| 124 |
<li> |
132 |
<li> |
| 125 |
<label for="type" class="required">Profile type: </label> |
133 |
<label for="type" class="required">Profile type: </label> |
| 126 |
<select id="type" name="type"> |
134 |
<select id="type" name="type"> |
| 127 |
[% IF csv_profile.type == 'sql' %] |
135 |
[% FOREACH type IN [ 'marc' 'late_issues' 'export_basket'] %] |
| 128 |
<option value="marc">MARC</option> |
136 |
[% IF csv_profile.type == type %] |
| 129 |
<option value="sql" selected="selected">SQL</option> |
137 |
<option value="[% type %]" selected="selected">[% PROCESS type_description type_code = type %]</option> |
| 130 |
[% ELSE %] |
138 |
[% ELSE %] |
| 131 |
<option value="marc" selected="selected">MARC</option> |
139 |
<option value="[% type %]">[% PROCESS type_description type_code = type %]</option> |
| 132 |
<option value="sql">SQL</option> |
140 |
[% END %] |
| 133 |
[% END %] |
141 |
[% END %] |
| 134 |
</select> |
142 |
</select> |
| 135 |
<span class="required">Required</span> |
143 |
<span class="required">Required</span> |
|
Lines 182-192
function reloadPage(p) {
Link Here
|
| 182 |
</li> |
190 |
</li> |
| 183 |
|
191 |
|
| 184 |
<li class="sql_specific"> |
192 |
<li class="sql_specific"> |
| 185 |
<label for="sql_content" class="required">Profile SQL fields: </label> |
193 |
<label for="late_issues_content" class="required">Profile SQL fields: </label> |
| 186 |
<textarea cols="50" rows="2" name="sql_content" id="sql_content">[% csv_profile.content %]</textarea> |
194 |
<textarea cols="50" rows="2" name="sql_content" id="sql_content">[% csv_profile.content %]</textarea> |
| 187 |
<p>You have to define which fields you want to export, separated by pipes.</p> |
195 |
<p>You have to define which fields you want to export, separated by pipes.</p> |
| 188 |
<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> |
196 |
<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> |
| 189 |
<p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p> |
197 |
<p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p> |
|
|
198 |
<p>For late issues claims you can use data from following tables: serial, subscription, biblio, biblioitems and aqbookseller.</p> |
| 199 |
<p>For basket exports you can use data from following tables: biblio, biblioitems, aqorders, aqbudgets and aqbasket.</p> |
| 190 |
</li> |
200 |
</li> |
| 191 |
</ol> |
201 |
</ol> |
| 192 |
</fieldset> |
202 |
</fieldset> |
|
Lines 243-253
function reloadPage(p) {
Link Here
|
| 243 |
<td>[% csv_profile.description %]</td> |
253 |
<td>[% csv_profile.description %]</td> |
| 244 |
<td>[% csv_profile.content %]</td> |
254 |
<td>[% csv_profile.content %]</td> |
| 245 |
<td>[% csv_profile.csv_separator %]</td> |
255 |
<td>[% csv_profile.csv_separator %]</td> |
| 246 |
[% IF csv_profile.type == 'sql' %] |
256 |
<td>[% PROCESS type_description type_code = csv_profile.type %]</td> |
| 247 |
<td>SQL</td> |
|
|
| 248 |
[% ELSE %] |
| 249 |
<td>MARC</td> |
| 250 |
[% END %] |
| 251 |
<td><a href="/cgi-bin/koha/tools/csv-profiles.pl?op=add_form&export_format_id=[% csv_profile.export_format_id %]">Edit</a></td> |
257 |
<td><a href="/cgi-bin/koha/tools/csv-profiles.pl?op=add_form&export_format_id=[% csv_profile.export_format_id %]">Edit</a></td> |
| 252 |
<td><a href="/cgi-bin/koha/tools/csv-profiles.pl?op=delete_confirm&export_format_id=[% csv_profile.export_format_id %]">Delete</a></td> |
258 |
<td><a href="/cgi-bin/koha/tools/csv-profiles.pl?op=delete_confirm&export_format_id=[% csv_profile.export_format_id %]">Delete</a></td> |
| 253 |
</tr> |
259 |
</tr> |