Release notes/10.1.8

2023-02-25T15:38:39Z

Aloha: Created page with "< Release notes '''Convention Master 10.1.8''' Released on January 12, 2023. ---------------------------------------------------- Release notes for version 10.1.8. January 12, 2023, 00:54: ---------------------------------------------------- The following changes and or features were added: * No new features or feature changes in this release Other fixes/changes: * Fixed a problem with new events wizard where it had problems inserting badge typ..."

Release notes/10.1.6

2022-09-21T03:15:44Z

Aloha:

< [[Release notes]]

'''Convention Master 10.1.6''' Released on January 10, 2022.

'''UPGRADE WARNING:''' If you are currently on version 10.0.x, release 10.1 has special instructions added to the upgrade process. Please make sure you read them before performing an upgrade. See [[Upgrading Convention Master]]

----------------------------------------------------
Release notes for version 10.1.6.
September 14, 2022
----------------------------------------------------
The following changes and or features were added

* Mantis 525 - Bag stuffing stickers PDF now better chops pages without wasted paper.
* Mantis 786 - Bag stuffing stickers can now be printed to PDF printers.
* Mantis 834 - Bag stuffing stickers can now be printed to a PDF file that you can download.
* Mantis 945 - Improved the submit button to prevent multiple clicks from resubmitting the form in den application kiosks. This will prevent duplicated den applications. Also updated table style of pre-auth space codes to match the rest of the kiosk steps.
* Mantis 958 - Bag stuffing stickers now use the standard printer queue system and support all printer types.
* Mantis 1038 - Bag stuffing stickers can now be printed using the filtering system.
* Mantis 1105 - Fixed bug that prevented Space Requests from being deleted by applicants in the ArtShow/Dealer Application kiosks.
* Mantis 1144 - Overhauled Bag Stuffing Sticker system.
* Mantis 1165 - Corrected a bug that prevented "use event default" from working correctly on the agreements step of the kiosk.
* Mantis 1167 - Overhauled Payment Holds system to handle abandoned carts and instant payment methods better so automated tasks can be used to clean up abandoned shopping carts effectively.
* Mantis 1195 - Created a new feature that will log the history of Fan name and legal name changes and provide the ability to search for previously used names quickly.
* Mantis 1214 - Created a new feature to find and display user account duplicates.
* Mantis 1217 - Upgrade license checks to warn when a valid license is installed but is for the wrong event database.
(primarily to help our customers who share equipment between multiple events.)
* Mantis 1218 - Added PHP CLI diagnostic info to the Diagnostic Log to assist in debugging installation issues.
* Mantis 1219 - Updated DB Sanitization script for registrant notes.
* Mantis 1227 - Fixed an issue preventing database upgrades prior to v576 from working in some situations.
* Mantis 1231 - Added the barcode options to the Online Payment kiosk step. This will allow people to pay in line and display a barcode on their phone to be ready for the cashier.
* Mantis 1234 - Improved the submit button to prevent multiple clicks from resubmitting the form in kiosks. This will prevent duplicate notification emails.
* Mantis 1235 - Improved method used to pass data in URLs.
Note: This will invalidate some URLs generated on console/kiosk pages before applying the update.
Refreshing the page will generate new URLs, which only matters to users actively using CM during the upgrade.
* Mantis 1239 - Automatically process zero-dollar payments (if applicable) on the Kiosk payment step. This resolves an issue for events using memberships that cost $0 that comes with bag-stuffed products.
* Mantis 1240 - Add a default payment hold to the user's account at the select membership kiosk screen if their payment hold is either non-existent or expired.
* Mantis 1241 - Add a default payment hold to the user's account at the go shopping kiosk screen if their payment hold is either non-existent or expired.
* Mantis 1242 - Ensure that instant payment Gateway transactions create a payment hold in the kiosk payment holds system.
* Mantis 1246 - Corrected an issue where certain situations could prevent bag stuffing labels from being generated for bag stuffed products purchased with a voucher.
* Mantis 1248 - Updated database migration runner for newer versions of MySQL server to prevent UTF8 upgrade from running unnecessarily during database migrations. (this only impacted performance - no data was modified.)
* Mantis 1253 - Updated DB Sanitization script to run at the current database version.
* Mantis 1254 - Updated Kiosk change name step to utilize new name logging system.
* Mantis 1258 - Corrected an issue on the choose freebies kiosk step, allowing you to select an out-of-stock product if it had a negative number remaining in inventory.

