hi steve, thanks.
the project is an annual competition for young
composers. i receive an MS Word doc containing
individual scores and comments from each jury
member for all submissions. i convert the table
to text, drop in excel and import to JURIES from
the excel file. the unique value in this case is
an individual score+comment by a juror for a
specific piece.
i need to be able to provide all jury comments (anonymously) to the composer.
if we have a 20-member jury and 75 submissions,
my layout (with the sub-summaries layout part) is
such that all 20 comments (1 per juror) fit on
one page, with the sliding/printing options set
to remove all blank space. therefore a total of
75 unique pages need to be printed (named
"ComposerLastName_ProjectName2010.pdf) and
emailed to 75 composers (participants).
the composers and jurors are ubique records in
CONTACTS (mailing address, date of birth, bio,
email etc.). in the relationships, Jury Members
and Composers tables are separate instances of
the main CONTACTS database.
so the structure within the database containing the comments was actually:
JURIES___Jury Members table (CONTACTS)
\____ AUDIO___Composers table (CONTACTS)
based on your comments, i started setting up the
layout in AUDIO, and so far got most of it
working, except for some reason the same juror's
name appears for all 20 scores/comments...
AUDIO___Composers table (CONTACTS)
\____ JURIES___Jury Members table (CONTACTS)
cheers, almost there!!
jef
>I don't really get what your needs are. Maybe
>you could explain a bit more precisely?
>
>For example, what is a project? Is that a record in AUDIO?
>
>Who are the participants in a project? Are they
>the related record(s) in CONTACTS?
>
>It seems that you are wanting to generate one
>pdf for each AUDIO that shows all the comments.
>Basically, you have to do the printing from the
>JURIES table. But you'd 'start' (ie run the
>script) from the AUDIO table. Loop through each
>AUDIO record. For each one get a found set in
>JURIES of the related records. Generate the pdf.
>Return to the AUDIO table and go to the next
>record in the loop. That will generate one pdf
>per AUDIO (project?)
>
>How you address the email depends on who the participants are...
>
>Maybe that will set you on the right track?
>
>Steve
>
>On Sep 12, 2010, at 10:52 AM, CEC jef chippewa wrote:
>
>> hi, wondering if anyone could let me know of a
>>solution to generate and email PDFs to provide
>>project participants with comments from all
>>jury members relevant to the piece they
>>submitted to the project. relationships are as
>>follows:
>>
>> JURIES (comments) -- AUDIO (composition) -- CONTACTS (composer / email)
>>
>> everything works up to seeing the pages as i
>>want them: project information in the header,
>>CONTACTS::composer and AUDIO::composition info
>>in a sub-summary layout part (sorted by
>>CONTACTS::composer) and all juror comments in
>>the body. the layout.
>>
>> i know how to name individual PDFs using the
>>fileName variable, but can't figure out how to
>>make it work in this context, because of the
>>sub-summaries.
>>
> > other email scripts i use work because they
>are done from within CONTACTS, where each record
>is one person/email. i thought of doing it from
>a new layout in JURIES defined to "Show records
>from CONTACTS", but then i need a portal to show
>the comments, and the portal doesn't seem to
>recognize the sliding/printing options to remove
>empty space. (i have to define the text area
>large enough to accommodate the longest juror
>comments).
--
Communauté électroacoustique canadienne (CEC)
Canadian Electroacoustic Community
eContact! 12.4 Perspectives... http://cec.concordia.ca/econtact/12_4
Jeu de temps / Times Play CEC + ACMA http://cec.concordia.ca/jttp/2010
http://econtact.ca | http://sonus.ca | http://cec.concordia.ca/jttp
http://facebook.com/cec.sonus
|
