• 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

Use the Waiting List feature

July 11, 2018 admin Leave a Comment

Print Friendly, PDF & Email

Waiting List allows your registrants to sign up and be placed onto a waiting list for a sold out event or program, in order to be notified when an event’s availability changes.

*Waiting List can be found under “Tools” at the bottom of the drop down menu.

Enabling the Waiting List.

To enable the waiting list for your event can be found under; Edit > Events > [Your Event] + Edit Selected Event > Registration/ Enrolment tab > Enable Waiting List.

Customization.

When an event is ‘Sold Out‘ now instead of the Sold Out icon showing, a icon will now be displayed. For your convenience a different color icon can be selected or your own custom made icon can be uploaded and used.

Data Fields.

Waiting List provides you with a detailed table of all your waiting registrants information. Each report column is as follows:

  1. Waiting for Event – name of event registrant is waiting for (events are grouped together, so all registrants waiting for one event will be under one another).
  2. Order – place in queue for each registrant in the event they are waiting for, decreasing or increasing this number moves the registrant up or down the list.
  3. Event Start Date – when the event will begin.
  4. Waiting From – the date the registrant signed up for the waiting list.
  5. Name – full name of registrant.
  6. Email – registrants contact email.
  7. Phone Number – registrants contact phone number.
  8. Spots Needed – the number of spots requested by the registrant.
  9. Status – lists the status of each registrant on the waiting list.
  10. Delete – remove a registrant from the waiting list.
  11. Email (Button) – manually send an email, this will override all other statuses and can be used to give an expired registrant another change, override the queue order or even send out multiple emails to see who registers first (NOT advised).

Waiting List Status.

  • Waiting – the registrant has successfully signed up for the given event and is waiting for a spot to become available.
  • Spot Available – a spot has opened up for the given event and the system is waiting for cashier input to send out a notification email.
  • Sent – an email has been sent, either automatically or manually by a cashier to the registrant. The registrant will have 48 hours to successfully register.
  • Registered – the registrant has successfully secured their spot for the given event.
  • Expired – the registrant’s registration period has expired (48 hours have passed since the email was sent out) and the spot has now been given to the next person in line.

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...