I am a contractor working with a client using OnTime 2004 Web Edition.

For tracking certain metrics, I cut-and-paste the Defects list into Excel and generate PivotTable Charts.  Because of the way the cut-and-paste technique is working*, this is very time consuming, taking over 30 minutes for less than 300 Defects to be pasted into an Excel sheet.

 I am wondering if there is anyway to directly access the database being used by OnTime (coworkers and project manager don't know) so that I can have Excel directly point there, instead of me doing it by hand?

Using the Web Query tool in Excel is not an option since I can't do more than one page at a time and I'm limited to viewing 100 at a time.

Upgrading is also out the window since we don't have the resources, or time.

 --

I can't cut-and-paste directly into Excel since it copies the Action column, which cannot be turned off and while the column can be deleted, the icons stay, causing memory/bloat problems.  I can't cut-and-paste directly into notepad/wordpad, since the column delimiter is a space, not a tab, and will cause import problems in Excel (not-fixed width).

The workaround is to cut-and-paste no more than 50 rows at a time into Word, delete the Actions column, copy the remaining table into Excel, clear the Clipboard, rinse and repeat.  Very time consuming...

You should be able to just export the data from the grid directly to a CSV file.  There's a button on the toolbar to export.

---

Dan Suceava
http://www.axosoft.com

There is no export button, there is a print button.

Printing creates a PDF with no grid for the data, instead copy-and-paste shows that there is exactly one space between one column and the next, rendering trying to paste in Excel meaningless.

Is it on any of the menus?  I was testing with 4.2.6 and it was on the toolbar, and just looked in our system that it was added to the toolbar in 4.1.

---

Dan Suceava
http://www.axosoft.com

As stated above, I'm using 4.0.3.0.

There is no print or export option in my toolbar.  It may be because I don't have admin rights, but it shouldn't apply

 The print / print details option is listed under the menu, within the header of the right pane.

Right, the toolbar button would have been added after 4.1.  But you don't have the option to export defects on the Defects menu?  It could very well be a security issue, can you have an administrator check your permissions?

---

Dan Suceava
http://www.axosoft.com

My current Defect Menu options is as follows (you can see the attachment):

New, Manage Workflow (disabled), Manage Filters, Manage Custom Fields (disabled), Edit Columns

 

I'll check with the admin, but don't expect a response soon, low-level issue at best.

 

 

My current Defect Menu options is as follows (you can see the attachment):

New, Manage Workflow (disabled), Manage Filters, Manage Custom Fields (disabled), Edit Columns

 

I'll check with the admin, but don't expect a response soon, low-level issue at best.