• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • e-RegisterNow Main Website

e-RegisterNow Support

1.888.218.1020

You are here: Support » M-Level Topics » Tools

Tools

Waiting List

July 11, 2018 admin Leave a Comment

Print Friendly, PDF & Email

The waiting list lets people sign up for a sold-out event and wait for a seat. They get an email when they join. You email them later, from the Waiting List page, when you are ready to offer a seat.

While seats are still open, people register as usual. The waiting-list icon shows only after the event is sold out.

Open it from Tools > Waiting List, at the bottom of the Tools menu. This page is for cashiers. People on the list do not see it.

 

Enabling the Waiting List

  1. Open the event settings for that event. Edit > Events > [Your Event] + Edit Selected Event > Registration/ Enrolment tab
  2. Set the waiting list to One person per entry or Multiple spots. Use the choice in the next section. Leave it off if you do not want a list.
  3. Save the event.

The icon shows only after the event is sold out and the waiting list is turned on. If seats are still open, someone who opens the sign-up form is not added to the list.

 

 

Which Setting to use

  • One person per entry
    Each person gets their own row. The sign-up form does not ask how many spots they need—each sign-up is for one spot. For example, a parent with three children would sign up three times. The same email address can be used more than once. However, the same first and last name cannot be added to the same event again while that person is still on the waiting list. When a spot becomes available, each person gets their own offer email, usually for one spot.
  • Multiple spots
    One person can ask for several spots, and all of them stay together on one row. They choose how many spots they need when they join the waiting list. When spots become available, the offer is for that number of spots. For example, if they ask for 3 spots, the offer is for 3 spots.
    If Display Editable Event Quantity? (Step 2) is off, they cannot change the number of spots when they register. All 3 spots will be registered under the same name. The person using the offer link can enter any name when registering.
    If Display Editable Event Quantity? (Step 2) is on, they can change the number of spots when they register. They can also split the spots between people using Register Another or Repeat, but only when the Step 1 quantity option is a drop-down or text box. People who requested multiple spots receive one offer for all of their requested spots.

Note: One person per entry is simpler for day camps and events where you collect information for each person.

How it works

SettingSign-up formSame person again
OffShows Sold Out. There is no waiting-list form.
One person per entryShows Email, first name, last name, and phone. No box for the number of spots. Each sign-up is for one spot.The same first and last name cannot join the same event again while they are still on the list. The same email can be used again.
Multiple spotsShows the same fields, plus a box for the number of spots they want. They can ask for up to 50 spots, or up to the highest number of spots that event already offers.The same email cannot join the same event again while they are still on the list.

These two settings only control how someone joins the waiting list. They do not change the number-of-spots box on the registration form, or how Register Another and Repeat work.

The icon people see

When an event is sold out, the Sold Out image is replaced by the waiting-list icon. People click this icon to join the waiting list.
The same icon is used for all events. You do not choose an icon separately for each event.
You can change it under Waiting List Icon on the Step 1 preferences page.

  • Bell or Hourglass — Choose the icon and set its line colour, such as #000000(black) and #FFFFFF(white). The colour setting applies only to these two icons.
  • Black, Red, Blue, or White — These are ready-made images with a fixed colour.
  • Custom Icon — Enter the file name of an image you have already placed in your merchant images folder. The recommended size is about 20 × 30 pixels.

Waiting-list instructions

On the same page, you can change the text people see in two places.

Alternate Waiting List Instructions is the message at the top of the public waiting-list form.
If you leave it blank, the form uses:
This event is currently sold out. Please fill out the form below and you will receive an email if a spot becomes available.

Alternate Waiting List Instructions in email lets you enter separate English and French text for the offer email.

Place %%WAITING_LIST_INSTRUCTION_EMAIL%% where you want this text to appear in the email.

  • A French offer uses the French text when it is filled in.
  • If the French box is empty, the English text is used.
  • If both boxes are empty, no extra instruction is added.

Customize the waiting-list emails

Two emails can be sent:

  1. A confirmation email when someone joins the waiting list.
  2. An offer email when you click Email.

You can use your own HTML files instead of the standard email templates. Place the file in the merchant folder using the correct file name. French emails use the file in the French merchant folder.

EmailEnglish fileFrench file
Confirmation, when they joinM####/waitinglist_confirmation.htmlM####f/waitinglist_confirmation.html
Offer, when you click EmailM####/waitinglist_spotAvailable.htmlM####f/waitinglist_spotAvailable.html

#### is the merchant number.

If the custom file is not there, the standard email is used.

Email subject

To set your own subject, put this on its own line at the top of the HTML file:

%%message_subject=Your subject here%%

This line is removed from the email body and used as the email subject.

Tags in the confirmation email

You can use these tags in your HTML file:

TagWhat it becomes
%%ENAME%%Event name
%%ETIME%%Event dates
%%GIVEN%%First name
%%SURNAME%%Last name
%%EMAIL%%Email address
%%PHONE%%Phone number
%%SPOTSREQUESTED%%Number of spots they asked for
%%MNAME1%%Merchant name

