XML file of course information from admissions system

[lrhm-unikent]

As WebDev We would like an XML file created that contains a course ID (in the PP), POS, MCR and IPO code So that we can populate the programmes plant with this data

[aw285-unikent]

Hi @lrhm-unikent @eg270-unikent or @mb324-unikent

Have you got five minutes today to brief @jjj-unikent @tlm-unikent and I on howthe XML MCR code spreadsheet will function? JJ and Tanith are attending a meeting about this when I'm on leave but I don't know enough to brief them myself. We also want to understand how this will affect how, where and by whom the POS codes are updated - because of the way the POS codes are vital for the modules feed to work.

[gb332-unikent]

@lrhm-unikent Hi Lauren,

I hope this finds you well.

I was just wondering when you guys are planning on doing the development for the prospectus links work? I don't know if you've planned a sprint for that yet but if you have the dates would be handy for me to know.

Guy

[gb332-unikent]

@mb324-unikent @jtisqo @eg270-unikent

Hey guys,

I won't be able to get you that TEST data today as there is some data that I need to set up in the TEST environment before that can happen. I'll endeavour to get that to you by the end of the week. The DEV data (well, 99% of it) should hopefully suffice for development until I can get the TEST data to you.

If you have nay issues in the meantime don't hesitate to shout :-)

Guy

[edelarose]

Hi @gb332-unikent

The main thing we will need to know is how the programmes plant ID will appear in the XML file. Will this be inside the course element? Also if you can let us know the name for the programmes plant ID element we can use this to write the code to pull the XML data into the relevant database entries.

[gb332-unikent]

Hi Edele,

Once I’ve updated the XML document I shall name the XML element ‘programmePlantID’. It will appear as a sub-element of the e.g.

0000000000 113

I hope this helps.

Regards, Guy

Guy Banister | Assistant Analyst Developer | University of Kent Address: A5-2 Darwin, University of Kent, Canterbury, CT2 7NY, UK E-mail: g.banister@kent.ac.ukmailto:g.banister@kent.ac.uk Phone: +44 1227 82 4431

From: eg270-unikent [mailto:notifications@github.com] Sent: 14 July 2014 14:52 To: unikent/programmes-plant Cc: Guy Banister Subject: Re: [programmes-plant] XML file of course information from admissions system (#686)

Hi @gb332-unikenthttps://github.com/gb332-unikent

The main thing we will need to know is how the programmes plant ID will appear in the XML file. Will this be inside the element? Also if you can let us know the name for the programmes plant ID element we can use this to write the code to pull the XML data into the relevant database entries.

— Reply to this email directly or view it on GitHubhttps://github.com/unikent/programmes-plant/issues/686#issuecomment-48901826.

[edelarose]

Hi @gb332-unikent can I just confirm that this is using the instance_id from our database, i.e. what appears in the URL:

2014: - https://www.kent.ac.uk/courses/undergraduate/2014/1/accounting-and-finance-and-economics 2015: - https://www.kent.ac.uk/courses/undergraduate/1/accounting-and-finance-and-economics

where the instance_id of the course is '1' but the database unique ID is different

[gb332-unikent]

Hi Edele,

Yes this utilises the instance_id rather than the database ID.

Due to the fact that instance_ids are not unique across prospectuses (i.e. 113 in UG might = X whereas 113 in PG might = Y) I’ve had to append the strings ‘UG’ and ‘PG’ to the end of the instance_id.

That means that instead of receiving ‘113’ you will receive ‘113PG’ or ‘113UG’ depending on whether it’s in the undergraduate or postgraduate prospectus. This is unfortunately necessary given that I will be storing these instance_ids in ONE entity in SITS and they need unique primary keys.

Is this ok with you guys? Guy Guy Banister | Assistant Analyst Developer | University of Kent Address: A5-2 Darwin, University of Kent, Canterbury, CT2 7NY, UK E-mail: g.banister@kent.ac.ukmailto:g.banister@kent.ac.uk Phone: +44 1227 82 4431

From: eg270-unikent [mailto:notifications@github.com] Sent: 14 July 2014 15:40 To: unikent/programmes-plant Cc: Guy Banister Subject: Re: [programmes-plant] XML file of course information from admissions system (#686)

Hi @gb332-unikenthttps://github.com/gb332-unikent can I just confirm that this is using the instance_id from our database, i.e. what appears in the URL:

2014: - https://www.kent.ac.uk/courses/undergraduate/2014/1/accounting-and-finance-and-economics 2015: - https://www.kent.ac.uk/courses/undergraduate/1/accounting-and-finance-and-economics

where the instance_id of the course is '1' but the database unique ID is different

[capture]https://cloud.githubusercontent.com/assets/6604537/3572120/a544206e-0b64-11e4-926f-9bc0cad57e64.PNG

— Reply to this email directly or view it on GitHubhttps://github.com/unikent/programmes-plant/issues/686#issuecomment-48907854.

[edelarose]

Hi @gb332-unikent,

Do you store the programmePlantID in your database with the appended 'UG' and 'PG'? If this is how it comes from the db then no worries, but if not would it be possible to add another XML sub-element so that we receive the file as:

<course>
                <mcr>0000000000</mcr>
                <programmePlantID>113</programmePlantID>
                <degreeLevel>UG</degreeLevel>
</course>

[gb332-unikent]

Hi Edele,

Yeah we do, the primary key will be ‘87PG’, unfortunately I can’t store it in any other way in the database.

Guy

Guy Banister | Assistant Analyst Developer | University of Kent Address: A5-2 Darwin, University of Kent, Canterbury, CT2 7NY, UK E-mail: g.banister@kent.ac.ukmailto:g.banister@kent.ac.uk Phone: +44 1227 82 4431

From: eg270-unikent [mailto:notifications@github.com] Sent: 14 July 2014 16:02 To: unikent/programmes-plant Cc: Guy Banister Subject: Re: [programmes-plant] XML file of course information from admissions system (#686)

Hi @gb332-unikenthttps://github.com/gb332-unikent,

Do you store the programmePlantID in your database with the appended 'UG' and 'PG'? If this is how it comes from the db then no worries, but if not would it be possible to add another XML sub-element so that we receive the file as:

0000000000 113 UG

— Reply to this email directly or view it on GitHubhttps://github.com/unikent/programmes-plant/issues/686#issuecomment-48910929.