[% 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 %] [% 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 for export records [% ELSIF type_code == 'late_issues' %] SQL for late serial issues claims [% ELSIF type_code == 'export_basket' %] SQL for basket export in acquisition [% ELSE %] Uknown type [% 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 %]
    2. [% END %]
  2. Required
  3. Required
  9. 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.

  10. 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 %]?"

[% 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    
[% csv_profile.export_format_id %] [% csv_profile.profile %] [% csv_profile.description %] [% csv_profile.content %] [% csv_profile.csv_separator %] [% PROCESS type_description type_code = csv_profile.type %] Edit Delete
[% ELSE %] There is no CSV profile defined. Create a new CSV profile. [% END %] [% END %]
[% INCLUDE 'tools-menu.inc' %]
[% INCLUDE 'intranet-bottom.inc' %]