Tags in the offer email

The offer email can use all of the confirmation tags, plus:

TagWhat it becomes
%%SPOTSOFFERED%%Number of spots this offer allows
%%URL%%Registration link
%%MEMAIL%%Merchant contact email
%%WAITING_LIST_INSTRUCTION_EMAIL%%The text from Alternate Waiting List Instructions in email

Tags are not case sensitive.

Waiting List page

Open Tools > Waiting List. This page is for cashiers, so people on the waiting list do not see it. They get a confirmation email when they join the list, and an offer email when you click Email.

The list is grouped by event. Each event has a bar showing the event name, start date, and event code. People who are still waiting for a spot are listed first. Registered and Released entries are shown at the end of the event.

  1. Look for Spot Available when there are enough seats for the person’s full request. You may also see Waiting with a note such as “8 open” when some seats are available, but there are not enough for their full request.
  2. Click Email to send the registration offer. This starts a 48-hour hold on the seats.
  3. If they do not register within 48 hours, the status changes to Expired. The seats stay held until you send a new offer with Email or click Release.
  4. Use the filters when you want to see a specific event, status, or person. Click Reset Filter to show the full list again.

When you open the page, offers that are more than 48 hours old are automatically marked Expired. This does not change their place in the queue.

Statuses

Click a colour in the legend to show only that status. Click it again to clear the filter.

StatusMeaningWhat you can do
WaitingThey are on the list, but no offer has been sent yet.Change Order, Delete, or Email if enough seats are available.
Spot AvailableEnough seats are available for them, and they are next in line. The status stays Waiting until you send the offer.Email (starts the 48-hour hold), Change Order, Delete
SentThe offer has been emailed. The date and time shown under the status is when the 48-hour hold started. Even if they move to the end of the queue, the same seats stay held for them.Resend (same deadline), Change Order
ExpiredThey did not register within 48 hours. They move to the end of the queue, but the same seats are still held for them.Email (starts a new 48-hour hold), Release, Change Order, Delete
FailedThe offer email could not be sent. The seats are still being held.Email to try again, Release, Change Order, Delete
ReleasedThe seats are no longer being held for them. They stay on the waiting list, but without an order number, at the end of the list for that event.Delete only.
RegisteredThey completed registration through the offer link. They stay on the waiting list at the end of the list for that event.Delete only.

Hide Registered and Hide Released are turned on by default, so these rows are usually hidden. Your choice is remembered. If you filter the legend or Status list to Registered or Released, the corresponding Hide checkbox is turned off so you can see those rows.

Buttons on the page

ControlWhat it does
Event / Start dateShows the events that match your selection. They appear above the table.
Column filtersType in a column heading to narrow the list by status, spots, name, date added, email, or phone.
Hide Registered / Hide ReleasedHides those rows from the list. It does not delete them.
Reset FilterClears the search and status filters. Your Hide settings stay the same.
OrderShows the person’s place in the queue. Type a new number and click outside the box to save it.
RenumberKeeps the current order and changes the queue numbers to 5, 10, 15, and so on.
DeleteDeletes the people you selected. You must confirm before they are deleted. Sent entries cannot be selected.
Check allSelects everyone you can delete from the list you are currently viewing.
CleanupDeletes waiting-list records for disabled events and for enabled events that ended more than one month ago. This cannot be undone.

The number shown next to the buttons tells you how many people match the current filter. If nobody matches, the page says “No people match this filter.”

A new person is added to the end of that event’s queue, after everyone who is still waiting. Registered and Released entries do not have a queue number.

Columns that matter

ColumnWhat it shows
Spot RequestedHow many spots they asked for when they joined the list. This number does not change if they register some of the spots.
Spot OfferedHow many spots they can register using the current offer.
RegisteredHow many spots they have registered so far.

Email, Resend, and Release

The link in the offer email opens registration for that event. They have 48 hours to register, and they cannot register more spots than they were offered.

Waiting or Spot Available

Email sends the offer and starts the 48-hour hold.

  • If enough seats are available for their full request, they are offered all the spots they still need.
  • If only some of the requested seats are available, you will see a message such as “8 open.” You will be asked to confirm before sending a partial offer.

People further down the list wait until this person’s offer is finished, released, or no longer needed.

Sent

Resend sends the same offer again. The 48-hour deadline does not restart.

If more seats become available while the offer is still active, those seats stay available for this person. You can send a new offer after the current offer expires.

Expired

The offer was not used within 48 hours. The seats are still being held, even though the person has moved to the end of the queue.

  • Email sends a new offer for the seats currently available and starts a new 48-hour hold.
  • Release stops holding the seats. The next person in line can then be offered those seats. If nobody is waiting, the seats become available to the public.

Failed

The offer email could not be sent.

  • Email tries to send it again.
  • Release stops holding the seats.

When they register

  • If they register all the spots they originally requested, their status becomes Registered.
  • If they register the full offer but still need more spots—for example, they requested 13 and register 8—they go back to Waiting for the remaining 5 spots.
  • If they register only some of the spots in the current offer, they stay Sent. Spot Offered goes down by the number of spots they just registered.

