Import from ODS — overview
Rediflow: Project flow. Portfolio flow. One flow.
Single entry point for importing data from ODS spreadsheets. When to use it, the correct order of steps, and whether to run locally or in containers.
When to use ODS import
| Scenario | What you need | Where to go |
|---|---|---|
| Single project | One ODS file with project structure (organisations, Work packages (WPs), tasks, milestones, deliverables) | Import project from ODS |
| Portfolio (multiple projects + staff) | Project ODS files and a people ODS file | Portfolio import (multiple projects + staff) |
| Per-org variant | Work breakdown structure (WBS) data per organisation; one project per organisation | Per-org ODS variant |
Order of steps
- Migrations — Always run first. The database must have the schema.
- Calendars — Run
seed-calendarsfor country holidays (FI, SE). No file download needed when using the bundled data. - Projects — Import from project ODS files. Projects must exist before you can assign people.
- People — Import persons, employee groups, leave types, and project assignments from a people ODS file.
Both project and people imports are idempotent: re-running updates existing records; safe to run multiple times.
Local vs container
| Where you run | Calendars | Projects | People |
|---|---|---|---|
| Local (app on host, DB in container) | uv run rediflow seed-calendars |
uv run python scripts/seed_from_ods.py --ods path/to/file.ods |
uv run python scripts/seed_people_from_ods.py --ods path/to/people.ods |
| Container (QA or production) | podman compose -f compose.deploy-qa.yml run --rm app-qa rediflow seed-calendars |
Mount ODS, run seed_from_ods.py inside container |
Mount ODS, run seed_people_from_ods.py inside container |
Use podman compose or docker compose — both work. Replace compose.deploy-qa.yml and app-qa with compose.deploy-prod.yml and app-prod for production.
For the full container workflow (mount paths, commands), see Seed projects and calendars.
Sheet layout reference
- Project ODS — Sheet names, columns, validation. Required sheets: ORGS, Work packages (WPs), Work breakdown structure (WBS), Tasks, Milestones, Deliverables, Estimated (EST) capacity.
- People ODS — Employee groups, Leave types, Persons, Full-time equivalent (FTE) periods (optional), Project assignments.
See also
- Portfolio import (multiple projects + staff) — Full workflow: projects first, then people
- Seed projects and calendars — Container deployment: calendars, projects, people
- Initial data entry after deployment — Manual data entry steps
- Deploy QA and production — Start the stack with the container image
← Home · Import project from ODS · Import people from ODS · Portfolio import