{{UpgradeAdvice}}

Sending parsed DL-ID data to CM

2022-09-19T17:09:17Z

Aloha:

When trying to implement reading of DL/ID barcodes we realized a way to pass the information to CM in a machine parsable way that was easy to send via a web browser without add-on software was needed.

This document attempts to create a standard so either mobile applications, or hardware imagers can be programmed to send the needed DL/ID information to CM, in a way that is universal and easy to understand.

Note, any field concatenation should be done on the server side, and blank fields are allowed, and will be ignored by the server side parser.

== V1 Data String ==
<tt>!V1!firstname!lastname!suffix!dateofbirth!address1!address2!city!state!postalcode!country<enter></tt>

For more information about the AAMVA field, see ''Annex D'' of the AAMVA DL/ID Card Design Standard

{| class="wikitable"
|+ V1 Data String Breakdown and Explanation
|-
! Data String !! AAMVA field !! Field Information !! Notes/Definition
|-
| V1 || N/A || !V followed by up to 3 numbers || Version String
|-
| firstname || DAC || Up to 40 Chars ANSI Text || First name of the cardholder.
|-
| lastname || DCS || Up to 40 Chars ANSI Text || Family Name of the Cardholder
|-
| suffix || DCU || Up to 40 Chars ANSI Text || Name Suffix (Issuer Optional)
|-
| dateofbirth || DBB || 8 Characters Numbers Only || CM Expected format is CCYYMMDD, format on license may be MMDDCCYY or CCYYMMDD, Reader must convert
|-
| address1 || DAG || Up to 35 Chars ANSI Text || Street Portion of Address
|-
| address2 || DAH || Up to 35 Chars ANSI Text || Second Line of Address (Issuer Optional)
|-
| city || DAI || Up to 20 Chars ANSI Text || City Portion of Cardholder Address
|-
| state || DAJ || 2 Chars ANSI Text || State Portion of the Cardholder Address
|-
| postalcode || DAK || Up to 11 Chars ANSI Text || Postal Code, includes zip+4 for US
|-
| country || DCG || 3 Chars ANSI Text || Country the Card is issued in
|-
| <enter> || N/A || N/A || Send the Enter Key when done reading.
|}

