Developer Network : Unanswered Threads - Data Extraction

Building/Testing Against REST Web Services

webtrends@webtrends-dev.sgaur.hosted.jivesoftware.com — Thu, 24 Sep 2009 17:02:55 GMT

When building & testing web services (DX REST) I have generally just hit the web services and pulled down the report, profile list, report list, or whatever other data I needed. However there is a problem with doing this, continuously pulling the report data down uses up usage unnecessarily & is also somewhat slow for debugging & troubleshooting.

What I'd like to be able to do is to either save, cache, or otherwise maintain a local repository of DimensionalReport Objects that I've previously retrieved form the web services. I have tried to serialize the returned objects but errors occur.

Does anyone have any other ideas, insight, or thoughts on how to setup an environment that wouldn't require continuously hitting the web services?

ODBC Access to WebTrends

webtrends@webtrends-dev.sgaur.hosted.jivesoftware.com — Wed, 09 Sep 2009 12:43:21 GMT

Hi everybody,

I'm searching for documents and howtos how I can access data from WebTrends. As i focus the software solution, the only way is via ODBC in the moment?

Do you have any documents, hints, ideas?

TIA,

Michael

Support for legacy reports

webtrends@webtrends-dev.sgaur.hosted.jivesoftware.com — Fri, 26 Jun 2009 17:51:54 GMT

In the documentation there are 33 legacy reports that are not supported in REST. While you suggest creating a custom report with the same data to get the covered, that not only uses up a customer's alloted custom reports with unnecessary duplication, but also you do not get any history before the report was generated. Are there plans to support these reports? If not, we will probably have to use SOAP to maintain data continuity.

DTS

Express Hourly Interval Data

webtrends@webtrends-dev.sgaur.hosted.jivesoftware.com — Fri, 12 Jun 2009 19:55:38 GMT

Will we be able to pull hourly interval data for current day (Express) data using the REST api for Page View based measures?

Our Editors would like to be able to see how various page components (modules), as well as for pages, sections and other reports, are performing on an hourly basis to ensure page real estate is being used effectively. For example, say a module has a solid number of clicks and a high CTR for the day overall, but there is a drop off in the clicks after a couple of hours, they would like to know when that drop-off happens, and then use that information to add/remove/modify content. Ideally, they are askign for real-time, but hourly data would be a big step in the right direction, and extremely useful.

a name was started with an invalid character. Error processing resource.

lalo.whitney@webtrends.com — Tue, 12 May 2009 17:28:08 GMT

https://ws.webtrends.com/beta/ReportService.svc/profiles/2sEJFNsnOr5/reports/ctHyvTe3ix5/?period=current_month-1&format=excel

Trying this URL in excel generates the above message. I used the Generator to get this URL and any insight as to the issue is appreciated.

If you wanted to test and need a username/pass, message me and I'd be glad to send it.

Also, I tried the folllowing URL with the same result.

https://ws.webtrends.com/beta/ReportService.svc/profiles/2sEJFNsnOr5/reports/ctHyvTe3ix5/?period=2009m04&format=excel

Utilities for keeping configurations organized

cgrant@enlighten.com — Thu, 23 Apr 2009 23:58:56 GMT

We have a lot of custom reports & custom components, and a lot of profiles also. We need to keep them organized and perhaps most importantly need to be able to go through them looking for inconsistencies or problems or to doublecheck that we set them up right. As you know the configuration information is scattered through a lot of .ini files.

Do you developers (or perhaps you Professional Services people) have tools that help with this? The Summary screens for profiles or custom reports are helpful, but they have to be visited and copied individually. And they have to be converted into a spreadsheet or maybe a database to be more useful than the simple text format.

We use the WT software, so we've written a script that collects settings from several ini files and produces a basic dump (spreadsheet) for all our custom reports - names, GUIDs, dimensions, measures, filters, and a few other things. Even though the output is fairly primitive, it's a big time-saver especially when we leverage Excel for sorting etc.

We'll be doing the same thing for profiles, custom filters, and so on. Eventually we'd also like to do something that will write the values back to the ini's if we change them, for example if we do a universal change to the name of a parameter.

But we're hoping you have or are working on something even better than our little script approach.

One example use: If a parameter name changes, what are all the filters and dimensions and measures that use that parameter? (We have to check every one for possible effects.)

Another use: We just created 80 filters that get applied to 100 different custom reports. Did we turn them on for all the right reports? Are all the filters set to use regex, or did we miss some?

P.S. I realize that this Developers Network is really intended as a Developers-using-Open-Exchange Network, but somehow I perceive this challenge as fitting in. Or, at least, I want it to be discussed a little and have no place else to go!