Importing Students/Prospects to MasterVision

MasterVision can import a text file of students. This file must be a TAB DELIMITED text file with with NO text qualifiers (no quotes around the text). Importing a file does not replace any data already there, it simply adds whatever is found in the file to the existing MasterVision data.

MasterVision can only import student names, addresses, and ranks. It does not import like exam history, attendance history, point of sale or contacts.

It is highly recommended that you make a backup copy of your DATA directory before importing. If something goes wrong with your import, you can then get your data back.

Import File Layout

The import file should have fields in this order:

Last Name

First Name

Address line 1

City

State

ZIP

Phone: Should look like xxx-xxx-xxxx. It can include “(“, “)” and spaces which the import will remove.

Source: Should match a source in MasterVision or be blank.

Status: “A” for active student. If blank, student will be added as a prospect (status “P”)

PIN number: Can be blank

Rank: Should match existing ranks in MasterVision. If the rank is not in MasterVision, student will be given a blank rank.

Birthday – MM/DD/YY

Enroll Date – MM/DD/YY

Sex: M or F. Male/Female will work as well.

Email