[Using Sakai] Assignment attachments
John Leasia
jleasia at umich.edu
Tue Oct 20 05:29:37 PDT 2009
Nope, sorry spoke to soon. That ref on the event isn't the attachment
URL, its composed of assignment ids. However there should be a
content.new event for the upload of the assignment attachment and that
event will have a reference to the attachment's URL.
John
John Leasia wrote:
> The event (asn.submit.submission) has a ref that references the
> attachment if you can query the db. Have you found one yet - wondering
> what the URL is?
>
> select ss.session_server, ss.session_user, se.event_date, se.event,
> se.ref
> from sakai_session ss, sakai_event se
> where ss.session_id = se.session_id
> and se.event = 'asn.submit.submission'
>
> John
>
> Sean Keesler wrote:
>
>>Understood, and each of those URL's work fine. So they are in
>>Resources/attachments SOMEWHERE.
>>I just am saying that its hard to track down where somewhere is in
>>admin workspace resources, if the folder doesn't seem to exist (not
>>the name of the site).
>>
>>Sean Keesler
>>130 Academy Street
>>Manlius, New York 13104 USA
>>315-663-7756
>>sean.keesler at threecanoes.com
>>
>>
>>
>>On Tue, Oct 20, 2009 at 7:20 AM, John Leasia <jleasia at umich.edu> wrote:
>>
>>
>>>I don't think it is site name in an attachment's URL, I think it is site_id.
>>>The site_id doesn't change on a rename of the site. For example,
>>>
>>>/attachment/SITE_ID/Assignments/ASSIGNMENT_ID/FILE_NAME
>>>
>>>John
>>>
>>>
>>>
>>>Sean Keesler wrote:
>>>
>>>I don't know if the site has been renamed. I haven't maintained the
>>>site and there isn't a history of previous site names for me to look
>>>through.
>>>
>>>It sounds as if you are saying that if the site was created and some
>>>assignments turned in and THEN the site was renamed, that the
>>>resources attachments folder would have the original site name...and
>>>its pretty tough to figure out what that folder name used to be
>>>(unless you actually made the change yourself).
>>>
>>>It seems to me that if the purpose of the naming the resource
>>>attachment folder with the name of the site is to make it easy to find
>>>files, renaming the site would need to rename the resource attachment
>>>folder too...
>>>
>>>
>>>Sean Keesler
>>>130 Academy Street
>>>Manlius, New York 13104 USA
>>>315-663-7756
>>>sean.keesler at threecanoes.com
>>>
>>>
>>>
>>>On Mon, Oct 19, 2009 at 11:39 PM, Zhen Qian <zqian at umich.edu> wrote:
>>>
>>>
>>>Sean:
>>>
>>>My comments below:
>>>
>>>On Mon, 19 Oct 2009 21:21:55 -0400, Sean Keesler
>>><sean.keesler at threecanoes.com> wrote:
>>>
>>>
>>>I have a question about the workings of Resources and assignments.
>>>
>>>I know of an implementation that for some reason seems to have a lot
>>>of "lost" assignment submissions. Reportedly, the students are getting
>>>their receipts, but faculty are often not able to find the files. The
>>>IT group has taken a shine to going into Admin Workspace and using the
>>>Resources tool to drill down through the "attachments > {Class Name} >
>>>Assignments > {Name of file} > {Name of file}" to seek out these
>>>"missing assignments'.
>>>
>>>Ignoring the fact that this shouldn't be necessary at all....
>>>
>>>
>>>Assignments tool, along with many other tools (e.g. Announcement,
>>>Syllabus), uses FilePicker and hence the addAttachmentResource() function
>>>of ContentHostingService for uploading attachment resources.
>>>
>>>You can check BaseContentService for the implementation of the above
>>>function. Basically the routine will create the attachment folder and
>>>insert attachment at proper place. Every attachment added will get a unique
>>>parent folder, with the url structure similar to the following:
>>>
>>>/attachment/9e8b3ef2-0e5c-4aa0-9289-dd18079b3b56/Syllabus/e94d2485-4089-4eb3-b3a3-71568b0c614c/
>>>
>>>In order to make attachment file lookup more easier, human-readable folder
>>>names have been assigned to the folders, so the above folder path will look
>>>like:
>>>
>>>/attachment/SITE_NAME/Syllabus/ATTACHMENT_FILE_NAME/ATTACHMENT_FILE_NAME
>>>
>>>This is just an interpretation of the attachment path. However, I don't
>>>know why the last containing folder's display name should be as same as the
>>>actual file name. Or whether this extra folder is necessary at all as you
>>>suggested above.
>>>
>>>
>>>
>>>There is one class that doesn't seem to have a folder in the
>>>"attachments" section of resources, even though students have turned
>>>in assignments in that class with file attachments.
>>>
>>>Is that pretty normal? How is that supposed to work?
>>>
>>>
>>>Has the site ever been renamed in the past and student submitted assignment
>>>attachment when the site was still using the old name? According to the
>>>addAttachmentResource, the "site title" section for the attachment url was
>>>created with site name at that time, see below:
>>>
>>> ....
>>> String siteCollection = ATTACHMENTS_COLLECTION + siteId +
>>>Entity.SEPARATOR;
>>> try
>>> {
>>> checkCollection(siteCollection);
>>> }
>>> catch (Exception e)
>>> {
>>> // add this collection
>>> ContentCollectionEdit siteEdit =
>>>addCollection(siteCollection);
>>> try
>>> {
>>> String siteTitle =
>>>m_siteService.getSite(site).getTitle();
>>>
>>> siteEdit.getPropertiesEdit().addProperty(ResourceProperties.PROP_DISPLAY_NAME,
>>>siteTitle);
>>> }
>>> catch (Exception e1)
>>> {
>>>
>>> siteEdit.getPropertiesEdit().addProperty(ResourceProperties.PROP_DISPLAY_NAME,
>>>site);
>>> }
>>> commitCollection(siteEdit);
>>> }
>>>...
>>>
>>>Thanks,
>>>
>>>- Zhen
>>>
>>>
>>>
>>>_______________________________________________
>>>sakai-user mailing list
>>>sakai-user at collab.sakaiproject.org
>>>http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>>>
>>>TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org
>>>with a subject of "unsubscribe"
>>>
>>>
>>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20091020/f6162168/attachment-0001.html
More information about the sakai-user
mailing list