Trying to import contents of a jira server xml issue export into cloud via csv format

[Jay Keck]

I'm having trouble getting the results of the xml created by Jira server issues export xml format into a csv that can be correctly imported into a jira cloud instance. everything seems to be working except for custom fields. The problem that I'm having is that when converting xml into csv, for custom fields only the column header is not the name of the custom field (say Product Name), but rather customfields/customfield/0/customfieldname and then the CONTENT of the cell under that header will be "Product Name". Then there will be customfields/customfield/1/customfieldname column, etc. So If I have 10 rows of issues. the column labeled customfields/customfield/0/customfieldname will have different custom field names depending on which customfields had values for each of the 10 issues. Is there a trick to get the actual name (Rank, Environment, etc) as a column so the import allows me to map the column to a jira field. Right now I can't map since the column can contain values from many different custom fields,never mind that the column name is meaningless.

In looking at the xml format I can see why it's doing this but I'm hoping there's a way or tool that lets me change this behavior, other than writing some code to tear part the csv and create it all over again.

Thanks,

Jay

customfields/customfield/0/customfieldname	customfields/customfield/1/customfieldname
Rank	Rank (Obsolete)
Rank	Rank (Obsolete)
Rank	Rank (Obsolete)
Date First Responded	Date Responded
Environment	Product
Environment	Product
Product	Rank
Environment	Rank
Environment	Fixed By
Date First Responded	Date Responded