[Download-List] Dynamically Generated File Key?

[Jeff Flynt]

Hi Jeffrey,

 

Even if this were to work, you would probably require an EVAL:

 

GET.LIST 2007.3.ENROLLED

DOWNLOAD STUDENTS \

  SECONDARY.FILE STUDENT.TERMS KEY EVAL “@ID:’*2007.3*UG’” \

  STU.FIRST.NAME \

  STU.LAST.NAME \

  STUDENT.TERMS->STTR.TERM.GPA \

FILE HOLD 2007.2.GPAS.XLS FORMAT DIF HEADING FIELD.NAMES OVERWRITING

 

I have tried that in the past. And an EVAL does not work as a KEY expression - unless it has been added as a new feature when I wasn’t looking. L 

 

 

 

Jeff Flynt

Arizona State University Foundation | Information Resources Management 
Applications Systems Analyst, Sr.
P.O. Box 875905 | Tempe, Arizona | 85287-5905
PH: 480.965.6870 | Fax: 480.965-6686 | e-mail: jeff.flynt at asu.edu

  <http://www.asufoundation.org/> 

 

 

 

From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Jeffery Summers
Sent: Thursday, May 15, 2008 1:13 PM
To: 'Cedarville DOWNLOAD Users'
Subject: [Download-List] Dynamically Generated File Key?

 

I know I can create a computed column and make a file key.  But it would be nice not to have to do that.

 

Our terms are numeric, and our current term is 2007.3.  So I tried this out just to see what would happen:

 

GET.LIST 2007.3.ENROLLED

DOWNLOAD STUDENTS \

  SECONDARY.FILE STUDENT.TERMS KEY @ID:”*2007.3*UG” \

  STU.FIRST.NAME \

  STU.LAST.NAME \

  STUDENT.TERMS->STTR.TERM.GPA \

FILE HOLD 2007.2.GPAS.XLS FORMAT DIF HEADING FIELD.NAMES OVERWRITING

 

Resulting in:

 

The following records were not found on STUDENTS.

Possible causes include mistyping keywords,

mistyping record keys, or having an extraneous

continuation character in your DOWNLOAD statement.

 

"*2007.3*UG" not found.

"" not found.

Invalid syntax "KEY @ID:": should be "KEY fieldName"

 

So no luck.  But, can something like this be done within DOWNLOAD without creating a computed column?  

 

Thanks,

Jeffery G. Summers

System Admin

Transylvania University

300 N. Broadway

Lexington, KY 40508

jsummers at transy.edu

 

________________________________

Successfully scanned by McAfee SIG 3200 Appliance. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080515/74460095/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 1672 bytes
Desc: image001.gif
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080515/74460095/attachment.gif>