==Reference Documents==
[https://www.aamva.org/assets/best-practices-guidance/dl-id-card-design-standard AAMVA DL/ID Card Design Standard]

[https://www.zebra.com/us/en/support-downloads/scanners/general-purpose-scanners/ds6708-dl.html Support Page to obtain product reference guide for DS6708]

Sending parsed DL-ID data to CM

2022-09-19T17:03:55Z

Aloha:

When trying to implement reading of DL/ID barcodes we realized a way to pass the information to CM in a machine parsable way that was easy to send via a web browser without add-on software was needed.

This document attempts to create a standard so either mobile applications, or hardware imagers can be programmed to send the needed DL/ID information to CM, in a way that is universal and easy to understand.

Note, any field concatenation should be done on the server side, and blank fields are allowed, and will be ignored by the server side parser.

== V1 Data String ==
<tt>!V1!firstname!lastname!suffix!dateofbirth!address1!address2!city!state!postalcode!country<enter></tt>

For more information about the AAMVA field, see ''Annex D'' of the AAMVA DL/ID Card Design Standard

{| class="wikitable"
|+ V1 Data String Breakdown and Explanation
|-
! Data String !! AAMVA field !! Field Information !! Notes/Definition
|-
| V1 || N/A || !V followed by up to 3 numbers || Version String
|-
| firstname || DAC || Up to 40 Chars ANSI Text || First name of the cardholder.
|-
| lastname || DCS || Up to 40 Chars ANSI Text || Family Name of the Cardholder
|-
| suffix || DCU || Up to 40 Chars ANSI Text || Name Suffix (Issuer Optional)
|-
| dateofbirth || DBB || Up to 40 Chars ANSI Text || CM Expected format is CCYYMMDD, format on license may be MMDDCCYY or CCYYMMDD, Reader must convert
|-
| address1 || DAG || Up to 40 Chars ANSI Text || Street Portion of Address
|-
| address2 || DAH || Up to 40 Chars ANSI Text || Second Line of Address (Issuer Optional)
|-
| city || DAI || Up to 40 Chars ANSI Text || City Portion of Cardholder Address
|-
| state || DAJ || Up to 40 Chars ANSI Text || State Portion of the Cardholder Address
|-
| postalcode || DAK || Up to 40 Chars ANSI Text || Postal Code, includes zip+4 for US
|-
| country || DCG || Up to 40 Chars ANSI Text || Country the Card is issued in
|-
| <enter> || N/A || N/A || Send the Enter Key when done reading.
|}

==Reference Documents==
[https://www.aamva.org/assets/best-practices-guidance/dl-id-card-design-standard AAMVA DL/ID Card Design Standard]

[https://www.zebra.com/us/en/support-downloads/scanners/general-purpose-scanners/ds6708-dl.html Support Page to obtain product reference guide for DS6708]

Sending parsed DL-ID data to CM

2022-08-25T17:24:24Z

Aloha:

When trying to implement reading of DL/ID barcodes we realized a way to pass the information to CM in a machine parsable way that was easy to send via a web browser without add-on software was needed.

This document attempts to create a standard so either mobile applications, or hardware imagers can be programmed to send the needed DL/ID information to CM, in a way that is universal and easy to understand.

Note, any field concatenation should be done on the server side, and blank fields are allowed, and will be ignored by the server side parser.

== V1 Data String ==
<tt>!V1!firstname!lastname!suffix!dateofbirth!address1!address2!city!state!postalcode!country<enter></tt>

For more information about the AAMVA field, see ''Annex D'' of the AAMVA DL/ID Card Design Standard

{| class="wikitable"
|+ V1 Data String Breakdown and Explanation
|-
! Data String !! AAMVA field !! Notes/Definition
|-
| V1 || N/A || Version String
|-
| firstname || DAC || First name of the cardholder.
|-
| lastname || DCS || Family Name of the Cardholder
|-
| suffix || DCU || Name Suffix (Issuer Optional)
|-
| dateofbirth || DBB || CM Expected format is CCYYMMDD, format on license may be MMDDCCYY or CCYYMMDD, Reader must convert
|-
| address1 || DAG || Street Portion of Address
|-
| address2 || DAH || Second Line of Address (Issuer Optional)
|-
| city || DAI || City Portion of Cardholder Address
|-
| state || DAJ || State Portion of the Cardholder Address
|-
| postalcode || DAK || Postal Code, includes zip+4 for US
|-
| country || DCG || Country the Card is issued in
|-
| <enter> || N/A || Send the Enter Key when done reading.
|}

==Reference Documents==
[https://www.aamva.org/assets/best-practices-guidance/dl-id-card-design-standard AAMVA DL/ID Card Design Standard]

[https://www.zebra.com/us/en/support-downloads/scanners/general-purpose-scanners/ds6708-dl.html Support Page to obtain product reference guide for DS6708]

2021-07-22T03:45:54Z

Aloha: Aloha moved page Universal Substitution System to Proposed Universal Substitution System

=== General Idea ===
CM has a bunch of variable lookup systems, it would be helpful to combine these into one system.

This article is still a stub.

{| class="wikitable"
|+ registrant
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| uid||outputs the registrant uid.||Tag Replacements||reg_uid||$uid|||
|-
| legal_first||outputs registrant first name. ||Tag Replacements||reg_rl_first||$registrant_rl_first|||
|-
| legal_last||outputs registrant last name. ||Tag Replacements||reg_rl_last||$registrant_rl_last|||
|-
| legal_name||outputs registrant "first" + "last" name. ||Tag Replacements||reg_full_name||||
|-
| common_name||outputs registrant badge name if not empty - otherwise thier "first" + "last" name. ||Tag Replacements||reg_badge_name||$registrant_fan_name|||
|-
| badge_name||outputs registrant badge name. ||Tag Replacements||reg_birthday||$registrant_birthday|||
|-
| birthday||outputs registrant birthdate. ||Tag Replacements||reg_first_created||||
|-
| first_created||outputs registrant account creation date from database. ||Tag Replacements||reg_common_name||$registrant_common_name|||
|-
| address_ship_to_name||outputs registrant ship to name. ||Tag Replacements||reg_address_ship_to_name||||
|-
| address_line_1||outputs registrant address line 1. ||Tag Replacements||reg_address_line_1||||
|-
| address_line_2||outputs registrant address line 2. ||Tag Replacements||reg_address_line_2||||
|-
| address_city||outputs registrant address city. ||Tag Replacements||reg_address_city||||
|-
| address_state||outputs registrant address state. ||Tag Replacements||reg_address_state||||
|-
| address_country||outputs registrant address country. ||Tag Replacements||reg_address_country||||
|-
| address_postcode||outputs registrant address zip/postcode. ||Tag Replacements||reg_address_zip||||
|-
| address_full||outputs registrant address with all fields combined. ||Tag Replacements||reg_address_full||||
|-
| phone_type||outputs registrant phone type. ||Tag Replacements||reg_phone_type||||
|-
| phone_number||outputs registrant phone number. ||Tag Replacements||reg_phone_number||||
|-
| email||outputs registrant email. ||Tag Replacements||reg_email||||
|-
| payment_hold_created||outputs date payment hold was created for current registrant and event. ||Tag Replacements||reg_payment_hold_created||||
|-
| payment_hold_expiry||outputs date payment hold will expire for current registrant and event. ex: 2020-01-22 18:30:15 ||Tag Replacements||reg_payment_hold_expiry||||
|-
| payment_hold_extendable_to||outputs latest date payment hold can be extended up to for current registrant and event. ||Tag Replacements||reg_payment_hold_extendable_to||||
|-
| payment_hold_payment_type||outputs most recent payment type selected for current registrant and event ||Tag Replacements||reg_payment_hold_payment_type||||
|-
| payment_hold_expiry_long||outputs long date payment hold will expire for current registrant and event. ex: Wednesday, January 22, 2020, @ 6:30 PM ||Tag Replacements||reg_payment_hold_expiry_long||||
|-
| bool_marked_deceased||Returns True if the user is marked deceased||new||||||
|-
| bool_ConsoleUser||Returns True if the user has an active console login||new||||||
|-
| consoleUserExpiryDate||Displays expiration date for console login||new||||||
|-
| CompMoneyRemaining||Displays the remaining comp money||new||||||
|}

{| class="wikitable"
|+ events
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| event_id||outputs the Event Id. Example: "DEMO_1"||Tag Replacements||event_id||$event_id||
|-
| event_title||outputs the Event Title. Example: "Demo Event" ||Tag Replacements||event_title||$events_event_title||
|-
| event_start_date||outputs event start date from event settings. ||Tag Replacements||event_start_date||||
|-
| event_end_date||outputs event end date from event settings.||Tag Replacements||event_end_date||||
|-
| event_age_of_maturity||outputs event age of maturity from event settings. ||Tag Replacements||event_age_of_maturity||||
|-
| event_pre_reg_end_date||outputs event pre-reg end date from event settings. ||Tag Replacements||event_pre_reg_end_date||||
|-
| event_address_1||outputs address line 1 from event settings. ||Tag Replacements||event_address_1||||
|-
| event_address_2||outputs address line 2 from event settings. ||Tag Replacements||event_address_2||||
|-
| event_address_3||outputs address line 3 from event settings. ||Tag Replacements||event_address_3||||
|-
| event_address_4||outputs address line 4 from event settings.||Tag Replacements||event_address_4||||
|-
| event_address_full||outputs event address with all fields combined. ||new||||||
|-
| event_defaultFromEmail||outputs default from email address in event settings. ||Tag Replacements||event_defaultFromEmail||||
|-
| event_defaultReplyTo||outputs default reply to: in event settings. ||Tag Replacements||event_defaultReplyTo||||
|-
| event_chequeToName||outputs cheque to name in event settings. ||Tag Replacements||event_chequeToName||||
|}

{| class="wikitable"
|+ attendee
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| bool_underage||true if below age of maturity set for event from birthdate and stored event age of maturity||badgecode||||$underage||
|-
| num||registration sequence number for that particular event||Tag Replacements||reg_reg_num||$events_attended_reg_num||
|-
| badge_display_code||outputs registrant badge layout code. Example: FNOT||Tag Replacements||reg_badge_display_code||||
|-
| membership_name||outputs membership name. (setting: Group Name)||Tag Replacements||reg_membership_name||$event_membership_types_name||
|-
| membership_long_name||outputs membership long name. (setting: Membership Type as printed on badge) ||Tag Replacements||reg_membership_long_name||$event_membership_types_long_name||
|-
| membership_full_desc||outputs membership description. (setting: Sales pitch description:) ||Tag Replacements||reg_membership_full_desc||||
|-
| membership_rules||outputs membership rules. (setting: Rules For this membership) ||Tag Replacements||reg_membership_rules||||
|-
| membership_type||outputs registrant membership code for current event. Example SPON_0||Tag Replacements||reg_membership_type||||
|-
| membership_last_updated||outputs membership last modified date for current event. ||Tag Replacements||reg_membership_last_updated||||
|-
| membership_price||outputs membership price. ||Tag Replacements||reg_membership_price||||
|-
| membership_avail_from||outputs membership available from date. ||Tag Replacements||reg_membership_avail_from||||
|-
| membership_avail_to||outputs membership available to date. ||Tag Replacements||reg_membership_avail_to||||
|-
| staff||if attendee_membership_name contains the word 'staff' this will equal true, this is not case sensitive.||badgecode||||$staff||if retained, maybe this should also check membership_long_name
|}

{| class="wikitable"
|+ panelist
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| bool_has_confirmed_activity||useful for a true false for flagging panelist badges.||new||||||This is highly speculative, however I'm presuming this would work something like AS/DD in that the application would be tied to the UID of the person who applied, so we could pick it up that way, it could go into the attendee group
|-
| bool_activity_host||useful for a true false for flagging panelist badges.||new|||||||
|-
| bool_activity_assistant||useful for a true false for flagging panelist badges.||new|||||||
|-
| bool_is_panelist||true if uid matches to either activity host or assistant - useful for a true false for flagging panelist badges.||new|||||||
|-
| activity_schedule||displays a formatted list of activities a panelist is assigned/confirmed to||new|||||||
|}

{| class="wikitable"
|+ dealers
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| <num>_application_state||useful for doing a strcmp in badgecode to automatically tag dealers on approved dealers/artists.||new||||||for correctness I want to call this group artshow, but these function will only really be used by dealers den
|-
| bool_<num>_confirmed||useful for a true false for flagging dealer badges.||new||||||these three are listed as options
|-
| bool_<num>_assistant||useful for a true false for flagging dealer assistant badges.||new||||||these three are listed as options
|}

{| class="wikitable"
|+ udf
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| <num>_title||Will display the title of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_title.||Badgecode||||$udf_title||
|-
| <num>_value||Will display the value of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_value.||Badgecode||||$udf_value||
|-
| bool_<num>||Returns True is the UDF has been answered||new||||||
|-
| <num>_type||returns the udf type||new||||||
|-
| <num>_udf_response_list||Will display the UDF questions if relevent||new||||||
|}

{| class="wikitable"
|+ product
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| bool_purchased_<num>||returns true if the customer has purchased the product||new||||||
|-
| bool_incart_||returns true if the customer has the product in their cart||new||||||
|-
| <num>_info||displays product description||new||||||
|-
| <num>_price||displays product price||new||||||
|-
| <num>_items_sold||displays how many have been sold||new||||||
|-
| <num>_items_remaining||displays how many are remaining (cart+purchased-inventory)||new||||||
|}

{| class="wikitable"
|+ system
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| cm_version||displays CM version string||new||||||
|-
| db_version||displays db db version int||new||||||
|-
| copyright||displays cm copyright statement||new||||||
|-
| license_expiration||displays license expiration date||new||||||
|-
| license_valid_events||displays list of valid events||new||||||
|-
| bool_dev_license||returns true if dev license||new||||||
|}

2021-07-22T03:23:18Z

Aloha:

{| class="wikitable"
|+ registrant
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| uid||outputs the registrant uid.||Tag Replacements||reg_uid||$uid|||
|-
| legal_first||outputs registrant first name. ||Tag Replacements||reg_rl_first||$registrant_rl_first|||
|-
| legal_last||outputs registrant last name. ||Tag Replacements||reg_rl_last||$registrant_rl_last|||
|-
| legal_name||outputs registrant "first" + "last" name. ||Tag Replacements||reg_full_name||||
|-
| common_name||outputs registrant badge name if not empty - otherwise thier "first" + "last" name. ||Tag Replacements||reg_badge_name||$registrant_fan_name|||
|-
| badge_name||outputs registrant badge name. ||Tag Replacements||reg_birthday||$registrant_birthday|||
|-
| birthday||outputs registrant birthdate. ||Tag Replacements||reg_first_created|||
|-
| first_created||outputs registrant account creation date from database. ||Tag Replacements||reg_common_name||$registrant_common_name|||
|-
| address_ship_to_name||outputs registrant ship to name. ||Tag Replacements||reg_address_ship_to_name|||
|-
| address_line_1||outputs registrant address line 1. ||Tag Replacements||reg_address_line_1|||
|-
| address_line_2||outputs registrant address line 2. ||Tag Replacements||reg_address_line_2|||
|-
| address_city||outputs registrant address city. ||Tag Replacements||reg_address_city|||
|-
| address_state||outputs registrant address state. ||Tag Replacements||reg_address_state|||
|-
| address_country||outputs registrant address country. ||Tag Replacements||reg_address_country|||
|-
| address_zip||outputs registrant address zip. ||Tag Replacements||reg_address_zip|||
|-
| address_full||outputs registrant address with all fields combined. ||Tag Replacements||reg_address_full|||
|-
| phone_type||outputs registrant phone type. ||Tag Replacements||reg_phone_type|||
|-
| phone_number||outputs registrant phone number. ||Tag Replacements||reg_phone_number|||
|-
| email||outputs registrant email. ||Tag Replacements||reg_email|||
|-
| payment_hold_created||outputs date payment hold was created for current registrant and event. ||Tag Replacements||reg_payment_hold_created||||
|-
| payment_hold_expiry||outputs date payment hold will expire for current registrant and event. ex: 2020-01-22 18:30:15 ||Tag Replacements||reg_payment_hold_expiry||||
|-
| payment_hold_extendable_to||outputs latest date payment hold can be extended up to for current registrant and event. ||Tag Replacements||reg_payment_hold_extendable_to||||
|-
| payment_hold_payment_type||outputs most recent payment type selected for current registrant and event ||Tag Replacements||reg_payment_hold_payment_type||||
|-
| payment_hold_expiry_long||outputs long date payment hold will expire for current registrant and event. ex: Wednesday, January 22, 2020, @ 6:30 PM ||Tag Replacements||reg_payment_hold_expiry_long||||
|-
| bool_marked_deceased||Returns True if the user is marked deceased||new||||
|-
| bool_ConsoleUser||Returns True if the user has an active console login||new||||
|-
| consoleUserExpiryDate||Displays expiration date for console login||new||||
|-
| CompMoneyRemaining||Displays the remaining comp money||new||||
|}

{| class="wikitable"
|+ events
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| event_id||outputs the Event Id. Example: "DEMO_1"||Tag Replacements||event_id||$event_id||||
|-
| event_title||outputs the Event Title. Example: "Demo Event" ||Tag Replacements||event_title||$events_event_title||||
|-
| event_start_date||outputs event start date from event settings. ||Tag Replacements||event_start_date||||
|-
| event_end_date||outputs event end date from event settings.||Tag Replacements||event_end_date||||
|-
| event_age_of_maturity||outputs event age of maturity from event settings. ||Tag Replacements||event_age_of_maturity||||
|-
| event_pre_reg_end_date||outputs event pre-reg end date from event settings. ||Tag Replacements||event_pre_reg_end_date||||
|-
| event_address_1||outputs address line 1 from event settings. ||Tag Replacements||event_address_1||||
|-
| event_address_2||outputs address line 2 from event settings. ||Tag Replacements||event_address_2||||
|-
| event_address_3||outputs address line 3 from event settings. ||Tag Replacements||event_address_3||||
|-
| event_address_4||outputs address line 4 from event settings.||Tag Replacements||event_address_4||||
|-
| event_address_full||outputs event address with all fields combined. ||new||||||
|-
| event_defaultFromEmail||outputs default from email address in event settings. ||Tag Replacements||event_defaultFromEmail||||
|-
| event_defaultReplyTo||outputs default reply to: in event settings. ||Tag Replacements||event_defaultReplyTo||||
|-
| event_chequeToName||outputs cheque to name in event settings. ||Tag Replacements||event_chequeToName||||
|}

{| class="wikitable"
|+ attendee
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| bool_underage||true if below age of maturity set for event from birthdate and stored event age of maturity||badgecode||||$underage||||
|-
| num||registration sequence number for that particular event||Tag Replacements||reg_reg_num||$events_attended_reg_num||||
|-
| badge_display_code||outputs registrant badge layout code. Example: FNOT||Tag Replacements||reg_badge_display_code||||
|-
| membership_name||outputs membership name. (setting: Group Name)||Tag Replacements||reg_membership_name||$event_membership_types_name||||
|-
| membership_long_name||outputs membership long name. (setting: Membership Type as printed on badge) ||Tag Replacements||reg_membership_long_name||$event_membership_types_long_name||||
|-
| membership_full_desc||outputs membership description. (setting: Sales pitch description:) ||Tag Replacements||reg_membership_full_desc||||
|-
| membership_rules||outputs membership rules. (setting: Rules For this membership) ||Tag Replacements||reg_membership_rules||||
|-
| membership_type||outputs registrant membership code for current event. Example SPON_0||Tag Replacements||reg_membership_type||||
|-
| membership_last_updated||outputs membership last modified date for current event. ||Tag Replacements||reg_membership_last_updated||||
|-
| membership_price||outputs membership price. ||Tag Replacements||reg_membership_price||||
|-
| membership_avail_from||outputs membership available from date. ||Tag Replacements||reg_membership_avail_from||||
|-
| membership_avail_to||outputs membership available to date. ||Tag Replacements||reg_membership_avail_to||||
|-
| staff||if attendee_membership_name contains the word 'staff' this will equal true, this is not case sensitive.||badgecode||||$staff||if retained, maybe this should also check membership_long_name
|}

{| class="wikitable"
|+ panelist
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| bool_has_confirmed_activity||useful for a true false for flagging panelist badges.||new||||||This is highly speculative, however I'm presuming this would work something like AS/DD in that the application would be tied to the UID of the person who applied, so we could pick it up that way, it could go into the attendee group
|-
| bool_activity_host||useful for a true false for flagging panelist badges.||new||||||
|-
| bool_activity_assistant||useful for a true false for flagging panelist badges.||new||||||
|-
| bool_is_true if uid matches to either activity host or assistant - useful for a true false for flagging panelist badges.||new||||||
|-
| activity_schedule||displays a formatted list of activities a panelist is assigned/confirmed to||new||||||
|}

{| class="wikitable"
|+ dealers
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| <num>_application_state||useful for doing a strcmp in badgecode to automatically tag dealers on approved dealers/artists.||new||||||for correctness I want to call this group artshow, but these function will only really be used by dealers den
|-
| bool_<num>_confirmed||useful for a true false for flagging dealer badges.||new||||||these three are listed as options
|-
| bool_<num>_assistant||useful for a true false for flagging dealer assistant badges.||new||||||these three are listed as options
|}

{| class="wikitable"
|+ udf
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| <num>_title||Will display the title of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_title.||Badgecode||||$udf_title||
|-
| <num>_value||Will display the value of the user defined field. (If the customer has it applied to them) Ex: $UDF_12_value.||Badgecode||||$udf_value||
|-
| bool_<num>||Returns True is the UDF has been answered||new||||||
|-
| <num>_type||returns the udf type||new||||||
|-
| <num>_udf_response_list||Will display the UDF questions if relevent||new||||||
|}

{| class="wikitable"
|+ product
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| bool_purchased_<num>||returns true if the customer has purchased the product||new||||||
|-
| bool_incart_||returns true if the customer has the product in their cart||new||||||
|-
| <num>_info||displays product description||new||||||
|-
| <num>_price||displays product price||new||||||
|-
| <num>_items_sold||displays how many have been sold||new||||||
|-
| <num>_items_remaining||displays how many are remaining (cart+purchased-inventory)||new||||||
|}

{| class="wikitable"
|+ product
| align="center" style="background:#f0f0f0;"|'''Substitution'''
| align="center" style="background:#f0f0f0;"|'''Description'''
| align="center" style="background:#f0f0f0;"|'''Source'''
| align="center" style="background:#f0f0f0;"|'''Tag Replacement'''
| align="center" style="background:#f0f0f0;"|'''badgecode'''
| align="center" style="background:#f0f0f0;"|'''Notes'''
|-
| cm_version||displays CM version string||new||||||
|-
| db_version||displays db db version int||new||||||
|-
| license_expiration||displays license expiration date||new||||||
|-
| license_valid_events||displays list of valid events||new||||||
|-
| bool_dev_license||returns true if dev license||new||||||
|}