Ariadne - Technical description
The function P322_Entry_confirmations_email generates for a kayak club an email message with the entry confirmations for that club as attachment. This is realized by using the MS-Access Sendobject object. As the email client MS Outlook is required.
The email text is language specific. E.g. foreign clubs can receive the email in their own language. The email text is provided via a template file in xml-format. The template file can be edited externally via Notepad of Wordpad. Per language a different template has to be supplied. Depending on the language attribute of the kayak club the required email template is selected.
The query Q337 selects the officials to which entry conformations are to be send by email. When calling P322, the requested mailing instruction is specified with mailing-instruction-id. The requested confirmation is produced by filtering Q337 on mailing-instruction-id.
In order to make the construction with language dependent templates work, two tables are added to the Current Competition database, the T065-Language table and the T243-Document-template table. The schema below shows de tables and relations Q337 uses. (The email object is not a database table).
In producing an entry confirmation per email the next input is required for P322:
- dataset with variables (officials name, email address): Q338
As an example the xml email template is shown:
For parsing this email template, the MSXML library is used. For having access to this library, the library has to linked to by MS Access.
On basis of the template fragments the MSXML parser supplies, the To-string, Subject-string and Message-string (email body) are composed. The tags <email-address/>, <competition-abbrev/>, <kayak-club-name/>, <official-name/>, <first-name/>, <competition-name/> are replaced by values from Q100 and Q338.
2. Access path
3. Function structure
The structure of the function P322_Entry_confirmations_email is: