View Issue Details

IDProjectCategoryView StatusLast Update
0031550mantisbtplug-inspublic2022-11-24 09:37
ReporterIASTSS Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionopen 
Summary0031550: Unable to import xml data
Description

I am migrating from AFAS to Mantis for bug reporting and got a Excel file with data.

From this data over a 1000 records I have created an xml with VBA but from some reasons this is not processing.

What am I missing or is it mandorty to put all the enums in?

TagsNo tags attached.
Attached Files
image.png (2,345 bytes)   
image.png (2,345 bytes)   
1.xml (2,480 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<mantis version="2.25.5" urlbase="https://ownurl" issuelink="#" notelink="~" format="1">
<issue>
	<project>ProjectName</project>
	<reporter>Reporter1</reporter>
	<status>Closed</reporter>
	<date_submitted>1418342400</date_submitted>
	<last_updated>1461169514</last_updated>
	<view_state>private</view_state>
	<summary>Summary 1</summary>
	<description>Summary 1</description>
		<bugnotes>
		<bugnote>
			<reporter>Developer 1</reporter>
			<note>Note1</note>
		<view_state>/bugnote</view_state>
		<view_state>/bugnotes</view_state>
</issue>
<issue>
	<project>ProjectName</project>
	<reporter>Reporter1</reporter>
	<status>Closed</reporter>
	<date_submitted>1418342400</date_submitted>
	<last_updated>1421228910</last_updated>
	<view_state>private</view_state>
	<summary>Summary 2</summary>
	<description>Summary 2</description>
		<bugnotes>
		<bugnote>
			<reporter>Developer 2</reporter>
			<note>Note6</note>
		<view_state>/bugnote</view_state>
		<view_state>/bugnotes</view_state>
</issue>
<issue>
	<project>ProjectName</project>
	<reporter>Reporter2</reporter>
	<status>Closed</reporter>
	<date_submitted>1418601600</date_submitted>
	<last_updated>1461169999</last_updated>
	<view_state>private</view_state>
	<summary>Summary 3</summary>
	<description>Summary 3</description>
		<bugnotes>
		<bugnote>
			<reporter>Developer 2</reporter>
			<note>Note7</note>
		<view_state>/bugnote</view_state>
		<view_state>/bugnotes</view_state>
</issue>
<issue>
	<project>ProjectName</project>
	<reporter>Reporter3</reporter>
	<status>Closed</reporter>
	<date_submitted>1418601600</date_submitted>
	<last_updated>1655455701</last_updated>
	<view_state>private</view_state>
	<summary>Summary 4</summary>
	<description>Summary 4</description>
		<bugnotes>
		<bugnote>
			<reporter>Developer 1</reporter>
			<note>Note9</note>
		<view_state>/bugnote</view_state>
		<view_state>/bugnotes</view_state>
</issue>
<issue>
	<project>ProjectName</project>
	<reporter>Reporter3</reporter>
	<status>Closed</reporter>
	<date_submitted>1418601600</date_submitted>
	<last_updated>1528139760</last_updated>
	<view_state>private</view_state>
	<summary>Summary 5</summary>
	<description>Summary 5</description>
		<bugnotes>
		<bugnote>
			<reporter>Developer 3</reporter>
			<note>Note11</note>
		<view_state>/bugnote</view_state>
		<view_state>/bugnotes</view_state>
</issue>
</mantis>
1.xml (2,480 bytes)   

Activities

IASTSS

IASTSS

2022-11-23 10:27

reporter   ~0067158

image-2.png (15,610 bytes)   
image-2.png (15,610 bytes)   
dregad

dregad

2022-11-24 09:37

developer   ~0067162

If the 1.xml attachment is the actual file you're trying to import, note that

  • it is not valid XML (e.g. mismatched &lt;status>Closed&lt;/reporter>or missing closing tags &lt;/bugnote>)
  • some mandatory fields are missing

Please consider that the XML import plugin was originally designed to process data that it generated itself (using XML export function).

Since you're importing from another source (custom generated XML) you must make sure that all expected fields and attributes are properly populated, and matching the expected structure (use the Export XML function for a sample).

Alternatively, you may want to try the CSV import plugin instead, it may cause less friction.

If you want to stick with importing XML, it may be an opportunity to improve the plugin. Feel free to submit a pull request.