[% USE raw %] [% USE Asset %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] Koha › Tools › CSV export profiles [% INCLUDE 'doc-head-close.inc' %] [% INCLUDE 'header.inc' %] [% INCLUDE 'cat-search.inc' %]
[% FOR m IN messages %]
[% SWITCH m.code %] [% CASE 'error_on_update' %] An error occurred when updating this CSV profile. Perhaps it already exists. [% CASE 'error_on_insert' %] An error occurred when adding this CSV profile. [% CASE 'error_on_delete' %] An error occurred when deleting this CSV profile. Check the logs. [% CASE 'success_on_update' %] CSV profile updated successfully. [% CASE 'success_on_insert' %] CSV profile added successfully. [% CASE 'success_on_delete' %] CSV profile deleted successfully. [% CASE 'already_exists' %] This CSV profile already exists. [% CASE %] [% m.code | html %] [% END %]
[% END %] [% BLOCK list_separator_options %] [% IF selected_separator == ',' %] [% ELSE %] [% END %] [% IF selected_separator == '|' %] [% ELSE %] [% END %] [% IF selected_separator == ';' %] [% ELSE %] [% END %] [% IF selected_separator == '#' %] [% ELSE %] [% END %] [% IF selected_separator == ' ' %] [% ELSE %] [% END %] [% IF selected_separator == '\t' %] [% ELSE %] [% END %] [% IF selected_separator == '\n' %] [% ELSE %] [% END %] [% END %] [% BLOCK type_description %] [% IF type_code == 'marc' %] MARC [% ELSIF type_code == 'sql' %] SQL [% ELSE %] Unknown type [% END %] [% END %] [% BLOCK used_for_description %] [% IF used_for_code == 'export_records' %] Export records [% ELSIF used_for_code == 'late_issues' %] Late serial issues claims [% ELSIF used_for_code == 'export_basket' %] Basket export in acquisition [% ELSIF used_for_code == 'export_lost_items' %] Export lost items in report [% ELSE %] Unknown usage [% END %] [% END %] [% IF op == 'add_form' %] [% IF csv_profile %]

Modify a CSV profile

[% ELSE %]

New CSV profile

[% END %]
    [% IF csv_profile %]
  1. Profile ID: [% csv_profile.export_format_id | html %]
  2. [% END %]
  3. Required
  4. Required
  5. Required

    You have to define which fields or subfields you want to export, separated by pipes.

    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.

    Example: Personal name=200|Entry element=210$a|300|009

    You can use Template Toolkit tags too. See the help page for more information.

  6. You have to define which fields you want to export, separated by pipes.

    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.

    Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq

    For late issues claims you can use data from following tables: serial, subscription, biblio, biblioitems and aqbookseller.

    For basket exports you can use data from following tables: biblio, biblioitems, aqorders, aqbudgets and aqbasket.

Cancel
[% END %] [% IF op == 'delete_confirm' %]
[% IF csv_profile %]

Delete CSV Profile "[% csv_profile.profile | html %]?"

[% ELSE %] This CSV Profile does not exist. [% END %]
[% END %] [% IF op == 'list' %]

CSV profiles

[% IF csv_profiles %] [% FOREACH csv_profile IN csv_profiles %] [% END %]
CSV profile ID Name Description Content CSV separator CSV type Usage Actions
[% csv_profile.export_format_id | html %] [% csv_profile.profile | html %] [% csv_profile.description | html %] [% csv_profile.content | html %] [% csv_profile.csv_separator | html %] [% PROCESS type_description type_code = csv_profile.type %] [% PROCESS used_for_description used_for_code = csv_profile.used_for %] Edit Delete
[% ELSE %] There is no CSV profile defined. Create a new CSV profile. [% END %] [% END %]
[% MACRO jsinclude BLOCK %] [% Asset.js("js/tools-menu.js") | $raw %] [% END %] [% INCLUDE 'intranet-bottom.inc' %]