[Koha-bugs] [Bug 4310] No Migration for budgets from 3.0 to 3.2

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4310

Chris Cormack <chris at bigballofwax.co.nz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |chris at bigballofwax.co.nz

--- Comment #5 from Chris Cormack <chris at bigballofwax.co.nz> 2010-08-23 22:43:26 UTC ---
What I did, to upgrade was

SELECT aqorders.ordernumber, biblionumber, entrydate, quantity, currency,
listprice, totalamount, datereceived, booksellerinvoicenumber, freight,
unitprice, quantityreceived, cancelledby, datecancellationprinted, notes,
supplierreference, purchaseordernumber, subscription, serialid, basketno,
biblioitemnumber, timestamp, rrp, ecost, gst, budgetdate, sort1, sort2,
bookfundid)
 from aqorders,aqorderbreakdown WHERE
aqorders.ordernumber=aqorderbreakdown.ordernumber GROUP BY
aqorders.ordernumber INTO OUTFILE '/tmp/aqorders.csv';

LOAD DATA INFILE '/tmp/aqorders.csv' INTO TABLE aqorders (ordernumber,
biblionumber, entrydate, quantity, currency, listprice, totalamount,
datereceived, booksellerinvoicenumber, freight, unitprice, quantityreceived,
cancelledby, datecancellationprinted, notes, supplierreference,
purchaseordernumber, subscription, serialid, basketno, biblioitemnumber,
timestamp, rrp, ecost, gst, budgetdate, sort1, sort2, budget_id);

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.