Registration Confirmation (regconfirm.txt)

The following template tags are used on the Registration Confirmation template:

The tCard cursor contains fields from the Course table. Available fields are:

cocrse, cocrsenm, cotype, coalias, cocategory, cobegdate AS Begins, coenddate AS ENDS, coregtime, conoteprt AS Notes, cocatcode, codow, colocid, cocrsetm, coinstid, cosess, cocoord, coregwarn

If you have added tables to the ##-Config-## statement, the tCard cursor also includes fields from those tables. See ##-Config-## section information above.

The ##loName.FullName()## function returns the registrant's name in First MI Last Suffix format by default. You can modify that by entering one of the following parameters into the function:

1 = First MI Last
2 = Last, First MI
3 = First Last
4 = Salutation First MI Last Suffix
5 = Last Suffix, First MI

E.g. ##loName.FullName(4)## would return Mr John M Smith Sr

You can also display other data from the registrant's name record using the ##tPerson.fieldname## template tag where fieldname is the name of the field you want to include. E.g. ##tPerson.nmcity## displays the registrant's City in the email.

You can include NameUDF data by adding the NAMEUDFS attribute to the ExtraFields setting in the ##-Config-##

##-Config-##
<ExtraFields>:LOCATION:CrseUDFs:NAMEUDFS:</ExtraFields>
##-End-##

Then using the tPersonUDF cursor to add a field, e.g. ##tPerson.nudfc1##

If you use the Membership option and want to show Membership Expiration information in confirmation emails sent to the individual, add the following expression to the ##-ConfirmTitle-## section of the regconfirm.txt template.

##iif(!empty(loName.Memberships()),"<tr><td>Memberships: "+loName.Memberships(,,[style='color: red;'])+"</td></tr>","")##

The function will return Membership expiration info in the confirmation email, e.g.

Optional parameters can be entered to modify the display of the Membership information:

1. Delimiter to divide multiple memberships (defaults to comma).
2. Filter to limit which memberships are listed (e.g. nccode==tCard.cocatcode).
3. HTML attributes, applied to span around expired memberships (e.g. [style='color: red;']; used in above function example).
4. Message to display if user has no memberships (defaults to "None").
5. Expiration limit – number of days into the past that expired memberships are reported (defaults to 366 days).

You can display *registration information in the email using the tRegister and tRegUDFs cursors. E.g.

• ##tRegister.rgcode## displays the value of the rgcode field.
• ##tRegUDFs.rudfc1## displays the value of the 1st Character type field.

These options are mostly used with the Supplemental Data Capture feature.

*IMPORTANT: any numeric fields you want to include in email confirmations must be transformed to text .

You can display payment information in the email using the ##tPay.fieldname## template tag. For example, display the Credit Card Authorization # if paid by credit card:

##iif(!empty(tPay.pyauthnum),[Credit Card Authorization #: ]+tPay.pyauthnum,[])##

There are several variables used in email confirmation templates

• *pnDepAmount - used when paying a deposit only. Returns the amount of deposit.
• pcDepDescript - used when paying a deposit only. Returns the description of the Deposit fee.
• plNoCharge - logical field set if there is no charge for the transaction.
• plInvoice - logical field set if person chose the invoicing option.
• lcTotals - generated statement listing total charges for transaction. E.g. Total Charges: $50.00.
• lcTax - generated statement stating tax amount (if being charged). E.g. Includes 8% tax.
• *lnSubttl - returns sub total for each course in the transaction.
• *lnTotals - returns total amount for the transaction.

*Numeric fields must be transformed to text to use in email confirmations.

You can include these Workshop fields in the ##-Workshops-## section:

wmcode, wmtitle, wmcatcode, wmdate, wmtime, wmop1, wmopt2, wmloc, wmleader, wmnote, *wsfee (workshop fee)

If you want to include other information not addressed above, you must use an SQL section to retrieve additional information. For help with creating an SQL statement and adding the fields to the regconfim.txt template, please contact your ACEware Systems technician.

You can customize the subject line.

You can include email attachments with the ACEweb Registration Confirmation. If the web registration includes multiple courses with receipt attachments, all the specified files will be attached.

Include an .ICS calendar attachment file (contains session information that registrant can import into their Calendar program--IF-- their program supports .ics files) with the VCAL section.

To enable the VCAL section, open the regconfirm.txt and remove the xx's (in red below):

##xx-VCAL-xx##
BEGIN:VCALENDAR
##xx-/VCAL-xx##