[Mantis] Export to Excel
zebug
Posted messages
5
Status
Member
-
mzfr -
mzfr -
Hello,
I’m working on a Mantis software to track bugs, and I would like to plug Mantis and export data to Excel using Macros, as this will allow me to set up a bug tracking indicator. Anyone who can help with this is welcome.
Thank you
I’m working on a Mantis software to track bugs, and I would like to plug Mantis and export data to Excel using Macros, as this will allow me to set up a bug tracking indicator. Anyone who can help with this is welcome.
Thank you
Configuration: Windows XP Internet Explorer 7.0
5 answers
-
Hello
I think you should rather use Mantis's features for that because you're going to complicate your life trying to combine updates... possibly creating other bugs!
--
Always zen -
Hello
Which of the two operating systems is the best?
That's the question everyone wants an answer to, even though it doesn't exist.
If I ask you "which is the best car: the Testarossa or the 2 CV?" try to give me an answer?
Testarossa? Try going on country paths and you'll see a 2 CV is much better!
For software, it's a bit similar: some use Word, but sometimes Notepad is far more appropriate...
--
Always zen-
Hello
thank you for the comparisons between Testarossa and CV, well, I have to submit a report because the company I work for, an SSII, has acquired another one, while the other one uses Bugzilla and the internal developers use Mantis, the goal is to use a single software for both companies, or for everyone.
That's why I wanted the opinion of people who know.
Otherwise, I will conduct surveys on the use of both software.
There you go.
-
-
Hello, I read your question and I understood that you are working on Mantis "bug and enhancement management", is that correct? I won’t answer your question, but I would like you to help me resolve this issue.
If I make the summary, the title of the graph does not support the "é". For example, if I make the summary by state, the word state displays like this " état ". I want to fix this issue, thank you. -
Hello.
To export data from Mantis to Excel and automate everything, the simplest way is to:
create an Access query that points to the SQL table where the data is stored.
Record an automatic import format (in Access)
replace the "é" and other characters that did not pass (this can be done in Excel by recording a macro with "Ctrl + H", selecting "&345", replacing with "é", "replace all" (the "&345" is an example).
Then export to a text file to reimport it in Excel. (you can export directly to Excel, but anyway).
I used this procedure to then do a mail merge to Word, the manipulation took about 10 minutes. Hope this helps. -
