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
