Generate a script to convert a closed version JSON export into an OpenMRS v1.11 mysqldump

[filiperochalopes]

User story

As a release maintainer, I want to convert a closed version JSON export into an OpenMRS schema v1.11 mysqldump so the CIEL release process can produce the legacy OpenMRS-compatible database export.

Use case

Take the JSON export of a closed CIEL version and generate a mysqldump compatible with OpenMRS schema v1.11 for distribution/use in the release pipeline.

Requirements

• Create a script that accepts a closed version JSON export as input.
• Convert the JSON export into a mysqldump formatted for OpenMRS schema v1.11.
• Ensure the script output can be integrated into the CIEL release process as an export artifact.

Acceptance criteria

• Given a closed version JSON export, running the script produces a mysqldump compatible with OpenMRS schema v1.11.
• The resulting mysqldump is suitable to be used as an output artifact in the CIEL release workflow.

[ocl-automation]

Automated Triage — 2026-04-17

Dimension	Score
Complexity	4
Scope	3
Clarity	2
Dependency	2
Risk	3

Decision: decision/human-review
Type: type/docs
Signals: signal/needs-spec

Complex data transformation requiring knowledge of both JSON schema and OpenMRS v1.11 database structure with design decisions needed. Clarity is low due to incomplete requirements (truncated at 'Convert the JSON export...'). Moderate risk as incorrect conversion could break release pipeline.

---

Generated by ticket-triage pipeline v3. Model: anthropic/claude-sonnet-4 (openrouter).