Dear Atlassian Community,
I hope this message finds you well.
I am writing to seek assistance with an issue I have encountered while attempting to import customer profiles into Jira using a CSV file. Despite following the instructions provided in the documentation, I am unable to complete the import successfully.
Documentation Link: https://support.atlassian.com/jira-service-management-cloud/docs/import-customer-and-organization-details/#Set-up-your-CSV-file
Error 1: If I save the excel as CSV, it detects the file but does not import it.
Error 2: If I save the excel as CSV with UTF-8 encoding, it says Email is required as a column header which I did but in vain.
Any assistance here would be greatly appreciated!
Many Thanks!
Hello everyone,
I was able to get this working. I downloaded a sample excel(CSV) from the instructions and edit the same and upload. This worked rather than creating an individual file and renaming it according to standards
Welcome to the community. Can you share a sample portion of your CSV file - (especially the header row of the file)?
In Excel, you should also save the file to use the "CSV (comma delimited)" type explicitly.
Please advise, so we can assist you further.
Best, Joseph Chung Yin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for responding @Joseph Chung Yin
Here is the sample image, I'm trying to import sample data so that if it's successful then I will proceed further with my import.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Does the file conform to the size restraints (1MB, < 1,000 rows)?
Without sharing any real data, can you show us what the first three or four rows of the file look like, including the header row? It's possible that the Excel "dialect" of .csv being produced isn't friendly to being imported to Jira.
I'm curious about the UTF-8 encoded version with the Email header.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Jim Knepley - ReleaseTEAM Yes, it does meet 1MB and < 1000 rows. I am trying to import sample data with Email as a header in the column and 1 other column as attached.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Instead of screenshotting the spreadsheet, can you show the .csv file contents?
What I mean by "dialect" are the preferences of Excel for how it generates the file. For example, Excel possibly writes the .csv file using the "\r\n" line termination which Jira might not like, or it only quotes values when it seems to be necessary, as opposed to all the time.
I've also had trouble from time-to-time with the byte order mark (BOM) of text files tripping up import processes, which isn't always easy to diagnose. I end up using a hex viewer like ImHex or similar to see the raw contents of a file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.