CDR Tickets

Issue Number 4024
Summary Import ftp_licensee File to DB Table
Created 2016-02-09 14:25:56
Issue Type Sub-task
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2016-04-18 07:26:46
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.178579
Description

The content of the file "ftp_licensee.db" that's currently used for the notifications needs to be imported into the new DB table.

Comment entered 2016-02-12 17:27:49 by Englisch, Volker (NIH/NCI) [C]

I've written the program

  • R13721: ImportFtpVendors.py

This program takes the licensee file ftp_vendors.db and imports all of its data into the CDR database table pdq_contacts.

Comment entered 2016-04-15 21:38:05 by Kline, Bob (NIH/NCI) [C]

Is it important that the id values be preserved?

Comment entered 2016-04-18 07:26:46 by Kline, Bob (NIH/NCI) [C]

Rewritten to normalize the data and provide a CGI interface.

R13915 /branches/Darwin/Inetpub/wwwroot/cgi-bin/cdr/load-pdq-data-partners.py
R13014 /branches/Darwin/Database/ftp_vendors.db

Supporting scripts for development/testing:
R13913 /branches/Darwin/Database/create-legacy-vendor-contact-records.py
R13911 /branches/Darwin/Database/find-ftp-vendor-product-outliers.py
R13910 /branches/Darwin/Database/backup-partner-tables.py

Manual deployment task:

Comment entered 2016-04-18 11:21:00 by Englisch, Volker (NIH/NCI) [C]

Is it important that the id values be preserved?

If you are referring to one of the three fields username, password, VendorID the answer is 'No'. This information used to be the password we created and the UID of the account we created. Those columns are now useless but I still would like to keep the username.

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

Those columns are now useless

I have to modify my last comment: The username is not useless at all. In fact, I've modified the PDQAccessReport report which scans the FTP logfile to use the partner information stored in the CDR. We actually need the user account for the report to function properly.

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

I added a record to my data file for a product TEST but nothing was imported. The product itself, however, did exist after the import.

Comment entered 2016-04-21 08:52:22 by Kline, Bob (NIH/NCI) [C]

I'll need to see you import file. The one in version control contains some TEST lines, and I believe they imported correctly.

Elapsed: 0:00:00.001313