Koha MARC Import Validator
Inspect MARC-style fields, subfields, required item data and common import problems before migration.
Accuracy note: Validation catches common structural problems but cannot replace cataloguer review or every local Koha/MARC framework rule.
How this result is calculated and when to review it
Method: Parses MRK, binary MARC21/ISO2709 or MARCXML, checks Leader and record structure, tags, indicators, subfields, fixed fields and common bibliographic issues, and can optionally audit Koha 952 item data. Local cataloguing policy, authority control and configured Koha authorised values still require human review.
Result type: Technical diagnostic.
Koha compatibility: choose your target Koha release in the tool interface when shown, then verify generated SQL, import fields and configuration against that installation before production use.
Good practice: keep one known-good example, test small batches first, and document any local conventions that affect the result.
Worked example
Paste or upload five known-good MARC21 records, confirm they pass the structural checks, then introduce one controlled error such as a malformed Leader, bad 008 length or duplicate Koha 952$p barcode to verify that the validator reports it at the correct severity.
Tip: the Try example control in the tool uses the built-in sample/default values so you can see the expected workflow before entering your own data.
Koha MARC Import Validator is a focused VWS Online utility for Koha administrators, librarians, migration consultants and institutions running or planning an open-source ILS. It is designed to inspect MARC-style fields, subfields, required item data and common import problems before migration. The revised version puts calculation rules, validation limits and practical warnings directly into the workflow so users can understand what the output means before copying it into a catalogue, repository, website, report or project plan.
What Koha MARC Import Validator does
The core job is practical browser-based processing. The main inputs are the inputs shown in the form. Instead of treating every problem as the same generic form, the tool now uses rules that match this particular task. That matters because a valid ISBN is checked differently from a DSpace CSV, an AI crawler rule is interpreted differently from a meta title, and an infrastructure estimate should never be presented with the certainty of a mathematical check digit.
Koha MARC Import Validator focuses on practical browser-based processing. Its interface has been revised so important assumptions are visible instead of being hidden in a generic score or a silent batch rule.
How the revised workflow works
Test a representative example before production use. The interface rejects or flags inputs that would otherwise create misleading output, and batch-oriented tools use explicit limits rather than quietly dropping records. Where an export is available, the preview and the downloaded file are derived from the same processed data so the user is not shown one value and given another.
- Start with the smallest representative example that includes the edge cases you care about.
- Enter values in the units, identifiers and formats shown beside the fields.
- Run the tool and read every warning or assumption before copying the result.
- Compare the output with one known-good example or the documentation for the target platform.
- Only then repeat the workflow for a larger batch, production configuration or decision.
A practical starting example from this tool is: Use Koha MARC Import Validator with a small test case first, review the result, then repeat the workflow with your real data once the assumptions match your environment. The purpose of the example is not to prescribe one local convention; it gives you a controlled baseline for testing the revised behavior.
Accuracy and interpretation
The result reflects the data and assumptions visible in the interface. The generated output is reviewable and copyable, but target-system rules still matter. A syntactically clean result can still be inappropriate when local codes, policies, permissions or content facts are wrong.
Validation catches common structural problems but cannot replace cataloguer review or every local Koha/MARC framework rule This limitation is important: VWS Online can validate the data visible to the tool, but it cannot see every locally customized field, policy, vendor contract, authentication rule, search-engine decision or infrastructure bottleneck. When the task can affect production data or public access, keep an original backup and test outside the live workflow first.
Input quality matters
Reliable output starts with consistent source data. Preserve leading zeros in identifiers, use one date convention, do not mix units in the same calculation, and keep local codes exactly as the destination system expects them. If a field is unknown, leaving it clearly unknown is often safer than inventing a value just to make a form look complete. For URL-based checks, use the final public HTTP or HTTPS address rather than an internal hostname.
For metadata and migration work, retain a source-of-truth export before cleaning. For cost and sizing tools, record where each assumption came from. For content audits, keep the original draft so recommendations can be compared against the edited version. For configuration generators, put the generated snippet under version control or at least save the previous configuration before deployment.
Common mistakes to avoid
- Using Koha MARC Import Validator without checking the target system or local policy.
- Scaling to a full production batch before testing a representative sample.
- Ignoring warnings, limits or assumptions shown beside the result.
- Treating a warning-free result as proof that every external requirement has been satisfied.
- Copying production secrets, passwords, private API keys or unnecessary personal data into a public web utility.
Privacy and safe use
Most local calculators, generators and text-processing tools in this suite run in the browser. Tools that need to inspect a public website use the VWS server to fetch only public HTTP(S) resources with safety controls that reject private/reserved network destinations. Regardless of the processing path, minimize sensitive data. Use test patrons, placeholder credentials and sanitized log excerpts when personal or confidential information is not required for the calculation.
Generated configuration and code should be treated like a draft from a knowledgeable assistant: review it in context, test it, and keep a rollback path. A robots rule cannot protect a private page, a SELECT report can still expose patron data, a security header can break an application, and a correct identifier check digit does not verify the underlying bibliographic identity.
Standards and external references
This page is written to support practical work, but official specifications and platform documentation remain the final reference when a standard is involved. Useful starting points for this tool include Official Koha manual Koha community. These links are included because they describe the relevant standard or platform, not merely to add outbound links for SEO.
Standards and software evolve. A field that is supported in one Koha or DSpace release can be locally customized, a crawler name or purpose can change, and a search engine can change which structured-data features it displays. When the decision matters, compare the tool's result with the current documentation and the exact version you operate.
Using the result in a real workflow
A dependable production workflow has four stages: prepare the source, run the transparent check or generator, review a small output, and reconcile the result in the destination. Reconciliation is the step most often skipped. It can mean comparing record counts after an import, scanning printed barcodes, verifying a redirect response, checking a repository item after ingest, or confirming that a calculation matches a policy example.
For teams, write down the settings that produced an approved result. That makes future batches reproducible and makes disagreements easier to resolve. If a policy changes, change the documented input rather than silently changing the tool's interpretation. If the tool produces a heuristic score, track the underlying findings rather than the number alone.
Related VWS Online tools
Koha MARC Import Validator is most useful as part of a connected workflow rather than an isolated page. Depending on the task, the following VWS tools can help with the next validation, conversion, planning or implementation step:
- MARC to Excel Converter — convert MARC21 MRC, MRK and MARCXML records into reviewable Excel or CSV data, including one-row-per-952 Koha item exports.
- Excel to MARC Converter for Koha Libraries — convert spreadsheet cataloguing data into MARC21 records for Koha and other MARC-based systems.
- MARC21 Validator — validate MARC21 record structure, fields, indicators, subfields and optional Koha 952 item data before import or migration.
- Koha Patron Import CSV Generator — build clean CSV rows for Koha patron or item imports with common field headings.
- Koha Item Import CSV Generator — build clean CSV rows for Koha patron or item imports with common field headings.
Frequently asked questions
Is Koha MARC Import Validator an official certification or platform feature?
No. It is an independent VWS Online utility. Deterministic rules are calculated directly where possible, while planning, readiness, content and sizing outputs are clearly treated as heuristics. Official platform behavior should be confirmed in the target system and its current documentation.
Should I test with production data first?
No. Start with a small representative sample. For migrations and imports, keep the original export and reconcile a pilot. For website configuration, test in staging. For print tools, print or scan one page before producing a large batch.
Does the tool guarantee search rankings, AI citations, system compatibility or successful imports?
No. Those outcomes depend on external systems and factors the tool cannot control. The purpose is to make a narrow task more accurate and reviewable, not to promise an external result.
What should I do when the tool and my local policy disagree?
Use the local approved policy or authoritative standard and document the difference. VWS tools expose assumptions so you can identify exactly which setting or rule must be changed rather than forcing a generic default.
Can I use the output commercially or in an institutional workflow?
You can use the generated output after reviewing it for your environment. Keep source records and backups, comply with licenses and privacy rules, and obtain professional review when a change has legal, security, financial or data-integrity consequences.
Next step
Run Koha MARC Import Validator with one known example now. If the result matches your documented requirements, save the settings or exported sample with the project notes and move to the related tool that handles the next stage. That test-first sequence is more reliable than generating a large batch and discovering an assumption only after production data has changed.
Continue the workflow
- 1Koha MARC Import ValidatorComplete and review this result first.
- 2Koha Barcode Generatorgenerate, validate, export and print sequential Koha item barcode ranges for MARC21 952$p
- 3Koha SQL Reports Generatorbuild vetted read-only Koha SQL reports for circulation, items, patrons and data quality with Koha runtime filters, privacy controls and SQL safety review
- 4Koha Migration Readiness Checkerassess Koha migration readiness across scope, configuration, MARC, items, patrons, operational data, testing and cutover with weighted domains, critical blockers and a prioritized action plan
