View | Details | Raw Unified | Return to bug 24163
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/optional/csv_profiles.sql (-1 / +11 lines)
Lines 1-2 Link Here
1 
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
 1 
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
2 
VALUES ( "Zeitschriftenreklamationen", "Standardprofil für den Export von Heftinformationen für Zeitschriftenreklamationen", "LIEFERANT=aqbooksellers.name|TITEL=subscription.title|HEFTNUMMER=serial.serialseq|VERSPÄTET SEIT=serial.planneddate", ",", "sql", "late_issues" );
 2 
VALUES ( "Zeitschriftenreklamationen", "Standardprofil für den Export von Heftinformationen für Zeitschriftenreklamationen", "LIEFERANT=aqbooksellers.name|TITEL=subscription.title|HEFTNUMMER=serial.serialseq|VERSPÄTET SEIT=serial.planneddate", ",", "sql", "late_issues" ),
3 
("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims
4 
[% FOR order IN orders ~%]
5 
[%~ SET biblio = order.biblio ~%]
6 
"[% biblio.title %]"[% separator ~%]
7 
"[% biblio.author %]"[% separator ~%]
8 
"[% bibio.biblioitem.publicationyear %]"[% separator ~%]
9 
"[% biblio.biblioitem.isbn %]"[% separator ~%]
10 
"[% order.quantity%]"[% separator ~%]
11 
"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]"
12 
[% END %]', ",", "sql", "late_orders");
(-)a/installer/data/mysql/fr-CA/facultatif/csv_profiles.sql (-1 / +11 lines)
Lines 1-2 Link Here
1 
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
 1 
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
2 
VALUES ( "Réclamation de numéros", "Export CSV par défaut pour la réclamation de numéros de périodiques", "FOURNISSEUR=aqbooksellers.name|TITRE=subscription.title|NUMÉRO=serial.serialseq|EN RETARD DEPUIS=serial.planneddate", ",", "sql", "late_issues" );
 2 
VALUES ( "Réclamation de numéros", "Export CSV par défaut pour la réclamation de numéros de périodiques", "FOURNISSEUR=aqbooksellers.name|TITRE=subscription.title|NUMÉRO=serial.serialseq|EN RETARD DEPUIS=serial.planneddate", ",", "sql", "late_issues" ),
3 
("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims
4 
[% FOR order IN orders ~%]
5 
[%~ SET biblio = order.biblio ~%]
6 
"[% biblio.title %]"[% separator ~%]
7 
"[% biblio.author %]"[% separator ~%]
8 
"[% bibio.biblioitem.publicationyear %]"[% separator ~%]
9 
"[% biblio.biblioitem.isbn %]"[% separator ~%]
10 
"[% order.quantity%]"[% separator ~%]
11 
"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]"
12 
[% END %]', ",", "sql", "late_orders");
(-)a/installer/data/mysql/it-IT/necessari/csv_profiles.sql (-2 / +11 lines)
Lines 1-2 Link Here
1 
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
 1 
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
2 
VALUES ( "issues to claim", "CSV export per fascicoli in ritardo", "FORNITORE=aqbooksellers.name|TITOLO=subscription.title|NUMERO FASC=serial.serialseq|IN RITARDO DAL=serial.planneddate", ",", "sql", "late_issues" );
 2 
VALUES ( "issues to claim", "CSV export per fascicoli in ritardo", "FORNITORE=aqbooksellers.name|TITOLO=subscription.title|NUMERO FASC=serial.serialseq|IN RITARDO DAL=serial.planneddate", ",", "sql", "late_issues" ),
3 
("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims
4 
[% FOR order IN orders ~%]
5 
[%~ SET biblio = order.biblio ~%]
6 
"[% biblio.title %]"[% separator ~%]
7 
"[% biblio.author %]"[% separator ~%]
8 
"[% bibio.biblioitem.publicationyear %]"[% separator ~%]
9 
"[% biblio.biblioitem.isbn %]"[% separator ~%]
10 
"[% order.quantity%]"[% separator ~%]
11 
"[% order.claims.count%][% IF order.claims.count %]([% FOR c IN order.claims %][% c.claimed_on | $KohaDates %][% UNLESS loop.last %], [% END %][% END %])[% END %]"
12 
[% END %]', ",", "sql", "late_orders");
3 
-

Return to bug 24163