File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes Weekly Summary Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Weekly Summary" Watch "Weekly Summary" New topic
Author

Weekly Summary

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Take a look at the net.jform.summary package. I think this has a Quartz scheduler job that can be added to your quartz-jforum.properties file to do this.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi all,

I have this query about email triggers in JForum 2.1.6:

Every week, I want to send a consolidated email containing forum topics created in a particular category during that week to one of the groups (something like a summary). Is this possible by configuration or do I need to code it myself.

Actually, i have a text file called summaryMessage in my mail templates folder. This created the doubt if some kind of configuration already exists.

Please guide me how to do achieve this.

Thanks,
Vidi
[originally posted on jforum.net by mailvidi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi Monroe,

Thanks for your response, will check that pkg.

One more query: I saw SystemGlobals properties file & found a property called weekly summary. I set its "enabled" attribute to true & today (monday), there was an email sent to all the users who have logged into the system!!

Now im wondering if some customizations can be done to this email through configurations ... rather than changing the code. I need to send posts of certain category to certain members or groups.

Thanks,
Vidi
[originally posted on jforum.net by mailvidi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Looking at that code is seem like you have two choices:

First, without modifying the code, it looks like you could just modify the SummaryDAO.selectAllRecipients SQL Query in your <database>.sql file.

The alternative is to modify the SummaryModel.listRecipients() method to return the list you want.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanx for your response monroe. Will try that & let you know .

Regards,
Vidi
[originally posted on jforum.net by mailvidi]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi all,

I enabled the weekly summary option in JForum 2.1.8, during the first month, I manged to received email with all the summary of the week. Since 3 weeks back, the email that I received are empty. It just says:

"Hi, this is Forum Summary of the week."

There is no topics or forums summary. Any idea what's went wrong?
[originally posted on jforum.net by eddieyan]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Not sure what's going on so let's break it down into the areas that might be causing problems.

First, I assume you have checked your logs for any exceptions relating to the net.forum.summary or net.jforum.util.mail packages...

You get the e-mail.. therefore the scheduler code is running and the system can find the recipients list. So this section seems to be working. (SummaryJob, SummaryScheduler)

The e-mail has the initial heading but nothing else. The summaryMessage.txt template shows that the body of message after this comes from the list of posts.

This is generated (in SummaryModel) based on the summary.days.before value (default is 7) in the config file. E.g., the posts selected are the value's BETWEEN today and today - summary.days.before days. Is this value set right?

The post listing are actually retrieved via the SummaryDAO using a query similar to the one below. Check your DB specific *.sql file in the config directory for the exact query. If it doesn't exist, it's this one.



Which is a prepared statement that has both ?s replaced with a Timestamp value for today and the last day.

Has you jdbc driver changed recently? Some DB's are modifying the way they interpret dates (to become more standard).

Does this query work if you construct a manual version of it?

Have you tried restarting the jforum application? It's unlikely, but maybe the cached version of the config values has gotten corrupt. So the value for the days before is 0 (or 1 which false with the between).
[originally posted on jforum.net by monroe]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Weekly Summary