Logs are per line, My hash should look like the second example you have given above. I am getting syntax error for second code.

I tried the first code given above and it works fine. I am able to get the all websites and categories for each user. Thanks a lot.

I will now work on getting count for each Website and Type.

Name: John
Website Count
google.com  10
yahoo.com    8
facebook.com 5

Type Count
Search Engines    10
Entertainment     8
Social Networking 5
[download]