[Bug 4310] New: No Migration for budgets from 3.0 to 3.2
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 Summary: No Migration for budgets from 3.0 to 3.2 Product: Koha Version: rel_3_2 Platform: PC OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Acquisitions AssignedTo: henridamien@koha-fr.org ReportedBy: colin.campbell@ptfs-europe.com Estimated Hours: 0.0 Change sponsored?: --- No migration or documentation has been supplied for users of 3.0 Acq budgets to the new 3.2 budgets. There should be a path for users to upgrade without losing info -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 --- Comment #1 from hdlaurent <henridamien@koha-fr.org> 2010-03-09 22:51:19 --- Hi, it is all coped with in dbrev 3.01.00.077 Can you check and update that report? -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 --- Comment #2 from Colin Campbell <colin.campbell@ptfs-europe.com> 2010-03-10 10:48:56 --- A comment in the db revision explicitly states there is no upgrade, Will test with copy of real data. An earlier experience suggested that data might be lost on this upgrade, (this may have been caused by other bugs, since fixed in the upgrade script) -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 --- Comment #3 from Colin Campbell <colin.campbell@ptfs-europe.com> 2010-03-19 18:02:25 --- An initial test seemed to increase my funds by $10,000. Committed and spent seem to be erased. investigating further. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 --- Comment #4 from Colin Campbell <colin.campbell@ptfs-europe.com> 2010-03-22 08:42:39 --- Ran a test upgrading from a copy of a live system. Pre- upgrade Totals Total in Funds & budgets is 300000 spent 777134.44 Comitted 53850.39 Available -530984.83 After Upgrade: Total is 380000 Spent 0 Comitted 0 Available 380000 -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 --- Comment #5 from Colin Campbell <colin.campbell@ptfs-europe.com> 2010-03-22 17:13:13 --- Yes budget_id is being set to 0 for all existing orders the data held previosly in aqorderbreakdown is lost when that table is dropped. Is this as intended if so it needs a big health warning. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 Galen Charlton <gmcharlt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gmcharlt@gmail.com Severity|normal |blocker --- Comment #6 from Galen Charlton <gmcharlt@gmail.com> 2010-05-03 16:08:19 --- (In reply to comment #5)
Yes budget_id is being set to 0 for all existing orders the data held previosly in aqorderbreakdown is lost when that table is dropped. Is this as intended if so it needs a big health warning.
Setting as blocker. This would be a rather large "health warning" unless there is no possible way to avoid it. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4310 --- Comment #7 from Colin Campbell <colin.campbell@ptfs-europe.com> 2010-05-19 11:54:15 --- On a copy of a live system I ran through the upgrades to 3.2 and compared the results. Using a map derived from the old aqorderbreakdown I managed to reinstate links from the orders to budgets (otherwise all orders become unlinked). This means I now have spend and committed amounts. As in the earlier check I now seem to have $80,000 in the budgets. The committed and spent amounds differ wildly the old committed amount was $777,036.20 it is now $138,952.67 the old spent total was $79.076.62 it is now $27,976.81 -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠kohaorg.ec2.liblime.com