jiraimporter

Useful tool public

A SlimPHP web tool that imports Trello cards, groups them into epics, and syncs with Jira for work-item creation.

Repository

1 commits over 1 day

What it is

This app parses a Trello JSON export, stores cards/labels/lists in SQLite, and provides a UI for filtering, grouping, and assigning cards to epics. Users can manually create epics or sync existing ones from Jira Cloud, then export assignments (CSV/JSON) or push cards as Jira issues directly. It's designed for teams migrating backlogs from Trello to Jira or organizing a one-time import of background-check-related tasks.

Why I built it

Built to solve a specific migration problem: moving a Trello board (likely for background-check workflow) into Jira while preserving organization by epic. The developer needed to group scattered Trello cards, map them to Jira epics, and automate bulk issue creation rather than manual re-entry.

Tech stack

PHP with SlimPHP (REST framework), SQLite, Composer, Guzzle (HTTP client for Jira API), Twig templates, Tailwind CSS (CDN), PHPUnit tests, and console commands for import/export. No Docker or CI pipeline.

Timeline & effort

Last active Nov 10, 2025 — 1 commit across 1 active day (spanning 0 days).

Only a single commit recorded on 2025-11-10, suggesting the history may have been squashed or this is a code snapshot. However, the project is extensive: a fully documented schema, detailed multi-phase task plan (with most boxes checked), a CLI import pipeline, a working web UI with sorting/grouping, epic CRUD, Jira API integration (bidirectional sync and import), export endpoints, and PHPUnit test coverage. The docs imply weeks of actual work condensed into one commit, or development happened elsewhere first.

Did it turn out useful?

The repo ships a complete, documented solution for a real-world migration task. It includes a working import pipeline, bidirectional Jira integration (reading epics, writing issues), export functionality, a manual-testing checklist, and unit tests. The task plan shows end-to-end delivery through multiple phases—Trello import, UI, epic management, and Jira sync—making it a practical tool for a specific use case, not just a demo or abandoned prototype.

#php #trello #jira #migration #slimphp #sqlite