Troubleshooting CSV Ticket Import Errors

If your CSV file import fails, it is likely due to incorrect data or formatting. Below are common issues and their solutions.

Common Issues and Solutions

Type	Target	Example Error Content	Error Message
Not a CSV File	Common	`sample.txt`, `sample.doc`	Invalid file format. Please import a CSV file.
Incorrect Character Encoding	Common	`EUC-JP`, `ASCII`	Character code is not {Encoding name}.
Missing Header	Common	-	Header row not found. Please add a header according to the template.
Incorrect Header Name	Common	`Subsequent Task`	The header row contains an incorrect value. Please follow the template.
Missing Required Column	Common	-	Required column not found. Please add all required columns according to the template.
Incorrect Column Order	Common	`Parent WBS No, WBS No`	Column order is incorrect. Please follow the template.
Record Count Exceeded	Common	-	The record count check exceeds the limit (Max: {limit} records).
Blank Row	Common	-	No data is entered in this row.
Data Columns Exceed Header Count	Common	-	Data columns exceed the number of header columns.
Required Field Missing	WBS No, Classification, Title, Status, Creator, Creation Date	-	[Item] is required.
Character Limit Exceeded	Title (255 chars), Details (32767 chars), Corresponding Team (100 chars)	-	[Item] must be within [max] characters.
Invalid Number Format	Planned Time, Actual Time	`a`	[Item] is invalid. Please enter a number greater than or equal to 0 (up to 2 decimal places).
Invalid Email Format	Email Address, Watcher, Creator	`testexample.com`	The format of [Item] is incorrect.
Invalid Date Format	Start Date, Due Date, Actual Start Date, Actual End Date, Creation Date, Updated Date	`2025-12-31`	[Item] must be entered in YYYY/MM/DD format.
Existence Check Failed	Assignee Email, Corresponding Team, Watcher, Creator, Related Items, Preceding Tasks	`TeamZZZ`	[Item] "{TeamZZZ}" does not exist.
Invalid Priority Value	Priority	`Urgent` (If the input is incorrect)	Priority must be one of the following: Urgent, High, Medium, or Low.
Milestone Start Date Check	Start Date	`2025/08/21`	A Start Date cannot be set for a Milestone. Please enter a Due Date only.
Target Ticket Does Not Exist	ID	1	An error occurs if the specified ID exists but the corresponding ticket cannot be found.
Deletion Specification Error	Delete	Delete	An error occurs if "Delete" is specified but the ID does not exist, the ID is invalid, or "Delete" is specified for a temporary ID.
Parent Ticket / Related Item Reference Error	Parent WBS No. Parent Ticket No. Related Items	-	An error occurs if the specified reference ID or temporary ID does not exist within the CSV file or the system.
ID Constraint Error	ID Temporary ID	-	An error occurs if both ID and Temporary ID are specified, or if both are left blank.
Duplication Error	ID Temporary ID	-	An error occurs if there is a duplicate between IDs, temporary IDs, an ID and a temporary ID, or a temporary ID and an existing ticket ID.
Circular Reference Error	Parent Ticket No. Related Items	-	An error occurs if a circular reference is detected (e.g., A → B → C → A) or if a ticket specifies itself as its parent.
Predecessor Task Reference Error	Predecessor Task	-	An error occurs if the specified predecessor task does not exist.
Insufficient Permissions	Common (All Fields)	-	An error occurs if you lack the required update or deletion permissions for the project, ticket, or specific field.