Hi Tanzeem, to migrate or correct bibliographic data into Koha you have to use MARC records - only changing the columns in the table biblio, biblioitems and items tables will not give you correct results. Koha stores the complete MARCXML record in biblioitems.marcxml so using the export and import tools (bulkmarcimport.pl oder staged marc import tools) is the best way to migrate and change data. Changes to the items table can be done with SQL, but you need to reindex the changed records after. Hope this helps, Katrin On 26.01.2017 06:40, Tanzeem M.B wrote:
In my migrated koha system I have got to do many corrections and additions. Some fields got values wrongly and some of the fields got no values. But the source spreadsheet database has got correct values.
I was thinking about a method by exporting the biblio, items and biblioitems tables to excel, make corrections/ additions to these excel files, truncate the biblio table which will make a cascaded truncation; import the excel files to the corresponding tables. If I import , in which order of tables should I import to. Run zebra-rebuild again. Will this method work? _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha