Mantis Bug Tracker - Forums

Hello,

Is there any ways to import data from an Excel spreadshit.
My issue is that all the current bugs I follow are listed in an excel spreadshit and I would like to retrieve as many info. as possible into Mantis.

Thanks

Try exporting the Excel spreadsheet to CSV and using the following patch to import it:
http://www.mantisbt.org/bugs/view.php?id=4220

I also propose a plugin to import from an XML file (see the link in my signature).
In the forum,we discuss about importing from excel file by using a macro to convert the spreadsheet in XML.

I would like to import data from an Excel spreadsheet into Mantis. I searched the forum for information about using a macro to convert the spreadsheet to XML, but only got results in French. Can anyone provide an explanation in English?
Thank!

I would like to add in this feature that the import actually go into a temporary table or something with some management capability to detect duplicates prior to
populating the actual Mantis Issue table.

The use case.
1. user accidentally imports the same file twice. Now you have to manually delete all the duplicates.
2. some of the imported issues are duplicates of what was already imported.
3. what if some of the imported issues were updates to a prexisting issue? Some management feature such as
maybe add notes, override the description field, change the status shoudl be addressed etc...
I'm sure there are other issues as well.

In my ideal import scenario, taking imported data from an external source is essentially a potential edit to an existing issue already
tracked in Mantis and hence rules on whether to replace, preserve, append to should be established on what essentially is an update/merge and also changing state/status.
The easy case is of course a new issue. t

Yesterday I opened my excel files and saw that all information in it were deleted.But fortunately mylelf helped-recovering Excel spreadsheet.It is free as far as I know,besides that tool can so scan damaged Microsoft Excel worksheet and repair it,work with *.xls, *.xlam, *.xltx, *.xlt and *.xlsm formats.

Yesterday I opened my excel files and saw that all information in it were deleted.But fortunately mylelf helped-recovering Excel spreadsheet.It is free as far as I know,besides that tool can so scan damaged Microsoft Excel worksheet and repair it,work with *.xls, *.xlam, *.xltx, *.xlt and *.xlsm formats.

vboctor wrote:Try exporting the Excel spreadsheet to CSV and using the following patch to import it:
http://www.mantisbt.org/bugs/view.php?id=4220

All of my friends are speaking about next tool-repair xlsx files,They say that it is free and has a lot of good features,besides that program helped a lot of them.And tool helped me too some days ago.It can also recover maximum percents of your document manually, than the entire Excel workbook.

dfrum wrote:I would like to import data from an Excel spreadsheet into Mantis. I searched the forum for information about using a macro to convert the spreadsheet to XML, but only got results in French. Can anyone provide an explanation in English?
Thank!

All of my friends are speaking about next tool-repair xlsx files,They say that it is free and has a lot of good features,besides that program helped a lot of them.And tool helped me too some days ago.It can also recover maximum percents of your document manually, than the entire Excel workbook.