The wiki is now available again. However, some recent changes may not have been restored.
Please see Computing Services' blog post for more details
Skip to end of metadata
Go to start of metadata

Icon

Each time we are provided with an Excel spreadsheet from Dept. Policy & Planning we effectively repeat the process on this page. It is important to note the information that Digital gathers in the sections below.

The Excel spreadsheet is only imported into Google Docs as an easy source for team members to get hold of it and work on.

Icon

Use this Ruby script to help generate the rewrites https://github.bath.ac.uk/digital/kis

 

Attachments

  File Modified
Text File kis-widget-rewrites.txt Sep 20, 2012 by mnskchg
Text File kis-progspecs-rewrites.txt Sep 21, 2012 by mnskchg

Generating the kis-widget-rewrites.txt file

We will be submitting to HESA information as below (see Google Spredsheet for 2012-2013):

KIS course ID

Department Code

Faculty Code

Course Title

URL for course page

UUHX3-B940&UDAS-KFF01

AS

D

Foundation Degree in Addictions Counselling

http://www.bath.ac.uk/study/kis/2012-2013/programme/UDAS-KFF01

UUUA1-RL12&UHPL-AYB13

PL

H

BA (hons) French and Politics

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB13

UUUA1-RL22&UHPL-AYB12

PL

H

BA (hons) German and Politics

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB12

UUUA1-RL32&UHPL-AYB16

PL

H

BA (hons) Italian and Politics

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB16

UUUA1-RL42&UHPL-AYB17

PL

H

BA (hons) Spanish and Politics

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB17

UUUA1-RL72&UHPL-AYB11

PL

H

BA (hons) Russian and Politics

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB11

UUUA1-RR12&UHPL-AYB05

PL

H

BA (hons) Modern Languages and European Studies (French and German)

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB05

UUUA1-RR13&UHPL-AYB04

PL

H

BA (hons) Modern Languages and European Studies (French and Italian)

http://www.bath.ac.uk/study/kis/2012-2013/programme/UHPL-AYB04

With a copy of the sheet that Dept. Policy & Planning provide, e.g. the Google Spredsheet for 2012-2013:

  1. Split the KIS Course ID column as it's of the form <ADMISSIONS-CODE>&<COURSE-CODE>
  2. Split from <ADMISSIONS-CODE> the characters after the last hyphen - to get the <UCAS-CODE>
    1. You could achieve this by column selecting and deleting in SublimeText2 or doing  a regex find and replace and then pasting back into new columns.
  3. We have for each entry found the equivalent UG Prospectus URL - see https://docs.google.com/spreadsheet/ccc?key=0AhL321UzuwKBdHhvYUZabzVkSjdzek9nUHR1alI0QWc&pli=1#gid=1
    1. Icon

      The prospectus URLs are manually gathered by Web Services! Each time I have received a new spreadsheet from DoPP I've matched up the entries again by sorting (by ADMISSIONS CODE) and then copying and pasting. However if the list for submission changes for next year we'd have to go through every entry.

  4. Create a new sheet and for each column:
    1. Concatenate academic year with hyphen then COURSE-CODE, e.g. <20xx-20xx-COURSE-CODE>
    2. Concatenate URL to UG Prospectus with UCAS code (from ADMISSIONS CODE) as URL param, e.g. http://www.bath.ac.uk/study/ug/subject/SUBJECT-NAME?kis=UCAS-CODE
  5. Saving the sheet out as a .txt (tab separated values) produces a file with entries like:

    2012-2013-UHPL-AYB13	http://www.bath.ac.uk/study/ug/prospectus/subject/language-politics?kis=RL12
    2012-2013-UHPL-AYB12	http://www.bath.ac.uk/study/ug/prospectus/subject/language-politics?kis=RL22
    2012-2013-UHPL-AYB16	http://www.bath.ac.uk/study/ug/prospectus/subject/language-politics?kis=RL32
    2012-2013-UHPL-AYB17	http://www.bath.ac.uk/study/ug/prospectus/subject/language-politics?kis=RL42
    2012-2013-UHPL-AYB11	http://www.bath.ac.uk/study/ug/prospectus/subject/language-politics?kis=RL72
    2012-2013-UHPL-AYB05	http://www.bath.ac.uk/study/ug/prospectus/subject/modern-languages-european-studies?kis=RR12
    2012-2013-UHPL-AYB04	http://www.bath.ac.uk/study/ug/prospectus/subject/modern-languages-european-studies?kis=RR13
    2012-2013-UHPL-AYB18	http://www.bath.ac.uk/study/ug/prospectus/subject/modern-languages-european-studies?kis=RR14
    2012-2013-UHPL-AYB08	http://www.bath.ac.uk/study/ug/prospectus/subject/modern-languages-european-studies?kis=RR1H
    2012-2013-UHPL-AYB09	http://www.bath.ac.uk/study/ug/prospectus/subject/modern-languages-european-studies?kis=RR1V
    

    Top of sheet should have comment:

    # KIS Rewrites for Widget - see https://wiki.bath.ac.uk/x/OADiAw
    

    Sections for each year should be separated with comments:

    ## START 20xx-20xx
    ...
    ## END 20xx-20xx
    
  6. For each year the output needs to be appended to the existing rewrite map.

    Icon

    Don't replace the old rewrite map URLs!

  7. If a destination link goes off-site and doesn't have any URL parameters, remember to add ?0=0 to the end, since the rewrite will add more parameters to the end, starting with a '&' symbol

See kis-widget-rewrites.txt as an example.

Entries for removed courses

The rewrite map file has the following entries:

## These courses are no longer running but these redirects are required otherwise user sees a "Bad request" error
2012-2013-UHES-AFB02    http://www.bath.ac.uk/study/kis/404?kis=removed
2012-2013-UHES-AKB02    http://www.bath.ac.uk/study/kis/404?kis=removed

This is so that users see a proper 404 instead of the one that the UG Prospectus throws up.

Generating the kis-progspecs-rewrites.txt file

In Google Spredsheetfor 2012-2013 I've added another sheet called "kis-progspec-rewrites" which has in the second column (the first is hidden) the following formula (copied down to the rest of the rows):

=CONCATENATE("2012-2013-", <SHEET FROM Dept Pol & Planning>!<COLUMN WITH ADMISSIONS CODE>)

and the next column will be the URL for the prog spec.

Icon

URLs for prog specs are manually gathered by Web Services and Faculties/Departments. See List of Prog Specs below as the sources for each year we generate the maps.

Saving this sheet out as a .txt file would produce a file with entries like:

2012-2013-UUUD1-L100	http://www.bath.ac.uk/hss/pdf/undergraduate/bsc-economics.pdf
2012-2013-UUUD1-L101	http://www.bath.ac.uk/hss/pdf/undergraduate/bsc-economics.pdf
2012-2013-UUUD1-LL19	http://www.bath.ac.uk/hss/pdf/undergraduate/bsc-economics-and-international-development.pdf
2012-2013-UUUD1-LLC9	http://www.bath.ac.uk/hss/pdf/undergraduate/bsc-economics-and-international-development.pdf

Top of sheet should have comment:

### Map of redirects for Programme Specs as used by RewriteMap in Apache - see https://wiki.bath.ac.uk/x/OADiAw

Sections for each year should be separated with comments:

## START 20xx-20xx
...
## END 20xx-20xx

For each year the output needs to be appended to the existing rewrite map.

Icon

Don't replace the old rewrite map URLs!

Lists of Prog Specs for each faculty

  • No labels