CDR Tickets

Issue Number 3852
Summary Fix and Improve FTP Licensee Report
Created 2015-01-05 18:18:33
Issue Type Bug
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2016-04-20 18:37:57
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.144333
Description

There are several problems with the program creating the monthly FTP licensee access report that need to be addressed.
Typically, this report is run as a cronjob on the DEV FTP APP server on the first of each month extracting the licensee data from the monthly log file. However, this report did not run for two months.

  • Need to find out why the report did not run (most likely due to cronjob entry commented out

  • We need to be able and run this report on a file that's not the previous month's log file. Add an option to pass the file name to inspect.

  • The log file is read from the directory /usr/local/cdr/ftplog but it should be read on /local/pdq_log

  • The latest log file on /local/pdq_log needs to be copied to /usr/local/cdr/ftplog

Comment entered 2016-02-18 11:42:48 by Learn, Blair (NIH/NCI) [C]

First bullet already resolved.
Estimate: 5 points

Comment entered 2016-04-19 15:42:39 by Englisch, Volker (NIH/NCI) [C]

I created a new file that allows us to retrieve the organization name and FTP user-ID from the CDR:

  • get-pdq-partners.py

Comment entered 2016-04-20 17:27:07 by Englisch, Volker (NIH/NCI) [C]

  • ✔ Need to find out why the report did not run (most likely due to cronjob entry commented out
    The cronjob is working properly since this ticket got created.

  • ✔ We need to be able and run this report on a file that's not the previous month's log file. Add an option to pass the file name to inspect.
    The program has been modified to allow running the report for any of the log files available:

     ~cdroperator/prod/bin/PDQAccessReport.py --livemode --month=201601

  • ✔ The log file is read from the directory /usr/local/cdr/ftplog but it should be read on /local/pdq_log
    The logfile location has been modified.

  • ✔ The latest log file on /local/pdq_log needs to be copied to /usr/local/cdr/ftplog
    This is performed with a cronjob under the cdroperator account.

Comment entered 2016-04-20 18:35:38 by Englisch, Volker (NIH/NCI) [C]

The following files have been versioned in SVN:

  • R13940: get-pdq-partners.py (in cgi directory on Windows)

  • R13932: PDQAccessReport.py (in ~cdroperator/prod/bin directory on Linux)

Elapsed: 0:00:00.001652