OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Annual Report

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Annual Report

Postby kennymatthew » Wed May 22, 2013 1:11 am

Hi,

Can OJS print yearly article reports ? IS there any material explaining the report process? Our journal year starts from sept 1st to aug 31st. Is it possible to make a report on these dates?
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: Annual Report

Postby JasonNugent » Wed May 22, 2013 6:28 am

Kenny,

What did you want to report on? OJS ships with a number of reporting plugins that can be enabled through the Journal Manager interface.

Regards,
Jason
JasonNugent
Site Admin
 
Posts: 849
Joined: Tue Jan 10, 2006 6:20 am

Re: Annual Report

Postby kennymatthew » Thu May 23, 2013 2:51 am

Hi Jason,

Main thing is we need from sept till aug not jan to dec
for Articles --> total number, accepted,declined,published,in review,country,revised
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: Annual Report

Postby JasonNugent » Thu May 23, 2013 3:50 am

Hi Kenny,

Have a look at the article reports plugin. It generates a list of reports that includes author information, section info, languages, editor decision, and ultimate status. The report outputs CSV, which you could bring into a spreadsheet application to do further analysis.

Regards,
Jason
JasonNugent
Site Admin
 
Posts: 849
Joined: Tue Jan 10, 2006 6:20 am

Re: Annual Report

Postby kennymatthew » Sat May 25, 2013 10:01 pm

Hi Jason,

I was using those same reports and noticed that there is not tab for submitted date. Is there anyway I Can add the date to the report?
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: Annual Report

Postby JasonNugent » Sun May 26, 2013 11:24 am

Kenny,

It would be easy enough to add. You'd need to add the date_submitted column to the first SQL query in the getArticleReport() method in ArticleReportDAO, and then modify the display() method in the ArticleReportPlugin class to include it in the CSV. That'd mean putting an entry in the $columns array about half-way through the method, and then possibly adding an elseif() statement to the while loop at the end of the method that iterates over $articlesIterator if you want to display it differently or format it better than a regular MySQL data column.

Regards,
Jason
JasonNugent
Site Admin
 
Posts: 849
Joined: Tue Jan 10, 2006 6:20 am

Re: Annual Report

Postby kennymatthew » Sun May 26, 2013 11:51 pm

Hi Jason,

I shall try it out. Thanks alot man been a big help.
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: Annual Report

Postby kennymatthew » Thu Jul 25, 2013 3:10 am

Hi Jason,

1 more doubt, the CSV files the first row consists of the header of the column. When i am trying to add this CSV file to make another database for reporting purposes, it is added as another table entry and the column names are just col1,col2 ...etc . is there anyway I can to remove the first line and add it as column name of the database ?


Kenny
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: Annual Report

Postby kennymatthew » Tue Jul 30, 2013 11:39 pm

Finally added the submission date to the articles CSV ....

in locale.xml
Code: Select all
<!-- Common Article Terms -->
    <message key="article.date">Submission Date</message>
   


plugins / reports / articles / ArticleReportPlugin.inc.php --->line 84
Code: Select all
   $columns = array(
            'date_sub' => __('article.date'),  // added this line to inculde date field in CSV file awesome ....
         'article_id' => __('article.submissionId'),
         'title' => __('article.title'),
         'abstract' => __('article.abstract')
      );


plugins / reports / articles / ArticleReportDAO.inc.php ----line 27

Code: Select all
   function getArticleReport($journalId) {
      $primaryLocale = AppLocale::getPrimaryLocale();
      $locale = AppLocale::getLocale();
      $result =& $this->retrieve(
         'SELECT   a.article_id AS article_id,
                 a.date_submitted AS date_sub,      // added this line to inculde date field in CSV file -->a.date_submitted AS date_sub,....
            COALESCE(asl1.setting_value, aspl1.setting_value) AS title,
            COALESCE(asl2.setting_value, aspl2.setting_value) AS abstract,
            COALESCE(sl.setting_value, spl.setting_value) AS section_title,
            a.status AS status,
            a.language AS language
         FROM   articles a



got the first column of the CSV file to be submission date. Is there a way I can format the date to day/month/year and with out the time ?
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm

Re: Annual Report

Postby kennymatthew » Wed Jul 31, 2013 12:05 am

Same way if you want to put country of reviewer in the reviewers CSV file


pkp / locale / en_US / user.xml

Code: Select all
    <message key="user.country">Country</message>



plugins / reports / reviews / ReviewReportDAO.inc.php -->line 45

Code: Select all
   $result =& $this->retrieve(
         'SELECT
                u.country AS country_reviewer,      // add this line
                r.round AS round,
            COALESCE(asl.setting_value, aspl.setting_value) AS article,
      


plugins / reports / reviews / ReviewReportPlugin.inc.php ---> line 79


Code: Select all
$columns = array(
           'country_reviewer' => __('user.country'),     // Add this line
         'round' => __('plugins.reports.reviews.round'),
         'article' => __('article.articles'),
      
kennymatthew
 
Posts: 127
Joined: Wed Jan 09, 2013 11:49 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 2 guests

cron