Bug 13703 - batchRebuildBiblioTables.pl should also update from database to MARC Record.
Summary: batchRebuildBiblioTables.pl should also update from database to MARC Record.
Status: Patch doesn't apply
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Olli-Antti Kivilahti
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-12 14:59 UTC by Olli-Antti Kivilahti
Modified: 2017-10-18 23:39 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 13703 - batchRebuildBiblioTables.pl should also update from database to MARC Record. (9.82 KB, patch)
2015-02-12 15:03 UTC, Olli-Antti Kivilahti
Details | Diff | Splinter Review
Bug 13703 - batchRebuildBiblioTables.pl should also update from database to MARC Record. (9.68 KB, patch)
2015-02-13 16:16 UTC, Olli-Antti Kivilahti
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Olli-Antti Kivilahti 2015-02-12 14:59:31 UTC
When adding a new column to biblio or biblioitems and populating it with legacy data, the MARC Record needs to be updated to match the values in DB, so they can be indexed for searching.

Upgrading the batchRebuildBiblioTables.pl -script to make updates upstream (DB columns to MARC Record) and downstream (MARC Record to DB columns), based on the "Koha to MARC mappings".
Comment 1 Olli-Antti Kivilahti 2015-02-12 15:03:49 UTC Comment hidden (obsolete)
Comment 2 Olli-Antti Kivilahti 2015-02-13 16:16:30 UTC
Created attachment 35911 [details] [review]
Bug 13703 - batchRebuildBiblioTables.pl should also update from database to MARC Record.

When adding a new column to biblio or biblioitems and populating it with legacy data,
the MARC Record needs to be updated to match the values in DB, so they can be indexed for searching.

Upgrading the batchRebuildBiblioTables.pl -script to make updates upstream (DB columns to MARC Record)
and downstream (MARC Record to DB columns), based on the "Koha to MARC mappings".

Also improves the batchRebuildBiblioTables.pl -script's documentation and parameter handling.

TEST PLAN:

1. Add a new column to biblio or biblioitems-tables.
2. Map the column to "Koha to MARC mappings".
3. Define the mapped MARC Field as a new search index to Zebra and all the relevant hassle what
   comes with defining a new search index.
4. Populate legacy data to the new DB column.
5. Run the batchRebuildBiblioTables.pl to update the MARC Records from the new DB column.
6. Reindex the whole DB.
7. Make searches from your new index.
8. Split hairs :)