|
Lines 25-35
description:
Link Here
|
| 25 |
tables: |
25 |
tables: |
| 26 |
- export_format: |
26 |
- export_format: |
| 27 |
translatable: [ profile, description ] |
27 |
translatable: [ profile, description ] |
| 28 |
multiline: [] |
28 |
multiline: [ content ] |
| 29 |
rows: |
29 |
rows: |
| 30 |
- profile: "issues to claim" |
30 |
- profile: "issues to claim" |
| 31 |
description: "default CSV export for serial issue claims" |
31 |
description: "default CSV export for serial issue claims" |
| 32 |
content: "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate" |
32 |
content: |
|
|
33 |
- "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate" |
| 33 |
csv_separator: "," |
34 |
csv_separator: "," |
| 34 |
type: sql |
35 |
type: sql |
| 35 |
used_for: late_issues |
36 |
used_for: late_issues |
| 36 |
- |
37 |
- profile: "Late orders (csv profile)" |
|
|
38 |
description: "default CSV export for late orders" |
| 39 |
content: |
| 40 |
- 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims' |
| 41 |
- '[% FOR order IN orders ~%]' |
| 42 |
- '[%~ SET biblio = order.biblio ~%]' |
| 43 |
- '"[% biblio.title %]"[% separator ~%]' |
| 44 |
- '"[% biblio.author %]"[% separator ~%]' |
| 45 |
- '"[% bibio.biblioitem.publicationyear %]"[% separator ~%]' |
| 46 |
- '"[% biblio.biblioitem.isbn %]"[% separator ~%]' |
| 47 |
- '"[% order.quantity%]"[% separator ~%]' |
| 48 |
- '"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]"' |
| 49 |
- '[% END %]' |
| 50 |
csv_separator: "," |
| 51 |
type: sql |
| 52 |
used_for: late_orders |