Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-37176

Update timezones info to latest version available (2012j)

    XMLWordPrintable

Details

    • Task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.2.6, 2.3.3, 2.4, 2.5
    • 2.2.7, 2.3.4, 2.4.1
    • Libraries
    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE, MOODLE_25_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Easy
    • Hide
      • remove this file in your site if present: dataroot/temp/olson.txt
      • remove this file in your site if present: dataroot/temp/timezone.txt
      • disable network access, so http://download.moodle.org/timezone/ cannot be accesed
      • go to Admin -> Location -> Update timezones
      • press the continue button, so the local lib/timezone.txt will be loaded
      • TEST: With debugging enabled, you should get one message like "cURL request for "http://download.moodle.org/timezone/" failed". Perfect, that means you disabled network access ok.
      • TEST: ignoring the previous warning, the load ends without any PHP notice/warning/error.
      • TEST: The page shows this info: "2268 entries imported from YOUR_MOODLE_BASEDIR/lib/timezone.txt". 2268 is the important bit. And also that the load has happened from that directory.
      • TEST: Run the simple/phpunit tests, paying attention to any testmoodlelib.php result. Process should end with "xxx passes, 0 fails and 0 exceptions." (or, alternatively, if there are some tests failing, none of them are related to testmoodlelib.php and date/time functions).
      • POST-TEST (optional, must work if all the prev tests have worked): after rolling upstream, with network access enabled, load the timezones again, it should show the same number of timezones (2268) but loaded from http://download.moodle.org/timezone/
      Show
      remove this file in your site if present: dataroot/temp/olson.txt remove this file in your site if present: dataroot/temp/timezone.txt disable network access, so http://download.moodle.org/timezone/ cannot be accesed go to Admin -> Location -> Update timezones press the continue button, so the local lib/timezone.txt will be loaded TEST: With debugging enabled, you should get one message like "cURL request for "http://download.moodle.org/timezone/" failed". Perfect, that means you disabled network access ok. TEST: ignoring the previous warning, the load ends without any PHP notice/warning/error. TEST: The page shows this info: "2268 entries imported from YOUR_MOODLE_BASEDIR/lib/timezone.txt". 2268 is the important bit. And also that the load has happened from that directory. TEST: Run the simple/phpunit tests, paying attention to any testmoodlelib.php result. Process should end with "xxx passes, 0 fails and 0 exceptions." (or, alternatively, if there are some tests failing, none of them are related to testmoodlelib.php and date/time functions). POST-TEST (optional, must work if all the prev tests have worked): after rolling upstream, with network access enabled, load the timezones again, it should show the same number of timezones (2268) but loaded from http://download.moodle.org/timezone/

    Description

      Last update was done 10-11 months ago (to tzdata2011n database, see MDL-31329). Going to update to tzdata2012.tar.gz

      Source: http://www.iana.org/time-zones

      Instructions:

      The olson.txt to be imported is the concatenation, in one unique file of this olson files (in this exact order):

      africa, antarctica, asia, australasia, europe, northamerica and southamerica

      1) Put the olson.txt file into dataroot/temp/olson.txt
      2) Go to Admin -> Location -> Update timezones and confirm
      3) Data will be loaded, replacing existing one
      4) Generate CSV file from phpMyAdmin (commas as field separators, non-quoted values, unix line feeds and first line as field names)
      5) Put it into /lib/timezone.txt
      6) Commit

      Note1: Current timezone.txt format is compatible only with Moodle 1.8 and upwards.
      Note2: We'll be spreading this change to all currently supported versions (22, 23, 24 and master).

      Ciao

      Attachments

        Issue Links

          has a clone

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-38668 Update timezones info to latest version available (2013b)

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is a clone of

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-31329 Update timezones info to latest version available (2011n)

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              stronk7 Eloy Lafuente (stronk7)
              Sam Hemelryk Sam Hemelryk
              Adrian Greeve Adrian Greeve
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                14/Jan/13