Hi,
Do you ever come across to be able to download blog/journal entries made by students? It could be possible if the functionality is available in your institution, but not mine.
Thanks,
Farah
Hi,
Do you ever come across to be able to download blog/journal entries made by students? It could be possible if the functionality is available in your institution, but not mine.
Thanks,
Farah
For Journals you can try this custom course report from OSCELOT.
http://projects.oscelot.org/gf/project/birt/frs/?action=FrsReleaseBrowse&frs_package_id=374
I built this for an example report for a BB Dev day a few years ago and so is not as polished as a production release would be. Feel free to modify it in anyway you like.
Regards
Andrew Hulme
Here's the (ORACLE) SQL that I made to grab the entries for a specific Blog.
SELECT u.user_id as "Username", be.CREATION_DATE AS "Blog Posted", be.UPDATE_DATE as "Blog Updated", be.TITLE AS "Entry Title", be.DESCRIPTION AS "Blog Entry"
FROM BLOG_ENTRY be
INNER JOIN course_users cu ON be.CREATOR_USER_ID = cu.pk1
INNER JOIN BBLEARN.users u ON cu.users_pk1 = u.pk1
WHERE be.BLOG_PK1 = '138729'
ORDER by u.user_id
I know this is from a long time ago, but we've just been asked to extract parts of a journal....and I can access our oracle database but aren't knowledgeable and aren't sure how to find out the BLOG_PK1. Can you help at all? Otherwise I can create a ticket and ask Bb. Thanks in advance.
Hi Sarah
We also now received such a request from a lecturer
the PK1 you get from the URL on the page the blog/journal is visible
<server URL>webapps/blogs-journals/execute/viewBlog?course_id=_118437_1&blog_id=_167557_1&type=journal&index_id=week
The PK1 here is "167557"
Hope the code also works for Postgress (we are moving to SaaS in a weeks time)
Johan
We are often asked about this. It was a feature with the Campus Pack blogs, but not with Blackboard blogs and journals.
The best we can suggest is to copy and paste into word