List Your Custom Report Configuration Settings in Excel

A cscript that reads the custom report settings in your WebTrends On Premises server and produces a summary of their configurations.

Be Sociable, Share!

Applies to:  Software (On Premises)

This post is about a script that will produce an Excel spreadsheet that lists all of your custom reports and their configurations.  You can use it with On Premises software.  For On Demand, Webtrends has nothing similar.

Attached to this post is a quick and dirty (actually, somewhat slow and dirty) cscript that parses through all your WebTrends configuration files, or .ini files, and creates a tab-delimited text file with all the settings for all your custom reports.  It shows the name of each custom report, its GUID, and it looks up all the filter and dimension GUIDs and displays their names.  It was written by Mister Peabody who plans to polish it up some day, unless WebTrends Inc provides us with something slicker and better.

The tab-delimited file the script produces can be opened with Excel, producing a spreadsheet with these columns:

  • Ini Section:  this column shows the section heading within the original config file, should you want to open the config file and find the report’s raw configurations quickly.  You’ll probably never use the information in this column.
  • Report Name:  the name or title of the report.
  • Report GUID:  the GUID or ID number assigned to the report by WebTrends and used internally by WebTrends.  It’s listed here because if you open a profile .wlp file, you’ll see only GUIDs for custom reports..
  • Profile Category:  if you assigned the report to a WebTrends custom category, the category name appears in this column.
  • Dimension 1:  the name of the report’s first or primary dimension, with the dimension’s GUID in case you ever want to look it up in the original ini file.  Also, the dimension information is annotated as to whether it’s a hit dimension or visit dimension, according to WebTrends, but only for custom dimensions you’ve created.  Out-of-the-box dimensions are identified as such (“OOTB”) but the config files provide no information about visits-vs-hit basis, so the output doesn’t show it.
  • Dimension 2:  Same as above, but for the second or secondary dimension, if there is one.
  • Exclude Filters:  names of all Exclude filters applied to the report.  They will be marked “hit” or “visit” depending on their basis.
  • Include Filters: names of all Exclude filters applied to the report.  They will be marked “hit” or “visit” depending on their basis.

Rightclick here and Save Link As, to obtain the “Dump of WebTrends Custom Report Configurations” script.

Here’s how to use this little script once you have it.

  1. Remove the “txt” filename extension
  2. Edit the line that defines the location of the configuration files.  If your configuration files are in the default location and your program is in the default location, all you have to do is replace “X:” with the drive letter
  3. Put the file somewhere accessible, like the root of the drive where WebTrends is installed
  4. Browse to it with Windows Explorer and double click on it
  5. Wait – it can take a while.

Details

  • If a cell contains more than one configuration setting (for example, if the report has multiple filters), you’ll see all of them together in one cell, but each will be separated by a pipe character (vertical line |).  You can neaten up these cells by turning the pipes into within-cell line breaks, i.e. turn them into a list inside the cell.  Because the pipe character is tricky in Excel, here’s how to do it in Excel for all of them at once:  do a global search and replace where “|” is replaced by Alt-0010 (that’s “hold down the Alt key and press – ON THE NUMERIC KEYPAD NOT ON THE ALPHA KEYPAD – zero zero one zero”).  Onscreen it will look like you’re going to replace the pipe with nothing, but Alt-0010 is an invisible “within-cell-line-break” character.
  • If you look at the script code you’ll see that it’s fairly repetitive and adaptable (by you, if you care to try).  But, remember, we’re just tossing it out there.  We don’t support or warranty it.
Be Sociable, Share!

9 thoughts on “List Your Custom Report Configuration Settings in Excel”

  1. Any reason measures were not included in this? We employ many custom measures in our reports as well. This would be helpful.

  2. Once again thank you for another very useful post and tool. I will use it even though I only have a few dozen custom reports.
    — Andy

  3. I do not often comment on blogs but I have to agree with Marc about how this is missing from any analytics program I have ever used, it is a very important piece, why don’t the vendors know this?

  4. UNBELIEVABLE. THANK YOU SO MUCH.

    You are the long sought somebody who takes the extensive, busy user’s obstacles seriously. I have been looking for something like this for a long time. All software should have it and WebTrends should have been doing this a long time ago. WebTrends talks like it is a vendor to big customers but its interface is still for little customers.

    End of rant, but WebTrends please pay attention to what happens in this top-notch blog!

Leave a Reply

Your email address will not be published.