[% 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 == '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 %]

Modify a CSV profile

[% ELSE %]

New CSV profile

[% END %]

Profile ID: [% csv_profile.export_format_id | html %]
Profile name: Required
Profile type: Required
Usage:
Usage:
Profile description: [% csv_profile.description | html %]
CSV separator:
Field separator:
Subfield separator:
Encoding:
Only available on the staff interface: [% IF csv_profile.staff_only %] [% ELSE %] [% END %]
Profile MARC fields: [% csv_profile.content | html %] 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.
Profile SQL fields: [% csv_profile.content | html %]
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 %]

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 \| 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 %]