[% USE raw %] [% USE Asset %] [% PROCESS 'i18n.inc' %] [% SET footerjs = 1 %] [% INCLUDE 'doc-head-open.inc' %] [% FILTER collapse %] [% IF op == 'add_form' %] [% IF csv_profile %] [% tx("Modify CSV profile '{csv_profile_name}'", {csv_profile_name = csv_profile.profile }) | html %] › [% ELSE %] [% t("New CSV profile") | html %] › [% END %] [% ELSIF ( op == 'delete_confirm' ) %] [% tx("Confirm deletion of CSV profile '{csv_profile_name}'", {csv_profile_name = csv_profile.profile }) | html %] › [% END %] [% t("CSV profiles") | html %] › [% t("Tools") | html %] › [% t("Koha") | html %] [% END %] [% INCLUDE 'doc-head-close.inc' %] [% WRAPPER 'header.inc' %] [% INCLUDE 'cat-search.inc' %] [% END %] [% WRAPPER 'sub-header.inc' %] [% WRAPPER breadcrumbs %] [% WRAPPER breadcrumb_item %] Tools [% END %] [% IF op == 'add_form' || op == 'delete_confirm' %] [% WRAPPER breadcrumb_item %] CSV profiles [% END %] [% END %] [% IF op == 'add_form' %] [% IF csv_profile %] [% WRAPPER breadcrumb_item bc_active= 1 %] [% tx("Modify CSV profile '{csv_profile_name}'", {csv_profile_name = csv_profile.profile }) | html %] [% END %] [% ELSE %] [% WRAPPER breadcrumb_item bc_active= 1 %] New CSV profile [% END %] [% END %] [% ELSIF ( op == 'delete_confirm') %] [% WRAPPER breadcrumb_item bc_active= 1 %] [% tx("Confirm deletion of CSV profile '{csv_profile_name}'", {csv_profile_name = csv_profile.profile }) | html %] [% END %] [% ELSE %] [% WRAPPER breadcrumb_item bc_active= 1 %] CSV profiles [% END %] [% END %] [% END #/ WRAPPER breadcrumbs %] [% END #/ WRAPPER sub-header.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 for details. [% 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 %] [% tab_char = '\t' %] [% IF selected_separator == '\t' %] [% ELSE %] [% END %] [% new_line_char = '\n' %] [% 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 == 'late_orders' %] Export late orders [% 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 %]

[% tx("Modify CSV profile '{csv_profile_name}'", {csv_profile_name = csv_profile.profile }) | html %]

[% ELSE %]

New CSV profile

[% END %]
    [% IF csv_profile %]
  1. Profile ID: [% csv_profile.export_format_id | html %]
    2. [% END %]
  2. Required
  3. Required
  11. [% IF csv_profile.staff_only %] [% ELSE %] [% END %]
  12. 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.

  13. 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.

    For exporting late orders you must provide a profile in Template Toolkit syntax to generate the CSV file.

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

[% tx("Delete CSV profile '{csv_profile_name}'?", {csv_profile_name = 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 | html_line_break %] [% 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' %]