I'd like to be able to download bugs to a spreadsheet. So I downloaded and installed OLE 0.5. So it tries to produce an output, but my Excel (Win 2000) complains about a non recognized format and shows a very ugly result :(
So I tried to update the Spreadsheat Excel part of pear too (version 0.8), but I still get the same message :(
Any clue? anything I could do about it?
Thanks,
Rolf
rgrau@cgiar.org
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
An easy manual way to get the table produced by a phpBugTracker query into a spreadsheet:
1) Issue the query as usual in your web browser;
2) Select the resulting table;
3) Choose "Copy" (Ctrl-C);
4) Select a cell in your spreadsheet;
5) Choose "Paste" (Ctrl-V).
And there you have it!
If you're trying to automate the process, or be able to issue the query from within Excel, it's a little more complicated. I don't know how OLE would handle it, or if it can. If you have Perl (or something similar) installed on your system, however, you could do something like this:
1) Write a Perl script that will:
a) Take a query string and submit it to phpBugTracker;
b) Parse the resulting html to extract the table data containing the list of bugs;
c) Write out that table data to a file in tab-delimited format.
2) Within Excel, have a VisualBasic script that:
a) calls the Perl script (via, for example, the Shell() command);
b) opens the tab-delimited file in Excel;
c) does any other manipulations you please (reformatting, for example).
That's a bit kludgy and involves a bit of programming, but I think it can be made to work. The whole process could probably be streamlined if you used an XML-based spreadsheet such as OpenOffice Calc instead of Excel.
I hope this helps.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried the first option of these, and it worked :)
...although it is not what I would like to do in the long-run... :|
As a matter of fact, I had tried this before, but using Firefox - and it did not work! :(
Maybe PHPBugTracker should try to export to csv rather than xls directly.
Thanks again,
Rolf
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'd like to share another hint by Benjamin Curtis:
"As a short-term fix, you could login to the tracker with IE, then get the bug results you want. Open Excel choose Data -> Get External Data -> New Web Query. Enter the same URL that is loaded in IE, and you (hopefully) will get a view that allows you to select the table with the bug data."
I have tried this too, and it works - although security restrictions of the PHPBT does not show all the fields I need. But could be a solution sometimes.
Regards,
Rolf
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
I'd like to be able to download bugs to a spreadsheet. So I downloaded and installed OLE 0.5. So it tries to produce an output, but my Excel (Win 2000) complains about a non recognized format and shows a very ugly result :(
So I tried to update the Spreadsheat Excel part of pear too (version 0.8), but I still get the same message :(
Any clue? anything I could do about it?
Thanks,
Rolf
rgrau@cgiar.org
An easy manual way to get the table produced by a phpBugTracker query into a spreadsheet:
1) Issue the query as usual in your web browser;
2) Select the resulting table;
3) Choose "Copy" (Ctrl-C);
4) Select a cell in your spreadsheet;
5) Choose "Paste" (Ctrl-V).
And there you have it!
If you're trying to automate the process, or be able to issue the query from within Excel, it's a little more complicated. I don't know how OLE would handle it, or if it can. If you have Perl (or something similar) installed on your system, however, you could do something like this:
1) Write a Perl script that will:
a) Take a query string and submit it to phpBugTracker;
b) Parse the resulting html to extract the table data containing the list of bugs;
c) Write out that table data to a file in tab-delimited format.
2) Within Excel, have a VisualBasic script that:
a) calls the Perl script (via, for example, the Shell() command);
b) opens the tab-delimited file in Excel;
c) does any other manipulations you please (reformatting, for example).
That's a bit kludgy and involves a bit of programming, but I think it can be made to work. The whole process could probably be streamlined if you used an XML-based spreadsheet such as OpenOffice Calc instead of Excel.
I hope this helps.
Thanks Carl
I tried the first option of these, and it worked :)
...although it is not what I would like to do in the long-run... :|
As a matter of fact, I had tried this before, but using Firefox - and it did not work! :(
Maybe PHPBugTracker should try to export to csv rather than xls directly.
Thanks again,
Rolf
I'd like to share another hint by Benjamin Curtis:
"As a short-term fix, you could login to the tracker with IE, then get the bug results you want. Open Excel choose Data -> Get External Data -> New Web Query. Enter the same URL that is loaded in IE, and you (hopefully) will get a view that allows you to select the table with the bug data."
I have tried this too, and it works - although security restrictions of the PHPBT does not show all the fields I need. But could be a solution sometimes.
Regards,
Rolf