Can I count how many times a folder has been opened?

I have seen some other messages here about counting the number of times a folder has been opened although didn't understand totally how to implement the solution or they didn't work. Trying to do something similar to a "hit counter" and be able to report how many times the folder was open?Any suggestions? Can it be done with a Live Report?

Find more posts tagged with

Comments

eLink User

Message from David Slimmon via eLinkHi there,One of the neat things that someone did - not exactly sure how it wasimplemented and haven't tried it myself...But what they did was they added a very small transparent gif to acustomview.html page and then added it to a Livelink folder. Then what theydid is they turned on Livelink auditing and audited the number of times thatthat image was fetched. Because that image would be fetched every timesomebody opened the folder, it would appear in the audit log and you couldthen generate a Livelink report on that action in the DAudit table.Again, I haven't tried this, but it sounded really neat and it kind of makessense.Cheers,Dave-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Friday, October 26, 2001 10:43 AMTo: eLink RecipientSubject: Can I count how many times a folder has been opened?Can I count how many times a folder has been opened?Posted by 18User3 on 10/26/2001 10:40 AMI have seen some other messages here about counting the number of times afolder has been opened although didn't understand totally how to implementthe solution or they didn't work. Trying to do something similar to a "hitcounter" and be able to report how many times the folder was open?Any suggestions? Can it be done with a Live Report?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

eLink User

Message from Steenbergen, Remco van (Commit) via eLinkBetter is to put al you gifs transparent gifs into a separate folder, so youcan query all the gifs in one time. You make the gifs available to show them as a banner in a folder, so itwould not bother the customviewsCheersRemco -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: vrijdag 26 oktober 2001 17:06To: eLink RecipientSubject: RE Can I count how many times a folder has been opened?RE Can I count how many times a folder has been opened?Posted by eLink on 10/26/2001 11:05 AMMessage from David Slimmon via eLinkHi there,One of the neat things that someone did - not exactly sure how it wasimplemented and haven't tried it myself...But what they did was they added a very small transparent gif to acustomview.html page and then added it to a Livelink folder. Then what theydid is they turned on Livelink auditing and audited the number of times thatthat image was fetched. Because that image would be fetched every timesomebody opened the folder, it would appear in the audit log and you couldthen generate a Livelink report on that action in the DAudit table.Again, I haven't tried this, but it sounded really neat and it kind of makessense.Cheers,Dave-----Original Message-----From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf OfeLink Discussion: Livelink LiveReports DiscussionSent: Friday, October 26, 2001 10:43 AMTo: eLink RecipientSubject: Can I count how many times a folder has been opened?Can I count how many times a folder has been opened?Posted by 18User3 on 10/26/2001 10:40 AMI have seen some other messages here about counting the number of times afolder has been opened although didn't understand totally how to implementthe solution or they didn't work. Trying to do something similar to a "hitcounter" and be able to report how many times the folder was open?Any suggestions? Can it be done with a Live Report?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe[To reply to this thread, use your normal e-mail reply function.]============================================================Topic: Can I count how many times a folder has been opened?https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2605090&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe**********This message and any attachment are confidential and may containprivileged information intended only for the use of the individual orcompany named above. If you are not the intended recipient, please telephone or email the sender and delete this message and anyattachment from your system. If you are not the intended recipientyou must not copy this message or attachment or disclose the contentsto any other person.Neither the sender nor the group of companies to which the sender belongs can accept any responsibility for any use or misuse of this message or its attachments.

18User3_(Delete)_2154966

Can you tell me how to write the Live Report (so I can cut and paste it in) so that it will give me the count? I have a Live Report that counts the "most viwed/fetched documents" and puts them in descending order. I'd like to be able to give a specific id (the banner) and see how many times it has been opened.Appreciate your assistance.

jamespate

select kuaf.name, kuaf.firstname, kuaf.lastname, count(auditdate) "accesses" from daudit, kuaf where dataid = %3 and event = 'FETCH' and auditdate >= %1 and auditdate <= %2 and userid = id group by kuaf.name, kuaf.firstname, kuaf.lastname order by count(auditdate) desc%1 is input 1, Date From%2 is input 2, Date To%3 is nodeid, NodeID of customview.html file (or any file for that matter)Apologies if SQL is lame - not my area!

18User3_(Delete)_2154966

I get an error stack message: cannot prepare cursor messageHow do I enter the Date From (format)Any other settings that need to be set?Thank you!!

jamespate

Inputs Section:type : date, prompt : Fromtype : date, prompt : Totype : number, prompt : NodeIDParam %1 : User Input 1Param %2 : User Input 2Param %3 : User Input 3Report Format : Auto LiveReport

18User3_(Delete)_2154966

Thanks! This worked but it provides me a list of each user who has accesed the site and their number of times. Is there a way to also count the total number of times the folder was opened - without showing each user?

jamespate

select count(auditdate) "accesses" from daudit where dataid = %3 and event = 'FETCH' and auditdate >= %1 and auditdate <= %2Might want to run this thread in email: john.underhill@crowncastle.com

18User3_(Delete)_2154966

What do yu mean - run this thread in email?