Aberystwyth University Blogging

Welcome to the Aberystwyth University Blogging Service.
If you wish to start a blog, please send an email to blogging@aber.ac.uk to discuss your requirements and we’ll advise you on how to get started. You can also view information about setting up a blog on the Web Services pages.

Our Active Blogs

Latest posts from across the AU blogging network

  • Gwneud cais i’r Brifysgol

    •   Mae gwneud cais i’r Brifysgol yn brofiad llawn emosiynau gwahanol. Hyd yn oed os wyt ti’n gwybod yn union pa gwrs i’w astudio, mae cymaint o brifysgolion sy’n cynnig opsiynau gwahanol neu’n addysgu mewn dulliau eraill. Gall hyn ei gwneud hi’n anodd iawn i benderfynu ar y cwrs delfrydol. Ond, paid â phoeni! Dyma ychydig ...more

  • LLEFYDD DEFNYDDIOL I WYBOD AMDANYNT

    • Er i mi fod yn fyfyriwr yma am dair blynedd, dwi dal ddim wedi bod ym mhob cilfan yn Aberystwyth ac mae na rhai llefydd bydden i wedi hoffi gwybod amdanynt yn gynt. Un peth wnaeth fy synnu yw faint o lefydd gwych sydd yma i astudio ynddynt, a faint o gyfleusterau diddorol sydd ar ...more

  • Y Gymraeg yn Aber

    • Mae Prifysgol Aberystwyth yn gweithredu’n ddwyieithog ac yn cynnig gwasanaethau i hyrwyddo’r Gymraeg i fyfyrwyr, staff a’r cyhoedd yng Nghymru. Adran o fewn y Brifysgol sy’n hyrwyddo ac yn cynorthwyo bywyd Cymraeg y Brifysgol yw Canolfan Gwasanaethau’r Gymraeg. Mae ei gwaith yn cynnwys cefnogi adrannau academaidd i ddatblygu prosiectau drwy’r Gymraeg, darparu gwasanaeth cyfieithu, cynnig a ...more

  • Cyngor ysgrifennu Datganiad Personol

    • Cyngor ysgrifennu Datganiad Personol   Dyma gyfle i ti werthu dy hun i’r brifysgol! Mae angen i ti brofi dy fod yn ymgeisydd da i astudio yn y brifysgol a phrofi bod gen ti’r sgiliau a’r potensial i lwyddo. Dyma rai awgrymiadau i dy helpu gyda’r cais.   Pam dewis y cwrs? Mae’n bwysig dy fod yn esbonio pam dy ...more

  • Distractions and procrastination.

    • Distractions and procrastination. There are lots of things to be embraced about being a Principal Investigator in Higher Education. You are free to direct your own research, you can be creative when devising your teaching sessions, and you can indulge your curiosity and passions, for example through public-engagement or immersing oneself in the literature. But everyone knows ...more

  • Do We Use Science at Home?

    • Do We Use Science at Home? Before Easter we had a lab meeting, where everyone presents a paper they found interesting. There were some interesting bioinformatics ones, some yeast genomics, the usual high impact or highly relevant papers. I, on the other hand, chose a different type of paper. It was published in the British Food ...more

  • Shibboleth 3 IdP - BeanManagedConnection configuration

    • As the original documentation isn't explicit with where all the settings for a BeanManagedConnection used by a RelationalDatabaseConnector Attribute Resolver, here's my crib sheet. Add a connection pooling library to %{idp.home}/edit-webapp/WEB-INF/lib (or use the provided C3P0 library, dealer's choice). For Apache Commons DBCP, DCBP 1.4 and Commons Pool 1.5.7 pair nicely Define your bean, this appears to ...more

  • When is a folder not a folder?

    • When it is a resource/x-turnitin-assignment. update course_contents set cnthndlr_handle = 'resource/x-bb-folder', main_data = NULL, text_format_type = 'S', offline_name = NULL, offline_path = NULL, start_date = NULL, title = 'Assignments' where pk1 = <offending item ...more

  • Adding Modules to Helix Categories (post rollover)

    • insert into .. select ...EXTERNAL_COURSE_KEY AS course_code,COURSE_NAME as course_title, hlx_c_xr.CategoryId as category_id, hlx_c_xr.CategoryName as category_name from .. JOIN .. on ...EXTERNAL_COURSE_KEY = ...EXTERNAL_COURSE_KEY JOIN OPENDATASOURCE('SQLNCLI' , 'Data Source=SQL3\SYSTEMS;Integrated Security=SSPI').vls.dbo.tbl_Group hlx_g ON hlx_g.GroupName = (CASE WHEN EXTERNAL_CATEGORY_KEY = 'A' THEN '_filmtv' WHEN EXTERNAL_CATEGORY_KEY = 'B' THEN '_education' WHEN EXTERNAL_CATEGORY_KEY = 'C' THEN '_english' WHEN EXTERNAL_CATEGORY_KEY = 'D' ...more

  • Getting child course users who may have been disabled when the parent course id was passed in to SIS

    • SELECT course_id, user_id FROM .. child JOIN .. parent on parent.child_crsmain_pk1 = child.crsmain_pk1 and parent.users_pk1 = child.users_pk1 JOIN .. on child.crsmain_pk1 = ...pk1 JOIN .. on ...pk1 = child.users_pk1 where child.available_ind = 'N' and parent.child_crsmain_pk1 is not ...more

  • Getting active uploaders from Panopto

    • SELECT distinct replace(replace(replace(,'blackboard\',''),'-ac',''),'pau.local\','') as UserName FROM ( SELECT ,DATEADD(ms, ((cast((startTime*10000000) as BIGINT)) / CAST(10000 AS bigint)) % 86400000, DATEADD(day, (cast((startTime*10000000) ...more

  • Renaming a file in Bb

    • Change: files.file_name, files.link_name, XYF_URLS.FULL_PATH and ...more

  • Creating user - course enrollments based on membership on existing courses

    • DECLARE @AY varchar(7); SET @AY = '2013-14'; SELECT DISTINCT USERS.Batch_uid, 'DEPT-I-0001' FROM Users JOIN COURSE_USERS ON COURSE_USERS.users_pk1 = USERS.PK1 JOIN COURSE_MAIN ON COURSE_USERS.crsmain_pk1 = COURSE_MAIN.PK1 WHERE COURSE_MAIN.lower_course_id in ('rd23520_'+@AY,'rg23520_'+@AY,'br23420_'+@AY,'bg23420_'+@AY) AND COURSE_USERS.ROLE = ...more

  • Generating user - course enrollment file by DSK and Course Catalog

    • declare @usr as varchar; declare @dsk as varchar; declare @dpt as varchar; set @usr= 'CHANGEME'; set @dsk= 'CHANGEME'; set @dpt= 'CHANGEME'; SELECT AS EXTERNAL_COURSE_KEY, '' + @usr + '' AS EXTERNAL_PERSON_KEY, 'D' AS ROLE, 'enabled' AS ROW_STATUS, 'Y' AS AVAILABLE_IND FROM .. JOIN .. ON .CRSMAIN_PK1 = COURSE_MAIN.PK1 JOIN .. ON .GATEWAYCAT_PK1 = .PK1 JOIN .. ...more

  • Checking Bb SIS logs against current course IDs

    • SELECT * FROM .. LEFT JOIN .. ON lower(rtrim(ltrim(RIGHT( SUBSTRING(, CHARINDEX('), CHARINDEX(']',, CHARINDEX(')+1)-CHARINDEX(')) , CHARINDEX(' ', reverse( SUBSTRING(, CHARINDEX('), CHARINDEX(']',, CHARINDEX(')+1)-CHARINDEX(')) )) )))) = .lower_course_id where data_intgr_pk1 = 2 and log_message like '%di.error.associate%' and .course_name is not ...more