[LON-CAPA-users] spreadsheet access folder name?

[Guy Albertelli II]

Hi Jon,

> if i have a bunch of problems in located in folders named:
> 
> Homework 14A
> Lab: Centripetal Motion
> Lab: Simple Pendulum
> Homework 14B
> Quiz 14.1
> 
> how can i reference that information in the assessment-level  
> spreadsheet?
>
> i.e. how do i code
> 
> if (folder name contains 'Homework')
> {
> calculation 1;
> }
> else
> {
> calculation 2;
> }

You can however set what assessment level spreadsheet is used on a per
resource basis.

So you could create 2 assement level sheets and use one for all the
Homeworks and a different one for the labs, quizzes, etc.

But for the next version one should be able to do

&EXT('resource.title') to get the current resource's title
&EXT('resource.map') to get the internal name of current resource
                     folder (or sequence or page)
and combine them:
&EXT('resource.title',&EXT('resource.map'))

To get the title of the current resources folder.

(If you are want to try testing these changes out, you'll need to
patch in:
Spreadsheet.pm 1.61
http://install.loncapa.org/cgi-bin/cvsweb.cgi/loncom/interface/spreadsheet/Spreadsheet.pm.diff?r1=1.60;r2=1.61

and 

lonnet.pm 1.693
http://install.loncapa.org/cgi-bin/cvsweb.cgi/loncom/lonnet/perl/lonnet.pm.diff?r1=1.692;r2=1.693
)

-- 
guy@albertelli.com   0-7-1-8-27,137