SID-02100: export WebStatistics into Excel

Status:	Answered	TWiki version:	6.0.0	Perl version:
Category:	CategoryStatistics	Server OS:		Last update:	10 years ago

How can I use the log files or any other method, to get the statsitcs from TWiki into an Excel spreadsheet for additional analytics?

-- TWiki Guest - 2015-08-24

Discussion and Answer

Do you want to do that with one of the WebStatistics, or the global SiteStatistics? Both are TWiki tables embedded in the topic, e.g. you should be able to copy the text in view mode, and paste into an Excel spreadsheet.

However, some cells don't have just a number, such as | 574 (52 unique users) |. If those cells are needed, you either need to manually clean them up, or create a utility topic that does that. That utility topic contains a VarSEARCH variable with a FormattedSearch. Do a search that identifies table cells, and add a multiple="on" parameter so that each search hit is one table row. In the format="..." parameter to can add RegularExpression $pattern() to pull values from certain cells.

Look also into the LogsStatisticsPlugin and UsageStatisticsPlugin.

-- Peter Thoeny - 2015-08-24

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.