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, |
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. |
| Hierarchy Rule Violation | Classification | Task └ Phase |
Invalid classification. Since the parent WBS is a Task, please enter only Deliverable or Task. |