In many aspects, you can consider SQLNotes as Excel with outlining capabilities, as the outlining tree supports formatting and has user-defined columns (text, date, number or checkbox types). The outlining grid is fully editable, printable and exportable. Equations can be defined between columns (i.e. fields or attributes in URp) and between rows (hierarchy based calculations). Item properties (color, backcolor, font, icons) can be determined from field values. Pivot tables and charts can also be used to summarize your info. Finally, as in UR, a rich text pane (HTML in SQLNotes, RTF in URp) is available to enter rich text content.

-PPLandry (August 01, 2008, 09:11 AM)

Yes, sqlNotes has a leg-up in many areas, it will be interesting to see what developes in the future for both programs.

Yeah, I would rather be able to scan automatically if possible since I am trying to track installations on three computers.  As for the Excel spreadsheet, that only covers my desktop computer - not the others.

As for using UR to store what I already have in Excel, that would be easy enough to put in there, but I guess my understanding of UR is lacking enough that I can't see what benefit that has.  UR has no inbuilt spreadsheet functionality, nor can it even be used to create tables other than very rudimentary ones that seem to be limited with very few attributes.  I have created a few but then discovered that I cannot do even a fraction of what I can do with tables in Word and other apps.

I guess I could just drag or import the Excel file there and then, what? View it in UR? Could I actually do anything with it in UR? Edit it?  Add programs to it?  Add in programs for the other computers?  or would I also need to complete those in Excel and pull it into UR?

-J-Mac (July 30, 2008, 11:54 PM)

Yes, for the number of systems you want to track scanning would be a big plus, especially if you want some real depth and detail for each system.

Regarding UR, Excel, and Tables

You wouldn't necessarily want to drop the native Excel file into UR, what I envisioned was creating UR Attributes to match the Excel column headings, export to csv from Excel then import that into UR. Your "spreadsheet-like functionality" would come from the grid display in the Child and Search Panes, granted these grid cells are not yet editable. There is a sample UR database - Software Inventory - that may give a glimpse into the possibilities.

I believe that similar functionality is available in sqlNotes.

Yes, table creation and manipulation in UR lacks a number of features, you've just about got to create and populate the table in Excel or Word before bringing it into UR (as RTF), and even then it would be more for presentation purposes.

John,

I realize that .mht is a MS/IE only format, but what's puzzling about UR's current state is that UR has always had such tight integration with MS products. It would appear that both browsers have a handle on page capture, but I will admit that there have been times when the Save Page As .mht has hung, failing to complete and forced shutdown of the browser is required. Sometimes you can re-launch the browser, try again and it will succeed, other times...

I would imagine that it's no small task to go out and grab all the related bits and pieces that determine how a page is rendered.