SFUMIA / Documentation
Guide
Import time from a CSV
Map columns, check rows and create drafts without replacing existing time entries.
In this guide
Prepare the file
Save the table as UTF-8 CSV with a header row. Choose a semicolon, comma or tab separator. Use numbers without formulas or thousands separators.
Open and map
- In timesheets, open Entry tools and CSV, then Import time (CSV).
- Choose the file, its separator and an identifiable import source.
- Map columns, then members, projects, tasks and activities. Also check defaults used when a column is empty.
Example columns
This fictional example uses a date, hours and a stable reference. Map each header to its field; choose the member and project yourself.
| date | hours | reference |
|---|---|---|
| 2026-10-12 | 2.5 | example-001 |
| 2026-10-13 | 3 | example-002 |
Choose a suitable duration
Import hours, days based on the configured workday, or start and end times with a break in minutes. Check the calculated duration in the preview.
Night sessions and retained timestamps
CSV does not carry a complete session with UTC timestamps and dated breaks. Use detailed entry for these cases; do not simplify a full session by deleting its information.
Analyse, then confirm
- Choose Analyse rows.
- Review drafts to create, existing rows and every error.
- Correct the batch, analyse again, then confirm Import drafts.
Resume an interrupted import
Keep the same source and references, then analyse the file again. Existing rows are identified. An existing reference with different content is refused; correct the entry through its usual workflow.
Available features depend on your version and installation.