topic Re: how many documents did a user review? in Alfresco Archive

how many documents did a user review?

lucille_arkenst — Thu, 24 Jun 2010 17:55:30 GMT

Is there a built-in method to show how many documents a user reviewed? How many workflows they performed?

Re: how many documents did a user review?

buurd — Mon, 28 Jun 2010 13:05:27 GMT

No, you have to write your own loggning and than query that information.

//Roland

Re: how many documents did a user review?

lucille_arkenst — Mon, 28 Jun 2010 13:13:47 GMT

Thanks, Roland! Question – you don't mean "logging" in the traditional sense, right (log4j)? I Googled it and that's what I came up with. Do you mean write to an XML file and then query with JavaScript?

Re: how many documents did a user review?

buurd — Mon, 28 Jun 2010 14:25:57 GMT

Logging - a record of sequential data. For your purpose I'd guess a simple textfile could be good enough. It depends on how you would like to process the data after it has been logged.

Make sure that you don't get into trouble with concurrency. 🙂

//Roland

Re: how many documents did a user review?

lucille_arkenst — Mon, 28 Jun 2010 15:07:20 GMT

If there is a way to get in trouble with concurrency, I'll find it
I'm still struggling. Could you please point me to which tutorial/wiki tells me how to write to a file and query it properly? Was there a resource that you found to be particularly helpful when you were working on "Old tasks and workflows"? I assume this will be the same technique.
Thanks again!

Re: how many documents did a user review?

savic_prvoslav — Mon, 28 Jun 2010 22:04:00 GMT

HI, your problem is easy to solve but it requires some interesting coding in java for browser and some changes for the share ( if you are using it) .
So if you are java programer in soul :twisted: you could do this in browser for a few hrs.

you can log in database because this is the fastest and safest , I gues mysql is good.
also if you are good in alfreseco you can add new properties to add to user so all information is in alfresco it self ( this would be better ) .

Re: how many documents did a user review?

buurd — Wed, 30 Jun 2010 06:24:26 GMT

In the book, Alfresco 3, Enterprise Content Management Implementation, chapter 8, there are an example of how to solve the problem. It is kind of hidden in the sources you can download but they show the result in the book at page 299.

Savics suggestion is a little bit harder but if you do it right you probably could either sell it or at least publish it on Alfresco forge. Workflow logging is something that Alfresco should have provided in min opinion.

Re: how many documents did a user review?

savic_prvoslav — Wed, 30 Jun 2010 10:42:17 GMT

Hi, saw from the book. can not find the part where he generate this files…( but I guess it is done with java script)

During the process of the Review and Approval workflows, two XMLs files
are generated. These are userlogger.xml and logger.xml. These have the detailed information about the workflow in terms of initiator, assignee, start date, and end date of the workflows.

this is realy easy to implement, you just add javascript part where you find and edit this files adding some xml code.

Re: how many documents did a user review?

buurd — Wed, 30 Jun 2010 11:13:27 GMT

You have to download the source from the website about the book.

Yes, it's done with javascript and it is faily easy. But since you can't write javascript functions in workflows it gets ugly and very messy, when you have a workflow with more than a single task (lots and lots of duplication).

Re: how many documents did a user review?

lucille_arkenst — Wed, 30 Jun 2010 14:48:30 GMT

Thanks everybody, for your advice! Agreed. It is messy. That's how I was thinking about doing it initially but wanted to steer away from that route because of the messiness.
And I agree with you wholeheartedly –

Workflow logging is something that Alfresco should have provided in min opinion.

Whosoever has the time to figure out how to implement it and put it on Alfresco Forge… have at it!

In the example ftl they spin through the users and increment a count. I am wondering is there a way to find a user tag in the xml and increment a count element in the xml file itself? But we would somehow need to do that in the JavaScript in the process definition. Ugh!

Re: how many documents did a user review?

savic_prvoslav — Wed, 30 Jun 2010 16:37:03 GMT

user tag in the xml , this is possible but you need java coding for this.

if you need answer to querstion : how manu wf-s did user checked ? then use aspect with one propertie witch will be counter .

if you need complex information than this from the book is a way to go .
ps: put log files inside alfresco repo and locate it with lucene.