CDR Tickets

Issue Number 3848
Summary Create Web Interface for Quarterly ZIP Code Updates
Created 2014-12-31 11:16:25
Issue Type New Feature
Submitted By Englisch, Volker (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2016-03-09 18:13:31
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.144260
Description

Currently, updating the ZIP codes that are published each quarter requires us to coordinate with both, the CBIIT DBA team and the CBIIT Webteam. It would be nice if the update could be modified and "triggered" by a CDR developer without the involvement of either of these teams.

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

Python, SQL

What are the ZIP codes used for? Do we still need this?

Estimate: 3

Comment entered 2016-03-09 18:13:19 by Englisch, Volker (NIH/NCI) [C]

The following files have been updated:

  • R13750: LoadZipCodes.py

  • R13751: upload-zip-code-file.py

  • R13752: DevSA.py

In DevSA.py I've added a menu item to access the ZIP code upload script.
LoadZipCodes.py has been modified to limit the number of print statements displayed on the screen. Previously, every loaded record had been reported. I'm now reporting every 2,500 rows plus the final count.
upload-zip-code-file.py does the copying of data and submitting the load command. The zip file provided by ZIPInfo.com is uploaded to the directory \cdr\uploads, the ZIP data file is extracted to the \tmp directory and loaded.

This is ready for testing on DEV.

Comment entered 2016-03-29 10:18:11 by Juthe, Robin (NIH/NCI) [E]

Volker, just wanted to confirm - is this something CIAT should be testing or will you be testing the interface? Thanks.

Comment entered 2016-03-29 11:09:35 by Englisch, Volker (NIH/NCI) [C]

This is something that CIAT could perform but I am receiving the email with the login information and file location; I will have to download the file; and I will have to store it on the network. If everything works as expected it's just clicking one more button and loading the file.
It probably makes most sense if I keep performing this task, therefore I will also test it or have Aarti test it with me.

Comment entered 2016-04-29 13:20:57 by Englisch, Volker (NIH/NCI) [C]

The process works perfectly with one caveat - we should have added what file to be loaded (the *.zip file instead of the z5max.txt file) or added the URL to the CDR documentation.

We'll leave this as an enhancement to Einstein.

Comment entered 2016-04-29 16:11:36 by Englisch, Volker (NIH/NCI) [C]

I forgot to mention we'll have to create an action called UPLOAD ZIP CODES and assign the users to the group = ZIP Code Maintainers to allow the upload on the higher tiers for specific users.

Comment entered 2016-05-13 12:37:33 by Englisch, Volker (NIH/NCI) [C]

, if you could check the ZIP codes on STAGE I can upload the new ZIP codes to PROD using our new web interface.

Comment entered 2016-05-13 12:38:23 by Englisch, Volker (NIH/NCI) [C]

Linking upload Q2 data ticket.

Comment entered 2016-05-13 13:21:20 by Osei-Poku, William (NIH/NCI) [C]

Sure. They are on Stage now ?

William Osei-Poku, if you could check the ZIP codes on STAGE I can upload the new ZIP codes to PROD using our new web interface.

Comment entered 2016-05-13 16:30:57 by Englisch, Volker (NIH/NCI) [C]

The latest ZIP code data has been loaded to PROD using our new web interface.

Closing ticket.

Elapsed: 0:00:00.001702