Uploaded image for project: 'Kuali Rice Development'
  1. Kuali Rice Development
  2. KULRICE-4623

Research the best strategy for keeping postal-related data up to date

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Analysis
    • Labels:
    • Rice Module:
      Rice Core
    • KAI Review Status:
      Not Required
    • KTI Review Status:
      Not Required

      Description

      Right now we have some information in our database for:

      • states
      • countries
      • counties
      • postal codes

      We need to ensure we have implemented a good strategy for either:

      1) Keeping our database tables up to date
      2) Integrating with external systems or web-services of some kind in order to keep this data up to date
      3) Creating a way for people to "load" this data from flat files or some other format that they can use to keep this information up to date

      We also need to document and/or figure out where each of these is used internally and externally to Rice.

        Attachments

          Activity

          Hide
          jamesrenfro James Renfro (Inactive) added a comment -

          On (2) you might want to look at http://www.geonames.org to see if there's an easy way to configure a hook so the rice database would basically act as a cache for the web services data if an institution wanted.

          Alternatively it might be a source for downloading/batch loading data since there is a limit on how many calls an application can make to the web service.

          "30000 credits limit per application (identified by the parameter 'username'), the hourly limit is 2000 credits. A credit is a web service request hit for most services. An exception is thrown when the limit is exceeded. (New limits as of 5. August 2010)"

          You can pay for more.

          Show
          jamesrenfro James Renfro (Inactive) added a comment - On (2) you might want to look at http://www.geonames.org to see if there's an easy way to configure a hook so the rice database would basically act as a cache for the web services data if an institution wanted. Alternatively it might be a source for downloading/batch loading data since there is a limit on how many calls an application can make to the web service. "30000 credits limit per application (identified by the parameter 'username'), the hourly limit is 2000 credits. A credit is a web service request hit for most services. An exception is thrown when the limit is exceeded. (New limits as of 5. August 2010)" You can pay for more.

            People

            • Assignee:
              Unassigned
              Reporter:
              ewestfal Eric Westfall
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: