Fix errors in a business project import

This is a troubleshooting guide for importing data into Jira Work Management. This page can help you resolve errors while importing using a CSV file or the Trello and Asana importers.

If your import has failed or is partially complete, you should be able to download an error log at the end of the import.

To find a solution to an error, use Ctrl+F or Command+F and enter the error code from the error log.

Read more about:

CSV errors

Here’s how you can resolve errors that you may come across while importing a CSV file.

Error code

Why does this error occur?

Solution

DT001

Locale, date, and time values don't match the selected format

  1. Ensure that the locale, date, and time formats are consistent across your CSV file.

  2. Upload the updated CSV file for import.

  3. In the Preview mapped data screen, select Date and time format options.

  4. Change the locale, date, and time formats to match the format in your CSV file.

DA002

Locale and dates don't match the format selected

  1. Check if the locale and date formats are consistent across your CSV file.

  2. Upload the updated CSV file for import.

  3. In the Preview mapped data screen, select Date and time format options.

  4. Change the locale and date format to match the format in your CSV file.

NU003

The number fields contain letters, special characters, or spaces

Remove special characters (e.g., commas, periods, or slashes), spaces, or letters from the number fields in your CSV file.

  • Number fields in your CSV file should only contain numbers from 0 to 9.

CS004

The CSV file may contain the following issues:

  • Missing line break(s)

  • Missing data in rows and/or columns

  • Extra rows and/or columns

Check your CSV file for:

  • Missing line break(s)

  • Missing data in rows and/or columns

  • Extra rows and/or columns

Contact support if you need assistance with this error.

EM005

The email addresses in the file aren't in the correct format

Check the email addresses in your CSV file.

  • All email addresses should follow the format, username@domain.extension (e.g., xyz@company.com).

UR006

The URLs in the file aren't in the correct format

Check the URL formats in your CSV file.

  • All URLs should follow the format, <scheme>://<authority><path>?<query>#<fragment> (e.g., https://www.atlassian.com).

IS007

One or more Summary fields are empty

Make sure Summary field isn't left empty in your CSV file.

TE008

The Original time estimate, Remaining time estimate, and/or Time spent fields may contain the following issues:

  • The time data is not in seconds

  • The fields may contain letters, special characters, or spaces

Check and remove special characters (e.g., commas, periods, or slashes), spaces, or alphabets from the number fields in your CSV file.

  • The field must only contain numbers from 0 to 9.

  • Make sure the time data is formatted in seconds (e.g., 1 hour should be 3600).

Third-party importer errors

Here’s how you can resolve errors that you may come across while using Trello or Asana importers.

Error code

Error

Solution

PA009

Invalid personal access token

  1. Create a new personal access token from the third-party tool you’re importing the data.

  2. Run the import once again by entering the new personal access token.

 

Still need help?

The Atlassian Community is here for you.