Joost, does this mean you would like to read the table containing the report
with a tool? And to achieve this you are asking for an ID tag?

Created attachment 13846 [details]
Dynamicly imported bug count and feature statistics

JA: I created a Calc document which gets data from the report functionality
within IssueTracker. This data is imported via '/Insert/External Data' feature
in Calc. This feature can directly select the table within the output of
IssueTracker but as far as the HTML import functionality has improved in OOo
src680 a different part of the html document is selected if you load it in a
src680 version. As a result the data imported into Calc is broken. The only way
to get around this problem is to name the table via an ID tag within the HTML
report generation in IssueTracker. To get an idea how it works just load the
document attached in a srx645 version.
JA->ST: please configure a proxy before you load this document.

reassign to support

I am not sure what the RFe is about..
is it asking collab to name a ID TAG to the tables
or to correct the HTML functionality of src68 ver ??

Can you please elaborate on your needs ?

thanks

mohan

Yes, it is asking collab to name a ID TAG to the tables.

Update : I have Filed an internal query for the enhancement
Will update the response of the engineers as & when i receive them

-Mohan

The engineers have posted the following questions

1. How exactly are you "directly accessing the tables 
within the output of Issuetracker"? 

2. What method are you following  to get an HTML file with a table of IZ query 
results ?
Are you saving the entire page using the browser "save as"?
If thats the process then they recommend that you either use one of 
the handy buttons at the bottom of the page to export the table to a comma or 
tab delimitted file, or highlight just the table and copy/paste it into Calc.

Thanks

Mohan

Joost->Mohan: just read my posting above...

Those questions were asked as the above posting was not clear for the engineer. 
Can you please explain it better?

St: Can you help us getting more information on this?

Thanks
Priya

JA: If you use menu item '/Insert/External Data' in OpenOffice.org Calc to
import HTML content then HTML tables can be selected by their number (in this
case tables are numbered by Calc) or by their name (if an HTML ID tag is given
within the HTML code).

As the HTML import has been improved in the upcoming version of OpenOffice.org a
different table is loaded into Calc if I use the same document to import the
IssueTracker report. As a result the imported data is garbage.

To workaround this problem I would like to have the ID tags set within the HTML
code generated by IssueTracker because I plan to _publish the OpenOffice.org
Calc document to generate the 'IssueTracker bug count, features & enhancements,
oooqa keyword and additional statistics'
(http://qa.openoffice.org/iz_statistic.html)

This document automates a lot of my work on creating the statistics.

reassigning to me for further investigation with Joost

1. How exactly are you "directly accessing the tables within the output of
Issuetracker"?
Start OpenOffice.org Spreadsheet
Use menu item Insert / External Data
Enter the URL of the report

Then you will see a list of several available tables from the document which are
arbitrary named.

2. What method are you following  to get an HTML file with a table of IZ query 
results ?
We are taking about reports and not queries.
The method is HTTP GET :-)
Seriously, OpenOffice.org's Spreadsheet is able to work on a document given by
an URL retrieved via HTTP.
This avoids the unnecessary additional step to download a temporary file and
allows easy updates.

And yes, the issue is asking collab to name a ID TAG to the tables - esp. to the
table contraining the report. This allows correct addressing of the report data
range with a well-defined URL.

Still on engineers queue.
Have queried them for the information. will update when a comment is received 
from the engineers

mohan

Is your asking, that the data tables in buglist.cgi (or possibly 
reports.cgi) have something like:
  <table id="foo">...</table>
So that the application has a point of reference as far as which table to 
grab ?
Is the import to Calc just looking 
for some kind of indentification (that we arbitrarily decide) so that the user 
can choose something to import?

please confirm whether this is report or query output that is being 
imported? & also (if possible)  Please provide an example URL that you want to 
use in this manner.  


Mohan

Assigning to st

Mohan

JA->Mohan: In  
http://qa.openoffice.org/issues/reports.cgi?state=Open+issues&issue_type=DEFECT&containing=&type=case-insensitive+substring&x=Component&y=Status

it's the sixth table within the html output which is used and which needs a name
tag.

Joost, let's answer all the asked questions.
reassigning to me...

It seems this issue is outdated. Feel free to reopen if appropriate...