Description containing some tables fails to migrate (ADF)

[eplnde]

Describe the problem

If the Jira description field contains tables with "merged cells", the are lost/dropped

To Reproduce

1. Paste an excel table with combined cells in to the description field
2. Run jira export
3. check the Json output

otput:
{
"ReferenceName": "System.Description",
"Value": "

For test of some AzDo migration issues

\n\n"
},

Tool version

• Think I am rebased towards 3.0.331 at the moment

Attachments

Please attach the following files:

• config.json
• jira-export-log.txt
• wi-import-log.txt

Screenshots
If applicable, add screenshots to help explain your problem.

[eplnde]

Ah, I see even the output when pasted here rendered weird, this is a screenshot:

[eplnde]

This is json dump of the description field from Jira:
"description": "For test of some AzDo migration issues\n\n{adf:display=block}\n{\"type\":\"table\",\"attrs\":{\"isNumberColumnEnabled\":false,\"layout\":\"default\",\"localId\":\"7653755d-e3a5-40b1-a69f-6e1dd78e5bd3\"},\"content\":[{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"column1\"}]}]},{\"type\":\"tableCell\",\"attrs\":{},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"column2\"}]}]}]},{\"type\":\"tableRow\",\"content\":[{\"type\":\"tableCell\",\"attrs\":{\"colspan\":2},\"content\":[{\"type\":\"paragraph\",\"content\":[{\"type\":\"text\",\"text\":\"grouped\"}]}]}]}]}\n{adf}",

[Alexander-Hjelm]

@eplnde I assume we are talking about the standard tables in jira? See screenshot:

It seems like this is some kind of macro inside jira, and the data is never exported as proper html. So maybe there is another endpoint involved to get the html formatted table?

Marking as feature request.

[eplnde]

No, this is a cust&paste table from excel
I do not think you can merge/combine cells in the Jira table-interface

[Alexander-Hjelm]

Ah ok!

Either way this feature will need to be implemented.

[eplnde]

@Alexander-Hjelm I think it would be good to at least add some warning that data is dropped as a "quick fix"
Right now this easily slips under the radar

[Alexander-Hjelm]

We did some repro and we found that regular tables in jira (see my screenshot) are migrating just fine.

It must be that bringing in table data from external sources like excel causes a problem.

Will look into this asap, but this is not our highest priority at the moment.

@eplnde, maybe there is a way to convert your data, like first creating a regular table in Jira and then pasting the data? Even if that is not optimal if you have a lot of data, of course. I'm not sure myself here.

Edit: Screenshot of our repro data:

[eplnde]

You need to merge two cells in excel before pasting the table in to Jira to be able to reproduce the issue

i.e. this function:

So not that common, but when you merge thousands of issues, it is easy to miss that a table was lost

[Alexander-Hjelm]

Aha ok!

This is an excel function, right? I am guessing that default HTML tables in Jira do not support this function?

[eplnde]

yes, as mentioned in #961 (comment)
"I do not think you can merge/combine cells in the Jira table-interface"