I export a table from jira, then when I go to import it with modifications, there is a black diamond with a questionmark in each table box. The only solution I have found is to literally manually put a space where each of those where. So when the tables are huge, that is way too tedious, especially across multiple tickets. The file encoding is correct as UTF-8 on import. I already tried pasting it into notepad then back into excel. And using new excel sheets. I've deleted the question marks then hit the "text" button on the description box and then copied and pasted. This is a huge pain because we're creating hundreds of tickets that have tables.
|Cam| | | |
In my experience Excel saves CSV's in the encoding you OS is using. For me that is Windows-1252 (= ANSI)
After saving/ exporting the csv please check the encoding of the file and use it in the jira import wizard.
I usually open the file in notepad++ where you can check the encoding a the bottom right. See these screenshots for examples:
Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events