Hi Ralph,
I've just had a quick look - thus the following information is based on
a "quick poke around" rather than an exhaustive study of the database
structure.
That said, the answer sadly is that links seem to be in different
tables, one for each contennt area (users, courses, orgs, institution
and library).
They all follow a pattern e.g. the permalink:
https://your.bb.server/bbcswebdav/xid-12345_X
The only bits that change are the final numerals (here 12345) and the
last number (marked here with an X).
X first:
It seems that:
1 USERS
2 COURSES
3 ORGANISATIONS
4 INSTITUTION
5 LIBRARY
The numbers 12345 represent the FILE_ID value of the item.
For an item in your personal area (i.e. users)
Look in CMS_FILES_USERS.XYF_URLS
select * from CMS_FILES_USERS.XYF_URLS where FILE_ID=12345
Would bring up this:
FULL_PATH /users/ausername/thefile.doc
FILE_NAME thefile.doc
FILE_ID 12345
And some other useful? stuff!
Ffor COURSES use a table with a name like CMS_FILES_COURSES.XYF_URLS,
etc.
Hope that helps,
Malcolm.
---
Dr Malcolm Murray
Learning Technologies Team Leader
IT Service
Durham University
-----Original Message-----
From: bbadmin-l - listserv [mailto:[log in to unmask]] On Behalf Of Ralph
Holland
Sent: Wednesday, April 02, 2008 2:36 PM
To: [log in to unmask]
Subject: [BBADMIN-L] permlink
Hi all,
Does anybody know where the permlink data is stored inside the
blackboard database, which table and field it is in.
Regards
Ralph
Ralph Holland
VLE Administrator
E-Learning & ICT Department
South Tyneside College
St. George's Avenue
South Shields
NE34 6ET
TELE: 0191 427 3500 EXT. 4007
FAX: 0191 427 3535
SKYPE: ralph.holland
DISCLAIMER:
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent
those of the company. Finally, the recipient should check this email and
any attachments for the presence of viruses. The company accepts no
liability for any damage caused by any virus transmitted by this email.
South Tyneside College,
St Georges Ave,
South Shields,
Tyne & Wear,
www.stc.ac.uk.
VAT No: GB605 5084 59
Directions to BBADMIN-L archives and settings:
http://is.asu.edu/instruction/faq/usingBBADMIN-L.html
|