### Goal

Let users create work packages in bulk from a spreadsheet.

### Requirements

* Accept Begin of the insertion`.csv`End of the insertion Begin of the deletion `.csv` 
_To specify_: Handle encoding issues with the fileEnd of the deletion

* Column contract

* Downloadable template for creating new CSV files

* Column reference in docs/user-guide/

* Begin of the insertionDate fields: ISO

* Text/date only:End of the insertion Begin of the deletion _To specify_: Core attributes:End of the deletion subject, Begin of the deletion type,End of the deletion description, estimated hours, percent complete, dates

* Must exist Begin of the deletion vs create on-the-fly - may not be possible because of necessary admin rights)End of the deletion

* Begin of the insertionType, Status, Priority, CategoryEnd of the insertion Begin of the deletion _To specify_: status, priority, assigneeEnd of the deletion by name

* Begin of the insertionAssigneeEnd of the insertion Begin of the deletion _To specify:_ Custom fieldsEnd of the deletion by Begin of the insertionemail addressEnd of the insertion Begin of the deletion name?End of the deletion

* Begin of the deletion _To specify:_ Parent / hierarchy by row number, external ID?
_To specify:_ Relations by row number, external ID?

* _To specify:_ Version and category by name?

* _To specify:_End of the deletion Backdate journals if created\_at and/or updated\_at are part of the data

* Error handling

* Validate the header row once, up front, and report unknown or ambiguous columns before any row is processed.

* Report the line number of each error encountered

* An error rolls back all changes

* Row or file-size limit

* Permission

* A dedicated `import\_work\_packages` permission, modelled on `export\_work\_packages`

* Not admin-only

* UI

* On the project level Begin of the deletion (_To specify: where?)_End of the deletion

* Begin of the deletion _To specify:_End of the deletion Upload page with a downloadable sample file

* Begin of the deletion _To specify:_End of the deletion Dry-run toggle

* Begin of the deletion _To specify:_ Reports progress

* _To specify:_ Is abortable

* End of the deletion Runs as a background job Begin of the deletion (_To specify:_ progress needed?)End of the deletion

* Begin of the insertionNotifications (e.g. assignee)End of the insertion Begin of the deletion _To specify:_ notificationsEnd of the deletion to imported work packages are Begin of the deletion created (e.g. assignee) orEnd of the deletion suppressed

* Tag journals with `Journal::CausedByImport`

* Feature flag


### Out of scope

* User specified column mapping

* Attachments

* API endpoint

* Historic import (multiple rows for different states of the same work package)

* XLS/XLSX Begin of the insertion

* create fields/types/status on-the-fly - need admin rights

* Parent / hierarchy by row number, external ID

* Relations by row number, external ID

* Custom fields by name

* Version by name?

* Reports progress

* Is abortableEnd of the insertion


<br>