Registration Import Wizard

The Registration Import Wizard allows you to import names and register them in courses specified in the import file.

Notes:

  • You must have a Course Code column (or rgcrse if using field names) in your import file.
  • You must specify the exact course code for each record in the import file. E.g. 20SACE010A. Note, your import file does not need the course code if you are importing using the Speed Registration option.
  • The specified course record must exist in your database before you can run the import wizard.
  • You can import any field NAMES, NAMEUDFS, REGISTER, REGUDFS, and WKSHPIND tables.
  • Date Format: use the ShortDate format for dates in your import file. The column width must also be expanded to at least 36.
  • These fields must be set to Text format even if the value is only numbers: colocid, liinstid, all phone number fields, all zip code fields.

You can download a sample registration import file from our website:

https://www.aceware.com/docs/regimport.xlsx

IMPORTANT NOTICE ABOUT DUPLICATE NAME RECORDS

The Import Wizard will only check for duplicate names if your records in the Excel spreadsheet include the Name ID from the person's Name record in Student Manager. If the wizard finds a name record with the specified ID, it will not create a duplicate name record for that person. You can also choose to dedupe by email address (see step 6 below).

To import name records and register in courses:

  1. Select Tools > Import/Export > Registration Import Wizard.
  2. In the Windows Open box, find and select your Excel spreadsheet file.
  3. Select the Student Manager field for the columns in your spreadsheet.
  1. click the drop down and select the field to store the data in:

 

  1. Once the field is selected click the OK button to continue:

Repeat steps a-b for all columns in your spreadsheet.

  1. If your spreadsheet has a Header row, click the Yes button:

  1. The Preview window will display for you to see the records that will be imported. Press Ctrl+Q to continue with the import process. Press ESC to cancel the import.

  1. You can check for duplicates based on email address or name/birthdate -IF- those fields are in your import file.

  1. If you would like to assign a source code to the imported records, click the Yes button on the Would you like to assign these names a Source code? box, enter the source code value (IMPORT is entered by default), then click the OK button:

  1. If you would like to assign an interest code to the imported records, click the Yes button on the Would you like to assign these names an Interest code? box, enter the interest code value (IMPORT is entered by default), then click the OK button:

  1. If you would like to have the system automatically link the record to a firm or create new firm records, click Yes.

  1. The system will then import the records and notify when it's completed:

Related Topics Link IconRelated Topics