Import Work Items
Prepare a data file for import
Download import template
- Click the
icon on the upper right corner of the work table, and select Import.
.png)
.png)
- Download the import template.
.png)
Prepare import file
Organize your data into the template file for import.
.png)
- Columns in the file will be automatically mapped to fields in Leiga during import. Columns marked with * denotes required fields in Leiga.
- Each row indicates a work item record.
- A tab is created for each work type in the current project to input data for import.
- Up to 10,000 work items can be imported in one batch.
A column can be matched to a default field or a custom field.
You can also choose to exclude columns to be imported during mapping.
Import subtasks
- Add columns ID, Parent ID, and Work Type to the import file.
- For the subtask row, enter the subtask ID in the ID column, the parent work item's ID in the Parent ID column, and 'Subtask' in the Work Type column.
One parent work item can have multiple subtasks, the ID for each subtask must be unique.
.png)
Data formatting requirements
Formatting for date and date/time fields
Format | Example | |
---|---|---|
Date | YYYY-MM-DD | 2023-06-01 |
Time | YYY-MM-DD XX:XX:XX (24 hour time) | 2023-06-01 16:00:00 |
Formatting for multi-value fields
Use "," to separate multiple values in a single field.
Example: tag1,tag2,tag3
Upload file
Click the Upload button to upload your prepared import file.
.png)
Field matching
- After uploading your the file, click Next to match its columns to fields in Leiga.
- Leiga will automatically match fields where possible, but you can review and adjust them manually if needed.
.png)
Finalize importing into Leiga
- Click Next to continue.
- Click Start Importing to complete the import.
.png)