[Koha] Recover deleted books

2014-11-18 Thread Jorge de Cardenas
I had a similar problem not long ago and discovered that at least on my system the table structure of the deleted tables did not match the structure of their counter parts. The result was that directly inserting from the deleted tables did not match up and data was lost. In other words even though

Re: [Koha] Recover deleted books

2014-11-18 Thread Robin Sheat
Jorge de Cardenas schreef op di 18-11-2014 om 16:45 [-0500]: In other words even though the tables had the same fields they were not in the same order. Then instead of using * in your query, you list off the field names in the required order. This is good practice anyway unless you know for

[Koha] Recover deleted books

2014-11-17 Thread CTS-Programmer 3 (Paul Dokken)
We accidently deleted about 100 books a few weeks ago and would like to recover them. We have a list of the barcodes and titles. What would be the best way to do this? Thanks, Paul Dokken Software Developer SIL PNG Communication and Technology Services Ukarumpa EHP 444 | Papua New Guinea

Re: [Koha] Recover deleted books

2014-11-17 Thread Chris Cormack
On 18 November 2014 18:45, CTS-Programmer 3 (Paul Dokken) cts-pr...@sil.org.pg wrote: We accidently deleted about 100 books a few weeks ago and would like to recover them. We have a list of the barcodes and titles. What would be the best way to do this? Thanks, Hi Paul Look in the

Re: [Koha] Recover deleted books

2014-11-17 Thread Vinod Kumar Mishra
You can restore the backup taken before deletion of Books or if you have titles than convert into marc and import it. On Tue, 18 Nov 2014 11:17:25 +0530 CTS-Programmer 3 (Paul Dokken) wrote We accidently deleted about 100 books a few weeks ago and would like to recover them. We have a list of