View Issue Details

IDProjectCategoryView StatusLast Update
0031550mantisbtplug-inspublic2023-01-03 05:04
ReporterIASTSS Assigned Todregad  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
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)   

Relationships

related to 0031876 closeddregad XML import: Undefined property warning when importing bug notes 

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.

atrol

atrol

2022-12-05 14:12

developer   ~0067193

IASTSS,

You did not provide any feedback; I am therefore resolving this issue as "no change required".

Feel free to reopen the issue at a later time and provide the requested information.