With Multiple spots, one offer can include several spots. The number in the offer is the number of spots they can register.

If Display Editable Event Quantity? (Step 2) is off, they cannot change that number when they register. For example, an offer for 3 spots means all 3 spots are registered under the same name.

If Display Editable Event Quantity? (Step 2) is on, they can change the number of spots. They can also use Register Another or Repeat to split the spots between people when the Step 1 quantity option allows it.

With One person per entry, each person has their own offer link, usually for one spot.

Filed Under: Events, How to ..., Tools, Tools Tagged With: customizing waiting list, enabling waiting list, waiting list

Event Exporter

October 12, 2017 Yoko Leave a Comment


Print Friendly, PDF & Email

Event Exporter allows the clients to download all the data of existing events as a tab-delimited file.

  • Select from the menu bar, Tools | Import/Export | Import/Export Events. Select the option from Export Option and click on Start Export.

Commonly Used Fields
Commonly Used Fields are the fields that are used for simple events. For instance, to obtain the fields for “Group Discount”, “All Fields” is the option to select. The fields are listed below.

Fieldname Description Type size Answer Defaut Value
ENAME Event Name text 255 NULL
EDISPLAYNAME Matrix Display Name text if null, Event Name will be stored NULL
ESTARTDATE Event Start Date & Time date 8 YYYYMMDD (20171225) current date&time
EENDDATE Event End Date & Time date 8 YYYYMMDD (20171225) current date&time
ESTARTTIME Event Start Time datetime 19 YYYYMMDD HH:MM:SS (2012-01-11 15:50:00) current date&time
EENDTIME Event End Time datetime 19 YYYYMMDD HH:MM:SS (2012-01-11 15:50:00) current date&time
EORDER Event Order number 8 e.g. 10 10
EENABLED Event Enabled text YES/NO YES
IS_LABEL Is this a Label? text Y(Yes)/N(No) N
ELOCATION Event Location text 255 NULL
EINSTRUCTOR Event Instructor text 255 NULL
ECODE Event Code text 35 NULL
ECATEGORIES Event Category text 255 NULL
EUSERFIELD1 Message 1 text 0 NULL
EUSERFIELD2 Message 2 text 0 NULL
EUSERFIELD3 Message 3 textarea 255 NULL
EREGISTRATION_FROMDATE Registration Period Starting Date date 8 YYYYMMDD (20171225) current date
EREGISTRATION_TODATE Registration Period Ending Date date 8 YYYYMMDD (20171225) current date
AID Registration Form text Registration Form ID (Use ID Lookup on the event importer) NULL
EENROLUNITS Enrolment Units text REGISTRATION(Registrations)
REGISTRANT(Registrants)
RREF(Ref#)
REGISTRATION
EMAXENROL Max Enrolment number 8 e.g. 100 9999
E_CAD_PRICE/E_USD_PRICE CAD/USD Price money 10 e.g. 150.00 0.00
E_GL_CR_ACCOUNT GL Account Number text 35 NULL
ETAXID1 TAX1 text Tax ID (Use ID Lookup on the event importer) NULL
EEMAILFORM_TO_REGISTRANT_ENABLED Send registrant standard confirmation e-mail upon registration? text YES/NO NO
EEMAILFILE_TO_REGISTRANT_ENABLED Send registrant custom confirmation e-mail upon registration? text YES/NO NO
EEMAILFILE_TO_REGISTRANT_FILENAME Custom E-mail Text Message Filename text 95 NULL
EFILEATTACHMENT Custom E-mail File Attachment Filename text 95 NULL
EVIEWED_BY Event Visible on Step 1 For: text ALL/CASHIERS ONLY ALL
EPROMO_CODES Promotion Code(s): text 0 NULL
ESTEP1SELECTOR Step1 Selector text CHECKBOX (Checkbox)
RADIO (Radio)
SLCT (Drop-down Quantity)
TXT (Text Quantity)
NONE (None)
CHECKBOX
EPAGE1_MATRIX_ENABLED Display Event on Step 1 Event Matrix? text ON(Yes)/OFF(No) OFF
EMATRIX_COLUMN_HEADING Matrix Column Heading text 200 NULL
EMATRIX_COLUMN_ORDER Matrix Column Order (e.g. 1) number 10 e.g. 10 NULL
ETHANKS_ENABLED Display ‘Thanks’ Page instead of Payment Pages? text YES/NO NO
ERECALL_ENABLED Enable Step 2 Home Phone ‘Recall’?< text YES/NO YES
ERECALC_ENABLED Display the ‘Recalculate’ button? (Step 2) text YES/NO Y
EREGISTER_ANOTHER_ENABLED Display the ‘Register Another’ button? text YES/NO YES

Filed Under: Import\Export

Virtual Terminal

September 21, 2017 Yoko Leave a Comment


Print Friendly, PDF & Email

Virtual Terminal let you process a one-time payment, recurring payment, planned payment.
Payments can be made toward an existing registrant or a new person. You can also enroll a person into an event. (Note: no e-ticket will be issued.)

  • Monthly Recurring Payment: This creates a monthly credit card payment. Once this is submitted, the future payment will appear in Tasks > Deferred Payment. When the time comes, the user needs to process the payment there. To stop the recurring payment, the record in the Deferred Payment Page needs to be deleted after the last payment.
  • Payment Plan: This will create a planned (scheduled) payment. When you select this type in frequency, the payment plan editor (see below) will appear.
    1. Enter the Total Amount, Deposit Amount and Number of Payments (the orange box)
    2. Click on the ‘Show Plan’ button
    3. According to what you’ve entered, the payment plan will get calculated and be displayed on the left side (the green box).
    4. Date and each amount can be adjustable. (* the total of each amount + deposit must be the same as the Total Amount that is specified at #1)

    The deposit amount will be processed on the submission. The planned payment will appear in the Tasks > Deferred Payment. When the time comes, the user needs to process the payment there.

  • Make a payment towards existing Pending/Deferred Payments: If a registrant owe some payments, by typing the reference #, what the registrant owes will be listed in the Amount Section (See the image below). Enter each payment (partially/fully) to process. At least one slot needs to be entered.
  • Make a payment with event: To enroll a person into an event, select an event from the event drop down which lists all the available events (See the image below).
    *Note: If the registrant is already in that event, it will just add the payment to the event.

Filed Under: Virtual Terminal

Event Importer

September 12, 2017 Yoko Leave a Comment


Print Friendly, PDF & Email

Procedure:

Event Importer allows the client to upload any number of relevant data into the e-RegisterNow database. Use the procedure outlined below.
Procedure:

  1. Create an Excel spreadsheet containing the new database entries. Each column needs a unique heading – use the event fieldnames, listed at the end. The default value will be stored for the fields that are not listed in the spreadsheet. Some fields need to be in the correct format; also shown below. Use ID for Registration Form and Tax (ID can be looked up in the Import/Export Events page).
  2. Save the spreadsheet in the Text (Tab Delimited) format.
  3. Use File Upload, to bring the text file into the M root directory.
  4. Select from the menu bar, Tools | Import/Export | Import/Export Events. Type the file name that you’ve just uploaded into the textbox. Use the eye icon to view the file. Finally, click on Start Import

The data should now be imported as events. If there are any errors make sure the spreadsheet is properly setup and saved as a tab delimited text file. Listed below are the event fieldnames and formats.

SAMPLE: Excel | Tab-delimited text file

Event Fieldnames

* Required field
Fieldname Description Type size Answer Defaut Value
ENAME* Event Name text 255 NULL
EENABLED Event Enabled text YES/NO YES
AID* Registration Form text Registration Form ID (Use ID Lookup on the event importer) NULL
E_CAD_PRICE* CAD Price money 10 e.g. 150.00 0.00
EPRICEDESC Additional Cost Description (Steps 2-4) text 255 NULL
EMAXENROL* Max Enrolment number 8 e.g. 100 9999
ELINK_GROUP_MAX_ENROL Group Max. Enrolment number 8 e.g. 100 NULL
ECATEGORIES Event Category text 255 NULL
ETHANKS_ENABLED Display ‘Thanks’ Page instead of Payment Pages? text YES/NO NO
ERETURNURL Direct Step 2 Return URL (English) text 255 NULL
ETERM Term or Period text 50 e.g. Fall 2004 NULL
EDISPLAYNAME* Matrix Display Name text if null, Event Name will be stored NULL
ECLASSIFICATION Classification text 255 NULL
ESUBCLASS Sub-Classification text 255 NULL
E_RETURNURL_FRENCH Direct Step 2 Return URL (French) text 150 NULL
E_CAD_EARLYDISCOUNT ? 20 NULL
EDISCOUNTDATE Deadline for Early Registration date 8 YYYYMMDD (20171225) Current Date
EDISCOUNTTYPE ? 1 NULL
EPRICETYPE ? 1 NULL
ECOUNTOFFSET Starting Enrolment (e.g. Reserved places) number 8 e.g. 0 0
ECOUNTSWITCH Display Event’s Accelerator Number? text YES/NO NO
EORDER* Event Order number 8 e.g. 10 10
ESTARTDATE* Event Start Date & Time date 8 YYYYMMDD (20171225) current date&time
EENDDATE* Event End Date & Time date 8 YYYYMMDD (20171225) current date&time
E_DISPLAY_QTY_ON_STEP2_PAGE Display Editable Event Quantity? text Y(Yes)/N(No) N
MAILFLAGDEFAULT Default Snail Mail Preference in C-Level? text HOME(Home Address)
BUSINESS(Business Address)
WHERETOMAIL(where_to_mail fieldname decides)
OFF(Off)
HOME
EMAIL_PRICECHANGE_TYPE ? 15 NULL
EMAIL_PRICECHANGE ? 15 NULL
ECREDITCARD_PRICECHANGE_TYPE ? 15 NULL
ECREDITCARD_PRICECHANGE ? 15 NULL
ERECALL_ENABLED Enable Step 2 Home Phone ‘Recall’?< text YES/NO YES
EREGISTER_ANOTHER_ENABLED Display the ‘Register Another’ button? text YES/NO YES
EPAGE1_MATRIX_ENABLED* Display Event on Step 1 Event Matrix? text ON(Yes)/OFF(No) OFF
EPAGE1_MATRIX_ORIENTATION ? text 10 COLUMNS
EPASSWORD Event Password(s) text 60 NULL
EEMAILFORM_TO_REGISTRANT_ENABLED Send registrant standard confirmation e-mail upon registration? text YES/NO NO
EEMAILFILE_TO_REGISTRANT_ENABLED Send registrant custom confirmation e-mail upon registration? text YES/NO NO
EEMAILFILE_TO_REGISTRANT_FILENAME Custom E-mail Text Message Filename text 95 NULL
EEXCLUSIVE_EVENT ? text 3 NO
EURL URL for Matrix Display Name Link text 255 NULL
EFILEATTACHMENT Custom E-mail File Attachment Filename text 95 NULL
EBALANCEOWINGDATE Balance Payment Due date 8 YYYYMMDD (20171225) current date
EREGISTRATION_FROMDATE* Registration Period Starting Date date 8 YYYYMMDD (20171225) current date
EREGISTRATION_TODATE* Registration Period Ending Date date 8 YYYYMMDD (20171225) current date
ENAME_PREFIX Event Name – Prefix (Steps 2-4) text 50 NULL
ENAME_SUFFIX Event Name – Suffix (Steps 2-4) text 50 NULL
E_USD_DEPOSIT Event Deposit Amount (USD) money 10 e.g. 150.00 NULL
E_USD_PRICE Event Cost (USD) money 10 e.g. 150.00 NULL
E_USD_EARLYDISCOUNT NULL
E_CAD_DEPOSIT Event Deposit Amount (CAD) money 10 e.g. 150.00 NULL
E_GL_CR_ACCOUNT GL Account Number text 35 NULL
E_COUPON_FOR_2 Coupon for the discount for 2 people text Coupon ID NULL
E_COUPON_2_CONDITION Registrant/Family for the discount for 2 people text any(registrants)
samefamily(family members)
any
E_COUPON_FOR_3 Coupon for the discount for 3 people text Coupon ID NULL
E_COUPON_3_CONDITION Registrant/Family for the discount for 3 people text any(registrants)
samefamily(family members)
any
E_COUPON_FOR_N Coupon for the discount for N people text Coupon ID NULL
E_N Set a number for the discount for N people text 2 NULL
E_COUPON_N_CONDITION Discount type for E_N text 12 any(registrants)
samefamily(family members)
any
E_COUPON_NUMREG1 Coupon for Registrant 1 text Coupon ID NULL
E_COUPON_NUMREG2 Coupon for Registrant 2 text Coupon ID NULL
E_COUPON_NUMREG3 Coupon for Registrant 3 text Coupon ID NULL
E_COUPON_NUMREG4 Coupon for Registrant 4 text Coupon ID NULL
E_COUPON_NUMREG5 Coupon for Registrant 5 text Coupon ID NULL
E_COUPON_NUMREG6 Coupon for Registrant 6 text Coupon ID NULL
E_COUPON_NUMREG7 Coupon for Registrant 7 text Coupon ID NULL
E_COUPON_NUMREG8 Coupon for Registrant 8 text Coupon ID NULL
E_COUPON_NUMREG9 Coupon for Registrant 9 and over text Coupon ID NULL
E_DISPLAY_REGULAR_PRICING Display Regular Pricing Details? (Review Page text YES/NO NO
E_DISPLAY_GROUP_BOX Display Coupon Code Box? (Step 2) text YES/NO/VAL(for Authentication) NO
E_DISPLAY_COST_ON_STEP2_PAGE Display Event Cost? (Step 2) text YES/NO YES
E_GL_DB_ACCOUNT ? 35 NULL
EGROUP1 Event Group Name 1 text 20 NULL
EGROUP2 Event Group Name 2 text 20 NULL
EGROUP3 Event Group Name 3 text 20 NULL
EGROUP4 Event Group Name 4 text 20 NULL
EGROUP5 Event Group Name 5 text 20 NULL
EGROUP1COUPON Applicable Coupon 1 text Coupon ID NULL
EGROUP2COUPON Applicable Coupon 2 text Coupon ID NULL
EGROUP3COUPON Applicable Coupon 3 text Coupon ID NULL
EGROUP4COUPON Applicable Coupon 4 text Coupon ID NULL
EGROUP5COUPON Applicable Coupon 5 text Coupon ID NULL
ECOLLECTION1 Event Collection Name 1 text 20 NULL
ECOLLECTION2 Event Collection Name 2 text 20 NULL
ECOLLECTION3 Event Collection Name 3 text 20 NULL
ECOLLECTION4 Event Collection Name 4 text 20 NULL
ECOLLECTION5 Event Collection Name 5 text 20 NULL
ECOLLECTION6 Event Collection Name 6 text 20 NULL
ECOLLECTION7 Event Collection Name 7 text 20 NULL
ECOLLECTION8 Event Collection Name 8 text 20 NULL
ECOLLECTION9 Event Collection Name 9 text 20 NULL
ECOLLECTION10 Event Collection Name 10 text 20 NULL
ECOLLECTION11 Event Collection Name 11 text 20 NULL
ECOLLECTION12 Event Collection Name 12 text 20 NULL
ECOLLECTIONCOUPON1 Full Collection Coupon 1 text Coupon ID NULL
ECOLLECTIONCOUPON2 Full Collection Coupon 2 text Coupon ID NULL
ECOLLECTIONCOUPON3 Full Collection Coupon 3 text Coupon ID NULL
ECOLLECTIONCOUPON4 Full Collection Coupon 4 text Coupon ID NULL
ECOLLECTIONCOUPON5 Full Collection Coupon 5 text Coupon ID NULL
ECOLLECTIONCOUPON6 Full Collection Coupon 6 text Coupon ID NULL
ECOLLECTIONCOUPON7 Full Collection Coupon 7 text Coupon ID NULL
ECOLLECTIONCOUPON8 Full Collection Coupon 8 text Coupon ID NULL
ECOLLECTIONCOUPON9 Full Collection Coupon 9 text Coupon ID NULL
ECOLLECTIONCOUPON10 Full Collection Coupon 10 text Coupon ID NULL
ECOLLECTIONCOUPON11 Full Collection Coupon 11 text Coupon ID NULL
ECOLLECTIONCOUPON12 Full Collection Coupon 12 text Coupon ID NULL
EMATRIX_COLUMN_HEADING Matrix Column Heading text 200 NULL
ETAXID1 TAX1 text Tax ID (Use ID Lookup on the event importer) NULL
ETAXID2 TAX2 text Tax ID (Use ID Lookup on the event importer) NULL
ETAXID3 TAX3 text Tax ID (Use ID Lookup on the event importer) NULL
ETAXID4 TAX4 text Tax ID (Use ID Lookup on the event importer) NULL
ETAXID5 TAX5 text Tax ID (Use ID Lookup on the event importer) NULL
ECODE Event Code text 35 NULL
EVIEWED_BY Event Visible on Step 1 For: text ALL/CASHIERS ONLY ALL
ESTARTTIME* Event Start Time datetime 19 YYYYMMDD HH:MM:SS (2012-01-11 15:50:00) current date&time
EENDTIME* Event End Time datetime 19 YYYYMMDD HH:MM:SS (2012-01-11 15:50:00) current date&time
ELOCATION Event Location text 255 NULL
EINSTRUCTOR Event Instructor text 255 NULL
EBLURBFILE e-Ticket ‘Blurb’ Filename text 255 NULL
DEALID Package Deal Identifier text 10 0
ENABLE_RESERVED_SEATING Enable Reserved Seating text YES/NO NULL
EDISPLAY_DATES_ENABLED Display Date with Event Name? (Step2/Review/Step4) text YES/NO YES
EMATRIX_COLUMN_COLOUR Matrix Column Colour (e.g. #DEDEDE) text 7 NULL
EMATRIX_COLUMN_ORDER Matrix Column Order (e.g. 1) number 10 e.g. 10 NULL
EBADGENAME Event Badge Name textarea 0 NULL
EQTY_FIELDNAME uantity Variable’s Fieldname in Registration Form<br><dd>(e.g. ADULT_COUNT) NULL
EQTY_DESC Quantity Variable’s Description<br><dd> e.g. ADULT NULL
ELONGDESC Event’s Long Description  (note: single quotes are not permitted) text unlimited NULL
EREPEAT_ENABLED Display the ‘Repeat’ button?< text YES/NO YES
EINCLUDE_STEP4_BARCODES Barcode Text: Include on Step4? text YES/NO YES
EUSERFIELD1 Message 1 text 0 NULL
EUSERFIELD2 Message 2 text 0 NULL
EUSERFIELD3 Message 3 textarea 255 NULL
EENROLUNITS Enrolment Units text REGISTRATION(Registrations)
REGISTRANT(Registrants)
RREF(Ref#)
REGISTRATION
EDROP_CONDITION Drop Event Condition text 255 e.g. donate_amount <= 0.00 NULL
RS_ID Resource Package Identifier NULL
ME_ID Membership Type text Membership ID 0
ESTEP1SELECTOR Step1 Selector text CHECKBOX (Checkbox)
RADIO (Radio)
SLCT (Drop-down Quantity)
TXT (Text Quantity)
NONE (None)
CHECKBOX
ERADIOGRPNAME Radio/Checkbox Group Name text 20 NULL
ERADIOCOMPULSORY Radio/Checkbox Compulsory text OPTIONAL/COMPULSORY OPTIONAL
ELINK_GROUP_NAME Linked Event Group Name text 50 NULL
EPROMO_CODES Promotion Code(s): text 0 NULL
ERECALC_ENABLED Display the ‘Recalculate’ button? (Step 2) text YES/NO Y
TOP_NOTES_BOX TOP (Selection from Preferences) text 0-10 0
BOTTOM_NOTES_BOX MIDDLE (Selection from Preferences) text 0-10 0
EPAYFREQ Payment Frequency text ONE-TIME
MONTHLY
30D_FREETHEN_MONTHLY
PRORATE
PRORATE_DAILY
PRORATE_MONTHLY
PRORATE_QUARTERLY
PREPAID_MONTHLY
PREPAID_ANNUALLY
ONE-TIME
EPORTAL_EMAIL_CHECK Guarantee only one email address per ACTIVE portal account. text YES/NO NO
CLIENT_ID Associated with which C-Level text C-level Client ID
IS_MOBILE Mobile Event? number 1(Yes),0(No) 0
IS_LABEL* Is this a Label? text Y(Yes)/N(No) N
EEMAILS_ASKED_TWICE Ask the [Emailbox] question twice? text YES/NO NO
EACCEPT_ONLY_UNIQUE_EMAILS Guarantee that people have unique emails for this event? text YES/NO NO
ES1S_SELECT_TYPE 55 RANGE NULL
ESECTION Seat Section text 10 NULL
PAGE_BOTTOM_NOTES_BOX BOTTOM (Selection from Preferences) text 0-10 0
promo_from_SQL ? 0
EBOXNAME Box Office Button Name text 90 NULL
ENOTE_TOP TOP (Show this box) text NULL
ENOTE_BOTTOM MIDDLE (Show this box) text NULL
ENOTE_PAGE_BOTTOM BOTTOM (Show this box) text NULL
E_ICALENDAR Display ‘Add to your calendar’ icons? text NO
OP1(YES at Event Date and Time)
OP2(YES as all-day event)
NO
E_CCEMAILS Carbon Copy E-Mail To text 255 NULL
ESHOWEVENTDATE Display Event Date under the Selector? text NO
STARTDATE(Start Date Only)
ENDDATE(End Date Only)
BOTH(Start Date & End Date)
NO
ESHOWEVENTDATE_FORMAT Event Date Format text 2(mmm d (Mar 5)
10(mmmm d (March 5)
11(mmm d, yyyy (Mar 5, 2014))
9 (mmmm d, yyyy (March 5, 2014))
12 (d mmm (5 Mar))
13 (d mmmm (5 March))
14 (d mmm, yyyy (5 Mar, 2014)
15 (d mmmm, yyyy (5 March, 2014))
16 (mmmm yyyy (March 2014))
NULL
EMAXENROL_PER_TRANSACTION Maximum Enrolment per Transaction Number 8 e.g. 1 99999
EMINENROL_PER_TRANSACTION ? Number 8 NULL
EECARD_ENABLED Enable e-Card Feature text N(No)/Y(Yes) N
EECARD_COPYTOSENDER Send a Copy to Sender text N(No)/Y(Yes) NULL
EECARD_FILENAME e-Card Template Filename text 95 NULL
EECARD_ATTACHMENT e-Card Attachment text 95 NULL
EDEFAULT_REFUND Refund Amount money 10 e.g. 150.00 NULL

&nbsp

Filed Under: Import\Export

Import Registrants

June 15, 2016 Sebastian Leave a Comment

import_data

Print Friendly, PDF & Email

Procedure:

Import Registrants allows the client to upload any number of relevant data into the e-RegisterNow database. An event and a registration form will have to be set up for the import to be used correctly. Use the procedure outlined below. Click here for additional screenshots.
Procedure:

  1. Create an Excel spreadsheet containing the new database entries. Each column needs a unique heading – these will become fieldnames during the import. Use the standard fieldnames, listed at the end, when appropriate. Dates, telephone numbers, etc. need to be in the correct format; also shown below. Finally, save the spreadsheet in the Text (Tab Delimited) format.
  2. The spreadsheet headings need to be added to a registration form. The standard fieldnames must be selected on the form, the rest will be added as custom questions:
    a. Create a new registration form. For each standard fieldname, enable the corresponding standard question.Import Data
    b. Add a custom question for each non-standard fieldname, using an appropriate question type. For example here is a custom, “date added” field:
  3. Create an event using the registration form created above. Other event options don’t need to be changed. This allows the data to be imported as registrants.
  4. The M is now ready for the import. Use File Upload, to bring the text file spreadsheet into the M.  Next, select from the menu bar, Tools | Import | Import Registrants. Type the text file name into the textbox and make sure the event from part 3 is selected. Finally, click on Import Data

The data should now be imported as registrants. If there are any errors make sure the spreadsheet is properly setup and saved as a tab delimited text file. Listed below are the standard fieldnames and formats.

Standard Field Names

Fieldname Description
RGIVEN First name
RSURNAME Surname
RMIDDLE Middle name
RTITLE Mr., Ms., Dr., etc.
RCITY City
RPROV Province
RCOUNTRY Country
RPOSTAL Postal Code
RCOMPANY Company Name
RJOBTITLE Company Job Title
RCOMMENTS Comments/Notes
RSTATUS
REMAIL Email address
RHAREAPHONE Home Phone area code
RHPHONE Home Phone number
RHPHONEEXT Home Phone extension
RFAREAPHONE Fax area code
RFPHONE Fax number
RCAREAPHONE Cell phone area code
RCPHONE Cell phone number
RBADDRESS1 Business Address
RBADDRESS2 Business Address2, eg. Suite number
RBCITY Business’ city
RBPROV Business’ province
RBCOUNTRY Business’ country
RBPOSTAL Business’ postal code
RDATECREATED Date added to database

Standard Formats

Telephone Number 123-456-7890 x 111 (ext. must be same cell as number)
Date yyyymmdd
Phone # clean 1 column (613-(665-3333)ext2

Do not include area code

Filed Under: Import\Export Tagged With: Import Data

e-Ticket Resender

June 15, 2016 Sebastian Leave a Comment


Print Friendly, PDF & Email

email_resenderThe email re-sender allows the client to set up an autonomous website that allows registrants to resend their e-tickets to themselves. This feature is useful when the registrant never got the original email or has lost/deleted the email with the e-tickets. The M number using this feature must process credit card payments and capture the postal/zip code of the registrant. To use this page, create a new template file (easier to just take the step 2 template file) and add the variable “%%E-RESEND_DEFAULT%%” to it, then upload the file and link it under preferences > template files > email re-sender. Then take the link below and replace xxxx with your M number, (for example 2088).

https://secure.e-registernow.com/cgi-bin/accept.dll?state=e-resend&MID=xxxx

Place this link on your home website with a button labeled “lost tickets?” or something similar and people will be able to find their missing e-tickets.

Filed Under: Email Resender Tagged With: e-ticket, e-ticket resender, resender

View Batch History

June 14, 2016 Sebastian Leave a Comment


Print Friendly, PDF & Email

view_batch_historyThe View Batch History allows the user to see individual batches that have been processed. By clicking “Done” under Status, the user can see the individual transactions that occurred within the batch checking if each one was authorized. If the transaction failed, it will list an error with the reason why.

Filed Under: View Batch History Tagged With: Batch, Batch History, Batches

File Upload

April 7, 2016 admin Leave a Comment


Print Friendly, PDF & Email
  1. Go to Tools > File Upload
  2. The following screen will appear:Note: If the window does not appear, make sure you have pop-ups enabled.
  3. Click on “Browse” and select a file to upload.
  4. If the file should be uploaded to a sub-directory (e.g. “images”), enter it in the appropriate field.
  5. Click on “Upload File”

Filed Under: Tools Tagged With: Upload

Batch File Format

April 7, 2016 admin Leave a Comment


Print Friendly, PDF & Email

File Format For Credit Card Transaction Submission

Expiry Date Amount Card Number Cardholder’s Name Company Name (Optional)
mmyy 0.00 dddd dddd dddd dddd Jimmy Breer Interware.Net Inc.

 

  • Each line of the file should appear as follows as shown in the example.
  • Each column is separated by tabs.
  • An unlimited number of lines/transactions are allowed.
  • The batch file must be in .txt format.
  • The fifth column can be omitted

Example of the Batch File format: (tab delimited)

1209    10.00    4500 5400 2300 1200    John Doe       Interware.Net Inc.
1115    15.00    5500 5400 4400 1265    Peter Jones    ABC company

Notes about Excel

If the card information is stored in excel,

  1. Ensure the batch file is in the correct format:
    • the first column contains the expiry month and year,
    • the second column contains the amount to be charged (no negative amounts are allowed)
    • the third column contains the credit card number (must be 15 or 16 digits long)
    • the fourth column contains the card holder’s name
    • the fifth column contains the card holder’s company. (optional column)
  2. Save the excel sheet to a new file of type *.txt, e.g. c:\cards.txt (Save as…, Text (Tab delimited) (*.txt)

Filed Under: Batch Processor Tagged With: Batch, File Formatting

Submit a Batch

April 7, 2016 admin Leave a Comment


Print Friendly, PDF & Email

Starting the Batch Run

  1. In the M-account, Go to Tools > Batch Processor > Submit a Batch
  2. Enter the following settings:
    Batch Name Assign the batch a name, e.g. July 2008 Run
    Batch File Click on ‘Browse’ and select the .txt file containing the credit cards, e.g. c:\cards.txt
    Currency Type Select a currency
    GL Number Optionally assign a GL number.
  3. Click on  The batch pre-processor will look for any errors before running the batch. If some errors are detected, edit the c:\cards.txt file and fix all of the errors. If no errors are detected, the batch will begin to process. The process is actually occurring the in the background. If you like, you can go on to other work and return later to see the results of the batch.
  4. The following screen will appear
  5. click on the Refresh button to check the batch progress.
  6. When the Status is displayed as ‘Done’, click on the ‘Done’ hyperlink to view the Batch History. The following screen will appear:

Filed Under: Batch Processor Tagged With: Batch

Primary Sidebar

© Copyright 2016 · e-registernow.com · All Rights Reserved · Admin

Loading Comments...