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

(-)a/installer/data/mysql/atomicupdate/bug_24163.perl (-1 / +1 lines)
Lines 2-8 $DBversion = 'XXX'; # will be replaced by the RM Link Here
2 
if( CheckVersion( $DBversion ) ) {
 2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do(q{
 3 
    $dbh->do(q{
4 
        INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) VALUES
 4 
        INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for ) VALUES
5 
        ("Late orders (csv profile)", "default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims
 5 
        ("Late orders (CSV profile)", "Default CSV export for late orders", 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims
6 
        [% FOR order IN orders ~%]
 6 
        [% FOR order IN orders ~%]
7 
        [%~ SET biblio = order.biblio ~%]
 7 
        [%~ SET biblio = order.biblio ~%]
8 
        "[% biblio.title %]"[% separator ~%]
 8 
        "[% biblio.title %]"[% separator ~%]
(-)a/installer/data/mysql/en/optional/csv_profiles.yml (-3 / +3 lines)
Lines 28-41 tables: Link Here
28 
      multiline: [ content ]
 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:
 32 
          content:
33 
            - "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate"
 33 
            - "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate"
34 
          csv_separator: ","
 34 
          csv_separator: ","
35 
          type: sql
 35 
          type: sql
36 
          used_for: late_issues
 36 
          used_for: late_issues
37 
        - profile: "Late orders (csv profile)"
 37 
        - profile: "Late orders (CSV profile)"
38 
          description: "default CSV export for late orders"
 38 
          description: "Default CSV export for late orders"
39 
          content:
 39 
          content:
40 
            - 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims'
 40 
            - 'Title[% separator %]Author[% separator %]Publication year[% separator %]ISBN[% separator %]Quantity[% separator %]Number of claims'
41 
            - '[% FOR order IN orders ~%]'
 41 
            - '[% FOR order IN orders ~%]'
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/csv-profiles.tt (-2 / +1 lines)
Lines 210-216 Link Here
210 
                    <p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p>
 210 
                    <p>Example: Name=subscription.name|Title=subscription.title|Issue number=serial.serialseq</p>
211 
                    <p>For late issues claims you can use data from following tables: serial, subscription, biblio, biblioitems and aqbookseller.</p>
 211 
                    <p>For late issues claims you can use data from following tables: serial, subscription, biblio, biblioitems and aqbookseller.</p>
212 
                    <p>For basket exports you can use data from following tables: biblio, biblioitems, aqorders, aqbudgets and aqbasket.</p>
 212 
                    <p>For basket exports you can use data from following tables: biblio, biblioitems, aqorders, aqbudgets and aqbasket.</p>
213 
                    <p>For late orders exports you must provide a Template Toolkit syntax that will generate the whole CSV file..</p>
 213 
                    <p>For exporting late orders you must provide a profile in Template Toolkit syntax to generate the CSV file.</p>
214 
                </li>
 214 
                </li>
215 
            </ol>
 215 
            </ol>
216 
        </fieldset>
 216 
        </fieldset>
217 
-

Return to bug 24163