[Piwik-hackers] Question: How to get the actions>pages widget to also display the domain name?

[Stephen Stroup]

Another update. It seems to be a problem with the parsing. I dove into the
mysql database. Here's what I got:

mysql> SELECT piwik_log_action.name, piwik_log_visit.idsite FROM
piwik_log_action, piwik_log_link_visit_action, piwik_log_visit WHERE
piwik_log_action.idaction=piwik_log_link_visit_action.idaction AND
piwik_log_link_visit_action.idvisit=piwik_log_visit.idvisit AND
piwik_log_visit.idsite>=3 AND piwik_log_visit.idsite<=4 GROUP BY
piwik_log_action.name ORDER BY piwik_log_visit.idsite;
+---------------------------------------------------------------------------------------------+--------+
|
name
| idsite |
+---------------------------------------------------------------------------------------------+--------+
|
proxy_setup/display.php
|      3 |
|
404.aspx?aspxerrorpath=/admin/default.aspx
|      3 |
|
index
|      3 |
|
analytics/test_page.php
|      3 |
|
piwik/index.php?module=Home&amp;action=index&amp;idSite=1&amp;period=day&amp;date=yesterday
|      3 |
|
piwik/piwik.php
|      3 |
| http://piwik.org
|      3 |
|
info.php
|      3 |
|
analytics/test_page.html
|      3 |
| http://lsproxy12.byu.edu/404.aspx?aspxerrorpath=/admin/default.aspx
|      4 |
| http://lsproxy14.byu.edu/proxy_setup/display.php
|      4 |
| http://lsproxy12.byu.edu/
|      4 |
| http://lsproxy11.byu.edu/
|      4 |
| http://lsproxy14.byu.edu/
|      4 |
| http://lsproxy14.byu.edu/analytics/test_page.html
|      4 |
| http://lsproxy14.byu.edu/analytics/test_page.php
|      4 |
+---------------------------------------------------------------------------------------------+--------+
16 rows in set (0.01 sec)



idsite 3 corresponds to the first image/site in my previous post and 4
refers to the second.

In the default setup (used by the site with id 3), the pages widget shows a
nice hierarchy. It seems to parse the "name" and every time it encounters a
"/" it breaks it off and sticks it in a sub group. As you can see in the
images in the last post, it doesn't do this for all the listings for idsite
4. It does make subgroups under each host name, but each entry contains the
full URL rather than the section after the host name. Anyone know why this
is? Do the double slashes confuse it? I'll keep exploring.


Cheers,
Stephen


On Thu, Jul 10, 2008 at 12:18 PM, Stephen Stroup <sstroup at gmail.com> wrote:
>
> Ok, quick update. I'm a little closer to my goal but not all the way there
yet. I changed
> piwik_action_name = '';
> to
> piwik_action_name = document.location;
> in the piwik javascript code that's inserted into pages.
>
> I managed to get it from showing the following
http://i292.photobucket.com/albums/mm34/sabin126/Piwik/piwik1.png
> to showing
http://i292.photobucket.com/albums/mm34/sabin126/Piwik/piwik2.png
>
> I now have the domain name showing up. However, everything under the host
name in the tree structure still contains the host name rather than the part
which appends to it. It makes the user have to roll over each entry to
actually see what page it's talking about. Is there any way to combine the
displaying of the host name with the nice tree structure that truncates off
the text of the parent?
>
> I hope that makes sense. Sometimes I don't know the proper technical
names/terms so if you need more clarification I'll be happy to provide it.
>
> -Stephen
>
> On Thu, Jul 10, 2008 at 9:48 AM, Stephen Stroup <sstroup at gmail.com> wrote:
>>
>> Hi,
>> I'm new to the analytics scene. I'm helping set up an apache reverse
proxy server for the sites hosted by our college within our university, and
decided to go with Piwik as the analytics software. It shows a lot of
promise. After getting everything up and running with the reverse proxy and
the proper code injection, I ran into the following problem for our setup.
>>
>> All domain names will go to the proxy server, and it will dynamically
send the requests to the correct server and site on our back end. One of the
uses is for a content management system where professors and others can have
a simple interface to create their own sites within ours. These sites
however will be seen by the client as a specific domain name. With piwik
analytics so far, when I view the pages widget, I only see the part of the
URL after the domain name. So, the problem exists that all these visits are
not separated by the domains. This is even worse when domains have the same
pages (for example, index.html) as we can't distinguish them from one
another. We hope to be able to have an aggregate piwik site for all data
coming through and still be able to break it apart by the domains that were
requested.
>>
>> For some of you experienced folks I'm sure this is a very simple and easy
problem. If anyone can help with the easiest/simplest solution, I would be
much obliged. If more information is needed let me know.
>>
>>
>> Sincerely,
>> Stephen Stroup
>
>
> --
> Stephen Stroup


--
Stephen Stroup
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.piwik.org/pipermail/piwik-hackers/attachments/20080710/6ecd581c/attachment-0001.htm