[Portfolio] Compiling Portfolio Matrix Elements into a Compiled Report

David McPherson dmcphers at vt.edu
Wed Aug 10 13:01:48 PDT 2011


In case anyone is interested...I made up a new one for 2.7.  I'll attach the MySQLWorkbench file too, in case you want to tweak the source.

Dave

-------------- next part --------------
A non-text attachment was scrubbed...
Name: ospTables.mwb
Type: application/octet-stream
Size: 66694 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/portfolio/attachments/20110810/17c462ea/attachment-0001.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ospTables.png
Type: image/png
Size: 908089 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/portfolio/attachments/20110810/17c462ea/attachment-0001.png 
-------------- next part --------------

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
David McPherson
Assistant Director, ePortfolio Initiatives
2210A Torgersen Hall
Learning Technologies
dmcphers at vt.edu
540-231-8993









On Aug 8, 2011, at 11:00 AM, Sean Keesler wrote:

> I'll mention this old chestnut of an ERD from 2.4 days...
> Not sure how much the world has changed, but it may help get you
> started understanding all of the relationships:
> 
> http://sakai-project-mail-list-archives.1343168.n2.nabble.com/attachment/3081542/0/SakaiERD.png
> 
> 
> Sean
> 
> 
> 
> On Fri, Aug 5, 2011 at 10:33 AM, David McPherson <dmcphers at vt.edu> wrote:
>> Hi Mike,
>> Ok...I think the OSP reports tool will do what you need.  Right now, I don't
>> have the code in a place where you can easily get to it.  I'm working on
>> getting my committer access set up and then you should be able to simply
>> check out the 2.7 version of the reports code.  You might be able to get the
>> IU version, which is what I've been working on getting running.  It allows
>> for the importing of reports while Sakai is running.  I think if you ask
>> Chris Mauer he won't mind letting you have access to that.  You would have
>> to modify the pom files to get it to build in Sakai 2.7 and there is one
>> extra parameter on one method that you need to remove.  I can find that line
>> and let you know what it is.
>> The next step would be learning how to write the reports.  That's what I'm
>> working on now. Here's a link to the confluence information I'm using.
>>  https://confluence.sakaiproject.org/display/OSPDOC/Writing+Reports+for+the+OSP+Reports+tool
>> I think there might be some sample reports linked off of there.
>> Let me know if you get stuck or if you want to bounce some ideas around.
>> Dave
>> --
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> David McPherson
>> Assistant Director, ePortfolio Initiatives
>> 2210A Torgersen Hall
>> Learning Technologies
>> dmcphers at vt.edu
>> 540-231-8993
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> On Aug 5, 2011, at 10:15 AM, Mike Song wrote:
>> 
>> Hi Dave,
>> Right now I've just set up a sandbox where I can experiment with a bunch of
>> different things.  I've set it up so students can upload a photo and enter a
>> rich-text bio into the matrix.  What i'm trying to do is now take those
>> elements from EVERY student and create a collection of many students in a
>> group and display their name photo and bio in a list.
>> I'm running Sakai version 2.7.1 and I have the following tools available:
>> Home
>> Announcements
>> Assignments
>> Basic LTI
>> Calendar
>> Email Archive
>> Evaluation System
>> Evaluations
>> Forms
>> Glossary
>> Mailtool
>> Matrices
>> News
>> Portfolio Layouts
>> Portfolio Showcase
>> Portfolio Templates
>> Portfolios
>> Resources
>> Roster
>> Search
>> Site Editor
>> Styles
>> Web Content
>> Wizards
>> 
>> On Fri, Aug 5, 2011 at 6:21 AM, David McPherson <dmcphers at vt.edu> wrote:
>>> 
>>> Hi Mike,
>>> I'm working on the "officially deprecated" OSP reports tool, that could
>>> possibly do something like this.  We have reports running in both 2.7 and
>>> 2.8.  I believe it also runs as far back as 2.4.  I think what you are
>>> asking about is possible with the tool, depending on where the data is
>>> stored, e.g. in a form, and what you are trying to do with this.
>>> Can you tell me some more about your installation?  What version of Sakai
>>> are you running? What tools do you have installed? etc.
>>> Thanks,
>>> Dave McPherson
>>> --
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> David McPherson
>>> Assistant Director, ePortfolio Initiatives
>>> 2210A Torgersen Hall
>>> Learning Technologies
>>> dmcphers at vt.edu
>>> 540-231-8993
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> On Aug 4, 2011, at 2:40 PM, Mike Song wrote:
>>> 
>>> Hi everyone,
>>> This is my first post and I'm looking for some help.  Here's what I'm
>>> trying to do... Take the Name, Bio, and user-uploaded Photo for each and
>>> every student enrolled in a course in Sakai and output that into a single
>>> report.  Does anyone have anything like this working now?  The students
>>> previously enter all of their information and upload their photos into their
>>> individual portfolios, but I'm trying to take each element from each student
>>> and bring it into a larger report that includes everyone.
>>> Thanks! Any help/advice would be greatly appreciated.
>>> Mike Song
>>> USUHS
>>> Bethesda, MD
>>> michael.song.ctr (at) usuhs.mil
>>> mtsong (at) gmail.com
>>> _______________________________________________
>>> portfolio mailing list
>>> portfolio at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/portfolio
>>> 
>>> TO UNSUBSCRIBE: send email to
>>> portfolio-unsubscribe at collab.sakaiproject.org with a subject of
>>> "unsubscribe"
>> 
>> 
>> 
>> _______________________________________________
>> portfolio mailing list
>> portfolio at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/portfolio
>> 
>> TO UNSUBSCRIBE: send email to portfolio-unsubscribe at collab.sakaiproject.org
>> with a subject of "unsubscribe"
>> 



More information about the portfolio mailing list